Page 1 of 1
Getting Fielddefs
Posted: Sun 06 Feb 2005 16:19
by 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
Posted: Mon 07 Feb 2005 09:54
by Ikar
This technique is applicable for SDAC. Please send us small complete sample and include script to create StoredProc
Posted: Wed 16 Feb 2005 12:10
by 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;