ansaurus

Question

Answer 1

+2 A:

I believe the new types all map to System.String:

case ACE.ADS_NCHAR:
case ACE.ADS_NVARCHAR:
   return Type.GetType( "System.String" );

case ACE.ADS_NMEMO:
   return Type.GetType( "System.String" );

Jeremy Mullin 2010-10-18 13:17:21

What I need is the Advantage Client Engine Constant Name for these data types. This is critical for parsing metadata. I use these in an Enumeration.

Howard Edidin 2010-10-18 13:29:25

The Advantage Client Engine only uses integer constants, the ones I mentioned above (ACE.ADS_NCHAR, etc.). The text versions are self-explanatory ("nchar", "nvarchar", "nmemo").

Jeremy Mullin 2010-10-18 20:23:04

I am not using the ACE. I am using ADO.NET to call sp_getProcedureColumns to return the TYPE_NAME.

Howard Edidin 2010-10-19 12:09:52

This returns i.e ADS_TIME

Howard Edidin 2010-10-19 12:11:07

look at the Advantage .NET Data Provider Data Types in the documentation.

Howard Edidin 2010-10-19 12:12:26

ansaurus

tags:

views:

answers:

I see new datatypes in the ARC list.

related questions