Archives of the TeradataForum

Message Posted: Wed, 18 Sep 2002 @ 07:21:30 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: An SQL PrettyPrinter???

From:		Dieter N�th

Frank C. Martinez IV wrote:

You can do multi-statement requests from THIS TYPE OF TOOL (see, I'm not talking about a particular product) (oh yeah, try that in Queryman).

Press F9? But Queryman's syntax highlighting/formatting is terrible...

[snipped nice macro]

Oh yeah, as you can see, I'm having some trouble with this little macro, getting SQL to let me use the Title column in DBC.Columns. Seems it conflicts with the reserved word. Anybody figured a way around that?

The errormessage is
3810: Column/Parameter 'T1.Title' does not exist.

Hmmm, i've never seen that before ;-)

So let's see, what's in the Messages manual about that error:

"Explanation: The column/parameter %VSTR could not be found in any of tables or views referenced in this statement.

Remedy: Check the spelling of the column or parameter name, or see if the table or procedure in which the column exists is correctly referenced."

Hint: the column is named ColumnTitle ;-)

Dieter


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Archives

2016		2007
2015		2006
2014		2005
2013		2004
2012		2003
2011		2002
2010		2001
2009		2000
2008		1999

2002 Indexes

Jan		Jul
Feb		Aug
Mar		Sep
Apr		Oct
May		Nov
Jun		Dec

Last Modified: 15 Jun 2023