Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Copying Dbf to SQL
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01555166
Message ID:
01556151
Views:
76
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform