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:[email protected]
**********************************************************************
