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

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

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

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

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

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