Strange Behaviour of SetSearchSpec
Hi,
Here is the code:
SQL that is generated is below:
Can someone temme why the SearchSpec is not getting applied???
Regards,
Maggi.
Here is the code:
CSR = sActiveBO.GetBusComp("Contact SR Intersection BC");
with(CSR)
{
SetViewMode(AllView);
ActivateField("Contact Id");
ClearToQuery();
SetSearchSpec("Sr Id", "1-ABC");
ExecuteQuery(ForwardOnly);
sIsRecord1 = FirstRecord();
while(sIsRecord1 == true)
{
sContactId = GetFieldValue("Contact Id");
<DoSomething>
sIsRecord1 = NextRecord();
}
}
with(CSR)
{
SetViewMode(AllView);
ActivateField("Contact Id");
ClearToQuery();
SetSearchSpec("Sr Id", "1-ABC");
ExecuteQuery(ForwardOnly);
sIsRecord1 = FirstRecord();
while(sIsRecord1 == true)
{
sContactId = GetFieldValue("Contact Id");
<DoSomething>
sIsRecord1 = NextRecord();
}
}
SQL that is generated is below:
SELECT
T1.CONFLICT_ID,
T1.LAST_UPD,
T1.CREATED,
T1.LAST_UPD_BY,
T1.CREATED_BY,
T1.MODIFICATION_NUM,
T1.ROW_ID,
T1.CONTACT_ID
FROM
SIEBEL.S_SR_CONTACT T1
T1.CONFLICT_ID,
T1.LAST_UPD,
T1.CREATED,
T1.LAST_UPD_BY,
T1.CREATED_BY,
T1.MODIFICATION_NUM,
T1.ROW_ID,
T1.CONTACT_ID
FROM
SIEBEL.S_SR_CONTACT T1
Can someone temme why the SearchSpec is not getting applied???
Regards,
Maggi.
0