BaseNow Forums

Home

Member List

Subscribe to all forums

» BaseNow Forums

» Chat

» BASENOW AND FOXPRO DATE FORMAT...

Welcome Guest ( Login or Register )

Active Topics |

Popular Topics

BASENOW AND FOXPRO DATE FORMATS

Author

Message

Posted 1/12/2024 10:05 PM

Forum Member
Forum Newbie

Group: Forum Members
Active: 2/5/2024
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/2024')) 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

Posted 2/3/2024 11:41 PM

Forum Administrator

Group: Advanced Members
Active: 8/9/2024
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

Posted 2/5/2024 9:34 AM

Forum Member
Forum Newbie

Group: Forum Members
Active: 2/5/2024
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

Posted 2/7/2024 11:59 PM

Forum Administrator

Group: Advanced Members
Active: 8/9/2024
Posts: 64

Thank you for you feedback. I will investigate this further and try to reproduce the problem on my machine.

IP Logged

Showing page 1 of 1 - 4 messages found

« Next Oldest