>>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement