I'm trying to query a Pervasive table with two-word name.

Example: "select * from Table 1"........ but an error always occurs. I try
this: "select * from [Table 1]" but it also doesn't work.

I tried to query other tables but with only a single name and no error occurs. So this is a syntax error in Pervasive.

What is the correct syntax for this. Anybody there who can help me.............

You need to use double quote around tables with spaces in the name. So in your example, it should be:
Select * from "Table 1"

I also ried that but the same error occurs. I'm actually doing the query in Visual Basic. When you try to queyr there, the syntax must be:

"select * from Table 1"............. you need to put open/close double qoute. so if i will try your suggestion it will be:

"select * from "Table 1""........... and 'Syntax Error' occurs..........

Have you already encountered this? THANK YOU VERY for your reply. I appreciate it so much. But I think it's not the right solution to my problem. Thank you again.

The only double quotes need to be around the table name. What version of Pervasive are you using? What tool are you using to issue the statemtn?

You must be new to VB. To include quotes in a string you must use "".

So, try something like this:

sSql = "select * from ""Table 1"""

ALSO, First verify your queries work in the Sql Data Manager. It's like Query Analyser if you have used Sql Server.

Another way to specify double quotes in VB would be:
SQL = "Select * from " & chr$(34) & "Table 1" & chr$(34)

Yes, but that's sooo much typing! I prefer "" because it is the same in sql (two single quotes) and makes it second nature in both languages..

Of course, all those quotes can get confusing!

Sometime I'd do something like :

q = chr$(34)

sSql = "select * from " & q & "table 1" & q

OKEY!!!!!! Thank you very much!!!! It already works..... Thank you.

LOL, ..glad we could be of help!

-Eric