Re: v13 - what is happening here, extra Quotation mark

2016-09-21 Thread Spencer Hinsdale

yes, I think this needs to be "\\"


> On Sep 21, 2016, at 9:16 AM, Tai Bui  wrote:
> 
> Hi,
> 
> Off the top of my head, is the \ character possibly acting as an escape 
> character?
> 
> Best Regards,
> -Tai B.
> **
> 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: 4D v15 & Mac OS Sierra

2016-09-21 Thread Spencer Hinsdale
maybe you just upgraded and it's doing that spotlight thing

> On Sep 21, 2016, at 2:44 PM, Tom Dillon  wrote:
> 
> 4D v15.2 & Mac OS Sierra
> 
> Is anyone else using Sierra yet and are they experiencing spinning 
> psychedelic pizza of death delays in the form editor?


**
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: How to resize PNG images for button icons

2016-10-12 Thread Spencer Hinsdale
Hi Kirk,

You can scale the image used in a 3-D Button by using a Variable and Transform 
Picture.  This works well and works for Retina.

We used Picture Buttons previously and also with a Variable in order to support 
background, mask, and multi-state.

3-D Buttons handle these automatically and with OS-specific flare.  Here's a 
visual:
https://www.bigbusiness.com/solutions/6453 

same buttons with different icons and different Set Format "Styles" have 
different background, highlight, bevel, offset...automatically.

hth,

Spencer


> On Oct 12, 2016, at 8:41 AM, Kirk Brooks  wrote:
> 
> Picture buttons do this nicely. But there are some limitations; the border
> choices aren't good and you can't include a text label, for instance. 3D
> buttons offer better configurability as an interface object but the linked
> image won't scale.

**
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: HTTP Request not working on macOS Sierra (4D 13.5)

2016-10-17 Thread Spencer Hinsdale
Hi Peter,

I think there is a bug in 13.5, fixed in 13.6, that HTTP Authenticate only 
sends 38 characters of password...



> On Oct 17, 2016, at 11:27 AM, Peter-Christian Miest  wrote:
> 
> Can anybody confirm that the command HTTP Request works correctly on macOS
> Sierra 10.12 with 4D 13.5?
> It simply get an empty response. Same code works on macOS El Capitan
> 10.11.4.
> 
> Thank you very much for any hint.
> Peter

**
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: European number format

2016-10-20 Thread Spencer Hinsdale

I'm not following your test exactly, but maybe it needs the Compatibility 
setting that reads something like, "use both comma period as valid decimal 
separators"

> On Oct 20, 2016, at 9:17 AM, Pat Bensky  wrote:
> 
> ​What am I doing wrong?
> 

**
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: European number format

2016-10-20 Thread Spencer Hinsdale
yes, it's on line eight, "use period and comma as placeholders in numeric 
formats"

> On Oct 20, 2016, at 10:24 AM, Pat Bensky  wrote:
> 
> Spencer - I can't find that setting Where is it? It isn't in
> Database Settings->Compatibility.
> Thanks
> Pat
> 
> On 20 October 2016 at 17:32, Spencer Hinsdale 
> wrote:
> 
>> 
>> I'm not following your test exactly, but maybe it needs the Compatibility
>> setting that reads something like, "use both comma period as valid decimal
>> separators"
>> 
>>> On Oct 20, 2016, at 9:17 AM, Pat Bensky  wrote:
>>> 
>>> ​What am I doing wrong?
>>> 
>> 

**
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: Need help setting up oAuth with cURL

2016-10-26 Thread Spencer Hinsdale

Hi Miyako,

I recently tried replacing OAuth.bundle (10/10/14)  with cURL.bundle (9/30/16) 
and ran into a problem with Error 60:
Peer certificate cannot be authenticated with known CA certificates.

I found that I could work around the problem by setting
CURLOPT_SSL_VERIFYPEER
to zero, which didn't seem like a great idea so I reverted :)

I tested against bigcommerce.com and shopify.com, getting the same error, using 
15.2 on El Capitan with Firewall off.  I did not have common-crypto installed.

I would be happy to post code, re-test, etc..

Thanks!

Spencer

> On Oct 26, 2016, at 8:35 AM, Keisuke Miyako  wrote:
> 
> the command names are exactly the same, nothing has changed other than the 
> name of the 2 plugins (the plugin has been split).
> code written for the old plugin will work "as is" with the "curl" and 
> "common-crypto" plugins.

**
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: Need help setting up oAuth with cURL

2016-10-28 Thread Spencer Hinsdale

Thanks!  I will have a look.  I now remember needing to add cert separately for 
curl.exe, prior to OAuth plugin (non-blocking!).  Thanks again.

> On Oct 28, 2016, at 12:03 AM, Keisuke Miyako  wrote:
> 
> please study the method "HTTPS_DEBUG" provided with the plugin's sample 
> database.
> 
> C_BLOB($in;$out)
> C_LONGINT($err)
> ARRAY LONGINT($tNomOption;0)
> ARRAY TEXT($tValOption;0)
> APPEND TO ARRAY($tNomOption;CURLOPT_SSL_VERIFYHOST)
> APPEND TO ARRAY($tValOption;"1")
> 
> APPEND TO ARRAY($tNomOption;CURLOPT_SSL_VERIFYPEER)
> APPEND TO ARRAY($tValOption;"1")
> APPEND TO ARRAY($tNomOption;CURLOPT_CAINFO)
> APPEND TO ARRAY($tValOption;Convert path system to POSIX(Get 4D 
> folder(Current resources folder)+"cacert.pem"))
> 
> APPEND TO ARRAY($tNomOption;CURLOPT_DEBUGFUNCTION)
> APPEND TO ARRAY($tValOption;"CB_DEBUG")
> 
> $err:=cURL ("https://www.bigcommerce.com";$tNomOption;$tValOption;$in;$out)
> 

**
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: Survey on 4D’s strategy for implementing Preemptive Processing / worker processes

2016-11-01 Thread Spencer Hinsdale
Hi Tony,

I love your preemptive enthusiasm!  But I also want you to update to watchOS 3 
so you have the Breath App at hand.

IMO 4D has always, always done a terrific job of migrating us, be it to 
unicode, or out of subtables, or to that new OS.

Do you remember Windows NT?  Microsoft totally abstracted the hardware.  Except 
developers weren't thrilled with the video, so they hardwired that back in.  
Oops.


-spencer

> On Nov 1, 2016, at 12:03 PM, Tony Ringsmuth  wrote:
> 
> 
> I appreciate your feedback in this
> Thanks!
> Tony 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
**

Re: Internet Commands plugin not working with Server v15.5

2016-11-08 Thread Spencer Hinsdale

Check the location of the plugin.  If you right-click on Server and Show 
Package Contents, in Contents there is a Plugin folder...



> On Nov 8, 2016, at 2:56 AM, tec...@mac.com wrote:
> 
> Hoping ….
> 
> ….  to elicit a clue on what might be the problem.
> 
> Anyone else ever experience a persistent failure of 4D (any flavour, any 
> version) to connect with the Internet Commands plugin?
> 
> What fixed it?
> 

**
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: Internet Commands plugin not working with Server v15.5

2016-11-08 Thread Spencer Hinsdale

I think you start off with:

1.  4D.app : Contents : Plugins : Internet Commands.bundle

2.  MyFolder : MyStructure.4DC
 MyFolder : Plugins : [empty or non-existent]

3.  4D Server.app : Contents : Plugins : [empty]


Then, depending on how you Build it copies from 1 or 2 to automatically 
populate 3.

We use BUILD APPLICATION:
http://doc.4d.com/4Dv15/4D/15.1/BUILD-APPLICATION.301-2686322.en.html 
<http://doc.4d.com/4Dv15/4D/15.1/BUILD-APPLICATION.301-2686322.en.html>
and it copies from 1 to 3.

To test you could manually copy from 1 to 3, again by right-click on 4D to Show 
Contents, and double-click on Contents, Plugins (expanding folders in detail 
view may not work as expected inside a Package).  If they are the same version 
(15.2?) then 1 should be the right one for 3.  Hope that's not too cryptic. :)





> On Nov 8, 2016, at 5:06 AM, tec...@mac.com wrote:
> 
> Oh! 
> 
> So am I being dim all this time? 
> 
> The Plugins folder in Server Package  Contents is empty - does this mean that 
> I need to move the plugins I want into that folder from the Plugins folder  
> which is alongside the 4D Server app? 
> 
> I have never had to do that previously.
> 
> From my reading of the plugin installation documentation the plugins folder 
> simply has to be alongside the Server app - or alongside the database 
> structure ...
> 
> Regards
> 
> David Hudson
> 
> 
>> On 8 Nov 2016, at 12:16, Spencer Hinsdale  wrote:
>> 
>> 
>> Check the location of the plugin.  If you right-click on Server and Show 
>> Package Contents, in Contents there is a Plugin folder...
>> 
>> 
>> 
> 
> **
> 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: Damaged database

2016-11-10 Thread Spencer Hinsdale

This Alert appears when the Data File has been Converted to v15.


> On Nov 10, 2016, at 7:11 AM, stardata.info  wrote:
> 
> Hi All,
> 
> In one my customer that use one application developed in 4D V13.2 from two 
> months, i have two or tre time a message for damage database.
> " The database is damaged, it will opened in maintenance mode "
> 

**
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: HTTPS failure to POST - Server Unreachable error

2016-11-16 Thread Spencer Hinsdale
can you connect from a browser?  unreachable suggests the web server is not 
running on port 443.

do you control the web server, and is it 4D?  

