Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Server numeric(1,0)
Message
De
27/01/1999 17:40:02
 
 
À
26/01/1999 18:12:42
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00180305
Message ID:
00181092
Vues:
22
[snip]
>SELECT ... FROM ... WHERE column = ?TRUE
>
>The database engine (VFP's) and ODBC will handle the conversion for you.
>

Sorry I wasn't clear enough :( By "dealing with the differences" I meant that, since the app was concurrent in VFP and SS, we wanted our SELECTs to look as similar as possible between the local and remote views, for maintenance reasons. Some things just can't be done the same in both - in this case, WHERE lLogical = .F. needs to be WHERE lLogical = 0 (for bit types). The ODBC driver doesn't handle that type of difference, and these views were too complex for the view designer. But it's true, the ODBC driver handles that conversion quite well.

[snip]
>You could have used a TinyInt. It has a size of one byte.
>

I keep forgetting that SS has several integer types. Thanks for the tip! :)

>I can't explain the behavior that you're seeing, sorry.

Yeah - with nearly 30 years combined experience at our shop, we couldn't figure it out either.


>
>-Mike
Insanity: Doing the same thing over and over and expecting different results.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform