What you are looking for does not probably require setDynamicCriteriaStr.
You could contruct the query in the studio itself.
select * from tbl where dt = (select max(dt) from tbl)
Robin Karatra
> -----Original Message-----
> From: Rimma [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, July 27, 1999 1:47 PM
> To: [EMAIL PROTECTED]
> Subject: [ND] Need to get the LAST inserted record from the database
>
>
> Hello,
> I have a problem which is probably going to be easy to solve for most of
> you.
>
> I have a Query DataObject and I need to get a record which was inserted
> the last. The
> primary key for that record will be Date field, so, I guess, it's easier
> to say that I need
> to get a record with the last date inserted (the most recent Date
> inserted).
> I understand that I have to set up some dynamic criteria for that, but I
> don't understand
> how to do that. Is there a method that I can use?
>
> Could anybody help me? Thanks in advance for your help,
> Rimma
> _________________________________________________________________________
>
> For help in using, subscribing, and unsubscribing to the discussion
> forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
>
> For dire need help, email: [EMAIL PROTECTED]
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
