serios problem with sql command

[Ruslan Zasukhin]

On 11/3/05 3:35 PM, "Alessandro Pisoni" <alessandro at system-ini.it> 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" <harvey.toyama at qlogic.com> 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" <hershrev at realtorsgroup.us> 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]