Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Why libre office base fails to recognise DECLARE statement?

I am using the SQL View to create my query and for some reason I do not get syntax highlighting. My Query is: DECLARE @var SET @var = 10 SELECT @var I get a syntax error. This is,AFAIK,legal SQL code so there should be no problems. Can you tell me what I am doing wrong?

click to hide/show revision 2
clean up formatting

Why libre office base fails does Base fail to recognise DECLARE statement?

I am using the SQL View to create my query and for some reason I do not get syntax highlighting. highlighting.

My Query is: is:

DECLARE @var
SET @var = 10
SELECT @var

I get a syntax error. error.

This is,AFAIK,legal is, AFAIK, legal SQL code so there should be no problems. Can you tell me what I am doing wrong?