Gossamer Forum
Quote Reply
Extern table
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?
Subject Author Views Date
Thread Extern table Robert 7931 Aug 15, 2017, 5:42 AM
Post Re: [Robert] Extern table
Andy 7759 Aug 15, 2017, 9:21 AM
Post Re: [Robert] Extern table
socrates 7370 Sep 30, 2017, 11:19 PM
Thread Re: [Robert] Extern table
Robert 7383 Oct 2, 2017, 10:32 AM
Thread Re: [Robert] Extern table
Andy 7359 Oct 3, 2017, 10:56 PM
Post Re: [Andy] Extern table
Robert 7318 Oct 5, 2017, 12:46 AM
Thread Re: [Robert] Extern table
Robert 6914 Nov 23, 2017, 10:03 AM
Post Re: [Robert] Extern table
Andy 6889 Nov 23, 2017, 11:54 PM