> On Nov 16, 2016, at 9:43 AM, Donald Koffman  wrote:
> 
> I have successfully used the HTTP Request command to POST to a url ($url). 
> The command is HTTP Request(“POST”; 
> $url;$content_blb;$response_blb;$headers_at;$values_at)
> 
> $url is  http//xx.xx.xxx.xxx/ 
> When I replace “http” with “htpps” in the url, 4D throws an error:
> 
> Error when executing the method “HTTP_PostTest” at line number 67
> 
> HTTP server not reachable: xx.xx.xxx.xxx   (sane ip address as in $url.
> Error #2 
> 
> line 67: $status_l:=HTTP 
> Request(“POST”;$url;$content_blb;$response_blb;$headers_at;$values_at) 
> 
> Question: why does http succeed and https fail?   
> Thanks,
> Don
> **
> 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: v15.3 seems to be crashing on MACOS 10.12.1 & the new MBP

2016-11-17 Thread Spencer Hinsdale
release notes indicate a known problem with macos build 16B257 but not with 
build 16B2555

go to about this mac and click on the 10.12.1 and it will reveal build.  
inquiring minds wanna know, which do you have?

if you are a developer, you can get beta 10.12.2 which per release notes fixes 
the 16b257 issue.


> On Nov 17, 2016, at 11:31 AM, Kirk Brooks  wrote:
> 
> Just unboxed a new MBP. And it's pretty fricking awesome! Just saying.
> 
> After about 45 mins I had it setup to the point I was ready to download 4D
> give it a spin. Just in time for the brand new 15.3 update to boot. Sadly
> things are not going well. 4D 15.3 crashes on start up.
> 

**
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: v15.3 seems to be crashing on MACOS 10.12.1 & the new MBP

2016-11-17 Thread Spencer Hinsdale

if you're bored, try v16 beta or 15R5.  i think these avoid some problems by 
being carbon free.  i would be curious to know if they work with the bad build.

i have been running 15.3 with the good build and it's awesome.  just saying. :)

> On Nov 17, 2016, at 11:51 AM, Kirk Brooks  wrote:
> 
> I don't have a 15.2 dmg with me. If someone has the link to it I'll try
> again. Otherwise I'll try when I get home.
> 

**
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: v12 & v13 screwup, converted accidentally

2016-11-23 Thread Spencer Hinsdale
you might try a Compact.  try going into v12 MSC, then changing the structure 
to v13’d, then Compact it.  this may create a new structure with v12 markings.  
or it may fail horribly.  if it works even some you might be able to copy from 
v12 resurrected to v12 restored.

> On Nov 23, 2016, at 1:01 PM, Chip Scheide <4d_o...@pghrepository.org> wrote:
> 
> yeah -
> I have done a lot of work over the past 3 days since last backup.
> 

**
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: About using the same data file in two different structures...

2016-12-03 Thread Spencer Hinsdale
Do either matter?  I kinda think MyStructure.Match is the map of table UUIDs.  
My guess is that if you have two identical structures and add a new table to 
each they will have different uuid's and therefore DATA added in one would not 
transport to the other despite having the same new table number, same new table 
name.  Meanwhile renaming a table would make no difference because it would 
still have the same uuid.


> On Dec 3, 2016, at 4:29 PM, Kirk Brooks  wrote:
> 
> ​What I'm seeing is the table names don't seem to matter as long as the
> Tables and Fields have exactly the same numbers. ​
> 

**
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: Most Current Cipher List for 4D

2016-12-05 Thread Spencer Hinsdale

I think there is a cipher list option with Get Database Parameter.  And I think 
4D uses OpenSSL and that 15.3 (not R that you are running) updates this (to 
1.0.x "J" or some such).  Sorry to be vague and unable to lookup right now but 
maybe this give a few ideas of where to start...

> On Dec 5, 2016, at 11:43 AM, Michael McCall  
> wrote:
> 
> I have a government client using our 4D OEM Web Server application. Their 
> security team would like to customize the cipher list used by 4D. We provide 
> the ability for clients to do that using our application. They however have 
> asked for the following information.
> 
> 1.  A complete list of the cipher suites the application presently 
> supports.
> 2.  Mapping of cipher suites supported to a known naming convention for 
> those cipher suites (eg – Windows, Apache, etc)
> 
> I found tech note 10-07 by Timothy Penner and it would appear to answer the 
> questions but it is for 4D v11 and we are currently using 4D v15 r5. 
> 
> Does anyone know?
> 

**
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: Most Current Cipher List for 4D and questions regarding OpenSSL versions being used

2016-12-05 Thread Spencer Hinsdale

it is the timing
- 15.3 is from 11/17/16
- OpenSSL is from 9/26/16
- R5 is from 9/14/16


> On Dec 5, 2016, at 4:10 PM, Michael McCall  wrote:
> 
> Thanks Tai,
> 
> I took your suggestion and checked the version of the ssleay32.dll which came 
> with v15 r5 and it only uses 1.0.1p. According to the list below that would 
> suggest that it is only using the version which v14 used instead of the one 
> which v15 used.
> 
> That doesn't appear to make sense to me nor does it seem to the build timing 
> seem to explain this anomaly. 
> 

**
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: 4D Server v15.2 OSX 10.12.1

2016-12-19 Thread Spencer Hinsdale
Hi David,

See if you have publickey.pem in the same location and move or rename:

http://kb.4d.com/assetid=77137

> On Dec 18, 2016, at 9:36 PM,   
> wrote:
> 
> I just upgraded a client to 4D v15.2 and OSX 10.12.1
> 
> The cert and key .pem were working just fine in 13.5.
> 
> Now on startup when 4D’s web server is starting I see:
> 
> Failed to set SSL certificate
> 

**
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: Sorting chemical formulas

2016-12-20 Thread Spencer Hinsdale
I'm not clear on the rules but it seems like you could build one sort field in 
the proper order, so:

AbCdEf
AbCgEf
AhCgEf

use sort field entries:

ACEbdf
ACEbgf
ACEhgf

Does this make sense?


> On Dec 20, 2016, at 4:40 PM, Pat Bensky  wrote:
> 
> Here's an interesting challenge for those off you who like a good puzzle ...
> 
> I need to figure out how to sort chemical formulas correctly.
> 

**
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: [ANN] XMAS SALE 4D pdf and outlook Plugin, 4D PDF Printer Plugin update 5.2.0

2016-12-21 Thread Spencer Hinsdale

Hi All,

I would like to offer an unsolicited recommendation for this product.  It pains 
me sometimes to read here about others' failing or flailing with 
free-pdf-whatever.

This plugin is great for emailing pdfs and works with Outlook.

It also super easy to do cool things like:

- combine pdfs (great for adding a page of terms and conditions to the back of 
an invoice, combining print jogs, etc)

- get the pro version and give your customers a pdf printer (that is super fast 
and makes tight pdfs)

- get support for pdfs on server, terminal services, etc

I'm sure it's not for everyone and there are lots of alternate ways to do some 
of the above.  There is a demo and I would be happy to field any questions if 
you're on the fence.

I have found it to be a complete solution with great reliability and support.  
And I'm looking forward to trying Plus integration with Outlook.

-spencer


> On Dec 21, 2016, at 2:50 AM, Armin Deeg  wrote:
> 
> For a short period until the end of the year we have reduced our plugin 
> pro/plus prices.
> Reduced prices are valid only for purchases from our homepage.
> 
> Example: If you own the plugin 5 pro, you can get the upgrade to the plus 
> version for only €450
> 
> go to http://www.node.de/indexplug.htm
> 
> 4D PDF PLUGIN:
> 
> 4D PDF Plugin with Royalty Free pdf printer driver.
> Just print your documents directly from 4D Windows to get very small
> colorful pdf files with activated hyperlinks, optional
> bookmarks and letter form watermarks. And much more ...
> 
> New in this version:
> 64bit demos for 4D15r5_64 and 4D16_64
> bug fixes for 64bit 4D
> new commands to set the outlook sender and mail store
> save mailed pdfs in your archive path
> set pdf version
> updated pdf driver
> 

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

Re: 4D UI code questions and observations

2017-01-09 Thread Spencer Hinsdale
Hi Arnaud,

What is 4dbb?

thanks,

Spencer

> On Jan 9, 2017, at 1:07 AM, Arnaud de Montard  wrote:
> 
> 
>> Le 9 janv. 2017 à 00:38, David Adams  a écrit :
>> 
>> [...]
>> * Reading 4D code on the NUG is pretty hard to do.
> 
> I do like inug, but really, from that point of view, 4dbb is another world… 
> In France we had 4d-forum, similar to inug. In a few years, quite all 
> contributors went on 4dbb. 
> 
> -- 
> Arnaud de Montard 

**
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: 4D UI code questions and observations

2017-01-09 Thread Spencer Hinsdale

thank you!


> On Jan 9, 2017, at 4:54 AM, Arnaud de Montard  wrote:
> 
> 
>> Le 9 janv. 2017 à 13:26, Spencer Hinsdale  a écrit :
>> 
>> Hi Arnaud,
>> 
>> What is 4dbb?
> 
> Hi Spencer, 
> 4dbb stands for "4d bulletin board", the "official" 4d forum. 
> <http://forums.4d.fr>
> 
> -- 
> Arnaud de Montard 

**
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: How to halt execution, to avoid Quit 4D

2017-01-10 Thread Spencer Hinsdale

Yes this is the problem.  One way to switch is to start 4d and instead of using 
a shortcut on the splash screen or a choice in recent menu, go File, Open, 
Local Database.  On the Open dialog you can choose Compiled/Interpreted and 
Current/Other/New Data File.

> On Jan 10, 2017, at 3:46 PM, Doug Hall  wrote:
> 
> I have an alert box that declares a certain plugin is not properly
> licensed. The very next command is Quit 4D. In a former version of 4D, I
> could hold down ++, and then click the alert button,
> and it would automatically continue in trace mode. How do I do this in v15?
> I last asked to run it in compiled mode. Is this the problem? If so, how do
> I get it to open back up in interpreted mode?
> 
> Thanks,
> Doug Hall

**
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: 4D Volume desktop v15/v16 in write protected folder

2017-01-11 Thread Spencer Hinsdale
The v15 R4 Upgrade docs show features to store the Data File Path in User 
Prefs, etc...

ftp://ftp-public.4d.fr/Documents/Products_Documentation/LastVersions/Line_15R4/VIntl/4D_Upgrade_v15_R4.pdf
 



In v15 it is possible to set compatibility to allow read-only (to suppress the 
error) and then in code determine if the "default" data file is being opened, 
read your own prefs, and Open Data File (last saved to your prefs).


> On Jan 11, 2017, at 5:36 PM, John DeSoi  wrote:
> 
> Hi Piotr,
> 
> 
>> On Jan 11, 2017, at 4:55 AM, Piotr Chabot Stadhouders 
>>  wrote:
>> 
>> So, my question is (again) :
>> Does anybody know of a way to run an application build with 4D Volume 
>> Desktop in a write protected citrix environment, without using virtual store 
>> and elevated privileges?
>> Now, in v15, I am getting an alert saying "Database is write protected". 
>> Because 4D still wants to store the location of the datafile in the 
>> structure?
>> I thought this was possible in v15

**
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: 4D Volume desktop v15/v16 in write protected folder

2017-01-11 Thread Spencer Hinsdale
i think the question is how to make it run.  first you check the checkbox, "Do 
not display warning when structure file is in read only".  then you write some 
code to open a writeable data file and remember where it is. :)

> On Jan 11, 2017, at 6:11 PM, Wayne Stewart  wrote:
> 
> Hi,
> 
> I think the question is not only data file but structure as well.
> 
> Problems:
> Storage of lists
> Logs
> Preferences
> 
> Regards,
> 
> Wayne
> 
> 
> Wayne Stewart
> about.me/waynestewart
> 
> 
> 
> 
> On 12 January 2017 at 13:09, Spencer Hinsdale  wrote:
>> The v15 R4 Upgrade docs show features to store the Data File Path in User 
>> Prefs, etc...
>> 
>> ftp://ftp-public.4d.fr/Documents/Products_Documentation/LastVersions/Line_15R4/VIntl/4D_Upgrade_v15_R4.pdf
>>  
>> <ftp://ftp-public.4d.fr/Documents/Products_Documentation/LastVersions/Line_15R4/VIntl/4D_Upgrade_v15_R4.pdf>
>> 
>> 
>> In v15 it is possible to set compatibility to allow read-only (to suppress 
>> the error) and then in code determine if the "default" data file is being 
>> opened, read your own prefs, and Open Data File (last saved to your prefs).
>> 
>> 
>>> On Jan 11, 2017, at 5:36 PM, John DeSoi  wrote:
>>> 
>>> Hi Piotr,
>>> 
>>> 
>>>> On Jan 11, 2017, at 4:55 AM, Piotr Chabot Stadhouders 
>>>>  wrote:
>>>> 
>>>> So, my question is (again) :
>>>> Does anybody know of a way to run an application build with 4D Volume 
>>>> Desktop in a write protected citrix environment, without using virtual 
>>>> store and elevated privileges?
>>>> Now, in v15, I am getting an alert saying "Database is write protected". 
>>>> Because 4D still wants to store the location of the datafile in the 
>>>> structure?
>>>> I thought this was possible in v15
>> 
>> **
>> 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
> **

