Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Copying Dbf to SQL
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01555166
Message ID:
01556151
Vues:
72
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform