Thanx Josh,
Will try it out!
Bob
>You can use SQL Server's @@IDENTITY variable to find the value of the last record inserted. You must use the same connection you used to insert the record. Try this after you add the record:
>
>llsucess =SQLEXEC(CURSORGETPROP('ConnectHandle','myalias'), ;
> 'SELECT @@IDENTITY AS KeyValue')
This assumes the alias of the view you just added the record to is 'myalias.'
>
>>I ran into this problem today and was wondering if anyone
>>can give some ideas on how to handle this...
>>
>>In the scenario:
>>
>>Customer_Num I - Identity Key
>>Customer_Name C(15)
>>
>>If I insert Into the SQL Server database using a remote
>>view, I do not know the Customer_Num. In Order to
>>get the current result set I would need to =Requery() the
>>Remote View. When I requery() the remote view, the
>>record pointer moves. Since I do not know the
>>Customer_Num key, how would I know where to return the
>>record pointed to?
>>
>>This becomes more of a problem if the View is ordered, and
>>the returned REQUERY Set had the new record in the middle or so...
>>
>>Locateing for the Customer_name is not really any option
>>Since we could possible have the same name for different customer
>>#'s...
>>
>>Anyone have any thoughts on this?
>>
>>Bob