Updating all records again

[Roger Amar]

Hi Ruslan,

The version of VXCMD I am using is 1.11 for both Mac and Windows (this value is returned by the "Version" command )
Here are my handlers :

on UpdateAllRecords fldName, fldValue
   CheckdbRef
   CheckCursor

   put Valentina ("Cursor_SetField",cursorRef,fldName,fldValue) into temp
   CheckError "UpdateAllRecord", "Cursor_SetField", temp

   put Valentina ("Cursor_GetField",cursorRef,fldName) into tempValue --> just for checking here tempValue = fldValue
   CheckError "UpdateAllRecord", "Cursor_SetField", tempValue

   put Valentina ("Cursor_UpdateAllRecords",cursorRef) into temp
   CheckError "UpdateAllRecords", "Cursor_UpdateAllRecords", temp

   put Valentina ("DataBase_Flush",dbRef) into temp
   CheckError "UpdateAllRecords", "DataBase_Flush", temp
end UpdateAllRecords

on UpdateAllRecords fldName, fldValue, numVolume
   CheckdbRef
   CheckCursor

   RemoveCursor --> because of error 363 (not documented in the Valentina Database Kernel.pdf)

   put "update boTitres set" && fldName && "=" && fldValue && "where numeroVolume =" && numVolume into theSQL
   put theSQL --> to check if it is correct


   put Valentina ("Database_SQLExecute", dbRef, theSQL) into temp --> here temp = number of records
   CheckError "UpdateAllRecords", "DataBase_SQLExecute", temp

   put Valentina ("DataBase_Flush",dbRef) into temp
   CheckError "UpdateAllRecords", "DataBase_Flush", temp
end UpdateAllRecords 

I hope this will help you.

Best regards,

Roger;



-----Message d'origine-----
De : valentina-bounces at lists.macserve.net [mailto:valentina-bounces at lists.macserve.net] De la part de Ruslan Zasukhin
Envoyé : jeudi 24 février 2005 16:51
À : valentina at lists.macserve.net
Objet : Re: Updating all records again

On 2/24/05 5:17 PM, "Roger Amar" <Roger at logram.com> wrote:

> Hi Ruslan,
>
> I am sorry to confirm that UpdateAllRecords command *and* the update
> sql do not work neither on my Macintosh nor on my PC and that they return no error.

Send me please your db AND your SQ command.

Also tell me which versions of VXCMD you use


--
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
-------------------------------------------------------------


_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina