cx-supervisor: database "FieldCount" property

[pro17 0]

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?

[pro17 0]

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! Edited 28 Nov 2007 by pro17

[PdL 71]

Thanks for the feedback