Re: ORDA - NOT(IN)

Adrian, I honestly believe this to be a bug and hope that in the future it will be fixed. Below does not work: $vc_exclude:=New collection //make a simple empty collection $es_MySel:=ds.myTable.query("not(myField in :1)";$vc_exclude) Here are few ways around it: Option 1 - Check and do

Re: ORDA - NOT(IN)

Tom, Re: Why is my query of NOT(IN []) versus NOT(IN [""]) producing difference results? I noticed this a few weeks back. The empty collection I was using was the result of a previous query that returned a collection. I had to code around it so if the myCollection.length

Re: An API for my 4D app

Pat, You mean something like: https://www.ilevelsoftware.co.uk/help/api/index.html I have written a REST API for our main system and implemented it in a number of others. Fairly generic 4D code. It needs a web server license. By comparison the RESTfull API. V18 looks pretty good but each

RE: Entity Selection Listbox with Image

Update. Having run many tests it would appear that I was experiencing some data issues possibly due to some internal data conversion. Having reset all the thumbnail images in the table the awful lag that was being experienced when using an entity selection with a list box went away. I then

Entity Selection Listbox with Image

Hi Folks, We have been working on moving our generic listing over to using ORDA. To do this we realise that we would need to use entity selections with list boxes. This has gone really well but we have now hit a very road bump and I need some advice on how to overcome it. Two of our tables

Re: What is equivalent to SELF when a form object's "variable or expression" is an object attribute?

Chris, Is it not just: Object get pointer(Object current)->:=Uppercase(Object get pointer(Object current)->) Regards, Dougie telekinetix Limited- J. Douglas Cryer Phone : 01234 761759 Mobile : 07973 675 218 2nd Floor Broadway House, 4-6

Re: Citrix Playbook

Rudy, Re: My customers run on Citrix on a daily basis. Do you manage that or is the Citrix part managed by the customers IT? Re: No such errors, ever. Do you run the Citrix server and the 4D server on the same LAN? I have proposed two solutions to the IT company but they have declined

Citrix Playbook

Hi folks, Most of our clients connect to their databases over the internet directly with 4D in client server mode. We have one client where they have an company running their IT and do everything via a Citrix connection. They have been having on-going issues with the connection dropping and

Re: Capturing barcodes without a 'text' field

Peter, As Pat said a barcode scanner is nothing more than an input device so it operates like a keyboard. So an enterable text area is the easiest way to manage the input. We do an awful lot of barcode processing in our EPOS app as well as in our main ordering system. It is about managing

Re: v13+ SQL access other system

Chip, What you are trying to do is all possible and I have done it with many different SQL databases over the years with various SQL backends such as DEC RDB, Sharebase, Terradata, Oracle, MS SQL, Firebird, MySQL, SQLite and PostgreSQL. Some of these do not exist anymore the main ones I

Re: v15 - what code runs before On Startup?

Chip, Re: Component interpreted: the alert is never encountered before the Out of stack space issue. Component compiled (built): the alert is displayed, and the host starts normally That is strange is it a component Cache issue? Are you running client server or standalone. I know that in

Re: v15 - what code runs before On Startup?

Chip, Do you have anything in the "On Host Database Event" method in the component? If you have the database setting on the host as: 'Execute "On Host Database Event" method of the components' set then any component might be running something. Re: The ON STARTUP of the component is empty

Re: POS Systems

Hi David, I have done a few POS related projects in the past 20 years. What is meant by POS can be quite wide. When I refer to it I mean retail till systems. I currently have a number of systems that use a 4D solution for till sales in fashion clothing boutiques. Integrated with Card

Re: 4D Web Log Out

Lutz, Re: > I'm not really understand your problem. What do you mean with "the browser > still persists with the username and password"? Does it mean that you > send > these credentials with every request to the web server? > What we do is this: > If the browser makes a request without a

Re: 4D Web Log Out

Dani, Re: Have you looked at the "WEB CLOSE SESSION” command? That is probably what you are looking for assuming you are using the built in 4D sessions. Yes I have looked extensively at that command and I am using it. The examples all deal with how you would use it with regards the "On

4D Web Log Out

Hello folks, Forgive me if this question has been asked many times before but I am a bit stumped. Logging on to 4D via a web page is relatively simple wither using the nasty dialog or rolling your own page to submit the httpauth details. Logging off however is proving to be more difficult.

