Pcdsql – Kofax DM API User Manual
Page 136

116 C
HAPTER
3
PCDSQL
'Set the Library.
If nResult = 0 Then
nResult = oUpdateSQL.
("MyNewLibrary")
Else
MsgBox ("The
call failed.")
End If
'This function does not return a SUCCESS/FAILURE
'value. Instead, it returns the numeric value of
'the DB Vendor.
If nResult = 0 Then
nResult = oUpdateSQL.
Else
MsgBox ("SetLibrary call failed")
End If
'This SQL statement retrieves two columns.
nResult = oUpdateSQL.
( "SELECT “ _
& “USER_ID, FULL_NAME FROM DOCSADM.PEOPLE")
'Load put data from the SELECT into the list Box.
'Then, determine which list box item is in focus.
nNumRows = oUpdateSQL.
'Fill up the ListBox with result set data.
For i = 1 To nNumRows
nResult = oUpdateSQL.
(i)
'Place the User ID in the buffer.
sTempBuf = oUpdateSQL.
(1)
UpdateForm.lstUserIDs.AddItem(sTempBuf)
Next i
'Select the first element in the listbox.
lstUserIDs.Selected(0) = True
'Match the item selected in the list box with
'the data in the textbox.
nResult = oUpdateSQL.
(1)
- AP Automation (18 pages)
- AP Automation (12 pages)
- TotalAgility AP Automation (43 pages)
- SupplierExpress (80 pages)
- SupplierExpress (94 pages)
- SupplierExpress (6 pages)
- Capture (12 pages)
- Capture (10 pages)
- Capture (14 pages)
- Capture (44 pages)
- TotalAgility (28 pages)
- Getting Started with Ascent Xtrata Pro (623 pages)
- Export Connector 1.0.0 (10 pages)
- Export Connector 1.0.0 (12 pages)
- Export Connector 1.0.0 (6 pages)
- Export Connector 8.0.0 (16 pages)
- Export Connector 8.0.0 (14 pages)
- Export Connector 8.0.0 (8 pages)
- Export Connector 8.1.0 (12 pages)
- Export Connector 8.1.0 (16 pages)
- Export Connector 8.2.1 (26 pages)
- Export Connector 8.2.1 (6 pages)
- Capture Export Connector (30 pages)
- Capture Export Connector (18 pages)
- Release Script (24 pages)
- Ascen 7.0 Release Script (36 pages)
- Ascen 7.0 Release Script (32 pages)
- Ascen 7.0 Release Script (48 pages)
- Ascent Captur (30 pages)
- Export Connector for Fax 1.1.0 (10 pages)
- Export Connector for Fax 1.1.0 (8 pages)
- Export Connector 8.2.0 (10 pages)
- Export Connector for TotalAgility 1.1.0 (10 pages)
- Export Connector 8.3.0 for Microsoft SharePoint (18 pages)
- Capture Export Connector for Documentum 6.7 (18 pages)
- Export Connector 7.6.0 (8 pages)
- Export Connector 8.2.0 for IBM FileNet Content Manager (30 pages)
- Ascen 7.0 Release Script for FileNet Panagon Content Services 5.2-5.4 (30 pages)
- Export Connector 8.1.0 for FileNet Content Manager (8 pages)
- Ascen 7.1 Release Script for FileNet Content Manager 4.0 (48 pages)
- Ascen 7.5 Release Script for FileNet Content Manager 4.5 (42 pages)
- Capture 8.0 Release Script for FileNet Content Manager 5.0 (30 pages)
- Ascen 7.0 Release Script for Hummingbird DM 5.0-5.1 (46 pages)
- Ascen 7.5 Release Script for Hummingbird DM 6.0 (45 pages)