**
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: How to halt execution, to avoid Quit 4D

2017-01-17 Thread Spencer Hinsdale
licensing?

> On Jan 17, 2017, at 12:24 PM, Lee Hinde  wrote:
> 
> Is there any other reason the debugger would be blocked from coming up? Now
> I'm having the problem with an old v13 database.  I know it's an
> interpreted database (no compiled choice in the open dialog).
> 

**
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: Live "On Column Resize" event

2017-02-08 Thread Spencer Hinsdale

can you filter for mouse down?

> On Feb 8, 2017, at 12:04 PM, Tilman Haerdle  
> wrote:
> 
> With 4D v16.0 the event "On Column Resize" fires live during resize of 
> listbox columns.
> 
> This has severe effects on methods who do stuff after resizing a column. If 
> the method takes to long irt is invoked again while it is still running which 
> results sooner or later in a stack overflow and subsequently a crash.
> 
> I'd wish there was a "On After Column Resize" event for methods who take 
> place after the fact and not during the resize action.
> 
> Any strategies to cope with the current implementation in v16?
> 

**
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: v15.3 and Windows 2016 Server

2017-02-09 Thread Spencer Hinsdale

Dude, there it is.  How did you do that?

> On Feb 8, 2017, at 4:50 PM, Randy Engle <4d.l...@xc2.us> wrote:
> 
> And yes, of course we will upgrade to 15.4 as soon as available.
> 

**
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: Live "On Column Resize" event

2017-02-09 Thread Spencer Hinsdale
+1  As OP mentioned this feature is much nicer with multiple list boxes you'd 
like to keep in sync

> On Feb 9, 2017, at 10:29 AM, Cannon Smith  
> wrote:
> 
> I love this feature. [snip]
> 
> 
>> On Feb 9, 2017, at 11:09 AM, Chip Scheide <4d_o...@pghrepository.org> wrote:
>> 
>> this behavior caused me no end of problems with window resizing.
>> personally I do not see the benefit. [snip]

**
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: v13 - Can not add record & Maintenance issues

2016-08-17 Thread Spencer Hinsdale
Hi Chip,

You can ignore an orphaned blob.  It is just a saved-outside-the-record field 
that lost its parent.  I don't think it causes any problem.

To fix an orphaned blob run Repair, twice.  If you go into MSC and Repair it 
will say "Anomalies Detected".  Repair again and it will be fixed.

First, for your your Index error, try re-writing all records in the table with 
something like
All Records
Apply To Selection(field1:=field1)

Does this help?


> On Aug 17, 2016, at 6:52 AM, Chip Scheide <4d_o...@pghrepository.org> wrote:
> 
> since this is development - it is not so much a problem as I can 
> replace the data file, however, I would like to understand what is 
> going on. 
> all of this is:
> C/S v13.5 OS X 10.6.8 on client side, OS X 10.9.? server side.
> 
> I attempted to add a record to a table, this is the first record in the 
> table (in other words the table is empty) 
> Create record([table])
> 
> set some values in the record, and save it.
> Upon saving, I get an error (not exact message)
> The record can be saved bad index.
> 
> I go into the structure editor, remove the indexes on the table.
> I then add them back.
> try again to add a record - no joy, same error.
> 
> I remove all the indexes completely.
> I try adding a new record - STILL no joy.
> *same* error - even though there is no longer an index on the table.
> 
> Run maintenance, from client, 'verify' fails showing an orphaned blob 
> in a different table from the one I am having trouble with.
> Go to server, run maintenance, 'Compact', it starts hits the table with 
> the orphaned blob - and crashes!
> 
> Any ideas what is going on?
> 

**
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: v13 - how to get directory path on server from client

2016-08-17 Thread Spencer Hinsdale

get process variable (-1;<> Directory_path;$Server_path) ?

> On Aug 17, 2016, at 12:51 PM, Chip Scheide <4d_o...@pghrepository.org> wrote:
> 
> get process variable(<> Directory_path;$Server_path)
> 

**
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: Design Environment Jankyness in 15.2 Mac

2016-09-06 Thread Spencer Hinsdale

Hi Lee,

I think there are three solutions:

1. Get Info on 4D and click the checkbox to Open In Low Resolution

2. Regress to v13 (pre Retina)

3. Upgrade to new 64-bit Developer



> On Sep 6, 2016, at 4:01 PM, Lee Hinde  wrote:
> 
> Scrolling property lists and moving around in the layout editor is painful.
> 
> Is this just the way it is, or is there something I need to turn on or off?
> 

**
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: v12 - Web authentication & Digest & MD5

2016-09-07 Thread Spencer Hinsdale

it's a hash (not the kind you're smoking); is not reversible

> On Sep 6, 2016, at 10:18 AM, Chip Scheide <4d_o...@pghrepository.org> wrote:
> 
> Anyone have an MD5 decoder they would be willing to share?
> 

**
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: printing issues in v15.2

2016-09-08 Thread Spencer Hinsdale

Hi Chuck,

Are you printing to paper to test?  There is a known problem with the Preview 
app not displaying Hairlines.  I think it only affects 10.10, and I'm pretty 
sure it only affect displaying on screen.  IOW it does not affect 10.9 or 
printing from Preview to paper, so probably not what you're seeing, or not 
seeing as the case may be


> On Sep 8, 2016, at 10:05 AM, Charles Miller  wrote:
> 
> Hi All,
> 
> we have many print forms which have hairline lines on them. When we use
> these forms to print, the lines do not show. They do in v11. If I delete
> and recreate the line with exactly the same dimensions. The print as
> desired. Any ideas out there as we have many forms where this might be a
> problem. and it will be a very large task to make all changes needed. We
> are running on Macs Have tested on 10.11 and 10.9
> 
> 

**
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: Programmatic control of accept/reject new connections

2017-09-27 Thread Spencer Hinsdale via 4D_Tech
wouldn’t you just
$0:=123

in On Server Open Connection DB Method

Spencer

> On Sep 27, 2017, at 7:38 AM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Can this be done in code? Or is there a way to default it to rejecting 
> connections when you start the server?
> **
> 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: Resolving format

2017-10-02 Thread Spencer Hinsdale via 4D_Tech

Hi Jeremy,

I don't know.

I think it you use Filters and Formats to enter the format, i.e."£###,###" it 
is saved somewhere in your Structure and may be inaccessible.

However you do have a Localization mechanism available, which works sort like 
this (stop me if you've heard this one before):

toolbox, filters and format, |Money, Definition = ":20001;1"

then adjacent your structure in your resources folder:
resources:en.lproj:structureEN.xlf


http://doc.4d.com/4Dv16/4D/16/XLIFF-and-translation.200-3246844.en.html

Then, Get Indexed String(20001;1) would give you "£###,###"

Or you could access your resources file with xml commands:
$path:=get 4d foler(resources folder)+folder 
separator+"en.lproj"+folder separator...

hth,

spencer

> On Oct 2, 2017, at 2:06 AM, Jeremy Roussak via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> If have defined, for example, “|Money” in the Filters tab of Toolbox as 
> "£#,###,##0;-£,##0”, I’d like to be able to resolve the format name into 
> the text of the format.
> 
> Is there a valid way in which it can be done?
> 
> Jeremy
> 
> 
> Jeremy Roussak
> j...@mac.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
> **

**
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: Create multi array

2017-10-06 Thread Spencer Hinsdale via 4D_Tech

1) Use a Two Dimensional Array:
http://doc.4d.com/4Dv16/4D/16.2/Two-dimensional-Arrays.300-3433911.en.html

2) Decide if your arrays are Rows or Columns.  The Docs call them Rows.  If you 
decide your arrays are Columns, then you must REMEMBER the Docs need 
"translation" anytime you refer to them.

3) Decide if you will use array zero.  If you decide to use array zero, then 
you must REMEMBER to Clear it yourself.


That's it.


You will want to fill your arrays, so you may want to pass them to another 
method, or perhaps another process, or even another computer (method with 
execute-on-server attribute).  You will want to declare them.  You can declare 
20 arrays in 20 lines.  Or, see #1.

You may want to display your arrays.  If so, you will use a List Box.  And your 
arrays will be Columns.  See #2.

And you may want somewhere to put additional info, that goes with the data when 
you pass the arrays, and stays synchronized when your user moves or sorts your 
List Box.  And once your users see these arrays they will want others.  If so, 
you will likely re-use your code, your List Box, and your arrays.  In which 
case, see #3.


HTH,

Spencer




> On Oct 6, 2017, at 1:57 AM, stardata.info via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi All,
> 
> I need to create 20 arrays that have a similar name.
> I can do this using the pointers?
> I try with this code, but in compiled mode not work.
> 
> For ($I;1;17)
> $vPoint:=Get pointer("aAna_"+String($I))
> ARRAY REAL("aAna_"+String($I);0)
> End for
> 
> Have suggestions?
> 
> Thanks
> Ferdinando
> **
> 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: Post Key command not working in converted 4Dv16 database

2017-10-09 Thread Spencer Hinsdale via 4D_Tech
You might try the key command to disable any event handler:
http://doc.4d.com/4Dv16/4D/16.2/ON-EVENT-CALL.301-3432983.en.html 




> On Oct 9, 2017, at 6:41 AM, Ken Daniel via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Koen & Steve, thanks for the tip, but in this case I am using POST
> KEY(Character code(".");Command key mask) and had the shortcut of Ctrl .
> assigned to a button. It only fails to work in this one converted database.
> I've converted another database to v16 for a different application and it
> works fine. I've compared the two databases and can't discern any
> difference. In another test, if I execute POST KEY (Character Code("a")), I
> can see it populate a variable field with the letter "a", but it just won't
> execute the code assigned to the button with that shortcut. Ken
> 

**
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: San Fransisco Font

2017-10-09 Thread Spencer Hinsdale via 4D_Tech
Here's how to get font and something about style sheet "automatic":

http://kb.4d.com/resources/inug?msgid=GmailId15d3951d31795686 


I don't know from "Default" but I do vaguely recall having boxes for 95, 2000, 
and XP.  :)

