Grid not editable

Hi,

Using SQLexec, I populate a cursor as the resultset

= SQLEXEC(lchandle, 'SELECT top 10 * FROM mytable', 'c_myresults')

I then populate the grid.

lgrid = Lianja.findElementByID("mygrid").grid
lgrid.clear
lgrid.additems('select top 10 * from c_myresults')

In the Section attributes of the grid I have toggled back and forth between the "Double Click to Edit", but no luck.
I also noticed that split view does not work in my case either.
What should I be doing differntly to allow me to edit a value in the grid?

Thanks.

Herb

Herb,

Did you ever get this issue resolved? I have a similar issue working with a grid on a custom canvas.

tia,

Jeff

Hi Jeff,

I changed to using virtualtables, it made everything much simpler.
Do a search on virtualtables, it is pretty straightforward. However just note that appending data to the virtualtable has a bug that is being fixed in the next release.
So for now, you can use SQLExec to update your data directly, but for populating my controls, I am using virtual tables.

Herb

Hi Jeff,

Did you get a chance to look at the virtualtable syntax?

Herb

Hi Jeff,

Have you had a chance to look at virtual Tables?

Herb