Getting Fielddefs

[Guest]

In dbGo you can assign a storedprocecure name to TADOStoredProc and go myAdoSP.FieldDefs.Update and it will obtain the list of fielddefs for the stored procedure. Is there an equivalent for SDAC as the ADO technique doesn't work.

Thanks in advance.

Richard

[Ikar]

This technique is applicable for SDAC. Please send us small complete sample and include script to create StoredProc

[Ikar]

The problem is in incorrect setting of StoredProc name. Instead of 'Ten Most Expensive Products' you should use 'Ten Most Expensive Products;1'

The easiest way to fill FieldDefs:

Code: Select all

 MSStoredProc1.Connection.Open;
 MSStoredProc1.StoredProcName := 'Ten Most Expensive Products;1';
 MSStoredProc1.FieldDefs.Update;