Chip and Kirk comment:
>> forgotten the whole idea for these two commands is to allow you to >> PUSH the record you are currently using to allow you to do queries on >> the same table without having to save it first. >Yes I know that about Push and Pop >In this case I have a complicated set of inter relations (some as relational >lines >and some not) and in many cases trying to get related records loses the >current starting record, so pushing and piping insures that I end up on the >same starting record. Another useful tool to avoid disturbing the current selection is to use SQL queries within Begin SQL...End SQL. I use them frequently to collect data from various tables into arrays (or objects if you're in the 21st Century). Tom Benedict Optum This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