Re: Collection of Telemetry Data

Robert, I am up for exchanging ideas and I recognise some of the things that you want to do as things that have been done in a variety of ways in the past in various systems I have worked on. For one of our systems licenses are managed via a simple file placed on an FTP which the system with

Re: SOAP over HTTPS

Keisuke and Lutz, Thank you again for your comments. I have now worked out what is not working... I was dumb enough to think that all SOAP clients would be equal. In fact when I tried from SOAPUI the HTTTPS call worked fine. When I tried from 4D v17 the HTTPS call also worked fine. My

Re: SOAP over HTTPS

Keisuke and Lutz, Thank you for your comments. Lutz said: "is not only necessary to access the endpoint with https:// you have to offer the service as a https:// service, e.g. you have to adjust the settings in 4D to modify the wsdl in the proper way." This sounds like the key, so I will look

SOAP over HTTPS

Hi folks, I need some advice on what I need to do to make 4D Web Services accept HTTPS calls. I am using v17 64bit server. In my naivety I assumed that it would just be a case of changing the URL in the SOAP calls to point at the https endpoint. But this does not work and returns "SOAP

Quit Action on Windows Close Box

I have a niggly issue with v17 4D 64bit, Usually when I click the close box on the main application window it triggers the associated menu that has the quit action on it. It is one of those automatic things that I have never tried to find a code alternative for. This still works with v17

Re: Selection to JSON Date Conversion

Helge, Re: use SET DATABASE PARAMETER([Booking];JSON use local time;0) // scope current process before the json command. Many thanks, that is exactly what I was looking for __. I had already post parsed everything to fix the dates. It has little impact and removes the

Re: Selection to JSON Date Conversion

Miyako, Based on your reply it looks like I have to accept that I will either have to write my own version of Selection to JSON or I will have to post parse the resulting dates to correct them at least while I am still on v15 4D. I have already seen the impact of setting the "Dates inside

Selection to JSON Date Conversion

Help, I have just hit a problem with Selection to JSON that has me floored and I am hoping somebody can point me to missing setting or to my ignorance. When including date fields in a template and using it with Selection to JSON dates that fall inside of BST the dates are being corrupted by

Re: Defining and documenting

Paul, I think I get where you are coming from. With a defined structure, table and field names it is fairly easy to see what the model is. What you see is pretty much what you get. Introduce objects and you suddenly have hidden data structures. Indeed those data structures can vary by

Re: Thoughts and Suggestions?

Ken, We have two similar use cases linked to our i.LEVEL solution. Order Taker - This is for sales agents throughout Europe selling a large range of fashion clothing and jewellery Store Controller - This is for concession store managers travelling the country visiting their concessions in

4D Networking or Notworking

Hi all, In the past few years there has been an increasing trend towards Virgin Cable internet in the UK. We have Virgin at our offices now and were using it for our primary connection with a fail over back to our existing ADSL connection. Increasingly we were seeing a significant number of

v17 Find in Design Client Server

Hi Folks, More than 80% of my development effort is spent using client server. The main system I work on these days had 10 years development before I got involved so although I have been working on the code for nearly as long I still have to use Find in Design daily. Lets face it we all need

Re: Export text columns containing carriage returns to Excel?

Brad, My stock answer to questions like this is. Get yourself a copy of : http://www.pluggers.nl/product/xl-plugin/ If you are doing anything serious with excel files this is the easiest and best solution and well worth the outlay. Regards, Dougie

Re: What do you use to monitor your offsite servers?

Hi there, I thought I would chime in as I may have something useful to contribute for once __ My support team manage over 30 hosted Windows servers mostly at our data centre but some at client sites. For server remote control we almost exclusively use RAdmin. Unfortunately there is no Mac

Re: XSLT APPLY TRANSFORMATION

Miyako and Koen, Many thanks. The plugin works brilliantly as a direct replacement. Re: but if it is a command you "never use or know much about" why is it even being called..? I often get asked by clients to look at code that has been written by someone else decades ago. Usually the

XSLT APPLY TRANSFORMATION Replacement

Hi there, I have a client who has just hit a problem with a deprecated command _o_XSLT APPLY TRANSFORMATION Seems to be two issues. One the command is deprecated and two the command returns a message that it cannot be executed on server. Does anybody have a viable direct replacement for this

