HI Kevin Acorace

How are you invoking this script? 

Set oCountry = oSession.AsObject(oBusObj.GetChildHandle("CountryCode"))

The above should be the proper syntax, assuming there is a child collection called CountryCode.  You can get a list of the data sources by doing something like:

msgbox oBusObj.GetDataSources() ' this should put a list in your message box.

The second thing I noticed is that the value you are getting from the country table is different.

retVal = oCountry.Find(CountryCode)

retVal = oCountry.GetValue("AlternateCountryCode$", AltCountryCode) ' remember the "$" for string values

Hope that helps, not sure where you are getting the error 88!

Elliott

I wanted to test seeing the list of data sources, so I added this to my code and it froze and I didn't see a message box on the client or the server.  Not sure why it didn't work.  Any ideas?

msgbox oBusObj.GetDataSources() 

Thanks,

Kevin

Never use msgbox for Advanced / Premium.  It won't work.  Try this:

retVal = oSession.AsObject(oSession.UI).MessageBox("", oBusObj.GetDataSources() )

Can anyone let me know what I am doing wrong with the GetChildHandle code below with the script above?

Thanks, everyone for responding!  Well, I confirmed that CountryCode is in the list but I still couldn't get the GetChildHandle to work.

It would be great to figure out what I'm doing wrong for the future, but I did get this working using GetObject.

This worked:

oCountry = oSession.GetObject("SY_Country_BUS")

and this doesn't:

set oCountry = oBusObj.AsObject(oBusObj.GetChildHandle("CountryCode"))

Thanks again!

Kevin

Can anyone let me know what I am doing wrong with the GetChildHandle code below with the script above?

Thanks, everyone for responding!  Well, I confirmed that CountryCode is in the list but I still couldn't get the GetChildHandle to work.

It would be great to figure out what I'm doing wrong for the future, but I did get this working using GetObject.

This worked:

oCountry = oSession.GetObject("SY_Country_BUS")

and this doesn't:

set oCountry = oBusObj.AsObject(oBusObj.GetChildHandle("CountryCode"))

Thanks again!

Kevin

Set oCountry = oSession.AsObject(oBusObj.GetChildHandle("CountryCode"))

Thanks for the response!  Using that still gets me this error:

Thanks for the screenshot and response, but I still can't get past that set line.  I have a debug message line right after and the error comes before that message line.  My set line is exactly like yours Kevin M.  I appreciate you taking the time to respond, but I'm stumped.  I think I might just go with what is working, and not spend any more time on this.  Thanks all!!