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 : <http://w3schools.com/sql/sql_update.asp>
e.g.
put "UPDATE Schueler SET Name="& "tName"&","&&
"Vorname="&tVorname&","&& "Strasse="&tStrasse&"," &&"Hausnr="&
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&&"WHERE rowID=1" into tSQL
you have to know the rowId here...
But it seems that you are updating all of your fields ; I would
suggest to use the REPLACE INTO Statement instead...
sql-statement ::=
REPLACE INTO [database-name .] table-name [( column-list )] VALUES
( value-list ) |
REPLACE INTO [database-name .] table-name [( column-list )] select-
statement
Look here for more information : <http://www.sqlite.org/
lang_replace.html><http://www.sqlite.org/>
Hope this helps,
Christian Langers
_______________________________________________
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
