Re: Put a button in an email that won't open a web page

My bad I misunderstood your question. It seems what you want is for the user to be able to click on the button in the email and only sent an email and be taken to a webpage that first time. After that any click on button in the email would only send an email. Yes the URL will send the user to a

Re: Put a button in an email that won't open a web page

Without knowing the details of what you are doing I can only say that the button will just act like any URL to a server. What you do with the URL and respond to it is entirely up to how the server responds. I regularly send out emails with buttons linked to a URL. I use 4D Webserver and trap the

Re: PROCESS 4D TAGS

Just tried exactly that (I used select document and the Document variable to get document). It worked with no problem. I tested on v16 OSX10.10.5 So it's either v14 problem or your settings. Cheers Jim Labos - infobase - Jim Labos - infobase -- View this message in context:

Setting "DEFAULT VALUE" with SQL

I have no problem setting a default value with mySQL but I am having trouble getting the correct syntax with 4D's SQL implementation. I am just in test and experiment phase of trying to see if I can replace mySQL with 4D (so far so good except for this little hiccup which I am certain is my

Re: Re(4): 4D db -> SAAS

Unless I misunderstood the requirement, if it's a single user application and the Data is particular to each customer but not the schema/structure than why not use 4D Volume Desktop? Cheers Jim Labos - infobase - Jim Labos - infobase -- View this message in context:

Saving open windows in Design environment feature

Before I create a feature request I thought I'd ask here to see if I am missing something (sometimes yes, I am guilty of not reading the manuals fully!). I would love to see an implementation for naming and saving "sets" of windows in Design. It would be a way to organize sets of code and forms

Re: Saving open windows in Design environment feature

Hi Jeremy, What I mean by that is to open the form editing window in Design environment. For instance. If I have a form named "input" in the table named "Access" I can call the following: FORM GET NAMES([ACCESS];atxt_PATHS) now the array "atxt_PATHS" will contain a list of all the forms in

Re: Saving open windows in Design environment feature

Thanks for your replies Douglas and Jody. It looks like I'll have to look into rolling my own. I'll create a feature request as well. Thanks for the insights. Cheers Jim - Jim Labos - infobase -- View this message in context:

Re: Saving open windows in Design environment feature

I am looking into Design Object Access to do what I need but I although there is a way to get the Form names there seems to be no way that I found to open up the forms themselves. All commands deal with Methods and all other code. Have not looked at the 4D POP yet as Douglas mentioned.

Re: Sending Emails Quicker?

Not sure about the authenticate but what I do is use multiple processes to send out. There is the added work to keep track of what has gone out and divide the selections for each process but it does enable one to send out faster. Note also that your outgoing email server may have a maximum of

4D Write Pro - WP EXPORT DOCUMENT to WORD?

Trying out 4D Write Pro with v16 R4 beta for possible use in an upcoming project. It's the "Bookmark" feature that got me curious as without it we would not be able to fulfill our requirement. I will need to "construct" a 4D Write document from "Bookmarks". If this works well then we need to

Re: 4D Write Pro - WP EXPORT DOCUMENT to WORD?

Why I wonder does the list often mix thread messages such as here? The thread was started by me with a subject about 4D Write Pro. However we find another totally different subject matter within it? This is not the first time I have seen this. Any clues as to why this happens? Jim Labos -

RE: 4D Write Pro - WP EXPORT DOCUMENT to WORD?

Hi Lutz, Thanks I just added my vote for this feature. - Jim Labos - infobase -- 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

Re: 4D Write Pro - WP EXPORT DOCUMENT to WORD?

Thanks Pat, However I believe my colleague has tried this and the result was not pretty, so it is not a solution that would be acceptable to us at this moment. - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html

Re: METHOD OPEN PATH Equivalent For Forms

I asked the same question and got same answer a few months back. Maybe if we push enough they will add it in? Cheers Jim Labos - infobase - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html

Anyone use phpdocx with 4D or using external interpreter?

