create table error with BDE 5.2 and interbase 6.2

Jonas Raudonas

Delphi Developer

Tue, 22 Mar 2005 19:18:24 GMT

create table error with BDE 5.2 and interbase 6.2

Hi,

1) I try create table (in SQL Explorer or from my delphi app.) in this way:
CREATE TABLE "Test1" ("First_Name" varchar(20))
and get error: Token unknown - line 1, char 14 ...

if i don't use " - all goes without error but table is created with
field names in upper cases only.

2) creating table with DATE field:
"CREATE TABLE Test1 (BDate DATE)"

error: Metadata update statement is not allowed by current database SQL
dialect 3 ... DATE data type is now TIMESTAMP

Jonas Raudona

Delphi Developer

Tue, 22 Mar 2005 21:34:33 GMT

Re:create table error with BDE 5.2 and interbase 6.2

:) I found solution

Quote

Jonas Raudonas wrote:
> Hi,

> 1) I try create table (in SQL Explorer or from my delphi app.) in this way:
> CREATE TABLE "Test1" ("First_Name" varchar(20))
> and get error: Token unknown - line 1, char 14 ...

> if i don't use " - all goes without error but table is created with
> field names in upper cases only.

> 2) creating table with DATE field:
> "CREATE TABLE Test1 (BDate DATE)"

> error: Metadata update statement is not allowed by current database SQL
> dialect 3 ... DATE data type is now TIMESTAMP

Bill Tod

Delphi Developer

Tue, 22 Mar 2005 21:42:58 GMT

Re:create table error with BDE 5.2 and interbase 6.2

I suggest that you not use the BDE to connect to InterBase. See
http://community.borland.com/article/0,1410,28688,00.html . Also, be
aware that the BDE does not support large exact numerics in dialect 3
databases.

If you do want to use the BDE do the following to enable support for
the dialect 3 features.

To use the new InterBase 6 Dialect 3 features, add an entry
to your Windows registry under
HKEY_LOCAL_MACHINE\SOFTWARE\
Borland\Database Engine\Settings
\Drivers\Intrbase\Db Open\SQLDIALECT
and set the value to "3".

When an InterBase alias is created, the new entry will be
available in the .CFG file.

On Fri, 04 Oct 2002 13:18:24 +0200, Jonas Raudonas

Quote

<--------remove-it-before-sending------1uo...@delfi.lt> wrote:
>Hi,

>1) I try create table (in SQL Explorer or from my delphi app.) in this way:
>CREATE TABLE "Test1" ("First_Name" varchar(20))
>and get error: Token unknown - line 1, char 14 ...

>if i don't use " - all goes without error but table is created with
>field names in upper cases only.

>2) creating table with DATE field:
> "CREATE TABLE Test1 (BDate DATE)"

>error: Metadata update statement is not allowed by current database SQL
>dialect 3 ... DATE data type is now TIMESTAMP

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

Other Threads

1. BDE 5.2 + Interbase Server 4.0 + Interbase 6 Client

2. Exist version 6.1 and 6.2 Interbase??

3. Interbase with BDE 5.2 and Domain Users on Win2000 Server

4. InterBase BDE 5.2 SQL Links Update WARNING!!!

5. Interbase dialect 3 Int64 and BDE 5.2

6. InterBase 6 and BDE 5.2 : Cursor unknown

7. BDE 5.2 and Interbase 6

8. BDE 5.2 with InterBase 4.0

9. $2501 Error in BDE 5.2 on XP

10. BDE Merge Module 5.2 error