CODEWITHSUNDEEP
c#sqlvisual-studiosql-server-ce
Wesley Lalieu
Wesley Lalieu

Reputation: 487

Query error SQL Compact Edition 3.5

In my solution I have a local database and a database connect class with a GetQuery function. This function works good but for some reason, it won't handle the query as shown below. When I run a query like SELECT * FROM logs everything works out, but when I try to use this query instead 

SELECT klantnr AS 'Klantnummer', 
       klantnaam AS 'Klantnaam', 
       vraag AS 'Vraag/probleem',
       informatie AS 'Informatie/uitvoering', 
       antwoord AS 'Antwoord/oplossing', 
       datum AS 'Datum', 
       tijd AS 'Tijd' 
FROM logs

I get the following error message: There was an error parsing the query. [ Token line number = 1,Token line offset = 21,Token in error = Klantnummer ]

Upvotes: 0

Views: 324

Answers (1)

Arion
Arion

Reputation: 31249

Please try this:

SELECT klantnr AS [Klantnummer], 
       klantnaam AS [Klantnaam], 
       vraag AS [Vraag/probleem],
       informatie AS [Informatie/uitvoering], 
       antwoord AS [Antwoord/oplossing], 
       datum AS [Datum], 
       tijd AS [Tijd] 
FROM logs

Upvotes: 5

Related Questions