|Subject||Re: [IBO] how to?|
>This isn't an IBO issue and should be posted in the ib-support list...Yeap, I realized after the fact and it was to late, sorry
>You've missed a few steps but you will bump into another problem beforeI worked my way around it, I created a temp table. dump the data in it,
>you solve this.
dropped the original and recreated (including the PK) and dump the data in
the new table, recreated the indexes.
There doesn't seem to be any null values in any keys, if there are I'll
have to cleanup manually. the index on these keys were unique.
I have to do this for about 15 tables
so every table will have a PK , and a unique index also.
>Varchar(4) seems too small for a unique key unless this is just a littlein this case yes it's a lookup table
>control table of some sort...
>Is there a special reason why you can't use a generator for your primary key?I'm using a generator for the main tables, which will be the PK .
I'm doing all of this, before inserting an IBODatabase and doing the code
changes you suggested.
>Helen Borrie (TeamIBO Support)
>** Please don't email your support questions privately **
>Ask on the list and everyone benefits
>Don't forget the IB Objects online FAQ - link from any page at
>IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
>http://www.ibobjects.com - your IBO community resource for Tech Info papers,
>keyword-searchable FAQ, community code contributions and more !
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/