Board index » delphi » BDE : General SQL error when querying DATE datatype field in InterBase table

Steven Cheng

Delphi Developer
Mon, 15 Nov 2004 11:27:10 GMT

BDE : General SQL error when querying DATE datatype field in InterBase table

Hi,

I'm using TQuery to access a table in InterBase6.0. I got an error message
saying that the BDE eemgine cannot refer to the DATE datatype of InterBase.
How to fix this problem?

Error:
Project IBBDE.exe raised exception class EDBEngineError with message
'General SQL error. Column unknown PRODDATE Client SQL dialect 1 dose not
support reference to DATE datatype'. Process stopped. Use Step or Run to
Continue.

How can I make the BDE client to support dialect 3 as I used in InterBase
database?

Thanks in advance.

Steven Cheng

 
Bill Tod

Delphi Developer
Mon, 15 Nov 2004 21:13:35 GMT

Re:BDE : General SQL error when querying DATE datatype field in InterBase table


BDE versions prior to 5.2 do not support InterBase dialect 3
databases.  Even version 5.2 does not support large exact numeric data
types. Before you use the BDE for your application you should read
http://community.borland.com/article/0,1410,28688,00.html. Using the
InterBase Express or dbExpress components would be a much better
choice.

On Thu, 30 May 2002 11:27:10 +0800, "Steven Cheng"

Quote
<steven_ch...@hongkongconcrete.com.hk> wrote:
>Hi,

>I'm using TQuery to access a table in InterBase6.0. I got an error message
>saying that the BDE eemgine cannot refer to the DATE datatype of InterBase.
>How to fix this problem?

>Error:
>Project IBBDE.exe raised exception class EDBEngineError with message
>'General SQL error. Column unknown PRODDATE Client SQL dialect 1 dose not
>support reference to DATE datatype'. Process stopped. Use Step or Run to
>Continue.

>How can I make the BDE client to support dialect 3 as I used in InterBase
>database?

>Thanks in advance.

>Steven Cheng

--
Bill (TeamB)
(TeamB cannot respond to questions received via email)

Other Threads

1. Saving TMemo field data to a Blob field (Interbase Table) via SQL Update Query

2. cannot retrieve dbexpress interbase SQLDataset when table contains a DATE datatype...help

3. Problems TEXT field in SQL Server (General SQL Error)

4. SQL-Error with ORDER BY for Date-Fields of FoxPro tables

5. BDE error: 13059 (General SQL error)

6. BDE error: 13059 (General SQL error)

7. BDE error 13059 General SQL error

8. sql and dates query?delphi dont query dates?

9. Interbase: General sql error, connection lost to database.

10. Interbase General SQL error suddenly come again..