Did you try it from the Command prompt?:
CREATE [SQL] VIEW [ViewName] [REMOTE] CONNECTION ConnectionName [SHARE]
| CONNECTION DataSourceName] AS SQLSELECTStatement]
p.s. when checking this I came across the CREATE VIEW command (.vue
files) - I do not remember ever using this, or even knowing it existed -
anyone use it?
On 26-Jan-2018 2:31 AM, Chris Davis wrote:
Hi All
Just wondered if anyone out there is using MariaDB as a back end but using
remote views in a DBC with it?
I have a server working, a database and table created ... I can do "select * from
mytable" using sqlexec but I can't create a remote view with the same table on.
Any help you could give would be appreciated.
Thanks
Chris.
______________________________________________________________________
This email has been scanned by the Symantec Email Security.cloud service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