Re: MySql login problem

Pat, Where is the MySQL database hosted? If the clients IP has not changed it is possible that the IP is restricted by a time rule rather than an IP rule. We have had this issue more often with FTP than databases but I have seen it. Regards, Dougie

Re: Google Authenticator Integration

Chip, Thank you for the input. I am trying to build to what people expect. My target market in this instance is trading exchange users crypto exchanges in particular. In this market 2FA is used extensively as a secondary or tertiary security level. As example Binance but may others use 2FA

Re: SPAM-LOW: Re: Google Authenticator Integration

Chip, Thank you for the input. I am trying to build to what people expect. My target market in this instance is trading exchange users crypto exchanges in particular. In this market 2FA is used extensively as a secondary or tertiary security level. As example Binance but may others use 2FA

Re: SSL cipher list

Jim and Mike, Thank you for your inputs on this. The resource: https://mozilla.github.io/server-side-tls/ssl-config-generator/ was very helpful in creating a cipher list that 4D would accept and which got rid of all the insecure options. With regards: I would guess its a syntax issue

Google Authenticator Integration

Hi folks, In my quest for building better security solutions I am currently looking at implementing 2FA specifically Google Authenticator Two Factor Authentication. Has anyone done this with 4D code and is willing to share an example? Seems like the building blocks are there: QR Code

Re: HTTPS Connection for Web Module

Ronnie, As painful as it may seem I would second the comment made by Dani: > I would consider putting Apache or NGINX in front of your 4D v11 application > and configure Apache/NGINX as a reverse proxy to your 4D app. > There has > been messages on the nug that can tell you how to do that.

Re: Options To Put Data Into Existing Excel Spreadsheets?

Allan, Until recently we were using Keisuke's component. Clients were asking for more, in particular images so we looked around and found the Pluggers Plugin. Yes it does mean going from a free option to a paid option but equally it is like going from a 2CV to a Ferrari. It does much more,

SSL cipher list

Hi folks, I have been working on a project which requires strong web encryption and high rating. The latest FPS and HSTS blog from 4D has allowed me to get an A+ rating and compared with the target site I was trying to match I meet all the criteria. There are two of the bars though that are

Re: Image Madness

Cannon, I tried your code on the supplied image and had to swap the values for 6 & 8 as, after rotation, the image was upside down. So : ($lOrientation=8) //Left 90˚, so need to rotate right 90˚ $gPicture:=Photo_Rotate ($gPicture;90)

Picture Madness

I have a picture puzzle that I hope someone may be able to help me with. We are doing the following: C_PICTURE(vg_Picture) READ PICTURE FILE("";vg_Picture) To load a picture to a screen variable. My colleague has complained that when he loads some pictures they as he puts it "lay down". I got

Re: Installing a Wildcard SSL Certificate

Pascal, Re: Does the server start up correctly ? How did you make the cert.pem file ? Make sure it does not contain any invisible characters and the linefeeds should be just regular linefeeds not windows linefeeds. Yesterday I was getting no error starting and stopping the web server and I

Installing a Wildcard SSL Certificate

Hi folks, It has been some time since I have installed an SSL certificate with 4D and I seem to be having little success. In this case I want to use a wildcard SSL certificate so I found an article that explained what you had to do with the intermediate part of the certificate. I have

Re: 4D Summit 2018 Comments

