Forum > Databases

SQLQuery: How to assign a NULL value to a param?

(1/2) > >>

Jvan:
How to do it?


--- Code: Pascal  [+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i < x.length; i++) { x[i].style.maxHeight='none'; x[i].style.height = Math.min(x[i].clientHeight+15,306)+'px'; x[i].style.resize = "vertical";}};} ---SQLQuery1.ParamByName('my_field').AsFloat := NULL;  

bpranoto:

--- Code: Pascal  [+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i < x.length; i++) { x[i].style.maxHeight='none'; x[i].style.height = Math.min(x[i].clientHeight+15,306)+'px'; x[i].style.resize = "vertical";}};} ---SQLQuery1.ParamByName('my_field').Clear

Jvan:
I need the database field to have a null value.

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

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

bpranoto:

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

--- End quote ---

Have you tried what I posted before?

Navigation

[0] Message Index

[#] Next page

Go to full version