Subject | Re: [IB-Conversions] problem with sql2gdb |
---|---|
Author | Enrique I.Rodriguez |
Post date | 2000-12-05T12:10:59Z |
Sorry the delay.. really busy lately :-(
On Sun, 19 Nov 2000 20:15:20 -0300, Marcelo
<marcelo.lopezruiz@...> wrote:
statments... as I see the 'migrate the database to file' feature of
sql2gdb is for that templating you say above. Isn't it? The only way
of get the true data is migrating to the ending .gdb.
localized caracters in object names as far as you surround it with
"'s.
There are some i8n issues where this goes more critical if you don't
want to get storing real field names into tables and getting those
things on the application TIER.
-------
Enrique I.Rodriguez - http://club.idecnet.com/~esoft
Las Palmas de Gran Canaria - Canary Islands
Spain
On Sun, 19 Nov 2000 20:15:20 -0300, Marcelo
<marcelo.lopezruiz@...> wrote:
>The sql2gdb wizard uses this script as a "template" to move records later on.Ok. I thought I could get a script with all the data into INSERT's
>The quotes can be turned on or off from the Customizations step (but the
>wizard will use other mangling methods). The colon before the field name
>means that it is a placeholder. For example, if you want not to move a field,
>you can modify the script to look like:
>
>insert into mytable (
> "field1",
>...
statments... as I see the 'migrate the database to file' feature of
sql2gdb is for that templating you say above. Isn't it? The only way
of get the true data is migrating to the ending .gdb.
>> Unless you want your column names to be case-sensitive, or you want to useI do want my column names casesensitive.
>> reserved words as column names, avoid the quotes when you define the
>> columns in your metadata.
>>Not for data but it is for object names. In fact, IB does really allow
>> In IB 6, double-quotes are not legal syntax for delimiting values.
localized caracters in object names as far as you surround it with
"'s.
>Yes, and case-sensitivity is, in my opinion, a pain, at least for datamyproductoftheyear - MyProductOfTheYear.
>modeling (what's the different between product and Product?).
There are some i8n issues where this goes more critical if you don't
want to get storing real field names into tables and getting those
things on the application TIER.
-------
Enrique I.Rodriguez - http://club.idecnet.com/~esoft
Las Palmas de Gran Canaria - Canary Islands
Spain