You can -
1. set the dynamic criteria using:
addDynamicCriterion(...,...) //check the docs
2. send the complete SQl using:
yourDataObject.addDynamicStrCriterion(CSpCriteriaSQLObject.QBE_CRITERIA_TYPE,"SQL_String");
--Vishal
"Rimma" <[EMAIL PROTECTED]> wrote:
>
>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]
