[VSRV] Can't get an updateable cursor with VXCMD

[Ruslan Zasukhin]

on 9/12/03 2:31 AM, Ken Ray at kray at sonsothunder.com wrote:

>>> I'm trying to make the following code work, and it's erroring out on
>>> me:
>>> 
>>> on MarkRecords pRecID
>>>   put "SELECT * FROM Marked WHERE RecID=0" into tSQL
>>>   put Valentina("Database_SQLSelect",gMainDBRef,tSQL,2,2,2)
>> into tCurs
>>>   put (pRecID & tab & gUserID) into tRecord
>>>   get Valentina("Cursor_AddRecord",tCurs,tRecord)
>>>   get Valentina("Cursor_UpdateAllRecords",tCurs)  -- ERROR 605 HERE
>>>   get Valentina("Cursor_Remove",tCurs)
>>> end MarkRecords
>>> 
>>> What I get is "Error 605: CantBeUpdated"
>> 
>> I wonder whether your problem can be that you do not assign field
>> values (SetField) explicitely. UpdateAllRecords works only on dirty
>> fields, so if the temp buffer has no fields dirty, it has nothing to
>> do. Also, I wonder why you use UpdateAllRecords since your cursor has
>> only a single record at this point.
> 
> Well, actually the code above is simplified to only post a single
> record; in actuality it works with one or more records. However perhaps
> I hit on another bug; if I just do "Cursor_AddRecord" without the
> "Cursor_UpdateRecord" (or "Cursor_UpdateAllRecords"), it doesn't "take".
> The code was working fine in the standalone version of Valentina; it's
> only when I am trying to tweak my code to work with VSRV that I run into
> this problem.

Ken,

So you thi9nk you have found bug in Server or in Client ?

Please repeat report in details.
What you do, what expect and what you get.
Versions, Os, APIS.
If you can make project that reproduce this will be great.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------