Record Functions
Description
Alpha Anywhere provides the following Record functions.
- Name
- Description
- a5_finddupsgenie Function
Displays the Find Duplicate Records genie
- a5_get_recs_in_qry_local Function
Returns the number of records in a query for a table or a set.
- a5_paste_current_record Function
Pastes data from the A5 Record Clipboard into current record
- a5_paste_from_clipboard Function
Pastes an entry in the A5 Record clipboard into the record referenced by tbl_pointer.
- a5_paste_new_record Function
Pastes data from the A5 Record Clipboard as a new record
- a5_put_rec_on_clipboard Function
Puts the current record (in the record referenced by tbl_pointer) on the A5 Record clipboard.
- a5_rec_clip_has_data Function
Returns .t. if the Alpha Anywhere record clipboard has any data on it.
- a5_records_undelete Function
Call the Undelete Records dialog
- a5_remove_recs_genie Function
Displays the Remove Records genie
- a5_selected_records Function
Takes a comma delimited list of records, and record ranges, and returns a list of record numbers. e.g. 1,5-7,11 becomes 1,2,5,6,7,11
- BOTTOM_PERCENT_RECORDS Function
Return the bottom N percent of records for a given sort order.
- BOTTOM_RECORDS Function
Return the bottom 'count' records for a given sort order.
- CURRENT_RECORD Function
Returns the current record number
- CURRENT_RECORD_NUMBER Function
Returns the current record number.
- DBAVG Function
Returns the average value for a field in records of a specified table.
- DBCOUNT Function
Returns the number of matching records in a specified table.
- DBMAX Function
Returns the maximum value of matching records in a specified table.
- DBMIN Function
Returns the minimum value of matching records in a specified table.
- DBSUM Function
Returns the sum of fields of matching records in a specified table.
- DELETED Function
Returns TRUE if the current record has been marked for deletion.
- EVERY_RECORD_LIST Function
Returns a list of record numbers for an open layout.
- FILTER_STRING Function
Filter in/out words that contain case insensitive sub_string from a list, default delimiter is CR-LF.
- form_qs_explicit Function
Sorts the record in a window based on values in a field object
- IS_RECNO_IN Function
Returns TRUE if record number is in list of record numbers provided.
- LOOKUP Function
Returns the value of an expression in an external table for first match of filter.
- LOOKUPC Function
Returns the value of a character expression in an external table.
- LOOKUPD Function
Returns the value of a date expression in an external table.
- LOOKUPL Function
Returns the value of a logical expression in an external table.
- LOOKUPN Function
Returns the value of a numeric expression in an external table.
- MARKED Function
Returns TRUE if the current record has been marked.
- page_records_get Function
Return a cr-lf delimited list of the records displayed on a page.
- POP_STDDEV Function
Get the population standard deviation of subexpression over group 'over' sampled each group 'each'
- POP_VARIANCE Function
Get the population variance of subexpression over group 'over' sampled each group 'each'
- RANDOM_PCT_RECORD_LIST Function
Fetches a list of record numbers for the current open DBF table.
- RANDOM_PERCENT_RECORDS Function
Return percent of the records, selected at random.
- RANDOM_RECORD_LIST Function
Selects a random list of records from the current DBF table.
- RANDOM_RECORDS Function
Return 'count' random records.
- RECORD_ADD Function
Adds a new record to a table. Data is CRLF delimited list. Style 1 - data is fieldname=fieldvalue pairs, Style 2 data is just fieldvalues in same order as fieldnames
- RECORD_DELETE Function
Deletes one or more record(s) in a table that match the filter condition
- RECORD_UPDATE Function
Updates a record in a table. Data is CRLF delimited list. Style 1 - data is fieldname=fieldvalue pairs, Style 2 data is just fieldvalues in same order as fieldnames
- RUN_AVERAGE Function
Get the running average of subexpression over group 'over' sampled each group 'each'
- RUN_MAXIMUM Function
Get the running maximum of subexpression over group 'over' sampled each group 'each'
- RUN_MINIMUM Function
Get the running minimum of subexpression over group 'over' sampled each group 'each'
- RUN_STDDEV Function
Get the running standard deviation of subexpression over group 'over' sampled each group 'each'
- RUN_VARIANCE Function
Get the running variance of subexpression over group 'over' sampled each group 'each'
- SAMPLE_RECORDS Function
Select every Nth record in the table in the current sort order.
- STDDEV Function
Get the standard deviation of subexpression over group 'over' sampled each group 'each'
- TOP_PERCENT_RECORDS Function
Return the top N percent of records for a given sort order.
- TOP_RECORDS Function
Return the top 'count' records for a given sort order.
- TOP_RECORDS_LIST Function
Gets the record numbers for the first "X" records in a DBF table matching the filter and order expression.
- TOP_RECORDS_PCT_LIST Function
Returns the specified top percent of records from a DBF table matching the specified filter and order expression.
- VARIANCE Function
Get the variance of subexpression over group 'over' sampled each group 'each'
Methods
- CHANGE_RECORD Method
Allows for data to be changed via Xbasic, when using a Form or Browse. Returns a dot variable that is the validation object.
- DELETE_RECORD Method
Allows for data to be deleted via Xbasic, when using a Form or Browse. Returns a dot variable that is the validation object.
- ENTER RECORD Method
Allows for data to be entered when using Xbasic with a Form or Browse. Returns a dot variable that is the validation object.