Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Locking VFP records in ASP.NET
Message
From
17/09/2008 12:06:16
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Locking VFP records in ASP.NET
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01348296
Message ID:
01348296
Views:
58
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!!!
Next
Reply
Map
View

Click here to load this message in the networking platform