LOCAL lcLog_key_date, lcLog_key_time SELECT Audit_trail INDEX ON Color + Date + Time TAG MyTag IF SEEK([GREEN], [Audit_trail], [MyTag]) lcLog_key_date = Audit_trail.Date lcLog_key_time = Audit_trail.Time SELECT * FROM Audit_trail ; WHERE Date >= lcLog_key_date AND Time >= lcLog_key_time ; ORDER BY ... ENDIF>I need to select all the records from an audit trail after a key value changes. What I have is like this:
>date time color >20001001 18:03:12 RED >20001001 18:03:13 PINK >20001001 18:03:14 ORANGE >20001001 18:03:15 TEAL >20001001 18:03:16 GREEN >20001001 18:03:17 YELLOW >20001001 18:03:18 BLACK >20001001 18:03:19 WHITE >>
>select *, date+time as logkey from audit_trail into cursor stuff >select * from stuff where log_key >= (select log_key from stuff where color = "GREEN") > >>The problem is that there may be more than one green record, but I need to select all the changes since the first green record. I thought about using TOP, but that doesn't work in a sql select.