using default_where when no value is returned
Hello all,
Can someone tell me what code I should write for a when button pressed instance if the table used in the following code does not have a record that exist. I am getting a missing expression error. I have some instances where a record will not exist in tabletwo and instead of continuing the form is giving me an error.
set_block_property('tabletwo',default_where,'PERSON_ID = '||chr(39)||:dummy_block.PERSON_ID||chr(39)||' and incident_id = '||:tableone.incident_id);
execute_query;
Can someone tell me what code I should write for a when button pressed instance if the table used in the following code does not have a record that exist. I am getting a missing expression error. I have some instances where a record will not exist in tabletwo and instead of continuing the form is giving me an error.
set_block_property('tabletwo',default_where,'PERSON_ID = '||chr(39)||:dummy_block.PERSON_ID||chr(39)||' and incident_id = '||:tableone.incident_id);
execute_query;
0