AnsweredAssumed Answered

SQL for an existing layout

Question asked by lkeyes on Nov 14, 2013
Latest reply on Nov 14, 2013 by databuzz

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.

 

--- L

Outcomes