Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange char in column name
Message
From
14/09/2014 22:48:05
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
 
To
14/09/2014 13:06:54
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 8.1
Network:
SAMBA Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01607500
Message ID:
01607514
Views:
49
>>
>>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]
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform