Problem with warnings

Jörg Pressel joergp at three-2-one.com
Thu Sep 6 15:11:33 CDT 2007


Hi Ruslan,

my app used to work just fine and I don't know why Valentina 3.3  
comes up with warnings. First warnings I get are in a select:

SELECT Distinct Artist,Tracks.Artist_Ptr,UpperArtistShort FROM  
Tracks,Artists Where Album_Ptr->CoverPictureL Is Not Null order by  
UpperArtistShort

Warnings:
Get Field : No field with name Album_Ptr
Get Field : No field with name Artist
Get Field : No field with name UpperArtistShort

But that's simply wrong. Valentina used to find the fields itself –
Album_Ptr is Tracks.Album_Ptr,
Artist is Artists.Artist,
UpperArtistShort is Artists.UpperArtistsShort.

Do I have to add the table names, even if field names are unique  
within a Select?

Huh, and why there is no warning for CoverPictureL?

Never I've added table names to fields in SQLSelect statements where  
it was obvious. Do I have to rework every single Select statement??


Thanks in advance,

Jörg



More information about the Valentina mailing list