BDE Supported SQL Functions

[wil5000]

Can anyone tell me if there are certain ANSI SQL functions that the BDE
doesn't support?

I'm trying to select all individuals from and employee table whose effective
dates are the 15th of the month my statement is as follows:

SELECT ssn,eff_date,name
FROM "employee.dbf"
WHERE DAYOFMONTH(eff_date) = 15
ORDER BY eff_date,ssn

The BDE returns and error message of "capability not supported"

Thanks in advance

Stacey
Reinsurance Management Inc.

[Andrea Gnesutta]

wil5000 wrote:

> Can anyone tell me if there are certain ANSI SQL functions that the
> BDE
> doesn't support?
>

Hi Stacey,
Take a look at Local SQL help in your Delphi folder.

Andrea

[Stefan Bodingh]

You have to use the "extract" to get the month. Please see my example:

SELECT ssn, eff_date, name
FROM "employee.dbf"
WHERE EXTRACT( DAY FROM eff_date ) = 15
ORDER BY eff_date, ssn
--
______________________________________________________________________
: Stefan Bodingh - Paradox and Delphi Consulting
: Located in Haninge Sweden
: URL: http://home2.swipnet.se/~w-27915/
: Tel +46 8 745 46 10 (mailto:stefan....@swipnet.se)
______________________________________________________________________

wil5000 skrev i meddelandet <6fdp2k$l3...@forums.borland.com>...

>Can anyone tell me if there are certain ANSI SQL functions that the BDE
>doesn't support?
>

[Bill Todd (TeamB)]

What database are you using? BDE supports whatever your database
emplements. If you are using local Paradox or Dbase tables then the SQL
funtionality that is supported is described in the Local SQL help file.

AFAIK DAYOFMONTH has never been part of the ANSI SQL spec. The ANSI 92 spec
includes the Extract function to get the parts of a date.

SELECT EXTRACT(YEAR FROM HIRE_DATE)
FROM EMPLOYEE

--
Bill

(TeamB cannot answer questions received via email.)
(To contact me for any other reason remove nospam from my address)

[wil5000]

Thanks to all of you. The EXTRACT function worked just fine.

[Nick Spurrier]

WHERE EXTRACT(DAY FROM <datefield>)=