Re: v2003 installer?

[webmaster namethatplant.net via 4D_Tech]

I have it, Pat.
Will send it this afternoon -

Janie


> On August 31, 2019 at 9:09 AM Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> 
> Anybody know where I can find a 4Dv2003 Mac installer?
> 
> PB
> 
> -- 
> *
> 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
> **
**
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: unicode, blobs, and the web

[webmaster namethatplant.net via 4D_Tech]

A belated thank you, Miyako, for the clarification. I didn't think that was 
enough text to have filled up 2 GB, but I didn't know how to calculate its size.

I still have a question.
The write-up for PROCESS HTML TAGS contains the warning, "It is now highly 
inadvisable to store texts in BLOBs".

I don't use the command "PROCESS HTML TAGS" but I have used BLOB variables in 
several other places throughout my website. These don't contain any 
troublemaker characters and they are working well.

Do I need to convert them to text variables?

Thank you!
Janie

--
>2019/08/10 2:35, webmaster namethatplant.net via 
>4D_Tech <4d_tech@lists.4d.com>ÇÃ ÉÅÅ[Éã:
>
>I didn't see that important detail mentioned anywhere but in reference to that 
>one command, but, since text variables can now hold up to 2 GB, I tried 
>substituting a text variable.
>Doing that did clear up the multiplication sign issue, but now the data was 
>truncated. Only about 3000 line items were displayed.
>Would 4000 line items be enough to overflow 2 GB? (Each line item contains 
>only around 300 characters.)

no.

if each line contains 300 characters, and there are about 3,000 lines, you'd 
have 900,000 characters.
2GB is 2*1024*1024*1024 bytes. a unicode code point in UTF-8 is 1 to 6 bytes in 
theory,
although 5 and 6 byte characters are not defined yet. so you have plenty of 
room.

that said, BLOB to text conversion (4D legacy encoding a.k.a. MacRoman to 
Unicode) is limited to 32,000 bytes, for backward compatibility.

https://doc.4d.com/4Dv16/4D/16.6/BLOB-to-text.301-4445240.en.html
in other words, C_TEXT can hold up to a quarter billion bytes but the 
conversion from BLOB to text stops at 32k bytes. ...
**
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
**

unicode, blobs, and the web

[webmaster namethatplant.net via 4D_Tech]

v12.6  OS 10.6.8

Hello!
I was recently made aware of the fact that, on some web pages, a multiplication 
sign was displaying as what looked like a square root symbol + a lowercase 
accented "o".

The database is running in unicode; the web site is using UTF-8. The pages in 
question are displaying a blob variable that contains about 4000 line items. 
The blob was created using the constant UTF8 text without length.

The only clue I found was a brief note under PROCESS HTML TAGS: "Beginning with 
version 12 of 4D, when you use BLOB type parameters, the command automatically 
considers that the character set used for BLOBs is MacRoman."

I didn't see that important detail mentioned anywhere but in reference to that 
one command, but, since text variables can now hold up to 2 GB, I tried 
substituting a text variable.

Doing that did clear up the multiplication sign issue, but now the data was 
truncated. Only about 3000 line items were displayed.

Would 4000 line items be enough to overflow 2 GB? (Each line item contains only 
around 300 characters.)

I can split the data into two text variables, and that appears to work, but it 
seems like it should be unnecessary.

What are some recommended ways to handle this?

Thank you all in advance -
Janie


Janie Marlow
webmas...@namethatplant.net
Travelers Rest, SC
**
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: Publishing a DB on the WWW. Howto.

[webmaster namethatplant.net via 4D_Tech]

Nolen -

There are many, many more options today than there used to be (browse the iNug 
archives for some lively discussions), but David Adams book is a comprehensive 
primer that many developers have used over the years, especially to get 
started. It is now available for download, free, as David tells us in his 2013 
letter below.

_
Date: Mon, 4 Nov 2013 18:38:55 +1100
Subject: 4D Web Companion PDF available for download

I've been asked many times over the years for a PDF version of this book
and have finally dug up a copy. You can find the link here:

http://www.island-data.com/
...
Regarding the PDF:
* I've embedded a full text index to make searches quicker in some readers.

* Some readers show a black background on some images instead of a
transparent background. File under "I can't fix that now." Reader seems
fine.

* The bookmark structure - now you all see how I think ;-)

