Subject Re: [IBO] Rights problem
Author Don Gollahon
It appears that the orderingitems, etc, only allow ordering on single
fields. I wantd to order by multiple fields in one case so that's why I use
the SQLOrder.

Anyway, my "insert" problem results in the following monitor output. There
is an insert in there for some reason but I have no idea where it is coming
from. It doesn't happen with the sysdba login. All I did was chose to
change the sort order by selecting a different option from the sort
combobox. All that does is close the table, change the Sqlorder, and open
the table. The error occurs on the line of code that closes of the table:

/*---

[ 1/19/2002 4:54:18 PM ]

CLOSE CURSOR

STMT_HANDLE = 11297460

----*/

/*---

[ 1/19/2002 4:54:18 PM ]

ALLOCATE STATEMENT

DB_HANDLE = 11294596

STMT_HANDLE = 11289096

----*/

/*---

[ 1/19/2002 4:54:18 PM ]

PREPARE STATEMENT

TR_HANDLE = 11294208

STMT_HANDLE = 11289096

INSERT INTO PARTNERINFO(

ID, /*PK*/

FIRST_NAME,

MIDDLE_NAME,

LAST_NAME,

ADDR1,

ADDR2,

CITY,

STATE,

ZIP,

HOME_PHONE,

WORK_PHONE,

NOTES,

PRAYER_DAY,

ACTIVE_,

EMAIL_ADDRESS,

EMAIL2,

FAX_NUMBER,

BIRTHDATE,

MAILING_LIST_ONLY,

MINISTER,

LOGIN_NAME)

VALUES (

? /* ID */ ,

? /* FIRST_NAME */ ,

? /* MIDDLE_NAME */ ,

? /* LAST_NAME */ ,

? /* ADDR1 */ ,

? /* ADDR2 */ ,

? /* CITY */ ,

? /* STATE */ ,

? /* ZIP */ ,

? /* HOME_PHONE */ ,

? /* WORK_PHONE */ ,

? /* NOTES */ ,

? /* PRAYER_DAY */ ,

? /* ACTIVE_ */ ,

? /* EMAIL_ADDRESS */ ,

? /* EMAIL2 */ ,

? /* FAX_NUMBER */ ,

? /* BIRTHDATE */ ,

? /* MAILING_LIST_ONLY */ ,

? /* MINISTER */ ,

? /* LOGIN_NAME */ )

FIELDS = [ Version 1 SQLd 0 SQLn 30 ]

SECONDS = 0.010

ERRCODE = 335544352

----*/

/*---

[ 1/19/2002 4:54:18 PM ]

INTERPRETE BUFFER = * EMAIL2 */ ,

? /* FAX_NUMBER */ ,

? P�

ERRCODE = 58

----*/

/*---

[ 1/19/2002 4:54:18 PM ]

INTERPRETE BUFFER = no permission for insert/write access to table
PARTNERINFO

ERRCODE = -1

----*/

/*===

[ 1/19/2002 4:54:18 PM ]

//>>> ERROR <<<//

ISC ERROR CODE:335544352

ISC ERROR MESSAGE:

no permission for insert/write access to table PARTNERINFO

STATEMENT:

TIB_Statement:
"<TApplication>.dmRReq.ibqAllPartnerInfo.<TIB_UpdateSQL>.<TIB_Statement>."
stHandle=11289096 (ERROR)



STATEMENT:

TIB_Query: "<TApplication>.dmRReq.ibqAllPartnerInfo." stHandle=11297460
(ERROR)

//>>> SQL MESSAGE <<<//

SQL ERROR CODE:-551

SQL ERROR MESSAGE:

This user does not have privilege to perform this operation on this object.

//>>> SQL <<<//

INSERT INTO PARTNERINFO(

ID, /*PK*/

FIRST_NAME,

MIDDLE_NAME,

LAST_NAME,

ADDR1,

ADDR2,

CITY,

STATE,

ZIP,

HOME_PHONE,

WORK_PHONE,

NOTES,

PRAYER_DAY,

ACTIVE_,

EMAIL_ADDRESS,

EMAIL2,

FAX_NUMBER,

BIRTHDATE,

MAILING_LIST_ONLY,

MINISTER,

LOGIN_NAME)

