Error #6

[Gregoire William]

SELECT KUNDENtable.*

no ?

WilG

> -----Message d'origine-----
> De : valentina-bounces at lists.macserve.net
> [mailto:valentina-bounces at lists.macserve.net]De la part de Florian
> Bogeschdorfer
> Envoye : mercredi 17 decembre 2003 16:01
> A : 'Valentina Developers'
> Objet : Error #6
> 
> 
> Ruslan, I know now where the problem is. This is my SQL:
> 
> SELECT * FROM KUNDENtable,KUNDENKARTENtable WHERE CRD_KD_ID = 
> KD_ID AND
> KUNDENKARTENtable.CRD_Number ='667' no_case ORDER BY KD_ID
> 
> I make the SELECT over 2 tables and then the cursor will be read-only
> automatically. But how can I change my SQL since I need a 
> cursor with fields
> from KUNDENtable only, but I have to include KUNDENKARTENtable for the
> search condition. Must I change to
> 
> SELECT field1,field2,field3,..field81 (//all from KUNDENtable) FROM
> KUNDENtable,KUNDENKARTENtable....
> 
> ?? Or is there another solution to avoid writing explicitely 
> 81 field names
> in the search condition?
> 
> Best regards, Florian
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina