topic Retrieve values from Fields having numbers in Macro in Water Cooler

Retrieve values from Fields having numbers in Macro

Thu, 15 Mar 2012 09:40:14 GMT

I have a field of numeric userIds in my qvw document. I am not able to get the values of this field in the macro using

ActiveDocument.Fields("userId").GetPossibleValues().

Can somebody please let me know if I am missing something

Thanks and Regards

Ashwini

Retrieve values from Fields having numbers in Macro

CELAMBARASAN — Thu, 15 Mar 2012 09:50:09 GMT

Hi,

Check with this

set val=ActiveDocument.Fields("Month").GetPossibleValues

for i=0 to val.Count-1

msgbox(val.Item(i).Text)

Celambarasan

Retrieve values from Fields having numbers in Macro

Thu, 15 Mar 2012 09:58:48 GMT

Thanks for the reply. But this didnt work. Actually in my database the userId field have both strings and numerals. But i need just the numeric userIds. So in my load script i am loading only the userIds which are numeric in the filed userId

i.e

load if(isnum(userID),userID) as userId

resident userTable;

I am then trying to access the values of this field in macro and some how getting an error at

ActiveDocument.Fields("userId").GetPossibleValues()

Re: Retrieve values from Fields having numbers in Macro

CELAMBARASAN — Thu, 15 Mar 2012 10:02:30 GMT

Hi,

Check with this

set val=ActiveDocument.Fields("userId").GetPossibleValues

for i=0 to val.Count-1

msgbox(val.Item(i).Text)

Celambarasan

Re: Retrieve values from Fields having numbers in Macro

CELAMBARASAN — Thu, 15 Mar 2012 10:04:00 GMT

Hi,

What error you are getting?

Celambarasan

Retrieve values from Fields having numbers in Macro

Thu, 15 Mar 2012 10:13:29 GMT

I am not getting any error. when i run the macro it just stops at that line and does not execute further. I think the problem is that it is fetching a large data. The field userId has 437 userId in it. Is this the cause.. Can you suggest a way to handle this ?

Thanks

Ashwini