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