Jump to content

Open an SQLIte EXISTING database file


Recommended Posts

Can someone tell me how to open an existing , File SQL database?

The examples in help only show how to create / open / work with / close / query, etc, etc on a database in memory.

I have a SQL lite database file already existing at a specific folder with a specific file name.

The following returns error:

include <sqlite.au3>

$FN="c:\temp\Reports.db"

$Handle=_SQLite_Open($FN)

MsgBox(0,"",$Handle)

This does the same thing:

include <sqlite.au3>

$FN="c:\temp\Reports.db"

$Handle=_SQLite_Open($FN=":File:") This is what is shown in the examples, however, it does not work. (I replaced "Memory" with "File")

MsgBox(0,"",$Handle)

Any help would be greatly appreciated.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...