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

**** Access97 Descripton Program !! ****

This code allows you to connect to a SQL Server database without creating an ODBC Connection.

Have you ever wanted data to be returned a page at a time? For example the data you requested returns 200 rows and you want to return them to the user 1 page at a time? Well now you can! PS!! Do not forget to rate this software. This results in more code!! Thanks.

Corrects for reserved SQL characters in SQL queries. This will correct your SQL statement if an apostrophe or 'pipe' character is in the SQL query. It is a better fix than the SQL functions which replace ' with '' because those will actually still fail in certain situations (such as in FindFirst commands).

This code can literally do anything you wish with an INI file. Here are a list of the 21 INI functions that I created. These took me a long time to make, so please let me know what you think. A program is included that explains everything completely...from how to use the functions...to an explanation of each variable. GetKeyVal(), AddToINI(), DeleteSection(), DeleteKey(), DeleteKeyValue(), TotalSections(), TotalKeys(), NumKeys()-"To count how many keys in 1 section"-RenameSection(), RenameKey(), GetKey(), GetKey2(), GetSection(), IsKey(), IsSection(), KeyExists(), KeyExists2(), SectionExists(), GetSectionIndex(), GetKeyIndex(), GetKeyIndex2().

Stored Procedure Generator for SQL Server 7.0

When using Autonumber fields in a database for a UID, you might need this value after you add the record, for that record. This is my example of how to get that value back from the database after it is added using DAO or ADO.

BUG correction!!! Version 1.01 A solution for who does not want to use ADO/DAO or ODBC to have access its database in MySQL. With only one DLL you it has the power on all functionalities of the MySQL.

vbs script code , using recursion , collections , this code convert xml files into sql recordsets. Usefull for search purpose , news management etc...

In this example I try to show you how to connect the ADO object to Excel file directy , without copy any data from the Excel file to DataBase first ( like MS access) , plesae vote for me :)

A nice student database with a very user-friendly environment. (an idea of Mr. R. A. Baltazar)

Este codigo facilita las conexiones mediante el ODBC creando un DSN segun el driver (class) que se este usando (Access, Dbase, Paradox y MySQL 3.51 en esta versión). Estupenda herramienta para los programadores de aplicaciones que usan bases de datos tales como Paradox o Dbase. Duda o sugerencia favor de ponerse en cotacto conmigo. With this code, u can connect to many databases formats using ODBC, like Paradox, Access, Dbase or MySQL, with a short numbers of lines and easy. Try it :-)

Automatically generate a function to create an Access 2000 Database With ADO. I catalogue this program like a utility. This utility generates a function that you can use inside your apps to create an Access 2000 Database With ADO Reviewed Verion 1.1.0!

Created for a barcode scanner. it stores the price, barcode and product name for an item. You can do a search for items by product name or by barcode. Also has an attempt at a registration enabled program which requires a valid username and password to register the program.

While searching for a way to repair a corrupted database file, that couldn't be fixed with just Repair and Compact, i found this undocumented option that prooved to repair and optimize my database file. Read the whole article. Any comments or feedback are welcomed.

I have received a lot of responses to my code posted earlier ( a generic object that assisted in returning recordsets from Oracle). Most of these questions have been in the domain of the stored procedures themselves. Hopefully this article and example stored procedures will help clarify.

This code demonstrates how to access a POSTGRES SQL database on a LINUX box via an ODBC connection. The demo ( using RDO ) shows you how to create a table, wipe a table, insert data, select data, modify data and write the modified contents back to the database.

This code allows for multiple record updates to be grouped into a single batch style transaction. You can then either committ changes to multiple records, or rollback the changes in the case of errors or conditions not being meet. This code is ideal for month-end processing, or in a situation where there is the possibility of errors being generated.

THIS CODE IS NOT THE SAME AS THE AUTO_COMPLETE FEATURES FOR VB5 LISTBOXES AND COMBOBOXES. This code is a class-module that enables VB6 DataCombo controls to function like MS Access combo-boxes. It adds an auto complete feature whereby when the user begins to type text in the combo it automatically searches through the list and completes the entry

if mdb_dsn_connection doesn't exist... then make it