[Lazarus] Inactive Dataset

[Dave Coventry]

Marc,

Thanks very much for looking at the code. My fault, the above example
is a cut and paste from the original code and my cutting knife must
have slipped!

In any case, the SQLQuery1.SQL.Text is not overwirrten in my code. :)



On Wed, May 28, 2008 at 4:21 PM, Marc Santhoff <M.Santhoff at t-online.de> wrote:
> Hi,
>
> I'm not really sure if this is a c&p-error or the like, but ...
>
> Am Mittwoch, den 28.05.2008, 10:32 +0200 schrieb Dave Coventry:
>> 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;
>
> ... here you assign another string named sqlq and overwrite the nice SQL
> from above.
>
> Maybe that line is still in your code messing up the query?
>
> HTH,
> Marc
>
>>   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?
>> >
>> _______________________________________________
>> Lazarus mailing list
>> Lazarus at lazarus.freepascal.org
>> http://www.lazarus.freepascal.org/mailman/listinfo/lazarus
>>
>
> _______________________________________________
> Lazarus mailing list
> Lazarus at lazarus.freepascal.org
> http://www.lazarus.freepascal.org/mailman/listinfo/lazarus
>