How do I save the current SQL statement as is so it can be loaded again and amended? (ActiveX Edition)
Hi I am a new to developing with your activeX component
How do I save the current tables/select statement as is so it can be loaded again and amended ?
I tried SaveToXMLFile but this does not seem to do anything
Also this and many other methods exposed by the activex do not appear to be in the help file which only seem to contain a tiny fraction of them ?
To load SQL query back to the component you can simply assign it's text to the ActiveQueryBuilderX.SQL property. Also if you want to save and load the layout of tables within the Design Area among with SQL text, you can read and write the ActiveQueryBuilderX.LayoutSQL property.
If you want to syncronize Active Query Builder with the SQL text editor, Use the ActiveQueryBuilderX.SQLUpdated event to get new SQL query text each time when the query is updated in Active Query Builder visually. In the text editor, assign the text from the editor to the ActiveQueryBuilderX.SQL property on exiting from the SQL text editor, but handle the exceptions, as the end-user may write incorrect SQL text, so Active Query Builder wouldn't be able to parse it.