May 28, 200421 yr Newbies Hi List!!! We have two different problems using Inline code: 1) First problem When we use this code (search and update): [inline: -Search, -Database='Contacts', -Table='People', -FMScript='DTcreate', -KeyField='recID', 'username'=(Field:'username')] [inline: -Update, -Database='Contacts', -Table='People', -KeyField='recID', -KeyValue=(field:'recID'), 'name'=(Var:'name'), 'email'=(Var:'email'), 'Address'=(Var:'Address'), 'ZipCode'=(Var:'ZipCode'), 'Phone'=(Var:'Phone'), 'City'=(Var:'City')] [/inline] [/inline] The errors generated by File Maker are ignored! In FM we are validating the phone number with the zip code since in our country the phone number is associated with the zip code. In case the phone number matches the zip code FMP accepts the data and the record is updated, if not the data is rejected and an error occurs. When the error occurs in the database nothing happens. The fields that were changed remain with the same information, and lasso reports nothing serving the html reporting your changes where made. 2) Second problem (different set of htmls and different database) The Update command only works if i have an error (for example a required field is left empty). If I fill all the fields the update doesn't work! Sometimes happens a strange thing: in spite of doing an Update, FMP ignores the -KeyField='recID' updating the first record in the database. [inline: -Search, -Database='Contacts', -Table='People', -KeyField='recID', 'username'=(Field:'username')] [inline: -Update, -Database='Contacts', -Table='People', -KeyField='recID', -KeyValue=(field:'recID'), 'name'=(Var:'name'), 'email=(Var:'email'), 'Address'=(Var:'Address'), 'ZipCode'=(Var:'ZipCode'), 'City'=(Var:'City')] [/inline] [/inline] We noted that the Inline tag is the first command to be executed. Is there anyway of changing this situation, and execute it at the end? Hardware and software setup: We are using WebStar V, lasso 6 (with AutoValidate 1.5.1) and FMP 5.5 Unlimited, each running on different xServers system X 10.2.8. Each application is running alone. In case of AutoValidate, we have the same results with or without it. Best Regards!
Create an account or sign in to comment