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
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
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
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
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
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
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
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
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
Thank you everyone.
Jonathan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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
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
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
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
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
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
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'
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
- 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
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
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
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
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
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
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
25 matches
Mail list logo