Jump to record using TfrxADOQuery at runtime!
Hello everyone,
Using TfrxADOQuery in data page, I try to locate specific record at runtime, here is my attempt:
Regards.
Using TfrxADOQuery in data page, I try to locate specific record at runtime, here is my attempt:
    with DataSets[0].DataSet do begin   Â
      RecNo := OtherDataSet.RecNo;//RecNo is readOnly :(
      RangeBegin := rbCurrent;
      RangeEnd := reCount;
      RangeEndCount := 1;     Â
    end;
I can't change RecNo from TfrxDataSet since its readyOnly property, any workaround will be appreciated.Regards.
Comments
run the main demo and look at other features, "urls,anchors" report or
under internaldatasets, "Internal query report" or
under ndialogs and script, "choosing records to print" report.
I have all above doubts because I do NOT know what do you really need to point in the second query or what kind of relation between those two DataSets you already have or want to make.
Write some words about the reality of those queries and it will help to understand your need and to show you the way of further tests.
Maybe that what is good to you is a classic master-detail relation of two queries (datasets). If so then you may find here (this forum - a few days ago) examples of how to use WHERE condition in queries after design time, when report is in use. Rcsoft & Gorousek have started similar topics.
And a bit more - have a look at TDataSet.Locate( Keyfields, KeyValues, Options). I was close to use this method but gave up, as I did not found explanation of TLocateOptions in documentations - maybe you'll be the lucky one and you'll get through it :-)
Mick