John,
You say "Show me all cities within 4 minutes from this longitude/latitude."
I propose to search in a square around your location, ie make a search lat +- 4
miles and long +- 4 miles.
You will get a few occurrences and then refine the search to a circle with
geodesic functions.
Luc,
For Find and replace, try this method
Reference inside
Cordialement,
Bernard Escaich
> Le 14 avr. 2020 à 22:36, Luc Devar via 4D_Tech <4d_tech@lists.4d.com> a écrit
> :
>
> I am still using 4Dwrite and need to eventually convert to 4DwritePro but did
> not find the time to start
Should have been search
On Tue, Apr 14, 2020 at 5:33 PM John J Foster via 4D_Tech <
4d_tech@lists.4d.com> wrote:
> Hey Chuck,
>
> Not sure what “hash and stir” means?
>
> Matching data requires one kind of index for speed and doing a radial
> search another.
>
> In the db where I only have 1/2
Hey Chuck,
Not sure what “hash and stir” means?
Matching data requires one kind of index for speed and doing a radial search
another.
In the db where I only have 1/2 million records with longitude as a real the
index returns a range quite quickly. So I’ll keep it for the radial search.
For
Hey Peter,
I have already added and split out the longitude into separates fields. So I
have the original longitude as a real and I have it separated into two other
fields.
There are only 360 integer longitudes (ignoring the decimal part) possible.
Potentially -180 through +180. In this case
On Apr 14, 2020, at 3:39 PM, Peter Bozek wrote:
> Cluster index is suitable when the result of search is a (potentially
> large) selection. While B-tree node stores a reference to a record, Cluster
> index node stores a selection, so no selection building is needed. However,
> if I would design
Sure you hash and stir that, when searching for a particular lat/long
combination you has entry and search
This will not help in distance calculations
How about this for a create a concatenated key that has two parts for each
Named LatKey
Lat_before decimal
Lat_after decimal
I am still using 4Dwrite and need to eventually convert to 4DwritePro but did
not find the time to start this yet. I have a process on the server ( 64 bits)
that send email containing a 4Dwrite document. Since I am on 64 bits. I cannot
use any of the old 4D write command. So I am converting my
I did not, but this happens with multiple connection types and points, but will
try and advise but not today
Regards
Chuck
Chuck Miller Voice: (617) 739-0306
Informed Solutions, Inc. Fax: (617)
Did you try clearing the local resources and start over?, we have had
unexplained issues on specific machines that went away when we started fresh.
Lahav
-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Charles Miller via
4D_Tech
Sent: Tuesday, April 14,
John,
I do not think using text for dat that can be represented by number is a
good idea. It require more memory - do not forget that Unicode uses 2 bytes
for each character - and manipulation of bigger data structures is slower,
but, especially, string manipulation, including comparison,
I have tried that as well. I added change user after trying to log in as
designer. Result crash. Logging in as administrator. Result crash. Change
user. Result crash
Regards
Chuck
On Tue, Apr 14, 2020 at 3:47 PM Tim Nevels via 4D_Tech <4d_tech@lists.4d.com>
wrote:
> On Apr 14, 2020, at 2:00
On Apr 14, 2020, at 2:00 PM, Chuck Miller wrote:
> Environment windows server 2016. 4D 17.4 running as a built server. Server
> running as a service.
>
> I am logged in as Administrator.
>
> A one line method
> OPEN ADMINISTRATION WINDOW
>
> 4D crashes every time
>
> I have changed method to
Yes on a client. not on the server
On Tue, Apr 14, 2020 at 3:25 PM lists via 4D_Tech <4d_tech@lists.4d.com> wrote:
>
> Chuck,
>
> Just to make sure, you are executing that command on a client, not on the
> server with a stored proc or Execute on server right?
>
> Lahav
>
> -Original
Chuck,
Just to make sure, you are executing that command on a client, not on the
server with a stored proc or Execute on server right?
Lahav
-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Charles Miller via
4D_Tech
Sent: Tuesday, April 14, 2020 1:17 PM
Hey Chuck,
Given my last response and my needs…
I am trying to visualize how a hash would work? Can you give me an example
using a longitude and latitude?
Thanks,
John…
> You could use a hash and store it. I have a sequence that is too long to
> query and that is what I did works like a
Hi Arnaud,
Hmmm...
I think I would like the data to be obvious to my eyes when I look at it.
My initial goal was simply to be able to match up a location with a missing
Olson Timezone ID. Import the data, fix the data in the much larger db, and
then export it back out to reimport into it’s
Hi Arnaud,
I have split out the longitudes into a text and real component. I have
formatted the longitudes as “000” and if west of GMT prefixed with “-“ and if
east prefixed with “+“. I'll do something similar with latitudes and then try
building some radial searches and see.
Since all string
Tried that with same result
On Tue, Apr 14, 2020 at 3:15 PM Bob Miller via 4D_Tech <4d_tech@lists.4d.com>
wrote:
> Hi Chuck,
>
> RE> A one line method
> RE> OPEN ADMINISTRATION WINDOW
>
> RE> 4D crashes every time
>
> What if you open a new process method with the one line?
>
> I call OPEN
Hi Chuck,
RE> A one line method
RE> OPEN ADMINISTRATION WINDOW
RE> 4D crashes every time
What if you open a new process method with the one line?
I call OPEN ADMINISTRATION WINDOW and it does work, but I have it in its own
process. Can't say why other than that's how I wrap all my primary
Hi All,
Environment windows server 2016. 4D 17.4 running as a built server. Server
running as a service.
I am logged in as Administrator.
A one line method
OPEN ADMINISTRATION WINDOW
4D crashes every time
I have changed method to add change user crashes in the same place
Any ideas
Regards
You could use a hash and store it. I have a sequence that is too long to query
and that is what I did works like a charm.
Regards
Chuck
Chuck Miller Voice: (617) 739-0306
Informed Solutions, Inc.
Thanks all.
Luckily the fault was mine, not 4Ds :)
Your answers assured my that 4d can produce wp til pdffound that the
document was produced but on another disk/folder than expected...! My fault
-
Hilsen
--
Helge Antonsen
www.4dialog.no
--
Sent
> Le 13 avr. 2020 à 23:51, John J Foster via 4D_Tech <4d_tech@lists.4d.com> a
> écrit :
>
> Hey Bernard,
>
> I would use text values if I didn’t think I needed to do range searches. It’s
> not a “live” db so I can play and experiment to my hearts content.
Considering 5 million pairs of
Hilsen,
This works for me (v17r6, Mac):
*SET PRINT OPTION*(Destination option;3;$pathname)
*WP PRINT*(WPdoc)
*SHOW ON DISK*($pathname)
Pat
On Tue, 14 Apr 2020 at 10:30, 4dialog via 4D_Tech <4d_tech@lists.4d.com>
wrote:
>
> - On mac i normaly produce pdf documents via SET PRINT
>
Hi Hilsen
This works fine for us, we never preview (16 and currently 17r6, 18 and 18r2)
$longDocName:=$pathname+$docname
SET PRINT OPTION(Orientation option;1)
SET PRINT OPTION(Destination option;3;$longDocName)
- On mac i normaly produce pdf documents via SET PRINT OPTION(9;3;$FileName)
and then some print commands. But SET PRINT OPTION does not work when used
with WP Print. No error, OK=1 but no pdf is created? Tested with 4d 16.6 and
17.4.
If i use SET PRINT PREVIEW(True) before WP Print, i get the
> Le 13 avr. 2020 à 19:36, Bernard Escaich via 4D_Tech <4d_tech@lists.4d.com> a
> écrit :
>
> Hi John,
>
> From the top of my head, indexes on long are less efficient than on text
> values ; I have a doubt, perhaps only for updating.
I'd think the opposite, an index based on a "fixed length"
28 matches
Mail list logo