If all of the above is the case then why, in your documentation, is there no mention of "weight"? We are left to establish this how exactly? By trial and error because we are "advanced users"? That's quite an assumption.
A simple paragraph explanation in your documentation would have saved me half a day today... "PLEASE NOTE: If you are using the WebAssist MySQLi Update Record behaviour and you are querying from a recordset be sure to check that the Update code hasn't been inserted BEFORE the recordset code otherwise it won't work"
Or is it not included in the documentation because, in effect, you are describing a scenario whereby the extension simply doesn't work without manual coding?
If most people don't insert from a recordset, does that mean that I'm doing something wrong in my approach? Or, if it's least common, what is the most common approach?
The scenario in full...
1) An Insert form adds a new record to our database table and creates a session value which is the unique ID for that record.
2) The Insert form also inserts a value of "True" (1) to a tinyint field in the same database table. That field represents "hide from display" - the 1 (true) value means that it should not be displayed on the public side of the website.
3) Upon submit, the Insert form inserts to database and re-directs to a confirmation page.
4) We use the session value described in step 1 above to query the database table on our confirmation page in order to create a recordset from which we display the newly added record's data.
5) We use an Update form on the confirmation page to change the tinyint field value, as described in step 2 above, to False (2) = the 2 value means that it SHOULD be displayed on the public side of the website.
Whilst I grasp what you're saying you seem to be withholding information about the extensions functionality, particularly in the documentation, that would be of huge help to "advanced users" like myself AND would save you heaps of time responding to the same old "it's not working" support whines on this forum, by e-mail etc. ;)
I find the approach quite odd in its nature.
