Hi, i'm new in sql.
How can i run two statement in one query?
Example ;
create table tmpTable (AField char(8))
insert into tmpTable values ('12345678')

Pervasive Control Center returns syntax error in this example
My ODBC driver version is 3.5

Hi,

As far as I know, those are two separate queries.

To separate them in the Pervasive Control Center, simply insert a "#"
(without the quotes) at the end of each statement. The PCC recognizes
the "#" or the semicolon (which is the standard termination character)
but defaults to the "#". You can change it to the semicolon if you
wish, under Preferences.

If you want to execute all the statements, I don't know if you can do
this in the v2000i PCC or not, but in v8 and v9 there is the capability
to "Execute all Queries" in the query window.

Hope this helps.

Wayne
www.analyticabiz.com
Analytica Business Systems, Inc.
A Premier Pervasive Partner

To subscribe to our Pervasive news feed:
www.analyticabiz.com/rss20.php

- Nascondi testo tra virgolette -

sectatrix (AT) gmail (DOT) com ha scritto:

Thanks Wayne for your help.
I know # seperator character too. But it doesnt works in ODBC
functions.
Maybe i must try in other versions.

Wayne yazdi:

I didn't get any syntax errors when I entered your two queries into the
v9 PCC. What syntax errors are you getting?

sectatrix (AT) gmail (DOT) com ha scritto: