DataGrid Help... @#$%&^**

[NigelS]

Greetings

I'm in a fix. For some reason, maybe old age, I cannot get my head around the datagrid. The result I'm trying to achieve is to have a datagrid with two columns. The curved ball in this is the second column. In some instances it'll have a check box and in other instances it'll have a text displayed. See examples I've attached to this post. I've been at this for the last month and still cant get it right.

I've searched high and low for some sort of example but with not much success.

Can any of our esteemed LC gurus please give me some guidance on this and in return I will open my source code on how it was accomplished.

The attachment "My attempt" is what I'm trying to achieve.

Regards
Nigel

[Klaus]

Hi Nigel,

sorry, but what exactly is your question?

[NigelS]

How do I mix object types in the second column. In the attached screen dumbs the second column has different objects. How do I achieve this? I'm using the data grid as a the object

[Klaus]

Hi Nigel,

ah, OK, I see
Your datagrid will need to be of type FORM for this!

On the other hand, this does not look like a job for a datagrid but for a carefully layed out group!?


Best

Klaus

[NigelS]

That was my first option, unfortunately this "Property Detail" differs in it's structure which is dependant on what the user has selected on a previous card. In the PHP version of this "Property Details" is built up dynamically and I'm trying to do the same. The details of which are retrieved from a database table. I'm lacking in-depth knowledge of LC only having started with it about a year ago and I only get to play with it over the weekend's.

Any other idea's would be welcomed, bearing in mind that these objects would have to be created dynamically, also this application will be running on a iPad.

[Klaus]

Hi Nigel,

no idea how your data will be organized, but I would eventually create a group with ALL possible options
and then check the incoming data and show/hide all (un-)neccessary options. Know what I mean?


Best

Klaus

[NigelS]

For those interest this is the process :-

//Retrieve the data from the database

Code: Select all

function populatePropertyDetail pPropertySubType
   
   local tSqlQuery, tConnectionID, tSqlResult, tFunctionFailed 
   
   put false into tFunctionFailed
   put empty into lgPropertyDetailList
   put empty into lgPropertyDetailArray
   
   if GetDataBaseID() is empty then
      openDatabase GetPlatformDesc()
   end if 
   
   put GetDataBaseID() into tConnectionID
   
   put "SELECT pd2st.propSubTypeID, pdt.datatype, pd.* " & \ 
         "FROM propertydetail pd " & \ 
         "JOIN propdetail2propsubtype pd2st ON pd.ID = pd2st.propDetailID " & \ 
         "JOIN propertydetailstype pdt ON pdt.ID = pd.propDetailsType " & \ 
         "WHERE pd2st.propSubTypeID = " & pPropertySubType & \
         " AND active = 1" & \
         " ORDER BY pd.orderno " into tSqlQuery
   
   put revQueryDatabase( tConnectionId, tSqlQuery) into tSqlResult
   if tSqlResult is an integer then
      ConvertSQLResultToArray tSqlResult, lgPropertyDetailArray 
      revCloseCursor tSqlResult
   else
      put true into tFunctionFailed
   end if
   
   closeDatabase
   
   return tFunctionFailed
   
end populatePropertyDetail 

In the end of all the processing an array with the following details is made available to build the data grid

[NigelS]

So what your saying Klaus is to create a group with ALL the data entry properties that is possibly going to be used and then when the user makes the selection hide/unhide those objects that are required as per user request, inside the group?

[Klaus]

Yes! But this is a quick shot without knowing any detail

[NigelS]

what details would that be?

[Klaus]

Every detail!

No I think I would do it the way I decsribed above, one group with ALL possible options
(depends on how many options there will be) and show/hide them according to the incoming data.


Best

Klaus

[NigelS]

I will pursue that way.