No , that one I don't have control over. but with the
view of common numbers, I should be able to export
only the items and columns that i need to update in
the inventory file.
Josh Berkus wrote:
>
> David,
>
> > > > > 1) Is there any way you can easily identify the relevant rows in the
> > > legacy
> > > > > database and export only those?
> >
> > I guess I'm unclear as to which table you are
> > referring to as the LEGACY table. either way i
> > imagine that by looking at a table or VIEW of the pik
> > numbers common to both tables is what i need, so yes I
> > can get that. in fact i have now. but how can i use
> > that table to update the price fields in inventory
>
> No, I'm talking about the database system that is exporting to text. Can you
> tell it to export only the rows you need?
>
> --
> -Josh Berkus
> Aglio Database Solutions
> San Francisco