gcue Posted September 3, 2009 Author Share Posted September 3, 2009 (edited) hey weaponx, is it possible to save the sql table to a file? this way i can do this on a nightly job and make the table available for my users during the day for better speed performance thanks again for your help!!!! Edited September 3, 2009 by gcue Link to comment Share on other sites More sharing options...
weaponx Posted September 4, 2009 Share Posted September 4, 2009 Juts look in the help file for _SQLite_Open, you can pass it a filename. I think it uses a proprietary format. Regardless, it can be reopened later. Link to comment Share on other sites More sharing options...
PsaltyDS Posted September 4, 2009 Share Posted September 4, 2009 (edited) I think it uses a proprietary format. SQLite code (including the file handling) is in the Public Domain. So the format is specific to SQLite, but very publicly shared and available if you wanted to play with it.I never looked to see if MSSQL, Access, Oracle, etc. had any import capability for SQLite files... hmmm... Edit: Oh, there it is: SQLite Converter Tools Edited September 4, 2009 by PsaltyDS Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now