>Got Insert working fine for Character fields, but cant get a 'Bit' field to update
>e.g. tried >> 1 , 'true' .t. , and get an error all the time
>
>Anybody know how to unpdate a BIt field in SQLSERVER using Insert
>Tia
>Gerard
TEXT TO lcSQL NOSHOW
INSERT INTO YourTable (BitField)
VALUES (?lbBit)
ENDTEXT
lbBit = .t.
? SQLEXEC(lnHandler, lcSQL )
lbBit = .f.
? SQLEXEC(lnHandler, lcSQL )
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.