If i try to read the FieldList.Origin poperty in the afterexecute event it returns nothing.

works fine if i read it a second or more after.

Aaron,

<< If i try to read the FieldList.Origin poperty in the afterexecute event
it returns nothing.

works fine if i read it a second or more after.  >>

DBISAM query execution is not asynchronous, so this doesn't make any sense.

Are you using DBISAM with multiple threads ?  What version of Delphi are you
using ?  Is it 32-bit or 64-bit ?  Are you using the DBISAM Database Server
?  If so, is it 32-bit or 64-bit ?

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com

Are you using DBISAM with multiple threads ?
No

What version of Delphi are you using ?
2010

Is it 32-bit or 64-bit ?
32

Are you using the DBISAM Database Server, If so, is it 32-bit or 64-bit ?
yes, 32bit running on SBS2011

if i do this it works fine, but if i move it to the AfterExecute event if fills the list box with blank items.

procedure TForm1.Button1Click(Sender: TObject);
var
 Cntr: word;
 Field: string;
begin
 qryMisc.ExecSQL;
 
 for Cntr := 0 to qryMisc.FieldList.Count - 1 do
 begin
   Field := qryMisc.FieldList[Cntr].Origin;
   ListBoxFields.Items.Add(Field);
 end;

end;

Aaron,

<< if i do this it works fine, but if i move it to the AfterExecute event if
fills the list box with blank items. >>

Duh, sorry, I should have known this one right away and told you when you
first asked.  I'm a little rusty on DBISAM stuff lately.

You need to use the AfterOpen event handler instead - AfterExecute only
fires after executing individual SQL statements *in a script*.

If you have any other questions, please let me know.

Tim Young
Elevate Software
www.elevatesoft.com