Hi,
Platform : PostgreSQLDirect .NET V3.85.33, VS2008 SP1, XP ProSP3
I'me getting a strange error calling SP in C# that table couple boolean and strings parameters. The error I get is
[syntax error at or near "pas"].
PAS is the Postgres schema as per below sp definition
CREATE OR REPLACE FUNCTION pas.sp_addclient(vclientname character varying,
vaccountnumber character varying,
vaddress1 character varying,
vaddress2 character varying,
vaddress3 character varying,
vaddress4 character varying,
vemailaddress character varying,
vtelephone character varying,
vcontactperson character varying,
vclientstatus character varying,
vclienttype character varying,
vurl character varying,
vmustdebit boolean,
vmustcrorrespond boolean,
vnotes text,
vbillingaddress text,
vpostaladdress text)
RETURNS void AS
....
Next is call from C#
cmdProcs.CommandText = "pas.sp_addclient";
cmdProcs.Parameters.Clear();
cmdProcs.ParameterCheck = true;
PgSqlParameter pm1 = new PgSqlParameter();
pm1.Direction = ParameterDirection.Input;
pm1.DbType = DbType.String;
pm1.ParameterName = "vclientname";
pm1.Value = edtClientName.Text;
cmdProcs.Parameters.Add(pm1);
....
PgSqlParameter pm13 = new PgSqlParameter();
pm13.Direction = ParameterDirection.Input;
pm13.DbType = DbType.Boolean;
//pm13.PgSqlType = PgSqlType.Boolean;
pm13.ParameterName = "vmustdebit";
pm13.Value = edtMustDebit.Checked;
....
cmdProcs.Parameters.Add(pm13);
Note: cmfProcs is PgSqlCommand connected to PgSqlConnection
Thanks in advance,
Alfred