This database class handles Select, Insert, Update, and Delete. It also takes steps to ensure your SQL syntax is valid, and that memory leaks / errors are prevented. Tutorial comes with demo, downloadable code, and an in depth explanation.
It is very common operation to request one field of information via a database query. This is called a singleton query. ADO.Net has specific functions for singleton queries, but not ADO (ActiveX Data Objects). This article describes how to use an ADO command object to perform faster singleton queries.
This writing will discuss several things to do to ensure the application migration carried on in a good way, particularly for ASP Database applications and to overcome possible problems might occurred. Basically, migrating ASP to Linux means you have to convert to database supported by Linux platforms. Currently, Chili!Soft ASP is already supporting MS Access but not all web hosting companies install this feature. They prefer to use more common database in Linux such as MySQL and PostgreSQL. Pay attention to some Chili!Soft specific ADO methods and properties, since there are slight differences with IIS ASP. You might need to convert some codes in your applications to make it run in Chili!Soft ASP.
Platform(s): Linux, Windows, FreeBSD, Mac OSX, Sun Solaris
Following example, extracts all of the records in a database table and stores into a 2-dimensional array. This gives you an advantages to modify and work on data.
Sum function can be used for to get the sum of a numeric expression evaluated over a set. This function must be placed in an SQL statement. Following example will return the sum of ratings in articles.
Sample implementation (source code)illustrating how to implement a "Suggestion Box" style form using ASP and MS Access. Easily installed, and customized.
This source code can compact and repair your MS-Access database files. If you compact your access files regularly, it will work more faster and secure. Also you will save some hard disk space.
0.0
3.0
5.0