Issue with DataGrid
Posted: Thu Aug 19, 2021 5:34 am
Howdy. I'm embarking on my first foray into databases and I've run into a problem I can't seem to overcome. I'm scraping data from a Wordpress website. Dragging a datagrid from the toolset to the card defaults to 'table' and I can connect and download the data into the 2 columns I want .. so far so good but it's when I try and display the data as a form (to allow for text wrapping) that the trouble starts.
For a start, the script examples in the LC lesson refer to tFieldRect but the default code in the 'Edit Script' button that appears when changing the behaviour of the datagrid from 'table' to 'form' is 'theFieldRect' and I can't get any data to show (I'm scrupulously following the lesson here). It's also curious that when displaying the data in a table, I can assign columns to various data eg. post_title and post_content (from the Wordpress DB) but changing the datagrid's default display from 'table' to 'form' causes the data to disappear (where have the columns gone?) and no matter what I do, I can't get the form to re-populate with data. Any advice appreciated.
For a start, the script examples in the LC lesson refer to tFieldRect but the default code in the 'Edit Script' button that appears when changing the behaviour of the datagrid from 'table' to 'form' is 'theFieldRect' and I can't get any data to show (I'm scrupulously following the lesson here). It's also curious that when displaying the data in a table, I can assign columns to various data eg. post_title and post_content (from the Wordpress DB) but changing the datagrid's default display from 'table' to 'form' causes the data to disappear (where have the columns gone?) and no matter what I do, I can't get the form to re-populate with data. Any advice appreciated.