Hi,
Could anyone help me with this problem...
SELECT COUNT (*) AS OutputTotal from atable.
How do I access the OutputTotal value? Im using C++ builder.
TIA!
Kris

Not sure the syntax that you use in C++, but you would simply call that alias in your output section of the script.

Example, in ASP: %OutputTotal%, ColdFusion: #QueryName.OutputTotal#

You'd have to use the C++ correct syntax for outputting that column alias.
========================================
Buh Bye!

Cheers,
Me

Cheers for reply Stealth, got it now. If anyone is interested syntax is :
OutputNo=IBQuery->FieldByName("OutputNo")->AsInteger;

Thanks again
Kris