Script priority

Jennifer Methlie

If a form has both a visual script and a client script on exit/submit, which takes precedance?  

 

I have a form with both and it just sitting and spins and never completes but never errs out.   The visual script inserts the data into a table but the client script is supposed to filter any single quotes from the memo fields on the form. 

 

Since I can't get the form to complete, i can't tell if the filter is working. 

 

Thanks

Jerome_Pearce

Client scripts go first always

Jerome_Pearce

Use SelectSql() and parameters for all SQL. That way you no longer have to mess about formatting and filtering. We left that behind in version 7!