Function AccessShowReport

The function below can be used to preview a report created in MS Access. 'Purpose : Preview an Access Report from VB 'Inputs : sAccessDBPath The path and filename of the access database containing the report to show ' ...

READ MORE - Function AccessShowReport

Connection Type

Microsoft Excel is a component of MS Office application, which is useful to create spreadsheet. This Office utility is fruitful to create and maintain huge lists easily and effortlessly. It is used for storing contacts, doing statistical analysis, performing...

READ MORE - Connection Type

SQL ODBC connection

SQL ODBC connection stringsStandard Security:< br> "Driver={SQLServer};Server=Your_Server_Name;Database=Your_Database_Name;Uid=Your_Username;Pwd=Your_Password;" Trusted connection:< br> "Driver={SQLServer};Server=Your_Server_Name;Database=Your_Database_Name;Trusted_Connection=yes;"...

READ MORE - SQL ODBC connection

SQL Functions

SQL Functions Keyword DescriptionCreate Function Ext_Orders(parmWhere CHAR(5)) CREATE FUNCTION names the UDTF and registers it with SQL. This function is called Ext_Orders (external orders). This name will be referenced by SQL statements using the function. You...

READ MORE - SQL Functions

C, C++ and Java Assignment Operators

C, C++ and Java Assignment Operators = -- simple assignment += -- add rhs, then assign to lhs -= -- subtract rhs, then assign to lhs *= -- multiply by rhs, then assign to lhs /= -- divide lhs by rhs, then assign to lhs &= -- bitwise and, then...

READ MORE - C, C++ and Java Assignment Operators

import java.sql

import java.sql.*; public class DataTransfer { private static String[] tableNames = new String[]{"SOME_TABLE_NAME"}; private static final int FETCH_SIZE = 100; public static void main(String[] args) throws ClassNotFoundException, SQLException { Connection...

READ MORE - import java.sql

Simple Database

A Simple Database Backup: You can use mysqldump to create a simple backup of your database using the following syntax. mysqldump -u [username] -p [password] [databasename] > [backupfile.sql] [username] - this is your database username [password]...

READ MORE - Simple Database