Hi Olaf, Yes, I am aware of those functions in your COM wrapper and I am using them. Was just thinking in general terms as not many users on this forum use VB. Great news about the new version and will download and test that today. Thanks for that.
Bart On 9/11/12, Olaf Schmidt <s...@online.de> wrote: > Am 10.09.2012 17:17, schrieb Bart Smissaert: >> Ah, OK. I have a feeling that needs to be done either in your >> application code or with a user defined SQLite function. >> Somebody may prove me wrong. > > Hi Bart, > > since I know you're using my COM-Wrapper, a larger set > of Functions (in "VBA-Style", similar to the JET-Engine) are > already built-in there (including Instr, Left$, Right$, Mid$, > DateDiff, DatePart, ... etc.). > > For example Sébastiens requirement could be handled this way: > > Select Mid$(TheField, Instr(TheField,'[') From Tbl > > Olaf > > BTW, a new version including newest SQLite 3.7.14 is out now > since yesterday: www.datenhaus.de/Downloads/vbRC4BaseDlls.zip > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
