On 2/2/2011 8:03 PM, BareFeetWare wrote: > I use the attach command to attach another SQLite database file that resides > in the same directory as my main file. I tried: > > attach 'Import.sqlitedb'; > > But it fails to find the file. If I specify the full path: > > attach '/Users/tom/Documents/Work/Databases/Import.sqlitedb'; > > Then it works.
Just as with any command line utility, relative paths are resolved relative to the current working directory. Just start sqlite3 in such a way that the directory where your database files reside is the current one. Read the fine manual for your shell of choice. > How can I attach to a local file in the same directory, without specifying > the full absolute path? How did you manage to open the main file in the first place? Specify the path to the second file in the same manner. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
