Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
A combo with the rowsourcetype = SQL Statement
Message
 
 
To
05/10/2009 13:10:09
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01427773
Message ID:
01427775
Views:
63
Can you use an alias for the combo's RowSource instead?

See also http://berezniker.com/content/pages/visual-foxpro/cannot-access-selected-table-error-1152

>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
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform