Re: Temp tables and LIKE

Yes, I have wanted the same thing. I have gotten around it somewhat by creating the temp tables with a select statement that selects the required values. I then put an impossible where clause on the select so the temp table has not data in it. Regards, Jason On 7 Nov 1997 16:19:24 +1100, batonnet@zeta.org.au (Bryan Tonnet) wrote: >What's the reasoning behind temp tables not allowing the 'LIKE table.column' >syntax in 4GL's version of 'CREATE TABLE'? > >There's a good maintenance benefit in having the facility, as changes to data >types don't need to be tracked through the code (well, not as much anyway). >Seeing as how 4GL is now Category 2 maintenance, I won't bother with an >enhancement request, but I'd be interested in knowing why it wasn't implemented >that way in the past. Different development teams for SQL and 4GL? > > >-- >Bryan Tonnet >batonnet@phase4.com.au > Jason Harris Informix DBA Westpac Banking Corporation NOTE: I add all these address at the bottom of people who spam me Now when their extractors extract my e-mail address they will also end up spamming each other. wtcjr@ix.netcom.com Shevsky@hotmail.com speech@speechrecognition.com SmartBiz@NevWest.com slender@juice4u.net sbliss@earthfriends.com ron@moneyaction.com removeme@gwh.net rocco@lostvegas.com market@DRAWBRIDGE.NET Foxyrusski@mail-response.com emaster@email-man.com waynesmail@earthlink.net root@localhost postmaster@localhost