Is it possible to use ExecuteSQL to constrain the records shown on an exisiting layout, as a substitute for the Find dialog?
So far I can't seem to make this work, if it is, and I'm still a little foggy about where the results of a SQL query will actually appear, (other than in a massive text variable). I'd like the results to be reflected on my existing layout, juast as the results of a FIND query are.
Example... I have a layout that displays a normal set of contact fields, such as id, firstname, lastname, address1, address2, city, state, zip, and
I want to have a query that finds one record:
Select * from person where ID=1234
I know this is a trivial idea which is easily done using the Find button, but it is preliminary to a more involved query that I don't think I can do a find, where I want to update a field, based on a nested SQL query something like...
Update person set person.status=0 where person.id IN (SELECT person.id from table2)
Thanks for any help.