Updating all records

Roger Amar Roger at logram.com
Wed Feb 23 17:56:12 CST 2005


Hello Robert,

>However, when fields are sorted, the cursor is not, and you can't use
>navigation arrows to move into.

>>But if you use SelectRecords, you have no cursor to be concerned
about. If user selects a line, you just fetch that records >>to display
it. Valentina is so fast that there is no real advantage (in most
>>circumstances) to keep the cursor and keep traversing it. It is as
effective to keep refetching the data.

What about my navigation arrows (first,prev,next,last) ?

Just now, I have a new problem : when I attempt to update all the
records of a cursor, they are *not* updated.

My handler is made like this :

on UpdateAllRecords fldName, fldValue
    CheckdbRef
    CheckCursor
 
    put Valentina("Cursor_SetField",cursorRef,fldName,fldValue) into
temp --> returns empty
    CheckError "UpdateAllRecord", "Cursor_SetField", temp
 
    put Valentina ("Cursor_UpdateAllRecords",cursorRef) into temp -->
returns true
    CheckError "UpdateAllRecords", "Cursor_UpdateAllRecords", temp
 
    put Valentina ("DataBase_Flush",dbRef) into temp --> returns empty
    CheckError "UpdateAllRecords", "DataBase_Flush", temp
end UpdateAllRecords
 
What is wrong ??
 
Thanks again for your help.
 
Roger;


More information about the Valentina mailing list