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
**********************************************************************

Reply via email to