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 2503 Aug 15, 2017, 5:42 AM
Post Re: [Robert] Extern table
Andy 2443 Aug 15, 2017, 9:21 AM
Post Re: [Robert] Extern table
socrates 2070 Sep 30, 2017, 11:19 PM
Thread Re: [Robert] Extern table
Robert 2053 Oct 2, 2017, 10:32 AM
Thread Re: [Robert] Extern table
Andy 2028 Oct 3, 2017, 10:56 PM
Post Re: [Andy] Extern table
Robert 2010 Oct 5, 2017, 12:46 AM
Thread Re: [Robert] Extern table
Robert 1585 Nov 23, 2017, 10:03 AM
Post Re: [Robert] Extern table
Andy 1578 Nov 23, 2017, 11:54 PM