# | Name,A,25 | Type,A,25 | Synopsis,A,255 | Category,A,20 | Syntax,F,40 | Description,F,40 | Example,F,40 | See Also,A,255 | User Level,A,10 | SQL-Specific,A,1 | ObjectType,A,255 | ReadProperty,A,1 | WriteProperty,A,1
|
---|
1 | MenuBuild | | Used in the built-in menuAction method. Reports when the Desktop is building a form's menu. | Constant | | | | | Advanced | N | | | |
2 | peGeneralSQL | | Reports the top error code in the error stack. | Constant | | | | errorCode, errorHasNativeCode | Advanced | Y | | | |
3 | beginTransaction | Database | Starts a transaction. | Method | | | | commitTransaction, rollbackTransaction, transactionActive | Advanced | Y | | | |
4 | commitTransaction | Database | Commits all changes made within a transaction. | Method | | | | beginTransaction, rollbackTransaction, transactionActive | Advanced | Y | | | |
5 | isExecuteQBEFileLocal | Database | Reports whether a QBE query will be executed locally or on a server. | Method | | | | isExecuteQBELocal, isExecuteQBEStringLocal | Advanced | Y | | | |
6 | isExecuteQBELocal | Database | Reports whether a QBE query will be executed locally or on a server. | Method | | | | isExecuteQBEFileLocal, isExecuteQBEStringLocal | Advanced | Y | | | |
7 | isExecuteQBEStringLocal | Database | Reports whether a QBE query will be executed locally or on a server. | Method | | | | isExecuteQBEFileLocal, isExecuteQBELocal | Advanced | Y | | | |
8 | rollBackTransaction | Database | Rolls back (undoes) all changes within a transaction on a server when transactions are supported. | Method | | | | beginTransaction, commitTransaction, transactionActive | Advanced | Y | | | |
9 | transactionActive | Database | Reports whether a transaction is currently active in a specified database. | Method | | | | beginTransaction, commitTransaction, rollbackTransaction | Advanced | Y | | | |
10 | dmGetProperty | Form | Returns the value of a specified table property. | Method | | | | dmSetProperty | Advanced | N | | | |
11 | dmLinkToFields | Form | Links two tables in a form's data model based on lists of field names. | Method | | | | dmLinkToIndex, dmUnlink | Advanced | N | | | |
12 | dmLinkToIndex | Form | Links two tables in a form's data model based on a list of field names and an index name. | Method | | | | dmLinkToFields, dmUnlink | Advanced | N | | | |
13 | dmSetProperty | Form | Sets the value of a specified table property. | Method | | | | dmGetProperty | Advanced | N | | | |
14 | dmUnlink | Form | Unlinks two tables in a form's data model. | Method | | | | | Advanced | N | | | |
15 | executeSQL | SQL | Executes an SQL statement. | Method | | | | executeSQLFile, executeSQLString | Advanced | Y | | | |
16 | executeSQLFile | SQL | Executes an SQL statement contained in a file. | Method | | | | executeSQL, executeSQLString | Advanced | Y | | | |
17 | executeSQLString | SQL | Executes SQL statements contained in a string. | Method | | | | executeSQL, executeSQLFile | Advanced | Y | | | |
18 | writeSQL | SQL | Writes a SQL statement or a SQL string to a file. | Method | | | | executeSQL, executeSQLString, executeSQLFile | Advanced | Y | | | |
19 | enumAliasLoginInfo | Session | Writes data about a specified alias to a table. | Method | | | | | Advanced | N | | | |
20 | getAliasProperty | Session | Returns the value of a specified property for a specified alias. | Method | | | | setAliasProperty | Advanced | N | | | |
21 | setAliasPassword | Session | Sets the in-memory password for a specified alias. | Method | | | | getAliasProperty, setAliasProperty | Advanced | N | | | |
22 | setAliasProperty | Session | Sets the value of a specified property for a specified alias. | Method | | | | getAliasProperty, setAliasPassword | Advanced | N | | | |
23 | dlgExport | System | Invokes the Table Export dialog box. | Method | | | | dlgImportASCIIFix, dlgImportASCIVar, dlgImportSpreadsheet,, exportASCIIFix, exportASCIIVar, exportSpreadsheet | Advanced | N | | | |
24 | dlgImportASCIIFix | System | Invokes the Fixed Length ASCII Import dialog box. | Method | | | | dlgExport, dlgImportASCIIVar, dlgImportSpreadsheet, importASCIIFix | Advanced | N | | | |
25 | dlgImportASCIIVar | System | Invokes the Delimited ASCII Import dialog box. | Method | | | | dlgExport, dlgImportASCIIFix, dlgImportSpreadsheet, importASCIIVar | Advanced | N | | | |
26 | dlgImportSpreadsheet | System | Invokes the Spreadsheet Import dialog box. | Method | | | | dlgExport, dlgImportASCIIFix, dlgImportASCIIVar, importSpreadsheet | Advanced | N | | | |
27 | errorHasErrorCode | System | Checks the error stack for a specific error code. | Method | | | | errorCode,errorHasNativeErrorCode | Advanced | N | | | |
28 | errorHasNativeErrorCode | System | Checks the error stack for a specific SQL error code. | Method | | | | errorNativeCode,errorHasErrorCode | Advanced | Y | | | |
29 | errorNativeCode | System | Returns the SQL server's error code. | Method | | | | errorCode, errorHasErrorCode, errorHasNativeErrorCode, errorMessage | Advanced | Y | | | |
30 | executeString | System | Converts the string into a method and executes it. | Method | | | | formReturn, executeMethod | Advanced | N | | | |
31 | exportASCIIFix | System | Exports data from a table to a text file with fixed-length fields. | Method | | | | dlgExport, exportASCIIVar, exportSpreadsheet | Advanced | N | | | |
32 | exportASCIIVar | System | Exports a table to a delimited (variable field length) text file. | Method | | | | dlgExport, exportASCIIFixed, exportSpreadsheet | Advanced | N | | | |
33 | exportSpreadsheet | System | Exports the data from a table to a spreadsheet file. | Method | | | | dlgExport, exportASCIIFixed, exportASCIIVar | Advanced | N | | | |
34 | importASCIIFix | System | Imports data to a table from an ASCII (text) file in which fields of each record are the same length. | Method | | | | dlgImport, importASCIIVar, importSpreadsheet | Advanced | N | | | |
35 | importASCIIVar | System | Imports data from a delimited (variable field length) text file to a table. | Method | | | | dlgImport, importASCIIFix, importSpreadsheet | Advanced | N | | | |
36 | importSpreadsheet | System | Imports the data from a spreadsheet file to a table. | Method | | | | dlgImport, importASCIIFix, importASCIIVar | Advanced | N | | | |
37 | sendKeys | System | Sends one or more keystrokes to the active window as if they had been entered at the keyboard. The active window need not be Paradox for Windows. | Method | | | | | Advanced | N | | | |
38 | sendKeysActionID | System | Lets the sendKeys() procedure notify the user that the sendKeys() queue is empty. | Method | | | | sendKeys() | Advanced | N | | | |
39 | forceRefresh | TCursor | Makes TCursor point to the current data in the underlying table. | Method | | | | currRecord, UIObject::forceRefresh | Advanced | N | | | |
40 | isOnSQLServer | TCursor | Reports whether a TCursor is associated with a table on an SQL server. | Method | | | | isOpenOnUniqueIndex | Advanced | Y | | | |
41 | isOpenOnUniqueIndex | TCursor | Reports whether a TCursor is open on a unique index. | Method | | | | | Advanced | N | | | |
42 | setBatchOff | TCursor | Ends the batch processing mode invoked by a call to setBatchOn. | Method | | | | setBatchOn | Advanced | N | | | |
43 | setBatchOn | TCursor | Groups multiple operations to improve performance of table updates in, a multiuser environment. | Method | | | | setBatchOff | Advanced | N | | | |
44 | update | TCursor | Assigns values to fields in the current record of a TCursor. | Method | | | | setFieldValue | Advanced | N | | | |
45 | forceRefresh | UIObject | Makes an object display the current data in the underlying table, and makes a calculated field recalculate. | Method | | | | currRecord, TCursor::forceRefresh | Advanced | N | | | |
46 | AutoAppend | Logical | Specifies whether a blank record is automatically inserted at the end of a table. | Property | | | | | Beginner | N | Form, Table frame, MRO, Record, Field | Y | Y |
47 | Columnar | Logical | Specifies whether a record will be expanded or not when printing or previewing. | Property | | | | | Advanced | N | MROs in reports | Y | Y |
48 | Design.Selectable | Logical | Specifies whether an object can be selected. | Property | | | | | Advanced | N | All UIObjects | Y | Y |
49 | DesignModified | Logical | True when a form's design is changed by an interactive user or ObjectPAL statements. | Property | | | | | Advanced | N | Form | Y | Y |
50 | Editing | Logical | Specifies whether the table associated with an object is in Edit mode. | Property | | | | | Advanced | N | Form, table frame, MRO, record and field objects | Y | N |
51 | Select | Logical | True if an object is selected (only in form design). | Property | | | | | Advanced | N | All UIObjects | Y | Y
|