Re: 4Dv15 applications as a Service in Windows Server 2012

[Ronnie Teo via 4D_Tech]

Hi Gerald,

Thanks for your heads.  
Yes, I had confirmed that the application is registered in the firewall.

Regards,
Ronnie
Tarawerkz

> On 3 Sep 2018, at 11:34 PM, 4d_tech-requ...@lists.4d.com wrote:
> 
> Subject: Re: 4Dv15 applications as a Service in Windows Server 2012
> Message-ID: <706c3933-68b2-4e60-b3dc-6c18bf603...@balzer-computing.ch 
> >
> Content-Type: text/plain; charset=utf-8
> 
> Make sure, that the application is registered in the windows firewall. Even 
> if it might be disabled.
> 
> Cheers
> 
> Gerald

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

SPELL CHECKING in a Listbox cell

[Pat Bensky via 4D_Tech]

Using v16.3:
The only way I can see to spell check the contents of a listbox cell is to
do it via a "Check spelling" button. I don't see how to get it to work on a
form event such as On Data Change because the Focus Object is the whole
listbox, not the cell.
Have I missed something or is a button the only way to do it?
Pat

-- 
*
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)
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: UUID query ignores characters 33 to n.... didn't know that!

[Paul Lovejoy via 4D_Tech]

When I first saw 4D’s requirement for unique indexes I was tempted to replace 
other ids in our databases with UUIDs in order to save space ... I quickly gave 
up on that idea. I just let 4D manage UUIDs to have unique IDs for backup and 
journalizing functions and I don’t assume anything regarding those fields and 
indexes. 

Paul 

> On 3 Sep 2018, at 21:07, Jim Labos - infobase via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> 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 Labos - infobase
> 
> 
> 
> -
> Jim Labos - infobase
> --
> 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 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: UUID query ignores characters 33 to n.... didn't know that!

[Jim Labos - infobase via 4D_Tech]

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 Labos - infobase



-
Jim Labos - infobase
--
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
**

Re: WS SEND BLOB encoding? - never mind

[JOHN BAUGHMAN via 4D_Tech]

4D was returning an error ousted of the blob due to a typo in the request. I 
have it working now. One letter can sure waste a lot of one’s time.

John


John Baughman
1331 Auwaiku Street
Kailua, Hawaii  96734
(808) 262-0328
john...@hawaii.rr.com

> On Sep 2, 2018, at 8:26 AM, JOHN BAUGHMAN via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I have a Web App running on the same machine as 4D Sever and all requests to 
> 4D are done over localhost. I am currently displaying PDFs by having the Web 
> App get the path to the pdf file from 4D then serve the file to it’s viewer 
> in the browser.
> 
> This all works fine, but after some testing have found that it is 
> significantly slower than serving the blob directly from 4D with WS SEND 
> BLOB. I have only been able to get this to work if I make the request for the 
> pdf directly from the browser, not via the Web App. In other words using the 
> address bar of the browser or the HTML viewer of the Web App in the browser. 
> The problem is that this exposes the request including the path to the PDF on 
> the server. 
> 
> I need to have the Web App on the server make the request to 4D over local 
> host then serve the PDF to the web app’s viewer in the browser.  The closest 
> I could get to being successful was by having the web app create a simple web 
> page with the returned data and send the page to the web app’s viewer in the 
> browser…
> 
> //web app request
> pdfBlob = socket1.Get("http://127.0.0.1:9000/getDocumentBlob?path="+docPath, 
> 30) //send request to 4D
> pdfBlob = EncodeBase64(pdfBlob,0)
> 
> //create the web page
> 
> 
> 
> 
> 
> 
>  width="100%" height="675px">
> 
> 
> 
> //send the page to the viewer in the browser
> 
> //4D response:
> $path:=Convert path POSIX to system(WebRequestGetFormField ("path"))  
> C_BLOB($blob)
> DOCUMENT TO BLOB($path;$blob)
> WEB SEND BLOB($blob;"application/pdf")
> 
> All I get, however, is “TESTING TESTING” followed by a grey block where the 
> pdf would be displayed. It has been suggested to me that the problem may be 
> encoding and the following was suggested for encoding the response…
> 
> pdfBlob = EncodeBase64(DefineEncoding(pdfBlob ,Encodings.UTF8),0). //still a 
> grey block
> 
> Not completely understanding how encoding really works I am not sure how to 
> ask this, but what encoding is 4D using to send the PDF blob. Or can somebody 
> explain why this doesn’t work.
> 
> Thanks,
> 
> John
> 
> 
> **
> 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: UUID query ignores characters 33 to n.... didn't know that!

[Arnaud de Montard via 4D_Tech]

> Le 3 sept. 2018 à 00:45, Jim Labos - infobase via 4D_Tech 
> <4d_tech@lists.4d.com> a écrit :
> 
> [...]
> 
> What do you all think? Is this a bug? An annoying gotcha? Did you already
> all know this and I am the only one who didn't?

QUERY([aTable];[aTable]longint=Num("123xxx")
We are not surprised that values = 123 are found. If you consider that 4D uuid 
field is a 2^128 integer (scalar number), it's the same thing that happens to 
your trailing "xxx" and those above. 

BTW, I think that uuid fields with an alpha icon in structure it is a source of 
confusion. 

-- 
Arnaud de Montard 



**
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: 4Dv15 applications as a Service in Windows Server 2012

[Gerald Balzer via 4D_Tech]

Make sure, that the application is registered in the windows firewall. Even if 
it might be disabled.

Cheers

Gerald

BALZER COMPUTING • Breitensteinstr. 88 • CH-8037 Zürich • Tel.: +41-44-4404605 
• Fax: +41-44-4404609
Mitglied im Entwicklernetzwerk die4dWerkstatt

> Am 03.09.2018 um 10:35 schrieb Ronnie Teo via 4D_Tech <4d_tech@lists.4d.com>:
> 
> Hi,
> 
> I have not been able to run v15 applications as a service under Windows 
> Server 2012, using 4Dv15.5
> When the service is started, I am unable to connect to the database from a 
> client, the Available tab is also empty.
> 
> It is not a problem when the same v15 application is launched directly with 
> the 4D Server application from the same 2012 server.
> If I launch a separate v13 application from the same 2012 server, it works 
> fine too.
> In both the above scenarios, there is no issue with client connections.
> 
> Can anyone advise?  Is there some setting I have to carry out to facilitate a 
> v15 app running as a service?
> 
> Regards,
> Ronnie
> Tarawerkz
> 
> **
> 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
**

4Dv15 applications as a Service in Windows Server 2012

[Ronnie Teo via 4D_Tech]

Hi,

I have not been able to run v15 applications as a service under Windows Server 
2012, using 4Dv15.5
When the service is started, I am unable to connect to the database from a 
client, the Available tab is also empty.

It is not a problem when the same v15 application is launched directly with the 
4D Server application from the same 2012 server.
If I launch a separate v13 application from the same 2012 server, it works fine 
too.
In both the above scenarios, there is no issue with client connections.

Can anyone advise?  Is there some setting I have to carry out to facilitate a 
v15 app running as a service?

Regards,
Ronnie
Tarawerkz

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