[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