MMFDBE with SQLite 3

OK, some of you may have seen my post over the weekend about issues I was having with the SQLite 3 object, though nobody had the answer to my issues I did get it worked out. I was inspired to make a Database Editor with MMF. It was made in build 248 MMF 2 Dev and uses some object I think are only for Dev. Sorry bout that for all of you who have standard.

Here is a link to the mfa file.
http://www.darlingroup.com/mmfdbe.zip

Here is a link to the install if you want ot play with it.
http://www.darlingroup.com/install.zip

When you do the install you can right click on the icon list on the left (big white empty box when it first loads) you will get a menu to add DB. This just adds it to the list of DBs you have access to. Load the Demo Base database and you can see a bit of how it works. This is only beta but I have run out of time and need to go see a client. There are a few things that just dont work yet but nothing that will stop the creation and editing of a sqlite db that you can then connect to from any web site using the ODBC drive provided through the sqllite web site.

Hope this is something people need. Well I needed it so I made it but I hope others can get something out of it as well. :)

Touch one time on the databse icon to load the tables. Touch onec one the table name to see a quick view of the structure, double click on the table to open it with all records. Use the sql box at the bottom with a select statement and it will pull just those records. This is still very basic but it's getting there. I have not had that much time on it yet and I am still learning and doing some testing with it but I will be using it in production DBs starting today so I don't see why others shouldn't have the chance.

If you want to connect to your db using the ODBC driver they offer on the sqlite site here is the connection string.

Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER=SQLite3 ODBC Driver;Database=D:\Jump-Point\DB Editor\Databases\Test DB.mmdb"

I will be adding CSV Import and if I can figure out how to get the table names from an access db using the MMF ODBC object I will add the MDB import function, and some other stuff.


Take care,
K

This is awesome! :)

Extremely lightweight and surprisingly professional in its interface. Impressive!

Some more work and it deserves to be spotlighted!

My feedback:

* How about adding a default menu with an addition toolbar below it instead of those bitmap buttons though? People are used to menus/toolbars I think.

* I did try to run an insert query into my new table (in my new DB) but nothing happened - no error and no rows in table. :/

* Maybe, also, include the new scintilla object for syntax highlighting?

Thanks Bornemix,

All feedback is welcome!

Yea the buttons have to go I agree. I am not sure what you ment by your statement on the menu. I would love any ideas, I have tons of things to add still and two buttons in the table editor don't do anything. (save and load layout) They will allow you to load a predefined table def that you saved out.

After your insert you will need to double click on the table to open the records. An exaple of an insert would be...

INSERT INTO <table_name> (Col,Col,Col) Values ('Var','Var','Var');
-OR-
For a table called users with columns named User_Name, Phone, Email, Notes, and Age - with Age being the only column that is a number...

INSERT INTO Users (User_Name, Phone, Email, Notes, Age) values ('Jon Doe', '555-555-5559','jondoe@mybox.com','No Notes',45);
-OR-
INSERT INTO Users values ('Jon Doe', '555-555-5559','jondoe@mybox.com','No Notes',45);

If you just want to insert one field you can use...

INSERT INTO Users (User_Name) values ('Jon Doe');

If you dont insert all the column data you have to state the columns and values.

The Scintilla object for syntax highlighting is a great idea, I have never seen it, never heard of it but if I can get an example of how it's used, and the object as well, I would love to look in to it.

Thanks again, it's nice to know someone found it useful, I am going to continue work on it since I will need it for things I am doing but if people like it I will keep a link current. If not it meets my needs and you found it useful so I am happy.

Later,
K

This is good stuff, Kimera. I think your work, (and sharing it) in this area is very important and useful. It should certainly make creating and using professional databases more understandable and even desirable to many users.

Please do keep developing this and sharing the results. I look forward to it.

BTW: The new, Scintilla Object is being Beta-tested publicly, as we speak, in the Extension Forum. I think it would go well with your application and you will probably give it some good testing at the same time.

Thank You Novabrain.

I will check out the Scintilla Ojbect when I get a chance. There are some basic functions I need worked out first.

Thanks again,
K

Update Info - Aug-13-08

I have found that creating a DB does not work as I thought. I will fix this very soon, I already know what the issue is I just need the time. There is a work around but it is a pain in the butt. Create a table with one colum and close the editor. When you reopen it you can create a new table. Any table can have columns added and removed without issues that I can see at this point.

