[SQL/VAPP] Problems with field recid

[Ruslan Zasukhin]

On 10/26/04 3:08 PM, "Klamp, Kurt" <Kurt.Klamp at abdnb.bayern.de> wrote:

Hi Kurt,
 
> 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.

I believe that Valentina 1.x still is not able to sort on RecID field.
(workaround is to use ULONG method = "RecID")

GROUP BY use sorting, so I think this is the same problem.

Yes you can use ObjectPtr field.

Is this solution for you ?


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------