On 2018-01-25 16:15, Chris Davis wrote:
I guess just for ease when designing forms etc and having the view on the data environment , also interested in why it just doesn't work
My table is called stock and I get the error saying root.stock doesn't exist!
Sounds like it's not looking in your database.
SQLEXEC(liHandle,'USE MBSS_DATABASE')