Have such SP:
CREATE PROCEDURE PROC_INSERT (Name VARCHAR (24),City VARCHAR (24))
AS
declare variable ID decimal(15,0);
BEGIN
ID = Gen_ID( "Gen_ID_BI" , 1 );
insert into P_L( "ID","Name","City" )
values ( :ID,:Name,:City );
END


There are 2 TIB_Edit's with DataField's Name & City. Edit's connected to
TIB_Query, which SQL is:
select p."Name" , l."City" from PERSON p join LOCATION l on p."L_id"=l."L_id"
InsertSQL is:
execute procedure Proc_Insert( :Name, :City );

Now, when I click button, queries Insert() method is called. But starting
application raises exception "Invalid custom DML column reference: Name".
What is wrong?

Besides, am I right, that IBO will put Name & City params from edit's into
dataset when insert is issued? What actions are performed when insert
occures - post is needed or not?





--/ Gediminas /--
The Truth Is Out There