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

This will show you how to code in Linux using g++.

A simple hospital system. Can add, update, retrieve and delete records like patient, ward, employee... I think it's helpful for those who want to know about how to update and delete record. Please give your comment so that I can improve on it.

Memory leakage is probably one of the most difficult programming problems to solve. This article tell you why, and how to do it.

response.write is okay for simple debugging but can become intrusive and cause formating problems itself. This simple script will display your debuging in a pop up window.

Creating a user friendly error handler. This Friendly Error Handler pops up a VB liked dialog box to display error messages.

A small script mixes ASP and Javasript to make messages alert or for the debugage.

The following function creates a user. You can execute it under any user you like. dror-a@euronet.co.il (Dror Dotan A')

A short routine that backups the tables from an open Access database George Kinney

How do you avoid the "Invalid use of null" error when reading null values from a database?If you try to retrieve a null value (empty field) from a database, you will get the error: "Invalid use of Null". Here is one way to get around this problem: ..

How to copy a database table. This may require some tweaking.... "Bill Pearson"

An easy example of Searching for records in a database. I posted this code last year without an example so here it is.

Allows you to select a ascii file and import it into your database. Example provided!

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.

Have you ever try so send a string variable to MS Access that have apostrophes using a SQL Statement? If YES you will get a run time ERROR Here is your solution....A function that formats the variable before sending it to the database.

This code creates a Microsoft Access MDB dynamically.

VERY VERY SIMPLE CRYSTAl REPORTS VIEWER - View Any Crystal Report with ease..lets you add reports to a list that you use all the time. Also allows for changing the parameter values. Very easy to understand code -- example report included. Hope you enjoy.

It is nice technique for dbgrid sorting.You can sort Dbgrid Columns by clicking on the grid column header in two ways ascending or descending.

This simple little function just returns the total number of records in a ADO recordset.

A utility to import/export Access database from/to other application formats, e.g. Excel and text files (single field or delimited entries for multiple fields). With sample files and help, as well as ample remarks. It is advisable to run the sample files first (and read remarks in each frame). Once you are familiar with the pertinent rules, you may then begin to use the program to process your other files.

Heres the update to my Address Book Example that pulls it information from an Access Database. I finally added the search and delete functions because I got tired of getting email from people asking me to write the update. :) Sorry it took so long but I've been busy opening up my office... Email any questions you have or comments to plexxonic@softhome.net