Re: how to store value to a boolean field?

Insert into table1(field1) values(True)
or
Insert into table1(field1) values(1)

--
With best regards, Mike Shkolnik
Scalabium Software
http://www.scalabium.com
mshkolnik@xxxxxxxxxxxxx

"Naser" <n_fadaei@xxxxxxxxx> wrote in message
news:481f11a2@xxxxxxxxxxxxxxxxxxxxxxxxx
Hi. MS Access table has a Yes/No field.
how can I store a boolean value into the field using like this SQL
statement:
Insert into table1(field1) values("Yes")

p.s. I don't like use Parameters....




.

Relevant Pages

  • Re: how to store value to a boolean field?
    ... With best regards, Mike Shkolnik ... how can I store a boolean value into the field using like this SQL ...
    (borland.public.delphi.database.ado)
  • Re: How to work with multiple response sets in Access
    ... simple checkboxes. ... but it gets simpler if I have only one survey ... and a table to store each answer to each question for each survey ... store the values in a Boolean field in the answers table, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: General Question On Handling of Function results.t
    ... might confuse another programmer working new on the project, ... > Best Regards ... >> use exception handling if you do not see anny other way, ... but a simple boolean is not enough. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Delphi type events in C#
    ... Beste Grüsse / Best regards / Votre bien devoue ... procedure TMyNewEvent (Sender: TObject; MyStream: TStream; var MyFlag: boolean) Of Object; ... procedure DoMyEvent(Sender: TObject; AStream: TStream; var AFlag: boolean); ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Crash saving boolean value to RS (Row cannot be located...)
    ... Brendan Reynolds ... > Close RecordSet ... > The issue I'm dealing with is that I was attempting to store the Gender ... >> What if you give the Boolean field a default value. ...
    (microsoft.public.data.ado)