Thanks for your quick response on this Shakti. I
hadn't had time to test the changes until today, but
your recommendations and patch seem to have worked.
For some reason, I didn't think of using the Microsoft
oleDB driver for loading the TNS profile- I couldn't
get the Oracle one to work, so I just set up the ODBC
connections.

When I run the query now, I can only run it as a
statement though, I can't run it as a script. I still
get the expected output(which works for me- just a
change in my approach), but the "run as script"
function just does nothing-unless I add the semicolon-
then it errors :-)

Also, many people in my group use the schema browser
to make changes to several rows at a time for a single
field. Is there an enhancement in the works to allow
a change to a row and just use the up/down arrow to
modify the next field rather than hit either enter and
arrow or tab and arrow?

--- "Shakti <skgoel@...>"
<shakti_k_goel@...> wrote:

> Hello Dan,
>
> Thank you for your interest in Guggi Oracle.
>
> We would recommend using Oracle OleDb by Oracle
> option
> to execute queries. OleDb driver supports most of
> the
> functionality of Oracle whereas ODBC driver can be
> sometimes limiting.
>
> If you have Oracle client installed then Oledb is
> automatically installed with it, and you would not
> need to take any additional steps.
>
> The issue that you have encountered below is as
> follows:
>
> The tool does not recognize "." as an end-of-word
> character. Therefore, it treats the entire string
>
> &START_DD.&START_MM.2005:00:00:00'
>
> as one parameter.
>
> In order for the script to work, please make the
> following changes
>
> '&START_DD . &START_MM . 2005:00:00:00'
>
> In other words, insert a space before and after the
> period (".")character. The tool will then recognize
> start_dd as a single parameter and same for other
> three parameters.
>
> We have tested this using OleDb driver.
>
> SELECT *
> FROM emp
> WHERE hiredate BETWEEN TO_DATE ('&START_DD .
> &START_MM .1981:00:00:00',
>
> 'DD.MM.YYYY:HH24:MI:SS'
> )
> AND TO_DATE
> ('&END_DD . &END_MM .1981:23:59:59',
> 'DD
> .MM.YYYY:HH24:MI:SS'
> )
>
>
> We will add an option in the tool to recognize "."
> as
> a character. This option will be placed in the
> Application Options form. You can then turn on-this
> option.
>
> Also, the OleDb and ODBC drivers do not recognize
> ";"
> as a valid character at the end of SQL statement.
> We
> are making enhancements to the product to address
> this
> issue as well.
>
> Hope the response addresses the immediate issue.
> Please let us know if you have any more questions.
>
> Regards,
>
> Shakti
> Sales - Impact Solutions
> http://www.impact-sol.com
> Developers of Guggi Oracle - Tool for DBAs and
> Developers
>
>
> --- Dan <dccorso@...> wrote:
>
> > Hi,
> >
> > I'm evaluating this product to replace TOAD in our
> > workplace. We
> > are budget cutting :-)
> >
> > We'll need 10 licenses, but while I'm testing
> > scripts that run in
> > TOAD, I get some funky errors in this. I was
> > wondering if some
> > light could be shed on them, and what I need to do
> > to get the
> > scripts to execute properly?
> >
> > Here's what I'm sending:
> > SELECT val1, val2, COUNT(1)
> > FROM table1
> > WHERE ( val3 in ('x1','x2','x3')
> > )
> > AND val4 BETWEEN TO_DATE
> > ('&START_DD.&START_MM.2005:00:00:00',
> >
> > 'DD.MM.YYYY:HH24:MI:SS'
> > )
> > AND TO_DATE
> > ('&END_DD.&END_MM.2005:23:59:59',
> >
> > 'DD.MM.YYYY:HH24:MI:SS'
> > )
> >
> > group by val1, val2;
> >
> > Here's the error that's coming out when I run it
> as
> > a script:
> >
> > [Oracle][ODBC][Ora]ORA-06550: line 1, column 7:
> > PLS-00103: Encountered the symbol "" when
> expecting
> > one of the
> > following:
> > begin declare exit for goto if loop mod null
> > pragma raise
> > return select update while <an identifier>
> > <a double-quoted delimited-identifier> <a bind
> > variable> <<
> > close current delete fetch lock insert open
> > rollback
> > savepoint set sql execute commit forall
> > <a single-quoted SQL string>
> > The symbol "" was ignored.
> > ORA-06550: line 12, column 50:
> > PLS-00103: Encountered the sy
> >
> > Now, I know if I were to replace the
> > &START_DD.&START_MM and
> > &END_DD.&END_MM with solid values, it will run
> fine,
> > but I run these
> > regularly and prefer the prompts. Guggi also
> seems
> > to not know that
> > I only want to populate those values, as it
> expects
> > me to include
> > the entire TO_DATE if I just try and execute the
> > statement.
> >
> > Any help would be appreciated. It's a very
> > reasonably priced tool
> > and seems comparable in function to TOAD
> >
> >
> >
> >
> >
>
>




__________________________________
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com