The query works fine in Valentina Studio. The query doesn't give any result using Xojo 2022r3 on Ventura. On High Sierra the result is better but not quite 100% what it should be.
I've attached the result in Valentina Studio. For testing Xojo I copy-and-pasted the query to the Open Any example and ran a cursor:
dim theCursor as VCursor = mDatabase.SqlSelect(ColorQuery1)
if theCursor = Nil then Return
dim temp as Integer = theCursor.RecordCount
The record count is 0.
The query:
SELECT Message.MailboxID,Message.RecID,Message.OriginatorFrom as 'From',Message.ReceiverTo as 'To',Message.MainSubject as 'Subject',Message.MainDateTime as 'Date',Message.AttachmentCount as 'Att',Mailbox.MailboxpathName as 'Mailbox',lower(Message.OriginatorFrom) as 'Order_From',lower(Message.ReceiverTo) as 'Order_To',lower(Message.MainSubject) as 'Order_Subject' FROM (Message INNER JOIN Mailbox ON Message.MailboxID = Mailbox.RecID) WHERE ( ( (message.MailtagsMessageColor <> '' AND abs(list_nthitem(message.MailtagsMessageColor, 1, ' ') - 249) <= 5 AND abs(list_nthitem(message.MailtagsMessageColor, 2, ' ') - 230) <= 5 AND abs(list_nthitem(message.MailtagsMessageColor, 3, ' ') - 5) <= 5) ) ) AND ( 1 ) ORDER By "Date" DESC
Am I going crazy?
Xojo 2022r3 on Ventura and High Sierra. Valentina 12.6 for Studio and Xojo.