Results for "Category: Databases/ Data Access/ DAO/ ADO"

This is my first post on PSC and it happens to be my biggest program ever attempted. It is not really clossed to finished but it proves that it can be done, it is a fully functional DBMS made in VB, this includes SQL queries, multiple tables, unlimited columns, validation rules, editing feild properties. This program is not yet in beta stage, with large amounts of work to be done. I am posting this to get feedback from other people on things I could add to make the program much better or change to give it more functianality. All comments are welcome. My main reason for posting this is that a few days ago the VB code of the day was a table so called DB creater, but could only take one table. There is a lot of string manipulation in this with the DB save in a plain text file (yes I know that could become corupted easily, i am going to work on measures to prevent that and solve coruptions) In certian sections the program is fairly well documented but in others not, thats something I need to do soon. Well please give me any feedback or even test the system out, included in the ZIP is an example DB called Test.bvd you can load this and mess around with it, delete records, do SQL queries, add records, export as XML and all, some of the functions in the menu do not exist but are there to remind me of what is to come :P If you wish to vote for this do so, but as I said the program is not finished, it is more a proof of concept to show others that it is plausible. Its around 4K lines and will probably be 10K by the time it nears finish time. Jonothan Tompson

This is a very usefull code, which i want to share it with u all, as i am working on an accounting package, this package closes it files at year end, and places it in backup database files. But the running year may need reports based on old data, i.e. the date range from the close file. Here is the SQL which can be used to get data form multiply database file in the fastes possible manner.

This piece of code shows how to connect to mySQL database using Visual Basic, myODBC 3.51 and DAO 3.5. It is very simple for understanding and code is commented. If you think that code is very helpful, you can vote for me.

Connecting to MySQL 4.0.2 using myODBC 3.5 & ADO 2.7 without creating DSN in ODBC DataSources in ControlPanel. In this sample is a code for adding records, showing records in listview removing selected records from list, searching records (you can search for records by name or by surname or both. Inside code is description what you must do before running code.

This is a Sales and Inventory created in Visual Basic 5 for the fulfillment of the BSCS course in Asian College of Technology in Cebu City, Philippines. It is originally programmed by Jerson Chy(super programmer) and was re-designed by Ted Antonio(computer hacker). Hope to receive messages on this system..It is complete and very useful and it can even be sold to anyone who wants it...Happy selling this product

This is very simple address book keeping data for your nearest one and also getting alerts for the reminders of the birthdays.Please Vote for me if you think I did good job.

Well.. for those who where happy about the previous version, heres a little update with scripting for Views, StoredProcs and missing tables. Works like a tierelier (Dutch ;-)). For those who don't know about the previous version, it compares 2 SQL-server databases. Also if somebody doesn't know how to implement a splitter, here's a idea how to do that :-).

The reason of doing is because I need to install my application together with database (schema & lookup data) at the client site. Of course we can do this using different approach like BACKUP/RESTORE, or MS Access upsizing. In my case, I need to script all the schema and the lookup data to have a better control to the setup file. Download VB6x LIbrary before using this program. http://www.geocities.com/adhadi/HadiLIb.zip

translate from english to : 1)french . ( 3257 words ) 2)german . ( 9600 words ) 3)spanish. ( 7487 words ) 4)italian . ( 5160 words ) 5)portogue . ( 1375 words ) very simple, very fast , searching from a txt file.

Everyone knows, that VB's reports can only make static reports... And what can we do to make report from dynamically selected data? Here is the answer: we only need to use HTML Reports - easy and powerful solution for creating HTML-based reports. This is the initial version, I think, that some improvements can be implemented in the future... Please leave your suggestions, comments AND VOTES :-) Thx.

A nice student database with a very user-friendly environment.

A database application that allows you to connect into two drivers: MS Access, and MySQL Server. It has instructions on how to create the database in MySQL Server. Uses ADODB and SQL statements. Has nice GUI too.

This inventory system for tires include: Administrator Password, User Account, Tire Maintenance with Category, Tire Size and Tread Pattern Data Entry and Data Report, Customer Maintenance with Data Report, Sales Invoice with Receipt, Printable Monthly Earnings and Order Slip Form with Supplier Data Entry. Made with ADO. 100% working and bug free. *Administrator password is "DBMS".

The code uses the Microsoft Access security utility that sets database password by which the program is only the one who can access the database. It also allows you to create and delete an account by having a "USER LEVEL" and a "ADMINISTRATOR LEVEL" feature. To summarize up this code helps you to add a security form to your application...generally looks like WINDOWS logon...

PURPOSE OF THIS PROGRAM IS TO GENERATE PAYROLL BASED ON INDIAN HR SYSTEM INCLUDING ESI,EPF etc. YOU MUST HAVE LITTLE KNOWLEDGE OF ORACLE TO RUN THIS PROGRAM SUCCESSFULLY OR JUST FOLLOW THE INSTRUCTION AS GIVEN IN README.TXT FILE. !!!! YOUR VALUABLE VOTE REQUIRED TO ENCOURAGE IN FUTURE !!!!

Shows how to use INI files as highly flexible,huge databases!!

This little utility allows the user to select an Access database and then generates the code to make a connection. It also allows the user to select a table from the database which then generates a simple SQL. Also attached are instructions for use and a test program If there is sufficient interest I will continue to develope code writing programs and submit them to PlanetSourceCode. Although a few votes would be nice I am more interested in feedback. Taken from an idea by Carlos Vara, thanks.

I had problems using the datagrid attached to an ADOdc control. Here is what I found.

This is a Report program desiged for an export corporation. It Uses ADO. You can add, edit, sort, search and print(with printpreview). Additionly you can set autobackup for defined times and can add logon feature, systemtray icon and more...

1) make blob compress, uncompress, retriving, updating, inserting as simple as normal select statement. 2) support multiple blob fields in 1 table support insert, retrive, update from file or memory 3) sample call RetrieveBlob(ADODB.Connection, sSql, sOutput) As String : retrieve single blob from database, RetrieveBlobToFile(ADODB.Connection, sSql, blobfiles, sOutput,recordSet) As recordCount InsertBlobFromFile(ADODB.Connection, sSql, vBlobfiles) vBlobfiles as array of files or fileName InsertBlob ADODB.Connection, sSql, vBlobs vBlobs as string or array of string UpdateBlobFromFile ADODB.Connection, sSql, vBlobfiles UpdateBlob ADODB.Connection, sSql, vBlobs sample input sql clause: insert into sTableName values(1,"ke,dfs,y",?,?,getdate()) insert into sTableName values(1,'ke,df"s,y',?,?,22-May-1992) select a, c from sTableName where key = 1 update parameterxml set a='ere',b='?' where d ="dfds" NOTE!) compress and uncompress are invisible to user !!!compress tool is not publish with this tool. (in order to use) comment out the compress part or replace with your own compress tool