General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Manually Open a View in a private DataSession
I am trying to open a view in a private datasession to check if a record exist on the database server. If it does not I want to insert a record.
The database server will not always be available. If it is not I want to go ahead and open the form with the vfp tables that are in it.
There are no controls tied to the view.
I am not sure how to trap if the database server is not available. If I have it to open automatically in the dataenviroment. I get the mysql error "can not connect" and then the form is closed. I have not been able to trap this and go ahead and open the rest of the tables.
So I thought I would manually open the view and if there was an error cancel opening the view. I took the view out of the data environment and in the click event of a button used the following code. "Use myview in 0". This works if the forms datasession is set to default.
If it is set to private then I get an error saying "File C:\mbc5\.dbc does not exist.". The form then closes. The mbc5.dbc that the view is in is actually in a directory mapped to M. The vfp dbf tables that are in the dbc are open and showing when I try this statement.
What am I doing wrong?
Randy
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only