Pavan,
As others suggested, print the record with hex option, so you see what the .
are underneath - I suspect they will be nulls (x'00').
You MUST get a map of how php sees the image record layout, USING WHATEVER
is php's equivalent of the image FORM command. In image to address a
member of an arrayed item (in Query), it is referred to as
<item-name>(subscript). When you read such an item in Image by using its
item name, you get back ALL the members of the array. If in PHP you are ONLY
loading the first occurrence, then nulls in all the other members makes
sense. Does your php code refer to ALL members, ie subscripts 1-20??
jp
-----Original Message-----
From: Pavan_Kumar [mailto:[log in to unmask]]
Sent: Wednesday, 26 July 2006 6:13 AM
To: HP3000 List; John Pitman
Cc: Pavan Kumar
Subject: Re: Need help on PHP for MPE/ix
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 20
x2
>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 fil
e
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 Beha
lf
>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 *
|
