Use * command Pervasive 9 1

[rewob65]

I have only used mssql, and would use a query like this:-

select data1, data2,*
from table1

which would show all data1 and data2 then all the rest of the table1

What should i use instead of the *? Also is there any source of different syntax than mssql, since as you see this is a basic question.

Thanks

 

[mirtheil]

You'd need to specify the fields individually.
The SQL syntax supported by PSQL is documented at

http://www.pervasive.com/library/docs/psql/950/sqlref/index.html

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com