Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Insert fields with a ' in them
Message
 
 
À
02/06/2015 08:16:58
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Allemagne
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01620334
Message ID:
01620479
Vues:
50
>>>>Gregory provided you with the correct way of using parameters. One possible gotcha - check out the types of the parameters, quite often VFP sends them wrongly (say, float for numeric, etc.) In those cases you can use CAST to correct type inside the ?mproperty, e.g.
>>>>
>>>>'cast(?mProperty as NUMERIC(17,0))'
>>>
>>>Try this with german standard
>>>
SET POINT TO ,
>>
>>I don't understand this reply. Did you mean another thread?
>
>Iif you cast to numeric and create a string out of it it will respect SET POINT. Then you have two fields out of one.

I'm not proposing to pass it as a string. Re-read my suggestion one more time.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform