IMPORTANT NOTICE: As of 21 February, anything posted in this community WILL NOT BE MIGRATED to our new community site. We have pulled all user information and data from this site and are now in an approximately week long process of importing users, roles, and data to our new site. We are leaving this site open and active so you can post and hopefully get a response until the migration is complete. Once complete, the URL that currently takes you to this site will take you to our new site so your bookmarks will work as always. Please read the information on a New Login Process
The requirement is to find ANY or ALL programs that start with a definable character string. How can this be done in HyperView - Clipper?
The search is will be a basic search on ENTITY - PROGRAM, with the Attribute "Name" being "LIKE" a specific character string. The attached example, does this search on any programs starting with the characters AR7, defined in the query as "AR7*"In a list of programs containing the names AR7100, AR7200, AR7300 and AR0700, only the program AR0700 will NOT be returned. This can be amended as required.
The Attached XML file can be imported directly into clipper for use.