Author Topic: [SOLVED] Can't create view (query)  (Read 11999 times)


  • Hero Member
  • *****
  • Posts: 831
  • ..... A day not Laughed is a day wasted !!
    • Nursing With Humour
Re: Can't create view (query)
« Reply #30 on: March 24, 2015, 10:22:46 pm »
Well it worked.
Now i finally can move on to the next problem ;)

And what that is i will let you all know when i have arrived there :)

Thanx for all the help
You treat a disease, you win, you lose.
You treat a person and I guarantee you, you win, no matter the outcome.

Lazarus 2.0.6 / FPC 3.0.4
Lazarus Trunc / FPC Trunc
Mac OS X Mojave


  • Hero Member
  • *****
  • Posts: 4465
Re: Can't create view (query)
« Reply #31 on: March 24, 2015, 10:24:23 pm »
It's a 1-on-1 from MS Access.
Aah, Ok. You probably used the Access' query designer to create those statements. It seems Access does require parentheses in it's statement at odd points. Unlike "normal" SQL. I've never used a query designer and always create queries "by hand" but it seems that Access' query designer makes it's queries quite difficult to read and somewhat incompatible with other SQL-engines (like SQLite and Firebird/Interbase). I even wonder if MSSQL could run that original query unchanged.

Good luck finding your next problem :)


TinyPortal © 2005-2018