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