SQLQuery: How to assign a NULL value to a param?
lazarus / 16-Databases

----------------------------------------------------------------------
Jvan · 2021-06-03 02:05

How to do it?

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
SQLQuery1.ParamByName('my_field').AsFloat := NULL;

----------------------------------------------------------------------
bpranoto · 2021-06-03 03:21

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
SQLQuery1.ParamByName('my_field').Clear

----------------------------------------------------------------------
Jvan · 2021-06-03 03:55

I need the database field to have a null value.

----------------------------------------------------------------------
egsuh · 2021-06-03 04:25

Try following --- I found this but haven't tried myself... please let
us know the result 

SQLQuery1.ParamByName('my_field').Value := null;

----------------------------------------------------------------------
bpranoto · 2021-06-03 04:48

Quote from: Jvan on June 03, 2021, 05:55:19 amI need the database
field to have a null value.

Have you tried what I posted before?

----------------------------------------------------------------------
Jvan · 2021-06-03 04:59

It works, thanks.

----------------------------------------------------------------------
bum_bum · 2021-06-07 20:20

Quote from: egsuh on June 03, 2021, 06:25:23 amTry following --- I
found this but haven't tried myself... please let us know the result 

SQLQuery1.ParamByName('my_field').Value := null;
Perhaps it will be more correct
SQLQuery1.ParamByName('my_field').IsNull := True;

----------------------------------------------------------------------
Remy Lebeau · 2021-06-07 21:18

Quote from: bum_bum on June 07, 2021, 10:20:44 pmPerhaps it will be
more correct
SQLQuery1.ParamByName('my_field').IsNull := True;

TParam.IsNull is read-only.

----------------------------------------------------------------------
egsuh · 2021-06-08 01:11

I confirmed

Qr.params[ l ].value := null;

works.