Re: [DUG] Adding Field to Table in SQL

Sun, 28 May 2006 23:26:38 -0700

 
----- Original Message -----
Sent: Monday, May 29, 2006 5:40 PM
Subject: [DUG] Adding Field to Table in SQL

Is it possible to add a field to a paradox table called Active using SQL.

In the BDE? Yes. eg:

 

alter table ":dbdemos:test.db"
  add "test.db"."Active" boolean

 

That weird syntax "file name including extension"."field name" is the BDE's way of letting you specify fields that are reserved words, contain illegal characters etc.

 

A similar example: to create a file with an illegal field:

 

create table ":dbdemos:test.db"
  (id numeric(6),
  "test.db"."Active" boolean)

I.E Alter table <x> add column Active Boolean

 

Active is of course a reserved word. I know this – pity the developer I inherited the system from didn’t. I have tried ‘Active’, “Active” and even [Active] but to no avail. 

_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi

Reply via email to