QUICK 8.40 G & BLOBS

[Bateman, Peter]

Hi Alan:

   I would try the SQL interface. i.e. define the database as RDB

RDB      -- accesses the database using a gateway which allows you create SQL cursors in PowerHouse.
versus
RDB/VMS  -- accesses the database directly.

Regards,
Peter Bateman

-----Original Message-----
From: powerh-l-bounces+peter.bateman=hpadvancedsolutions.com at lists.sowder.com [mailto:powerh-l-bounces+peter.bateman=hpadvancedsolutions.com at lists.sowder.com] On Behalf Of powerh-l-request at lists.sowder.com
Sent: Thursday, June 18, 2015 10:00 AM
To: powerh-l at lists.sowder.com
Subject: powerh-l Digest, Vol 115, Issue 6

Send powerh-l mailing list submissions to
	powerh-l at lists.sowder.com

To subscribe or unsubscribe via the World Wide Web, visit
	http://lists.sowder.com/mailman/listinfo/powerh-l
or, via email, send a message with subject or body 'help' to
	powerh-l-request at lists.sowder.com

You can reach the person managing the list at
	powerh-l-owner at lists.sowder.com

When replying, please edit your Subject line so it is more specific than "Re: Contents of powerh-l digest..."


Today's Topics:

   1. Run-time error on QUICK screen (Thurston, Alan R JTST:EX)


----------------------------------------------------------------------

Message: 1
Date: Wed, 17 Jun 2015 20:51:30 +0000
From: "Thurston, Alan R JTST:EX" <alan.thurston at gov.bc.ca>
Subject: Run-time error on QUICK screen
To: "'powerh-l at lists.sowder.com'" <powerh-l at lists.sowder.com>
Message-ID: <8b6d1d63fe0a46a384e01d7293aad91e at E3PMBX19.idir.BCGOV>
Content-Type: text/plain; charset="us-ascii"

I have a screen that includes a field defined in the database as a BLOB (actually LIST OF BYTE VARYING) The screen works in POWERHOUSE 710G1 running on ALPHA but fails when running ON Powerhouse 840G on ITANIUM

The error is:
%SYSTEM-F-ACCVIO, access violation, reason mask=04, virtual address=000000007ACC6000, PC=FFFFFFFF84236720, PS=0000001B

  Improperly handled condition, image exit forced by last chance handler.
    Signal arguments:   Number = 0000000000000005
                        Name   = 000000000000000C
                                 0000000000000004
                                 000000007ACC6000
                                 FFFFFFFF84236720
                                 000000000000001B

This is the source for the screen:

screen TU_LOCAL
FILE TU_LOCAL IN LRBDB
FIELD TU_LOCAL_ID OF TU_LOCAL REQUIRED NOCHANGE &
      NULL VALUE NOT ALLOWED LOOKUP NOTON TU_LOCAL FIELD TU_ID OF TU_LOCAL REQUIRED NOCHANGE NULL VALUE NOT ALLOWED FIELD CBR_ID OF TU_LOCAL REQUIRED NOCHANGE NULL VALUE NOT ALLOWED FIELD DEF_BU_DESC OF TU_LOCAL CHARACTER FOR 1,18 &
      NULL VALUE NOT ALLOWED
FIELD TU_OFF_TYPE OF TU_LOCAL NULL VALUE NOT ALLOWED FIELD TU_CONT_PERSON OF TU_LOCAL NULL VALUE NOT ALLOWED FIELD UPD_BY OF TU_LOCAL NULL VALUE NOT ALLOWED FIELD UPD_DTE OF TU_LOCAL NULL VALUE NOT ALLOWED BUILD

Any ideas why it works in 710G but not in 840G ?


Alan Thurston - Senior Software Developer - Information Systems Branch Ministry of Community, Sport and Cultural Development | Ministry of Jobs, Tourism, and Skills Training (and Responsible for Labour)

Phone: 250 387-0220 | Fax: 250 387-1590
3rd Floor, 800 Johnson Street, PO Box 9802 Stn Prov Govt, Victoria, BC V8W 9W1 P Please consider the environment before printing this e-mail

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20150617/dd2ea62b/attachment.html>

------------------------------

--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list: powerh-l at lists.sowder.com
Subscribe: &quot;subscribe&quot; in message body to powerh-l-request at lists.sowder.com
Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; in message body to powerh-l-request at lists.sowder.com http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the list archive at Google.

End of powerh-l Digest, Vol 115, Issue 6
****************************************