Hi Dan,

I am glad that the changes worked. The patch to make
the SQL execute with a semi-colon at the end also has
been developed. Version 1.5.3 of Guggi Oracle will be
released by the end of this week or early next week.

Please let me know what problems were encountered when
you tried to connect suing Oracle's OleDB.

The run as script functionality is there to execute
DDL and DML statements and not SELECT statements.
This is similar to the functionality in SQL*Plus where
you execute a file containing SQL statements (DML/DDL)
using the "@" symbol.

If any error is encountered then the SQL statement and
the error is captured and displayed to the user.
Semicolon is used to identify the end of the statement
in a script containing multiple statements.

In 1.5.3 you would be able to execute your SELECT
statements ending in a semi-colon.

Can you please provide an example of the last
statement in your email? I am not sure which UP and
DOWN arrows are being referred to (keyboard or in the
toolbar). If you make a change to a field in a given
record and want to commit the change, then click the
"tick mark" icon after making the change. In other
words, the change(s) are followed by a single click of
"tick mark" to commit(accept) the changes. Tab key
need not be used to commit changes.

Please let us know if there are any other enhancement
requests that you may have.

Regards,

Shakti

--- Dan Corso <dccorso@...> 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@...>"
> <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
=== message truncated ===