Subject |
Re: Using Field Named DATE in Where clause |
From |
Akshat Kapoor <akshat.kapoor@kapoorsons.in> |
Date |
Wed, 14 Feb 2024 18:21:45 +0530 |
Newsgroups |
dbase.getting-started |
Attachment(s) |
LocalSQL Help.pdf |
Good Evening Craig,
> In terms of the fieldName being a reserved word. I am trying to get new reports done in the current version of dBase as the original database is from a very early version which only works on Windows XP so the choice was not mine.
>
> Here is the Where clause that I am trying to use:
> where DATE>"(currentDate()-30)" order by DUEDATE, CUSTOMER
>
> This is what I saw online when I tried to look up how to do it
Converting from dos to windows can be troublesome. I would recommend
that you go through the tutorials by Ken Mayer. The last one will
probably help you the most.
I had moved from visual foxpro to dbase. I had taken the dbase Tutorial.
the dos to window tutorial was not available then. If you have time then
go through the dBase tutorial as well
*Ken Mayer*
Ken's dBASE Page: http://www.goldenstag.net/dbase
The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp
dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm
dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm
dBASE Web Tutorial: http://www.goldenstag.net/dbase/WebTutorial/00_Menu.htm
dBASE DOS to Windows Tutorial:
http://www.goldenstag.net/dbase/DtoWTutorial/00_Menu.htm
I have attached the local sql help file.
Have a look at page 64.
Local sql available with dbase doesnot support all functions available
with RDBMS like MySQL, oracle etc. And websites provide info for these
RDBMS sql.
You will probably be requiring a query with parameters. It is covered in
Ken's books.
Regards
Akshat
Some recommendations
Download a newsgroup reader. It will help in going through the posts.
|
|