🚀 go-pugleaf

"Jon Carter" <jcarter@sfo.co.uk> wrote:

>Hi - I'd be very grateful if someone could help me with a couple of problems
>I'm having :
>
>1.  I am using this SQL statement with a Paradox database -
>
>SELECT * FROM orders WHERE date = #1/3/99#
>
>but am getting an error - is it because 'date' is a reserved SQL word?  Will
>I have to rename the date field in the database and change the app code?

You're getting an error because the pound signs are something local
SQL doesn't understand, among other things.

However, yes, you are also running into an error because "date" is a
reserved word. Try:

select * from orders where orders."date" = "1/3/99"

Ken
---
Ken Mayer [dBVIPS/TeamB]
   VdBASE7 Tutorial, HOW TOs, and dUFLP library:
http://www.apptools.com/dbase/kenstuff
   (which is a mirror of:)
http://www.mindspring.com/~hirschv/dbase/dbase.htm

dBASE 2000: http://www.dbase2000.com