Pavan:
I really wanted Hex format, sorry.
Olav.
Pavan_Kumar wrote:
>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 *
>
>
>
>
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|