I am using Jim Duffys dataclas and I am getting to following error whenever I go to add a record through stored procedure:

OLE IDispatch exception code 0 from ADODB.Parameter: Application uses a value of the wrong type for the current operation...

In my dataclasvfp under lsaveobjectstore procedure it seem to be having this problem when saving a CHAR(40) value. My DCSP_tablename_ADD and DCSP_tablename_UPDATE are correct as follows:

/*DCSP_tablename_ADD */

CREATE PROCEDURE  DCSP_Juv_tbl_ADD 
@J_FNAME CHAR(40)
,@J_MI CHAR(20)
,@J_LNAME CHAR(40)
,@J_SSN CHAR(9)
,@J_DOB DATETIME
,@J_PFN CHAR(10)
,@J_DPO CHAR(10)
,@J_SEX CHAR(1)
,@J_RACE CHAR(10)
,@J_UNIT_DORM CHAR(20)
,@J_COUNSELOR CHAR(20)
,@J_DETBDTE DATETIME
,@J_PIN CHAR(10)
,@J_JOBASSIGN CHAR(20)
,@J_SCHOOLGROUP CHAR(20)
,@J_DATETIME DATETIME
,@J_FLAG1 INT
,@newkey INTEGER OUTPUT

AS 

/*  This procedure generated via the DataClas Stored Procedure Wizard on 06/29/04  */

BEGIN TRANSACTION 

INSERT INTO Juv_tbl(
J_FNAME
,J_MI
,J_LNAME
,J_SSN
,J_DOB
,J_PFN
,J_DPO
,J_SEX
,J_RACE
,J_UNIT_DORM
,J_COUNSELOR
,J_DETBDTE
,J_PIN
,J_JOBASSIGN
,J_SCHOOLGROUP
,J_DATETIME
,J_FLAG1
)
 VALUES (@J_FNAME
,@J_MI
,@J_LNAME
,@J_SSN
,@J_DOB
,@J_PFN
,@J_DPO
,@J_SEX
,@J_RACE
,@J_UNIT_DORM
,@J_COUNSELOR
,@J_DETBDTE
,@J_PIN
,@J_JOBASSIGN
,@J_SCHOOLGROUP
,@J_DATETIME
,@J_FLAG1
)
SELECT @newKey = @@IDENTITY 

COMMIT TRANSACTION
GO

here is the DCSP_tablename_UPDATE

CREATE PROCEDURE  DCSP_Juv_tbl_UPDATE 
@intPKID INTEGER ,@J_FNAME CHAR(40)
,@J_MI CHAR(20)
,@J_LNAME CHAR(40)
,@J_SSN CHAR(9)
,@J_DOB DATETIME
,@J_PFN CHAR(10)
,@J_DPO CHAR(10)
,@J_SEX CHAR(1)
,@J_RACE CHAR(10)
,@J_UNIT_DORM CHAR(20)
,@J_COUNSELOR CHAR(20)
,@J_DETBDTE DATETIME
,@J_PIN CHAR(10)
,@J_JOBASSIGN CHAR(20)
,@J_SCHOOLGROUP CHAR(20)
,@J_DATETIME DATETIME
,@J_FLAG1 INT

AS 

/*  This procedure generated via the DataClas Stored Procedure Wizard on 06/29/04  */

BEGIN TRANSACTION 

UPDATE Juv_tbl SET
J_FNAME= @J_FNAME,
J_MI= @J_MI,
J_LNAME= @J_LNAME,
J_SSN= @J_SSN,
J_DOB= @J_DOB,
J_PFN= @J_PFN,
J_DPO= @J_DPO,
J_SEX= @J_SEX,
J_RACE= @J_RACE,
J_UNIT_DORM= @J_UNIT_DORM,
J_COUNSELOR= @J_COUNSELOR,
J_DETBDTE= @J_DETBDTE,
J_PIN= @J_PIN,
J_JOBASSIGN= @J_JOBASSIGN,
J_SCHOOLGROUP= @J_SCHOOLGROUP,
J_DATETIME= @J_DATETIME,
J_FLAG1= @J_FLAG1 WHERE J_PK_ID=@intPKID
COMMIT TRANSACTION
GO

It is crashing when parameter object is assigned a value as VALUE = lxvalue.

Thanks
Nick Patel