RE: Null-capable field passed by reference to subprocedure

["McCallion, Martin" <martin.mccallion@xxxxxxxxx>]

Thanks for everyone's responses.

Martin Hillier wrote:
> Do you have the H - spec ALWNULL(*USRCTL) (Or the compilation
> option, but I
> recommend sticking it in the H Spec)?

Yes, thanks; it wouldn't even compile without that.

Hans Boldt wrote:
> You've just encountered a limitation of null-capable fields.
> The "null" flag is an attribute of a database field only,
<snip>

That's what I feared.

David Morris wrote:
> One solution would be to write a database wrapper/shell/server,
> whatever you want to call it for each database file. Then provide
> a generic procedure setNull(fieldname). That module would also
> support various get record procedures etc.  I usually write an
> abstraction layer (Mediator) that calls file specific module routines,
<snip>

That sounds interesting, but is much more than I need at present.  I was
just doing a small fix to a small application -- and I only had to do it
at all because we had to redesign the DB to work around a bug in the
Client Access ODBC driver.  But that's another story.

Thanks again.

Cheers,

Martin.

--
Martin McCallion
Senior Technical Consultant
Work:  martin.mccallion@misys.com
Home: martin.mccallion@ukonline.co.uk
Misys International Banking Systems
1 St George's Road, London, SW19 4DR, UK
T +44 (0)20 8486 1951
F +44 (0) 20 8947 3373
www.misys.com
This email message is intended for the named recipient only. It may be
privileged and/or confidential. If you are not the  intended named
recipient of this email then you should not  copy it or use it for any
purpose, nor disclose its contents to any other person. You should
contact Misys International Banking Systems as shown below so that we
can take appropriate action at no cost to yourself.
Misys International Banking Systems Ltd,1 St
George's Road, London, SW19 4DR, UK. Email: ibs.postmaster@misys.com.
Tel: +44 (0) 20 8879 1188 Fax: +44 (0) 20 8947 3373
Misys International Banking Systems Ltd is
registered in England and Wales under company no. 971479