Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Database Glitch in Method: BeforeOpenTables()
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01343156
Message ID:
01344517
Views:
17
If I have referenced the database in which at least 4 tables are attached to it, why then should I have to do anything more than perhaps the following?

SET PATH TO THISANDTHAT
SET DATABASE TO WHATEVER
and reference the database and cursors in the BeforeOpenTables() method of the Data Environment?

I am forced by a dialog box to look for the tables within the database; the dialog box says it can't find the tables, yet when the dialog box opens, you readily see the tables right there; all I do is double click on them to select them. But, why does FoxPro present the dialog box? Why should I have to double click on the tables to access them? Is this a FoxPro bug, or did I miss some important point?

The below is in my DataEnvironment.BeforeOpenTables() event/method:
SET PATH TO e:\proddata\
OPEN DATABASE e:\proddata\prodschd.dbc
SET DATABASE TO e:\proddata\PRODSCHD.DBC
* DESC.DBF is not attached to the PRODSCHD.DBC database. So,
* it is not necessary to make a database reference for it.
This.Cursor2.Database="e:\proddata\prodschd.dbc"
This.Cursor3.Database="e:\proddata\prodschd.dbc"
This.Cursor4.Database="e:\proddata\prodschd.dbc"
This.Cursor5.Database="e:\proddata\prodschd.dbc"

This.Cursor1.CursorSource="E:\ProdData\Desc.dbf"
This.Cursor2.CursorSource="E:\ProdData\Carbon.dbf"
This.Cursor3.CursorSource="E:\ProdData\D3dept.dbf"
This.Cursor4.CursorSource="E:\ProdData\Deltodpt.dbf"
This.Cursor5.CursorSource="E:\ProdData\Inst1.dbf"
Previous
Reply
Map
View

Click here to load this message in the networking platform