Hi JP,
Thanks for your response.
Actually I hardcoded the values so that all the fields will be non-blank.
I used the same way, how the dbget routine has returned the values. Even
after doing like that, the dbupdate has failed.
Once again I confirm the fact that I have provided the values for all the
elements in that array.
Please let me know if you have any more suggesstions with regard to this
issue.
Thanks & Regards,
Pavan Kumar
On Wed, 26 Jul 2006 07:56:46 +1000, john pitman <[log in to unmask]>
wrote:
>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 *
>========================================================================
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
