serios problem with sql command

Harvey Toyama harvey.toyama at qlogic.com
Wed Nov 9 18:10:55 EST 2005


Hi Alessandro,
If this is your code,

get revOpenDatabase 
("MySQL","localhost","Gestionale","alessandropisoni","")
revExecuteSQL it,"INSERT INTO Anagrafica (id, Codice) values (NULL, 22)"

then it looks like you forgot the semicolon, e.g.,

revExecuteSQL it,"INSERT INTO Anagrafica (id, Codice) values (NULL,
22);"

-- Harvey
-- 
 
-----Original Message-----
From: use-revolution-bounces at lists.runrev.com
[mailto:use-revolution-bounces at lists.runrev.com] On Behalf Of Alessandro
Pisoni
Sent: Thursday, November 03, 2005 5:35 AM
To: use-revolution at lists.runrev.com
Subject: serios problem with sql command


Bye i have an serios problem with the command revExecuteSQL !!! not  
work into my db sql.

get revOpenDatabase 
("MySQL","localhost","Gestionale","alessandropisoni","") // 
alessandropisoni is administrator fullcontrol
revExecuteSQL it,"INSERT INTO Anagrafica (id, Codice) values (NULL, 
22)" // not write in my db and in my table why?

i use now mysql 5 server and mac os x 10.4.3
I can to do the command sql SELECT and the command   get  
revQueryDatabase(it,"SELECT * FROM Anagrafica") work ok very well!


Cordiali saluti
Alessandro Pisoni

======================
System.ini
Via Grandi 5
20062 Cassano d'Adda (MI)
Tel. 0363-361487 Fax 1782260060 Cell. 335-440150
URL: www.system-ini.it   email: Info at system-ini.it

_______________________________________________
use-revolution mailing list
use-revolution at lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution




More information about the use-livecode mailing list