Re: 4GL question

Posted in 2004

Obnoxio The Clown — Fri, 30 Jan 2004 16:09:38 +0000 — source: Usenet: comp.databases.informix

Howard Salter wrote: > > This message is in MIME format. Since your mail reader does not understand > this format, some or all of this message may not be legible. > > ------_=_NextPart_001_01C3E5AE.12223DD0 > Content-Type: text/plain > > ------_=_NextPart_001_01C3E5AE.12223DD0 > Content-Type: text/html > > <html> > > <head> > <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"> > > > <meta name=Generator content="Microsoft Word 10 (filtered)"> > > <style> >  > </style> > > </head> > > <body lang=EN-US link=blue vlink=purple> > > <div class=Section1> > > font-family:Arial'>Hello all, > > font-family:Arial'>  > > font-family:Arial'>I'm writing a 4GL report, and I need it to span > several databases that all have matching tables and structures, it's just > the info in the tables that's different. I know I could add the database > name to the FROM statement in each of my selects, but I was hoping there > was a way to do create a DATABASE statement using a variable name. That > way I wouldn't have to change the SQL statements and add the CLOSE and > FREE statements for each cursor and prep statement. > > font-family:Arial'>  > > font-family:Arial'>TIA, > > font-family:Arial'>  > > font-family:Arial'>Howard > > </div> > > </body> > > </html> > > ------_=_NextPart_001_01C3E5AE.12223DD0-- > sending to informix-list Don't post HTML, or I'll set Jonathan on you. -- "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche