Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Special characters and SQL Server
Message
 
 
À
10/06/2009 16:44:47
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Vista
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01405053
Message ID:
01405059
Vues:
113
This message has been marked as the solution to the initial question of the thread.
It's simpler and more reliable to use SPT parameters
lcCommand  = [INSERT INTO GENERALSETUP (chaudnomen1)) VALUES (?m.chaudnomen1)]
>I use VfpEncryption.fll to encrypt some of the data. When I try to upload a table, which contains the encrypted information onto a MSSQL database, the insert is failed.
>
>Here is my insert command
>
>TEXT TO lcCommand NOSHOW TEXTMERGE 
>	INSERT INTO GENERALSETUP (chaudnomen1)) VALUES ('<<m.chaudnomen1>>')
>ENDTEXT 	
>lr = SQLEXEC(Handle, lcCommand) 
>
>If I STRTOFLE(lcCommand,…) here is what the command looks like
>INSERT INTO GENERALSETUP (chaudnomen1)) VALUES ('I­õUú.á÷þ_ :_¨âÍ_²UAÝ@Š
>ÄžÂ_.fðgÅÁª’Nº
>)Í4_€ì_oh8‹‹…V_þ;4`7ç_6à')
>
>What do I need to do to make it load into my MSSQL data?
>
>Thank you
>Yelena
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform