| Subject | Re: [IBO] Rights problem |
|---|---|
| Author | Don Gollahon |
| Post date | 2002-01-19T22:58:02Z |
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
====*/
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
====*/