LiveCode Forums.

Hello, it has been a while since i used the datagrid and had a simple question about datagrid tables. Maybe it is so simple, that I couldnt find any other threads on it so I decided to ask.

If I were to query a database and pull out tables X, Y, and Z. And say I had a template for each X Y and Z and a behavior for each as well. But I didn't know in what order they will appear, sometimes X is first, sometimes Z. And they could appear multiple times and I need to label the columns accordingly and sometimes build as many as 20 columns. How would I go about doing that?

I looked at the api and was looking for function like "dgCreateColumn" or "dgSetColumnLabel" but I didn't see anything. Did I miss something?

-Will

Hi Will,

you want to set a couple of properties: Grab your PDF copy of the complete datagrid docs here: http://lessons.livecode.com/m/datagrid_tips
A TINY link, must be seven points or something, sigh, under the Topics on the left side.

I read it up again and again and again whenever I need to work with datagrids!
Or answer DG related questions here in the forum.


Best

Klaus

Thanks klaus! Exactly what i was missing

The PDF Klaus has referred you to has not been updated to use the current IDE interface.
If you are using LC 8.1 or above please check out the included Dat Grid guide.
It has been updated to the version 8 interface which helps in doing the exercises.
You access it via the "Guide" tab in the Dictionary window.

Yes, sorry, I forgot that the docs are now in the dictionary in LC 8.1!

Im sad to say that is what I was using , I just didnt see the dgProps["columns"]. I must have just missed it.

Thanks!