query .ParamByName - MSSQL 1

[castore]

D7 - MSSQL

I have a table with a numeric integer field that can accept Null
(Table -> T1 Field -> F1)

My elementary query is:
update T1 set F1 = aram

and then in my code:

query.ParamByName('param').AsInteger := 10;
query.Excecute;

It works fine.

But, how can i do if i want to set F1 to Null?
How must write ?
query.ParamByName('param').????? = Null ????

thanks to all
castore

 

[DjangMan]

How about:

query.ParamByName('param').Value := null;

Hmmm,

As I look at that I wonder if your query would work correctly. If you substitute your parameter value you 'might' get:

update T1 set F1 = NULL

If that doesn't work you could always re-set the SQL without using the parameter to:

query.sql.clear;
query.sql.add(
  'UPDATE T1'+
  ' SET'+
  ' F1=NULL'
);
query.execsql;

query.sql.clear;
query.sql.add(
  'UPDATE T1'+
  ' SET'+
  ' F1=:param'
);

Regards,

Django

 

[castore]

Thank Django
query.ParamByName('param').Value := null;
works !!!!

 

[ndaru]

Try:

Query1.ParamByName('param').Clear;

similarly, for the fields:

Query1.FieldByName('field').Clear;

http://www.freetechbooks.com