Subject | Metadata SQL question |
---|---|
Author | Lee Jenkins |
Post date | 2004-04-23T20:13:23Z |
This question is in relation to my previous question about "Synchronizing
Generators". Now, that I know that I must not UNDER ANY CIRCUMSTANCES fool
with my generators, I need to be able to populate my IBOQuery from a table
but leave out fields that are are involved in an Index that must be unique
so that they are not included in an Import.
I'm guessing a query that pulls the fields from the table I want, but filter
out fields that are involved in a unique index? In otherwords, I don't want
to have to hard code and change the sql whenever I add another table and/or
unique index. Any help would be greatly appreciated.
Thank you again,
Lee
Generators". Now, that I know that I must not UNDER ANY CIRCUMSTANCES fool
with my generators, I need to be able to populate my IBOQuery from a table
but leave out fields that are are involved in an Index that must be unique
so that they are not included in an Import.
I'm guessing a query that pulls the fields from the table I want, but filter
out fields that are involved in a unique index? In otherwords, I don't want
to have to hard code and change the sql whenever I add another table and/or
unique index. Any help would be greatly appreciated.
Thank you again,
Lee