I am very excited about ORDA. Hopefully it will help to attract more young developers. I am however somewhat cautious about the potential GOTCHAS that will undoubtedly come out from using it. A few early examples: I find the having to restart the server if an entity or property (table or

Re: Import from Excel

Another vote for Pluggers Excel plugin. https://www.pluggers.nl/product/xl-plugin/ You will not regret it for creating and reading excel files it is simply the best, just as you would expect from Pluggers. For my usage it has paid for itself over

Re: REST server component?

> On 13 Feb 2018, at 20:00, 4d_tech-requ...@lists.4d.com wrote: > > Anyone have a full-featured, debugged REST server component for 4D? I am doing a session at the Conference in Paris which will demonstrate a REST implementation in 4D. It will not be a component but an example database with

Re: HTTP Body Size

>> 2018/02/08 17:36、Douglas Cryer via 4D_Tech <4d_tech@lists.4d.com >> <mailto:4d_tech@lists.4d.com>> のメール： >> TEXT TO BLOB($vt_Request;$vx_Request) > My bad. In fact I was doing TEXT TO BLOB($vt_Request;$vx_Request;UTF8 text without length) I missed tha

Re: HTTP Body Size

Jeremy, Re: > Instead of a text variable, you can also use a blob variable to avoid the > size limitation. > > http://doc.4d.com/4Dv16R5/4D/16-R5/WEB-GET-HTTP-BODY.301-3481155.en.html > Yes in fact I am declaring the

HTTP Body Size

Hi folks, I am working on a Windows tablet application where I am using RESTful services between a 4D App and a 4D Webserver. I have now hit a snag when I try and pass images back to the server with the HTTP client. The package is being truncated due to the image size. I read the docs and

Re: The writing is on the wall

The title of the post is correct. Here is my view… Since the new network layer was introduced I have tried firing up various databases with this setting on. In every case I have changed it back after a day or two as it was so unstable and was causing me so many issues. These were existing

Re: Capture Image on Tablet

Tim and Timothy, Thanks for the information. I thought it was going to be the solution as it works really well on a Windows 10 desktop with a plugin USB web cam. However, we have not been able to get it to recognise a tablets built in cameras. We have tried updating the js source code but

Capture Image on Tablet

Hi folks, I am writing a new tablet based app for store controllers who visit stores to have on hand stats fort the store they are visiting. One of the functions I want to be able to provide is to take a picture with the tablets camera directly inside of the 4D application. These will be

Re: Microsoft Outlook Integration

Tim, I have some code that I think does what you are asking for. Essentially I have written some methods that execute VBScript for Windows and Applescript for Ma. This supports calling Outlook on both platforms and Mail on Mac to send emails. It also gets the list of email accounts from the

Re: HTTP Request PATCH

Koen, Re: > There is no PATCH constant defined in 4D, but you can use “PATCH” as string > for http method as the first parameter: > HTTP Request(“PATCH”;$url;…) Many thanks. I had that thought in the waking hours and was going to try it. I had not spotted it was a string constant. The

Apache Kafka

Hi all, Has anyone had any experience communicating to an Apache Kafka service for sending or receiving data? If so how did you do this and what were your experiences (if willing to share). I will be needing to do this next year and wanted to get the jump on it... Regards, Dougie

POP3 Email Processing

Hi folks, After many years using OTRS for our help ticketing and change control we have recently decided to roll our own 4D based solution. This is partly a cost thing; partly a support/functionality thing and partly to get our teeth into a project where we can get used to the latest version

Deprecated Constants

Hi all, I just ran an upgrade to v16 (R5) to see what work might be required. By far the biggest issue will be images that still reside in the library. Aside from that I got 19 instances of constants that are now deprecated: _o_Mac To ISO - 1 Instance no longer required… _o_Extras Folder -

Re: What to do about users who won't follow instructions?

Pat, An age old question. I have a few thoughts around this. My baseline is to start with the assumption that it is not the person but the system or the explanation that they have been given that needs improvement. I suspect that you do this also but sometimes people can confound us.

Re: 4D v16.2 false record locks

Yes please, what David said… > David Adams wrote: > > ...but seriously, what I'd like to see 4D do is an *entire release* that > consists of *nothing* but fixing bugs - as many as they can find, as many > as we can find and longstanding annoyances. No fancy new features. Just > cleaning up

Re: Programmatic control of accept/reject new connections

Hi there, I thought this could be done with the “On Server Open Connection” Method. Not used it in a long time but if it returns false your client will be refused connection. http://doc.4d.com/4Dv15/4D/15.4/On-Server-Open-Connection-Database-Method.301-3286437.en.html

Re: v13.6 - 2 servers same network, how to make it work

Alan, If you are running the databases on different servers each with their own IP address you should not need to change the ports at all. In this case, if both are set with the default ports then they will both be visible under available. If you are running two or more servers on the same

Re: Getting image from JSON

OK I have figured it out… BASE64 DECODE($vt_Image;$vx_BLOb) BLOB TO PICTURE(vx_BLOb;$vg_Picture;”.png”) Works… Regards, Dougie telekinetix Limited- J. Douglas Cryer Phone : 01234 761759 Mobile : 07973 675 218 2nd Floor Broadway House,

Getting image from JSON

Hopefully this is a simple one for many people out there. I am working with a REST service that is returning an image in a JSON response. The image is coming back as a long text value and I am not sure what steps I need to go through to convert it to an image. I tried : TEXT TO

Re: Image Export to Excel

Douglas, Re: > > One of the best kept secrets of the 4D plugin world — the XL Plugin from > Pluggers. > Many thanks. I do not know how I have missed that for so many years given my usage and love of Robs work. Looks like I have a lot of work to do converting existing reports but I think

Re: Image Export to Excel

Miyako, Thank you for your reply a while back... > On 19 Jul 2017, at 20:00, 4d_tech-requ...@lists.4d.com wrote: > > the component was meant to be a simple demonstration of how one can call > AppleScript and VBA from 4D. > it was never meant to be an "out of the box" kind of production tool. >

Image Export to Excel

Hi all, I use the excel component written by Miyako to output all kinds of data to excel. I want to be able to insert images into some spreadsheets, either as actual images or via URL’s which can then be transformed in some way. Does anyone have a method / technique of doing this that they

Expose with 4D Mobile Service

Hello, Is there any way to get or set the property in 4D tables and fields to identify if a field or table is exposed with 4D Mobile Service. Is there any penalty or risk associated with having this setting on? It seems like everything just got it when we upgraded and the only way to unset it

Error -19191

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

Re: Website development path

Joshua, I read a post you made in January (below). I am currently building out a REST interface for a system. I am finding writing the REST calls fun and challenging but the 4D language has a lot of stuff that helps. What I am not having much fun with is the documentation. I know what I

Re: 4D and Sage

Pat, Transpose is your best bet. It does the automation and you can just pickup and drop files. Regards, Dougie ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive:

Re: 4D and Sage

Pat, We have done 3 things with regards Sage Integration. It is important to note these are all in relation to Sage Line 50. Simple Export This is just exporting invoices in a text format for import into Sage using their standard import function. Integration via Transpose -

Re: Desktop DBMS engines

How about: Firebird SQLite Both Can be used as desktop DBMS engines. ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options:

Re: AS400 & 4D...

> >Robert, You would need to use ODBC to connect to the DB2 database. I have not needed to do this since the 90¹s so no longer have any current information. Often AS/400 systems have many well defined and documented file transfer processes to allow communication with other systems so I would

Hex Colour Picker in Listbox

Hello all, I have a list of colours in my system and I have a corresponding hex colour code field but nobody has really used it. I want to do a few things: Automatically map common colours to hex colours (via a lookup Provide a hex colour picker that I can use in a listbox Use the

Re: Replacing - OAuth.bundle

Kirk, Thank you for a very clear, concise description of how to navigate GitHub repositories. I too have struggled with the interface and terminology. Your description demystifies it all. Regards, Dougie telekinetix Limited- J.

Anyone using v16 in WAN

I would like to hear from anyone using v16 in a WAN environment. Frankly every time I have tried out v16 or for that matter any v15 R release I have been shocked at how poor the network connection stability has been. It seems to stem from the new networking layer and certainly it seems to be

Re: HTML Editor in 4D

OK so within an hour of posting this and after a few dead end internet searches I found this: https://4dtoday.eu/blog/2015/02/20/tinymce-html-editor-for-4d/ Which is exactly what I was trying to do :-) So why did I not think

HTML Editor in 4D

I have a requirement to provide HTML data for web site product descriptions, authored within a 4D database. What is the best way to achieve this using v15. The styled text area is not powerful enough even to do bullet points. 4D Write is an expensive option for just this purpose and I am not

What is Cadran?

I have number of EPOS tills which use an engined 4D application which has been in place for around 6 years with a few upgrades and version releases. One of the till has just started reporting an error: Error when executing the method “Cadran_1” at line number 8 The method cannot be executed

Re: Strategy to allow one user to drop another from the server

Kirk, We had a similar requirement. In our case it was users remaining logged on after they had gone home. We needed them to be kicked off in order to run maintenance and so the backup was not slowed. I used execute on client to display a dialog to the user informing them that they would be

Re: Understanding 4D Mobile

When Wakanda was first released and the 4D mobile concept came about I got really excited as I like you thought of all the small functions that I could publish like little dashboards, public information, company news. I was never thinking lets re-write thousands of screens for internal users