Groups > microsoft.public.scripting.vbscript > #11423

Re: SQLite with VBScript UDF?

Newsgroups	microsoft.public.scripting.vbscript
Date	2016-11-22 14:12 -0800
References	(6 earlier) <76833a9e-cc38-4d59-adc4-719c01742639@googlegroups.com> <o11vap$7k9$1@dont-email.me> <o12039$aqs$1@dont-email.me> <4a3f1682-ca42-4769-bf4c-51ff8cf9e00d@googlegroups.com> <o129ov$gvk$1@dont-email.me>
Message-ID	<0525a034-a6ac-4103-8731-26054b8cdf7d@googlegroups.com> (permalink)
Subject	Re: SQLite with VBScript UDF?
From	bart.smissaert@gmail.com

Show all headers | View raw

> Since it's interpreted there's no way to handle addresses.

I was thinking about that. Excel or for example or a VB6 ActiveX dll are running
and you can than get the address of a procedure that is loaded in memory.
With VBScript however nothing runs till the .vbs file with the procedure you want to use as a UDF is actually called. Would it actually be possible to call 
the .vbs file first and then directly after get the address of that procedure you want to use as a UDF. All looks a bit complex to me.

RBS


On Tuesday, 22 November 2016 20:28:55 UTC, Mayayana  wrote:
> <bart.smissaert@gmail.com> wrote
> 
> | As GetRef produces an object not sure this can be used to provide an 
> address pointer to a procedure. Would be very interesting indeed if this 
> could work!
> | Can't see much about all this on the internet and not sure if anybody has 
> used
> | VBScript as a store for SQLite UDF's.
> 
>   I don't know anything about SQLite, but for
> what it's worth...
> 
>   I've never seen any point to GetRef. My sense is
> that it's included to maintain consistency. Their
> example is senseless. They show this:
> 
> Set Window.Onload = GetRef("GetRefTest")
> 
>   Which calls GetRefTest onload. But that can be
> done with Sub window_onload. It can also be
> done with unload=  in the body tag.
> 
>   With VBScript there are no pointers and no
> direct datatype access. All variables are variants
> or objects. Since it's interpreted there's no way
> to handle addresses. The only partial exception is
> that a method that takes a defined datatype will
> sometimes work with a literal. For instance,
> VBS can handle a dispatch function, but what
> if the function is contains a long parameter?
> You can sometimes send return = SomeFunction(10)
> where x = 10: return = someFunction(x) would not
> work. (I can't think of an example offhand, but I've
> run into that with some Windows functionality that's
> script-accessible but not designed for script.

Back to microsoft.public.scripting.vbscript | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

SQLite with VBScript UDF? bart.smissaert@gmail.com - 2016-11-21 02:04 -0800
  Re: SQLite with VBScript UDF? JJ <jj4public@vfemail.net> - 2016-11-21 23:17 +0700
    Re: SQLite with VBScript UDF? bart.smissaert@gmail.com - 2016-11-21 09:14 -0800
  Re: SQLite with VBScript UDF? GS <gs@v.invalid> - 2016-11-21 15:21 -0500
    Re: SQLite with VBScript UDF? bart.smissaert@gmail.com - 2016-11-21 13:03 -0800
      Re: SQLite with VBScript UDF? GS <gs@v.invalid> - 2016-11-21 16:11 -0500
        Re: SQLite with VBScript UDF? bart.smissaert@gmail.com - 2016-11-21 13:19 -0800
          Re: SQLite with VBScript UDF? GS <gs@v.invalid> - 2016-11-21 16:31 -0500
            Re: SQLite with VBScript UDF? bart.smissaert@gmail.com - 2016-11-21 13:40 -0800
              Re: SQLite with VBScript UDF? GS <gs@v.invalid> - 2016-11-22 12:30 -0500
                Re: SQLite with VBScript UDF? GS <gs@v.invalid> - 2016-11-22 12:43 -0500
                Re: SQLite with VBScript UDF? bart.smissaert@gmail.com - 2016-11-22 11:02 -0800
                Re: SQLite with VBScript UDF? GS <gs@v.invalid> - 2016-11-22 14:19 -0500
                Re: SQLite with VBScript UDF? "Mayayana" <mayayana@invalid.nospam> - 2016-11-22 15:27 -0500
                Re: SQLite with VBScript UDF? bart.smissaert@gmail.com - 2016-11-22 14:12 -0800
                Re: SQLite with VBScript UDF? "Mayayana" <mayayana@invalid.nospam> - 2016-11-22 17:34 -0500
                Re: SQLite with VBScript UDF? bart.smissaert@gmail.com - 2016-11-22 15:22 -0800
                Re: SQLite with VBScript UDF? "Mayayana" <mayayana@invalid.nospam> - 2016-11-22 20:06 -0500
                Re: SQLite with VBScript UDF? bart.smissaert@gmail.com - 2016-11-22 17:42 -0800
                Re: SQLite with VBScript UDF? Schmidt <ng@vbRichClient.com> - 2016-11-26 15:23 +0100
                Re: SQLite with VBScript UDF? GS <gs@v.invalid> - 2016-11-26 15:21 -0500
                Re: SQLite with VBScript UDF? bart.smissaert@gmail.com - 2016-11-27 08:11 -0800
                Re: SQLite with VBScript UDF? bart.smissaert@gmail.com - 2016-11-27 12:59 -0800
                Re: SQLite with VBScript UDF? bart.smissaert@gmail.com - 2016-11-28 07:39 -0800
                Re: SQLite with VBScript UDF? Schmidt <ng@vbRichClient.com> - 2016-11-28 18:28 +0100
                Re: SQLite with VBScript UDF? bart.smissaert@gmail.com - 2016-11-29 05:59 -0800
                Re: SQLite with VBScript UDF? Schmidt <ng@vbRichClient.com> - 2016-11-29 22:01 +0100
                Re: SQLite with VBScript UDF? bart.smissaert@gmail.com - 2016-11-29 13:35 -0800
                Re: SQLite with VBScript UDF? Schmidt <ng@vbRichClient.com> - 2016-11-30 06:31 +0100
                Re: SQLite with VBScript UDF? bart.smissaert@gmail.com - 2016-11-29 13:01 -0800
                Re: SQLite with VBScript UDF? Schmidt <ng@vbRichClient.com> - 2016-11-30 06:51 +0100
                Re: SQLite with VBScript UDF? bart.smissaert@gmail.com - 2016-11-30 00:17 -0800
                Re: SQLite with VBScript UDF? Schmidt <ng@vbRichClient.com> - 2016-11-30 10:50 +0100
                Re: SQLite with VBScript UDF? bart.smissaert@gmail.com - 2016-11-30 02:45 -0800
                Re: SQLite with VBScript UDF? bart.smissaert@gmail.com - 2016-12-01 02:40 -0800

csiph-web