>Hi Vladimir,
>I start with functions and procedures (I try it).
>my first function (after 2 hours):
>Create function pokus
>(mem1 in number) return number is mem2 number;
>begin
>mem2:=10*mem1;
>return(mem2);
>end;
>It works and I call it with "select pokus(number) from dual".
>my first procedure (still not work):
>Create procedure pokus2
>(mem1 in number, mem2 in char)
>as begin
>insert into MyTable (fld1,fld2) values (mem1,mem2);
>end;
>It doesn't work.(Why?) Or, I don't know, how to call it. MyTable exists. SqlExecute(,'insert ..') works.
>I try all first in Enterprise manager and SQL worksheet and after it from VFP.
>Is it (in general) better to do Inserts, Deletes and Updates with procedures ?
>(Sequences are OK. I have first working forms classes for one table manipulation too.)
>Thanks forward, Pavel
Hello Pavel
You have to add begin -and for calling Oracle procedure
for exampse
sqlexec(con,' begin '+DSH+' set_pti_made ; end ;')
I use Oracle procedures with upadate or delete when I need some group operation
or in case calling this procedures does not produce immidiate effect on the client forms
Best wishes, Vladimir