Re: SQLite 3 Database Editor
Quote:
Originally Posted by Kimera
is this wrong to do?
Yes, you already posted it in another forum, no need to relink back to it. I could see if it was an old thread and someone needed help with an SQLite 3 Database Editor, but you basically did it simultaneously. And people do not "tend to forget about other sections in this forum" because the File Archive is a very active forum as well, so that doesn't really justify it. And have you ever seen anyone else post something in the File Archive, then make a thread about it in here? It's not rewarding of the death penalty, but I wouldn't do it again. And yes, it is in the wrong forum, this is the support forum. I would think promotion of something you made should go in the Open Topic Community forum.
Re: SQLite 3 Database Editor
See, I knew I was messing up! Just trying to help out, sorry! And though I have seen posts with links back I have never paid attention to see if they were done at the same time or not but I would like to thank you for taking the time to let me know.
I would like to apologize as well for projecting my inability to keep up with all the changes in this forums, due to a lack of time, on to other users, I hope nobody got hurt or got anything on them. ;)
As for it being the wrong forum, I didn't ask that question. What I ask, you already answered when you pointed out I should not post an informational post about a new file made available in another part of the forum at which point would even make the Open Topic Community forum an improper place to post about a post you posted somewhere else in the forum, as you pointed out by asking if I had ever seen anyone do that in the past. Never the less, I am grateful for you letting me know that this would be the wrong forum for posting that type of thing.
You will have to forgive me, I have been around for years but don't really know the ins and outs of forum procedures as it seems that every time I try to get in to them someone who thinks they know everything comes along and is just rude enough to prevent me from wanting to participate in the forum. I am hoping that I can give back a bit to this forum as Click Team has done so much for me in keeping MMF a product that is current, flexible and powerful.
The last thing I will leave you with is a bit of advice. When someone makes it very obvious that they may have done something wrong letting them know is obviously the right thing to do but to do so in a condescending manner is not needed nor something anyone in this forum should have to put up with just and is not justified by anything.
Thank you,
K
Re: SQLite 3 Database Editor
Sorry, if that came out in a demeaning tone, that's not how I meant it. But its no problem, repeated misuse would be, but I wouldn't worry about this. And I thought you were asking if it was in the correct forum when you said:
Quote:
Originally Posted by Kimera
Hope I don't get in trouble for posting this here
So sorry for any misunderstanding, and good job on the Database editor. :)
Re: SQLite 3 Database Editor
No Worries and thanks Brandon, that means a lot to me coming from you! I don't get it right often, whatever it is, when it comes to dealing with people when I am not face to face. Something always seems to go wrong. I think it's the lack of emotion of the web. ;)
If only we could get mood computers that, when in chat, would change the color of the persons computer case based on your mood. hehe. OK a bit much I know.
Later,
K
Re: SQLite 3 Database Editor
Actually, that call is really up to the Admins/Mods of the forum.
Normally we do not allow cross-posting, or mis-posting, so that would be the correct assumption.
As far as I am concerned, the work that Kimera is doing has a potentially strong impact on professional use of MMF2. That's always good!
So, all is good and we can let this thread stand as a special case.
Re: SQLite 3 Database Editor
Thank you Novabrain.
I will keep working on it and I will keep you posted.
Much luv!
K
Re: SQLite 3 Database Editor
Wow, very professional and the user interface is well done. Congratulations.
Sugestions:
- On screen resolutions under 1024x768 some portions of the window are cropped and the buttons can't be seen.
- How about returning the error message if existent when the user runs an SQL statement?
This is looking very good.
:)
Re: SQLite 3 Database Editor
byo you snuck in on me bud. I have been looking out for you to say thanks for the object, it's great. In fact I wrote and posted a new widget that uses a SQLite 3 DB to hold a list of menu configurations. It uses the Icon View object and a button object to create an Outlook style menu where the buttons move from top to bottom based on the button you clicked on. It was so cool to be able to just send one SQL statement and restart the app and get a different menu. I needed one for the MMFDBE so I made it a widget. Right now it only does Vertical menus but Horisontal is comming I just want to get all this worked out first and there is along list of things I want to do, including the two you just gave me. hehe
Could you send me a screen shot to show me what you are talking about with the buttons. The screen res is the size it is since my new laptop is some messed up res and I have to hide my Task bar to see the bottom of the app. Adding full functionality for scalling is on the list. Though I thought the MMFDBE was running better than it is, it can still be used if you want to put up with the Table Creation issue. It still needs some time put in to it to make it somehting I feel would be worthy of a "release" but it currently works for my needs and you can bet I will keep working on it.
I would like to know why the 2 sql objects. Server/SQLite 3 Was this because you don't have full SQL functionality in SQLite or is there something else I am missing?
Also if I didn't tell you THANKS FOR THE EXTENTION!
U Da Man!
K
Re: SQLite 3 Database Editor
Thanks for the comments, Kimera.
Today I was showing your application to a bunch of my workmates and they thought it was cool. :)
Quote:
I would like to know why the 2 sql objects.
You mean SQL Server and SQLite3? My company works with SQL Server and I think it's a very stable and established technology and I'd like to implement that inside MMF2. I know you can make a workaround using ODBC but some tests of mine (in many machines simultaneously) showed that ODBC is slower than using ADO.
Since every database engine has some distinct functionality my intention was to provide these individual functionalities natively. Database application is somewhat an essential part of most IT companies and have so many applications like hospital, libraries, scientific research, product catalogue, clients, etc.
I'll be watching your projects closely. ;)
Re: SQLite 3 Database Editor
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
Re: SQLite 3 Database Editor
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
Re: SQLite 3 Database Editor
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?
Re: SQLite 3 Database Editor
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
Re: SQLite 3 Database Editor
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.
Re: SQLite 3 Database Editor
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