Re: Bit Datatype - Solved

Its SQL Express 2005

Ok - at least now I know I wasnt going crazy and "True" - "False" does work.

I deleted the table - re-created it without any joins and it worked.

I suspect I know what I did. - all user error and i should have rtfs when i
did a relationship.
I have another table called Login with a key LoginID - no nulls

here is a notes table so the keys are
NoteID - no nulls
LoginID - allow nulls here

I am suspecting the error was not actually an error on the boolean/bit field
but an error wth a wrong relationship.
It looks like the error is with the Bit field - but the bit field is my last
field in my whole table.

The only way I can re-create the error is doing a stupid relationship to
LoginID with NotID instead of Note-LoginID.
When you get to the last field ( in this case the bool field ) it errors
out -but not because of the field - because it cant join up the tables.

Thanks for your help.
-Super hard googling for key words like "bit" / "boolean" / "yes" / "no"
"VB.net" "datatype"

And back to learning...

Miro





"Mark S. Milley, MCSD (BinarySwitch)" <mark.milley@xxxxxxxxxxxxxxxx> wrote
in message news:1183640790.072008.259770@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi Miro -

True and False as values work on my end. Really, the values are stored
as -1 and 0 respectively.

Try putting in some data into all the other columns first (at least,
any that can't be null and don't have a default value). Then refresh
the table, and see how your interface is reporting the False value
that should be inserted on the DB side. After that, you should be able
to determine what to use for True (whatever the syntactic antonym is).

By the way, what are you using for a database? MS SQL Server 2005?

Cheers,

-Mark



.

Relevant Pages

  • Re: Standard Programming Languages
    ... proficient in SQL and C, I suspect the goal of all of these products ... I suspect that the average analyst/investor is not familiar ... SQL or C. IMO, if they do not achieve the previously mentioned goal, ...
    (misc.invest.stocks)
  • Re: DATABSE IS SUSPECT BECAUSE OF MISSING FILES
    ... situation including resetting the suspect status. ... Andrew J. Kelly SQL MVP ... > missing files that SQL needs in order to remove the DB ...
    (microsoft.public.sqlserver.connect)
  • Re: Automatic generation of SQL commands using a data adapter
    ... connection and data adapters to the project and all the SQL ... >I am going to re-create the the DB with the same specification ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Mirror one table from 1 db to another
    ... I suspect the answer is no. ... issue some SQL to merge regularly. ... Your inserting rows present on DB B that are not present on DB ... The WHERE clause filters out all the rows where all nonPKfields are ...
    (microsoft.public.data.ado)
  • Re: 3vl 2vl and NULL
    ... It seems you can't accommodate the SQL outcomes because it doesn't have a "shape" that you are comfortable with. ... I suspect you feel that "softness" weakens the process more so than the ... In my view the 2VL/MV actually allows, nay encourages, that "softness" to find its way into the repository, which in the wrong hands is a Bad Thing tm. ... The vast number of cursor happy application developers are a testament to that. ...
    (comp.databases.theory)