[Lazarus] Inactive Dataset

Dave Coventry dgcoventry at gmail.com
Wed May 28 10:32:36 CEST 2008


Sorry,

I should have been more specific....

SQLQuery1.SQL.Text:='SELECT fname,
sname,id,comboboxcourse,studentnumber,enquirydate,enquiryreferencenumber
from registration WHERE fname=''Dave''';
  StringGrid1.RowCount:=2;
  SQLQuery1.SQL.Text:=sqlq;
  SQLQuery1.Open;
  SQLQuery1.First;
  while not SQLQuery1.EOF do
  begin
    StringGrid1.Cells[0,i]:=SQLQuery1.FieldByName('fname').AsString;
    StringGrid1.Cells[1,i]:=SQLQuery1.FieldByName('sname').AsString;
    StringGrid1.Cells[2,i]:=SQLQuery1.FieldByName('id').AsString;
    StringGrid1.Cells[3,i]:=SQLQuery1.FieldByName('comboboxcourse').AsString;
    StringGrid1.Cells[4,i]:=SQLQuery1.FieldByName('studentnumber').AsString;
    StringGrid1.Cells[5,i]:=SQLQuery1.FieldByName('enquirydate').AsString;
    RecNumber:=RecNumber+','+SQLQuery1.FieldByName('enquiryreferencenumber').AsString;
    inc(i);
    StringGrid1.RowCount:=i+1;
  end;
  SQLQuery1.Close;

On Wed, May 28, 2008 at 9:01 AM, Dave Coventry <dgcoventry at gmail.com> wrote:
> Hi,
>
> I'm getting this: "operation cannot be performed on an inactive dataset".
>
> Googling (I'm on a slow dialup on someone else's line) seems to
> indicate that the problem is with my Lazarus version.
>
> The version I'm using is 0.9.23 beta SVN rev 12712.
>
> I obviously can't download a new version of Lazarus...
>
> Can anyone advise me?
>



More information about the Lazarus mailing list