Problem with Date and Interbase 5.5 ODBC driver

lbell...@dsuper.net (Luc Bellego)

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Problem with Date and Interbase 5.5 ODBC driver

When I use MyQuery.ParamByName('a name').AsDate := Now and I use
ExecSQL the system reply that :
[INTERSOLV][ODBC Interbase driver] Timestamp parameters with zero
scale must have a precision of 13, 16 or 19. Prameter
numer :1, precision: 0.

When I take a look with BDE Explorer I see that there is ???? for the
field date in each table. Time is a godd value : 00:00:00

When I can change the settings for the date ? I have found nothing in
ODBC Driver setup, BDE...

Luc Bellego
lbell...@gbinaire.com
Gestion Binaire Inc.

Other Threads

1. INTERSOLVE ODBC Driver for Interbase 5.5

2. I need get Date and Time from interbase server 5.5

3. Interbase Restore from 5.5 to 6.0 formatting dates

4. Problem with this code (Delphi 4/Interbase 5.5)

5. Date field problems with ODBC driver

6. Interbase 5.5 & ASP connection problem

7. Validation & Restore Problems with InterBase 5.5

8. Interbase problem with Ver 5.5

9. Special characters vom Interbase 4.2 to Interbase 5.5

10. Import Interbase 7.0 into Interbase 5.5 database fails.