Re: [sqlite] Setting up SQLite for VB6

Thank you, it's working now. Regards Jonathan On 21/11/2016 09:19, Bart Smissaert wrote: I think you will need this ODBC driver: http://www.ch-werner.de/sqliteodbc/ RBS On Mon, Nov 21, 2016 at 8:12 AM, J Trahair wrote: Hi everyone I am trying to link a VB6 project to SQLite. (I c

[sqlite] Setting up SQLite for VB6

Hi everyone I am trying to link a VB6 project to SQLite. (I can do this fine in VB.Net.) I am using System.Data.SQLite.dll file version 1.0.66.0, and the following connection properties: Option Explicit Public grsUtilities As ADODB.Recordset Public gconn As ADODB.Connection Public mstrSQL As

[sqlite] SQLite database in a Windows CE6.0 mobile device

Hi I am trying to run a SQLite database in a CE6.0 device (Psion Omnii XT15). It runs the demo from sqlite-netFx35-binary-PocketPC-ARM-2008-1.0.97.0.zip, which creates a db from testce.exe, but on running my VB.net app it produces an error message - File or assembly name Microsoft.VisualBasic V

[sqlite] SQLite database in a Windows CE6.0 mobile device

Hi I am trying to run a SQLite database in a CE6.0 device (Psion Omnii XT15). I have persuaded it to run the demo from sqlite-netFx35-binary-PocketPC-ARM-2008-1.0.97.0.zip, which creates a db (containing info on broccoli and onions) from testce.exe, but on running my VB.net app it produces an

[sqlite] How to speed up a bulk import

Hi I am using SQLite running under VB.net in a import routine of a series of csv files, but it seems to be slow, and I don't mean microseconds, I mean minutes. A typical INSERT might be: INSERT INTO AllSales (Source, MachineName, Location, UserPIN, TariffName, CustomerID, DateOfSale, TimeOf

Re: [sqlite] Get whether a column has been defined as 'unique'

Thank you, that's great. Jonathan On 15/02/2014 16:14, Igor Tandetnik wrote: On 2/15/2014 8:09 AM, J Trahair wrote: [I often use the structure of a table to recreate the table as new from scratch, or to clone it into a different table, eg. I have a table called 'Customers', I

[sqlite] Get whether a column has been defined as 'unique'

Hi all I have a table in a database, one of the columns is TEXT NOT NULL UNIQUE. If I want to find out which column has been designated unique, how can I do it? I can get the DataType of each column by testing the value of objDs1.Tables(0).Columns(numColumnNumber).DataType.ToString where obj

Re: [sqlite] VB.net project using Windows CE and SQLite on a handheldPsion terminal

Thank you - System.Data is of course referenced in the project already. Does Windows CE as a target device need a different version of System.Data? The one referenced is the one in C:\Program Files\Microsoft.Net\SDK\Compact Framework\v2.0\Windows CE folder. J Trahair On 02/12/2013 20:58, Joe

[sqlite] VB.net project using Windows CE and SQLite on a handheld Psion terminal

s DataSet Dim objDa As SQLiteDataAdapter The 3 errors refer to these dims. The project is set as a WindowsCE project. Can anyone shed light on what is missing? Thank you. J Trahair ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org

Re: [sqlite] Does SQLIte run under Windows CE?

Thank you everyone. Jonathan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Does SQLIte run under Windows CE?

Does SQLIte run under Windows CE? And if so, which version should I download? Thank you. J Trahair ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Fw: Fw: Is there a command to lock a database for a short while (0.25 sec, say)

while later (eg. 0.25sec) mcmd.Connection.Close() releases it. I read in one place that you need a transaction eg. SELECT * FROM Utilities WHERE RecNo = 1 for locking to occur, but this database locks without one. Jonathan On 24 Apr 2013, at 11:58am, "J Trahair" wrote: > I had

Re: [sqlite] Fw: Is there a command to lock a database for a short while (0.25 sec, say)

to cope with two separate invoices with the same number. Oooops. Thanks for your help! Jonathan On Wed, 24 Apr 2013 11:19:32 +0200 "J Trahair" wrote: > Thanks for the replies so far. > > I've been trying to get the database to lock - I am using a program I

[sqlite] Fw: Is there a command to lock a database for a short while (0.25 sec, say)

twork is still able to open the database and run the program. I have missed something - but what is it? Thanks for your help. Jonathan On 17 April 2013 14:39, J Trahair wrote: > Hi everyone > > Can my application lock the database for its own exclusive use at the beginning of

[sqlite] Is there a command to lock a database for a short while (0.25 sec, say)

Hi everyone Can my application lock the database for its own exclusive use at the beginning of a series of INSERTs UPDATEs and SELECTs, then unlock it again afterwards? I've read about the five locking states (unlocked, shared, etc.) but I assume the dll handles all that at INSERT or UPDATE tim

[sqlite] Copying an SQLite database

x27;s program is copying it to the other folder. Glitches, corruption...or perfect integrity? Thanks J Trahair ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Using SQLite on Windows 64bit

it was forced to be for 32-bit, it worked. This could be even changed from the command-line, but I forgot the tool doing it. I'll dig up, if you need to. Thanks! On 10/26/2011 2:17 AM, J Trahair wrote: > Hi. > > I want to install a VB.Net application onto a customer'

Re: [sqlite] Using SQLite on Windows 64bit

Got it! Thanks Joe. Regards Jonathan - Original Message - From: Joe Mistachkin To: 'General Discussion of SQLite Database' Sent: Wednesday, October 26, 2011 7:53 PM Subject: Re: [sqlite] Using SQLite on Windows 64bit J Trahair wrote: > > Works o

Re: [sqlite] Using SQLite on Windows 64bit

- Original Message - From: Joe Mistachkin To: 'General Discussion of SQLite Database' Sent: Wednesday, October 26, 2011 3:20 PM Subject: Re: [sqlite] Using SQLite on Windows 64bit J Trahair wrote: > > However, I have installed the same installation setup.e

[sqlite] Using SQLite on Windows 64bit

Hi. I want to install a VB.Net application onto a customer's Windows 64bit computer. I have my own Windows 64bit laptop with Visual Studio 2010 installed. I have a VB.Net application which uses SQLite successfully, both in the development runtime, and as an 'installed' program in a separate fol

[sqlite] Capitalisation

statements are not case specific? Thanks J Trahair ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Indexing - a test example

I have looked at some information on indexing, and watched a 44 minute presentation by Dr Richard Hipp. I looked at the project I am converting to SQLite, and I have identited all the SELECTs for all the tables. They do not fall easily into the 'SELECT x, y, z FROM Table1 WHERE w = 5 AND x = 6

Re: [sqlite] VB.net error on adding SQLite3.dll to ProjectReferences

Thanks everyone, this is sorted now. J Trahair - Original Message - From: jose simas To: General Discussion of SQLite Database Sent: Sunday, March 06, 2011 11:54 AM Subject: Re: [sqlite] VB.net error on adding SQLite3.dll to ProjectReferences Hi, Use System.Data.Sqlite

[sqlite] Using indexed fields in a table.

and if so what is the syntax at CreateTable time? Thanks in advance. J Trahair ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] VB.net error on adding SQLite3.dll to Project References

Hi everyone. VB.Net 2005, I am trying to add sqlite3.dll to the Project References. When I try to Add the dll I get an error message: 'A reference to {path to sqlite3.dll} could not be added. Please make sure that the file is accessible, and that it is a valid assembly or COM component.' The