Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #13385 > unrolled thread

SQLListTables:Destroy

Started byHenry Fidler <zodcomag@gmail.com>
First post2021-07-12 04:10 -0700
Last post2021-07-16 10:32 -0400
Articles 7 — 3 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  SQLListTables:Destroy Henry Fidler <zodcomag@gmail.com> - 2021-07-12 04:10 -0700
    Re: SQLListTables:Destroy "Wolfgang Riedmann" <wriedmann@gmail.com> - 2021-07-12 16:32 +0200
      Re: SQLListTables:Destroy Henry Fidler <zodcomag@gmail.com> - 2021-07-12 22:29 -0700
        Re: SQLListTables:Destroy "Wolfgang Riedmann" <wriedmann@gmail.com> - 2021-07-13 10:02 +0200
          Re: SQLListTables:Destroy Henry Fidler <zodcomag@gmail.com> - 2021-07-15 12:44 -0700
            Re: SQLListTables:Destroy "Wolfgang Riedmann" <wriedmann@gmail.com> - 2021-07-16 09:48 +0200
            Re: SQLListTables:Destroy Jamal <nospam@example.com> - 2021-07-16 10:32 -0400

#13385 — SQLListTables:Destroy

FromHenry Fidler <zodcomag@gmail.com>
Date2021-07-12 04:10 -0700
SubjectSQLListTables:Destroy
Message-ID<7d1c9a79-3655-414c-b7cc-70e8e6623256n@googlegroups.com>
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

[toc] | [next] | [standalone]


#13387

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2021-07-12 16:32 +0200
Message-ID<il324tF2058U1@mid.individual.net>
In reply to#13385
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



-- 

[toc] | [prev] | [next] | [standalone]


#13388

FromHenry Fidler <zodcomag@gmail.com>
Date2021-07-12 22:29 -0700
Message-ID<79fce97f-d8fe-4b43-a6e1-46fe174116abn@googlegroups.com>
In reply to#13387
CaVo 2.8, SP2
I tried to copy the Vo28SQL.dll from 2.8 SP1
Henry

[toc] | [prev] | [next] | [standalone]


#13389

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2021-07-13 10:02 +0200
Message-ID<il4vk0Fd7g6U1@mid.individual.net>
In reply to#13388
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

-- 

[toc] | [prev] | [next] | [standalone]


#13393

FromHenry Fidler <zodcomag@gmail.com>
Date2021-07-15 12:44 -0700
Message-ID<85dea669-dba2-46ef-8f92-00e4cb0d390en@googlegroups.com>
In reply to#13389
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

[toc] | [prev] | [next] | [standalone]


#13394

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2021-07-16 09:48 +0200
Message-ID<ilcrtqFtcocU1@mid.individual.net>
In reply to#13393
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


-- 

[toc] | [prev] | [next] | [standalone]


#13395

FromJamal <nospam@example.com>
Date2021-07-16 10:32 -0400
Message-ID<scs59d$5lf$1@gioia.aioe.org>
In reply to#13393
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
> 

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web