On 11/3/05 3:35 PM, "Alessandro Pisoni" <[EMAIL PROTECTED]> wrote:
Hi Alessandro, > Bye i have an serios problem with the command revExecuteSQL !!! not > work into my db sql. > 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! ------ > On 11/10/05 1:10 AM, "Harvey Toyama" <[EMAIL PROTECTED]> wrote: > then it looks like you forgot the semicolon, e.g., > > revExecuteSQL it,"INSERT INTO Anagrafica (id, Codice) values (NULL, > 22);" I do not think so. Semicolon is optional here It is required only if you have several SQL commands. ------ > On 11/10/05 1:58 AM, "Hershel Fisch" <[EMAIL PROTECTED]> wrote: > Looks like u r missing the "'" surrounding the values. > Hershel No, because NULL is keyword, and numbers as 22 go without quotes. Single quote is required only around string constants. ---------- Alessandro, I think you should check if some error code is reported. All looks correct in your query. I do not see any logical mistake. So or some db problems or some db structure gifts, e.g. If field ID specified that it can get NULLs ? -- Best regards, Ruslan Zasukhin VP Engineering and New Technology Paradigma Software, Inc Valentina - Joining Worlds of Information http://www.paradigmasoft.com [I feel the need: the need for speed] _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
