Opens a table and creates a handle to it.
Function OpenTable(ByRef hTableRef As Long, ByVal TableNo As Long) As Boolean
A new handle to the table.
Number of the table to be opened.
tmpVar = CF1.OpenTable(hTable, 15)
If VarType(tmpVar) = vbBoolean Then
logWr "OpenTable OK"
logWr "OpenTable failed. It didn't return a boolean"
OpenTable opens the table identified by TableNo and assigns a handle to it for future calls. The handle remains valid until CloseTable is invoked. You can create several handles to the same table and, using other library functions, set filters and a current key individually for each handle.
Even if a user (verified by Login) does not have permission to access the table, OpenTable will open it anyway. But the application will receive an error when it tries to read or modify the table. Only the table description (field and key layout) can be accessed, not the table data.
If the table is successfully opened, the function returns TRUE. If the table does not exist, two things can happen:
The function returns FALSE, and, unless the error has been allowed, an error message will be displayed if HideError is FALSE.
If this result has been allowed by the AllowTableNotFound function, it will not be considered an error. The function, however, still returns FALSE; and you should test this return value in your code.
For more information about how errors are handled, see Error Handling.
For more information about tables, see the Application Designer's Guide.