Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Select expression for both VFP and SQL DB
Message
De
29/03/2019 15:06:08
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01667660
Message ID:
01667730
Vues:
38
>I found another alternative:
>
>
>PRIVATE plValue
>plValue= .F.
>
>Select  ?plValue AS MYFIELD
>
Check that in a profiler. I guess you get something like

exec sp_executesql 'select @p1 as myfield', '@p1', 0

sent to the SQL. IOW I'm not sure it gets cast as bit when sending like this. Perhaps there's a declaration of '@p1 bit'... better check.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform