[V4RB] SQLselect ?

Thierry Nauze huancaya at wanadoo.fr
Tue Sep 23 15:06:25 CDT 2003


B'jour,

Here is my problem :

   dim i, n  as integer
   dim curseur as vCursor
   dim id, nom as string

// No problem with :
   id="1"
   nom="ABDALi"
   erreur = KarNotes.SQLExecute("UPDATE eleves SET nom='"+nom+"$' WHERE 
id="+id)    ***


// But this don't works.
   curseur = KarNotes.SQLSelect("SELECT id, nom FROM eleves")

   n=curseur.recordCount
   if n>0 then
     res=curseur.firstRecord
     For i=1 to n
       id=curseur.field("id").getString
       nom =  curseur.field("nom").getString
        erreur = KarNotes.SQLExecute("UPDATE eleves SET nom='"+nom+"$' 
WHERE id="+id)
        res=curseur.nextRecord
     next
    end

*** erreur = KarNotes.SQLExecute("UPDATE eleves SET nom='"+nom+"$' 
WHERE id="+id, 2, 3)  dont works also


If work with RB 5.21, MacOS X and Valentina 1.98.
I had read the releases notes and the manual but ...


Thanks

--
Thierry Nauze			Saint-Denis de la Réunion



More information about the Valentina mailing list