Hello,
Been trying to make an in memory database using vb.net and the system.data.sqlite dll. however I require to copy the context from my file db first
Got this syntax -
Dim conn As SQLiteConnection = New SQLiteConnection("Data Source=:memory:;")
conn.Open()
Using cmd As DbCommand = conn.CreateCommand()
cmd.CommandText = "ATTACH '\FilDB.db3;Password=1234' AS disk"
cmd.ExecuteNonQuery()
cmd.CommandText = "CREATE TABLE tblMain as Select * from disk.tblMain;"
cmd.ExecuteNonQuery()
End Using
Getting an error stating no such table: disk.tblMain
Can you pick the error here ??
Thanks for any answers.
48 weeks 3 days ago