I'm a Delphi7 newbie trying to use Aducom's wrapper to SQLite and NextDBGrid to edit the following table:
Since a customer may have more than one phone number, I added the phones_tel_parent column. For each child phone number, I need to set this column to that customer's main phone number, or to NULL if it is that customer's main number.
To do this, I guess I need NextDBGrid to do this:
- it must have three columns: phones_tel, phones_name, and phones_tel_parent
- the third column must be a combobox that contains all the rows, so I can just pick the customer's main number
- fill the grid with all the rows from that table
- save this row to the SQLite database
Here's what things look like at this point:
I did read this article, but I don't know how to run SELECT on the grid and the combobox, and how to save the change to the database. Besides, when I hit F9, those TEXT columns are marked as "(MEMO)" in NextDBGrid :-/ Can someone help?