Database 66

To deal with database and maintain it
  2. Categories
  3. Database
Sorted from new to old.
Card image
LastInsertedID_SQL

Get the ID of the last inserted record in a table. There are other methods, ...

2019Jul18
Card image
ANmaDB functions

Database functions, commonly used in my systems. Should be working for each ...

2019Apr14
Card image
DBMySQLVBA API

An API to allow connecting to MySQL database from VBA (or VB6), found it a ...

2019Feb3
Card image
DB Class

Database Class in Classic ASP An old article I found that helps a lot these ...

2018Dec25
Card image
Split string into table

Returns tag words (as table) in Microsoft SQL Separator set to comma, but you ...

2018Dec18
Card image
Import error log

Imports the SQL Server error log into a table, so that it can be queried This ...

2018Sep29
Card image
Arabic SQL+ASP

Enable Arabic in MSSQL DB, the correct way, as of Sep 2018 Tested in Alwah and ...

2018Sep24
Card image
RandomRecords

Returns random IDs (or any column) from SQL Database table, passing number of ...

2018Jul29
Card image
MSSQL DB Connection

Connects to MSSQL database from Classic ASP All DB variables need to be ...

2018Jul29
Card image
MySQL DB connection

Connects to MySQL database from Classic ASP All DB variables need to be ...

2018Jul29
Card image
DB_SettingRead_Field

Returns a certain field from Settings table by a SettingName. Similar to ...

2018Jul24
Card image
Modify SQL table

SQL seams to have issues when we try to modify a table and preserving data, I ...

2018Jun9
Card image
DB_Setting1List + DB_Setting1List_NameValue

DB_Setting1List is to Returns list of SettingValues matching certain ...

2018May31
Card image
DB_Setting2Read + DB_Setting2Save

Reads and save setting into settings table per 2 IDs, similar to SettingRead ...

2018May31
Card image
Connect to UDL

Use a UDL to make your connection to a database

2018May27
Card image
DB_AllRows

Returns all rows found from an SQL Query as string Separated by row and column ...

2018Apr23
12345