Prices table usage

Robin Chattopadhyay robinraymn at gmail.com
Thu Aug 27 08:21:34 EDT 2009


I don't think that's right. When I look, I see that the accounts table has a
commodity_guid field. That's the field I would use to join the prices to the
accounts to avoid name conflicts. The fullname field is independent of the
account(s) that the commodity is tied to.

On Thu, Aug 27, 2009 at 4:17 AM, Colin Law <clanlaw at googlemail.com> wrote:

> Hi
>
> A question on the prices table usage.  Is this correct?
> The prices table has a field commodity_guid that links to a commodity.
> The commodity linked to has a field fullname that contains the name of
> the account that this is the price for.
>
> So to find the prices for a given fund account I have to lookup the
> prices where the fullname of the linked commodity matches the name of
> the account.
>
> Am I missing something or is that right?
>
> What would happen if I had two accounts with the same name (with
> different parents obviously).
>
> Colin L
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


More information about the gnucash-user mailing list