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
>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!!!
If it's not broken, fix it until it is.
My Blog