General information
Category:
Visual FoxPro and .NET
Title:
OLEDB Provider and Record Locking
Any help would be appreciated:
I am accessing Fox2.5 data in VB.NET via the vfp oledb provider.
What I need to do is retrieve the value of a counter from a field and increment it, like this:
if rlock()
m_NextImage = sysconf.NextImage
replace sysconf.NextImage with NextImage+1
unlock
endif
My question is: can I do this by sending an SQL UPDATE and SQL SELECT from VB.NET through the oledb provider and be assured that the record was locked while being updated?
Thanks
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only