1 Topic by Paul (edited by Paul 2019-01-31 16:23:33)

  • Paul
  • New member
  • Offline
  • Registered: 2018-12-12
  • Posts: 2

Topic: limitation with SQL JOINS in MVD?

Hello Dmitriy,
I am pretty new to all this, so please excuse me if this is a "non-issue question".

I was trying to tie a push button action to a SQL search. In the process,
while  trying to join 2 tables in a search, I got this error message from MVD:
"ERROR: RIGHT and FULL OUTER JOINs are not currently supported ".
(the SQL statement was actually calling for a LEFT OUTER JOIN).
Is that a limitation in the program, and if so, do you have any plans to add that functionality in an upgrade?
If it is a current limitation, is there a way around it?

  • Registered: 2014-06-25
  • Posts: 861

Re: limitation with SQL JOINS in MVD?

Sqlite does not support Right and Full outer joins, you have to use workarounds see: https://www.sqlitetutorial.net/sqlite-full-outer-join/, using a MySQL database connection might support Right and Full outer joins.

  • From: Нефтеюганск
  • Registered: 2018-04-11
  • Posts: 1,775

Re: limitation with SQL JOINS in MVD?

http://myvisualdatabase.com/forum/viewtopic.php?id=4727

  • Paul
  • New member
  • Offline
  • Registered: 2018-12-12
  • Posts: 2

Re: limitation with SQL JOINS in MVD?

Thank you. The above 2 suggestions were helpful.