No integer? Weird. I was hoping I could use a format that was fast and compatible between VFP/MSSQL/ORA but I guess not. Oh well. If this was all VFP, after I got my primary key field in there, I'd setup a stored proc to get an auto-incrementing counter in there. For Oracle, this (pretty poor for a) O'Reilly book mentions some kind of "sequence" that has to be made, and I assume I have to put this in an insert trigger to get activated every time.

Sooo..... Do you have any example syntax (pseudocode?) for creating an insert trigger and/or a sequence?

How many times can I say "Thanks"?

Thanks!


>Oracle has no integer type. Just use number(9). Also, getting maintenance transferred to the data owner is a very good idea.
>