Question Syntax error without operator in query expression.

[Anwind]

Hello.

Public DbReader DataReader(sQuery);
{
System.Data.OleDb.OleDbCommand.ExecuteReader("Default");
}[/CODE]

System.Data.Common.DataReader


Please Teach me.

 

[Skydiver]

Try the same syntax interactively with some SQL explorer to see if it works. To me, it looks like invalid SQL, but I try to avoid SQL like the plague.

 

[jmcilhinney]

Of course it's wrong. You need to separate every column in the SELECT clause with commas and you appear to know this already, given that you have one comma in there.

 

[jmcilhinney]

By the way, this question is nothing to do with OLE DB. It's a straight SQL syntax question. Thread moved to Database General forum.