Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot access the selected table
Message
From
13/07/2001 06:53:37
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
07/07/2001 00:23:08
Agnes Cheng
DynamicTech Consultants Ltd.
Hong Kong, Hong Kong
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00526869
Message ID:
00530146
Views:
31
>Bingo.. As I remove my combo box.
>There Is No Error Message!!!
>
>However, After I re-write the combo box'rowsoure..
>e.g ThisForm.cmbPayment.rowsource ="payment.code,name"
>
>It prompt another error ' Alias "payment" cannot find'
>It seems. close all the tables !! How can restore it ???
>
>Thanks In Advance.

Agnes,
If you do not have good reason to have RowsourceType as fields use SQL instead. It would open tables as necessary and tables would be closed upon form closure since it's a private datasession. ie:
with thisform.mycombo
 .Rowsourcetype =3 
 .Rowsource = 'select code,name from payment into cursor crsPayment'
endwith
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform