Devart Forums

Hi
How do I insert a NULL value in a query?

Q.SQL.Add('SELECT * FROM TABLE1');

Q.SQLINSERT.add('INSERT INTO TABLE1');
Q.SQLINSERT.add('(FIELD1, FIELD2)');
Q.SQLINSERT.add('VALUES');
Q.SQLINSERT.add('(:field1, field2)');

Q.open;

Q.insert;
Q.fieldByName('Field1').asInteger := NULL;
Q.fieldByName('Field2').asInteger := 4;
Q.Post;

That obviously wont work...
I have tried with .Clear, but got some exception..

Best regards
Jens Fudge

Hello,

You have an error in SQLInsert, the second parameter is written without colon.

You can use the following code:

AndreyZ wrote:Hello,

You have an error in SQLInsert, the second parameter is written without colon.

In case you hadn't noticed.. This is just example code off the top of my head..
I dont really have a table named Table1 with Field1 and Field2...

AndreyZ wrote:You can use the following code:

Code: Select all

Q.FieldByName('Field1').Value := NULL;

oh.. ok.. thanks