Re: v13 - Why can a record NOT be Pushed?
Benedict, Tom: > 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). If you´re really in the 21st Century, you use ORDA. No need for SQL. (Of course that does not work in v13, but that is sooo last Century ;-) Greetings from Germany, Bernd Fröhlich ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: v13 - Why can a record NOT be Pushed?
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:4d_tech-unsubscr...@lists.4d.com **
Re: v13 - Why can a record NOT be Pushed?
Thanks Kirk, I found the problem I was having. PUSH RECORD can't push a record if there is no record to push... so as you suggested no selection. On Mon, 5 Nov 2018 13:51:18 -0800, Kirk Brooks via 4D_Tech wrote: > Stack is full? > The record is not selected? > > I was trying to use PUSH & POP the other day for something. It caused me to > re-read the docs about it and I found that over the years I'd 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. They aren't there to allow editing multiple > records in the same process because a process, at least in have 1 current record at a time. 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. This is in a situation where I have : * A storage unit, in side are 1 or more containers * - Container (Type -S) - this is allowed to have (many) of either or both of 2 other types of containers, or end products * -- Type B container - holds end products * -- Type R container - holds only other containers, of Type B There are 2 types of end products (End Product S and End Product I) The interface allows drag n drop on list boxes to populate the various containers. As well as printing the contents of the containers, at every level. I was having issues after printing, then switching to a different page/listbox. all of the above is probably TMI - but there it is :) Thanks again > On Mon, Nov 5, 2018 at 1:46 PM Chip Scheide via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > >> I am getting this error, and i can not figure out why. >> >> Thanks >> Chip >> --- >> Gas is for washing parts >> Alcohol is for drinkin' >> Nitromethane is for racing >> ** >> 4D Internet Users Group (4D iNUG) >> Archive: http://lists.4d.com/archives.html >> Options: https://lists.4d.com/mailman/options/4d_tech >> Unsub: mailto:4d_tech-unsubscr...@lists.4d.com >> ** > > > > -- > Kirk Brooks > San Francisco, CA > === > > *We go vote - they go home* > ** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ** --- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: v13 - Why can a record NOT be Pushed?
Stack is full? The record is not selected? I was trying to use PUSH & POP the other day for something. It caused me to re-read the docs about it and I found that over the years I'd 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. They aren't there to allow editing multiple records in the same process because a process, at least in wrote: > I am getting this error, and i can not figure out why. > > Thanks > Chip > --- > Gas is for washing parts > Alcohol is for drinkin' > Nitromethane is for racing > ** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ** -- Kirk Brooks San Francisco, CA === *We go vote - they go home* ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
v13 - Why can a record NOT be Pushed?
I am getting this error, and i can not figure out why. Thanks Chip --- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **