Display Records
April 12th, 2008 by 
daniva 
Loading ...The following example demonstrates how to display all records from a table. and loop thorough a record-set.
April 12th, 2008 by daniva Loading ...Display records where "Departure_Initials" starts with an "L"
April 12th, 2008 by daniva Loading ...This example uses the QTP_Flight32 DSN to database connection.
The example is based on the Flight Reservation demo database.
Delete a Record from a Recordset
April 1st, 2008 by daniva 
Loading ...The following code demonstrates how to delete a record from a table.
The example uses the Flight Reservation Database ( non default records )
Create a Table in a JET Database
April 1st, 2008 by daniva Loading ...The following code demonstrates how to create a new table in the Flight32.mdb
Create a New JET Database
April 1st, 2008 by daniva Loading ...The following code demonstrates how to create a new database named New_db.mdb.
Add a New Record to a Table
April 1st, 2008 by daniva Loading ...The following code demonstrates how to add a new record to a table. The example uses the Flight Reservation Database
Sort data with disconnected record set
April 1st, 2008 by daniva Loading ...Sorts numerical data using a disconnected record set.
Retrieve a list of the system DSNs installed
April 1st, 2008 by daniva Loading ...If you have no idea what we’re talking about System DSNs are simply a shortcut method for connecting to databases and other data sources. You can view a list of the System DSNs available on a computer by bringing up the ODBC Data Source Administrator dialog box and looking on the System DSN tab
Get a list of the ODBC drivers installed
April 1st, 2008 by daniva Loading ...The registry, is the upstairs closet of the operating system: if you’re willing to look, you can find almost anything in the registry. That’s where can be found the list of installed ODBC drivers, in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers.
Create and delete a DSN
April 1st, 2008 by daniva Loading ...a DSN, is a way for you to connect to a database merely by referencing the DSN name, and without having to specify the entire path to the database. That’s particularly handy if you have a bunch of scripts that access this database. If you hardcode the path into the scripts and then move the database from one server to another, you’ll have to edit the path on each and every script. If you use a DSN, however, you won’t have to edit the scripts at all; instead, you just need to modify the DSN. That’s one change versus hundreds of changes (depending on how many scripts you have).
Determine which version of access was used to create a database
April 1st, 2008 by daniva Loading ...While looking up something else in the Access documentation we ran across a property named FileFormat. FileFormat is the property that tells us which version of Access was used to create a database. Want to know which version of Access was used to create the database flight32.mdb? ( The flight application’s QTP demo ) Here you go:
Recent Comments