Subject | error Singleton |
---|---|
Author | Dion |
Post date | 2001-09-10T12:56:05Z |
Hi all,
When posting edits on a record in the detail table, I get the following error:-
ServerSQL
'SELECT PERSONID , OPTIONNAME'#$D#$A' , FUNDNO , GROUPNAME , MARKETERID, DOI
FROM MEMBERINFUND m'#$D#$A'WHERE PERSONID=? /* BIND_0 */ '#$D#$A' AND FUNDNO=? /* BIND_1 */ '#$D#$A' AND OPTIONNAME=? /* BIND_2 */ FOR UPDATE
My SQL for the Detail table is as follows:-
SELECT
PERSONID
, OPTIONNAME
, FUNDNO
, GROUPNAME
, MARKETERID
, DOI
FROM MEMBERINFUND m
WHERE m.PERSONID = :APERSONID
Please shed some light...
Thanks,
Dion.
[Non-text portions of this message have been removed]
When posting edits on a record in the detail table, I get the following error:-
ServerSQL
'SELECT PERSONID , OPTIONNAME'#$D#$A' , FUNDNO , GROUPNAME , MARKETERID, DOI
FROM MEMBERINFUND m'#$D#$A'WHERE PERSONID=? /* BIND_0 */ '#$D#$A' AND FUNDNO=? /* BIND_1 */ '#$D#$A' AND OPTIONNAME=? /* BIND_2 */ FOR UPDATE
My SQL for the Detail table is as follows:-
SELECT
PERSONID
, OPTIONNAME
, FUNDNO
, GROUPNAME
, MARKETERID
, DOI
FROM MEMBERINFUND m
WHERE m.PERSONID = :APERSONID
Please shed some light...
Thanks,
Dion.
[Non-text portions of this message have been removed]