[SQL/VAPP] Problems with field recid

[Klamp, Kurt]

Hi Ruslan,

since migration to OSX i have trouble with some sql statements which worked
before. Don't know wether it is a VAPP issue (always 1.10) or  an Mac OS
one.

This sql's lead to an error:
'Not uniqe field name' ??? 

SELECT Investments.**, Investments.Recid,count(InvBuchungen.InvPtr) FROM
Investments,InvBuchungen GROUP BY Investments.InvDepotNr 

SELECT Investments.recid, Investments.InvName, Investments.InvInhaber,
count(InvBuchungen.InvPtr) FROM Investments,InvBuchungen  GROUP BY
InvBuchungen.InvPtr

This similar statement works:

SELECT Investments.InvName, Investments.InvInhaber,
count(InvBuchungen.InvPtr) FROM Investments,InvBuchungen  GROUP BY
InvBuchungen.InvPtr 

If i replace the GROUP BY part with 'Investments.recid' which must leads to
the same result i get the error again. The 2 tables (Investments := One
Table ; InvBuchungen := Many Table) are linked with objPtr where
Investments.recid=InvBuchungen.InvPtr. I want to get some basic info from
One  Table together with the number of related records in Many Table.

In general i assume that there are problems with the field 'recid' eiter as
part of the selected fields or as direct or indirect part of the group by
statement.

Kurt
###########################################

This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.F-Secure.com/