More Data Grid Difficulties - Making it request data

[Len Morgan]

On 3/16/2010 6:57 AM, Trevor DeVore wrote:
> On Mar 16, 2010, at 12:15 AM, Len Morgan wrote:
>
>> I found the manual pages for coloring lines in a data grid table but 
>> it's not working.  I'm pretty sure that the reason is because I'm 
>> settting the dgText to the array I create from the database records 
>> and that is bypassing the FillInData routine.
>
> Setting the dgText does not bypass FillInData. You can't actually 
> display any data in the Data Grid without FillInData being called.
>
> What makes you think it is being bypassed?
>
> What columns have you defined in your data grid table and how are you 
> assigning in the dgText?
>
To answer your first question, the lines aren't getting colored and I 
have a message that's supposed to print to the message box as it goes 
by.  I went so far as to put a 500 ms delay in this routine (so EVERY 
column would wait 1/2 a second just in case the message got overwritten 
by a later message.

I'm not sure what you mean exactly by "what columns have you defined".  
They are all text fields, (e.g., no icons, images, buttons, etc).  I 
create the data array by going though the returned data a line at a time 
and creating a tab (col) delimited, cr (row) delimited variable then use:

set the dgText of group "searchResults" to theDataA

To clarify your first comment,  if I set the entire data array using 
dgText, does it call FillInData for every line possible or only the 
visible ones?  The reason I ask is that one of the things I want to do 
with FillInData is to get three more fields that don't come out of the 
original query.  I have two dates that come out of another table and 
have not been able to come up with any SQL query that would return these 
fields in the original query.  What I want to do is when FillIndata gets 
to the first field (key field), I can call another query for that one 
record only.  As each row is processed, I can get these two dates.  This 
will not be a processing burden IF I only fill the data that is on the 
screen at the time.

The last "field" I need isn't really a field but rather, based on the 
value of this field, I need to set the row color.  This field I DO have 
at the time theDataA array is created.

len