Request to help me for checking the Direct Discovery Functionlty in 11.20

[#1]

Hi Forums,

I had QV Desktop version 11.20.11643.0 IR. I am not able to see the functionalty of Direct Discovery.

I had written the following script in script editor as follows and saved:-

OLEDB

CONNECT32 TO [Provider=SQLOLEDB.1;Persist Security Info=True;User ID=sales_user;Initial Catalog=test_xxxx;Data Source=xxxxdev01;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=shandar;Use Encryption for Data=False;Tag with column collation when possible=False] (XPassword is xxxxxx);
SET DirectCacheSeconds=5;

tab1:
Direct (Stale After 5 seconds) select xxxName from xxxshantab;

And In sheet I had taken list box field/column xxxName.

Observtion: First time when I reloaded it show only 9 rows in the xxxName List Box.

But, when I add one more record at xxxshantab Table in column xxxName. The New records insert as 'newxxx'.

Now as per the functionlty without reloading it suppose to show all 10 rows/records including the new records which I had inserted in the Tables after 5 Second right?. But It is not showing.

Can anybody show where I am wrong?.

Advance Thanks

SD