LiveCode Forums.

hi, then i try this from sqlite documentation [/code] revExecuteSQL gConID, tSQL,"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, Sta...

works fine, thanks
Ralle

Hi Jan, the line is not the problem, i dont know the howto and have it in 1 line :oops: my way, i have many editfields for name, vorname, ......., below of this fields i an listfield, i pick one line of listfield, this appears in the editfields, i change some text of fields, click update > error, i ...

hi,
i have a tablefield with data from database, i want select line 5- 10 or line 20- 50 , print Printcommand with selectedLines or hilitedLines dont work. need a howto
Ralle

i update the code,
"" naer "(" syntax error ""
i have change my own code, no c + p,
ralle

not from webpage, in my own project,
ralle

hi,
add the comma, dont work, the same message

every time when use copy and paste with my database scripts i get an error,
use this code
""revExecuteSQL gConID, "Insert into Schueler (Name.........)""
in runtimemode rr comments " database error near "(" ", if i delete all and type the same in script it works ?????????????
its normally
Ralle

hi, little problem, RR tell "unrecognized token" :evil: i test to update my database, nearly the same to insert into on mouseUp global gConId put field "Name" into tName put field "Vorname" into tVorname put field "Strasse" into tStrasse put field "Hausnr" into tHausnr put field "PLZ" into tPLZ put ...

Thanks for help.
There was 2 silly mistakes, the quotes and "insert must be Insert".
now works
Ralle

thanks for help, my second name is "nervious" :wink: it was a little mistake, i mean this one "yxz" oops, there is no way, tried with "*b" or this "local tSQL put "INSERT INTO Example(" & return & \ "tname, name)" & \ "VALUES(" & return & \ ":1, :2,)" into tSQL local tFirstname put field "name" into...

thanks for reply, works, but please show on this topic

http://forums.runrev.com/phpBB2/viewtopic.php?t=930

any ideas
Ralle

hi,
whats wrong, 21 views, no reply, please help.
rallle

i have 2 fields , name, vorname in the stack, this script in the button for sqlite 3, connection is correct, on mouseUp global gConID put field "name" into tname put field "vorname" into tvorname answer tname, tvorname revExecuteSQL gConID,"insert into Schueler(name, vorname) VALUES(:1,:2)",tname, t...

i have created a sqlite db, works! then i have created two tables, okay. when i open the querybuilder i can see the db and the tables, but the tables havent a primarykey??? there is no way to tell the fields in rev which column. the code of stack is put "CREATE TABLE lehrer(lehrerID integer primary ...