quotes in fields

[fule12]

Hi all,

I'm learning Delphi and Interbase so please if someone know how to solve this problem.

I was migrate ms access database with interbase datapump 3.4
But now when i create query in interbase I need to put enclose fields with quotes.
Select
"AccCode_ID","AccCode_No"
from
AccCode
So each field in query mast be enclosed with ".
I'm using dialect 3.

Is any way to convert database, so that fields be come "normal" , without double quotes (“) ?

Or is another way to import Ms Access data base ?

Thanks





Fule

 

[pfournier]

Select case-insensitive fields when you import the data with Interbase DataPump...

 

[fule12]

Thanks,
but InterBase dialsec 3 is case sensitive.The only solution is to Create Table and Field Name with UperCase. and Interbase datapump put quote on filed imported from MS Access.


Fule

 

[pfournier]

If you convert the names to UperCase, you will not need the quotes anymore... (nor will you need to write them in UperCase if you don't use quotes)