On Tue, Jan 31, 2017 at 7:35 AM, Mike Kerner via use-livecode <
use-livecode@lists.runrev.com> wrote:
> SELECT table_name FROM information_schema.tables WHERE
> table_schema='public' AND table_type='BASE TABLE';
>
It wasn't so much getting the names, but trying to find out what the db
thought it
try put word 1 to -1 of theRes into theRes. Maybe there is a cr in there
somewhere.
Bob S
On Jan 30, 2017, at 19:03 , Dr. Hawkins via use-livecode
mailto:use-livecode@lists.runrev.com>> wrote:
theRes holds "dhbk_lcnsees", as it should. The name was created,
found in revDatabaseTableNames,
an
Oh PostGre I am out of my league then.
Bob S
On Jan 31, 2017, at 07:27 , Dr. Hawkins via use-livecode
mailto:use-livecode@lists.runrev.com>> wrote:
It's postgreSQL
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to
I always query the master table for the table names. Get the sql column which
is the create statement, from which you can parse the column names.
Bob S
> On Jan 30, 2017, at 18:29 , Dr. Hawkins via use-livecode
> wrote:
>
> After opening a database, I check for the names of a table
>
> *pu
SELECT * FROM information_schema.columns
That's from
http://stackoverflow.com/questions/21728073/postgressql-search-all-tables-of-a-database-for-a-field-called-like-active
or
SELECT table_name FROM information_schema.tables WHERE
table_schema='public' AND table_type='BASE TABLE';
from
http://
On Mon, Jan 30, 2017 at 8:07 PM, Mike Kerner via use-livecode <
use-livecode@lists.runrev.com> wrote:
> What's the type of db, and did you try sending a pragma to pull the table
> names to doublecheck?
>
It's postgreSQL
I'll be doing that kind of read today. I was so mystified yesterday, and
my
What's the type of db, and did you try sending a pragma to pull the table
names to doublecheck?
On Mon, Jan 30, 2017 at 10:54 PM, Mike Bonner via use-livecode <
use-livecode@lists.runrev.com> wrote:
> I'm at a loss then.
>
> On Mon, Jan 30, 2017 at 8:06 PM, Dr. Hawkins via use-livecode <
> use-li
I'm at a loss then.
On Mon, Jan 30, 2017 at 8:06 PM, Dr. Hawkins via use-livecode <
use-livecode@lists.runrev.com> wrote:
> On Mon, Jan 30, 2017 at 7:03 PM, Dr. Hawkins wrote:
>
> > theRes holds "dhbk_lcnsees", as it should. The name was created, found
> in revDatabaseTableNames,
> > and filter
On Mon, Jan 30, 2017 at 7:03 PM, Dr. Hawkins wrote:
> theRes holds "dhbk_lcnsees", as it should. The name was created, found in
> revDatabaseTableNames,
> and filtered to the sole line of theRes.
>
I just checked with 7.1.4 rc and got the same behavior.
--
Dr. Richard E. Hawkins, Esq.
(70
On Mon, Jan 30, 2017 at 6:41 PM, Mike Bonner via use-livecode <
use-livecode@lists.runrev.com> wrote:
> Most likely thing I can think of is that on opening the database, something
> is wrong with the path so it created a new and empty database.. somewhere..
> Just to test, I would "put theRes" and
Most likely thing I can think of is that on opening the database, something
is wrong with the path so it created a new and empty database.. somewhere..
Just to test, I would "put theRes" and see whats actually in there.
On Mon, Jan 30, 2017 at 7:29 PM, Dr. Hawkins via use-livecode <
use-livecode@l
11 matches
Mail list logo
