Rocksolid Light

Welcome to RetroBBS

mail  files  register  newsreader  groups  login

Message-ID:  

Love makes the world go 'round, with a little help from intrinsic angular momentum.

devel / comp.lang.clipper.visual-objects / SQLListTables:Destroy

SubjectAuthor
* SQLListTables:DestroyHenry Fidler
`* Re: SQLListTables:DestroyWolfgang Riedmann
 `* Re: SQLListTables:DestroyHenry Fidler
  `* Re: SQLListTables:DestroyWolfgang Riedmann
   `* Re: SQLListTables:DestroyHenry Fidler
    +- Re: SQLListTables:DestroyWolfgang Riedmann
    `- Re: SQLListTables:DestroyJamal

1
SQLListTables:Destroy

<7d1c9a79-3655-414c-b7cc-70e8e6623256n@googlegroups.com>

  copy mid

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

  copy link   Newsgroups: comp.lang.clipper.visual-objects
X-Received: by 2002:ac8:5815:: with SMTP id g21mr47383944qtg.266.1626088226202;
Mon, 12 Jul 2021 04:10:26 -0700 (PDT)
X-Received: by 2002:a37:a154:: with SMTP id k81mr8000688qke.202.1626088226012;
Mon, 12 Jul 2021 04:10:26 -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, 12 Jul 2021 04:10:25 -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: <7d1c9a79-3655-414c-b7cc-70e8e6623256n@googlegroups.com>
Subject: SQLListTables:Destroy
From: zodcomag@gmail.com (Henry Fidler)
Injection-Date: Mon, 12 Jul 2021 11:10:26 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
 by: Henry Fidler - Mon, 12 Jul 2021 11:10 UTC

After using the SQLListTables, the program crash with an error "SQLListTables:Destroy is not an exported method".

At the end of using the class, I tried to assign to it a Null_Object, but it does not help.

I read in this forum in: “https://groups.google.com/g/comp.lang.clipper.visual-objects/c/DE2TT2Uc0xs/m/pi--85ZIN2UJ”
That replacing the VO28SQL.DLL from SP2 with that from SP1 helps.
Not in my case.

Any help
Henry

Re: SQLListTables:Destroy

<il324tF2058U1@mid.individual.net>

  copy mid

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

  copy link   Newsgroups: comp.lang.clipper.visual-objects
Path: i2pn2.org!i2pn.org!news.swapon.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: wriedmann@gmail.com (Wolfgang Riedmann)
Newsgroups: comp.lang.clipper.visual-objects
Subject: Re: SQLListTables:Destroy
Date: Mon, 12 Jul 2021 16:32:59 +0200
Lines: 26
Message-ID: <il324tF2058U1@mid.individual.net>
References: <7d1c9a79-3655-414c-b7cc-70e8e6623256n@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit
X-Trace: individual.net fZjw6ONURavd4JgHbQYgZwJvrUYNlXdjbwnUNfpwDVOZUVULM=
Cancel-Lock: sha1:bJjzwAX5S8yM/y/FcA3lb1o5m5k=
User-Agent: XanaNews/1.18.1.6
 by: Wolfgang Riedmann - Mon, 12 Jul 2021 14:32 UTC

Hi Henry,

what VO version dou you are using?

Wolfgang

Henry Fidler wrote:

> After using the SQLListTables, the program crash with an error
> "SQLListTables:Destroy is not an exported method".
>
> At the end of using the class, I tried to assign to it a Null_Object,
> but it does not help.
>
> I read in this forum in:
> “https://groups.google.com/g/comp.lang.clipper.visual-objects/c/DE2T
> T2Uc0xs/m/pi--85ZIN2UJ” That replacing the VO28SQL.DLL from SP2
> with that from SP1 helps. Not in my case.
>
> Any help
> Henry

--

Re: SQLListTables:Destroy

<79fce97f-d8fe-4b43-a6e1-46fe174116abn@googlegroups.com>

  copy mid

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

  copy link   Newsgroups: comp.lang.clipper.visual-objects
X-Received: by 2002:ad4:4690:: with SMTP id bq16mr3088263qvb.23.1626154169535;
Mon, 12 Jul 2021 22:29:29 -0700 (PDT)
X-Received: by 2002:a37:44cc:: with SMTP id r195mr2444434qka.478.1626154169396;
Mon, 12 Jul 2021 22:29:29 -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, 12 Jul 2021 22:29:29 -0700 (PDT)
In-Reply-To: <il324tF2058U1@mid.individual.net>
Injection-Info: google-groups.googlegroups.com; posting-host=87.102.215.94; posting-account=FsGVgwoAAAAo88J9fd3ig_ravrDh6B2l
NNTP-Posting-Host: 87.102.215.94
References: <7d1c9a79-3655-414c-b7cc-70e8e6623256n@googlegroups.com> <il324tF2058U1@mid.individual.net>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <79fce97f-d8fe-4b43-a6e1-46fe174116abn@googlegroups.com>
Subject: Re: SQLListTables:Destroy
From: zodcomag@gmail.com (Henry Fidler)
Injection-Date: Tue, 13 Jul 2021 05:29:29 +0000
Content-Type: text/plain; charset="UTF-8"
 by: Henry Fidler - Tue, 13 Jul 2021 05:29 UTC

CaVo 2.8, SP2
I tried to copy the Vo28SQL.dll from 2.8 SP1
Henry

Re: SQLListTables:Destroy

<il4vk0Fd7g6U1@mid.individual.net>

  copy mid

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

  copy link   Newsgroups: comp.lang.clipper.visual-objects
Path: i2pn2.org!i2pn.org!news.swapon.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: wriedmann@gmail.com (Wolfgang Riedmann)
Newsgroups: comp.lang.clipper.visual-objects
Subject: Re: SQLListTables:Destroy
Date: Tue, 13 Jul 2021 10:02:05 +0200
Lines: 22
Message-ID: <il4vk0Fd7g6U1@mid.individual.net>
References: <7d1c9a79-3655-414c-b7cc-70e8e6623256n@googlegroups.com> <il324tF2058U1@mid.individual.net> <79fce97f-d8fe-4b43-a6e1-46fe174116abn@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
X-Trace: individual.net 75TYXjDNFJ7t4ZmsxCXRwwQc5FOnADtua2oYYvIk5EnXabK04=
Cancel-Lock: sha1:rbXRbrhIpgD+X+T3KsvgMocLCfA=
User-Agent: XanaNews/1.18.1.6
 by: Wolfgang Riedmann - Tue, 13 Jul 2021 08:02 UTC

Hi Henry,

> CaVo 2.8, SP2
> I tried to copy the Vo28SQL.dll from 2.8 SP1

the easiest option for you would be to build a class

class SQLListTablesEx inherit SQLListTables

add a fancy Destroy() method:

method Destroy() class SQLListTablesEx

and use that class in your application.

I cannot check that as I have VO SP4b running and no access to any
previous version.

Wolfgang

--

Re: SQLListTables:Destroy

<85dea669-dba2-46ef-8f92-00e4cb0d390en@googlegroups.com>

  copy mid

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

  copy link   Newsgroups: comp.lang.clipper.visual-objects
X-Received: by 2002:ad4:56e4:: with SMTP id cr4mr6206208qvb.54.1626378244354;
Thu, 15 Jul 2021 12:44:04 -0700 (PDT)
X-Received: by 2002:a37:815:: with SMTP id 21mr5804930qki.122.1626378244202;
Thu, 15 Jul 2021 12:44:04 -0700 (PDT)
Path: i2pn2.org!i2pn.org!paganini.bofh.team!usenet.pasdenom.info!usenet-fr.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: Thu, 15 Jul 2021 12:44:03 -0700 (PDT)
In-Reply-To: <il4vk0Fd7g6U1@mid.individual.net>
Injection-Info: google-groups.googlegroups.com; posting-host=87.102.215.94; posting-account=FsGVgwoAAAAo88J9fd3ig_ravrDh6B2l
NNTP-Posting-Host: 87.102.215.94
References: <7d1c9a79-3655-414c-b7cc-70e8e6623256n@googlegroups.com>
<il324tF2058U1@mid.individual.net> <79fce97f-d8fe-4b43-a6e1-46fe174116abn@googlegroups.com>
<il4vk0Fd7g6U1@mid.individual.net>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <85dea669-dba2-46ef-8f92-00e4cb0d390en@googlegroups.com>
Subject: Re: SQLListTables:Destroy
From: zodcomag@gmail.com (Henry Fidler)
Injection-Date: Thu, 15 Jul 2021 19:44:04 +0000
Content-Type: text/plain; charset="UTF-8"
 by: Henry Fidler - Thu, 15 Jul 2021 19:44 UTC

Wolfgang many thanks

I did what you have suggested,
I do not know what the method Destroy() should do, so I have just
Self:Close()

Until now it works OK.

Thanks
Henry

Re: SQLListTables:Destroy

<ilcrtqFtcocU1@mid.individual.net>

  copy mid

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

  copy link   Newsgroups: comp.lang.clipper.visual-objects
Path: i2pn2.org!i2pn.org!news.swapon.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: wriedmann@gmail.com (Wolfgang Riedmann)
Newsgroups: comp.lang.clipper.visual-objects
Subject: Re: SQLListTables:Destroy
Date: Fri, 16 Jul 2021 09:48:09 +0200
Lines: 15
Message-ID: <ilcrtqFtcocU1@mid.individual.net>
References: <7d1c9a79-3655-414c-b7cc-70e8e6623256n@googlegroups.com> <il324tF2058U1@mid.individual.net> <79fce97f-d8fe-4b43-a6e1-46fe174116abn@googlegroups.com> <il4vk0Fd7g6U1@mid.individual.net> <85dea669-dba2-46ef-8f92-00e4cb0d390en@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
X-Trace: individual.net 1OzC4iR1uxVj2FWInlaGCgFLX7TfbBS5p0NE/cust/x4hhj7M=
Cancel-Lock: sha1:+iqlRwEYoCUCDKrq9n7gtIS2T/M=
User-Agent: XanaNews/1.18.1.6
 by: Wolfgang Riedmann - Fri, 16 Jul 2021 07:48 UTC

Hi Henry,

> I did what you have suggested,
> I do not know what the method Destroy() should do, so I have just
> Self:Close()
>
> Until now it works OK.

I had written an empty method, only to suppress the runtime error.

Wolfgang

--

Re: SQLListTables:Destroy

<scs59d$5lf$1@gioia.aioe.org>

  copy mid

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

  copy link   Newsgroups: comp.lang.clipper.visual-objects
Path: i2pn2.org!i2pn.org!aioe.org!5khQQ74EcbbAsV5j3NyilA.user.gioia.aioe.org.POSTED!not-for-mail
From: nospam@example.com (Jamal)
Newsgroups: comp.lang.clipper.visual-objects
Subject: Re: SQLListTables:Destroy
Date: Fri, 16 Jul 2021 10:32:16 -0400
Organization: Aioe.org NNTP Server
Lines: 27
Message-ID: <scs59d$5lf$1@gioia.aioe.org>
References: <7d1c9a79-3655-414c-b7cc-70e8e6623256n@googlegroups.com>
<il324tF2058U1@mid.individual.net>
<79fce97f-d8fe-4b43-a6e1-46fe174116abn@googlegroups.com>
<il4vk0Fd7g6U1@mid.individual.net>
<85dea669-dba2-46ef-8f92-00e4cb0d390en@googlegroups.com>
NNTP-Posting-Host: 5khQQ74EcbbAsV5j3NyilA.user.gioia.aioe.org
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Complaints-To: abuse@aioe.org
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101
Thunderbird/78.11.0
Content-Language: en-US
X-Notice: Filtered by postfilter v. 0.9.2
 by: Jamal - Fri, 16 Jul 2021 14:32 UTC

You were getting the error because there is no such Destroy() method for
the SQLListTables class.

The only two classes that have the Destroy() method are: SQLStatement
and SqlParameter classes. Unrelated, but just in case you use
SQLParameter, according to the SDK, "If you instantiate a SQLParameter
object, you should explicitly destroy it when you are finished using it".

And remember the Close() method only closes the cursor, not the connection.

Jamal

As you found, the Close() method should work fine.

On 7/15/2021 3:44 PM, Henry Fidler wrote:
> Wolfgang many thanks
>
> I did what you have suggested,
> I do not know what the method Destroy() should do, so I have just
> Self:Close()
>
> Until now it works OK.
>
> Thanks
> Henry
>

1
server_pubkey.txt

rocksolid light 0.9.8
clearnet tor