To work with an extern table with lsql is really easy; just add a .def and add the tablename to dbnav.html (admin templates); then resync and ready to go.
Now i have the problem that my lsql has a prefix, but the extern table not and i cant change this.
Lsql wants to work now with prefix_externtable.
Anyway i need to count something from this table; is this possible without the .def file and without the prefix in the name of the table?
Maybe we had this before, and you, Andy, has told me a solution how to query an extern table?
Now i have the problem that my lsql has a prefix, but the extern table not and i cant change this.
Lsql wants to work now with prefix_externtable.
Anyway i need to count something from this table; is this possible without the .def file and without the prefix in the name of the table?
Maybe we had this before, and you, Andy, has told me a solution how to query an extern table?