Ben, I HAVE done this and it DOES work - it's called a cartesian product. David Blocker
----- Original Message ----- From: "Ben Petersen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 20, 2002 2:17 AM Subject: RE: Labels > I've never tried this, but I think you could do it with a view. > > Create a temporary table with 30 (or however many) rows. I'm not > sure that you would even need data in it. Then create a view > against it and your current table. > > Create temp Table DummyTempTable DummyText Text 4 > > Insert into DummyTempTable (DummyText) + > sel 'X' from sys_Tables whe limit = 30 > > Create Temp view ViewName (Your column list) as + > Sel -columns from your mailList table here- + > From YourMailListTable t1, DummyTempTable t2 > > Base your labels on the view. > > You see there is no where clause to correlate the two tables. This > is normally a bad thing, as the rows in T1 will be duplicated by the > number of rows in T2. > > I've never done this (on purpose <g>) so you might need to work > with it a bit. > > Ben Petersen > > > On 20 Nov 2002, at 1:45, Steve Johnson wrote: > > > To All: > > > > Nancy asks a great question. There are times I would like to print 30, > > 60, or an entire sheet of identical labels. Sounds deceptively > > simple. > > > > No problem projecting a dummy table but how do you populate it with 30 > > rows? Code to Add & Duplicate 30 times? Haven't looked at the > > documentation on this one yet, the thread caught my interest. > > > > Steve > > > > > > ================================================ > > TO SEE MESSAGE POSTING GUIDELINES: > > Send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: INTRO rbase-l > > ================================================ > > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In > > the message body, put just two words: UNSUBSCRIBE rbase-l > > ================================================ TO SEARCH ARCHIVES: > > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > > > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
