Mac OS Yosemite, 4D v15.6 If I am querying a UUID field, I use a UUID var of course. However there is no UUID variable type so like everyone I use a text var. What I never noticed before as I didn't need to check, is that *if* the var itself contains the UUID in the first 32 characters but has extra characters after it then 4D still finds a match!
So let's say the value in the UUID field's value is 607BFEA7CE2244EB9B00C2330E4E32F5 if my var $txt_UUID:="607BFEA7CE2244EB9B00C2330E4E32F5"+"xxx" Query([table1];[table1]UUID_FIELD=$txt_UUID) will still find the record. So in this case 607BFEA7CE2244EB9B00C2330E4E32F5"=607BFEA7CE2244EB9B00C2330E4E32F5xxx" I don't think this is a bug as 4D is using a special format for the UUID. However I falsely assumed that you needed an exact match for that type of query but it seems not. What do you all think? Is this a bug? An annoying gotcha? Did you already all know this and I am the only one who didn't? Cheers Jim Labos - infobase ----- Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************