Updating a cursor generated form SQLexec()

[Xaplytz]

Hi Volodymyr Grynchyshyn
I have seen the code that you made for work with cursors generated by SQLexe() for me are so important because I don’t like make viewer I like work with SQLexe() .
I modified to use in one of my cursor
//cod
CURSORSETPROP('Tables', 'dbo.arinvc')
CURSORSETPROP('UpdateNameList', 'lexported dbo.invc.lexported, dexported dbo.arinvc.dexported')
CURSORSETPROP('KeyFieldList','cinvno')
CURSORSETPROP('UpdatableFieldList', 'lexported, dexported')
CURSORSETPROP('SendUpdates', .T.)
CURSORSETPROP('buffering', 3)
//end code
I the program work ok in VFP but don’t update in SQL-server
Even I run tableupdate(.T.,.T.) after all the change.
I you or somebody have any idea
Thank
[sig][/sig]

 

[TomasDill]

CURSORSETPROP('UpdateNameList', 'lexported dbo.invc.lexported, dexported dbo.arinvc.dexported')

In the red highlighting: Is it just misspelled name of table, or it is cause of problem?

In addition, what value returns tableupdate() command? If .f., use aerrors() function to get information about why update was not made. [sig]<p>Vlad Grynchyshyn<br><a href=mailto:vgryn@softserve.lviv.ua>vgryn@softserve.lviv.ua</a><br>[/sig]

 

[Xaplytz]

It’s working ok
I work it with cusorsetprop(‘buffer’,5), when I finish to make changes, I use tableupdate(.T.) , because buffer 3 works row by row .
Thank you a lot .
[sig][/sig]