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
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
d 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 Problem
>
> That's exactly
gt;
> 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 Problem
>
>
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 =
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
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
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 '" &a
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
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
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
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 =
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?
On May 13, 2008, at 7:57 AM, [EMAIL PROTECTED] wrote:
>
> Im running ATTACH database on SQlite 3.5.8 on windows.
> Im 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
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,
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,
On May 13, 2008, at 7:57 AM, [EMAIL PROTECTED] wrote:
>
> Im running ATTACH database on SQlite 3.5.8 on windows.
> Im 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
19 matches
Mail list logo