MySQL Forums
Forum List  »  Delphi

Query Parameter value assigned to bit field
Posted by: Man Fan
Date: July 18, 2012 07:30AM

We have a table field defined as bit to represent as boolean field.

However, I have problem in assigning 'true/false' to the field.

Query1.ParamByName('NewEmployee').Value := 1;

It did not save as true or false.

Had tried:
Query1.ParamByName('NewEmployee').AsSmallInt := 1;
Query1.ParamByName('NewEmployee').AsBoolean := True;

All did not work.

Options: ReplyQuote

Written By
Query Parameter value assigned to bit field
July 18, 2012 07:30AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.