Re: Function Using Select Case for Query

Okay, I'm completely baffled. You're trying to use this function to
name a column in your query, but you never manipulate a query's SQL
property?

And your function, although it is declared to return a string value,
never actually returns ANY value. Where is the "SetInvBrkdwn=????" in
your code that passes the calculated value back to your function name
so it can be passed out of the routine?
.

Relevant Pages

  • RE: SQL Query Question
    ... Subject: SQL Query Question ... 'OKAY' ...
    (perl.dbi.users)
  • Re: SQL*PLUS select statment
    ... The query runs fine but I need to manipulate the data into a ... single column; Here is an example: ... I know this has to be possible, but I lack the SQL skill to get to ...
    (comp.databases.oracle.misc)
  • nested identifier
    ... I'm trying this query: ... SQL> @overlapping.sql ... I thought nesting it was ...
    (comp.databases.oracle.server)
  • The "You tried to execute... aggregate function... blah" error...
    ... I have a fairly big query I am opening using ADO in visual basic. ... The query works okay, until I add an expression field as one ... I tried putting the expression "as" bit (in the SQL I have my expression AS ...
    (microsoft.public.access.queries)
  • Re: nested identifier
    ... SQL> @overlapping.sql ... You're not 'nesting', that query is in an EXISTS condition. ...
    (comp.databases.oracle.server)