Date Fields on paradox sql statements

forums.inprise.com

Delphi Developer

Thu, 06 Dec 2001 03:00:00 GMT

Date Fields on paradox sql statements

Please,

i would like to know how i can use a statement like this:
' SELECT * FROM tablex WHERE datefield > "01/01/2000" '

I tried to use this comands but i got a error message.
I'm trying to access a PARADOX table.

Thanks a lot.

David Ree

Delphi Developer

Fri, 07 Dec 2001 03:00:00 GMT

Re:Date Fields on paradox sql statements

Quote

>i would like to know how i can use a statement like this:
>' SELECT * FROM tablex WHERE datefield > "01/01/2000" '

use single quotes to delimit dates:
SELECT * FROM <table> WHERE Datefield > '01/01/2000'

--
David Reed
Diamond Software Group
Oasis Rep Software, Inc
www.diamondsg.com
www.oasisrep.com

Steve Koters

Delphi Developer

Fri, 07 Dec 2001 03:00:00 GMT

Re:Date Fields on paradox sql statements

On Sun, 20 Jun 1999 22:30:13 -0300, "forums.inprise.com"

Quote

<starlines...@mandic.com.br> wrote:
>i would like to know how i can use a statement like this:
>' SELECT * FROM tablex WHERE datefield > "01/01/2000" '

>I tried to use this comands but i got a error message.
>I'm trying to access a PARADOX table.

What is the error you are getting? The syntax you cite as an example
appears correct.

When does the error occur? When you first activate the TQuery? When you try
to access the data after activating the TQuery?

//////////////////////////////////////////////////////////////////////////
Steve Koterski "My problem lies in reconciling my gross
Technical Publications habits with my net income."
INPRISE Corporation -- Errol Flynn (1909-1959)
http://www.borland.com/delphi

Other Threads

1. SQL statements and Date fields...

2. Paradox AutoIncrement Field Problem With SQL Update Statement

3. SQL and Date-Field in Paradox-Db

4. SQL on date-field in Paradox-table??

5. Wildcarding a Paradox Date Field - Using locl SQL

6. Database Explorer, Paradox, SQL and date fields

7. SQL and date fields in Paradox tables

8. Dates fields in SQL / Paradox

9. 'select' statements and date fields

10. Update-statement and date/time-fields