There is also an issue with saving DBs. If you save without adding an extention the db is saved in the parent folder without an extention. This is fixable as well.

Any other issues people find please let me know!

Very nice work :)
You should use a monospaced font for the query input fields, though X)
Well - I've seen that you might use my extension, which makes me very happy :D
Anyway, I dunno if you already tried my extension, so here's a little screenshot for you: http://s8.directupload.net/images/080813/xw59vzie.png
You could do more though, like colorizing data types red. ;)

Hey Looki,

I have not messed with it yet but I would like to check it out as soon as I get everything working at least on a basic level. I have just been tied up with a widget for the menu that I posted. The menu was for this interface but I thought it would be nice to put it up for others to use.

The screen shot looks good. That looks like it would be good to use in several things?

Will this extention fall under our Clickteam agreement or is there other licensing we have to worry about?

Thanks,
K

Hey, Kimera. I might release a documentated version soon. :)
It will also be possible to style using keywords like 'comment' rather than IDs like 4.
The license of scintilla can be found here: http://scintilla.sourceforge.net/License.txt
As you can see, you can use it anywhere you want, for free.

Cool, I will look forward to the docs.

Thanks for the link, I like to have the license for anything I use if it does not fall within the MMF license. I will use the object for sure, just give me some time for dev.

Did I see somewhere that someone did an HTML editor with it? I would like to look at that example as well, the concept gives me some ideas.

Thanks,
K

http://looki.lo.funpic.de/scintillaExample.mfa ;)
Anyway, let's get back to topic. We could use PM's to communicate or so :P

byo, I could not post on the SQLite 3 post but you said you would be checking this out and I have a request to help finish the MMDBE. Unless I am missing something there is no way to get the actual ROWID assigned by the DB itself. I can get the row index but that is the same data I can get from adding 1 to a counter each time I pull a NextRow() or using the loopindex("loopname") function in MMF. Any chance of getting the Row Index to return the ROWID or adding get ROWID to the extention?

Thanks,
K

Hi, Kimera.

Seems interesting to add.

[EDIT] I see what you mean. I'll take a look, ok? :)

Thank you. Kind regards,

byo

No worries! You da man!!!

:) :grin: I HAVE POWER!!! :grin: :)

OK now that IKE has stopped life where I live over the last few weeks I have a long list of things in my business life I have to catch up on now that I have working phones, power and Internet! :crazy:


This project is not dead, just not at the top of the list right now, I am very sorry! :( I am sure that those who have an interest will understand.

Thanks to those who contacted me, or attempted to contact me, to make sure I was OK durring all this, I am OK, alive, and now back in business.

Later,
K

Glad to know. Keep up the good work.

Hi Kimera, This is looking very impressive, however am I right in saying that you're offering an .mfa file? The two downloads I extract are both .exe files of the editor.

Many thanks, this is awesome! :)

LauraSoft you are right - :( :blush:

Nobody ever said a word, sorry, it was not my intent as you can see by the links and I thank you for pointing this out.

Now here is my problem. The current version has been integrated in to a patent pending product not available to the public. The backup I put on an external drive, plugged in to a power strip I turned off before the storm. My son needed to charge his cell phone and used that power strip to do so while we were on the generator then left the strip on the entire time. The fluctuations of power comming from the generator seems to have damaged the strip and everything plugged in to it, including that external drive.

With the MMFDBE I copied the files to the drive then edited the original for the integration, big mistake at this point, and this link was my salvation. Now I find out it's gone :( and I can only blame myself.

I am going to freeze the drive over night and see if that helps but I am not holding my breath. :sick: I also have some rar files I can look through that might have a copy in it but it will take a while to recover all the external files, pointers, etc... :crazy: as those only hold the MMF file and backups made by MMF if I have them at all.

Once again, Sorry!
K :blush: :(

Hi, Kimera.

Sorry to hear that. :(
I have the "MMFDBE.mfa" file from a previous version if that helps and I can send you if you can't recover your project.

Hope everything's fine with you.

Regards,

Andre

Thanks byo that would be great!

------ EDIT ------
sorry that was to mikeb I think
------ EDIT ------

Send me a PM with a link if you can or just give me a ring on the phone and we can set up an FTP if needed.

K

PM sent. ;)