Several problems on CBuilder6 with Postgresql 8.1
Posted: 17.12.2006, 06:08
i use zeosdbo with cbuilder6 and postgresql 8.1 . But i have several problems;
ZtoredProc component does not work. it is raise exception with message 'Unsupported operation'. After then i try to execute my stored procedure in a TZQuery but it doesnt work with open methods ,sometimes its work with ExecSQL method but i cant receive return value. However i try that with postgresdac Query component its work very well.So this is sample of code what is wrong ??
ZStoProc->Active = false;
ZStoProc->Params->Items[1]->AsInteger = 5;
ZStoProc->Params->Items[2]->AsString ="Test Value ";
ZStoProc->ExecProc();
if(ZStoProc->Params->Items[0]->AsBoolean)
ShowMessage("Its Done");
else
ShowMessage("Its Canceled");
Note: Param0 return value
ZtoredProc component does not work. it is raise exception with message 'Unsupported operation'. After then i try to execute my stored procedure in a TZQuery but it doesnt work with open methods ,sometimes its work with ExecSQL method but i cant receive return value. However i try that with postgresdac Query component its work very well.So this is sample of code what is wrong ??
ZStoProc->Active = false;
ZStoProc->Params->Items[1]->AsInteger = 5;
ZStoProc->Params->Items[2]->AsString ="Test Value ";
ZStoProc->ExecProc();
if(ZStoProc->Params->Items[0]->AsBoolean)
ShowMessage("Its Done");
else
ShowMessage("Its Canceled");
Note: Param0 return value