Re: Check mark strangeness
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
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
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
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
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
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
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")
>
> 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 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?
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
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
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
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
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
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
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)
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)
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
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 **
