That's the part I don't understand : the variable is integer and the database field is also set to integer.

But with Dmitry's trick it works

In fact my question was :
when I want to insert TEXT, I escape the variable in the SQL Query with :

"'+text_variable+'"

what is the correct escape sequence for numbers ?

I think I forgot to answer this post to mention it worked of course.

But this still bothers me to convert Integer to strings before saving them into integer fields in database

I will  try that tomorrow morning  (it is 1 am here ).

But wath bothers me is the IntToStr because I am trying to insert  in a INTEGER databse field.  I do not understand why convert the integer into string before inserting into... integer 

I Will see that tomorrow morning first thing.

Cheers

Mathias

if main_cat > 0 then SQLExecute('UPDATE asset SET id_main_cat='+ IntToStr(main_cat) + ' WHERE id='+ IntToStr(current_asset_id));

Well, I am a bit ashamed to ask such a question, but I have problems INSERTING..... Integers....

Can someone show me what the correct syntax is ?

if main_cat > 0 then SQLExecute('UPDATE asset SET id_main_cat=' main_cat ' WHERE id=' current_asset_id);

main_cat and current_asset_id being INTEGERs of course AND the table fields are also SET to INTEGER.

Thanks in advance.

Cheers

Mathias