Insert NULL value in Integer field through Progress 4GL

A

ashok

New Member
I am working on a progress add-on database in which records are created through Progress 4GL programs and accessed/processed by SQL-92 queries.

The requirement is that NULL values should be reflected in Integer data-type variables in case there are no explicit values to be inserted.
I tried changing the Initial value by removing the '0' and putting the '>>>>' display format, but when i take a export or access through "select" in SQL, the same is shown/stored as '0' (zero).

Please advise.

Thanks,
Ashok
 
Null

Greetings,

I am not too sure using the SQL platform, though basic Progress syntax may be applicable here. To null an interger var use '?' (a question mark) - without the quotes, I just used the quotes to show what were required. Example syntax would be the equivelant of, (PSC 4GL here)
ASSIGN
intVar = ?
.
 
Solved

Hi

I also tried yesterday the same '?' assignment later after the thread, but good that I got a confirmation for the same.

Thanks a lot..
 
You must log in or register to reply here.
Back
Top