"weeble" <webforumsuser@macromedia.com> wrote in message
news:c7g2bt$dh5$1@forums.macromedia.com...
> I'm trying to develop a basic database manager using Remoting/CF/ODBC
(access).
> And have a basic application working fine on a small, flat file db,
allowing me
> to ADD, EDIT, DELETE records. I've used textArea instances bound to the
> dataset to view and enter the field data
>
> However I now want to apply this to a much larger relational database and
> include an option to edit the related tables etc. I have no problems with
the
> CFC SQL call, and can pull-in all the data I need into a dataset and bind
it to
> other components as necessary. The problem is that I now have potentially
70-80
> fields related to each record and unless I instantiate ALL the textAreas
on the
> first frame I am unable to bind them to the dataset. This, of course is
not
> practicable due to the lack of space on the stage. What I'd really like to
do
> is have a half dozen or so frames in the movie, each one dealing with a
> particular data aspect and navigate between the frames as required.
>
> Is there a "cheat" way of binding the textAreas to the dataset from
within the
> movie -- i.e. almost like "refreshing" the dataset. Or is there some
other way
> of achieving my target. I did manage almost to do what I wanted using
dynamic
> text fields linked to the dataset's "currentItem" property:
>
> e.g. z_number_txt.text = ds.currentItem.z_number;
>
> but I couldn't manage to get the resolver to work with this to update the
> database!
>
> Baffled............................... mike
>