09-17-2007 04:56 AM
09-17-2007 08:04 AM
09-17-2007 10:50 PM
Tnal u 4 ur reply sir.
I am still confused...so let me ask my doubts?
In my point of view, i have to select all records from setting table(for checking purpose)and all records(depending on criteria,ie,which day's record the user wants 2 view) from info table.There may be a number of records in a particular day may be more than 300 records.And there may be records of different stations.(setting table is a master table which stores the information of all stations like how many pumps the station have,how many reservoir the station have...Not only pump but reservo,flow...also i have to check before display.)
What i have to do is display theselected records of info table by after checking for the field in the setting table.If i have 300 records i have to repeat the task for all the records.I have to check each field of the record of info table got value of 0 or 1 in setting table.If 0 just i have to display ' - ' and if its value is 1 i have to display the value of that field of the record as it is.For 300 records,i have to select each record,take each field and compare its value in setting table.This will be really time consuming process
If iam constructing a matrix as u suggested, i dont know how 2 go 4wd.Bse i am not only dealing wth pump but reservo levels,flow levels...has also to be checked and so the matrix multiplication also become complex,and have to do for all the 300 records also.
Can u please suggest a work around for my issue?
Thanx once again
09-17-2007 11:17 PM
09-18-2007 07:42 AM