>>>I have a default value setup in a VFP table that runs a stored procedure and returns a unique record ID for each new record inserted into the table. This works fine when using VFP but does not work using the VFP ODBC driver. Does anyone know why this doesn't work.
>>>
>>>Thanks,
>>>Dave
>>
>>there are lots of FoxPro things that aren't available to the ODBC driver. What is the code you are using to create your unique id?
>
>This is what does not work...
>
>begin transaction
> update setup set value = value+1 where key_name = "TABLENAME"
> lcret = setup.value
>end transaction
>return alltrim(str(lnret))
>
>This does not work either...
>
>begin transaction
> update setup set value = value+1 where key_name = "TABLENAME"
>end transaction
>lcret = setup.value
>return alltrim(str(lnret))
>
>This does work...
>
>begin transaction
> update setup set value = value+1 where key_name = "TABLENAME"
>end transaction
>lcret = 150
>return alltrim(str(lnret))
>
>The problem is assigning the value of table.field to my varialble, if you have any ideas on how to make this work it would be greatly appreciated.
>Thanks,
>Dave
The update command will not necessarily place you at the correct record in the table.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer