Chris, you have an extra pair of single quotes in your original code
compared to Simon's suggestion. Also in your parameter-based attempt you
have a typo when assigning the path (@DNName instead of @DBName).
Hope that helps,
-Rowan
On 31 July 2015 at 15:09, Chris Parsonson wrote:
> That's exac
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 SynchroniseDB() As Boolean
>
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
Forgot to add the code
Public Function SynchroniseDB() As Boolean
Dim dbConnection As New SQLiteConnection
Dim dbDataSet As New DataSet
Dim SQLStmt As String
Dim sDBPath As String = Application.StartupPath & "\wolfpro.db3"
Dim sUpdateDBPath As String = Ap
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
> compared to Simon
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 UPD"
>
> This is not the correct syntax for the ATTACH
On 31 Jul 2015, at 5:32am, Chris Parsonson wrote:
>SQLStmt = "ATTACH '" & sUpdateDBPath & "' AS UPD"
This is not the correct syntax for the ATTACH command. The name of the file to
be attached is not a value, it's just included in the command. I would expect
you to have better re
of SQLite Database
Betreff: Re: [sqlite] ATTACH Problem
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 '
The only parameters I can put in ar the DB name in the ATTACH and then the
table name in the DELETE. Anyway it fails on the ATTACH
SQLStmt = "ATTACH @DBName AS UPD"
Dim dbcommand As SQLiteCommand = dbConnection.CreateCommand
With dbcommand
.Comma
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.
> >
> >
>
> Have you tried using a SQLiteP
Hi mailinglists,
Please help.
Good Day SQLite Mailing List,
I have a VB.NET 2008 program running on Windows 7 which populates an
SQLite3 database. After updates are made I need to populate a second SQLite
database with some of the tables in the master database (by pressing a
button). As there will
On Fri, Jul 31, 2015 at 3:38 AM, Chris Parsonson wrote:
> Forgot to add the code
> Public Function SynchroniseDB() As Boolean
> Dim dbConnection As New SQLiteConnection
> Dim dbDataSet As New DataSet
> Dim SQLStmt As String
> Dim sDBPath As String = Application
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.
>
>
Have you tried using a SQLiteParameter for the file name for the database
to attach?
--
Joe Mistachkin
On Oct 10, 2008, at 1:32 PM, [EMAIL PROTECTED] wrote:
>
> Thank you. I've finally found the problem also thanks to error
> message. I haven't called sqlite3_reset() after SQLITE_BUSY so
> retrying step() returned MISUSE. But what to do if I'm fetching the
> rows for SELECT statement? Reset(
Thank you. I've finally found the problem also thanks to error message. I
haven't called sqlite3_reset() after SQLITE_BUSY so retrying step() returned
MISUSE. But what to do if I'm fetching the rows for SELECT statement? Reset()
would put me to beginning. Can SQLITE_BUSY (or _LOCK) occur after
On May 13, 2008, at 7:57 AM, [EMAIL PROTECTED] wrote:
>
> I‘m running ATTACH database on SQlite 3.5.8 on windows.
> I‘m opening one database
> file and attaching the second one.
> On my computer it works, but it fails at other computer. The
> database is opened in more
> than one thread (it i
Am 09.10.2008 um 18:21 schrieb [EMAIL PROTECTED]:
>
> Ok it seems last time I've posted too many errors so I'll try to ask
> about this one. Maybe other are just consequences of this. I've
> finally received this error also on my computer, but only in release
> build.
>
> - windows XP, sqli
Ok it seems last time I've posted too many errors so I'll try to ask about this
one. Maybe other are just consequences of this. I've finally received this
error also on my computer, but only in release build.
- windows XP, sqlite 3.6.3, VS 2005
- sqlite3_threadsafe() -> 1
- 20 worker threads, e
On May 13, 2008, at 7:57 AM, [EMAIL PROTECTED] wrote:
>
> I‘m running ATTACH database on SQlite 3.5.8 on windows.
> I‘m opening one database
> file and attaching the second one.
> On my computer it works, but it fails at other computer. The
> database is opened in more
> than one thread (it i
I‘m running ATTACH database on SQlite 3.5.8 on windows. I‘m opening
one database
file and attaching the second one.
On my computer it works, but it fails at other computer. The database is opened
in more
than one thread (it is failing in worker thread).
sqlite3_step() returns SQLITE_MISUSE , but
21 matches
Mail list logo