A fast DataBase driver without ADO, DAO reference, in pure vb. It is not using any third party product. The Data is stored in a standard text file, in the most simple format. The driver is made in Class as well as ActiveX Control. Most of the basic functions are included. You can view the data structure by opening the file in Notepad. You are free to use it and give me your feedback. Good Luck!
Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. Afterdownloading it, you will need a program like Winzip to decompress it.Virus note:All files are scanned once-a-day by Planet Source Code for viruses, but new viruses come
out every day, so no prevention program can catch 100% of them. For your own safety, please:
Re-scan downloaded files using your personal virus checker before using it.
NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.
Scan the source code with Minnow's Project Scanner
If you don't have a virus scanner, you can get one at many places on the net
including:McAfee.com
Terms of Agreement:
By using this code, you agree to the following terms...
You may use
this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
You may link to this code from another website, but ONLY if it is not wrapped in a frame.
You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.
Hi Jim Don't you like smart As_es.Actually I like what you have done. There is room for improvement as all projects do when they are first started. I have worked with many DB types over the years and this has potential. Infact I am developing some software for a home made CNC machine and I keep track of some information in text files. I tryed your method out and it will work just fine for what I am doing. When I get a bit of time in the next couple of days, I will send some suggestions. Thanks again for the idea. (If this comment was disrespectful, please report it.)
Hi not a bad little start you made there.ok here are some suggestions. How about some table support that can also be packed into one file. and also options to add multiply fields names, field types, field sizes etc.
I am sure that will be quite easy becuase you have already got a sort of base for it.
5 from me. (If this comment was disrespectful, please report it.)
Thanks for your comments. As dreamvb said, this is only a starting work on this purpose. I submitted it now to get your comments and suggessions to make it perfect. I will try to add those features mentioned.
Thanks again and welcomes more comments! (If this comment was disrespectful, please report it.)
I think it is good that this does not have lots of extra features since, as it is, it relatively easy to modify to suit oneself ***** (If this comment was disrespectful, please report it.)
Nice start. I like the fact that the files are simple TXT files, as this makes editing and locating record information possible without the need for a special library. Have you considered this same concept, but using XML schemas? Just a thought....5 from me!
TerriTop (If this comment was disrespectful, please report it.)
Looks like a good start. Some things that will make it a little more usable.
Example:
Public Property Get EOF() As Boolean EOF = ((m_RecordPosition + 1) > (RecordCount - 1)) End Property
Public Property Get BOF() As Boolean BOF = ((m_RecordPosition - 1) < 0) End Property
And to make it faster would be to set a variable for field count once you open the file. Use Mid$( instead of Mid(. Other than that its 5 globes. (If this comment was disrespectful, please report it.)
Nice and clean coding. It has potential for improvement, but it is a pretty good start, nonetheless. 5* (If this comment was disrespectful, please report it.)
This is a good single class solution for simple data storage & some good code for those new to the file statements. (If this comment was disrespectful, please report it.)
5/20/2005 6:52:31 AM:
Hi Jim, nice code! There is a little thingy when searching exact whole strings. Maby there shoud be a line for exact strings. Now searching for "Emp Name 111" results "Emp Name 1110" and also "Emp Name 1111" & "Emp Name 1112", etc. 5 Globes for your code anyway, but love to see it getting updated! (If this comment was disrespectful, please report it.)
Actualy the find function is realy in an infant stage. I will surely add [match case] and [Find whorl word only] option.
I am preparing a 'DataBase Builder' for this. Soon that will be available!
How many of you wish to have [multiple tables] in the next update???? (If this comment was disrespectful, please report it.)
5/20/2005 1:32:39 PM:
I learnt a lot from it. And as PSC sharing is about learning, this is good. Thanks Jim. (If this comment was disrespectful, please report it.)
5/20/2005 4:55:07 PM:
That would be nice Jim [multiple tables] + manually changing m_FieldLen would be great! Keep up the GOOD work! (If this comment was disrespectful, please report it.)
Wow that would need complete database replacement. Ok, I will try that!!!. Thanks for your suggession and votes. (If this comment was disrespectful, please report it.)
5/21/2005 6:18:02 AM:
Little sarcasm! Sorry for the misunderstanding. By manually I ment, there would be a function within the code to give FieldLength instead of writing the length in the Text-file manually. This way it is possible to start the writing-process without making a text file first (and writing 30,30,20,20>). I know this is a little tricky, maby this way there would be need of 's or character specific [Split]'s. This could slow down the search process... But anyway, thx for your quick respons! (If this comment was disrespectful, please report it.)
6/7/2005 1:11:34 PM:
Are you planning to upgrade your code? (If this comment was disrespectful, please report it.)
I already created multiple table, field, FieldName properies to the database driver. I am now creating a 'DataBase Builder' for easy building of database file ( since there is multiple table it is not easy to make it manually on Notepad).
I have a plan to build a 'DataSheet' activeX to use the file in any other program and edit it as MsAccess datasheet.
What you think?? (If this comment was disrespectful, please report it.)
6/9/2005 9:55:21 AM:
Very nice! Will it stil be open source? (If this comment was disrespectful, please report it.)
6/11/2005 5:46:46 AM:
Good...good!Keep working (If this comment was disrespectful, please report it.)
Nice code, thanks for sharing. 5 globes from me. If the code that I saw within this upload is in such a good state, I am very impatient to see what it has become in the next upgrade. Hope to see it soon! (If this comment was disrespectful, please report it.)
6/28/2005 4:57:35 PM:
I am most curious about the progress of the 'DataBase Builder' (multiple tables generation etc).... Need some help?
(If this comment was disrespectful, please report it.)
I don't know how much I can satisfy ur needs on the 'DataBase Builder'. I will try my best, and only with ur help I can complete it. (If this comment was disrespectful, please report it.)
6/29/2005 5:35:37 PM:
What kinda help do u need? (If this comment was disrespectful, please report it.)
Hi Jim, this's a great program, you still work in this project?, I think is excellent if you can implement multiple tables, fields, fieldsize, fieldtype and support SQL sentences.
Thx for the idea and if you need help with this, I can help you coz this program is sensational. (If this comment was disrespectful, please report it.)
Ooops, I am currently not working.. but using a modified version of this code. Yeah, I worked for a long term(not sooo long!!) for getting it into multiple tables. But, things become more complex and I can't get it bug free... So I gave up temporarly!!
The probelm is.... For using multiple tables, I used to storing data in two formats(two structures) and need to be splitted into seperate files at the time of opening it. Then modifying each files seperatly then combine into one main file(when terminating the connection)... Isnt it a bit confusing???
If u have a better idea to get multiple tables... please inform me!!
I know u r good in php(i am not). But I made exactly the same database system as a php class file(needs many more fixes) If u are interested please mail me.
Jim Jose (If this comment was disrespectful, please report it.)
Sparq I live in Mexico and a years ago, I saw this technique but using other language, anyway it´s great this idea. (If this comment was disrespectful, please report it.)
I followed the tip regarding the Cheetah database.
It was awesome!! For very simple apps your code is good enough I think. But anyway I would highly recommend Cheetah to anyone. Saved me tons of time. (If this comment was disrespectful, please report it.)
I just submitted the php version of this code on PSC-vb section. You can find it here.... http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=2044&lngWId=8 (If this comment was disrespectful, please report it.)
Cool :) How about use .dbf for your data? I'll give some rocks**** (There allways room for improvement) (If this comment was disrespectful, please report it.)
Hmmm interesting concept... I'm gonna check this out, see if it will work for my project. Keep it up! (If this comment was disrespectful, please report it.)
Excellent, easy to use, solid piece of work - Thank you very much - This is very good in a single stand-alone environment & project - but I think it will struggle a bit in a multi user enviroment, due to the sequential nature of the file access and file lock.
I will be using this in my next project - I love it.... 5 Globes from me... (If this comment was disrespectful, please report it.)
Is it possible to include reports like data reports in this program? If you could somehow do that, it would be great.:) (If this comment was disrespectful, please report it.)
Can i add more things? that he adds in a txt because i m making a program that saves my runescape accounts with Pass acc recovers.. so i need 7+ saves do u know how to? Mail me please. (If this comment was disrespectful, please report it.)
Very Nice, I use it on my Project right now !!Planet Sourse Code Team !!!Thank u for sharing cods.,,! (If this comment was disrespectful, please report it.)
Add Your Feedback
Your feedback will be posted below and an email sent to
the author. Please remember that the author was kind enough to
share this with you, so any criticisms must be stated politely, or they
will be deleted. (For feedback not related to this particular code, please
click here instead.)
By 49 Users
Download code
5/17/2005 4:55:56 PM: 