> On Oct 9, 2017, at 1:46 PM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> In my experience, the Default style sheet doesn't work correctly. On El 
> Capitan and Sierra, it uses the Yosemite system font no matter what. But if 
> you make a new style sheet that refers to "System Font" you'll end up the 
> correct font on each OS. Not sure why "Default" doesn't work properly... I 
> never really dug into it.
> 
> Keep in mind that the Yosemite system font is significantly wider than its 
> successors.
> 
> --
> Jeffrey Kain
> jeffrey.k...@gmail.com
> 
>> On Oct 9, 2017, at 4:28 PM, Sujit Shah via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>> 
>> My thinking has been to use the “Default “ style sheet and explicitly set
>> it to the prevailing system font on both platforms. However, the stylesheet
>> editor has only one setting for macOS and some obsolete windows OS.
> 
> **
> 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: Anyone using 4D Write Pro with a semblance of success?

2017-10-16 Thread Spencer Hinsdale via 4D_Tech

doesn’t r4 have tables, ie columns?

> On Oct 16, 2017, at 3:04 PM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> We are creating a document-building system using WritePro. It creates
> data-based documents like catalogues, price lists, directories etc. -
> something that our software currently does by creating tagged files for
> importing into InDesign, QuarkXPress, or Word.
> 
> Currently there are two major features missing from WritePro that are
> holding us back:
> 
> - Columns
> - Creating stylesheets via code
> 
> The idea is that the user will be able to build the catalogue (or whatever)
> and then either open it in a WritePro area and review it, maybe tweak it a
> bit, and then print it or PDF it, or just go directly to PDF. We've got the
> bones of it working but have stopped development for the time being because
> of those two major shortcomings. I've submitted both as feature requests
> and hope they get implemented soon.
> 
> Pat
> 
> On 16 October 2017 at 22:56, BTB-David via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
> 
>> From everything that I’ve read, High Sierra is the last version of OS X
>> that will support 32 bit apps.  This makes the 4D Write/4D View issue
>> imminent for me.
>> 
>> Thanks!
>> 
>> David Conley
>> By The Book, Inc.
>> Office: 815-234-7530
>> Direct Line: 815-406-5502
>> Fax: 815-234-7532
>> http://www.bythebook.com
>> 
>> 
>> 
>> 
>>> 
>>> Anybody heard comments from Apple or Microsoft as to when they will kill
>> support for 32bit applications?
>>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> This email was sent to 4d_tech@lists.4d.com (mailto:4d_tech@lists.4d.com)
>> unsubscribe from this list (http://emailclicks.bythebook.
>> com/track/unsub.php?u=30055319&id=55128fca61194ea7990a570d8e4be7
>> c5.6uKpduIsjJ%2FEqVQ1r%2BdLr66Tu1w%3D&r=https%3A%2F%
>> 2Fmandrillapp.com%2Funsub%3Fmd_email%3D4d_tech%2540lists.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
>> **
>> 
> 
> 
> 
> -- 
> *
> CatBase - Top Dog in Data Publishing
> tel: +44 (0) 207 118 7889
> w: http://www.catbase.com
> skype: pat.bensky
> *
> **
> 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: How do you run MSC in a compiled/merged single user app?

2017-10-18 Thread Spencer Hinsdale via 4D_Tech

hold Option key while starting up to get the dialog where you can switch files, 
create new, or use msc

> On Oct 18, 2017, at 7:54 PM, Robert McKeever via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> 4D V15.4, single user. The client is on the east coast (4 time zones), I’m in 
> the west.
> 
> I tried ‘Open Security Window’ in an execute statement (I’m logged in with 
> Teamviewer), and it does not work.
> 
> It is unable to save a record in a frequently used (adds only, no deletes) 
> table. So, I’ve compressed the datafile and its indexes, and I’m moving it 
> here to do the repair (He tends to shut his Mac off rather than quit 
> properly). 
> 
> Any ideas?
> _
> Bob McKeever  http://www.mswl.com 
> McKeever's Software Wizardry
> Port Coquitlam, B.C.
> bobmckee...@mac.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
> **

**
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: QUERY into variable vs. Records in Table

2017-10-19 Thread Spencer Hinsdale via 4D_Tech


trigger?

> On Oct 19, 2017, at 10:28 AM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I feel like I'm missing an obvious solution.
**
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: QUERY into variable vs. Records in Table

2017-10-19 Thread Spencer Hinsdale via 4D_Tech

maybe i don't understand but what about:

`trigger
execute on client("@";"flagPoll")

`flagPoll
c_boolean(<>flagPoll)
<>flagPoll:=true

...

if(<>flagPoll)
>   $x:=Records in table([ServerMigrations])
<>flagPoll:=false
else
 `skip 99,999 calls to server
end if

> On Oct 19, 2017, at 11:31 AM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Decided to test it. Here are the results, running interpreted, client-server 
> against a server under very low load:
> 
> Records in table: 565 ms
> Semaphore polling: 2482 ms
> Query into variable: 2749 ms
> 
> Here's my test code:
> 
> C_LONGINT($msRIT;$msSEM;$msQUERY;$x;$n)
> C_BOOLEAN($b)
> $n:=1000
> 
> $msRIT:=Milliseconds
> For ($i;1;$n)
>   $x:=Records in table([ServerMigrations])
> End for 
> $msRIT:=Milliseconds-$msRIT

**
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: info.plist

2017-10-29 Thread Spencer Hinsdale via 4D_Tech
http://doc.4d.com/4Dv16/4D/16/4D-XML-Keys-BuildApplication.100-3130124.en.html


> On Oct 29, 2017, at 1:31 AM, Jeremy Roussak via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> I’m sure I’m missing something obvious (and I think I’ve managed to solve the 
> issue in the past), but…
> 
> How do I tell 4D to put stuff into the info.plist file for a built 
> application? I’m particularly interested in version strings.
> 
> Mac, 4Dv14.
> 
> Thanks.
> 
> Jeremy
> 
> 
> Jeremy Roussak
> j...@mac.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
> **
**
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: 4DLINK

2017-11-09 Thread Spencer Hinsdale via 4D_Tech
Hi Pavel,

See if you can use LastDataPathLookup, ByAppPath:
http://doc.4d.com/4Dv16/4D/16/LastDataPathLookup.300-3130241.en.html

If you Build your application (app_sss.exe) using XML Keys, you:
- use v16
- set Compatibility option for Use New Architecture--see bottom of this page:
http://doc.4d.com/4Dv16/4D/16.1/Compatibility-page.300-3373287.en.html
- Build with the key above

This is a great solution for distribution.  Each target machine remembers each 
Data File for each App.

There are other solutions (DateName=StructureName AND in-same-directory, Key 
for DefaultDataFile) if _you_ control the target machine.



> On Nov 9, 2017, at 1:45 AM, Pavel Cerny via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi,
> 
> Under WIndows I have 2 or more identical applications in different
> directories with different filename datafiles.
> For example :
> C:\A\app_sss.exe   C:\A\Database\app_sss.4DC and app_sss.4DD  - it is OK
> C:\B\app_sss.exe   C:\B\Database\app_sss.4DC and app_bbb.4DD - when I update
> the application, I always have to select the datafile again, can I set up
> for exe (4dc) which datafile to open?
> 
> Thanks
> Pavel
> 
> 
> 
> 
> 
> --
> Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
> **
> 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: subforms and object focus

2017-11-15 Thread Spencer Hinsdale via 4D_Tech
Try this...

$row:=1
EDIT ITEM([SubformTable];$row)

`and then something like
HIGHLIGHT TEXT(Focus Object->;1;Length(Focus Object->))

> On Nov 15, 2017, at 9:34 AM, Randy Jaynes via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Has anyone figured out how go to a specific object in a subform when opening 
> the parent form (currently in v15.4 HF3)?
> 
> ...
> 
> The idea here is that I open the parent form and I want to be sitting in the 
> first field on the subform with all of its text highlighted.
> 

**
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: 4D v16.2 64-bit Server and 32-bit Clients?

2017-11-27 Thread Spencer Hinsdale via 4D_Tech
Hi Justin,

Yes, this works perfectly, especially if you have third-party plugins that are 
not updated ;p

This setup uses the new Network Layer, which seems to me problem-free on Mac.  
Windows Server seems more problematic but can be reverted to Legacy Network 
Layer.  16.3 will be along momentarily, I hope, and fix remaining issues.

With new Network Layer you can also have a client-update hurdle (old client 
need Legacy to update Client), error -19019 or some such.

hth,

spencer

> On Nov 27, 2017, at 5:29 PM, Justin Leavens via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> I think I remember that this configuration on the Mac is okay, but I could
> use some confirmaiton: a 64-bit 4D Server (which enables me to use maximum
> RAM for cache) and 32-bit 4D client apps (because ALP isn't yet 64-bit
> compatible).
> 
> Are there any reasons why I would run into trouble with this configuration?
> I'm upgrading an old app that was most recently v12, and wouldn't really
> benefit from 64-bit at this point. As for the Arealist Pro limitation: I
> understand there's a 64-bit version of that coming, but if I don't need
> 64-bit on the client app then I see no reason to push for it.
> 
> Thanks for helping me clear my head on this.
> 
> 
> 
> --
> Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
> **
> 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: Quick Report Editor Preview on Windows

2017-12-11 Thread Spencer Hinsdale via 4D_Tech
I'd guess you need XPS Viewer installed

> On Dec 11, 2017, at 12:16 PM, John Baughman via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> What do you have to do on windows to use the preview button in the Quick 
> Report Editor in Windows? When I click it I get “No application is associated 
> with the specified file for this operation”.
> 

**
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: Programmatically Manage Parent Tab an Multi-Subforms

2017-12-24 Thread Spencer Hinsdale via 4D_Tech

old school is draw two subfoms. one off screen. then swap as needed. with 
move-object. works a charm ;)


> On Dec 24, 2017, at 8:37 AM, truegold via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi All,
> 
> I have a parent form which has a subform container. Above the subform 
> container is a tab control object (5 tabs). Clicking on a tab selects the tab 
> an triggers (underlying code) a change to the underlying subform. Works great.
> 
> But I discovered I need one of the subform pages, let’s call it “Edits”, to 
> change, based upon a different context, to either a different page or a 
> different subform using code. The key here is that some action in the parent 
> form needs to cause the subform container to display a different form.
> 
> Seems easy… But I haven’t been able to get it to work.
> 
> Parent Form (Tab control)
>   -> Subform container
>  -> actual subform
> 
> Logically it seems that I need to programmatically set the correct tab and 
> tell the subform container to change the subform displayed. And then, of 
> course, have the subform appear in the subform container.
> 
> At the point where I need things to happen I’m not in a subform so I can’t 
> use CALL SUBFORM CONTAINER. I can’t use EXECUTE METHOD IN SUBFORM because I 
> am at the parent level. Well if I had a multi-page subform then I might need 
> to use the command.
> 
> I’ve tried many variations over the last few days. So… I am sure that not 
> having a clear understanding of what I am doing is contributing to my hit and 
> miss approach not working.
> 
> So what’s the secret sauce to manage programmatically the subform change 
> (parent level)?
> 
> Can someone point to where my understanding is off? Or other ideas?
> 
> Appreciate,
> John…
> 
> **
> 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: Screen capture code snippet found on the NUG that I am not able to make work. plse help

2018-01-26 Thread Spencer Hinsdale via 4D_Tech
Hi Ernie,

If you go to Terminal you can type or paste $command_t contents to test.

