I'm trying to use the Macro facility to write a Basic program to issue a
dbase query and generate some statistics from the results. The database
has been built and the internal query works fine but the copy of the
query in SQL that I'm trying to use in Basic gets a "Syntax Error
Parentheses do not Match" error message. (By internal query I mean one
created within Base using the Query Wizard method). The statement in
Basic looks like this:
ResultSet = Statement.executeQuery("SELECT " "ABA_NAMES"."COMMON_NAME",
"CBC_DATA_RECS"."COUNT_YR", "CBC_DATA_RECS"."SPECIES_COUNT" FROM
"CBC_DATA_RECS" AS "CBC_DATA_RECS", "ABA_NAMES" AS "ABA_NAMES" WHERE
"CBC_DATA_RECS"."SPEC_NO" = "ABA_NAMES"."CBC_S_NUM" ORDER BY
"CBC_DATA_RECS"."SPEC_NO" ASC, "CBC_DATA_RECS"."COUNT_YR" ASC)
[In the program the statement is all on one line with no breaks or
continuations.]
I see two parentheses, correctly paired so something else must be wrong.
Any help here would be appreciated.
As an alternative, is there a way to issue the internal query that works
from within the Basic macro? Its name in the query group listing is
"AllSpeciesAllYears". If so where is that format for issuing a query
documented?
Dick Hoffman
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
