Re: Problem with bit field using MS Sql server and Turbo Delphi 2006

From: "Joachim Uersfeld" <uersfeld@xxxxxxxxxx>
Date: 26 Feb 2008 01:26:40 -0700

There is no Boolean type in MS SQL. Try this:

ThisValid : int;

if (something) <> 0) then
ThisValid := 1
else
ThisValid := 0;

Parameters.ParamByName('@gps_validity').Value := ThisValid;

Andy Stephenson wrote:

ThisValid : boolean;

if (something) <> 0) then
ThisValid := true
else
ThisValid := false;

Parameters.ParamByName('@gps_validity').Value := ThisValid;

Follow-Ups:
- Re: Problem with bit field using MS Sql server and Turbo Delphi 2006
  - From: Andy Stephenson

References:
- Problem with bit field using MS Sql server and Turbo Delphi 2006
  - From: Andy Stephenson

Prev by Date: Re: Used a reserved word in a field name.....
Next by Date: Re: XML import/export for ADO
Previous by thread: Problem with bit field using MS Sql server and Turbo Delphi 2006
Next by thread: Re: Problem with bit field using MS Sql server and Turbo Delphi 2006
Index(es):
- Date
- Thread