[V4MD] get RecID from a long query

[info at vallemediatime.com]

Hi Ivan,

----- Original Message ----- 
From: "Ivan Smahin" <IvanSmahin at public.kherson.ua>
To: "Valentina Beta" <valentina-beta at lists.macserve.net>
Sent: Wednesday, November 02, 2005 9:44 AM
Subject: Re: [V4MD] get RecID from a long query


> Hello info,
> 
> Wednesday, November 2, 2005, 10:32:09 AM, you wrote:
> 
> ivc> Hi Ruslan,
> ivc> I need to know if is possible get RecID from this query that works only if I
> ivc> don't add RecID
> 
> ivc> query = "SELECT\
> ivc> Appuntamenti_ID,\
> ivc> Appuntamenti_Giorno, Appuntamenti_Mese, Appuntamenti_Anno,\
> ivc> Appuntamenti_Ore,\
> ivc> Persone_ID,\
> ivc> Studenti.Persone_Cognome || ' ' || Studenti.Persone_Nome,\
> ivc> Appuntamenti_Mediatore\
> ivc> FROM Appuntamenti, Persone, Persone Studenti\
> ivc> WHERE\
> ivc> Persone_ID = Appuntamenti_PersoneDoc_Ref\
> ivc> AND Appuntamenti_Persone_Ref = Studenti.Persone_ID\
> ivc> AND Appuntamenti_Aule_Ref = Aule_ID "
> 
> ivc> I need to begin with:
> ivc> query = "SELECT RecID,\
> 
> ivc> is possible?
> 
> Certainly possible. But which table's RecID you are going to select?

Good, this works
query = "SELECT Appuntamenti.RecID,\

it's very simple, thanks Ivan.
Paolo

> 
> SELECT
>       Appuntamenti.RecID,
>       Persone.RecID,
>       Studenti.RecID,
>       Appuntamenti_ID,
>       ...
> FROM
>     Appuntamenti, Persone, Studenti
> ...
> 
> -- 
> Best regards,
>  Ivan                            mailto:IvanSmahin at public.kherson.ua
> 
> _______________________________________________
> Valentina-beta mailing list
> Valentina-beta at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina-beta
> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.macserve.net/pipermail/valentina-beta/attachments/20051102/05038e24/attachment-0001.html