Hi,
qbds1 = q1.addDataSource(tableNum(TableName));
qbds1.addRange(fieldNum(TableName,Date)).value((strFmt(’((Date >= %1) && (Date <= %2))’, date2StrXpp(frmdt),date2StrXpp(todt))));
I didn’t get any data related to my query datasource. What is problem in my above code?Please help me.
Thanks in Advance
Nimisha Patel
hi ,
use this instead of adddatasource method i think it will workout…[:)]
qbds1=q1.dataSourceName(identifierstr(tablename));
Thank you very much for your quick support. It’s working very good as per our requirement.
Regards,
Nimisha Patel
Hi,
You said to use identifierstr …it’s working great…but I can’t fetch data in datewise. I send my code like
Hi,
qbds2=q.dataSourceName(identifierstr(TableName));
qbds2.addRange(fieldNum(TableName,Date)).value((strFmt(’((Date >= %1) && (Date <= %2))’, date2StrXpp(frmdt),date2StrXpp(todt))));
queryRun1 = new QueryRun(q);
while(queryRun1.next())
{
TableName1= queryRun1.get(tablenum(TableName)); }
Not getting data using this code.
Please hepl me asap.
Regards,
Nimisha Patel
try this and lemme know…
as far ur range statement to retrieve date is concerned i dont think there s anything wrong with it…
qbds2=q.dataSourceName(identifierstr(TableName));
qbds2.addRange(fieldNum(TableName,Date)).value((strFmt(’((Date >= %1) && (Date <= %2))’, date2StrXpp(frmdt),date2StrXpp(todt))));
queryRun1 = new QueryRun(q);
queryrun1.reset();
while(queryRun1.next())
{
TableName1= queryRun1.get(tablenum(TableName)); }
Hi Nimisha ,
You can use the QueryRange method instead of using .value method.
As you can see in the below code…
qbds1.addRange(fieldNum(TableName,Date)).value(queryRange(From, To));
I think this will work fine…
Regards,
Janak Talekar
Thank you for your suggestion…it’s work fine…