Looking at phpdocx as they claim to be able to generate decent looking Word ( .docx ) from HTML. I am getting good results on Word but my partner is not getting the same at all. I am trying to avoid using XML to generate the Word file and so the idea of using HTML (which I am doing already in any

Re: How does one detect that Cookies are disabled?

Hi John, I just saw this and will check it out. I knew there are Javascripts to check for Cookies but was resisting going that route. I will give it a try. Thanks to you and Danny Beaubien. Cheers - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html

How does one detect that Cookies are disabled?

This particular Web application sends out emails with embedded ID's in a URL that uniquely identifies a connection. We have been able to do this because our customers forward us their list of members etc. We have a new customer that must send out the emails themselves and therefore it is not

Re: How does one detect that Cookies are disabled?

I am creating the cookie and immediately after that checking if cookie exists. We handle our own session so no we do not use 4D Session method. So by session I mean the initial call on the server. Using v13 in this application. 1: User hits server with a URL. 2: Server analyzes URL and if it

Re: How does one detect that Cookies are disabled?

Yes but I am trying to detect if Cookies are "Disabled". If I can read the Cookie it exists and there is no problem. If I cannot read a Cookie then I will create it and that is where the problem lies as one cannot know if it was or not. At least not immediately. That is the predicament. Cheers

Re: How does one detect that Cookies are disabled?

Hi, Don't take this the wrong way but other then telling me what you do on your computer to the cache from browser I don't know what this has to do with the subject matter. I just want to be able to "detect" if cookies are enabled or not. It is not my business what the person connecting to the

Re: How does one detect that Cookies are disabled?

Thanks John. That was my thought too but I thought maybe someone had some other "magic" trick. It's clear now there is none in this case. It's cumbersome but it will need to be processed as you stated. Since it's not a single call I can be checking if the Cookie was created on first hit and

Re: How does one detect that Cookies are disabled?

Thanks to all that replied. I learned a lot here. It forced me to understand the process and sequence of events that goes into creating, reading and deleting Cookies. Cheers - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html

Re: How does one detect that Cookies are disabled?

Thanks John. This was my finding as well although I was not using Xojo (if Xojo code is running from within the HTML form than if it programmed to send message to server you may be able to detect it). Essentially the browser does not see anything until 4D ends the code. I have not checked if it

Re: 4D Server crashing with MyConnect

Are you checking on the mySQL server side to see what is going on there? Restart mySQL? If it was running that long without a hiccup it's probably not this but make sure all the connections are closed and none left hanging open. We had that problem a while back where we kept opening new

Re: Saving open windows in Design environment feature

Not unless something has changed since then. I put in a 4D feature Request in order to do this but have not checked if it was done. Cheers Jim Labos - infobase - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html

Re: Saving open windows in Design environment feature

I can't find my request now but certain I had put one on. Maybe because it is exactly same as ; In any case they do have the request in. I am assuming that it would not be a big deal to implement. If we can do it with a keystroke, doing it with code

Best way to get HTML Tables to MS Word tables

I've been doing some HTML tables that end up in Word for a while now but until now there was no need to get it to render any better so if it ain't broke. However now comes the need to have tables render as exact as possible in Word. Now I say /from/ HTML because I have been doing it that way

Re: Best way to get HTML Tables to MS Word tables

Thanks Dani, I'll check that out. I have never used or needed to use PHP so I hope that I can find another solution. If it's the only game in town then I guess I'll have to dive in. I'm thinking XML, as I am more familiar with that and MS Word seems to support it, but again I would feel better if

Statistical functions

Does anyone know of a plug-in or component that computes statistics: t-tests, analysis of variance, correlation coefficients, chi-square etc.? Thanks Jim Labos - infobase - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html

RE: UUID version 4 needed

This brings up the question of shouldn't 4D confirm what method they are using? The random (version 4) does rely on the host computer's system to generate the randomness I would assume so that becomes the weakness (according to the definitions). As far as I know most computers generate pseudo

Re: 4D Summit 2018 Comments

Thanks for taking the time to give us this detailed hint at what's coming. This is fantastic and exciting news! I hope the iOS feature will get developed to it's max. This has potential to open many areas for us developers. I have not found a need for the object oriented code yet, but then I'm

Setting color print option problem

A customer is using a Xerox printer where customer is charged on a per page printed basis. There are 2 tariffs, the cheaper one is the black and white. Since the customer mostly does not need the color options I set him up with a way to set his print settings at startup so tha he does not have to

Re: Setting color print option problem

Unfortunately they are on v13 still. Looks like its available only starting in v15. Looks like they will have to live by doing manually each time they change settings for a print job. Thanks. Jim Labos infobase - Jim Labos - infobase -- Sent from:

Re: Best way to get HTML Tables to MS Word tables

Since I am only interested in generating tables in word I have no need for something elaborate enough to generate everything. So yes Dan what I did is I started to look at table sin Excel and copy pasting to Word. Finally I created a sample of the simplest table we need to generate and then saved

Re: SEND PACKET in a multi-process environment

I have an aversion from long ago for semaphores so this may not be the best advise but what I'd do in these situations is create a "queu" list either in memory or records and let the file writing be done by only one process. The queu list could contain all the info necessary to pass to the process

Video viewer on Webarea on Windows 7

I am just testing a way to display short intructional videos in a 4D Webarea via simple HTML. On Mac it looks something like this: Video type="video/mp4" width="980" autoplay="True"> ERROR: Cannot locate Help file.

Re: Video viewer on Webarea on Windows 7

Hi Kirk, Yes sorry, on this particular application it is still v13.6. Windows 7. I've solved the problem of IE when I upgraded it to version 11. So now video plays on IE and Chrome browsers on Windows 7. However I still cannot get it to work on the Webarea on windows (it works fine on OSX). I

Re: Video viewer on Webarea on Windows 7

Hi, (I don't see a name sorry). I am using URL's and they work on Win7 on Chrome but not Explorer. So certain it's not a URL problem. It may be the Webkit use so I'll check that. I've disabled drag and drop so I'll try that as well. Thanks for the tips. Cheers Jim Labos - infobase -

UUID query ignores characters 33 to n.... didn't know that!

Mac OS Yosemite, 4D v15.6 If I am querying a UUID field, I use a UUID var of course. However there is no UUID variable type so like everyone I use a text var. What I never noticed before as I didn't need to check, is that *if* the var itself contains the UUID in the first 32 characters but has

Re: UUID query ignores characters 33 to n.... didn't know that!

Yes thanks, that is what I became aware of at that point. Previously UUID's nature was not particularly interesting to me and so I thought of it as Alpha numeric string. For comparison's sake a text will work but not as I previously falsely assumed. This old dog can still learn! Cheers Jim

Re: _ as first character in Method Name [was 64 bit...]

I haven't started to look at v17. Are we still limited to 32 characters for Method and Variable names? - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group

Re: Sending Text Messages From 4D

Hi Tim (or anyone else that could help), I am looking for a quick and simple SMS solution and came upon your (Tim's) message that you possibly had gotten some HTTP code snippets to send SMS via 4D using Twilio. I tried and was unsuccessful probably because of syntax so I gave up and moved on. I

Re: Sending Text Messages From 4D

Here are what the HTTP_REQUEST parameters look like. $lHTTPStatus:=HTTP Request(HTTP POST Method;$tURI;$tRequest;tResponse) $tURI="https://api.twilio.com/2010-04-01/Accounts/account SID goes here/Messages.json" $tRequest="FROM=%2B15551234537=%2B15551212=Test%20SMS" tResponse= "{"code": 21602,

Re: Sending Text Messages From 4D

Thanks for the code example, much appreciated. I keep getting a 400 HTTP error however. I am not using "HTTP_Request_Build" as I don't have it but I assume the "*" is an option to omit or include some characters for formatting. Here is what I am using from your code less proper username (assume

Re: Sending Text Messages From 4D

Thanks Koen, but with the headers I get a 404. Not sure but I believe the headers are optional. My guess is that the "$tRequest" var is not formatted correctly. I'm going to ask Twilio if they can help here. Cheers Jim Labos - infobase - Jim Labos - infobase -- Sent from:

Re: Sending Text Messages From 4D

Hi Randy, I just tried PostMan! Fantastic tool! A million thanks for suggesting that. However I am still getting the same 400 error. It's great to be able to see the complete request sent to Twilio. The formatting looks good. This is teh problem I was having on my own and that is why I asked

Re: Sending Text Messages From 4D

Got it! Thanks Randy and the rest of you. It would have taken me a lot longer. The PostMan app really helped and yes the header MUST be included in order for it to work. Once I saw how a good request was formatted I was able to pinpoint my 4D code that was not doing the job 100%. All good now.

Importing into 4D View

This particular requirement is still in V13 at the moment. There are Tab Delimited Text documents that need to be imported partly into vars and partly into a Table. Since these documents are from various sources they can contain varying numbers of columns or rows (ie: One document may have 16

Re: How to Modify a column using SQL

Hi Chuck, No I meant the field definition as in the original post. I cannot alter the field type etc.. That part of SQL does not work in 4D but I was wondering if that had changed for v17 or even will for v18. From the looks of things it doesn't look like it has or will. Cheers Jim -

HTTP Upload file size too low

Settings for Web Option is at the max limit. However the largest file size I can receive is around 600mb. The limit should be aprox. 2gb. Same limit on v13 or v15. "WEB GET BODY PART" will receive zero bytes when file is over aprox. 600mb. I have not done this kind of coding in years but I recall

Re: HTTP Upload file size too low

You are correct with the FTP, I didn't think of that but now that you mention it yes I would probably have to deal with IT and in our case the users are in many locations in the U.S.. I'm looking into restricting the upload size as one solutions (the huge sizes were for testing and not

Re: AW: HTTP Upload file size too low

Ok thanks for the link Jim. Essentially what 4D is saying (and it makes sense) is that the BLOB will need a contiguous block of memory and so if memory is fragmented and no block large enough exists 4D rejects the entire upload. That may be why I was getting inconsistent limits on different days.

Re: AW: HTTP Upload file size too low

I seem to remember in the past there was a way to get the entire body and one would have to parse the contents in order to delineate the part that was the uploaded file. Also if you do a WEB GET VARIABLES you will get an out of memory error if the file is too large (413 - Request Entity Too

Re: How to Modify a column using SQL

Thanks for the info John. I'm not planning on going to v18 until it is mature. I'm a little superstitious for even numbered versions! Cheers - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html

Re: MySQL connection from 4D

My suggestion is to try the demo of Pluggers myConnect plugin to try and connect. It will at least help you find the correct syntax or protocol to connect. We have been using it for years with no problem. It's one of those plugins that is worth every penny. For the price it may be worth buying

Re: How to Modify a column using SQL

Does anyone know if this has changed since 2013? I couldn't find anything but I could be missing something. Thanks - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D

Re: HTTP Upload file size too low

but not the ability to do it regardless of fragmented RAM. Cheers 4D Tech mailing list wrote >> On Jan 8, 2020, at 4:15 PM, Jim Labos - infobase via 4D_Tech < > 4d_tech@.4d >> wrote: >> >> No I am using just plain File object to send file. On the 4D side I use >>

Re: HTTP Upload file size too low

I wish. However as someone else pointed out some IT departments will not allow FTP. The people who would be using this are not predetermined so I have no way of knowing or vetting FTP. Cheers Just curious could you not code something so that it uses FTP? Regards Chuck

Re: HTTP Upload file size too low

Ok that's a start if using WEB GET BODY PART will get the "chunks" and I can then reconstruct the file (I am assuming that is how it works). I'll b echeking for libraries that will allow me to implemnt chuncked uploads. Thanks for your acknowledgement that you have had success doing this. 4D

Re: HTTP Upload file size too low

This is something that will be needed for an upcoming project. I'm thinking more and more to outsource this part to leave me concentrating on the rest. Let me know if you would be interested in doing this. It does not look like a huge job but there are other specs I'd need to be implemented.

Re: HTTP Upload file size too low

Thanks for link John. I'll give it a look. I knew it needed more than HTML on the browser's side just wasn't sure if 4D was then able to receive the chunks. Cheers 4D Tech mailing list wrote > This is what I was trying to get at a few messages ago. Maybe WEB GET BODY > PART does support chunked

RE: HTTP Upload file size too low

This is a known issue due to fragmented memory as 4D will only use contiguous memory for uploads. I do check with WEB GET OPTION(Web Maximum requests size;$i_SET_SIZE) and $i_SET_SIZE is at the max setting of 2GB. I'd be content with the 2GB limit. I can sometimes upload 500MB, others not even

RE: HTTP Upload file size too low

Good to know that but from what I've read I'm not the only one having this issue with inconsistent size uploads. I also get the same error others are getting. I'm using the basic way to obtain the file in a Blob in 4D by using WEB Get body part count and WEB GET BODY PART to get the Blob. I get

Re: HTTP Upload file size too low

No I am using just plain File object to send file. On the 4D side I use WEB Get body part count and WEB GET BODY PART. No chunking that I know of unless 4D is doing itself (which by the way I don't know why they didn't implement that themselves since they give us a 2GB limit). That was my

Re: HTTP Upload file size too low

I'm back after holidays and also testing other solutions. I keep getting the "413 - Request Entity Too Large" error. The On Web Authentication" method never get's triggered. The conclusion is that I need to find a way to upload from browser and receive in 4D pieces or chunks of the file and then

Re: iNUG Messages ― Is it time for it to be more than just 'plain text' ???

Yes! Finally! I'll be using the new one from now on. However! Let's leave this one alone at least for searching old posts. Looking forward to seeing you all on the new forum. - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html