sqlite insert hell

[stefano cerbioni]

hi i try to insert in db sqlite a  simply data  that a grab by  text input box  the  problem i find  but not  find  a solution  in practical  i must add  this    '   because with this  work in sqlitebrowser 

i try to add  in this mode  

func Inserisci() {
if lineedit1ApiKey.text() != "" and lineedit6SecretKey.text() != "" and lineedit8EXchange.text() != ""

oSQLite = sqlite_init()
sqlite_open(oSQLite,"mytest.db")
sql = "
        INSERT INTO key_exchange (ApiKey,SecreatKey,idApi,exchange)
        VALUES  ('lineedit1ApiKey.text()',  'lineedit6SecretKey.text()' ,'lineedit8EXchange.text()',' lineedit7IDApi.text()');"
        ?sql

sqlite_execute(oSQLite,sql)


else
MsgInfo("Info","Devi inserire Apikey,SecreteKey, exchange obbligatoriamente  ")

ok
}

return me  this  code   INSERT INTO key_exchange (ApiKey,SecreatKey,idApi,exchange)
        VALUES  ('lineedit1ApiKey.text()',  'lineedit6SecretKey.text()' ,'lineedit8EXchange.text()',' lineedit7IDApi.text()');   

1. why  not  return a value  'lineedit6SecretKey.text()  read ?

2. why also in this mode  also if  have  '''''''''   not  insert nothing  ?? 

thanks 

[Ilir Liburn]

Hello Stefano,

concatenate returned strings from the Ring functions, SQLite knows nothing about .text() existing in the Ring world.

Greetings,

Ilir