Hi guys,
I have 3 dbs connected such as "abcd.db" "abcdu.db" and "utlcomu.db". these are the logical names and abcd.db contains all the standard QAD tables where as abcdu.db and utlcomu.db contains customized tables. Now in a query i am taking input as the table name to search the fields. By default it is working for abcd.db but for other dbs it is not working. It's searching for a db extension before the table name, but from the front end it is not possible for me to pass the DB extension... please refer the example.
this is correctly working for abcd.db related table.
but for the tables related to other 2 tables are searching for a db extension such as "abcdu.xx_tbl". which is not possible for me to pass through m_db to run the query.
if i write the query as :
Then i am getting error as m_db is not a valid database name.
please help to resolve this.
appreciate your response on this.
I have 3 dbs connected such as "abcd.db" "abcdu.db" and "utlcomu.db". these are the logical names and abcd.db contains all the standard QAD tables where as abcdu.db and utlcomu.db contains customized tables. Now in a query i am taking input as the table name to search the fields. By default it is working for abcd.db but for other dbs it is not working. It's searching for a db extension before the table name, but from the front end it is not possible for me to pass the DB extension... please refer the example.
Code:
define variable m_tbl as character no-undo.
define variable m_db as character no-undo.
update m_tbl m_db with frame a.
find first _file where _file-name = m_tbl no-lock no-error.
if avail _file then
disp _file with 2 col.
but for the tables related to other 2 tables are searching for a db extension such as "abcdu.xx_tbl". which is not possible for me to pass through m_db to run the query.
if i write the query as :
Code:
define variable m_tbl as character no-undo.
define variable m_db as character no-undo.
update m_tbl m_db with frame a.
find first m_db._file where _file-name = m_tbl no-lock no-error.
if avail m_db._file then
disp m_db._file with 2 col.
Then i am getting error as m_db is not a valid database name.
please help to resolve this.
appreciate your response on this.
Last edited by a moderator: