Updates with user defined parameter types does not work
Posted: Fri 16 Sep 2005 12:55
I defined Domain type as
and table with column of this (udt_namealias) type.
Now when trying to do PgSqlDataAdapter.Update on a relevant dataset, the error "Cannot convert value" appears. No matter if CommanBuilder is used or parameters specified manualy as Varchar(16). On the same table with explicitly specified data types as Varchar everything works fine.
Can you help?
Code: Select all
CREATE DOMAIN "public"."udt_namealias" AS
varchar(16) NULL;
ALTER DOMAIN "public"."udt_namealias"
ADD CHECK ((VALUE)::text ~ '^\w.*$'::text);
Now when trying to do PgSqlDataAdapter.Update on a relevant dataset, the error "Cannot convert value" appears. No matter if CommanBuilder is used or parameters specified manualy as Varchar(16). On the same table with explicitly specified data types as Varchar everything works fine.
Can you help?