Topic: Using a component in a filter query
Rather than using the script facility to write a filter, I thought I might be able to parse an edit box into the filter query in the 'set up auto query'. Sadly this does not work, as it appears the filter searches for a column with the edit box name.
When a script is used either the SQLQuery or the SQLExecute are quite happy to have a component in the SQL text, so somewhere there is the ability to parse components into a SQL statement.
Before I give up and write the script, does anyone know if it is possible to retrieve the contents of an edit box and parse them into the filter script?
Image attached of what I'm trying to do. This creates the error; 'No such column frmMain.edtAssGroup.text' .
I have tried
(( assemblyNo ="{edtAssGroup}") AND (subOrdinateParts.id_part_categories != 2))
This doesn't cause an error message, but it doesn't work possibly because edtAssGroup is on the main form and not on the form I'm using to display this filtered result.
Thank you in advance.