Re: SQL statement failing on Windows 4D Volume Desktop, other things discovered

2016-12-30 Thread Paul Ringsmuth 
> Are you using port forwarding?  There is a possible problem with Client 
> reaching SQL Server if the port is being changed.
Hi Spencer. I am not using any network process at all. This is a standalone 
program which does not access anything but itself. The SQL was being used to 
find UUID fields within my own standalone application and check for bad values 
and generate new UUIDs if needed. 

I just got an email from ADeeg that says, Try with process arrays, local arrays 
does not work in compiled mode with
SQLRegards Armin

Thanks for helping. 

Paul Ringsmuth

> On Dec 30, 2016, at 12:43 PM, Spencer Hinsdale  
> wrote:
> 
> Are you using port forwarding?  There is a possible problem with Client 
> reaching SQL Server if the port is being changed.
> 
>> On Dec 30, 2016, at 9:57 AM, Paul Ringsmuth  wrote:
>> 
>> 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
>> 
> 
> **
> 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
> **

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

Re: SQL statement failing on Windows 4D Volume Desktop, other things discovered

2016-12-30 Thread ADeeg 
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_IDfrom _USER_COLUMNS WHERE DATA_TYPE = 13AND
> DATA_LENGTH = 16into :$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:

> 4D_Tech-Unsubscribe@.4D

> ******





--
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:4d_tech-unsubscr...@lists.4d.com
**

Re: SQL statement failing on Windows 4D Volume Desktop, other things discovered

2016-12-30 Thread Spencer Hinsdale 
Are you using port forwarding?  There is a possible problem with Client 
reaching SQL Server if the port is being changed.

> On Dec 30, 2016, at 9:57 AM, Paul Ringsmuth  wrote:
> 
> 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
> 

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

SQL statement failing on Windows 4D Volume Desktop, other things discovered

2016-12-30 Thread Paul Ringsmuth 
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
**