You could also type, "man screencapture" to see the the manual which documents 
options like -R, which I do not see in High Sierra.

My guess is that you need a single quote for path name since it contains space. 
 I will add it for you in the following:

$command_t:="screencapture "+$screenRectOption_t+" '"+Convert path system to 
POSIX($filePath_t)+"'"

or the human-readable version:

$command_t:="screencapture "+$screenRectOption_t+" "+Char(Quote)+Convert path 
system to POSIX($filePath_t)+Char(Quote)

HTH,

Spencer

> On Jan 25, 2018, at 10:04 PM, ernie hilgers via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Hi Tim Nevels,
> 
> I was trying to make the code work on my mac 10.6 / 10.8 but somehow I am not 
> getting the snapshot on the desktop. (where I want them, for now)
> 
> I changed some of your code  (see below) but I am not sure if I understand if 
> that makes it work.

**
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: Problems installing built application

2018-02-05 Thread Spencer Hinsdale via 4D_Tech
Well, if you go back to PackageMaker you can build an Installer that is signed 
with your Developer ID Installer

And in Package, Contents you can go to Scripts, Postinstall and add a script 
with contents like:

#!/bin/sh

chmod -R 777  '/Applications/MyAppFolder'

> On Feb 5, 2018, at 11:46 AM, macjimbo via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Help!
> 
> Cheers
> 
> James
> 
> 
> 
> --
> Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
> **
> 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: Problems installing built application

2018-02-05 Thread Spencer Hinsdale via 4D_Tech

v16, database prefs, New Architecture

anything else?  :)

> On Feb 5, 2018, at 3:36 PM, macjimbo via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> that works until I install an upgrade.
**
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: Problems installing built application

2018-02-05 Thread Spencer Hinsdale via 4D_Tech

oh, okay you can use Default Data File feature in XML Build Keys,
store last file opened in your own text file, test the data file opened and if 
it is default look for text file and use Open Data File. there is some trick 
like calling in a new process maybe...

> On Feb 5, 2018, at 3:36 PM, macjimbo via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> 'm running 15.5 on Mac OS 10.13.2
**
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: Blank Listbox

2018-02-23 Thread Spencer Hinsdale via 4D_Tech
my blank list boxes are always arrays, out of sync, which is easy to suss by 
backing off the fill instructions until it shows something.  hint, one column 
is always in sync.

however i don't think this problem makes headers blank.

i would suggest you try leaving listbox in group4 and showing group4 but NOT 
hiding group1.  if needed scoot some objects around so they can be viewed 
together.  does this make any difference?

> On Feb 23, 2018, at 7:32 AM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Why would it appear as a blank box in Group​4?
> 
> Thanks for any enlightenment you can offer!

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Label Editor problems v16 (doesn't recognize # of columns)

2018-03-09 Thread Spencer Hinsdale via 4D_Tech

Hi Rob,

It seems to work for me, same setup, running 32-bit.  Maybe it's different 
64-bit?

One oddity is clicking the up arrow to go from 2 to 3 Columns worked but did 
not re-scale in any way.  I then had to change Label Width to see the column on 
page view.  Maybe you are adding a column off-screen?

HTH,

Spencer

> On Mar 9, 2018, at 12:05 PM, Robert C. Faucett via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Hello All - I am having problems getting the Label Editor to recognize how 
> many columns
> of labels I want.  Anybody else having experience with this?  4D v16.3 &
> MacOS 10.13.3.  It seems to ignore the value in the “Columns” box.
> 
> Thanks for any advice.
> 
> Rob

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Label Editor problems v16 (doesn't recognize # of columns)

2018-03-09 Thread Spencer Hinsdale via 4D_Tech
When I started 2 Columns took up 80% of the window.  When I switched to 3 
Columns the 3rd column extended to about 120% so I couldn't see half of it.  

This gave me the idea that maybe your columns take 100% of the width and when 
you add a column it appears in the 100-150% range, i.e. "off-screen".  If so, 
typing a smaller value in Label Width would make it appear.

Just a theory :)



> On Mar 9, 2018, at 12:46 PM, Robert C. Faucett via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Thanks Spencer.  How would a column be added ³off screen?"
> 
> 
> --
> Robert C. Faucett
> Collections Manager
> Ornithology
> Burke Museum
> Box 353010
> University of Washington
> Seattle, WA 98195-3010
> Office: 206-543-1668
> Cell: 206-619-5569
> Fax: 206-685-3039
> rfauc...@uw.edu
> www.washington.edu/burkemuseum
> http://www.washington.edu/burkemuseum/collections/ornithology/index.php
> http://www.washington.edu/burkemuseum/collections/genetic/index.php
> 
> 
> 
> 
> 
> 
> On 3/9/18, 12:12 PM, "4D_Tech on behalf of Spencer Hinsdale via 4D_Tech"
> <4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:
> 
>> 
>> Hi Rob,
>> 
>> It seems to work for me, same setup, running 32-bit.  Maybe it's
>> different 64-bit?
>> 
>> One oddity is clicking the up arrow to go from 2 to 3 Columns worked but
>> did not re-scale in any way.  I then had to change Label Width to see the
>> column on page view.  Maybe you are adding a column off-screen?
>> 
>> HTH,
>> 
>> Spencer
>> 
>>> On Mar 9, 2018, at 12:05 PM, Robert C. Faucett via 4D_Tech
>>> <4d_tech@lists.4d.com> wrote:
>>> 
>>> Hello All - I am having problems getting the Label Editor to recognize
>>> how many columns
>>> of labels I want.  Anybody else having experience with this?  4D v16.3 &
>>> MacOS 10.13.3.  It seems to ignore the value in the ³Columns² box.
>>> 
>>> Thanks for any advice.
>>> 
>>> Rob
>> 
>> **
>> 4D Internet Users Group (4D iNUG)
>> FAQ:  http://lists.4d.com/faqnug.html
>> Archive:  http://lists.4d.com/archives.html
>> Options: https://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: https://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: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Label Editor problems v16 (doesn't recognize # of columns)

2018-03-09 Thread Spencer Hinsdale via 4D_Tech

maybe you are entering values in Euros and it is converting to Dollars (5:6)?  
Just kidding; I have no idea, except when I tested I used the up-down arrows 
not typing a value


> On Mar 9, 2018, at 1:23 PM, Robert C. Faucett via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Thanks Spencer - My problem is more simple that that . . .  If I enter “5"
> into the “Columns” boxing hit preview the document has 6 columns of labels
> (5.75 actually as it spills off the right side of the page).
> 

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Error -19191 ?

2018-05-08 Thread Spencer Hinsdale via 4D_Tech
It is old client cannot update via new network layer...

http://kb.4d.com/assetid=77427 

> On May 8, 2018, at 9:53 AM, Bob Miller via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi Everyone,
> 
> I have a 4D Client user (v15r5, Windows) who can't connect, with error 
> -19191.  I can't find this error in either the language ref, the server 
> reference, or the design ref.  Does anyone have an idea of what this error is?
> 
> Thanks,
> 
> Bob Miller
> Parker Hannifin Corp.
> 
> ll
> "PLEASE NOTE: The preceding information may be confidential or privileged. It 
> only should be used or disseminated for the purpose of conducting business 
> with Parker. If you are not an intended recipient, please notify the sender 
> by replying to this message and then delete the information from your system. 
> Thank you for your cooperation."
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://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: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: EC2 server on Amazon AWS

2018-05-11 Thread Spencer Hinsdale via 4D_Tech

Hi Rudy,

1) you need the public IP from your dashboard.  this may not be the IP that 4d 
server appears to be listening to

2) you need allow access from your dashboard by going to Security Groups and 
adding your Ports (19812 - 19814)

3)  you need to configure Windows Advance Firewall


https://www.bigbusiness.com/solutions/6779

> On May 11, 2018, at 7:21 AM, Two Way Communications via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Hi,
> 
> Has anyone succeeded in setting up a 4D server on a virtual Windows server on 
> AWS?
> 
> I have set up the server (free version), installed 4D server 416R6, added the 
> licenses and launched the 4D database.
> Additionally I configured the ports on the AWS server to also listen to the 
> TCP and UDP addresses.
> 
> However, there is no way I can connect to it from a 4D client on my machine, 
> Neither on the public address provided, nor the private IP address.
> I tried with the public address, and even tried with appending :19813 as a 
> port after the IP address.
> 
> Any tips will be greatly appreciated.
> 
> 
> Regards,
> 
> Rudy Mortier
> Two Way Communications bvba 
> 
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://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: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Chromium Embedded Framework in built applications question

2018-05-19 Thread Spencer Hinsdale via 4D_Tech
Hi David,

My guess was it was added to support Tabbed interface on Mac, Developer.

v16.3 in December greatly reduced Built Client for us (506MB -> 282MB), and 
comes after R3 you are using.

So my guess is current R6 would do the same for you.


Spencer


> On May 19, 2018, at 4:14 AM, David Adams via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> A friend recently pointed out that built apps had unexpectedly increased in
> sizea lot. We used to come in at something like 150MB and are now at
> over 600MB.
> 
> macOS, 16.3 R3
> 
> Digging into the ressoures in the built app, this package appears:
> 
> Chromium Embedded Framework.framework
> 
> ...at about 260MB. The compiled database is less than 55MB.
> 
> Does anyone know what this Chromium Embedded Framework.framework file is
> and how to get rid of it? You can't just strip it out after the build as 4D
> complains on launch.
> 
> Thanks!
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://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: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Backup Settings window

2018-06-01 Thread Spencer Hinsdale via 4D_Tech
seems like a Resource error. assuming you are on macOS, maybe a fix is to Build 
using 32-bit Volume Desktop

-spencer

> On Jun 1, 2018, at 1:50 AM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I've just upgraded a client's custom database to v16.
> I compile it and build a stand-alone single-user app.
> When I launch this app, the Backup settings window opens with the window
> title ":StrLang,61".
> No matter what settings I choose, when I click the Save button I get the
> message:
> 
> *Backup settings not saved.*
> *Preferences path not found.*
> *No Backup XML file was opened.*
> 
> I've tried various backup settings but I always get the same result.
> I've tried with v16.3 and with v16r6 - same result.
> In the Database Settings, on the Backup tab, I selected *Never* for
> Automatic Backup but that did not fix the problem.
> 
> Want would be causing this?
> 
> PB
> 
> -- 
> *
> CatBase - Top Dog in Data Publishing
> tel: +44 (0) 207 118 7889
> w: http://www.catbase.com
> skype: pat.bensky
> *
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://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: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: POW Function

2018-07-24 Thread Spencer Hinsdale via 4D_Tech
is it caret?

7^3



> On Jul 24, 2018, at 9:15 AM, Cannon Smith via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I’m looking for an equivalent function in 4D as the pow function in other 
> languages. For example:
> 
>   
> 
> 

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: POW Function

2018-07-24 Thread Spencer Hinsdale via 4D_Tech

difference btwn log and natural log.  try LOG10

> On Jul 24, 2018, at 9:32 AM, Cannon Smith via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> 
> But I’m getting an exponent of 7 instead of 3. Any ideas what I’m doing wrong?
> 

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Orphaned blobs and SSD drives

