>Great question. I believe it was asked here two times and no solution was found how to retrieve output parameter from SP called by OleDB in .NET
Why would you need an output parameter?
>
>>We have an ASP.NET application that writes records into Visual Foxpro tables. We use an "ID" table that has a record for every table for the purposes of assigning the next primary key for a given table. Previous we used code much like:
>>
>>
>>
>>lnNextid = 0
>>LOCATE FOR id.tablename = lcTable
>>IF !EOF()
>> if RLOCK()
>> lnNextid = id.keyvalue
>> replace id.keyvalue with lnnextid + 1
>> endif
>>endif
>>return lnNextid
>>
>>
>>The problem is in ASP.NET with ODBC connection we have no way of locking the record (that i know of) to make sure two users do not happen to similtaneously call our newid function and receive a duplicate key.
>>
>>What would be the best way of grabbing and updating these primary keys from an ASP.NET application?
>>
>>Thanks in advance!!!