Regarding the content:
4D has done an *amazing* job of keeping their Web server backwards
compatible. Despite being an old title, most of the content in this book is
still correct. It's not complete, of course, but it's fundamentally
correct. Again, that's to 4D's credit, not mine.

Regarding the cost:
Free. Thanks to everyone over the years for supporting my trainings and
writings. Much appreciated! If anyone is overwhelmed by a need to share,
there's an Amazon referral click-through on my site and I'm always in the
market for iTunes gift cards to buy yet more birding apps. In any case, I'm
happy if some of you find the PDF helpful.

-- David Adams

_
To: 4d_tech@lists.4d.com
Subject: Publishing a DB on the WWW. Howto.
Date: Sun,  2 Dec 2018 18:56:35 -0700 (MST)
From: Nolen via 4D_Tech <4d_tech@lists.4d.com>
Reply-To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: no...@internode.on.net

I have a small DB which does what it needs to do and now I would like to run 
aspects of it on the WWW.
I understand this is possible but I don't have any real knowledge of websites 
and how to publish them.

Is there a public or demo database anyone can recommend which will help me 
understand how to achieve this?

Thanks.

_
Sent from http://4d.1045681.n5.nabble.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: is it possible to rename the data file?

[webmaster namethatplant.net via 4D_Tech]

Thank you, Chip and Chuck!
I was afraid that if I fiddled with the names it might somehow corrupt the 
"strong link" between v12's structure and data files. 
For the archives, I changed the names of the .DD, .INDX, and .MATCH files, also 
the backup files .BK AND .BL.

Why v12? Well, it's closer to current than v2004, and I was not up to the 
challenge of leaping all the way to 15, 16 or 17 in one go, much as I might 
have liked to. Besides, v12 is paid for... :-)

Thanks again -
Janie

---
On August 2, 2018 at 3:47 PM Charles Miller wrote:
A. why are you going to v12. 
B yes you can change name but the server or standalone can not be running when 
you do it. I do not remember in v12 what naming conventions were re 4D, so it 
may not be just the data file you need to rename
Regards
Chuck

---
On August 2, 2018 at 3:46 PM Chip Scheide <4d_o...@pghrepository.org> wrote:
at the desktop (OS) level rename the data file.
on start up the database will ask you where the data file is.
point it to the newly renamed data file.

---
On Thu, 2 Aug 2018 15:42:48 -0400 (EDT), webmaster namethatplant.net via 
4D_Tech wrote:
Is it possible to rename the data file in v12?
After converting a v2004 database to v12, but before I'd finished 
making the necessary changes to the code, I converted datafile 
updates more than once. Unfortunately, I forgot to change the name of 
the datafile on the last conversion, so it has the old (v2004) name.
Too late to import again: it's got two weeks worth of new data.
I guess it doesn't hurt anything, but it's confusing and untidy, 
especially when looking at the backup files.
Is there any way to (easily) fix this?
Thank you -
**
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
**

is it possible to rename the data file?

[webmaster namethatplant.net via 4D_Tech]

Is it possible to rename the data file in v12?

After converting a v2004 database to v12, but before I'd finished making the 
necessary changes to the code, I converted datafile updates more than once. 
Unfortunately, I forgot to change the name of the datafile on the last 
conversion, so it has the old (v2004) name.

Too late to import again: it's got two weeks worth of new data.

I guess it doesn't hurt anything, but it's confusing and untidy, especially 
when looking at the backup files.

Is there any way to (easily) fix this?

Thank you -
Janie Marlow
webmas...@namethatplant.net
Travelers Rest, SC
**
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
**

