Hello,
This is a big time FDS newbie question.
I have developed my first Flex2 app using RemoteObjects to
ColdFusion. I'm satisfied but I now understand how FDS could help
me better (mainly in the sync/conflict area).
But there is something, I'm sure quite easy, that stumps me
when I study FDS. How to use data relationships. Let me give you
and example:
A datagrid contains
Order_No Customer_Name Warehouse_Name Date Total
------------- -----------------------
-------------------------- -------- --------
The customer_name comes from the Customer table where
Order.No_Customer = Customer.No_Customer. Same concept for
Warehouse name.
I understand that I can use LabelFunction to get the name but
I am not convinced that returning to the database a hundred times
to get each customer and warehouse name is wise. (I may be wrong).
In my RemoteObjet application I prepared a SQL query in a CFC
to pre-prepare the data to fill the grid and load the order as per
the order_no column.
If I run such a query in FDS (if possible) I will loose the
fiil/sync capabilities I want to use, at least I think.
But how can I accomplish that in FDS ?? In other
language/technologies (read WebObjects) I could use "Pathing" like
order.toClient().name. Is there something like that in Flex/FDS ?
Our database is pretty well layed out from a relational
standpoint. So solving this issue will help me a lot.
Thanks
Steve