Problems with importing SQLite3 with Exec in Gambas
Posted: Tuesday 2nd April 2024 7:08pm
I have a file with data that I want to add to an empty table. But when I use this statement on an already open database, it doesn't work. But when I do it from within in SQLite3 this same statement works perfectly fine. Give me some clue why it doesn't work. Indicate tells me that the (.) in front of import is the problem.
sSQL = ".import " & Application.Path & "/" & "file.dat table1"
mg.gConn.Exec(sSQL)