Subject Cannot insert a new Row
Author Jackson Gomes
I'm trying to insert a new record in a IBOQuiery with the follow SQL
sentence:

>> Select T1.*, T2.SEC_LEVEL PARENT_SEC_LEVEL, t2.PROF_ID PARENT_PROF
>> From UCS_PACCESS T1 left outer join UCS_PACCESS T2 on
>>
>> T2.PROF_ID = (Select PARENT_PROF From UCS_PROFILES WHERE
>> PROF_ID = T1.PROF_ID) and
>> T2.APP_ID = T1.APP_ID and
>> T2.COMP_ID = T1.COMP_ID and
>> T2.FORM_ID = T1.FORM_ID
>>
>> Where (t1.APP_ID = :APP_ID1 or 0=:APP_ID2) and
>> T1.PROF_ID = :PROF_ID
>>
>> ORDER BY T1.APP_ID, T1.FORM_ID, T1.COMP_ID

Any idea why I get this message?

Thanks in advance.

Jackson Gomes
Tools&Comps - Security Components for Borland Developers.
Web Site: http://www.toolsandcomps.com
Our Forum: http://groups.yahoo.com/group/toolsandcomps
e-mail: jackson@...
Phone: 55 27 99602760 / 55 27 33891138