Hi, I have a very wierd problem regarding the use of Delphi 5's ADO Stored
Procedure component.  When I set the Stored procedure component (this stored
procedure component is pointing to the MSSQL 7 stored procedure code below)
to active, it produces the following error "Insert Error:  Column name or
number of supplied values does not match table definition".  The wierd thing
was that if I use Delphi 5's stardard Stored Procedure component, it works!

Also, I am using SQLOLEDB as the Provider in the ConnectionString property
of the ADO Stored Procedure component.

Can someone help with this problem?

Please advise.

Thank you.

Jose...

***** Begin of SP ******
CREATE PROCEDURE GetTablesAndColumns
AS
BEGIN

  -- Create temporary table
  Create Table #SPColumns
 (xTABLE_QUALIFIER sysname,
 xTABLE_OWNER sysname,
 xTABLE_NAME sysname,
 xCOLUMN_NAME sysname,
 xDATA_TYPE smallint,
 xTYPE_NAME varchar(50),
 xPRECISION int,
 xLENGTH int,
 xSCALE smallint NULL,
 xRADIX smallint NULL,
 xNULLABLE smallint,
 xREMARKS varchar(254) NULL,
 xCOLUMN_DEF varchar(254) NULL,
 xSQL_DATA_TYPE smallint NULL,
 xSQL_DATETIME_SUB smallint NULL,
 xCHAR_OCTET_LENGTH int NULL,
 xORDINAL_POSITION int NULL,
 xIS_NULLABLE varchar(254) NULL,
 xSS_DATA_TYPE tinyint NULL)

  INSERT INTO #SPColumns exec sp_Columns @table_name = N'CUST'    <-- this
can be any existing in you database

 Select * from #SPColumns

END

***** End of SP ******