If I leave out the apostrophes then because the path to the DB contains 'C:\' I get an SQL error 'unknown character :'
On 31 July 2015 at 09:26, Hick Gunter <hick at scigames.at> wrote: > Not quite. Try printing the generated statement. It should read > > ATTACH myfilepath 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: [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 <slavins at bigfraud.org> wrote: > > > > > On 31 Jul 2015, at 5:32am, Chris Parsonson <z2668856 at gmail.com> 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 results using something > > like > > > > SQLStmt = "ATTACH " & sUpdateDBPath & " AS UPD" > > > > You must, of course, make sure that the sUpdateDBPath specifies a > > place that your application does have access to. You can test this by > > inserting a few test lines which open a database of that location. > > > > Simon. > > _______________________________________________ > > 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 > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > ___________________________________________ > Gunter Hick > Software Engineer > Scientific Games International GmbH > FN 157284 a, HG Wien > Klitschgasse 2-4, A-1130 Vienna, Austria > Tel: +43 1 80100 0 > E-Mail: hick at scigames.at > > This communication (including any attachments) is intended for the use of > the intended recipient(s) only and may contain information that is > confidential, privileged or legally protected. Any unauthorized use or > dissemination of this communication is strictly prohibited. If you have > received this communication in error, please immediately notify the sender > by return e-mail message and delete all copies of the original > communication. Thank you for your cooperation. > > > _______________________________________________ > 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
