I just discovered that transactions don't apply to free tables, which is what I must use in this SBT-based product. If anyone has any suggestions regarding an alternate way to populate a unique ID, I'd be happy to hear it! Thanks,

Joy

>I have an issue with a transaction. The program assigns a remoteid to each new record which gets added. So that two users can't simultaneously add the same remoteid, I've used a transaction:
>
>WITH THISFORM
>BEGIN TRANSACTION
> * Add to the header:
> SELECT a_arpthd
> APPEND BLANK
> SELECT MAX(RemoteID) AS MaxRemote FROM a_Arpthd INTO CURSOR c_Temp
> .prpRemoteID =c_Temp.MaxRemote +1
> REPLACE ;
> ProjectID WITH mProjectID, ;
> Techno WITH .prpVendno, ;
> Date WITH .prpDate, ;
> RemoteID WITH .prpRemoteID, ;
> Address WITH .txtAddress.Value, ;
> Adduser WITH gc_userid, ;
> Adddate WITH DATE(), ;
> Addtime WITH TIME()
>END TRANSACTION
>SELECT c_temp
>USE
>ENDWITH
>
>I thought that by doing this in a transaction, it would run all of those commands "simultaneously" (sort of) and make sure it didn't do one without the other. However, I'm still getting duplicate remoteid's. Does anyone have a better way? I'd prefer not to use another file that has the remoteid ticker in it, but if I must I will.
>
>TIA
>Joy