Environment: 4D 15.3HF1 for Mac and Windows macOS Sierra 10.12.2 Windows 7 in VMWare Either running interpreted or running standalone with 4D Volume Desktop on either platform
The following SQL statement works on Macintosh both interpreted and built with 4D Volume Desktop. It works on Windows interpreted. It fails on Windows 4D Volume Desktop. ARRAY LONGINT($tabs;0) ARRAY LONGINT($cols;0) Begin SQL select TABLE_ID, COLUMN_ID from _USER_COLUMNS WHERE DATA_TYPE = 13 AND DATA_LENGTH = 16 into :$tabs, :$cols; End SQL The error message is: Error when executing the method “LocateAndFixUUIDs” at line number xx (the End SQL line) Variable ‘$Tabs’ does not exist” Anyone else see this? Other things I learned: • If you put a comment in your code using “\\” next to “End SQL”, the comment is not saved. • If you need to get a the latest .4DB file from the Mac to Windows under VMWare, Beware. If you have shared folders with the Mac and you are in Document Library view or sometimes even regular view, you most likely will not be getting the latest version from the Mac. The only reliable way to get the file from Mac to Windows is to select the file on Mac, issue the copy command. Go to the Windows side and paste it into the appropriate folder there. Paul Ringsmuth ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************