I thought this forum might be the best place for this thread.
Spending a few hours reading as many posts on Virtual Tables as possible there has been no definitive answer on “should they be used exclusively or not?”

From my readings VT’s offer portability and encapsulation and some posters feel the “anywhere and any database” is best.
HOWEVER:
If the Lianja SQL Server is as good as written up here why would you build in any other SQL? If you were to develop exclusively in the Lianja SQL what is the best practice? Would you just go native or cursor adapter?
Granted if connections were required to a foreign SQL based system then VT’s would be used.

Some references:
http://www.lianja.com/community/show...virtual+tables
http://www.lianja.com/community/show...virtual+tables