With ADS 21.0 , I am unable to create table in Interbase 2000 . The problem is with double quotes in the create table statement generated by ADS. The statement executes perfectly without double quotes through query window. The problem is with SQL dialect. It needs to be set to 3. If I go through IBconsole and create a database with SQL dialect 3, then I can easily create tables through ADS. Is there any way I can specify the SQL Dialect in ADS while creating the database or do I have to take help of IBConsole each time?
Thanks
Gaurav.
Response
Thomas Conrad over 2 years ago
Hi Gaurav,
You can turn off the quotes in Visual Editing by unchecking File->Options->Script->Interbase->Visual Editing Quote Identifier.