sequence problem

[Peter Bateman]

Harold:

The database definition in the PowerHouse dictionary should explicitly
say NULLS ALLOWED otherwise PowerHouse will fill with default initial 
values. i.e. BLANKS for character strings, 0 for numbers.
Regards,
Peter Bateman






>From: "Johnson, Harold A EDUC:EX" <Harold.A.Johnson@gems1.gov.bc.ca>
>To: powerh-l@lists.swau.edu
>Subject: sequence problem
>Date: Tue, 25 Feb 2003 15:33:37 -0800
>
>Hi all.   When trying to add a record to an Oracle table from VMS using
>Powerhouse, the auto generation using sequence values for a primary key
>doesn't work; however, it works when using SQLPLUS from VMS.  Any ideas?
>
>The trigger on the Oracle table is:
>
>...
>BEGIN
>     IF (operation = 'INS') THEN
>         BEGIN
>			IF (cg$ind.ADRTYP_ID = FALSE OR cg$rec.ADRTYP_ID is
>NULL) THEN
>				SELECT ITS_SURROGATE_KEY_SEQ.nextval
>				INTO   cg$rec.ADRTYP_ID
>				FROM   DUAL;
>				cg$ind.ADRTYP_ID := TRUE;
>			END IF;
>         EXCEPTION WHEN OTHERS THEN
>...
>
>
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l@lists.swau.edu
>Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
>Unsubscribe: "unsubscribe" in message body to 
>powerh-l-request@lists.swau.edu
>http://lists.swau.edu/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.


_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.  
http://join.msn.com/?page=features/virus