ADHOCVIEW() is available as an optional add-in for Alpha Five.
ADHOCVIEW( Table_Set_Name as C [, Read_Only as L [, Show_Table_Set_Selector as L ]] )
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.
Optional. Default = .F. Determines whether to open a read-only ad hoc view.
Optional. Default = .T. If Read_Only is .F. (FALSE), determines whether the user can select a different table.
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.
Alpha Five Version 6 and Above
Desktop applications only.
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
Browse Functions and Methods, Form Functions and Methods