BaseNow - Database Front-End Software
*
Home Buy Download Details Support
BaseNow Forums 
Home
Login Register Member List
  » BaseNow Forums   » Chat   » BASENOW AND FOXPRO DATE FORMAT...  

Welcome Guest ( Login or Register )


BASENOW AND FOXPRO DATE FORMATS
Author
Message
Posted 1/12/2007 10:05 PM
Forum Member
Forum Newbie

Group: Forum Members
Active: 2/5/2007
Posts: 2
I have been trying for several hours to figure out what basenow does with the date when I put it in a sql query. When I type:
select *
From rmbil
where ((date >= '01/01/2007')) it changes it to:
SELECT
*
FROM
rmbil
WHERE
((date >= { d '{01-01-2007}' }))
then complains that the "function name is mussing ).".

How does one enter a date in BASENOW? Can anyone help? Thanks.
IP Logged
This member is offline.
Posted 2/3/2007 11:41 PM
Forum Administrator
Forum Administrator

Group: Advanced Members
Active: 3/7/2010
Posts: 64
Try to change the SQL syntax in the Query Builder by selecting a different option from the "Action/SQL Syntax" menu.
IP Logged
This member is offline.
Posted 2/5/2007 9:34 AM
Forum Member
Forum Newbie

Group: Forum Members
Active: 2/5/2007
Posts: 2
Thanks for your response.

I have tried all of those options and the problem remains, even before posting this. I think its the interface thats the problem as it attempts to create syntax from mouse click selections. It is also modifying standard sql instructions instead of passing them to the DBMS as entered.
IP Logged
This member is offline.
Posted 2/7/2007 11:59 PM
Forum Administrator
Forum Administrator

Group: Advanced Members
Active: 3/7/2010
Posts: 64
Thank you for you feedback. I will investigate this further and try to reproduce the problem on my machine.
IP Logged
This member is offline.
Showing page 1 of 1 - 4 messages found
« Next Oldest

Powered by InstantForum.NET v3.4
Copyright © 2002, 2004, InstantASP Ltd. All rights reserved.