Knowledgebase: Data & Table
[QODBC-Desktop] Vendor Custom Field Label Captions
Posted by brad waddell on 12 March 2009 05:21 PM

Where the Vendor Custom Field Label Captions come from

In QuickBooks

      Custom Fields are created within QuickBooks. The Label names can also be modified at any time also.

      In an example, when editing a Vendor, click on the Additional Info tab page:

     Click on the Define Fields button to create and modify your Custom Fields as required:

In QODBC

     In QODBC the Custom Field Label appears as: CustomFieldname (with the name of the custom field, without spaces, as shown in QuickBooks) as can be seen in VB Demo by running:

     sp_columns Vendor

Using Custom Field Names via Programming

To determine the Custom Field names via programming, just do:

Const adUseClient = 3
rs.CursorLocation = adUseClient

strSQL = "sp_tables"
'Open rs
rs.Open strSQL, cnConnection, adOpenStatic, adLockReadOnly

And loop through the recordset for each table:

then:

strSQL = "sp_Columns """ & sTableName & """"
'Open rs
rs.Open strSQL, cnConnection, adOpenStatic, adLockReadOnly

And spin through the columns for that table.

(148 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).