autocomplete/ typeahead for a web application?

[webmaster namethatplant.net via 4D_Tech]

I would like to add an autocomplete/ typeahead function to a web application, 
and I'd be interested to know what y'all recommend that can work with 4D's 
built-in web server (v12.6).

Is anyone using Awesomplete? Does it work with mobile browsers?

I read that Twitter's Typeahead does not work with mobile browsers, also that 
it is no longer supported -- Can anyone confirm?


Thanks!
Janie Marlow
webmas...@namethatplant.net
Travelers Rest, SC
**
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: query for empty string

[webmaster namethatplant.net via 4D_Tech]

Thank you, Keisuke.

I will take this off my list of things to worry about

Janie


-
Date: Thu, 15 Feb 2018 04:03:03 +
From: Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com>

> but I'm still trying to wrap my brain around the sorts of situations that 
> might require using length=0

as mentioned in the previous post,
there are some (non) characters that has a measurable length but whose sorting 
value is equal to that of "".
Char(0) and Char(1) are such examples.

> Given a group of records,
> * some created manually with data keyboarded in
> * some created programmatically with data imported from tab delimited text 
> that was exported from Excel

the reason I hesitate to answer your question is because "how the record was 
created" is not the deciding factor.
unicode "sorting value" is basically determined by the code point (character 
code) and locale (database settings).

technically, I suppose it is possible to enter non characters by the keyboard 
(paste) or via Excel.
but normally that would happen in the context of non-empty text.

so for all practical purposes, I wouldn't call ="" a major vulnerability.
I would though, avoid it for validating web input (because there are bad people 
out there).
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: query for empty string

[webmaster namethatplant.net via 4D_Tech]

Thank you, Miyako -
I'm very glad to know that it is okay to continue to use =""   (in general)
but I'm still trying to wrap my brain around the sorts of situations that might 
require using length=0

Given a group of records,
* some created manually with data keyboarded in
* some created programmatically with data imported from tab delimited text that 
was exported from Excel

Will QUERY([Table];[Table]Field="") deliver the same results as it has in the 
past?

Thank you!
Janie



Date: Mon, 5 Feb 2018 21:11:56 +
From: Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com>

Hello,

it is not a matter of western or non-western.
the test for length=0 is only necessary if you can reasonable expect string 
that collates to "".

c.f.

$test:=""=Char(0)
$test:=""=Char(1)

  //both is true

otherwise you can continue to use ="" for queries and string in general.



2018/02/06 0:31ÅAwebmaster namethatplant.net via 
4D_Tech <4d_tech@lists.4d.com> ÇÃÉÅÉãÅF

QUESTION:
In versions 12+, in unicode mode, if the field contains only routine Western 
characters,
is it okay to continue to use
QUERY([Table];[Table]Field="")

and only if the field may contain nonWestern characters, use
QUERY SELECTION BY FORMULA([Table];Length([Table]Field)=0)
???


**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

query for empty string

[webmaster namethatplant.net via 4D_Tech]

Hello all -
I have converted a database from v2004 to v12, and Unicode is ON.

Conversion4Dv11SQL_R9.pdf, page 69, says:
In Unicode Mode, if you want to check if a string does not contain any 
characters, including ignorable ones, you need to use the following test:
If (Length(vText)=0)
Instead of
If (vText="").

I don't see that advice repeated anywhere else in v11 or v12 docs, but I may 
have missed it.

To find empty strings, both v11 and v12 Language docs recommend:
QUERY([People];[People]Company="")

In previous versions, I would assume that "an empty string" was the same thing 
as "a string that does not contain any characters", but in this context I'm not 
sure


QUESTION:
In versions 12+, in unicode mode, if the field contains only routine Western 
characters,
is it okay to continue to use  
QUERY([Table];[Table]Field="")

and only if the field may contain nonWestern characters, use
QUERY SELECTION BY FORMULA([Table];Length([Table]Field)=0)
???

Thank you -
Janie Marlow
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**