ADHOCVIEW()

ADHOCVIEW() is available as an optional add-in for Alpha Five.

Syntax

ADHOCVIEW( Table_Set_Name as C [, Read_Only as L [, Show_Table_Set_Selector as L ]] )

Argument	Description
Table_Set_Name	A non-null character string. Table_Set_Name must be fully qualified if it is not the primary table for the associated form. The ".dbf" file extension is automatically appended for tables. The ".set" extension is required for sets.
Read_Only	Optional. Default = .F. Determines whether to open a read-only ad hoc view. .T. = Open read-only. .F. = Do not open read-only.
Show_Table_Set_Selector	Optional. Default = .T. If Read_Only is .F. (FALSE), determines whether the user can select a different table. .T. = Allow user to select other tables. .F. = Do not allow user to select other tables.

Description

ADHOCVIEW() creates a temporary browse for the table or set defined by Table_Set_Name. If Table_Set_Name is NULL, the expression displays records from the first table that is found. If Read_Only is True, then Alpha Five opens a read-only ad hoc view. If Show_Table_Set_Selector is False, then Alpha Five does not allow the user to change the table or set for which the Ad Hoc View dialog was originally opened.

If Read_Only is false and Show_Table_Set_Selector is true, then the user can optionally select a different table and use all of the features of the function to create an ad hoc browse or form.

Supported By

Alpha Five Version 6 and Above

Limitations

Desktop applications only.

Examples

adhocview("customer") -> opens the customer table in user editable mode

adhocview("customer", .T., .F.) -> opens the browse fixed to the customer table and read-only

adhocview("invoice.set") -> opens the invoice set in user editable mode

adhocview("invoice.set", .T.) -> opens the invoice set in read-only mode