🚀 go-pugleaf

Hi!

I've just started programming databases with C++ Builder 5 enterprise, and I've encountered a few small problems.I hope you can help me with any or all of them.

I'm using ADO to access an SQL-Server database, and I'm using the ADO
data-access objects.

1) Right now I'm using this notation to read from or write to
database-fields Form->Table->FieldValues["FieldToAccess"], but in the help it states that this is slow because it returns a variant. How should I do to speed it up and return the value as a) an Integer or b) an AnsiString

2) I've managed to go through tables row by row, using Table->First() and Table->Next, is it possible to do the same on the results from a query?
As it is now I must go through every record and test the validity of it with an if-statement, it would be nice to use a query to filter out the interesting results before going through them one by one.

Thanks
Henrik