2018-07-29 Thread Spencer Hinsdale via 4D_Tech
John,

This might be a man in the middle of a weekend attack.  I'm pretty sure the 
real Jeff Kain would tell you to run Repair, TWICE, to fix Orphaned BLOBs.

> On Jul 29, 2018, at 3:32 PM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> To fix a table with orphaned blobs, export the data, truncate the table, and 
> reimport. Nothing to really worry about, except that you can't do a simple 
> compact without erroring out.

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: ORDA - updating data in listboxes

2018-08-12 Thread Spencer Hinsdale via 4D_Tech
is this relevant?

http://kb.4d.com/resources/inug?msgid=GmailId164f73d107b663e7 



> On Aug 12, 2018, at 11:55 AM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> The thing that's not working is the Name column of the listbox - 


**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: pdfCreator problem

2018-08-29 Thread Spencer Hinsdale via 4D_Tech

+1

> On Aug 29, 2018, at 8:19 AM, Randy Engle via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Keith,
> 
> Two thumbs up for Armin's plugin.
> Yes, there is a cost, but eliminates a lot of headaches
> 
> Randy Engle, Director
> XC2 Software LLC – XC2LIVE!
> 
> Keith wrote
>> Hi all.
>> We have suddenly struck a problem with pdfCreator v1.7.2 not working 
>> when using a built 4D Client via Remote Desktop Connection access.
>> It used to work, but started giving problems about a month ago (that's 
>> when we first detected it).
>> 
>> pdfCreator works just fine when the 4D Client is accessed via Ericom 
>> and the Chrome browser, but not when accessed via Remote Desktop Connection.
>> In the latter case, the problem manifests itself when the document 
>> that pdfCreator is told to create in the Temp folder in the User 
>> folder doesn't happen, and an error is then generated when the code tries to 
>> access it.
>> The error can be trapped but the document is needed.
>> It is not a user permissions problem because the code can write csv 
>> files to the same folder.
>> 
>> It happens for both 4D v15.2 and v17.0 HF1. 
>> The computer is a cloud server VM running OS is Windows Server 2008 R2 
>> Datacenter / Service Pack 1.
>> 
>> Has anyone come across this or something like it?
>> Thanks, Keith
> 
> Keith,
> 
> try this pdf plugin http://www.node.de/indexplug.htm
> 
> regards Armin
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Isolating the Cause of a Server Crash

2018-08-31 Thread Spencer Hinsdale via 4D_Tech
reboot the computer. it has been running for 40 days?

> On Aug 31, 2018, at 1:54 PM, Dave Nasralla via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> One of our systems is crashing about every 3 days
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Help->v11 to v17 Upgrade or New?

2018-10-17 Thread Spencer Hinsdale via 4D_Tech

4D automatically converts Subtables. This should not be a problem.

> On Oct 17, 2018, at 12:45 PM, Robert ListMail via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> I have an old v11 database running on Windows that’s not particularly 
> well-designed and where there are more than a few subtables to deal with. 
> Assuming that there is no additional budget for writing a new clean app, 
> would you likely upgrade or re-write in v17 with the old v11 structure as 
> guide?  I’m concerned that the upgrade path will be difficult because of the 
> subtables and that by the time you deal with all of the legacy junk not this 
> database from the early 90s you could have created something fresh and new. 
> How might you approach this?
> 
> Also, the client originally said the new database would not have to migrate 
> data forward from the old system and now they are wanting to have the data 
> too.
> 
> Thanks,
> 
> Robert
> 
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Help->v11 to v17 Upgrade or New?

2018-10-18 Thread Spencer Hinsdale via 4D_Tech

It was Dani!  Yeah, 4D is awesome at this stuff.  We get upgrades old, old 
versions all the time and our current structure just opens these old data 
files, and 4d does its magic to uid them, unicode them, de'subtable them.  no 
problem.


> On Oct 18, 2018, at 2:19 PM, Robert ListMail via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Okay, I can’t find it now but someone said, "hey pop it into v17 and see if 
> it works…" or something like that. Well, I did just that and without any 
> changes it compiled (after toggling unicode on) and I created a built server 
> and client and ran a few tests. Yes, as I recall, I did fix all of the syntax 
> errors years ago. It seems to work for the most part (PICT icons and images 
> do not show and a couple of fields cannot be used for data entry, I’m sure 
> that’s an easy fix). I’m surprised this works at all! So, there are more than 
> 700 lines of code with the deprecated “_o_” prefix. Perhaps I could make a 
> lot of that go away via Search/Replace (a feature that I normally don’t use).
> 
> Thanks to all of you that have contributed. It looks like I can get this 
> running as it did before via v17 so that it can run on their new hardware 
> running the latest Windows server and Win10 clients…. Of course they want 
> this yesterday, so I could deliver the converted one and then upgrade 
> incrementally. Yes, it does look ugly as f*ck but sadly no one is complaining 
> about that.
> 
> Thanks,
> 
> Robert
> 
>> On Oct 17, 2018, at 3:11 PM, Spencer Hinsdale via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> 4D automatically converts Subtables. This should not be a problem.
> 
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: sending mail through Office365 using SMTP

2018-11-20 Thread Spencer Hinsdale via 4D_Tech
in the docs for Send there is an Exchange example that set Port
587. 
Spencer


