Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CA with parameter makes me crazy
Message
From
09/11/2006 03:20:19
 
 
To
08/11/2006 21:56:59
Max Chen
Yx Software
Shunde, China
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows Server 2003
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01168332
Message ID:
01168356
Views:
14
>Hello
>
>the CA.selectCMD with parameter does not work well as remote view before.
>
>Create a form, open dataEnvironment, add cursoradapter, set it with builder
>and type in ....
>
>select id_, fid_, tst_, code,name where name = ?(thisform.abcd)
>where name = (?thisform.abcd)
>
>All fail to create the cursor.
>
>But it will ok if "where name = ?(thisform.tag)".
>
>It seems different the between thisform.tag and thisform.abcd.
>
>(i sure that the thisform.abcd is existed.)
>
>I make me crazy. Plz help
>
>max.

Using an object name or an object value in a fumction, is generally a bad idea, use a variable instead. I am not sure that it will help in this specific case, but often a variable is very much faster.
lcAbcd=thisform.abcd
select id_, fid_, tst_, code,name where name = ?(lcAbcd)
Previous
Reply
Map
View

Click here to load this message in the networking platform