Re: [sqlite] ActiveX documentation

Steve, You might try installing this ODBC driver that allows you to query a Sqlite db just like Access, Excel, etc with Adodb. You can use VB6, VBA, vbscript. http://www.ch-werner.de/sqliteodbc/ The connection string is like this: objConn.Open "DRIVER=SQLite3 ODBC

Re: [sqlite] how to speed up this ?

ly not multi thread :( > > On 12/23/2010 11:46 PM, stormtrooper wrote: >> would it run faster if you add two columns to the Hast table - randmax >> and >> randmin >> >> update Hash set randmax = max((<#randomnumber> % 255)-10,0) >> update Hash set

Re: [sqlite] how to speed up this ?

would it run faster if you add two columns to the Hast table - randmax and randmin update Hash set randmax = max((<#randomnumber> % 255)-10,0) update Hash set randmin = min((<#randomnumber> % 255)+10,255) CREATE INDEX HASH_RMIN_IDX ON HASH (RANDMIN); CREATE INDEX HASH_RMAX_IDX ON HASH

Re: [sqlite] beginner

Srinidhi, I recommend Sqlite-manager, a free tool which runs inside Mozilla FireFox, to help build your queries and view the table,rows, etc. http://code.google.com/p/sqlite-manager/ Keith -- View this message in context: http://old.nabble.com/beginner-tp30480116p30523978.html Sent from

[sqlite] ogr2ogr

Rich, There is a command line tool (ogr2ogr) that runs on linux or windows that converts dbf to sqlite, csv, xml, etc. It is primarily a converter for geographic data but supports tabular data as well. OGR is part of fwtools. http://fwtools.maptools.org/ http://www.gdal.org/ogr/ - supported

Re: [sqlite] re gular expression search

SqliteSpy has RegExp functionality. -- View this message in context: http://www.nabble.com/regular-expression-search-tp25916275p26102979.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list

Re: [sqlite] Using SQLite for GIS Application

This is just a simple spatial intersection. Each line will intersect many contour lines producing points, you can calculate the average elevation points per line, calc min, max elev. Or save the line ID and elevation points in another table to query later. Ask the Spatialite User Group.

Re: [sqlite] Does SQLite have an Instr function?

This extension (extension-functions.c) has Charindex, which is basically the same as the VB instr. http://www.sqlite.org/contrib I had to compile the C source code to make the sqlite extension: I assume you are on Windows because you use VB. I had to install the mingw compiler, small and easy

Re: [sqlite] GUI design & managment tool?

I recommend 2 free tools: 1. The Firefox Sqlite Manager extension. 2. AnySQL Maestro (Windows) - this is an excellent tool, it can connect to almost any database or ODBC - Excel, Access, dbase, txt, sqlite, SQL Server, ... It has so many features. Please try it. Keith Allen Fowler wrote: >

Re: [sqlite] visual basic and sqlite

I recommend http://www.ch-werner.de/sqliteodbc/ Keith Raziedahanin KASIM wrote: > > I want to develop a simple application using VB 6.0 and sqlite Where > should > i start? > > I want to craete a embedded database into this small application. Anyone > can > advice and guide me. > > Thank

[sqlite] re gexp dll win32

Has anyone created a dll for the Windows version of Sqlite to access the Perl regular expression engine inside Sqlite? I noticed there is a pcre.so file for linux users. Or is easier to use regular expressions from a scripting language? -- View this message in context: