Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!uunet!cti1!kmeek
From: kmeek@cti1.UUCP (Kevin Meek)
Newsgroups: comp.databases
Subject: UNIFY RPT bug concatenating strings
Keywords: UNIFY
Message-ID: <321@cti1.UUCP>
Date: 19 Nov 90 19:21:14 GMT
Organization: Comprehensive Technologies Int., Arlington VA
Lines: 53

I have come accross a interesting little bug (feature??) in RPT

When concatenating strings together if any of the fields in the input
are null then resulting output string is set to null as well.

For example.

with input section like the following 

input
   fname [string 2],
   lname [string 4],
   room [string 3]


And Data like the following 

John|Smith|100
John|Smith|
John||103
|Smith|102


the following set statement will set result_str to null for all
but the first line of input.

  set result_str to fname + lname + room


Basically If any of the variables are null when concatenating strings
the result will be null as well.


I am using RPT that came with Accell/IDS for our 3B2/600
The output of RPT -version is below

Database Version: 34
Revision:         1.1.1.4.8
Nap Option:       POLL
Machine:          ATT 3B2
Operating System: att600g 3.2.2 3 3B2
(SM:22 DB:1 CM:10 FM:26 LM:17 TM:16 CL:3)


If anyone else has this problem maybe this should be forwarded to unify
via the bug mailing list.

---
Kevin Meek    
kmeek@cti.com
-- 
Kevin Meek 
kmeek@cti.com