Pardon my abject ignorance of C and C++. But just a quick naive observation.
Does it have anything to do with the fact that the string is declared
"database_name", but the invocation uses "databese_name". ???
>
> Chris.
___
PS: DB4S is on v3.10 now, so if you're using the 'portable version', it
needs updating! ;)
Thanks,
Chris
On Tue, Aug 22, 2017 at 9:32 AM, Matthew Halliday
wrote:
> Hi Clemens - thanks for the reply.
>
> I'm trying to keep them a regular 4 or 6 hours - I'll
uires the use of the DLL, and some of
your clients are set up correctly (or have that DLL on their system) while
others don't. Its an easy fix.
Thanks,
Chris
On Thu, Jul 6, 2017 at 1:55 PM, Paul Sanderson wrote:
> Could your 32 bit app be picking up a 64 bit dll. Could you rename t
ng with (I assume 4.5.1) I recommend the '
*sqlite-netFx451-binary-Win32-2013-1.0.105.2.zip*' download.
If you're new to SQLite, I've written a number of SQLite classes which can
be useful building a DB application... a wrapper around the wrapper, so to
speak. ;)
Thanks,
C
insert into filters (absid, filter_name, enabled, filter_order) values
(null, 'Untitled filter', 0, ((select max(filter_order) from filters)+1)
On Mon, Jun 19, 2017 at 11:46 AM, Tim Streater wrote:
> I want to insert a new row in my table, and while doing so setting a
> column to one more than t
out that the table needs to
> be in t2 too.
>
> -Ursprüngliche Nachricht-
> Von: sqlite-users
> [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von
> Chris Peachment Gesendet: Sonntag, 11. Juni 2017 17:22 An: SQLite
> mailing list Betreff: [sqlit
syntax error
sqlite> create index idx on link (idChild,idParent);
Error: no such table: main.link
sqlite>
Regards,
Chris Peachment
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Excellent, thanks - I'll pass that on.
Very much appreciated.
Thanks,
Chris
On Thu, May 4, 2017 at 4:52 PM, Richard Hipp wrote:
> On 5/4/17, Chris Locke wrote:
> > If sqlite is given a slightly misconfigured SQL statement (eg, incorrect
> > JOIN statements), it could
are
retrieved, or a way of (cleanly) terminating a query after a period of time?
Thanks,
Chris
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Obviously the information given is a bit sparse. I'm assuming from a .dll
you're using Windows?
What steps have you taken, and what is giving this error?
On Thu, May 4, 2017 at 11:54 AM, prabha karan
wrote:
> Dear All,
> I got this exception except my system ... Pls help me
>
f your zone can appear
bizarre.
Hope this is useful
Chris
>
> I'm in the Eastern US time zone, in daylight savings time. I am four hours
> earlier than UTC time. I have a column that stores UTC times as Julian times
> (floating-point numbers). The latest data point in the table
Another 'sharing solution' which is just getting off the ground is dbhub.io,
(https://dbhub.io)
This is a 'github for sqlite databases' allowing you to share databases,
have version control, etc.
Thanks,
Chris
On Fri, Apr 7, 2017 at 6:22 PM, Warren Young wrote:
> On A
Have you tried exporting to Excel? They're are even components (relatively
cheap) to convert to PDF so both bases are covered.
Exporting to excel allows columns to be used so figures line up nicely.
Open source applications open excel files.
Thanks,
Chris
On 24 Mar 2017 8:03 p.m., &qu
An interesting discussion of it on StackOverflow...
http://stackoverflow.com/questions/689963/does-anyone-use-right-outer-joins
To give one example where a RIGHT JOIN may be useful.
Suppose that there are three tables for People, Pets, and Pet Accessories.
People may optionally have pets and thes
Sqlite is public domain, so feel free to add the necessary code, and once
approved, it'll get added to the main code.
Thanks,
Chris
On 20 Mar 2017 8:09 p.m., "PICCORO McKAY Lenz"
wrote:
> i got this
>
> Query Error: RIGHT and FULL OUTER JOINs are not currently suppo
Just add a 'comments' table. Seems a lot of extra work and 'extra tools'
needed to read the comments, which could potentially be missed.
Add a 'comments' table with a 'comment' field which you can even add dates,
usernames, etc, to.
Thanks,
Chris
O
understand it if its in a subroutine, and I appreciate the
example given was just an example, but whats the advantage of parametized
queries?
Sorry if diverting the topic somewhat
Thanks,
Chris
I
On Mon, Mar 13, 2017 at 8:15 PM, Rob Richardson
wrote:
> To answer my own question: this
Jacob Sylvia wrote:
> I know what the problem was... bash was interpreting the `table_name` piece
> as a command. I had to escape the backticks...
>
Yes, `command` is the old-fashioned way of saying $(command) in bash.
--
Chris Green
·
_
NT- I write a lot of vb.net programs that use sqlite databases, so will be
happy to run though a beginners guide.
It would be painless to convert from vb.net to c#
Thanks,
Chris
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http
Or user error.
"Thanks. Also found out where I was going wrong. While creating the .lib
file, weshould be using the following command: lib /def:sqlite3.def
/machine:X64 /out:sqlite3.lib I was skipping the /machine:X64 option
before."
On Mon, Mar 6, 2017 at 10:48 AM, Anick Saha wrote:
> Hi,
>
>
On Mon, Feb 13, 2017 at 9:13 PM, Richard Hipp wrote:
> [...]
> This makes me want to ask: Is anybody still using auto_vacuum? And
> if they are, should they be?
I am thinking to change the commonly-used Cordova/PhoneGap sqlite
plugin [1] to enable auto-vacuum by default for the following reason
Feb 6, 2017 at 1:55 AM, Hick Gunter wrote:
> > But only if you can guarantee that your statement inserts exactly one
> record and that nothing is executed on your connection between the insert
> and the call.
> >
> > -Ursprüngliche Nachricht-
> > Von: sqlit
Last_insert_rowid()
https://www.sqlite.org/c3ref/last_insert_rowid.html
On Fri, Feb 3, 2017 at 1:51 PM, Clyde Eisenbeis wrote:
> For OLE DB SQL, I have retrieved the primary key:
>
> -
> using (System.Data.OleDb.OleDbConnection oledbConnect = new
> System.Data.OleD
Ken,
That went to the mailing list ... to which you are also a recipient of
;)
Thanks,
Chris
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
PHP will easily display a value with trailing zeros - you don't add '00'
programmatically.
eg: $number = number_format(1234, 2, '.', '');
On Thu, Dec 1, 2016 at 8:08 AM, Werner Kleiner
wrote:
> As I can see storing prices is a topic with different ways and
> different solutions.
>
> The advic
.
Storing as integers is the way to go.
Thanks,
Chris
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Ulrich- a fantastically detailed post.
On Mon, Nov 14, 2016 at 3:23 PM, Ulrich Telle wrote:
> Richard,
>
> > Well what I've done is to create an encrypted database with
> > SQLite2009 and then use that in my C# project. I just add the password to
> > the connection string in my app and then it w
Encryption in system.data.sqlite is legacy encryption, only used within
itself, and not with other applications.
On Fri, Nov 11, 2016 at 6:24 PM, Richard Andersen wrote:
>
>
> I'm using the ADO.NET version (System.Data.SQlite).
>
> I've created an RSA encrypted database using SQLite2009 and that
But be careful, as you can't change all records from 3 to 4 and then 4 to
5, as the 4 to 5 will contain the records you've just moved from 3 to 4
Canofworms.jpg. ;)
Thanks,
Chris
On 15 Oct 2016 5:46 p.m., "Richard Damon" wrote:
> On 10/15/16 12:15 PM, Simon Slavi
that v103 was recently released, so the v89 you're using
is fairly old. Thats not the cause of the problem, but it may not be
helping.
Thanks,
Chris
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.o
What OS are you using? There is a freeware utility here for Windows:
http://sqlite2009pro.azurewebsites.net/
Thanks,
Chris
On Sat, Sep 10, 2016 at 10:24 PM, Scott Doctor
wrote:
> I have a database with a few tables and about 140MB of data in it that
> exists as a MySQL database. Using
) is a
3rd party tool.
I can post your query to their issues board though ... its still in high
development, and its curious the version number irregularities...
https://github.com/sqlitebrowser/sqlitebrowser/issues
Thanks,
Chris
On Wed, Sep 7, 2016 at 4:04 PM, Simon Slavin wrote:
>
> On
Makes perfect sense. Thanks.
Chris
On Tue, Sep 6, 2016 at 12:26 PM, Richard Hipp wrote:
> On 9/6/16, Chris Locke wrote:
> > When reducing the size of the browser (on Chrome desktop at least) the
> '***
> > DRAFT ***' tag disappears. Rather than disappears, mayb
by design?
Additionally, on the menu, the 'Download' option is not visible at all.
Thanks,
Chris
On Mon, Sep 5, 2016 at 10:56 PM, Delvin
wrote:
> The site seems to be quite readable - I did notice that the text appears
> larger in landscape mode but it seems to appear quite r
+1 on my part
On Sun, Aug 14, 2016 at 9:59 AM, Василий Кудрявцев wrote:
> Hi!
>
>
>
> I would like to propose an enhancement to SQLite diagnostics in case of
> unique constraint failure.
>
> Currently the message does not contain the name of constraint in question,
> only columns. For example:
>
(0, 1,2,7,15,150) Or M10 IS NULL))
This query works and has reasonable performance right now for
us, but I feel like there should be a more efficient way to do this.
Thanks
Chris
___
sqlite-users mailing list
sqlite-users
every field required. A
necessary evil, and 'the right thing', but still a pain...
Thanks,
Chris
On Fri, Jul 22, 2016 at 11:33 AM, R Smith wrote:
>
>
> On 2016/07/21 11:20 PM, Chris Locke wrote:
>
>> I've a table I'm calling recursively.
>>
>> ...
Thank you for your prompt reply. Thats no big issue then and I will code
it explicitly ... didn't want to do that if there was an option / some
other method I was missing.
Thanks,
Chris
On Fri, Jul 22, 2016 at 6:55 AM, Hick Gunter wrote:
> Short answer: YES.
>
> This que
Bit of a noob question, but whenever I post to the group, I get the below
email - 'you're not part of the group'. How does one join the group? I've
subscribed, so get all the emails... just wondering if there was a second
step, or if all group messages get moderated.
Thanks,
qlReader.GetName(11))
I know I can change my SQL statement to be explicit, and select each
required field and use AS, but is that the only solution?
Thanks,
Chris
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
*everyone rushes to download the files to have a nose*
On Wed, Jul 13, 2016 at 12:02 PM, Richard Hipp wrote:
> Off-list reply
>
> On 7/13/16, Miroslav Rajcic wrote:
> >
> > Note that I had to delete other tables to protect customer info.
>
> You did not seem to enable "PRAGMA secure_delete" bef
Whats the benefit of getting a sorted query and then sorting that query
again?
On Tue, Jul 12, 2016 at 12:45 AM, Stephen Chrzanowski
wrote:
> Simons + My answer;
>
> select * from (SELECT date_time_stamp FROM general ORDER BY date_time_stamp
> DESC LIMIT 2) a order by date_time_stamp;
>
> On Mon
Thanks, definitely looks straightforward to me.
On Tue, Jul 12, 2016 at 11:14 AM, Jan Nijtmans wrote:
> 2016-07-12 11:03 GMT+02:00 Chris Brody:
>> Personally I would really like to see this. Can you show the patch somewhere?
>
> Here is the patch. I'm not sure that the
> Actually, it is very well possible to build an amalgamation which can
> be built with or without ENABLE_UPDATE_DELETE_LIMIT, and
> functions fine as expected both ways without rerunning Lemon. If you
> are interested in a patch which demonstrates this, I'm happy to provide that.
Personally I wou
#x27;2');
expect(rs.rows.item(0).VALUE).toBe('value2');
});
}, function(e) {
// not expected:
expect(false).toBe(true);
expect(JSON.stringify(e)).toBe('---');
done();
Did you see the Cordova-sqlite-storage plugin that I maintain? It
supports Windows 8.1, Windows Phone 8.1, and Windows 10 UWP in
addition to Android and iOS. It uses the SQLite3-WinRT C++ library
which I think is better than using .NET/C#.
The following test case works fine for me when I try it on
Version.targets(3506,5):
> warning MSB3178: Assembly 'SQLite\System.Data.SQLite.dll' is incorrectly
> specified as a file.
>
> It not affect the final release program, but I don't know how it comes from
> and how to eliminate it.
>
> Thank you!
>
>
>
>
Blimey - arguments over a feather, However, I want to argue about your "They
look nothing alike" and I would say to a non-feather expert, they are very
similar. Same orientation (upwards, pointing to the right), white middle,
a nick on the right. They do look alike ... very alike.
>
> Just for my information, what is the purpose of this temporary file? I see
>> that -journal file is always stored to disk.
>>
>
> It's a statement journal:
>
> https://www.sqlite.org/tempfiles.html#stmtjrnl
>
> Recent changes mean that the first 64KiB of a statement journal are always
> stor
oad the DLL.
Indeed it couldn't, as it also needed msvcr100.dll, which wasn't on the
users machine. This only came to light when I used the above program and
noticed the error produced when it was looking for the file that wasn't
there
Chris
On Tue, Jul 5, 2016 at 4:59
Thanks James. Points taken on board. :-)
Chris
On Fri, Jun 17, 2016 at 5:24 PM, James K. Lowden
wrote:
> On Fri, 17 Jun 2016 07:37:16 +0100
> Chris Locke wrote:
>
> > I fail to see what any of this has to do with sqlite. I thought this
> > was a mailing list for sq
orums to email lists... don't feel so 'spammmy' and noisy...
Thanks,
Chris
On Fri, Jun 17, 2016 at 3:16 PM, Drago, William @ CSG - NARDA-MITEQ <
william.dr...@l-3com.com> wrote:
> > -Original Message-
> > From: sqlite-users-boun...@mailinglists.sqlite.or
there, and as soon as
the original poster has another query (no pun intended) which would result
in a schema change, this would have to be explained, etc.
A specific group on SQL is required.
Just my thoughts...
Chris
On Thu, Jun 16, 2016 at 10:14 PM, Simon Slavin wrote:
>
> On 16 Jun
Great analogy. PS: What colour seat covers should I be using if I have a
Ford?
On Mon, Jun 13, 2016 at 2:11 PM, jumper wrote:
> Thank you for the advice/information. I just solved the issue about a
> minute ago. How can I stop getting new replies?
>
>
> On 6/13/2016 8:08 AM, R Smith wrote:
>
>>
I wonder if the answers following link could help you:
http://stackoverflow.com/questions/19617368/sqlite-database-and-datagrid
I found this by a quick Google search. For the future please explain
the context, show that you have done some basic research, show what
you have found, and show specific
(though 5 years old)
at: http://www.mimec.org/node/297
I also like the Unicode link from Igor.
Chris
On Wed, Jun 8, 2016 at 3:49 AM, Wang, Wei wrote:
> Thanks for your reply! But I found the Latin-1 encoded characters are listed
> in the Unicode chart. http://unicode.org/charts/PDF/U00
On Jun 6, 2016 7:47 PM, "Eric Sink" wrote:
>
> Official, but slightly vague:
>
> https://developer.android.com/preview/behavior-changes.html#ndk
SQLCipher (based on SQLite) has already dealt with this in:
https://github.com/sqlcipher/android-database-sqlcipher/issues/216
I also made a library to
Hi Joe,
Adding two extra backslashes worked a treat. Many thanks for replying.
Would never have occurred to me to try that. No other Windows program uses
that convention, so seems 'alien' to me.
Again, thanks!
Chris
On Thu, May 26, 2016 at 6:17 PM, Chris Locke
wrote:
> Aah
Aah, thats handy. Will try that. Thanks for that - much appreciated. :-)
Thanks,
Chris
On Thu, May 26, 2016 at 5:38 PM, Joe Mistachkin
wrote:
>
> Chris Locke wrote:
> >
> > Have used system.data.sqlite.dll (1.0.67.1) for ages with no problems.
> > Recently thought, &
if there is a 'historical'
archive...
Thanks,
Chris
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
s up with "unable to
open database file". DB Browser for Sqlite opens it fine, so its not
corrupt. In fact, if I go back to 1.0.67.1, it opens fine.
Wondered if this was either 'by design' (something added since .67) or
something I was doing wrong?!
Thanks,
Chris
___
Another piece of feedback: I think it would be people to have access to the
presentation slides and samples.
Having JOIN for beginners is great. I think it would be cool to have VIEWs
for beginners as well. These are major benefits over NoSQL.
On May 22, 2016 1:29 PM, "R.A. Nagy" wrote:
> All,
>
On Mon, May 9, 2016 at 2:20 PM, Richard Hipp wrote:
> On 5/9/16, Chris Brody wrote:
>> On Wed, May 4, 2016 at 2:52 PM, Richard Hipp wrote:
>>> On 5/4/16, Bhagwat Balshetwar wrote:
>>>> I want to write the custom function for regular expression using C/C++.
On Wed, May 4, 2016 at 2:52 PM, Richard Hipp wrote:
> On 5/4/16, Bhagwat Balshetwar wrote:
>> I want to write the custom function for regular expression using C/C++.
>
> You mean like this one: https://www.sqlite.org/src/artifact/a68d25c659bd2d89
Is there any reason this cannot be included as an
On https://www.sqlite.org/datatypes.html there is a typographical error.
In the first paragraph of 1.0 Typelessness
"A database is suppose to store and retrieve data and it should? the word
should be ?supposed"
-Original Message-
> From: sqlite-users-bounces at mailinglists.sqlite.org
> [mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Chris
> Prakoso
> Sent: Tuesday, February 9, 2016 7:56 AM
> To: SQLite mailing list
> Subject: Re: [sqlite] C# + SQLite - Update/In
Thanks for the detailed explanation.
Regards,
Chris
On Tue, Feb 9, 2016 at 4:05 PM, R Smith wrote:
> That's not an SQLitespeed feature but indeed a backwards-compatible SQLite
> feature. (I had this wrong too at some point)
>
> You probably already know, but to be clear
Ok. Thanks for the reminder.
Regards,
Chris
On Tue, Feb 9, 2016 at 3:18 PM, Richard Hipp wrote:
> On 2/9/16, Chris Prakoso wrote:
> > Actually I've just done it now, in SQLiteSpeed, and it allowed me to use
> > double-quote as delimiter successfully.
> >
>
>
Actually I've just done it now, in SQLiteSpeed, and it allowed me to use
double-quote as delimiter successfully.
Regards,
Chris
On Tue, Feb 9, 2016 at 3:03 PM, Simon Slavin wrote:
>
> On 9 Feb 2016, at 12:10pm, Chris Prakoso wrote:
>
> > *insert into test (field1,field2)
Yes thank you. My SQLite is the latest, it's the front-end that is
outdated, which I have just swiftly corrected.
Regards,
Chris
On Tue, Feb 9, 2016 at 2:52 PM, Richard Hipp wrote:
> On 2/9/16, Clemens Ladisch wrote:
> > Chris Prakoso wrote:
> >> insert into test (f
Steven,
I don't use any back-end, the code I pasted here IS my back-end. I opted
for direct SQLite connection. So I don't use EF6 nor Linq.
Chris
On Tue, Feb 9, 2016 at 1:47 PM, Steven M. McNeese <
steven.mcneese at freedomparkdfw.com> wrote:
> Chris,
>
> What are y
Thanks Ryan,
I will definitely try it. I'm ok with raw SQL, just not familiar with the
odd ones like this multiple rows update.
Thanks a lot,
Chris
On Tue, Feb 9, 2016 at 12:42 PM, R Smith wrote:
>
>
> On 2016/02/09 1:30 PM, Chris Prakoso wrote:
>
>> Hi Clemens,
>
Ok. Got it.
Now, if only I can get that multiple rows update working on my code, it
would be perfect.
Thanks a lot,
Chris
On Tue, Feb 9, 2016 at 12:07 PM, Clemens Ladisch wrote:
> Chris Prakoso wrote:
> > public bool UpdateData(string tableName,
> Dictionary fields, Li
I did a test using simple table, and entering the sql directly using SQLite
Administrator:
*insert into test (field1,field2) values (1,"two"),(2,"three")*
The error I got from the SQLite Administrator is:
*2/9/2016 11:29:40 AM: SQL Error: near ",": syntax error
Updated > 0)
result = true;
}
catch (System.Exception ex)
{
this.UpdateStatusMessage(ex.Message);
}
}
return result;
}
On Tue, Feb 9, 2016 at 11:13 AM,
Hi Clemens,
Thanks for your reply. I've tried to use raw SQL but it didn't work
either. Do you have any SQLite front-end that you use?
Regards,
Chris
On Tue, Feb 9, 2016 at 11:12 AM, Clemens Ladisch wrote:
> Chris Prakoso wrote:
>> My question is whether anybody had succe
Hi all,
I've been testing the performance of my Insert/Update using
Transaction and without, and I found that it is quicker when I don't
use it.
Anybody has an insight on this?
Thanks a lot,
Chris
ate.
I've tried to use INSERT OR REPLACE and passing multiple VALUES, but
it didn't seem to work.
Any pointers would be appreciated.
Thanks very much,
Chris
that postcode
will not be unique, if Australia Post's version of this is typical. One
postcode covers several suburbs. I guess this will fundamentally alter the
approach. A blisteringly fast lookup retrieving the wrong result may not be all
that useful.
Chris Waters
Hello,
I was just looking at updating to SQLite 3.8.11.1 when I spotted what appears
to be an error.
Here?s a patch to fix it:
--- sqlite-amalgamation-3081101/sqlite3.c 2015-07-30 03:06:58.0
+0100
+++ sqlite3.c 2015-09-12 19:03:55.0 +0100
@@ -92265,7 +92265,7 @@
}
Thanks TIm
On 13 August 2015 at 15:31, Tim Streater wrote:
> On 13 Aug 2015 at 11:34, Chris Parsonson wrote:
>
> > Has anybody ever used this ATTTACH command?
>
> Here's what I do to move a row from one database to another (same
> table/column defs). I have to go via
Path As String =
"C:\Users\Chris\Documents\UpdateWolfpro.db3"
Try
If dbConnection.State = ConnectionState.Closed Then
dbConnection.ConnectionString = "Data Source=" & sDBPath &
";New=True;Compress=True;Synchronous=Off"
In fact I found the database in the Documents folder.
"C:\Users\Chris\Documents\UpdateWolfpro.db3"
but it made no difference. But the ATTACH gives no error in either my first
attempt or this second one.
On 13 August 2015 at 10:45, R.Smith wrote:
>
>
> On 2015-08-13 10:26
at doesn't exist
> yet in the same named (with the same schema) table in the attached database
> on a Primary key called "RecID", this SQL might work:
>
> INSERT INTO DB2.MyTable SELECT * FROM MyTable WHERE MyTable.RecID NOT
> IN (SELECT RecID FROM DB2.MyTable);
>
So can someone give me a working example of two database ATTACHed and a
simple select using columns from a table in each database
On 13 August 2015 at 07:13, Chris Parsonson wrote:
> Now we get down to the first real problem that of the ATTACH. I have never
> been able to get that to work
Server doing synchronisation there
On 13 August 2015 at 07:08, Simon Slavin wrote:
>
> On 13 Aug 2015, at 5:55am, Chris Parsonson wrote:
>
> > The tables are very simple. They have a primary key, but no relationship
> > between tables in the sense that you mean. Synchronisat
The tables are very simple. They have a primary key, but no relationship
between tables in the sense that you mean. Synchronisation will be add new
rows, and update some rows, no deletions
On 13 August 2015 at 05:53, Simon Slavin wrote:
>
> On 13 Aug 2015, at 3:52am, Chris Parsonson
Hi SQLite people,
I need to be able to synchronise some fairly simple table in two databases.
Can someone help please
Regards,
Chris
--
Chris Parsonson
083 777 9261
Dunno but I changed it and ran the code. It goes through without error but
the DELETE still has not worked
On 31 July 2015 at 11:36, Kevin Benson wrote:
> On Fri, Jul 31, 2015 at 3:38 AM, Chris Parsonson
> wrote:
>
> > Forgot to add the code
> > Public Function Synch
UPD;
>
> Intead of
>
> ATTACH 'myfilepath' AS UPD;
>
>
>
> -Urspr?ngliche Nachricht-
> Von: Chris Parsonson [mailto:z2668856 at gmail.com]
> Gesendet: Freitag, 31. Juli 2015 09:10
> An: General Discussion of SQLite Database
> Betreff: Re: [sqlite] ATTACH Pr
ilepath AS UPD;
>
> Intead of
>
> ATTACH 'myfilepath' AS UPD;
>
>
>
> -Urspr?ngliche Nachricht-
> Von: Chris Parsonson [mailto:z2668856 at gmail.com]
> Gesendet: Freitag, 31. Juli 2015 09:10
> An: General Discussion of SQLite Database
> Betreff: Re: [s
With dbcommand2
.CommandText = SQLStmt
.ExecuteNonQuery()
.Dispose()
End With
Return True
Catch ex As Exception
MessageBox.Show(ex.Message)
Return False
End Try
End Function
Thanks,
Here is my code again, hopefully with typing errors corrected. The attach
and the delete run without generating any errors, but the delete does not
work
On 31 July 2015 at 09:25, Rowan Worth wrote:
> Chris, you have an extra pair of single quotes in your original code
> compa
That's exactly what I started with, then somebody suggested using a
parameter
On 31 July 2015 at 09:02, Simon Slavin wrote:
>
> On 31 Jul 2015, at 5:32am, Chris Parsonson wrote:
>
> >SQLStmt = "ATTACH '" & sUpdateDBPath & "' AS U
d = dbConnection.CreateCommand
With dbcommand2
.CommandText = SQLStmt
.Parameters.AddWithValue("@TBName", "UPD.Items")
.ExecuteNonQuery()
.Dispose()
End With
On 31 July 2015 at 06:42, Chris Parsonson wro
No, but I can do that
On 31 July 2015 at 06:41, Joe Mistachkin wrote:
>
> Chris Parsonson wrote:
> >
> >
> > The first thing I need to do with the second database is ATTACH it
> > to the first one. This is what I haven't been able to do successfully.
SQLStmt = "DELETE FROM UPD.Items"
Dim dbCmd2 As New SQLiteCommand(SQLStmt, dbConnection)
dbCmd2.ExecuteNonQuery()
Return True
Catch ex As Exception
MessageBox.Show(ex.Message)
Return False
End Try
End Function
End Module
--
Chris Parsonson
083 777 9261
then back to
strings again. To do a thorough evaluation, I would want to dig into
specific implementations and do my own tests. I just don’t have the time
and don’t think it will be a factor at my relatively low volumes. If any of
you have dug into the performance aspects, I’d be interested in hearing.
;m
writing won't push any performance boundaries and likely won't need to
overly worry about storage. I just want to make the right call on data
type and format and learn something in the process.
Again, I hope this is an appropriate post for this mailing list. I
from an SQLite memory instance. A single-thread batch job
over 100,000 user-agents goes from average 130 seconds to over 250 with this
update, which is a horrific decrease in speed. It's a bad enough effect to
necessitate a downgrade.
Chris
101 - 200 of 522 matches
Mail list logo
