Re: PLEASE PLEASE PLEASE Help Me!!!

On Wed, 23 Nov 1994 tech@compsys.demon.co.uk wrote: } This one has got me baffled - can anybody please help me ... } } Is there any way of assigning a NULL value to part of a column value ? } long. } } initialize null_field to null } let recordname.keyfield = "1234", null_field } } but this makes no difference. I have also tried adding a NULL record } } The reason I need to do this is because I am writing some software which } integrates with another 3rd party package. This 'other' package recognises } record locks by assigning the last 24 characters of the keyfield to NULL. } Although I can check for this using SQL similar to: } } select keyfield from table } where keyfield[1,4] = "1234" } and keyfield[5,28] is null } } I cannot seem to use 4GL code to make similar locks which would be } recognised by the 'other' package. } } Keith. } *************** tech@compsys.demon.co.uk *************** } Tel: 044 (0)1482 803961 Fax: 044 (0)1482 804333 } ******************************************************** Keith, [FMI], forgive my ignorance, but can you take a new tack & give up the notion of concatenating a null to the end of the field (assuming the 3d party pkg knows your kind of null). Try instead creating a file or even a small table for use as a semaphore, & inserting keys for locked records. Just an idear :-) ********************************* Nick Nobbe, Library of Congress NLS/BPH Off: (202) 707-0548 Fax: (202) 707-0711 mail: nnob@loc.gov *********************************