Thanks much. I'll give it a try!

--- shakti_k_goel <shakti_k_goel@...> wrote:

> Hi Dan,
>
> In version 1.5.3 that has just been released, users
> will be able to
> run the query with a semi-colon at the end. Also,
> "." character is
> recognized as word terminating character. Users now
> have the option
> to run the DML in the background thread or in the
> main SQLEditor
> window.
>
> Shakti
>
>
>
> --- In guggiusers@yahoogroups.com, Dan Corso
> <dccorso@y...> wrote:
> >
> > 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@a...>"
> > <shakti_k_goel@y...> 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@y...> 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
>
=== message truncated ===





__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com