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
.CommandText = SQLStmt
.Parameters.AddWithValue("@DNName", sUpdateDBPath)
.ExecuteNonQuery()
.Dispose()
End With
SQLStmt = "DELETE FROM @TBName"
Dim dbcommand2 As SQLiteCommand = dbConnection.CreateCommand
With dbcommand2
.CommandText = SQLStmt
.Parameters.AddWithValue("@TBName", "UPD.Items")
.ExecuteNonQuery()
.Dispose()
End With
On 31 July 2015 at 06:42, Chris Parsonson <z2668856 at gmail.com> wrote:
> No, but I can do that
>
>
> On 31 July 2015 at 06:41, Joe Mistachkin <sqlite at mistachkin.com> wrote:
>
>>
>> Chris Parsonson wrote:
>> >
>> > <snip>
>> > 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.
>> > <snip>
>> >
>>
>> Have you tried using a SQLiteParameter for the file name for the database
>> to attach?
>>
>> --
>> Joe Mistachkin
>>
>> _______________________________________________
>> sqlite-users mailing list
>> sqlite-users at mailinglists.sqlite.org
>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>>
>
>
>
> --
> Chris Parsonson
> 083 777 9261
>
--
Chris Parsonson
083 777 9261
