Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Pass Through Problem
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01063586
Message ID:
01063673
Views:
8
Kevin,

I wouldn't use ? parameters it makes the SPT execution a lot slower. Build your whole SQL string up and send that to your method.

>Ok, I see what is happening.
>
>As Aergey pointed out, the parameter values are dropping out of scope
>when the call to ._oSQLProcs.SQLCommand(sSqlCommand) happens.
>
>I'm open to suggesstions on the best way to do this.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform