StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » How do I trap for no records found?

How do I trap for no records found?

StarkMike — Tue, 29 Aug 2006 10:54:34 GMT

If I attempt to fill a BO and the critera I used returns zero records.... how do I handle that gracefully? Right now I get an error: "Cannont convert "" to integer".

Thanks

RE: How do I trap for no records found?

Trent L. Taylor — Tue, 29 Aug 2006 10:54:34 GMT

All you need to do is attempt to populate before you call the Requery method of the ListView. This way the ListPopulating event will never even be called and the list will not attempt to re-populate. One thing that you will probably want to do is set the PopulateOnFormLoad to manual which means the list will not populate unless you call the Requery method of the ListVIew.

RE: How do I trap for no records found?

StarkMike — Tue, 29 Aug 2006 07:46:08 GMT

Is there a way I can cancel the ListPopulating event if my primary business object returned zero rows?

RE: How do I trap for no records found?

Trent L. Taylor — Mon, 28 Aug 2006 20:32:41 GMT

Let me know if you have any questions. We may not have 2 minute responses since we are out of town, but we are keeping on top of the forum :)

RE: How do I trap for no records found?

StarkMike — Mon, 28 Aug 2006 20:29:25 GMT

I'm filling the busines object using Me.FillDataTable(cmd). I'll check it out in the morning. Thanks

RE: How do I trap for no records found?

Trent L. Taylor — Mon, 28 Aug 2006 17:34:30 GMT

It depends on how you are filling the business object. All binding logic already takes this into account so basic StrataFrame binding will not generate this error since we remove the binding when there are no records. But you can use teh CurrentDataTableRefilled method and then look at the Count property of the BO.