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 *