Hi Rene,
Thank for ur reply ....the above issue was solved due to datatype problem...
Now i hv another issue..
I doing upgrade from v3.10 to v4SP3. I hit an error while i trying to import the customized object(that i merged previously)
When system trying to import Table 97(Comment Line) The error msg prompted
"The change in the primary key definition has resulted in two records with the same primary key value.
The primary key is the first key in the list of keys
Table: Comment Line
Company: GBerg
Record: Table Name='Loan Application', No.='SHEL-973017',No. 2='',Line No.='10000'
And i noted in my Comment Line table i only hv 2 records with Line NO. = 10000 which are:
Table Name No. No. 2 Line No. Date Code Comment User ID Locked
Loan Application SHEL-973017 '' 10000 09/21/04 Member deceased.
Loan Application SHEL-973017 00005709 10000 01/18/06 add. as per ic search dated 15/1205 LSC No
and my primary keys = Table Name,No.,No. 2,Line No.
But the system seem like treated my primary as "Table Name,No. and Line No." which ignore the "No. 2" that i specified as part of my
primary key
AND when i open cronus db with v4SP3 i noted the primary for Comment Line table is "Table Name,No.,Line No."instead of Table Name,No.,No. 2,Line No.
Help ..any idea to solve this ?? i stuck the upgrade process bcoz of tis "Comment Line"