Application Notes for QuNect ODBC for QuickBase

First Steps

• Getting Started

• How to find the APPID of a QuickBase application.

• How to find the DBID of a QuickBase table.

• How to find the FID of a QuickBase field.

• Writing SQL Statements for QuNect ODBC for QuickBase

• QuickBase User Field Behaviour

• Bulk Uploading of Files to File Attachment Fields

Security

• Security

SQL Server

• Creating a Linked Server for QuickBase in SQL Server Using the UI

• Creating a Linked Server for QuickBase in SQL Server Using SQL

• Listing all your QuickBase Applications in SQL Server

• Creating a Data Source for QuickBase in SQL Server Integration Services (SSIS)

• Listing all your QuickBase Tables in SQL Server

• Writing a Simple Select Statement for QuickBase in SQL Server

• Slaving a QuickBase Table to a SQL Server Table with one SQL Statement

• Synching All QuickBase Tables in SQL Server

• Mirroring All QuickBase Tables in SQL Server

• Mirroring a Single QuickBase Table in SQL Server

• Mirroring the Schema of a Single SQL Server Table in QuickBase

• Synching a QuickBase Table in SQL Server

• Synching a SQL Server table in QuickBase

• Copying Records from SQL Server to QuickBase

• Optimizing SQL Server OPENQUERY with INSERT, UPDATE and DELETE

• Downloading File Attachments from QuickBase into SQL Server

• How to Manually set the Size of a QuickBase Field

MS Access

• Exporting a table via QuNect ODBC for QuickBase from MS Access

VB.Net, VB6 and VBScript

• Backing up a table to a CSV file

• Creating a connection string

• Opening up a table and reading the first column

• Inserting and Adding Records to a QuickBase Table from VBScript

• VB.Net Console Application for Copying Rows from a SQL Server Table to a QuickBase Table

Supported SQL Syntax

• SQL Syntax Supported by QuNect ODBC for QuickBase

• Using a CREATE TABLE statement

• Scalar String Functions Supported by QuNect ODBC for QuickBase

• Scalar Numeric Functions Supported by QuNect ODBC for QuickBase

• Scalar Date and Time Functions Supported by QuNect ODBC for QuickBase

• Scalar Type Conversion Function Supported by QuNect ODBC for QuickBase

• Adding a Master Record and a Linked Detail Record