>The line with "declare @Output table (NewID int)" with not compile in VFP 9 - it is an unrecognized command.
That should be in your INSERT command string.
OK, give us what you use for inserting a record and we will change it :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.