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

Re: SQLite with VBScript UDF?

Newsgroups	microsoft.public.scripting.vbscript
Date	2016-11-30 02:45 -0800
References	(18 earlier) <88fec54b-eff8-466c-8ec2-7593153cbb80@googlegroups.com> <c93cff42-9b1a-4f55-8bc6-7190a78f1e2f@googlegroups.com> <o1lpad$m60$1@dont-email.me> <37dcde4b-f939-49e2-b793-98a15db37462@googlegroups.com> <o1m7av$sqi$1@dont-email.me>
Message-ID	<824f4274-8417-45cb-8976-810664860346@googlegroups.com> (permalink)
Subject	Re: SQLite with VBScript UDF?
From	bart.smissaert@gmail.com

Show all headers | View raw

On Wednesday, 30 November 2016 09:50:38 UTC, Schmidt  wrote:
> Am 30.11.2016 um 09:17 schrieb bart.smissaert@gmail.com:
> 
> > There are 2 other alternative approaches that I can see that are easy.
> > 1. Use TCL for the UDF's. I understand this is well integrated with SQLite and it might be faster as well.
> 
> It might - never tried it, would be interesting to see an example...
> 
> > 2. Go back to using all vbRichClient5 functionality, including cConnection etc.
> > No idea though then how to use UDF's from VBA. Would it be possible you could add the option to use a procedure address pointer with 
> A VBA-Class (of a 32Bit-Excel-Installation) can Implement IFunction 
perfectly fine

OK, didn't realise that and that is interesting. Will give the cUDF class a
go first and take it from there. Thanks for the assistance.

RBS


Cnn.AddUserDefinedFunction, instead of a class that implements IFunction?
> 
> A VBA-Class (of a 32Bit-Excel-Installation) can Implement IFunction
> perfectly fine (and thus would be usable as an "SQLite-UDF-Container"
> without problems, no delegation to VBScript needed from there).
> 
> The other alternative (in case you want to go "low-level") would be,
> to use the already mentioned Cnn.DBHdl-property of the cConnection -
> (then doing your own thing - against the Flat-API in vb_cairo_sqlite.dll)
> 
> Olaf

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