Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why do queries take longer in a private datasession?
Message
 
 
To
21/07/1999 15:19:11
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00244276
Message ID:
00244342
Views:
12
I think you may be making this harder than need be. Try creating a local, parameterized view:

create sql view RptCursor as select * from Imprn where PrintNo = ?nPrintNo

Then in your form DE, you can add this view. Set the NoDataOnLoad to .T. and in the BeforeOpenTables, put set talk off. In the click, put this code:

local nPrintNo
nPrintNo = thisform.txt_printno.value
requery("RptCursor")

Add whatever other code you need around this.
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform