Hi JP,
Thanks for your valuable suggesstion.
First I retrieved the record from the database. I used the same format to
insert the value or to update the values to the same dataset in the same
database. But still it is failing.
I have ran the fcopy command that you have suggessted. I got the below
output:
***************************************************************************
PAVAN,PAVAN.MSI2(150):query
HP32216D.03.21 QUERY/NM TUE, JUL 25, 2006, 10:51 AM
COPYRIGHT HEWLETT-PACKARD CO. 1976
>assign lockoption=off
>data-base=libdb.database
PASSWORD = >>
MODE = >>5
>f itm-item-no eq "1404-4000"
1 ENTRIES QUALIFIED
>save queryout
>e
PAVAN,PAVAN.MSI2(150):listf quer@
FILENAME
QUERYOUT
PAVAN,PAVAN.MSI2(150):fcopy from=queryout;to=;char
HP31900A.05.04 FILE COPIER (C) HEWLETT-PACKARD CO. 1999
QUERYOUT RECORD 0 (%0, #0)
00000: 1404-4000
00044: ......................
....
00110: ..............20 ............................................
....
00154: SAME: TO 000264-1
00264: ..................5 ................ 3 ........
3 ....
00330: SAME: TO 000332-1
EOF FOUND IN FROMFILE AFTER RECORD 0
1 RECORD PROCESSED *** 0 ERRORS
END OF SUBSYSTEM
***************************************************************************
I could not make out any thing from the above output.
I have been trying to resolve this problem from a long time. If you have
any suggesstions please let me know. If you need any thing from my side,
please let me know.
Thanks again.
Regards,
Pavan Kumar
On Mon, 24 Jul 2006 08:14:25 +1000, john pitman <[log in to unmask]>
wrote:
>Is it safe to assume that your data layout matches the record layout ,
based
>on 16 bit boundaries, NOT 32 bit alignments? And that the array field 20x2
>is a continuous string of 40 chars? PHP (or whatever code you build the
>buffer in )doesn't layout arrays in any odd fashion does it? If you ARE
>updating an existing record UPDATE is correct, to add a NEW record, PUT is
>correct.
>
>If you find a record in Query and SAVE <filename> it, then fcopy the file
as
>in
>Fcopy from=file;to=;char
>You will see the record exactly as it exists in the database, excluding
>pointers of course. The buffer you are sending to Image should look
EXACTLY
>like this. Usually image returning a null value means that either you
loaded
>a null (x'0') in the first byte, or that your PUT did not include that
field
>in its item list, and Image inserted a null for you to fill out the
buffer.
>
>Hth
>jp
>
>-----Original Message-----
>From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On Behalf
>Of Pavan Kumar
>Sent: Saturday, 22 July 2006 3:19 AM
>To: [log in to unmask]
>Subject: [HP3000-L] Need help on PHP for MPE/ix
>
>Hi,
>
>I have a problem with updating the data in turboimage database through
>
>php. I am looking for some kind of help which will solve this problem.
>
>Here is the problem:
>
>We are using Turbo Image database on HP3000 system. I am providing one
>table(ITMMSTR) contents for reference
>
>**********************************************************************
>**
>***********************************************
>DATA BASE: LIBDB .DATABASE WED, JUL 19, 2006, 1:17 PM
>
>
>DATA BASE LANGUAGE ATTRIBUTE: NATIVE-3000
>
>
>SET NAME:
> ITMMSTR,MANUAL
>
> ITEMS:
> ITM-ITEM-NO, X10 <<KEY ITEM>>
> ITM-TITLE, X70
> ITM-GROUP-CODE, X4
> ITM-CAT-CODE, X2
> ITM-LEAD-NAME, X14
> ITM-LEAD-PHONE, X8
> ITM-ORG-NUMBER, X6
> ITM-BASEPLANE, X4
> ITM-BASELINE-CD, 20X2
> ITM-BASELINE-MDL, 20X10
> ITM-RELEASETYPE1, 5X4
> ITM-RELEASETYPE2, 5X4
> ITM-PLNG-GRPCD, X6
> ITM-PARTICIPANT, X6
> ITM-1ST-CUS-DBT, 3X4
> ITM-IWS-SECTION, X2
> ITM-SUB-CUS-DBT, 3X4
>
> CAPACITY: 40739 ENTRIES: 26845
>
>
>**********************************************************************
>**
>***************************************************
>
>I have developed a screen in html for allowing users to enter the
>values. At the bottom of the screen, there is button called update.
>After entering the data in the fields on the screen and clicking on
>the update button, it will call php code, which will try to update the
>
>data entered on the screen in the TurboImage database.
>
>Before updating I stored the values entered against the fields on the
>screen in to an array. When I use this array in the update call
>intrinsic(mpe_dbupdate), it is not throwing any errors but it updating
>
>"NULL ITEM" value for the arrays like ITM-BASELIN-CD field(marked in
>red above). Rest of the fields are updating properly.
>
>I guess I am doing something wrong and therefore it is not working
>properly.
>
>If any body have a solution for this problem, please let me know.
>
>Thanks & Regards,
>Pavan Kumar
>
>* To join/leave the list, search archives, change list settings, *
>* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>
>* To join/leave the list, search archives, change list settings, *
>* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>========================================================================
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|