VirtualQuery linked to VirtualTable
Posted: Tue 03 Sep 2019 22:52
I am finding the lack of documentation for these components a bit of a challenge. I have created a VirtualTable called vtHTRX (the name of the component) and created a whole bunch of fields. I Open it. I now want to use VirtualQuery against it. Something line "SELECT * FROM vtHTRX WHERE something"
I open the VirtualQuery and I get an error message saying the table does not exist. How does one do this? I need to do some fairly complex filters on the table and vtHTRX.Locate is simply not good enough.
If I do get VirtualQuery to connect with a VirtualTable, does VirtualQuery.INSERT, VirtualQuery.EDIT work as per normal?
I open the VirtualQuery and I get an error message saying the table does not exist. How does one do this? I need to do some fairly complex filters on the table and vtHTRX.Locate is simply not good enough.
If I do get VirtualQuery to connect with a VirtualTable, does VirtualQuery.INSERT, VirtualQuery.EDIT work as per normal?