Sample for querying data from related tables in GeoDataServer

[sidneykelvin]

I've got a non-spatial database with related tables published in the ArcService GeoDataServer. Can anybody please give me samples on how to query on those tables in Actionscript.

Thanks in advance.

[DasaPaddock]

Here's a sample that uses the FeatureLayer.
http://help.arcgis.com/en/webapi/flex/samples/index.html?sample=FeatureLayerQueryRelated
http://help.arcgis.com/en/webapi/flex/apiref/com/esri/ags/layers/FeatureLayer.html#queryRelatedFeatu...

You can also use a QueryTask:
http://help.arcgis.com/en/webapi/flex/apiref/com/esri/ags/tasks/QueryTask.html#executeRelationshipQu...

[sidneykelvin]

dpaddock,

Thank you so much in your valuable advice. I didn't know that a related table can be viewed in the MapServer. In the Web service I published I couldn't view the related table. Can I do it in ArcGIS Server 9.3.1.3000 with mxd created in ArcMap 9.3.1? If yes, please advise what have I done wrong.

If no, I'm trying to work around and putting the tables in the Geodata Server, so can you advise me on samples to retrieve data in the Geodata Server?

Btw, I'm using Flex 3.0, can I make use of similar script from the sample?


Thanks again

[DasaPaddock]

Querying related records via the ArcGIS REST API requires ArcGIS Server 10:
http://sampleserver3.arcgisonline.com/ArcGIS/SDK/REST/queryrelatedrecords.html

You can call a custom server side script to access your data. It can be implemented in any technology you're comfortable with. Here's a discussion on some of the options available:
http://livedocs.adobe.com/flex/3/html/Part4_data_access_1.html

[sidneykelvin]

dpaddock,

I need to work on the matter on ArcGIS Server 9.3.1.3000 and therefore I found the calling for a custom server side script more likely to solve my problem.

However, when I look into the part "Calling HTTP services in ActionScript", I got no idea in making query using the HTTP service.

Can you give samples in this?

Thanks

[DasaPaddock]

Here's a sample from the old forum:
http://forums.esri.com/Thread.asp?c=158&f=2421&t=297646

Here's some generic samples:
http://blog.flexexamples.com/category/httpservice/