ext_qry_join

Needs description!!!!

Syntax

void ext_qry_join()

Description

ext_qry_join() modifies G.query_buf by pre-pending the table alias to the field name entered by the user when creating an extended query.

For example, 'AN = 100' may become A.AN = 100 and 'SMILES = CC' may become 'B.SMILES = CC'. This translation is required when creating extended queries in windows with select statements containing joins because the table name or id of each field must be specified.

Since this function must find space field_name space within G.query_buf, it is important for users to learn the correct syntax.

While ' AN = 100' will be converted to ' A.AN = 100', 

neither 'AN = 100' nor ' AN= 100' will be converted.

Example

Action Buttons are often used to open a text editor for the user to type extended queries. Since the user is unlikely to know the names or aliases for the database tables used in SQL joins, it is important to add them automatically.

 {

 edit_text(G.query_buf,400,6,36,5,80,true);   /* Edit G.query_buf   */
 ext_qry_join();                /* pre-pend table alias to field names */
 }