Mike,
Hi. It would probably not be appropriate for 4D to create a .gitignore as it
can't assume that you will use Git as a repo. For Git you would want to exclude:
/Project/DerivedData
and possibly:
/Logs
On mac you would also want to exclude (this could be put in your global
.gitignore file
Hi all. We have a requirement to connect to MS SQL Server databases hosted on
AWS from 4D v17.3 on Mac OS 10.14+. The use case scenario is likely to be that:
* only a single user will need to connect, either via 4D Client or from 4D
standalone - tbc
* we may need to ingest large amounts of data
Piotr,
Hi. That seems like the expected behaviour according to the docs:
https://doc.4d.com/4Dv17/4D/17.3/Overview-of-XML-DOM-Commands.300-4620648.en.html
"Error Handling
Many functions in this theme return an XML element reference. If an error
occurs during function execution (for example,
Piotr,
As alternative "hacky" solution you could try is to monitor the "modified at"
at property and keep testing it every second or so until it's value no longer
changes? There may be other possibilities too by inside using LEP but I'm not
sure without further investigation.
Regards,
I could download that note. When 4D does not recognise me I delete all
cookies containing "4D", usually it stops being blind and deaf.
ROTLF :)))
Regards,
Narinder Chandi,
ToolBox Systems Ltd.
https://toolbox.systems
I am available for new consulting opportunities…
I just downloaded it without problem - Safari 13/Mac OS Mojave. If it is
permissible to do so I can send it to you...
Regards,
Narinder Chandi,
ToolBox Systems Ltd.
https://toolbox.systems
I am available for new consulting opportunities…
I remembered now, I was also thinking of The Noun Project:
https://thenounproject.com
Regards,
Narinder Chandi,
ToolBox Systems Ltd.
https://toolbox.systems
I am available for new consulting opportunities…
http://4d.1045681.n5.nabble.com/ANN-4D-Developer-Available-td5765443.html
--
You could take a look at Google Material Design icons - seems like a pretty
large collection in 5 styles:
https://material.io/resources/icons/
I'm sure there are some other collections like this but can't recall from
memory - I will post if I can track them down.
Regards,
Narinder Chandi,
Keith,
Hi. It looks like it would be a lot of work to do a native implementation of
OIDC in 4D?
Why not instead look at providing support for services such as OneLogin, Auth0,
AWS Cognito instead? Certainly the former 2 of those appear to offer REST APIs
to. Cognito doesn't offer a REST API
So it appears that I can use HTTP Client commands for ‘outbound’ REST calls
and use Web Server commands to respond to ‘inbound’ REST calls. Does that sound
right?
Correct.
I recently did an e-commerce integration piece into PayPal and it was my first
spin with the HTTP Client/Web Server
Tom,
A simple minimal example of how to respond would be something like this:
ARRAY TEXT($aHeaderFields;3)
ARRAY TEXT($aHeaderValues;3)
$aHeaderFields{1}:="X-VERSION"
$aHeaderFields{2}:="X-STATUS"
$aHeaderFields{3}:="USER-AGENT"
$aHeaderValues{1}:="HTTP/1.0"
$aHeaderValues{2}:="200 OK"
Chip,
Use the For each...End for each loop construct to iterate over the array of
objects, something like (untested written off the bat):
For ($i;1; size of array(object_array))
For each(property;object_array{$i})
If ([property="Object_Name")
If (object_array{$i}.property="Fred")
Tom,
This may have been mentioned already, but I just remembered that it is possible
to do this encoding natively with 4D's XML and XSLT Transformation commands and
I wrote a pair of encode/decode functions several years ago that worked no
problem.
However, XSLT has been deprecated in v17.
Tom,
>https://github.com/miyako/4d-tips-encode-uri
>I found that component earlier today and it does help a bit. I was looking
for a way to fill an object with key value pairs which HTTP Request would then
convert into the right content-type.
Unfortunately HTTP Request is sadly
Tom,
I'm not sure but maybe this will help you?
https://github.com/miyako/4d-tips-encode-uri
Regards,
Narinder Chandi,
ToolBox Systems Ltd.
I am available for new consulting opportunities…
http://4d.1045681.n5.nabble.com/ANN-4D-Developer-Available-td5765443.html
--
-Original
I hope that what we're suggesting is that the plan is to (finally) dump the
binary format entirely and move to a collection of text files, whether they
be XML, YAML, JSON, etc.
Yes, the Project mode currently in Beta seems designed to achieve exactly that.
In fact maybe you missed
JPR,
Hi. Ah, that's great, thanks for confirming that. I should really find some
time to experiment with Project mode then ;)
Regards,
Narinder Chandi,
ToolBox Systems Ltd.
I am available for new consulting opportunities…
Well, JPR's as always makes a good response! But, I still need to fully
understand exactly why 4D is not eliminating the interpreted structure binary
.4DB file completely at this time? Maybe 4D plan to do so eventually? Was this
question asked at the last tour? If we are given the Project
d uploading to Git takes
hours. There’s gotta be a more efficient way.
I’ll check out Gitflow and see whether it can help me.
Thanks again,
Tom Benedict
> On Oct 10, 2019, at 13:12, Narinder Chandi via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
&g
Tom,
What version of 4D are you using?
It seems to me that the way forward for team development (or solo for that
matter) will be to ditch the 4D binary based structure file and use v17's 4D
Project format stored that in a Git repo, even though it's still Beta it should
be finalised soon
In my experience 4D conversions have generally been fairly smooth, and that's
going back many versions. When I did a 4D v11 to v15 conversion (Mac server and
clients) a few years ago there were no significant issues that I recall. I've
recently completed a conversion of that same database from
You can download it from here and other versions from 2004 to v17 can be found
there too:
ftp://188.165.34.189//Documents/Products_Documentation/LastVersions/Line_15/VIntl
Regards,
Narinder Chandi,
ToolBox Systems Ltd.
I am available for new consulting opportunities…
This is standard since v14. From the docs:
"Note: Starting with 4D v14, any new table created in the database contains a
primary key field by default. For more information about this, refer to Default
primary key field."
It's a shame that 4D's web server does not directly support something similar
to Apache's .htaccess file in the web root. Securing direct access to html
files/folders would then be trivial.
Regards,
Narinder Chandi,
ToolBox Systems Ltd.
I am available for new consulting opportunities…
I would say that you should use the HTTP Status Code returned by HTTP Get. A
well designed service should return 401 Unauthorised.
Regards,
Narinder Chandi,
ToolBox Systems Ltd.
I am available for new consulting opportunities…
Sorry my last post got slightly truncated in one place... here it is again but
complete...
Pat,
Did the client send you any crash logs? I posted about a crashing issue with
v17 just recently over on the 4D Forum. See this thread:
https://forums.4d.com/Post/EN/31710108/1/31710109#31710109
If
Pat,
Did the client send you any crash logs? I posted about a crashing issue with
v17 just recently over on the 4D Forum. See this thread:
https://forums.4d.com/Post/EN/31710108/1/31710109#31710109
If it's related to application translocation then I posted in that thread how
to fix it.
TL;DR
949-910-4084
On Fri, Sep 20, 2019 at 11:02 AM Narinder Chandi via 4D_Tech
<4d_tech@lists.4d.com> wrote:
So, I am writing some code and using C_OBJECT. Using the following
contrived object as an example:
C_OBJECT($object)
$object:=New obje
an entire transparent background or a blank picture.
Paint.net saves a JPG in 34 KB form 244 KB.
I suspect the PNG is compressed somehow and not correctly convertible.
David Ringsmuth
From: Narinder Chandi via 4D_Tech <mailto:4d_tech@lists.4d.com>
Sen
So, I am writing some code and using C_OBJECT. Using the following contrived
object as an example:
C_OBJECT($object)
$object:=New object
$object.foo:=New object
$object.foo.foo1:="foo1"
$object.foo.foo2:="foo2"
$object.bar:=New object
$object.bar.bar1:="bar1"
$object.bar.bar2:="bar2"
The code
David,
When you say that the "result is an empty picture", does the resulting picture
have any bytes and/or dimensions, i.e. did you try checking it with Picture
size and PICTURE PROPERTIES commands?
I wonder if the issue is with the parameters that you are passing to the
CREATE THUMBNAIL
- Revolutionize your apps with object-oriented programming in 4D v17 —
today!
- express4d: The better way to write web APIs in 4D
I’m wondering how many people would be interested in one or both of these
courses.
Pricing:
1 course: $500
2 courses: $900
I would
Indeed. This prompts to relay a quick anecdote - I worked on a 4D system
originally developed by Aparajita more than 22 years ago for an investment
bank. It used a plug-in that was probably little known at the time -
ObjectTools. Aparajita's always been far, far ahead of the curve. That 4D
t time since 1988 !
Peter
> On 15 Sep 2019, at 12:52, Narinder Chandi via 4D_Tech
<4d_tech@lists.4d.com <mailto:4d_tech@lists.4d.com>> wrote:
>
> Yes, for legacy structures that are converted to v17 you have to
explicitly enable Unicode support and
new object
syntax.
Many thanks for taking the time to check it and respond !
Peter
> On 15 Sep 2019, at 12:41, Narinder Chandi via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> I just tested your code exactly as-is and all the variab
Peter,
I just tested your code exactly as-is and all the variables have the expected
values. I used 17.2 on Mac. What version/platform did you test on? I've sent
you a screenshot directly.
Regards,
Narinder Chandi,
ToolBox Systems Ltd.
I am available for new consulting opportunities…
Actually, you and Tom are onto something there. During my recent v15 to v17
conversion MSC reported PICTS on some auto generated list forms which I then
simply deleted. As Tom points out, they are easy to spot on the forms as they
have the red X.
Regards,
Narinder Chandi,
ToolBox Systems
Is it possible to Copy/Paste them from the form into the Picture Library? You
could then use GET PICTURE FROM LIBRARY and GET PICTURE FORMATS commands to
analyse the image:
https://doc.4d.com/4Dv17/4D/17.2/GET-PICTURE-FROM-LIBRARY.301-4387016.en.html
Eric,
Interesting question... 2FA you could roll your own on top of Twilio's APIs
perhaps, or use an API driven service like Authy (which implements the Twilio
piece for you) or AWS Cognito. I did a AWS Cognito integration last year
building it as a PHP authentication microservice. Would make
Tony,
Are you able to open the structure with a later version of 4D? In v14 the
EXPORT STRUCTURE command was introduced:
https://doc.4d.com/4Dv17/4D/17.2/EXPORT-STRUCTURE.301-4386049.en.html
which would get you the quickest representation of your structure, albeit in
XML.
Otherwise it should
Hi all. Having just finished a customer's v15 to v17 migration project I am now
immediately available for other projects. I am open to opportunities regardless
of whether your needs are short, medium or long term. If you need help with
specific projects or want to offload one or more projects
ing 4D’s php interpreter and use the one
exterior to 4D?
Thanks again,
Sam
> On Sep 3, 2019, at 5:14 PM, Narinder Chandi via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> Sam,
>
> I don't think Dani was suggesting that you build yo
Sam,
I don't think Dani was suggesting that you build your own PHP interpreter
(although it's not hard to compile it from source for custom needs). If I
understood him correctly he was merely hinting at the option to download a
prebuilt binary with cURL support baked in, for example.
Regards,
Pat,
Perhaps you can create custom help tips with SVG overlays? You could also try
using AJUI_Tip or just take a look at it for some inspiration:
https://ch-fr.4d.com/ajuitip
It may be worth checking out the 4D KnowledgeBase or 4D Blog too for possible
options?
Regards,
Narinder Chandi,
Pat,
From memory, the Combo Box doesn't respond to the "On Clicked" event (and
never has done). It took me a while to find confirmation in the docs. But I
finally found it:
"WARNING: Combo boxes are not considered to be clickable objects. A combo box
must be treated as an enterable text area
Jörg,
IS this for Mac/Windows or both? You can use the LAUNCH EXTERNAL PROCESS
command:
https://doc.4d.com/4Dv17/4D/17.2/LAUNCH-EXTERNAL-PROCESS.301-4386604.en.html
On Mac you could accomplish this using the "chflags" terminal command, I don't
know what the Windows equivalent would be but a
Yah, success!!
I overlooked that the orphans after the repair were located under _project_
forms not table forms!
Then, every time I tried to select one I got into some endless loop where 4D
refused to let me select the form as it was damaged. Eventually I managed it by
holding down the
...and replying to my own previous message, now when I use "Find in Design" I
get a dialog pop up twice with the message:
"One field was bad. It has been suppressed from your form."
Having this come up every time is going to be a PITA :(( Is there a way to fix
this?
Regards,
Narinder
Thanks Tim - I overlooked that!
So, repairing the structure eliminated the previous FO4D warnings but I now
have 9 new ones under Check Project Forms:
___Orphan___31086.Page1.Picture1 uses a deprecated picture format: PICT.
___Orphan___31086.Page1.Picture2 uses a deprecated picture format:
So, after a long, long hard slog migrating from v15 to v17, I have reduced the
6,000 MSC warnings down to the last 2.
Under "Check Orphan Forms" I am seeing:
The form resource FO4D of id 31086 is not used anywhere
The form resource FO4D of id 21169 is not used anywhere
How do I address these?
I was checking the docs on this point a couple of days ago. Method names are
still limited to 31 characters but variable length up to 255 characters
_should_ be possible if the database is running in Unicode mode.
Why do I say _should_? Because in my current v17 conversion project (from v15)
I
Using Global Find with the picture's name or ID?
Regards,
Narinder Chandi,
ToolBox Systems Ltd.
--
-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> on behalf of 4D Tech Mailing List
<4d_tech@lists.4d.com>
Reply-To: 4D Tech Mailing List <4d_tech@lists.4d.com>
Date:
Not that I know of however since v16 there has been the GET PICTURE FORMATS
command:
https://doc.4d.com/4Dv17/4D/17.2/GET-PICTURE-FORMATS.301-4387029.en.html
but that doesn't directly help you for v13 or v15.
So, I thought about it some more and _maybe_ could use PICTURE CODEC LIST and
CONVERT
>> and 4D then processes to list all method names, and forms (1) with a space
>> in their names
...and actually, by chance I was reading the v17.2 docs at the weekend which
explicitly states:
"Tip: It is a good programming technique to adopt the same naming convention as
the one used by 4D
We have used digits for years, e.g. 00MyMethod, 000MyMethod2, etc. I haven't
checked yet if digit prefixes for methods are still valid in v17 though!
Regards,
Narinder Chandi,
ToolBox Systems Ltd.
--
-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> on behalf of 4D
Chip,
You may be able to determine this information by combining the output of the
Count screens and SCREEN COORDINATES commands:
https://doc.4d.com/4Dv17/4D/17.2/Count-screens.301-4387339.en.html
https://doc.4d.com/4Dv17/4D/17.2/SCREEN-COORDINATES.301-4387338.en.html
Regards,
Narinder
Gabriel,
Thanks for your blog - great effort, keep up the good work!
I really like the look of the Cobalt2 theme for 4D that you replicated from Wes
Bos so I downloaded it and I'm going to give that a test drive in my local v17
4D Dev this afternoon!
I think for most devs writing tips about
Chuck,
From the docs on Get Pointer:
"The Get pointer command returns a pointer to the process or interprocess
variable whose name you pass in varName."
Regards,
Narinder Chandi,
ToolBox Systems Ltd.
--
-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> on behalf of
Tim,
Hi. I had only seen mention of this new Project format in passing so I've just
taken a moment to read both of those Blog posts. Certainly this an interesting
new feature and sets 4D moving in the right direction for source control
integration. I will have to find some time to play with
it to be more of an IDE. Especially
with the Projects option coming where the 4D part is all stored in text
files.
On Fri, Aug 2, 2019 at 10:37 AM Narinder Chandi via 4D_Tech <
4d_tech@lists.4d.com> wrote:
> Yup, that is _exactly_ the behaviour I would expect from an
2019, at 1:10 PM, Narinder Chandi via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> This current behaviour as is means that there is a great chance of mixing
properties from multiple different objects within a given Method that can and
will result in unexpected coding err
e?
On Fri, 02 Aug 2019 18:10:09 +0100, Narinder Chandi via 4D_Tech wrote:
>
> Having used other IDEs, in particular those from JetBrains, 4D still
> has a ways to go to provide the "expected" behaviours for proper OOP
> style object prope
aven’t typed the property into
the method editor yet then the method editor won't suggest it, regardless of
where the property came from.
-Tim
-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Narinder Chandi
via 4D_Tech
United States
Telephone: +1-408-557-4600
Fax: +1-408-271-5080
Email: tpen...@4d.com
Web: www.4d.com
-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Narinder Chandi
via 4D_Tech
Sent: Friday, August 02, 2019 9:
So, I'm in the final phase of a v15 to v17.2 upgrade and eliminating/replacing
all the remaining _o_ prefixed obsolete 4D commands. I came across some Method
Editor behaviour that I totally didn't expect... btw, this is my very first
foray into using C_OBJECT and 4D commands that return
Yup.
Actually, many flavours of SQL support table renaming or table duplication with
additional keywords on ALTER TABLE since, at least in SQL92 AFAIK it wasn't
supported as part of the DDL.
For example, the last time I used MySQL with the Sequel Pro GUI tool, It has a
table duplication menu
Chip,
My initial observations are:
* I think [ ] around the table name are not required (that's not part of the
SQL standard)
* it would seem that 4D's implementation of Alter table doesn't support "rename"
Regards,
Narinder Chandi,
ToolBox Systems Ltd.
--
-Original Message-
From:
20:23
To: 4D Tech Mailing List <4d_tech@lists.4d.com>
Cc: Narinder Chandi <4dtechmailingl...@toolbox.uk.com>
Subject: Re: What is wrong with this statement? Corrected
At least it is easy to work around...
On Tue, 09 Jul 2019 20:18:18 +0100, Narinder Chandi via 4D_Tech
{ } can not be an expression (at least in v13). Even a
simple expression {2+8-6} fails.
Chip
On Tue, 09 Jul 2019 19:32:05 +0100, Narinder Chandi via 4D_Tech wrote:
> That was with 17.2 Mac and I also tested the same code just now with
> 15.4
be that the issue is resolved in a newer
version (>v13) then I am working in...
On Tue, 09 Jul 2019 18:30:33 +0100, Narinder Chandi via 4D_Tech wrote:
> Chip,
>
> If I interpreted it correctly, I just created this code block based
> on your spec. an
Does it work if you do use an intermediate value? e.g.
$value:= $Return_ptr-> {$Item}
$Result:= $Column1 ->{$value}
Regards,
Narinder Chandi,
ToolBox Systems Ltd.
--
-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> on behalf of 4D Tech Mailing List
Replying to myself here(!) but I should also have mentioned a third thing to
check:
* have you used the correct name in the $ListBoxName variable?
* what does $tableNum contain? It should be a valid table number
* check the contents of $highlightSet - it should be a non-empty string
Regards,
Carl,
Hi. Couple of obvious things to check:
* have you used the correct name in the $ListBoxName variable?
* what does $tableNum contain? It should be a valid table number
Regards,
Narinder Chandi,
ToolBox Systems Ltd.
--
-Original Message-
From: 4D_Tech
Chuck,
Been a long, long time since I write any AppleScript and I don't know what the
dictionary for Preview supports but did you try passing "properties {...}" to
" without print dialog" - logically it doesn't make sense, but it might crazily
work?!
Another (more hacky) option could be try
From memory, this error is usually triggered because a record you are trying to
access doesn't exist. You need to look at the context in which you are trying
to create the selection to figure this error out. Perhaps you are in a
transaction?
Regards,
Narinder Chandi,
ToolBox Systems Ltd.
--
David,
Hi. I believe your starting point will be the "Communication" section of the
docs. For the latest v17.3 this is the link:
https://doc.4d.com/4Dv17/4D/17.2/Communications.201-4385988.en.html
HTH.
Regards,
Narinder Chandi,
ToolBox Systems Ltd.
--
-Original Message-
From:
Michael,
Hi. Well, straight away I can see that the your CREATE TABLE command includes
specific directives that only apply to MySQL, e.g.
ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
so that will most likely be the reason why it is ignored. I think you need to
adapt
Douglas,
Thanks. Plenty of food for thought in your post too!
Regards,
Narinder Chandi,
ToolBox Systems Ltd.
--
Kirk has explained how the “form controller” approach works and it is
essentially the same as selector methods. In the past, I avoided that
approach, as I’ll touch on
Thanks Douglas. Yes, the Find in design has been amazing since v11 (I think?),
certainly I have used it a _lot_ in recent years in v15! The next best thing to
4D Insider, but still not anywhere near as good ;)
Regards,
Narinder Chandi,
ToolBox Systems Ltd.
--
-Original Message-
S, I suspected this would be the case but just seeking confirmation...
I am working with a 4D database that has made extensive use of dot in table,
variable and project names (not of my doing btw!), e.g.
[my.table.name]
my.process.variable
my.project.method
Converting the database to v17
Kirk,
Hi. Thanks for that lengthy response! You make a lot of useful points in
regards to v17 for sure and in fact I have already been reading up and
digesting the implications of the new ways of working in 4D, particularly Form
and ORDA. And yes, it totally makes sense to re-think ones
I'm wondering, who out there is still actively developing using selector
methods?
For a long time now (way back since v6, perhaps even before that...) I have
tended to encapsulate all of my code into Project Methods such that Form and
Object level methods consist of nothing more than a
I may be mistaken but I have a feeling that these kind of "magic" window types
(for want of a better description) are a relic of the ancient history of the
Mac (we are talking as far back Mac OS OS 7 and 8) and there availability in 4D
is an un-documented feature and therefore wholly
Maybe this is too obvious or difficult due to the sheer size of the logfile,
but would it not be possibly to ingest the log file into a database for easy
searching? You could maybe use 4D :P
Alternatively, how about feeding it into a log monitoring and analysis service
such as Splunk,
example:
> Run a bunch of reports to Excel xml, or text files. Manually check them
> for accuracy, then lock the files.
> Nightly, run the same reports and run diffs on them. If any differences,
> let us know.
>
> Jim
>
>
> On Tue, Jun
Jim,
Hi. I'm curious:
>> ...in dev-build-test cycle. This is where we run automated, headless builds
>> and tests with multiple data files...
Are you able to describe this in more detail? I would quite like to learn what
kind of build/test can be implemented for 4D.
Having worked quite a lot
Luc,
Only obvious thing I can think is did you check that the image embedded in the
email is available on the client's server? After that maybe worth checking the
raw source of the email to see what if anything is different in the content?
Regards,
Narinder Chandi,
ToolBox Systems Ltd.
--
Pat,
Interesting link. Will that work for Jeremy as it looks like that documentation
is in relation to notarizing software built using Xcode only?
Regards,
Narinder Chandi,
ToolBox Systems Ltd.
--
Jeremy,
This should help:
Bob,
>> I’ve just been handed a website to host with 4D. No big deal, I thought.
>> Except it built with WordPress.
If it's a WordPress site then, unless I'm mistaken, you wouldn't actually host
it with 4D right? Perhaps your wording is just not conveying the correct
intention...
I have
Jun 7, 2019, at 8:48 AM, Narinder Chandi via 4D_Tech
<4d_tech@lists.4d.com> wrote:
>
> Hi all. I am migrating a v15 database to v17, 4D Server running on Mac. I
need some opinions as to what to do with regards to converting commands marked
as obsolete as per this article:
[snip
4D (or any .app) must be installed by drag & drop from a signed .dmg,
directly to a subfolder of /Applications,
or by using a signed .pkg.
if you .zip it yourself, or install elsewhere, the .app is translocated and
you get all sorts of problems.
> 2019/06/14 0:03、Narinder
So, I was trying to install 4D v17.1 on a 2016 MacBook Pro running OS X 10.13.6
(High Sierra). The installer was a direct download from 4D.com. Any attempt to
launch 4D resulted in a hard crash - the output from the Crash Report for 17.2
is below.
I tried re-installing, re-booting, starting
Could you import the SQL script file using the SQL EXECUTE SCRIPT command?
Regards,
Narinder Chandi,
ToolBox Systems Ltd.
--
-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> on behalf of 4D Tech Mailing List
<4d_tech@lists.4d.com>
Reply-To: 4D Tech Mailing List
Thanks Keisuke, that looks like an acceptable solution for James I hope. The
only comment I have is whether:
$regex:="[:^ascii:]"
should actually be:
$regex:="[[:^ascii:]]"
Since although 4D is accepting the first version, when I tested this with
https://regex101.com it complained that "A
James,
Hi. It's late here now but I will look into this tomorrow. In my experience
Regex can be a bit of a black art at times but once you get the hang of it you
come to see how useful and powerful it can be.
Regards,
Narinder Chandi,
ToolBox Systems Ltd.
--
-Original Message-
In fact thinking about the Regex solution some more, even if there is no Regex
support using 4D commands you could pipe it through the built-in PHP
interpreter as there is excellent Regex support in PHP.
Regards,
Narinder Chandi,
ToolBox Systems Ltd.
--
-Original Message-
From:
James,
Hi. I encountered a similar problem a while back although the client sending
the request to MySQL was PHP rather than 4D. My solution was to use Regex to
replace the emoji characters. Try Googling for something like "remove emojis
from string" and that should turn up some options you
Luc,
I assume that this 4D database is running on Windows since DDE is a Windows
technology, I think DDE is Dynamic Data Entry which is a way of communicating
between Windows programs, I think it was quite commonly used to send/receive
information from Excel and also other applications. I
Chip,
from memory so...
One note:
- I believe existing (v15+) subtable support is one level deep only, I
do not know if this will/does affect you.
i.e [parent].substable_level1.subtable_level2... is not supported.
I'm not affected by this.
there is a special link
Thanks. Yes, there is good example in the docs for "Get subrecord key ":
https://doc.4d.com/4Dv15/4D/15.6/Get-subrecord-key.301-3818017.en.html
Regards,
Narinder Chandi,
ToolBox Systems Ltd.
--
-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> on behalf of 4D Tech
1 - 100 of 107 matches
Mail list logo
