Re: Check mark strangeness

2018-08-22 Thread JOHN BAUGHMAN via 4D_Tech
A bit more information. The discrepancy in the debugger the where 2 appears for 
a check mark only happens in v15 not v16.

I am fixing this in v16R6 in a data file that that has seen life through 
versions of 4D since version 3 days. It contains 3,702 records with the flag 
field set to the superscript 2 and 89,934 records contain a check mark.

The v15 and v16 structures do not contain a check mark in the code only the 
superscript 2. Somewhere along the line I think the check mark got corrupted 
such that it was converted in the structure to the superscript 2. 



> On Aug 22, 2018, at 5:56 PM, JOHN BAUGHMAN via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> For many years now I have been using a check mark, option-v on a Mac, to flag 
> a particular field. Today while working on a web site that was consuming that 
> field the site the field crashed the site when it contained the check mark. 
> When I traced it I discovered that the field in the debugger displayed with a 
> superscripted 2.
> 
> If I search for records with the with the check mark using the following code 
> it finds those records correctly…
> 
> QUERY([Appointment] ;[Appointment]In_chair="√”)
> 
> When that same line of code is viewed in the debugger it looks like this...
> 
> QUERY([Appointment];[Appointment]In_chair="²”)
> 
> I am going to change √ to #, but I am wondering if anyone can explain this 
> strangeness? Is it a unicode thing?
> 
> John
> 
> 
> John Baughman
> 1331 Auwaiku Street
> Kailua, Hawaii  96734
> (808) 262-0328
> john...@hawaii.rr.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
**

Check mark strangeness

2018-08-22 Thread JOHN BAUGHMAN via 4D_Tech
For many years now I have been using a check mark, option-v on a Mac, to flag a 
particular field. Today while working on a web site that was consuming that 
field the site the field crashed the site when it contained the check mark. 
When I traced it I discovered that the field in the debugger displayed with a 
superscripted 2.

If I search for records with the with the check mark using the following code 
it finds those records correctly…

QUERY([Appointment] ;[Appointment]In_chair="√”)

When that same line of code is viewed in the debugger it looks like this...

QUERY([Appointment];[Appointment]In_chair="²”)

I am going to change √ to #, but I am wondering if anyone can explain this 
strangeness? Is it a unicode thing?

John


John Baughman
1331 Auwaiku Street
Kailua, Hawaii  96734
(808) 262-0328
john...@hawaii.rr.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 Write Pro Formatting Text Fields

2018-08-22 Thread Mikey via 4D_Tech
How do you do display formats in the new 4D Write Pro?  You used to have an
option to format the output, e.g. phone numbers.  That does not seem to
exist any more...or does it?
-- 
On the first day, God created the heavens and the Earth
On the second day, God created the oceans.
On the third day, God put the animals on hold for a few hours,
   and did a little diving.
And God said, "This is good."
**
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
**

Remove Remembered Password

2018-08-22 Thread Tim Nevels via 4D_Tech
Here is some code I wrote today due to a request by a client to stop allowing 
users to remember their password when using the built in 4D user login window. 
This is that “Remember password” checkbox that you can’t make go away. The 
workaround is to just delete the file that stores the user name and password 
that is remembered. 

There is an article in the 4D Knowledge Base about this, but it is for older 
versions of 4D where the path to this saved “.mdp” file has different. I used 
that as a starting point and the got it to work with the 4D v14 version that I 
needed. Should work with 4D v14+. 

Works on macOS and Windows. You do need to provide the “application name” 
because I could not reliably determine this with so many possible variations 
like: using 4D, using merged single-user application, using merged client 
application or user has changed the application name. 

  // ===
  // PROJECT METHOD: RemoveRememberedPassword

  // PARAMETERS: $1 = application name

  // DESCRIPTION: When using the 4D password system
  // you can choose the "Remember password" option which 
  // will save your username and password. This will allow 
  // you to bypass the login prompt and automatically log in from then on.

  // When the "Remember Password" option is selected, the 4D user name
  // and password are saved to a file. File name is the application name+".mdp"
  // This method will delete that file, if it exists.

  // Should work with 4D v14+ versions. (Unless they change the location, 
again.)

  // Windows path
  // C:\Users\{username}\AppData\Roaming\{applicationName}\Favorites 
v{applicationMajorVersion}\Remote\

  // macOS Path
  // /users/{username}/Library/Application 
Support/{applicationName}/Favorites v{applicationMajorVersion}/Remote/

  // CREATED BY: Tim Nevels, Innovative Solutions ©2018
  // DATE: 8/22/18
  // LAST MODIFIED: 
  // 
C_TEXT($1;$applicationName_t)
$applicationName_t:=$1

  // declare local variables
C_TEXT($applicationMajorVersion_t;$filePath_t)

  // get 4D application major version
$applicationMajorVersion_t:=Substring(Application version;1;2)

  // strip off extension
If (<>macOS)
   $applicationName_t:=Replace string($applicationName_t;".app";"")
Else 
   $applicationName_t:=Replace string($applicationName_t;".exe";"")
End if 

  // build file path to the .mdp file
$filePath_t:=Get 4D folder(Active 4D Folder)+"Favorites 
v"+$applicationMajorVersion_t+Folder separator+\
   "Remote"+Folder separator+$applicationName_t+".mdp"

  // delete file if it is there
If (Test path name($filePath_t)=Is a document)
   DELETE DOCUMENT($filePath_t)
End if 


Tim

*
Tim Nevels
Innovative Solutions
785-749-3444
timnev...@mac.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 Text Messages From 4D

2018-08-22 Thread Wayne Stewart via 4D_Tech
I used clickatell for a 4D summit presentation a few years back.  It
allowed two way communication.

Regards,

Wayne



On Thu, 23 Aug 2018 at 00:04, Tim Nevels via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> I have a client that has asked me to add the option to send text messages to 
> cell phones from 4D. I know this is possible via some websites or web 
> services for a fee. Has anyone done this and can recommend a web service that 
> you were able to use from 4D to do this?
>
> Tim
>
> *
> Tim Nevels
> Innovative Solutions
> 785-749-3444
> timnev...@mac.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
**

RE: Sending Text Messages From 4D

2018-08-22 Thread David Ringsmuth via 4D_Tech
Tim,

I’ve integrated https://www.data24-7.com/index.php#pricing into one 4D system.

It’s fairly cheap ($12/mo + $0.005 per lookup), and the lookups are stored 
locally, so they are one-time.

David Ringsmuth

From: Tim Nevels via 4D_Tech
Sent: Wednesday, August 22, 2018 9:04 AM
To: 4d_tech@lists.4d.com
Cc: Tim Nevels
Subject: Sending Text Messages From 4D

I have a client that has asked me to add the option to send text messages to 
cell phones from 4D. I know this is possible via some websites or web services 
for a fee. Has anyone done this and can recommend a web service that you were 
able to use from 4D to do this?

Tim

*
Tim Nevels
Innovative Solutions
785-749-3444
timnev...@mac.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
**

Re: Sending Text Messages From 4D

2018-08-22 Thread Tim Nevels via 4D_Tech
On Aug 22, 2018, at 2:00 PM, Jim Hassler wrote:

> We had a need to send texts to company employees so we have the luxury of 
> knowing the cell phone provider.  So, we use something like this…
> 
> Case of
> 
>: ([User]Company Cell Phone Provider="AT&T")
> 
>   aEmailAddress{1}:=$cellPhoneNum+"@txt.att.net"
> 
>   emSEND EMAIL ("Linbeck Lean Video";<>CR+[Video]Web 
> Address;$fromAddress;"aEmailAddress";"";"";"")
> 
> 
>: ([User]Company Cell Phone Provider="Verizon")
> 
>   aEmailAddress{1}:=$cellPhoneNum+"@vtext.com"
> 
>   emSEND EMAIL ("Linbeck Lean Video";<>CR+[Video]Web 
> Address;$fromAddress;"aEmailAddress";"";"";"")

Thanks for the info. Several people have responded that most providers have a 
free email service that allows sending a text. I’d love to be able to do this, 
but for this client it’s just not possible to always get the person’s cell 
phone provider. So we will have to use a pay service.

Of all the SMS web services out there twilio.com seems to be the most popular 
with 4D developers. I have a few say they can provide me with some code to do 
the http work with Twilio’s API. So I’ll probably go that route.

It was a bit unclear to me exactly what the cost is with Twilio. Their website 
lists many services available for sending and receiving SMS and even MMS. From 
what I could gather it costs about $1.00 a month for the pay-as-you-go option, 
and 1 cent for each SMS sent. 

It is not exactly 1 cent for every SMS because you pay Twilio $0.0075 for each 
SMS and they you pay another fee to the carrier of the person’s cell phone. 
AT&T is $0.0025 per SMS and Sprint is $0.005 per SMS. In any event the cost 
seems incredibly low. 

If someone knows the exact pricing scheme for Twilio, I’d love to hear it. I’m 
not sure I completely understand it. 

One other question is do you need a cell phone account to send SMS with Twilio? 
If so, I guess the company could get a cell phone for the business and just 
never use it. It would be just so you could send SMS via 4D. 

Tim

*
Tim Nevels
Innovative Solutions
785-749-3444
timnev...@mac.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 16.3HF4 Windows 64 bit?

2018-08-22 Thread Ben Kershaw via 4D_Tech
Is there a 64 bit version of v16.3HF4 for Windows? I don’t see any 64 bit 
Windows versions in the hotfix area on the forums. I see the server, but not 
the single user/client version.

If I need 64 bit Windows clients, am I forced into using an R release?

Thanks,
Ben Kershaw
**
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 Text Messages From 4D

2018-08-22 Thread Jim Hassler via 4D_Tech
Tim,

We had a need to send texts to company employees so we have the luxury of 
knowing the cell phone provider.  So, we use something like this…


Case of

: ([User]Company Cell Phone Provider="AT&T")

aEmailAddress{1}:=$cellPhoneNum+"@txt.att.net"

emSEND EMAIL ("Linbeck Lean Video";<>CR+[Video]Web 
Address;$fromAddress;"aEmailAddress";"";"";"")



: ([User]Company Cell Phone Provider="Verizon")

aEmailAddress{1}:=$cellPhoneNum+"@vtext.com"

emSEND EMAIL ("Linbeck Lean Video";<>CR+[Video]Web 
Address;$fromAddress;"aEmailAddress";"";"";"")



End case

Jim Hassler

On Aug 22, 2018, at 9:04 AM, Tim Nevels via 4D_Tech 
<4d_tech@lists.4d.com> wrote:
I have a client that has asked me to add the option to send text messages to 
cell phones from 4D. I know this is possible via some websites or web services 
for a fee. Has anyone done this and can recommend a web service that you were 
able to use from 4D to do this?
Tim
*
Tim Nevels
Innovative Solutions
785-749-3444
timnev...@mac.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 Text Messages From 4D

2018-08-22 Thread Keith Culotta via 4D_Tech
This has been working for us, but we only use it occasionally. 

$err:=SMTP_QuickSend 
($Host;$FromAddress;$msgTo;$subject;$message;0;25;$vAuthUserName;$sequence) 
where $msgTo is a text/phone# like 555...@vtext.com

Keith - CDI

> On Aug 22, 2018, at 9:04 AM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I have a client that has asked me to add the option to send text messages to 
> cell phones from 4D. I know this is possible via some websites or web 
> services for a fee. Has anyone done this and can recommend a web service that 
> you were able to use from 4D to do this?
> 
> Tim
> 
> *
> Tim Nevels
> Innovative Solutions
> 785-749-3444
> timnev...@mac.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
**

Re: Sending Text Messages From 4D

2018-08-22 Thread Dani Beaubien via 4D_Tech
I have been using http://plivo.com and it has worked well. I use it for sending 
out PIN #s for people to use when logging in.

Dani


> On Aug 22, 2018, at 8:10 AM, Darin Schroeder via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Tim, we've been using Twilio with a lot of success.
> 
> https://www.twilio.com/sms
> 
> Darin
> 
> On Wed, Aug 22, 2018 at 9:04 AM Tim Nevels via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
> 
>> I have a client that has asked me to add the option to send text messages
>> to cell phones from 4D. I know this is possible via some websites or web
>> services for a fee. Has anyone done this and can recommend a web service
>> that you were able to use from 4D to do this?
>> 
>> Tim
>> 
>> *
>> Tim Nevels
>> Innovative Solutions
>> 785-749-3444
>> timnev...@mac.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
> **

**
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 Text Messages From 4D

2018-08-22 Thread Jeffrey Kain via 4D_Tech
Same here. 

> On Aug 22, 2018, at 10:10 AM, Darin Schroeder via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Tim, we've been using Twilio with a lot of success.
> 
> https://www.twilio.com/sms

**
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 Text Messages From 4D

2018-08-22 Thread Darin Schroeder via 4D_Tech
Tim, we've been using Twilio with a lot of success.

https://www.twilio.com/sms

Darin

On Wed, Aug 22, 2018 at 9:04 AM Tim Nevels via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> I have a client that has asked me to add the option to send text messages
> to cell phones from 4D. I know this is possible via some websites or web
> services for a fee. Has anyone done this and can recommend a web service
> that you were able to use from 4D to do this?
>
> Tim
>
> *
> Tim Nevels
> Innovative Solutions
> 785-749-3444
> timnev...@mac.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
**

Re: Sending Text Messages From 4D

2018-08-22 Thread Patrick Emanuel via 4D_Tech
I know the Bertrand Soubeyrand provide a product doing this.
https://www.soubeyrand-4d-developer.eu/



-
Patrick EMANUEL

Administrator
www.association-qualisoft.eu 
(Soft1002, Simply Asso & QS_Toolbox)
--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
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
**

Sending Text Messages From 4D

2018-08-22 Thread Tim Nevels via 4D_Tech
I have a client that has asked me to add the option to send text messages to 
cell phones from 4D. I know this is possible via some websites or web services 
for a fee. Has anyone done this and can recommend a web service that you were 
able to use from 4D to do this?

Tim

*
Tim Nevels
Innovative Solutions
785-749-3444
timnev...@mac.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: Switching to design mode fails (v13)

2018-08-22 Thread Chip Scheide via 4D_Tech
Corrupted user?

Try a repair on the structure
Chip

On Wed, 22 Aug 2018 02:27:04 -0700 (MST), fpoeck via 4D_Tech wrote:
> I have a 4D v13 development server (interpreted client/server setup) here,
> which i am using since several years. Until this week i was able switch to
> design mode by either
> 
> * closing the main window of my application (on the client side) OR
> * use a menu entry which points to the default action "Design"
> 
> Problem:
> If i choose one of the 2 methods above now it seems like it switches to the
> development/design environment, but then closes the entire session without
> an error dialog or anything else.
> 
> Right now i don't understand why this behaviour changed.
> 
> Using another account (with developer priviledges) i can swtich to design
> environment as expected.
> 
> Any ideas?
> 
> Best regards
> Florian
> 
> 
> 
> --
> Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
> **
> 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
> **
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
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
**

Switching to design mode fails (v13)

2018-08-22 Thread fpoeck via 4D_Tech
I have a 4D v13 development server (interpreted client/server setup) here,
which i am using since several years. Until this week i was able switch to
design mode by either

* closing the main window of my application (on the client side) OR
* use a menu entry which points to the default action "Design"

Problem:
If i choose one of the 2 methods above now it seems like it switches to the
development/design environment, but then closes the entire session without
an error dialog or anything else.

Right now i don't understand why this behaviour changed.

Using another account (with developer priviledges) i can swtich to design
environment as expected.

Any ideas?

Best regards
Florian



--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
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 v17 & macOS Mojave beta

2018-08-22 Thread James Brown via 4D_Tech
Has anyone tried 4D v17.0 client on macOS Mojave?

Just curious - I get a -10509 ‘Can’t open database’ runtime error when I try.

Thanks,

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