Hi!
This is my latest problem.

When I use DBProperty( "Northwind.Products", "FieldCount" ) function to get the number of columns in a recordset (ie. a processed query like SELECT * FROM Products) I get an empty response (should get an integer number).

I would like to use this number so I can dynamically change (add or delete) columns in a table.

Can anyone help?

Since I couldn't find the sollution using CX-Supervisor "FieldCount" property (on both SQL Server and Access database) I did it with the help of VBScript and ADO Recordset object..
Best Regards!

Thanks for the feedback