VALUES (

? /* ID */ ,

? /* FIRST_NAME */ ,

? /* MIDDLE_NAME */ ,

? /* LAST_NAME */ ,

? /* ADDR1 */ ,

? /* ADDR2 */ ,

? /* CITY */ ,

? /* STATE */ ,

? /* ZIP */ ,

? /* HOME_PHONE */ ,

? /* WORK_PHONE */ ,

? /* NOTES */ ,

? /* PRAYER_DAY */ ,

? /* ACTIVE_ */ ,

? /* EMAIL_ADDRESS */ ,

? /* EMAIL2 */ ,

? /* FAX_NUMBER */ ,

? /* BIRTHDATE */ ,

? /* MAILING_LIST_ONLY */ ,

? /* MINISTER */ ,

? /* LOGIN_NAME */ )

====*/

/*---

[ 1/19/2002 4:54:20 PM ]

PREPARE STATEMENT

TR_HANDLE = 11294208

STMT_HANDLE = 11289096

INSERT INTO PARTNERINFO(

ID, /*PK*/

FIRST_NAME,

MIDDLE_NAME,

LAST_NAME,

ADDR1,

ADDR2,

CITY,

STATE,

ZIP,

HOME_PHONE,

WORK_PHONE,

NOTES,

PRAYER_DAY,

ACTIVE_,

EMAIL_ADDRESS,

EMAIL2,

FAX_NUMBER,

BIRTHDATE,

MAILING_LIST_ONLY,

MINISTER,

LOGIN_NAME)

VALUES (

? /* ID */ ,

? /* FIRST_NAME */ ,

? /* MIDDLE_NAME */ ,

? /* LAST_NAME */ ,

? /* ADDR1 */ ,

? /* ADDR2 */ ,

? /* CITY */ ,

? /* STATE */ ,

? /* ZIP */ ,

? /* HOME_PHONE */ ,

? /* WORK_PHONE */ ,

? /* NOTES */ ,

? /* PRAYER_DAY */ ,

? /* ACTIVE_ */ ,

? /* EMAIL_ADDRESS */ ,

? /* EMAIL2 */ ,

? /* FAX_NUMBER */ ,

? /* BIRTHDATE */ ,

? /* MAILING_LIST_ONLY */ ,

? /* MINISTER */ ,

? /* LOGIN_NAME */ )

FIELDS = [ Version 1 SQLd 0 SQLn 30 ]

ERRCODE = 335544352

----*/

/*---

[ 1/19/2002 4:54:20 PM ]

INTERPRETE BUFFER = * EMAIL2 */ ,

? /* FAX_NUMBER */ ,

? P�

ERRCODE = 58

----*/

/*---

[ 1/19/2002 4:54:20 PM ]

INTERPRETE BUFFER = no permission for insert/write access to table
PARTNERINFO

ERRCODE = -1

----*/

/*===

[ 1/19/2002 4:54:20 PM ]

//>>> ERROR <<<//

ISC ERROR CODE:335544352

ISC ERROR MESSAGE:

no permission for insert/write access to table PARTNERINFO

STATEMENT:

TIB_Statement:
"<TApplication>.dmRReq.ibqAllPartnerInfo.<TIB_UpdateSQL>.<TIB_Statement>."
stHandle=11289096 (ERROR)



STATEMENT:

TIB_Query: "<TApplication>.dmRReq.ibqAllPartnerInfo." stHandle=11297460
(ERROR)

//>>> SQL MESSAGE <<<//

SQL ERROR CODE:-551

SQL ERROR MESSAGE:

This user does not have privilege to perform this operation on this object.

//>>> SQL <<<//

INSERT INTO PARTNERINFO(

ID, /*PK*/

FIRST_NAME,

MIDDLE_NAME,

LAST_NAME,

ADDR1,

ADDR2,

CITY,

STATE,

ZIP,

HOME_PHONE,

WORK_PHONE,

NOTES,

PRAYER_DAY,

ACTIVE_,

EMAIL_ADDRESS,

EMAIL2,

FAX_NUMBER,

BIRTHDATE,

MAILING_LIST_ONLY,

MINISTER,

LOGIN_NAME)

