Message-ID:

Due to lack of disk space, this fortune database has been discontinued.

devel / comp.lang.clipper.visual-objects / SQL Table list

SQL Table list

<55d531a5-7a67-412f-8332-621a5bb7f0f0n@googlegroups.com>

https://www.rocksolidbbs.com/devel/article-flat.php?id=857&group=comp.lang.clipper.visual-objects#857

copy link Newsgroups: comp.lang.clipper.visual-objects

X-Received: by 2002:a37:9445:: with SMTP id w66mr9861276qkd.410.1624895450970;
Mon, 28 Jun 2021 08:50:50 -0700 (PDT)
X-Received: by 2002:ae9:e30a:: with SMTP id v10mr9546189qkf.161.1624895450807;
Mon, 28 Jun 2021 08:50:50 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.clipper.visual-objects
Date: Mon, 28 Jun 2021 08:50:50 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-host=87.102.215.94; posting-account=FsGVgwoAAAAo88J9fd3ig_ravrDh6B2l
NNTP-Posting-Host: 87.102.215.94
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <55d531a5-7a67-412f-8332-621a5bb7f0f0n@googlegroups.com>
Subject: SQL Table list
From: zodcomag@gmail.com (Henry Fidler)
Injection-Date: Mon, 28 Jun 2021 15:50:50 +0000
Content-Type: text/plain; charset="UTF-8"

by: Henry Fidler - Mon, 28 Jun 2021 15:50 UTC

I try (CaVo 2.8 SP2)
oTables := SQLListTables{ , , , , oConn }
lOK := oTables:Execute() /// return True
cTables := oTables:TableName

cTable return empty string.

What is wrong?
Henry

Re: SQL Table list

<9e6e2ddd-7ea3-4106-bbe7-712b3b8d8a6cn@googlegroups.com>

copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=860&group=comp.lang.clipper.visual-objects#860

copy link Newsgroups: comp.lang.clipper.visual-objects

X-Received: by 2002:a37:345:: with SMTP id 66mr32192274qkd.499.1625068332090;
Wed, 30 Jun 2021 08:52:12 -0700 (PDT)
X-Received: by 2002:a37:8e81:: with SMTP id q123mr21351328qkd.188.1625068331973;
Wed, 30 Jun 2021 08:52:11 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.clipper.visual-objects
Date: Wed, 30 Jun 2021 08:52:11 -0700 (PDT)
In-Reply-To: <55d531a5-7a67-412f-8332-621a5bb7f0f0n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=87.102.215.94; posting-account=FsGVgwoAAAAo88J9fd3ig_ravrDh6B2l
NNTP-Posting-Host: 87.102.215.94
References: <55d531a5-7a67-412f-8332-621a5bb7f0f0n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <9e6e2ddd-7ea3-4106-bbe7-712b3b8d8a6cn@googlegroups.com>
Subject: Re: SQL Table list
From: zodcomag@gmail.com (Henry Fidler)
Injection-Date: Wed, 30 Jun 2021 15:52:12 +0000
Content-Type: text/plain; charset="UTF-8"

by: Henry Fidler - Wed, 30 Jun 2021 15:52 UTC

I found a workaround

oTables := SQLListTables{ ,, , 'Table', oConn }
lBack := oTables:Execute()
IF lBack
oTables:GoTop()
DO WHILE !oTables:EOF
cTable := oTables:FIELDGET(3) // 1-"Database name", 2-Null, 3-Table Name, 4-"Table", 5-Null
AAdd(a_Table, cTable)
oTables:Skip()
ENDDO
ENDIF

Henry

Subject	Author
SQL Table list	Henry Fidler
Re: SQL Table list	Henry Fidler