>I am using ADO to invoke a stored procedure on a DB2 mainframe using FoxPro 5.0.
>
>In using Help files from VB, Constants are used for TYPE and DIRECTION. Unfortunately, FoxPro does not have the integer values of each with the CONSTANT name.
>
>I have found adChar = 129, adInteger = 3.
>
>Can someone please tell me where to find the integer values of the rest of the TYPEs or at least the integer values of adDouble, adVarChar and adDecimal are.
>
>DIRECTION CONST's are :
>adParamInput = 1
>adParamOutput = 2
>adParamInputOutput = 3
>adParamReturnValue = ? (don't know but do not need yet either)

If I may, consider using the following tool from the UT downloads: http://www.levelextreme.com/wconnect/wc.dll?FournierTransformation~2,54,Forum=5,28,1196 , it will go to the selected stored procedure and create a parameters collection with field / parameter types and all. The provider needs to support the Refresh method of the parameters collection for this to work.

Also you can download rs2dbf.exe from MS that contains a VFP include file with the ADO constants. The link is http://support.microsoft.com/support/kb/articles/Q192/6/92.ASP

HTH