General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>I have a combo-based class that has the SQL in the init of the class. There's a custom property of the class that tells the name of the table to get the data from.
>>
>>This class worked fine in Tripsoft. Now I'm using it in a new app, and it tells me it can't find the table.
>>
>>The table is in the database, which is open and the current database. The table, as well as the database, is in the path.
>>
>>I don't have the table in the DE because there are a _lot_ of look-up tables and I'd rather just have the select open it up. I have no idea why it can't find it.
>>
>>Any ideas?
>>
>>Thanks,
>>
>>-Michelle
>
>Michelle- I read the whole thread and saw that you solved the problem, but thought I might offe rsome insight as to what probably happened:
>
>Since you are using a Private Datasession in your form, the database being opened in the defualt or calling form's datasession has no effect. So as soon as your form instanciated, the new datasession went into effect and no database was open. Even if you opened the database in the form.init, it was not open in the the control's init event because the form instanciates from the inside out: control.init runs before form.init. SO to have the database open in the new DS, oyu would either have to open the DB in the Form.Load, or the DE.BeforeOpenTables event, or have member tables present in the DE. I'll guess that you had none of the above?
Actually, I had the last one, which is why I assumed the DB was being opened. (Yeah, I know how to take that word apart..)
Anyway, it turns out I had the path wrong after all. I was putting "fireapp" instead of "fire app" as the directory. It's working fine now.
Thanks,
-Michelle
Previous
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