VALUES (

? /* ID */ ,

? /* FIRST_NAME */ ,

? /* MIDDLE_NAME */ ,

? /* LAST_NAME */ ,

? /* ADDR1 */ ,

? /* ADDR2 */ ,

? /* CITY */ ,

? /* STATE */ ,

? /* ZIP */ ,

? /* HOME_PHONE */ ,

? /* WORK_PHONE */ ,

? /* NOTES */ ,

? /* PRAYER_DAY */ ,

? /* ACTIVE_ */ ,

? /* EMAIL_ADDRESS */ ,

? /* EMAIL2 */ ,

? /* FAX_NUMBER */ ,

? /* BIRTHDATE */ ,

? /* MAILING_LIST_ONLY */ ,

? /* MINISTER */ ,

? /* LOGIN_NAME */ )

====*/

/*---

[ 1/19/2002 4:54:23 PM ]

PREPARE STATEMENT

TR_HANDLE = 11294208

STMT_HANDLE = 11297460

SELECT P1.*,

Last_name||', '||First_name as Member_Name

FROM PARTNERINFO P1

Where Active_ = 'Y'

ORDER BY Prayer_day ASC

PLAN (P1 ORDER PRAYER_DAY)

FIELDS = [ Version 1 SQLd 22 SQLn 30

PARTNERINFO.ID = <NIL>

PARTNERINFO.FIRST_NAME = <NIL>

PARTNERINFO.MIDDLE_NAME = <NIL>

PARTNERINFO.LAST_NAME = <NIL>

PARTNERINFO.ADDR1 = <NIL>

PARTNERINFO.ADDR2 = <NIL>

PARTNERINFO.CITY[CITY] = <NIL>

PARTNERINFO.STATE = <NIL>

PARTNERINFO.ZIP = <NIL>

PARTNERINFO.HOME_PHONE = <NIL>

PARTNERINFO.WORK_PHONE = <NIL>

PARTNERINFO.NOTES = <NIL>

PARTNERINFO.PRAYER_DAY = <NIL>

PARTNERINFO.ACTIVE_ = <NIL>

PARTNERINFO.EMAIL_ADDRESS = <NIL>

PARTNERINFO.EMAIL2 = <NIL>

PARTNERINFO.FAX_NUMBER = <NIL>

PARTNERINFO.BIRTHDATE = <NIL>

PARTNERINFO.MAILING_LIST_ONLY = <NIL>

PARTNERINFO.MINISTER = <NIL>

PARTNERINFO.LOGIN_NAME = <NIL>

[MEMBER_NAME] = <NIL> ]

SECONDS = 0.010

----*/

/*===

[ 1/19/2002 4:54:23 PM ]

//>>> STATEMENT PREPARED <<<//

TIB_Statement.API_Prepare()

TIB_Query: "dmRReq.ibqAllPartnerInfo" stHandle=11297460

====*/

/*---

[ 1/19/2002 4:54:23 PM ]

PREPARE STATEMENT

TR_HANDLE = 11294208

STMT_HANDLE = 11289096

INSERT INTO PARTNERINFO(

ID, /*PK*/

FIRST_NAME,

MIDDLE_NAME,

LAST_NAME,

ADDR1,

ADDR2,

CITY,

STATE,

ZIP,

HOME_PHONE,

WORK_PHONE,

NOTES,

PRAYER_DAY,

ACTIVE_,

EMAIL_ADDRESS,

EMAIL2,

FAX_NUMBER,

BIRTHDATE,

MAILING_LIST_ONLY,

MINISTER,

LOGIN_NAME)

VALUES (

? /* ID */ ,

? /* FIRST_NAME */ ,

? /* MIDDLE_NAME */ ,

? /* LAST_NAME */ ,

? /* ADDR1 */ ,

? /* ADDR2 */ ,

? /* CITY */ ,

? /* STATE */ ,

? /* ZIP */ ,

? /* HOME_PHONE */ ,

? /* WORK_PHONE */ ,

? /* NOTES */ ,

? /* PRAYER_DAY */ ,

? /* ACTIVE_ */ ,

? /* EMAIL_ADDRESS */ ,

? /* EMAIL2 */ ,

? /* FAX_NUMBER */ ,

? /* BIRTHDATE */ ,

? /* MAILING_LIST_ONLY */ ,

? /* MINISTER */ ,

? /* LOGIN_NAME */ )

