I am using trial o IBDAC and try to make some simple test task as this one :
I have a TIBCQuery with a SQL text :
Field “Type” has values 1 = Customer, 2 = Supplier, 3 = Contact ,so ParType gets values from 1-3. I display the records in a grid, so far OK.SELECT FullName, Phone, Address, Type FROM Contacts WHERE Type :ParType
I need to get RecordCount for type = 1 (customers) and the grid is showing record results from type =2 (Suppliers)
when the RecordCount is executed the grid is showing the result from type = 1 (Customers) .
Note that the SQlRecCount text is the same as above and property QueryRecordCount = True. Before I execute the
TIBCQuery.RecordCount I pass the parameter as 1 (Customers).
Is there something that I missing or do I need to create a new query for that, to pass a diffrent parameter?
Thank you,
John