Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Strange char in column name
Message
De
14/09/2014 22:48:05
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Allemagne
 
 
À
14/09/2014 13:06:54
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 8.1
Network:
SAMBA Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01607500
Message ID:
01607514
Vues:
50
>>
>>the SELCTCMD is defined by code. Its just like:
>>
>>THIS.SELCTCMD = 'SELECT Cur1.[Field "C"] FROM myTable AS Cur1'
>>
>>
>>Or I do not understand what you mean with catch.
>
>Are you sure you pasted this from your code? As the property name is .SelectCmd - note the typo you made twice here.
>
>What happens if you run the same command as SPT? And, BTW, why don't you give an alias to that field, i.e.
>
>
>THIS.SELECTCMD = 'SELECT Cur1.[Field "C"] as FieldC FROM myTable AS Cur1'
>
Nope, it's not a copy from my code. This is just like. The original statement is a bit longer, but that is what failed. And, I can't give the original statement. We have to simulate it. Alias was skiped in the example for lazyness. The real thing has it.

The typo was made once - this is called copy and paste error. :)

By SPT you mean to run it as SQLEXEC like
?SQLEXEC(m.lnHld,'SELECT Cur1.[Field "C"] AS FieldC FROM myTable AS Cur1')
?
This ends up the with same problem, was my first try after the CA failed. :(
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform