J
jasdeep
Guest
Thanks Gus. I tried it , it is giving "unknown or giving ambiguios table X1.(545)." error. Here is actually what I try to implement. In a table I am looking for records for specific date . The date is when some changes are made to one of the field of table. The records that come up for that date ,for every record I want to show all the dates if any changes are done prior or after the selected date for that record. So if the search is for date "3/4/14" , then it should show the following records: ID Date Changed_Value abc 2/3/14 yes abc 3/4/14 no xyz 3/4/14 no xyz 6/7/14 no xyz 5/6/14 yes ghk 3/4/14 no fgt 3/4/14 yes In the above table the Changed_Value column refers to value that is changed . It can be changed between yes or no. IT DOES NOT MEAN THAT THE VALUE IS CHANGED OR NOT. IT IS THE ACTUAL VALUE. For records with ID abc and XYZ it shows the records for "3/4/14" along with other dates on which the value has been toggled from yes to no or from no to yes. I am using following code: define buffer x2 for RFSourceHistory. for each RFSourceHistory where date(x2.DATE_Time_Updated) = DATE("03/04/2014"): FIND x2 WHERE x2.Source_Id = RFSourceHistory.Source_Id . DISPLAY x2 EXCEPT comment WITH STREAM-IO WIDTH 100. END. Please help me in correcting the code. It is driving me nuts. Thanks
Continue reading...
Continue reading...