FIELDS = [ Version 1 SQLd 22 SQLn 30

PARTNERINFO.ID = <NIL>

PARTNERINFO.FIRST_NAME = <NIL>

PARTNERINFO.MIDDLE_NAME = <NIL>

PARTNERINFO.LAST_NAME = <NIL>

PARTNERINFO.ADDR1 = <NIL>

PARTNERINFO.ADDR2 = <NIL>

PARTNERINFO.CITY[CITY] = <NIL>

PARTNERINFO.STATE = <NIL>

PARTNERINFO.ZIP = <NIL>

PARTNERINFO.HOME_PHONE = <NIL>

PARTNERINFO.WORK_PHONE = <NIL>

PARTNERINFO.NOTES = <NIL>

PARTNERINFO.PRAYER_DAY = <NIL>

PARTNERINFO.ACTIVE_ = <NIL>

PARTNERINFO.EMAIL_ADDRESS = <NIL>

PARTNERINFO.EMAIL2 = <NIL>

PARTNERINFO.FAX_NUMBER = <NIL>

PARTNERINFO.BIRTHDATE = <NIL>

PARTNERINFO.MAILING_LIST_ONLY = <NIL>

PARTNERINFO.MINISTER = <NIL>

PARTNERINFO.LOGIN_NAME = <NIL>

[MEMBER_NAME] = <NIL> ]

SECONDS = 0.010

ERRCODE = 335544352

----*/

/*---

[ 1/19/2002 4:54:23 PM ]

INTERPRETE BUFFER = * EMAIL2 */ ,

? /* FAX_NUMBER */ ,

? P�

ERRCODE = 58

----*/

/*---

[ 1/19/2002 4:54:23 PM ]

INTERPRETE BUFFER = no permission for insert/write access to table
PARTNERINFO

ERRCODE = -1

----*/

/*===

[ 1/19/2002 4:54:23 PM ]

//>>> ERROR <<<//

ISC ERROR CODE:335544352

ISC ERROR MESSAGE:

no permission for insert/write access to table PARTNERINFO

STATEMENT:

TIB_Statement:
"<TApplication>.dmRReq.ibqAllPartnerInfo.<TIB_UpdateSQL>.<TIB_Statement>."
stHandle=11289096 (ERROR)



STATEMENT:

TIB_Query: "<TApplication>.dmRReq.ibqAllPartnerInfo." stHandle=11297460
(ERROR)

//>>> SQL MESSAGE <<<//

SQL ERROR CODE:-551

SQL ERROR MESSAGE:

This user does not have privilege to perform this operation on this object.

//>>> SQL <<<//

INSERT INTO PARTNERINFO(

ID, /*PK*/

FIRST_NAME,

MIDDLE_NAME,

LAST_NAME,

ADDR1,

ADDR2,

CITY,

STATE,

ZIP,

HOME_PHONE,

WORK_PHONE,

NOTES,

PRAYER_DAY,

ACTIVE_,

EMAIL_ADDRESS,

EMAIL2,

FAX_NUMBER,

BIRTHDATE,

MAILING_LIST_ONLY,

MINISTER,

LOGIN_NAME)

VALUES (

? /* ID */ ,

? /* FIRST_NAME */ ,

? /* MIDDLE_NAME */ ,

? /* LAST_NAME */ ,

? /* ADDR1 */ ,

? /* ADDR2 */ ,

? /* CITY */ ,

? /* STATE */ ,

? /* ZIP */ ,

? /* HOME_PHONE */ ,

? /* WORK_PHONE */ ,

? /* NOTES */ ,

? /* PRAYER_DAY */ ,

? /* ACTIVE_ */ ,

? /* EMAIL_ADDRESS */ ,

? /* EMAIL2 */ ,

? /* FAX_NUMBER */ ,

? /* BIRTHDATE */ ,

? /* MAILING_LIST_ONLY */ ,

? /* MINISTER */ ,

? /* LOGIN_NAME */ )

SELECT P1.*,

Last_name||', '||First_name as Member_Name

FROM PARTNERINFO P1

Where Active_ = 'Y'

ORDER BY Prayer_day ASC

====*/