SQLite 3 Database Editor

[Kimera]

Cool thanks for the info on the objects. I take it then the SQL Server connects to a server and is not a server object?

In my oppionion ADO smokes ODBC but ODBC is better than INI and until you came along we had nothing other than the ODBC. It's nice to see and I can't thank you enough.

Maybe you can help me a bit. I cant figure out how to get the table names from a .mdb file using ODBC. You have any ideas on what that select statement would look like? Any attempt I made to select from MsysObjects just faild. If I can get the table names I can then import an entire .mdb file just by pointing to it, and that would be great.

I have been in IT since I was a kid and have made software for both local and global companies. With all the work I have done, the work that I made the best money on where the jobs that used a DB.

I hope to post a new MMFDBE in the next day or so with new menu options and some fixes that I did not notice until I did the install on my own system, as well as, csv importing.

I am so glad you like what you saw in the MMFDBE, it means a lot from the guy who wrote the object that made it all work.

God Bless,
K

[Kimera]

I have posted Version 1.0.0.1 of the MMFDBE in the archive section of the forum. :grin:

If anyone would like to start using SQLite DBs in their games or apps I think they will want to check out this post.

http://www.clickteam.com/epicenter/ubbthreads.php?ubb=showflat&Number=106050#Post1060 50

Let me know if you find any bugs or have any questions.

Thanks,
K

[droberson]

The install.zip file does not seem to work when you click on it. I just get a webpage that cannot be displayed. Could you confirm?

[Kimera]

droberson,

I tried to re-uplaod and it still will not work. I think it's to large (2.3 MB). Here is a link to the file from my server, hope this helps.

http://www.darlingroup.com/mmfdbe/install.zip

Sorry,
K

[droberson]

That did the trick, thanks Kimera.

By the way, I may have a need for you other services with the marketing product for one of my clients. I will send you an email.

[Kimera]

No worries bud!

Let me know what you think. I did not plan on writting the MMFDBE it just kind of happend but I would like to keep it up if people find it useful.

K