> On Nov 20, 2018, at 2:58 PM, Chris Belanger via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Hi,
> 
> I have a client that has switched its email provider to use Office365.
> My app sends emails using SMTP_Send( ) perfectly well with other providers, 
> but not Office365.
> 
> Any help you may offer will be appreciated.
> 
> 
> my significant part of my code currently is:
> 
> Case of
> 
>: (Not(eMail_ERRCHECK ("SMTP_New";SMTP_New (SMTP_ID
>: (Not(eMail_ERRCHECK ("SMTP_Host";SMTP_Host (SMTP_ID;$Host;0
>: (Not(eMail_ERRCHECK ("SMTP_From";SMTP_From (SMTP_ID;$From;1
>: (Not(eMail_ERRCHECK ("SMTP_ReplyTo";SMTP_ReplyTo (SMTP_ID;$From;0
>: (Not(eMail_ERRCHECK ("SMTP_To";SMTP_To (SMTP_ID;$To;0
>: (Not(eMail_ERRCHECK ("SMTP_Cc";SMTP_Cc (SMTP_ID;$CC;0
>: (Not(eMail_ERRCHECK ("SMTP_Bcc";SMTP_Bcc (SMTP_ID;$BCC;0
>: (Not(eMail_ERRCHECK ("SMTP_Subject";SMTP_Subject 
> (SMTP_ID;$Subject;0
>: (Not(eMail_ERRCHECK ("SMTP_Body";SMTP_Body (SMTP_ID;$Body;0
>: (Not(eMail_ERRCHECK ("SMTP_Attachment";SMTP_Attachment_It 
> (SMTP_ID;$Attachments;2;0
>: (Not(eMail_ERRCHECK ("SMTP_Auth";SMTP_Auth 
> (SMTP_ID;True;<>Auth_UN;<>Auth_PW
>: (Not(eMail_ERRCHECK ("SMTP_Send";SMTP_Send (SMTP_ID;0
>: (Not(eMail_ERRCHECK ("SMTP_Clear";SMTP_Clear (SMTP_ID
> Else 
> $SentOK:=True
> End case 
> 
> SMTP_Auth( ) works without error, but then
> SMTP_Send( ) returns error:   10032 ‘Unknown or invalid response’
> 
> Thanks for any help,
> 
> Chris Belanger
> Innovative Solutions
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: auto update of clients

2017-03-02 Thread Spencer Hinsdale via 4D_Tech
19191 is the new-protocol error.  old clients can only update themselves if you 
use the old network layer option in compatibilty 
**
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: Copy or Drag from a listbox?

2017-03-06 Thread Spencer Hinsdale via 4D_Tech

http://kb.4d.com/assetid=49867 
**
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: Backup files - restoring backup

2017-03-13 Thread Spencer Hinsdale via 4D_Tech
Hi Pat,

Check the size of the log file.  This will give you some indication of how long 
it's been since last backup.  It is possible to have .journal without .4bk.



> On Mar 13, 2017, at 7:50 AM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> A client is getting the message:
> 
> "An error occured during the log file integration, it is recommended to
> restore the last backup of this database in order to attempt the
> integration of this log file""
> 
> I've told them how to restore the backup file manually but they say they do
> not have any files with the .4BK extension. Surely, if they didn't have any
> backup files, this message wouldn't even appear? If the database was
> damaged, they'd just get a "damaged database" error instead, if no backup
> had been set up? Right?
> 
> (They are using 4D v13.6, server).
> 
> I think the .bk files must be there somewhere - they just can't find them.
> 

**
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: Moving a window

2017-03-31 Thread Spencer Hinsdale via 4D_Tech

same works on windows except:
- modifier keys are different (see docs?)
- instead of one button, first hold right-mouse-click, then hold 
left-mouse-click TOO, then drag

> On Mar 31, 2017, at 6:26 AM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Should be easy enough ... right?
> Nope!
> Using Windows 7 (or any version of Windows, probably) we've opened a window
> in a new process, and it has somehow got itself moved up too far so that
> the title bar is hidden. On the Mac I can easily fix this by cmd+ctrl+click
> and drag. On Windows this can be done by typing Alt-spacebar-M. But that
> only works on the main 4D window - not the process window.
> 
> How can I move the process window if I don't have access to the title bar?
> 

**
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: v15.2 clients logging into v15.4 server

2017-04-18 Thread Spencer Hinsdale via 4D_Tech

+1

and certified for Sierra, Touchbar

> On Apr 18, 2017, at 7:39 AM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:

> Otherwise 15.4 is very stable in my opinion.
> 
**
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: Bar code

2017-05-08 Thread Spencer Hinsdale via 4D_Tech

Try PNG. I think scaling does not work with SVG because of crisp edges.

-Spencer

> On May 8, 2017, at 1:57 AM, stardata.info via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hello,
> 
> I try to use Picture:=Picture*,09 but not work because some part of bar code 
> are differents
> 
> Thanks
> Ferdinando
> 
**
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: printing listbox v 15.4hf2

2017-05-17 Thread Spencer Hinsdale via 4D_Tech

I think someone recently posted a link to 4d today:
http://www.4dtoday.com

there is a generic list box print routine on the home page

however, since the host is in Australia it appears the site is actually 4D 
TOMORROW  :)

> On May 17, 2017, at 9:56 AM, Timothy Penner via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Hi Chuck,
> 
> There is an example in the docs:
> http://doc.4d.com/4Dv15/4D/15/LISTBOX-GET-PRINT-INFORMATION.301-2007323.en.html
> 

**
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: Need plugin that will set macOS window modified indicator

2017-06-08 Thread Spencer Hinsdale via 4D_Tech
Awesome!

I tried this and am having a problem creating a generic usage for "current 
window"...

I get compiler errors:
the result of the function is not compatible with the expression
this value cannot be passed as a parameter to this method or command

from this line of code:
WINDOW SET ENABLED (Current form window;Window document modified;True)


Thanks!

Spencer

> On Jun 7, 2017, at 6:47 PM, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> just posted:
> 
> https://github.com/miyako/4d-plugin-window-button
> 
>> 2017/06/08 4:25、Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> のメール:
>> 
>> I’m looking for a plugin that can be used with 4D v14+ to set the window 
>> modified indicator. You know the little black dot in the center of red close 
>> button in the window title bar.
>> 
>> I found a Miyako plugin called “Carbon Window Manager” but it specifically 
>> states it only works with old style Carbon windows. Newer versions of 4D 
>> have native Cocoa windows.
>> 
>> Miyako do you have a plug that works with current versions of 4D?
> 
> 
> 
> **
> 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: Need plugin that will set macOS window modified indicator

2017-06-08 Thread Spencer Hinsdale via 4D_Tech
compiled!

thanks, Jeremy!

> On Jun 8, 2017, at 6:37 AM, Jeremy Roussak via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Try using 1 and 0 instead of True and False for the third parameter.
> 
> Jeremy
> 
> 
> Jeremy Roussak
> j...@mac.com
> 
> 
> 
>> On 8 Jun 2017, at 14:00, Spencer Hinsdale via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>> 
>> Awesome!
>> 
>> I tried this and am having a problem creating a generic usage for "current 
>> window"...
>> 
>> I get compiler errors:
**
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: Big Commerce v3 API

2017-06-11 Thread Spencer Hinsdale via 4D_Tech
can't you "manually" enter this detail, then get to see format, then put same?

-spencer

On Jun 11, 2017, at 12:33 AM, J. Douglas Cryer via 4D_Tech 
<4d_tech@lists.4d.com> wrote:

>> An unlikely ask but:
> 
>> Has anyone out there had any experience with integrating to Big Commerce
>> v3API?  I have done an integration but I am stuck on a very specific
>> issue of trying to add variants to an existing product.  BC
>> Documentation, Community and Support are all a bit useless for this kind
>> of detail.
> 
> Regards, Dougie
> 
> 
> 
> 
> 
> 
> **
> 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: Rotate Picture in 4D

2017-06-25 Thread Spencer Hinsdale via 4D_Tech

did you try 270?

> On Jun 25, 2017, at 12:51 PM, Peter Mew via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi
> I am trying to use Miyako's rotate picture component in v13.
> I dont know if its not compatible but It wont run.
> So Ive extracted the code and made it a subroutine (Rotate_Picture)
> 
> C_PICTURE($1;$0)
> C_REAL($2;$w;$h;$ww;$hh;$s;$c)
> 
> PICTURE PROPERTIES($1;$w;$h)
> 
> $s:=Sin($2*Degree)
> $c:=Cos($2*Degree)
> 
> $ww:=($w*$c)+($h*$s)
> $hh:=($w*$s)+($h*$c)
> 
> $svg:=SVG_New ($ww;$hh)
> $g:=SVG_New_group ($svg)
> $image:=SVG_New_embedded_image ($g;$1;($ww/2)-($w/2);($hh/2)-($h/2))
> SVG_SET_TRANSFORM_ROTATE ($g;$2;$ww/2;$hh/2)
> 
> $0:=SVG_Export_to_picture ($svg)
> SVG_CLEAR ($svg)
> 
> 
> I then Call
> New_Picture:=Rotate_Picture(Old_Picture;degrees)
> 
> If I call this routine with 90 as the rotation degrees it works, if I try
> with -90 degrees it doesnt. Can anyone see why and suggest a modification
> to make it so
> thanks
> -pm
> **
> 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: Error -19191

2017-06-27 Thread Spencer Hinsdale via 4D_Tech
this is cant use new network layer from old clients...
http://kb.4d.com/assetid=77427 

Spencer


> On Jun 27, 2017, at 6:15 AM, Douglas Cryer via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi,
> 
> We have a client trying to connect to a database from Austria and they are 
> getting a -19191 error when trying to connect.
> 
> Anyone know what this error is?
> 
> Regards,  Dougie
> 
> 
> telekinetix Limited- J. Douglas Cryer
> Phone : 01234 761759  Mobile : 07973 675 218
> 2nd Floor Broadway House, 4-6 The Broadway, Bedford MK40 2TE
> Email : jdcr...@telekinetix.com   Web : 
> http://www.telekinetix.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
> **

**
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: Packages-building an installer

2017-07-11 Thread Spencer Hinsdale via 4D_Tech

Assuming you are talking about Apple's PackageMaker, you can use a shell script 
to set read-write.  For the Package there is a Scripts tab with an entry for 
Postinstall that will run after install.  I think you are using this for 
AppleScript already.

You can create a shell script by going to Terminal and typing "pico" to run the 
text editor.

Then type a script like:
#!/bin/sh
chmod -R 777 '/Applications/MyApp'

Type control-x (shown as ^x at the bottom of the window) to eXit and follow 
prompts to save as something like "myscript".

Back in Package, Scripts, Postinstall select your script (/Users/me/myscript).  
This script just says use bourne shell (bin/sh) set all contents (-R) to 
read-write for all (777).

hth,


Spencer


> On Jul 11, 2017, at 4:12 AM, Nigel Greenlee via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Hi
> 
> I wondered if anyone else has used ‘Packages’ for creating an installer(maybe 
> you can suggest a similar product). I am creating a simple installer for an 
> in-house application-i will rather give the users a link to an installer than 
> a .zip as they have a habit of installing stuff on the desktop.(this is on 
> OSX only)
> 
> I know this is slightly ‘off topic'
> 
> I am however having two problems:-
> 
> The first is with permissions. If i zip the .4dbase up and send it to a 
> machine the installed app runs fine. However when i create an installer 
> package(with user persmissions set to Owner Root and user Admin(i also tried 
> user Wheel) The installed application does not have the correct permissions 
> and wants to open read only. I wondered if anyone has a suggestion to 
> overcome that.
> 

**
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: Serious 4D Internet commands issue in v15.4 with SMTP on Mac OS X

2017-07-26 Thread Spencer Hinsdale via 4D_Tech

Hi Paul,

Look at forms being used for data entry to see if these text fields have the 
Multi-style checkbox checked in Properties.

Here is a v14 picture:
http://kb.4d.com/assetid=77175

And v15 feature:
http://livedoc.4d.com/4D-Design-Reference-15.4/Properties-for-active-objects/Multi-style-Rich-text-area.300-3285451.en.html




> On Jul 25, 2017, at 9:36 PM, Paul Lovejoy via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> It seems this does not do the trick in all instances.
> 
> It appears there may be a problem with the text in the fields. I exported to 
> text and everything looks fine but some texts truncate with a “?” when the 
> email is sent. I have re-typed some of the offending texts and they work 
> fine. The strange thing is they are identical, character-to-character, to the 
> texts that are truncating in the emails. Could it be something to do with a 
> length byte or something else that 4D stores along with the text in the 
> fields?
> 
> 

**
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: 4D Forums no longer accessible -- too many redirects

2017-07-27 Thread Spencer Hinsdale via 4D_Tech

they have implemented Single Sign On.  there was a banner that took me to 
partners sign-on, then a button to "migrate forums logon" or some such.  sorry 
to be vague. :)


> On Jul 27, 2017, at 8:17 AM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Is there a new way to access forums.4d.fr? For the past few days I haven't 
> been able to reach this site -- Safari displays an error saying too many 
> redirects.
> 
> 
> **
> 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: 4D Forums no longer accessible -- too many redirects

2017-07-27 Thread Spencer Hinsdale via 4D_Tech

I guess I should have mentioned that it works fine for me, just the sign-on is 
new and improved

> On Jul 27, 2017, at 8:18 AM, Spencer Hinsdale  wrote:
> 
> 
> they have implemented Single Sign On.  there was a banner that took me to 
> partners sign-on, then a button to "migrate forums logon" or some such.  
> sorry to be vague. :)
> 
> 
>> On Jul 27, 2017, at 8:17 AM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com 
>> <mailto:4d_tech@lists.4d.com>> wrote:
>> 
>> Is there a new way to access forums.4d.fr <http://forums.4d.fr/>? For the 
>> past few days I haven't been able to reach this site -- Safari displays an 
>> error saying too many redirects.
>> 
>> 
>> **
>> 4D Internet Users Group (4D iNUG)
>> FAQ:  http://lists.4d.com/faqnug.html <http://lists.4d.com/faqnug.html>
>> Archive:  http://lists.4d.com/archives.html 
>> <http://lists.4d.com/archives.html>
>> Options: http://lists.4d.com/mailman/options/4d_tech 
>> <http://lists.4d.com/mailman/options/4d_tech>
>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com 
>> <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: Heads Up about Write Pro Style Transformations

2017-08-01 Thread Spencer Hinsdale via 4D_Tech
i'm confused.  he's getting the right plain text. isn't he saying that if there 
were an emphatic style that displayed . as ! then the plain text ought to 
change to ! too ?

> On Aug 1, 2017, at 1:05 PM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Keith,
> If you used ST Get Text instead of Get Plain Text, then you maybe could
> strip out the style tags and end up with the correct plain text? (I haven't
> tried this).
> 
> Pat
> 
> On 1 August 2017 at 15:08, Keith Culotta via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
> 
>> Well, It looks like this has been declared standard behavior.  I can't say
>> it's unexpected to see the words "style" and "cosmetic" in the same
>> vicinity.  I question their use with a text "transformation".  This is more
>> about user expectations.  "a" and "A" have always been understood, by
>> technical and non-technical users, to be two different character values.
>> 
>> Transforming a character from one case to another changes the value of the
>> character in Text Edit, Word, other 4D commands, and so on.  In Write Pro
>> there is no way to tell which character is in the text.  Suppose a client
>> wants their customer name list to be Capitalized.  Write Pro would be a
>> great tool for that, except the final product would be wrong.  They are
>> unable to depend on the data.
>> 
>> All users of any software that I have met, have an expectation that the
>> case of a character is a "real" thing, and the attributes like bold, etc...
>> are the "cosmetic" part.  It seems unfortunate to introduce this kind of
>> ambiguity.
>> 
>> Keith - CDI
>> 
>>> On Aug 1, 2017, at 4:10 AM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com>
>> wrote:
>>> 
>>> Hi Keith,
>>> I suppose it could be argued that ST Get Plain Text gets plain (i.e.,
>>> unstyled) text ... text in its raw form ... but I agree with your point
>> of
>>> view.
>>> 
>>> Pat
>>> 
>>> On 31 July 2017 at 15:09, Keith Culotta via 4D_Tech <
>> 4d_tech@lists.4d.com>
>>> wrote:
>>> 
 This is something to be aware of if you plan to use Write Pro text
>> outside
 of Write Pro areas.
 
 A bug report has been submitted, but for now Write Pro Style
 Transformations are cosmetic only.
 
 For instance, if you apply the Write Pro transformation
 Uppercase to "This is a Test",
 you will see "THIS IS A TEST" in the document.
 
 If you copy the text, or retrieve it using "ST Get plain text", you end
>> up
 with "This is a Test".
 
 Keith - CDI
 **
 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
 **
>>> 
>>> 
>>> 
>>> 
>>> --
>>> *
>>> CatBase - Top Dog in Data Publishing
>>> tel: +44 (0) 207 118 7889
>>> w: http://www.catbase.com
>>> skype: pat.bensky
>>> *
>>> **
>>> 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
>> **
>> 
> 
> 
> 
> -- 
> *
> CatBase - Top Dog in Data Publishing
> tel: +44 (0) 207 118 7889
> w: http://www.catbase.com
> skype: pat.bensky
> *
> **
> 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: 4D server "pausing" every 15 minutes

2017-08-24 Thread Spencer Hinsdale via 4D_Tech
could this have anything to do with new volume shadow copy feature?


> On Aug 24, 2017, at 8:05 AM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I just made a very interesting discovery and thought I'd share it with the 
> group -- it's timely given the recent blog post by 4D about dashboards.
> 
> We're huge fans of dashboards here at Sweetwater, and our dashboard tool of 
> choice is Prometheus. We use this on all our major servers -- Exchange, 
> Postgres, MySQL, and others.  We decided to add our 4D Server to the mix. 
> This server is a 24-core Dell server running Windows Server 2012 Datacenter, 
> and it hosts, at peak, around 540 simultaneous 4D users and around 3000-3500 
> 4D processes. It runs great and it is extremely stable.
> 
> For the 4D Server dashboard, we feed certain statistics directly from 4D via 
> a SQL function call (poor-man's web service), and we recently installed the 
> Prometheus wmi_exporter tool which exports operating system-related data from 
> the Windows Management Instrumentation Service (WmiPrvSE.exe) into Prometheus 
> format.  The wmi_exporter tool is very fast and you have to look fast to see 
> it consume any resources at all, but when it is running, the Microsoft 
> WmiPrvSe.exe process periodically wakes up and consumes 4% of our 24-core 
> server for 10-12 seconds. This happens about once every 15 minutes.
> 
> When this is happening, 4D Server slows to a crawl. Clients start to 
> beach-ball, pause, or have their network connections broken and throw runtime 
> errors. Some astute users actually noticed this 15 minute cycle, and after I 
> dug into it it turns out that is exactly the case and is 100% reproducible.
> 
> We had the dashboard turned on all day Tuesday, and we received dozens of 
> support tickets from users complaining about slow performance in 4D. On 
> Wednesday, we ran without the seemingly harmless wmi_exporter service 
> enabled, and we didn't receive a single support ticket.
> 
> My guess is that wmi_exporter may be asking for a particular statistic that 
> takes Windows a significant amount of time to collect. We may try to scale it 
> back and turn our measured statistics on one by one until we can determine 
> the problem. But until then, we can live without the dashboard (beautiful as 
> it was on the 60-inch 4K display...).
> 
> Jeff
> **
> 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: Edit in list / subform / 4D v16

2017-09-12 Thread Spencer Hinsdale via 4D_Tech

read write([contacts])?

> On Sep 12, 2017, at 4:15 AM, Two Way Communications via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> I thought this would be a no brainer but it’s starting to become a nuisance…
> 
> I create a subform for a table [Contacts] inside the form for the table 
> [Customers]
> The subform is set to display the [Contacts] Output form, is set to ‘Edit in 
> list’ etc.
> 
> However, when I display the list of [Contacts] inside my [Customers] input 
> form, they display fine, are selectable.
> 
> There is NO WAY however to ‘edit in list’. Whatever I do. Click, long click, 
> etc.
> And yes, the fields are set to be ‘enterable’.
> 
> This is 4D v16.1, on Mac OS Yosemite, 4D developer mode.
> 
> 
> Am I overlooking something or just getting old? ;-)
> 

**
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: QUERY BY ATTRIBUTE is slow af

2017-09-12 Thread Spencer Hinsdale via 4D_Tech

isn't there some trick to use a character code instead of at?  

and does the "beginning and end" pref possibly apply?

> On Sep 12, 2017, at 8:22 AM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Trying to figure out why our experience with QUERY BY ATTRIBUTE is so 
> different than the demos at the last 4D Summit.
> 
> We're running 4D Server 16.2 64-bit on Windows. The Invoices table has about 
> 9 million rows, and we added an index to the Extra field in this table which 
> is an object field.
> 
> The following query always runs sequentially - i.e. very very slowly. 
> Thinking it might be a wildcard issue with the email we also tried strings 
> with no '@', but no matter what we do the query runs sequentially.
> 
> QUERY BY ATTRIBUTE \
>  ([Invoices];\
>   [Invoices]Extra;\
>   "gift_card_line_items[].to_email";=;"desig...@sweetwater.com")
> 
> 
> What are we doing wrong here? The query returns one row, 20 minutes later.
> **
> 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: MSC: why "Checking list of deleted records ..." persists?

2019-01-12 Thread Spencer Hinsdale via 4D_Tech
Hi Kirk,

Isn’t there an option for Compact to drop Address Tables?  This invalidates any 
Log Files but gives table(s) a clean start. There is a function like Table 
Fragmentation which returns ratio of remaining record to total address table. 
Sorry not at computer...

Spencer

> On Jan 12, 2019, at 8:12 AM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> A few months ago a bug resulted in a large number of records being created
> in a table ([email_que]) by mistake. Bug was fixed and 1 or 2 million bogus
> records were deleted.
> 
> Since then the data file has been verified and compacted at least once.
> 
> Just now I was running a verify on the data file again and notice 4D
> spending a - very - long - time verifying that table. Looking at the verify
> log I notice a few, but not all, tables with this message listed by them.
> 
> The table property "Records are definitively deleted" is not checked for
> [email_que]. At least one other table with the message do have it checked.
> 
> I have to assume it's connected with the the large selection that was
> deleted. But given that I would expect a repair/compact operations to have
> resolved it.
> 
> Anyone else run into this?
> 
> Thanks
> -- 
> Kirk Brooks
> San Francisco, CA
> ===
> 
> *We go vote - they go home*
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: AWS Experts - Need a little help

2019-01-14 Thread Spencer Hinsdale via 4D_Tech


Check that you are using the public ip displayed on the desktop not on server 
admin window...

On 1/14/19, 1:01 PM, "4D_Tech on behalf of Randy Engle via 4D_Tech" 
<4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:

I'm testing an app on AWS (LightSail Account)

I've got a very lightweight app running on 4D Server (v17) Windows running 
on an instance of AWS.

I'm not able to connect 4D Client (from my location) to the 4D Server on AWS


**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: AWS Experts - Need a little help

2019-01-14 Thread Spencer Hinsdale via 4D_Tech

did you edit Security Groups to add 4D ports 19812 to 19814?

> On Jan 14, 2019, at 2:15 PM, Randy Engle via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Spencer, thanks for the tip.
> 
> Yes, I'm using the public IP address
> (Same address that I use to connect via RDC)
> 
> No workie!
> 
> ;-(
> 
> Randy Engle 
> 
> Check that you are using the public ip displayed on the desktop not on server 
> admin window...
> 
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Making sense of a crash report

2019-01-18 Thread Spencer Hinsdale via 4D_Tech


I don't know, but it seems weird the app appears to be in a system folder...

Shouldn't this say, Path: /Applications/Catbase8.app?

hth

On 1/18/19, 5:23 AM, "4D_Tech on behalf of Pat Bensky via 4D_Tech" 
<4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:

Path:  /private/var/folders/*/CatBase
8.app/Contents/MacOS/CatBase 8
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: 4D 17.1 network issues

2019-04-24 Thread Spencer Hinsdale via 4D_Tech

Hi John,

Just checking...

If you go to Apple menu, System Preferences on the mini, for Network do you see 
more than one green dot?  Each is separate network connection, where you can 
click Advanced and go to TCP/IP tab for details.  Is not unheard of for someone 
to set up Ethernet and Wi-Fi.

Back in System Preferences, Energy Saver, you probably want Prevent Computer 
From Sleeping on all computers, but especially server.  It is common for an 
upgrade of computer or system to reset this, to be green.

That said, be aware that 16.4 used New Networking only, which allows Clients to 
sleep.  It is possible, if you have the Compatibility checkbox (in 4D Server, 
File menu, Database Settings) set to Use Legacy Network Layer that this works 
in 17.1 and would cause the errors below if Clients did Sleep.  This checkbox 
would have no effect (and different text) in 16.4 and Clients could Sleep and 
wake no problem.  Maybe all you need is to uncheck this.

Hope this makes sense.

-Spencer



On 4/24/19, 4:54 AM, "4D_Tech on behalf of John DeSoi via 4D_Tech" 
<4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:

Since I upgraded from 16.4 to 17.1 (all Mac), users have been complaining 
about 4D Client disconnects. Messages like:

"The current connection to the database has been disrupted. Connection 
error with the server. Please restart the application."

"Unknown Error. Connection error with the server. Please restart the 
application."

It is an all local single switch network with default timeouts. I 
experimented with changing timeouts, but it did not help.

The server hardware also changed (new 2018 Mac Mini), so I'm looking into 
that. One curious thing I noticed is the "Application Server" tab shows it to 
be listening on two IP addresses: 192.168.X.X and 169.254.X.X. The 192 address 
is expected and the only active network connection on the computer. Why would 
the server be listening on a 169 link-local address and where did that come 
from? I don't see that when I run the server on my laptop under the same 
operating system (10.14 Mojave).

Digging into it with Wireshark is next, but hoping someone might suggest an 
easier path.

John DeSoi, Ph.D.


**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: creating a plain text document from within 4D

2019-05-27 Thread Spencer Hinsdale via 4D_Tech

does “” work?

i always type  for break tag

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: 4D Mobile App

2019-07-20 Thread Spencer Hinsdale via 4D_Tech
Hi Dave,

I would assume you need a License for Developer and to be running Interpreted...

Go to Help menu, Licenses to see if you have "Developer".  If you just switched 
to R, you may need to re-enter.

Restart 4D, go to Open, select your Structure, and in bottom left of Finder 
window click Options.  Is it set to Open > Interpreted Database?  If you 
compile and test in 4D, it may automatically re-open in Compiled mode.

FYI, R5 was released yesterday.

I had not tried Mobile till I saw your email and now (55 min later) I have 
first test app running in iPhone XR Simulator and it totally works!

Amazing!

-spencer




On 7/20/19, 7:19 AM, "4D_Tech on behalf of Dave Tenen via 4D_Tech" 
<4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:

I am trying to learn the procedure and tutorial for 4D Mobile Apps

I am having a problem where the menu item “ Mobile Project” is not active!
I have gone trough the steps in the tutorial to setup, launch and run the 
Mobile Project item in the New Menu, except it is not available to choose 
(grayed out).  
I am running 4d v17r4 on a MacBook pro running 10.14.5
Do I need a different version of 4D?

Any ideas on how to fix this?


Thanks in advance,
Dave Tenen


Personal Chef 

Coming to you from Spec Pond and I swear the fish was
[]
this big

dte...@me.com



Dave Tenen


Personal Chef 

Coming to you from Spec Pond and I swear the fish was
[]
this big

dte...@me.com

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

  1   2   >