Try with process arrays, local arrays does not work in compiled mode with SQLRegards Armin Paul Ringsmuth wrote > Environment:4D 15.3HF1 for Mac and Windows macOS Sierra 10.12.2Windows 7 > in VMWareEither running interpreted or running standalone with 4D Volume > Desktop on either platformThe 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 SQLThe 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.htmlArchive: > http://lists.4d.com/archives.htmlOptions: > http://lists.4d.com/mailman/options/4d_techUnsub: mailto:
> [email protected] > ********************************************************************** -- View this message in context: http://4d.1045681.n5.nabble.com/SQL-statement-failing-on-Windows-4D-Volume-Desktop-other-things-discovered-tp5749466p5749468.html Sent from the 4D Tech mailing list archive at Nabble.com. ********************************************************************** 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:[email protected] **********************************************************************
