Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
A combo with the rowsourcetype = SQL Statement
Message
From
05/10/2009 13:10:09
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
A combo with the rowsourcetype = SQL Statement
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01427773
Message ID:
01427773
Views:
137
Hi All:

I have a combo class with the rowsourcetype = SQL Statement.

The statement reads thus:
sele dist Cde from itlook where cnatable = 'PRTDISP' into curs "Z"+ substr(sys(2015),3,10)
The itlook table contains two possible values, 'Display' or 'Print'.

This problem started when I wrote the init method:

In the init I have:
this.Value = 'Display'
In some forms that use this combo, I'm getting the following message when instantiating the form:
Cannot access the selected table
It then appends the SQL code.

Again, This problem started when I wrote the init method.

What gives?

Yossi
Next
Reply
Map
View

Click here to load this message in the networking platform