View Single Post
  #6  
Old 1st October 2003, 07:26 AM
Ole Willy Tuv
 
Posts: n/a
Default Re: Assigning NULL to a Prepared SQL DateTime Field

<< When I try:

Q.Params[0].Clear;

I get the following exception: Invalid date/time format [no error code] >>

As a last shot, try:

Q.Params[0].Value := Null;

If you get the same error, I'm out of ideas ;-)

<< Also, Where is NUL defined? >>

NULL (not NUL) is defined in Variants.pas (D6/D7) or System.pas (D5).

Ole Willy Tuv