Newbies Dborges Posted May 28, 2004 Newbies Posted May 28, 2004 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!
Recommended Posts
This topic is 7753 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now