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
> > > 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
>