alternative version without placeholder: the WHERE clause is important or else this will affect ALL the rows in the table. Put "UPDATE survey_results SET favourite_picture = :1 WHERE rowid =" & tRowID into tSQL Put theDataA into timage2 -this I assume is the Base64Encoded data, not the binary Put the dgDataOfLine of group "mydatagrid" into theDataA Put the dgHilitedLines of group "mydatagrid" into theLine but don't really understand.Ĭode: Select all command takeImageFromDatagrid I have tried reading a few of the the forums / livecode lessons, etc. The problem is I can't get my head round how to start getting my head round how to do this. Then when I press a button or as the app/card closes save changes to the db to the right row/cell etc. after the survey, I would like go through the form shown in the screenshot and if the "species recorded" is right tick the checkbox, or if not, select the species from the option menu (or ideally using an input field with predictive text to guess the name as i start typing, although this doesn't seem to be possible) the field "species recorded" is the name of the species the child thinks the picture shows (this again is saved earlier in the app and then used to populate the form). the image at the left hand side of each row is just a placeholder for now, but when the app is used it will show pictures taken during a wildlife survey (these pictures are taken earlier in the app and saved in the sqlite db, then used to populate the form). So, the last page I need to do is basically a datagrid form with a tick box and option menu (or similar) - I have uploaded a screenshot that probably explains it better: Thanks very much for all your help on my last post about blob images, after many hours its now working fine (I am however starting to think that datagrids may not be the best thing to try and use in your first app!).Īnyway, I thought I may as well plough on seeing as I've almost finished.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |