At 12:46 PM 12-12-01 +1000, you wrote:

>Hi,
>
>We are trying to migrate to the interbase / IBX family from Acess / ADO. We
>had a lot of trouble getting our first query to run. It turned out that the
>table name was case-sensitive and needed quotes. This is a pain - it means
>amending a lot of code. Is there a way to do without the quotes and make it
>non-case sensitive?

Yes indeed. In fact, quoted identifiers were PUT there in v. 6 to pander to Access migrants who wanted to be able to use blanks in identifiers or to recycle reserved words as identifiers. I suppose you used some no-brain tool that didn't give you the option for standard, non-case-sensitive identifiers with sensible names....

What I'd do - grab IB_SQL (free from www.ibobjects.com). Use it to connect to your db and use its Extract tool to get a metadata script. Save the output to a text file and then go in there and edit out all the quoted identifiers.

You'll need to either leave the q. identifiers on "wrong" identifiers, or change them to something useful.

Then create a new database by running that script in the script window of ib_sql.

Then use the Datapump tool to pump your data from the embellished database to the plain-Jane one.

regards,
Helen

>Regards,
>
>Mark
>
>
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________