>Use row and table buffering and then ther uniqueness of they key
>will not be checked until the tableupdate is executed
>
>Good Luck
>Jon
>
>>I've been putting off using databases with primary or candidate indexes and feel it's time to try them out.
>>
>>How do you get around the Uniqueness is Violated error? Is there anything more savvy than populating the unique code field with something like '####' and going out and looking for a duplicate? Seems to me there should be something better than allowing it to come up with the error for you, and I'm sure that many of you have figured something out!
>>
>>Thanx,
>>JR
Using buffered writes is your best option, but you can also use the INSERT SQL command. (i.e. INSERT INTO tablename FROM MEMVAR)