Eclipse Community Forums: EGL Development Tools » How do I know if a GET succeeded in fetching the record?

Help

Home

Home » Archived » EGL Development Tools » How do I know if a GET succeeded in fetching the record?

Show: Today's Messages :: Show Polls :: Message Navigator

How do I know if a GET succeeded in fetching the record? [message #811661]

Fri, 02 March 2012 17:04

Daniel Rippa

Messages: 10
Registered: March 2012

Junior Member

I'm posting some code to make my point, but it's really a more general question.

function fetchSomeField(someOtherRecordID bigInt) returns (Timestamp?)
  someRecord1 SOMERECORD;
  get someRecord1 from ds using (someOtherRecordID) with #sql{
    select * from someTable where OTHERRECORD_ID = ?
  };
  if (someRecord1 != null) <-- Fails, it's not null, even though such record doesn't exist 
    return (someRecord1.timestampField1);
  else
    return (null);
  end
end

How do I know if the GET action did actually fetch a record or not?

Report message to a moderator

Re: How do I know if a GET succeeded in fetching the record? [message #811740 is a reply to message #811661]

Fri, 02 March 2012 19:18

Daniel Rippa

Messages: 10
Registered: March 2012

Junior Member

In the meanwhile, I'm using this:

function fetchSomeField(someOtherRecordID bigInt) returns (Timestamp?)
  someRecord1 SOMERECORD;
  rs SQLResultSet?;
  open rs from ds using(someOtherRecordID) with #sql{
    select * from someTable where OTHERRECORD_ID = ?
  };
  if (rs.setNext())
    get someRecord1 from rs;
    return (someRecord1.timestampField1);
  else
    return (null);
  end
end

It looks quite right actually! Smile

Report message to a moderator

Re: How do I know if a GET succeeded in fetching the record? [message #812398 is a reply to message #811661]

Sat, 03 March 2012 19:04

Joseph Vincens

Messages: 31
Registered: December 2011
Location: Prospect CT

Member

Hi

The first code you wrote was almost correct. You are checking someRecord1 for null, but you did not define it as nullable. Without a ? the initial value is an empty record and you can't even assign null to it.

someRecord1 SOMERECORD;
should be:
someRecord1 SOMERECORD?;

Adding the ? to the declaration sets someRecord1's initial value to null. If no record is returned from the get it will remain null.

The second example accomplishes the same thing.

regards,
Joe

Report message to a moderator