Re: sqlite and update

--- haribo <[EMAIL PROTECTED]> wrote: > > hi, > now, i spend 3 days for update problem, i can > insert, delete, no problem, > then i want update one person, its terrible, first i > have this code > > [snip] > > dont work > need help > Ralle > Hi Ralle, I replied to your question on the runre

Re: sqlite and update

Hi Ralle, Next to Christian's reply, consider using an array. Your input should read like this: put fld "name" into data[1] put fld "vorname" into data[2] That way you don't need the long list of variables at the end of your query. And there's a typo you may have missed: ::16 Regards, Henk

Re: sqlite and update

Hello, The SQL syntax for Update is : UPDATE table_name SET column_name = new_value WHERE column_name = some_value Here is a good reference : e.g. put "UPDATE Schueler SET Name="& "tName"&","&& "Vorname="&tVorname&","&& "Strasse="&tStrasse&"," &&"

sqlite and update

nr = tHausnr, PLZ = tPLZ, Ort = tOrt, Gebdatum = tGebdatum, Tel1 = tTel1, Tel2 = tTel2 , Tel3 = tTel3, Geschl = tGeschl, Konf = tKonf, Staatsang = tStaatsang, Klasse = tKlasse, Nachname2 = tName2, Nachname3 = tName3, Email = tEmail" into tSQL revExecuteSQL gConID, tSQL put the result into