General information
Category:
Forms & Form designer
Here is the code.
ThisForm.txtProcessDisplay.value = "Building road inventory records"
ThisForm.txtProcessDisplay.refresh
SELECT *
FROM plc,lne;
WHERE lne_placement_id = plc_placement_id ;
AND lne_survey_id $ ThisForm.cSurveyString ;
AND SUBSTR(lne_lane_number,1,1) $ 'RL' ;
AND !lne_unable_to_rate ;
AND !lne_unsafe_to_rate ;
ORDER BY lne_placement_id, lne_lane_number;
INTO TABLE data\pmi_inventory;
DATABASE data\pmib;
NAME pmi_inventory
The textbox object is not refreshed until after the SQL statement finishes.
I have tried both using a refresh on the textbox alone and the whole form.
Same results, no refresh until after the SQL executes.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only