Thanks for your suggestion, Albert. It gave me an idea. I actually did use a sub report initially, but it has the same issue. However perhaps I can use separate sub reports for the two images, in order to eliminate the need for the UPDATE statement.
Thanks, Chaya -----Original Message----- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Albert Berry Sent: Wednesday, December 13, 2017 3:51 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - copying images Would it perhaps be easier to use a sub report for the images rather than updating the main table? Sub reports work quite will in R:Base Albert > On Dec 13, 2017, at 1:33 PM, Chaya Goldberg <cgoldb...@omnirehab.com> wrote: > > Hi Everyone, > > I’m writing a report which needs to have two or three images on it in a > certain order. I get these images by querying our database. The queried > images first get saved to separate temporary tables (one of which will become > the “main” table), then get collected into the main table using an UPDATE > statement. I then print the report off of this main table. > > The problem is that the results are inconsistent. Sometimes it works and the > images print as they’re supposed to, but other times the second image does > not appear. In reviewing the tables during their intermediate stages, I’ve > found that although both images initially appear when queried, the second > image does not copy during the UPDATE. > > Any suggestions or ideas as to why this would happen? > > > Chaya Goldberg > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to rbase-l+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.