Alpha Software

*AT_Multi()

Searches for the position where any one of a CR-LF delimited list of search strings occurs in another string. Case-sensitive.

*ATC_Multi()

Same as *AT_Multi() but case-insensitive.

a5_ServerSide_FilterOrder_Get()

Returns information about the current server-side filter and order that has been applied to an active-link table.

a5_ADO_ResolveConnectionString()

Takes a namedADO connection string and resolves it, returning the actual connection string. The named connection string is of the form: ::Name::connectionstringname.

a5_NamedConnectionCreate()

Creates a named ADO or AlphaDAO connection string.

a5_Convert_ActiveLink_to_Named_Connections()

Converts connection strings in all active-link tables from explicit to named connections. If flag is .t., then converts named connection strings to explicit connection strings.

Filter_String_Smatch_Change()

Combines Filter_string_smatch() and stritran_multi() into a single, more efficient function call. Used to change lines of text that match a pattern.

<Layout>.ServerSideQueryRun() 

Applies a server-side filter and order to the primary table of a form or browse (if that table is an active-link table). Allows filters to be applied incrementally. I.e. each filter can be applied to search in the sub-set of previously found records. If this method is called repeatedly with the additive option set to .t., a stack of previously applied filters is maintained.

<Layout>.ServerSideQueryRetract()

Removes the most recently applied server-side filter.

<Layout>.ServerSideQuery_Show_All()

Removes all incremental server-side filters from the primary table of a form or browse (if that table is an active-link table).

Table.External_Suggest()

Returns a list of values from a field in a table that start with a specified string. See also <tbl>.Suggest()

<tbl>.To_sql_expression()

For an active link table, takes an expression that references field names in the active link table and converts it to an expression in SQL syntax that references the corresponding fields in the remote table. If the expression cannot be converted, returns a null string.

<tbl>.To_sql_filter()

For an active link table, takes a filter expression that references field names in the active link table and converts it to an expression in SQL syntax that references the corresponding fields in the remote table. If the expression cannot be converted, returns a null string. Also returns the portion of the filter expression that could not be converted to SQL syntax.

<tbl>.To_sql_order()

For an active link table, takes an order expression that references field names in the active link table and converts it to an order expression in SQL syntax that references the corresponding fields in the remote table. If the expression cannot be converted, returns a null string.

<tbl>.ServerSideQueryRun()

Filters the records in an active-link table. The query is performed on the server. Allows filters to be applied incrementally. I.e. each filter can be applied to search in the sub-set of previously found records. If this method is called repeatedly with the additive option set to .t., a stack of previously applied filters is maintained.

<tbl>.ServerSideQueryRetract()

Removes the most recently applied server-side filter.

<tbl>.ServerSideQueryRetractAll()

Removes all incremental server-side filters.

<tbl>.ServerSide_Records_Get()

Returns the number of records in an active-link table. Faster than <tbl>.Records_Get() because it does not cause the local record cache to become fully populated.

 

<tbl>.Suggest()

Returns a list of values from a field in a table that start with a specified string. See also Table.External_Suggest()

<Layout>.Refresh()

Refreshes all of the controls on a form or browse layout. Useful if you have changed the value in a field by getting a pointer to the table and then setting the field value using Xbasic. Similar to the .Resynch() method, but can be executed when the table is in change or enter mode.

Ping()

Ping a URL to see if it is responding.

SQL_Lookup()

Does a lookup into a table in a remote database using AlphaDAO. Returns a field value or expression from the remote table.

 SQL_Records_Get()

Returns a CRLF delimited string with data from a table or query in a remote database using AlphaDAO.

Merge_variable_frames()

Merges the variables from two different variable frames (i.e. two different dot variable) into a single variable frame.

*gzip_blob()

Compresses a blob variable using Gzip encoding.

*gunzip_blob()

Un-compresses a previously Gzip encoded blob variable.

*gzip_text()

Compresses a character variable.

*gunzip_text()

Un-compresses a previously Gzip encoded character variable.

<Form>.IsDirty()

Returns .t. if any field on the form has been changed.

<Browse>.IsDirty()

Returns .t. if any field on the browse has been changed.

*Locale()

Represents text in a specified locale (e.g. Polish), so that it can be sorted correctly in that locale.

*XML_DOCUMENT()

 Parses text into an xml document object (useful for immediate access to xml document/node functionality without having to instantiate the XMLSchemaManager.

SSL_test_cert()

Used to test a certificate and its matching key file to make sure they are valid for use in the Application Server.

*XML_PEEK_ATTRIBUTE()

 Extracts an attribute value from a snippet of XML text.