Re: v13 - SQL alter table, what is wrong?

[Chuck Miller via 4D_Tech]

I missed th v13 part. Is the field already set as indexed and unique. If not I 
would bet alter table would not work. I do not know what would happen in newer 
versions if you tried to assign UUID inside 4D without it being a UUID field

Have you tried other data types. 

Regards

Chuck

 Chuck Miller Voice: (617) 739-0306
 Informed Solutions, Inc. Fax: (617) 232-1064   
 mailto:cjmillerinformed-solutions.com 
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D and Sybase connectivity
  http://www.informed-solutions.com  

This message and any attached documents contain information which may be 
confidential, subject to privilege or exempt from disclosure under applicable 
law.  These materials are intended only for the use of the intended recipient. 
If you are not the intended recipient of this transmission, you are hereby 
notified that any distribution, disclosure, printing, copying, storage, 
modification or the taking of any action in reliance upon this transmission is 
strictly prohibited.  Delivery of this message to any person other than the 
intended recipient shall not compromise or waive such confidentiality, 
privilege or exemption from disclosure as to this communication. 

> On Sep 17, 2018, at 4:28 PM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> what does a length of 0 have to do with setting the field as a primary 
> key?

**
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: v13 - SQL alter table, what is wrong?

[Chuck Miller via 4D_Tech]

I think it should be

ALTER TABLE [Anmlprot_File_Link] 
ADD [Journal_Key] [Primary KEY]

This is from the 4D docs
ALTER TABLE sql_name
{ADD column_definition [PRIMARY KEY] [TRAILING] |
DROP sql_name |
ADD primary_key_definition |
DROP PRIMARY KEY |
ADD foreign_key_definition |
DROP CONSTRAINT sql_name |
[{ENABLE | DISABLE} REPLICATE] |
[{ENABLE | DISABLE} AUTO_INCREMENT] |
[{ENABLE | DISABLE} AUTO_GENERATE] |
SET SCHEMA sql_name}

Chuck

 Chuck Miller Voice: (617) 739-0306
 Informed Solutions, Inc. Fax: (617) 232-1064   
 mailto:cjmillerinformed-solutions.com 
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D and Sybase connectivity
  http://www.informed-solutions.com  

This message and any attached documents contain information which may be 
confidential, subject to privilege or exempt from disclosure under applicable 
law.  These materials are intended only for the use of the intended recipient. 
If you are not the intended recipient of this transmission, you are hereby 
notified that any distribution, disclosure, printing, copying, storage, 
modification or the taking of any action in reliance upon this transmission is 
strictly prohibited.  Delivery of this message to any person other than the 
intended recipient shall not compromise or waive such confidentiality, 
privilege or exemption from disclosure as to this communication. 

> On Sep 17, 2018, at 3:48 PM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> $SQl_Command:="ALTER TABLE [Anmlprot_File_Link] ADD PRIMARY KEY 
> (Journal_Key)"

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

Using a custom namespace in SVG

[Keith Culotta via 4D_Tech]

I'm taking a shot at using a custom namespace, but can't find an example of its 
implementation in 4D SVG.
Experimenting, I noticed that all three attributes below assigned with 
SVG_SET_ATTRIBUTES worked without returning an error when created, when used 
with SVG_GET_ATTRIBUTES, or when opened in Chrome and Safari.

Are all of these forms "legal"?

-
$svg:=SVG_New 
SVG_ADD_NAMESPACE ($svg;"declaredNS";"http://www.somewhere.com;)
$ref:=SVG_New_rect ($svg;10;10;100;100)

SVG_SET_ATTRIBUTES ($ref;\
  "declaredNS:myAtt";"AnyAtt";\
  "ThisNSWorks:myAtt";"AnyAtt";\
  "andThisWorks";"AnyAtt")

SVG_CLEAR ($svg)
-

Yields this:
 rect ThisNSWorks:myAtt="AnyAtt" andThisWorks="AnyAtt" 
declaredNS:myAtt="AnyAtt" fill="white" height="100" stroke="black" width="100" 
x="10" y="10"

Thanks - Keith - CDI
**
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: v13 - SQL alter table, what is wrong?

[Charles Miller via 4D_Tech]

Chip what version of 4D a UUID key has a lenght of 0 in at least v15 and
higher.



On Mon, Sep 17, 2018 at 3:49 PM Chip Scheide via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> trying to set a new field in a new table as primary key
>
> $SQl_Command:="ALTER TABLE [Anmlprot_File_Link] ADD PRIMARY KEY
> (Journal_Key)"
>
> Begin SQL
>  Execute Immediate : $Sql_Command
> end SQL
>
> table : [Anmlprot_File_Link]  exists
> Field : Journal_Key  exists as a field in [Anmlprot_File_Link]
>
> Journal_Key defined as: String 255, Unique, Indexed, Null, UUID, Auto
> UUID
>
> When I run the above sql line of code - the field is NOT set to be a
> primary key.
>
> As an aside, is setting a field as primary key an option (check box) in
> the Field properties dialog?
>
> Thanks
> Chip
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing
> **
> 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
> **



-- 
-
 Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064
 Informed Solutions, Inc.
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D, Sybase & SQL Server connectivity
  http://www.informed-solutions.com
-
This message and any attached documents contain information which may be
confidential, subject to privilege or exempt from disclosure under
applicable law.  These materials are intended only for the use of the
intended recipient. If you are not the intended recipient of this
transmission, you are hereby notified that any distribution, disclosure,
printing, copying, storage, modification or the taking of any action in
reliance upon this transmission is strictly prohibited.  Delivery of this
message to any person other than the intended recipient shall not
compromise or waive such confidentiality, privilege or exemption
from disclosure as to this communication.
**
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: Understanding a Runtime Error message

[Timothy Penner via 4D_Tech]

What version are you using?

It sounds like the following bug:

ACI0097564   Unexpected Runtime internal timer error #22 during a Backup.

This was fixed  in 16 R6 and 16.3

-Tim



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

v13 - SQL alter table, what is wrong?

[Chip Scheide via 4D_Tech]

trying to set a new field in a new table as primary key

$SQl_Command:="ALTER TABLE [Anmlprot_File_Link] ADD PRIMARY KEY 
(Journal_Key)"

Begin SQL
 Execute Immediate : $Sql_Command
end SQL

table : [Anmlprot_File_Link]  exists
Field : Journal_Key  exists as a field in [Anmlprot_File_Link]

Journal_Key defined as: String 255, Unique, Indexed, Null, UUID, Auto 
UUID

When I run the above sql line of code - the field is NOT set to be a 
primary key. 

As an aside, is setting a field as primary key an option (check box) in 
the Field properties dialog?

Thanks
Chip
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
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: Understanding a Runtime Error message

[Sandor Szatmari via 4D_Tech]

Thanks for the guidance all….  Will include this right off the bat next time.

Mac
Version 15 R5

Sounds like it’s the issue you referenced.  I appreciate it.  How do I a. Look 
up the details for that issue, b. Find these issues on my own?

Again thanks for the trip to school.  :)

Sandor Szatmari

> On Sep 17, 2018, at 15:02, Timothy Penner via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> What version are you using?
> 
> It sounds like the following bug:
> 
> ACI0097564   Unexpected Runtime internal timer error #22 during a Backup.
> 
> This was fixed  in 16 R6 and 16.3
> 
> -Tim
> 
> 
> 
> **
> 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
> **



CONFIDENTIALITY NOTICE: This email (and any related attachments) contains 
information from InfoPlus (a service of Bristol Capital, Inc.). It is intended 
only for the addressee and may contain information that is confidential and/or 
otherwise exempt from disclosure under applicable law. If you are not the 
intended recipient or are acting as agent for the intended recipient, any use 
or disclosure of this communication is prohibited. If you have received this 
communication in error, please notify us immediately to arrange for the 
appropriate method of returning or disposing of the communication. If our 
respective Companies have confidentiality provisions in effect, this email and 
the materials contained herein are deemed CONFIDENTIAL and should be treated 
accordingly unless expressly provided otherwise.

**
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: v13 - SQL alter table, what is wrong?

[Chip Scheide via 4D_Tech]

title says what version   :)

what does a length of 0 have to do with setting the field as a primary 
key?

On Mon, 17 Sep 2018 16:05:29 -0400, Charles Miller via 4D_Tech wrote:
> Chip what version of 4D a UUID key has a lenght of 0 in at least v15 and
> higher.
> 
> 
> 
> On Mon, Sep 17, 2018 at 3:49 PM Chip Scheide via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> trying to set a new field in a new table as primary key
>> 
>> $SQl_Command:="ALTER TABLE [Anmlprot_File_Link] ADD PRIMARY KEY
>> (Journal_Key)"
>> 
>> Begin SQL
>>  Execute Immediate : $Sql_Command
>> end SQL
>> 
>> table : [Anmlprot_File_Link]  exists
>> Field : Journal_Key  exists as a field in [Anmlprot_File_Link]
>> 
>> Journal_Key defined as: String 255, Unique, Indexed, Null, UUID, Auto
>> UUID
>> 
>> When I run the above sql line of code - the field is NOT set to be a
>> primary key.
>> 
>> As an aside, is setting a field as primary key an option (check box) in
>> the Field properties dialog?
>> 
>> Thanks
>> Chip
>> ---
>> Gas is for washing parts
>> Alcohol is for drinkin'
>> Nitromethane is for racing
>> **
>> 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
>> **
> 
> 
> 
> -- 
> 
-
>  Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064
>  Informed Solutions, Inc.
>  Brookline, MA 02446 USA Registered 4D Developer
>Providers of 4D, Sybase & SQL Server connectivity
>   http://www.informed-solutions.com
> 
-
> This message and any attached documents contain information which may be
> confidential, subject to privilege or exempt from disclosure under
> applicable law.  These materials are intended only for the use of the
> intended recipient. If you are not the intended recipient of this
> transmission, you are hereby notified that any distribution, disclosure,
> printing, copying, storage, modification or the taking of any action in
> reliance upon this transmission is strictly prohibited.  Delivery of this
> message to any person other than the intended recipient shall not
> compromise or waive such confidentiality, privilege or exemption
> from disclosure as to this communication.
> **
> 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
> **
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
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: v16 - playing videos stored in the database

[Jody Bevan via 4D_Tech]

Tai:

Thanks, I will take a read through these. In the case for the current client I 
am wanting this for it is a one off application so having the videos stored 
locally (on their server) is likely the better way. 

For our Shell training videos the other storage off site is the better way to 
go for sure.

Thanks

Jody Bevan

> On Sep 17, 2018, at 11:00 AM, Tai Bui via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi,
> 
> Perhaps the following two Tech Tips can give you an idea on how to implement 
> your feature:
> 
> If HTML5 is available:
> http://kb.4d.com/assetid=77517
> 
> 
> If Youtube is available:
> http://kb.4d.com/assetid=77911
> 
> Best Regards,
> -Tai B.
> 
> 
> 
> **
> 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: v16 - playing videos stored in the database

[Tai Bui via 4D_Tech]

Hi,

Perhaps the following two Tech Tips can give you an idea on how to implement 
your feature:

If HTML5 is available:
http://kb.4d.com/assetid=77517


If Youtube is available:
http://kb.4d.com/assetid=77911

Best Regards,
-Tai B.



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

Understanding a Runtime Error message

[Sandor Szatmari via 4D_Tech]

I received the following runtime error from 4D server.  The runtime error 
dialog was just sitting on the server screen when I got in.



Text from the runtime error dialog (pressed the copy button)

Error


Invalid argument


Error code: 22
Invalid argument
component: 'POSX'
task -2, name: 'Internal Timer Process'



Looking up 'Error code: 22' I see it is defined as: 'The fields must belong to 
the same table or subtable for a sort or graph.'


But, I don't know how to take this information and trace it back to what caused 
this.


How do I track this down?



Thanks in advance!

Sandor Szatmari


















Senior Software Developer
Bristol Capital Inc. - InfoPlus
201 746 7215
www.infoplusonline.com

CONFIDENTIALITY NOTICE: This email (and any related attachments) contains 
information from InfoPlus (a service of Bristol Capital, Inc.). It is intended 
only for the addressee and may contain information that is confidential and/or 
otherwise exempt from disclosure under applicable law. If you are not the 
intended recipient or are acting as agent for the intended recipient, any use 
or disclosure of this communication is prohibited. If you have received this 
communication in error, please notify us immediately to arrange for the 
appropriate method of returning or disposing of the communication. If our 
respective Companies have confidentiality provisions in effect, this email and 
the materials contained herein are deemed CONFIDENTIAL and should be treated 
accordingly unless expressly provided otherwise.
**
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: v13 - SQL alter table, what is wrong?

[Charles Miller via 4D_Tech]

That’s v14 look at 13 doc which is where I got it from

 Regards
Chuck

On Mon, Sep 17, 2018 at 6:46 PM Chip Scheide via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Chuck,
> Thanks but...
>
> http://livedoc.4d.com/4D-SQL-Reference-14/Syntax-rules/primary-key-definition.300-1198391.en.html
>
> Says:
> [CONSTRAINT sql_name] PRIMARY KEY (sql_name, ... , sql_name)
>
> example:
> CREATE TABLE Customer
> (SID int32,
> Last_Name varchar(30),
> First_Name varchar(30),
> PRIMARY KEY (SID));
>
>
> On Mon, 17 Sep 2018 17:10:56 -0400, Chuck Miller via 4D_Tech wrote:
> > I think it should be
> >
> > ALTER TABLE [Anmlprot_File_Link]
> > ADD [Journal_Key] [Primary KEY]
> >
> > This is from the 4D docs
> > ALTER TABLE sql_name
> > {ADD column_definition [PRIMARY KEY] [TRAILING] |
> > DROP sql_name |
> > ADD primary_key_definition |
> > DROP PRIMARY KEY |
> > ADD foreign_key_definition |
> > DROP CONSTRAINT sql_name |
> > [{ENABLE | DISABLE} REPLICATE] |
> > [{ENABLE | DISABLE} AUTO_INCREMENT] |
> > [{ENABLE | DISABLE} AUTO_GENERATE] |
> > SET SCHEMA sql_name}
> >
> > Chuck
> >
>
> 
> >  Chuck Miller Voice: (617) 739-0306
> >  Informed Solutions, Inc. Fax: (617) 232-1064
> >  mailto:cjmillerinformed-solutions.com
> >  Brookline, MA 02446 USA Registered 4D Developer
> >Providers of 4D and Sybase connectivity
> >   http://www.informed-solutions.com
> >
>
> 
> > This message and any attached documents contain information which may
> > be confidential, subject to privilege or exempt from disclosure under
> > applicable law.  These materials are intended only for the use of the
> > intended recipient. If you are not the intended recipient of this
> > transmission, you are hereby notified that any distribution,
> > disclosure, printing, copying, storage, modification or the taking of
> > any action in reliance upon this transmission is strictly
> > prohibited.  Delivery of this message to any person other than the
> > intended recipient shall not compromise or waive such
> > confidentiality, privilege or exemption from disclosure as to this
> > communication.
> >
> >> On Sep 17, 2018, at 3:48 PM, Chip Scheide via 4D_Tech
> >> <4d_tech@lists.4d.com> wrote:
> >>
> >> $SQl_Command:="ALTER TABLE [Anmlprot_File_Link] ADD PRIMARY KEY
> >> (Journal_Key)"
> >
> > **
> > 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
> > **
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing
> **
> 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
> **

-- 
-
 Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064
 Informed Solutions, Inc.
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D, Sybase & SQL Server connectivity
  http://www.informed-solutions.com
-
This message and any attached documents contain information which may be
confidential, subject to privilege or exempt from disclosure under
applicable law.  These materials are intended only for the use of the
intended recipient. If you are not the intended recipient of this
transmission, you are hereby notified that any distribution, disclosure,
printing, copying, storage, modification or the taking of any action in
reliance upon this transmission is strictly prohibited.  Delivery of this
message to any person other than the intended recipient shall not
compromise or waive such confidentiality, privilege or exemption
from disclosure as to this communication.
**
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: Do I want to use SELECTION TO ARRAY instead of GOTO SELECTED RECORD server-side in V17

[Arnaud de Montard via 4D_Tech]

> Le 17 sept. 2018 à 16:15, Bart Davis via 4D_Tech <4d_tech@lists.4d.com 
> > a écrit :
> 
> No need to write to a file.  Appending text to a text variable is very slow, 
> but using TEXT TO BLOB($textToAdd;$blob;UTF8 text without length;*)  is very 
> fast.  Give that a try and see the huge speed difference.

You can also append in a text array, then implode that array using that blob 
technique.
>
Huge amount of text can be hold this way, very fast. 

About the 2Gb limit of text, I noticed the limit in number of chars is about 
the half. 

-- 
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: v13 - SQL alter table, what is wrong?

[Chip Scheide via 4D_Tech]

Chuck,
Thanks but...
http://livedoc.4d.com/4D-SQL-Reference-14/Syntax-rules/primary-key-definition.300-1198391.en.html

Says:
[CONSTRAINT sql_name] PRIMARY KEY (sql_name, ... , sql_name)

example:
CREATE TABLE Customer
(SID int32,
Last_Name varchar(30),
First_Name varchar(30),
PRIMARY KEY (SID));


On Mon, 17 Sep 2018 17:10:56 -0400, Chuck Miller via 4D_Tech wrote:
> I think it should be
> 
> ALTER TABLE [Anmlprot_File_Link] 
> ADD [Journal_Key] [Primary KEY]
> 
> This is from the 4D docs
> ALTER TABLE sql_name
> {ADD column_definition [PRIMARY KEY] [TRAILING] |
> DROP sql_name |
> ADD primary_key_definition |
> DROP PRIMARY KEY |
> ADD foreign_key_definition |
> DROP CONSTRAINT sql_name |
> [{ENABLE | DISABLE} REPLICATE] |
> [{ENABLE | DISABLE} AUTO_INCREMENT] |
> [{ENABLE | DISABLE} AUTO_GENERATE] |
> SET SCHEMA sql_name}
> 
> Chuck
> 

>  Chuck Miller Voice: (617) 739-0306
>  Informed Solutions, Inc. Fax: (617) 232-1064   
>  mailto:cjmillerinformed-solutions.com 
>  Brookline, MA 02446 USA Registered 4D Developer
>Providers of 4D and Sybase connectivity
>   http://www.informed-solutions.com  
> 

> This message and any attached documents contain information which may 
> be confidential, subject to privilege or exempt from disclosure under 
> applicable law.  These materials are intended only for the use of the 
> intended recipient. If you are not the intended recipient of this 
> transmission, you are hereby notified that any distribution, 
> disclosure, printing, copying, storage, modification or the taking of 
> any action in reliance upon this transmission is strictly 
> prohibited.  Delivery of this message to any person other than the 
> intended recipient shall not compromise or waive such 
> confidentiality, privilege or exemption from disclosure as to this 
> communication. 
> 
>> On Sep 17, 2018, at 3:48 PM, Chip Scheide via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> $SQl_Command:="ALTER TABLE [Anmlprot_File_Link] ADD PRIMARY KEY 
>> (Journal_Key)"
> 
> **
> 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
> **
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
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: Understanding a Runtime Error message

[Timothy Penner via 4D_Tech]

Hello,

> How do I
>a. Look up the details for that issue,

The details of bug reports are private so you cannot look up the bug details 
yourself.
If you are a member of the 4D Partner Program you can contact tech support and 
ask for additional details of a particular bug report and they will try to 
obtain additional context for you.
If you are not a member of the 4D Partner Program than you can contact your 
account/sales rep and get additional details on joining the program.

> b. Find these issues on my own?

As a member of the 4D Partner Program (Silver level and higher), you get access 
to hotfixes and nightly builds, each of these include a list of bug fixes. So 
if you have access to them then you could browse the lists to find the fixed 
issues yourself. However, there is no interface to search (other than find in 
page). On the other hand, 4D Tech Support has access to the database and can 
perform full text searches.

Hope that helps,

-Tim



**
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: Understanding a Runtime Error message

[Charles Miller via 4D_Tech]

I would think this was by 4D unless you have a process with the name
listed.

It is always a good idea to give us info re version of 4D Windows or Mac
and  OS

Regards
Chuck

On Mon, Sep 17, 2018 at 12:54 PM Sandor Szatmari via 4D_Tech <
4d_tech@lists.4d.com> wrote:

>
> I received the following runtime error from 4D server.  The runtime error
> dialog was just sitting on the server screen when I got in.
>
>
> 
> Text from the runtime error dialog (pressed the copy button)
> 
> Error
>
>
> Invalid argument
>
>
> Error code: 22
> Invalid argument
> component: 'POSX'
> task -2, name: 'Internal Timer Process'
> 
>
>
> Looking up 'Error code: 22' I see it is defined as: 'The fields must
> belong to the same table or subtable for a sort or graph.'
>
>
> But, I don't know how to take this information and trace it back to what
> caused this.
>
>
> How do I track this down?
>
>
>
> Thanks in advance!
>
> Sandor Szatmari
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Senior Software Developer
> Bristol Capital Inc. - InfoPlus
> 201 746 7215
> www.infoplusonline.com
>
> CONFIDENTIALITY NOTICE: This email (and any related attachments) contains
> information from InfoPlus (a service of Bristol Capital, Inc.). It is
> intended only for the addressee and may contain information that is
> confidential and/or otherwise exempt from disclosure under applicable law.
> If you are not the intended recipient or are acting as agent for the
> intended recipient, any use or disclosure of this communication is
> prohibited. If you have received this communication in error, please notify
> us immediately to arrange for the appropriate method of returning or
> disposing of the communication. If our respective Companies have
> confidentiality provisions in effect, this email and the materials
> contained herein are deemed CONFIDENTIAL and should be treated accordingly
> unless expressly provided otherwise.
> **
> 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
> **

-- 
-
 Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064
 Informed Solutions, Inc.
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D, Sybase & SQL Server connectivity
  http://www.informed-solutions.com
-
This message and any attached documents contain information which may be
confidential, subject to privilege or exempt from disclosure under
applicable law.  These materials are intended only for the use of the
intended recipient. If you are not the intended recipient of this
transmission, you are hereby notified that any distribution, disclosure,
printing, copying, storage, modification or the taking of any action in
reliance upon this transmission is strictly prohibited.  Delivery of this
message to any person other than the intended recipient shall not
compromise or waive such confidentiality, privilege or exemption
from disclosure as to this communication.
**
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: Do I want to use SELECTION TO ARRAY instead of GOTO SELECTED RECORD server-side in V17?

[Bernd Fröhlich via 4D_Tech]

David Adams:

> I'm checking for the simplest, least difficult default as that should work in 
> the vast majority of cases.


Here are my two Eurocents:
it does not matter how you collect the data, but concatenating the text in 
memory vs. writing to a file makes a HUGE difference when you have lots of 
records.

I have a method in my toolbox  that writes out a selection or a whole table 
into a file.
Looping through the records and appending each record to a file.
Works great.

Then I did the same but instead of writing to a file, I appended to a 
textvariable.
Works well for small amounts of data but is unusable for more than about 2 
records as it slows down ever more.
(I am lazy and did not do any pre-sizing, chunking, whatever.)

So if you want to export the data anyway and look for the simplest way, then 
just loop through the data and write into a file.

Greetings from Germany,
Bernd Fröhlich
**
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
**

Off topic: small office laser printer Mac OS

[Jim Dorrance via 4D_Tech]

I need to buy a new color laser printer , either w-fi or ethernet,
that works without hassle with OS X. Any suggestions?

Thanks

-- 
Jim Dorrance
jim.dorra...@gmail.com
4...@dorrance.eu
www.4d.dorrance.eu

PS: If you know of anyone that needs an experienced 4D programmer to add
energy and experience to their team, please let me know. I have
experience in many areas. Reasonable rates. Remote or Paris only.
**
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: Off topic: small office laser printer Mac OS

[Tilman Haerdle via 4D_Tech]

Check for offerings from Brother, like the HL-3152 CDW. Cheap to buy, cheap 
toner, reliable, AirPrint compatible

Cheers,
Tilman

> Am 17.09.2018 um 13:09 schrieb Jim Dorrance via 4D_Tech 
> <4d_tech@lists.4d.com>:
> 
> I need to buy a new color laser printer , either w-fi or ethernet,
> that works without hassle with OS X. Any suggestions?
> 
> Thanks
> 
> -- 
> Jim Dorrance
> jim.dorra...@gmail.com
> 4...@dorrance.eu
> www.4d.dorrance.eu
> 
> PS: If you know of anyone that needs an experienced 4D programmer to add
> energy and experience to their team, please let me know. I have
> experience in many areas. Reasonable rates. Remote or Paris only.
> **
> 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: Off topic: small office laser printer Mac OS

[Jeffrey Kain via 4D_Tech]

Anything by Brother.

I've had really great luck with Brother and macOS, as have some of my 
colleagues.


> On Sep 17, 2018, at 7:09 AM, Jim Dorrance via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I need to buy a new color laser printer , either w-fi or ethernet,
> that works without hassle with OS X. Any suggestions?

**
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: Off topic: small office laser printer Mac OS

[Jim Dorrance via 4D_Tech]

Thanks

On Mon, Sep 17, 2018 at 1:26 PM Jeffrey Kain via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Anything by Brother.
>
> I've had really great luck with Brother and macOS, as have some of my
> colleagues.
>
>
> > On Sep 17, 2018, at 7:09 AM, Jim Dorrance via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> > I need to buy a new color laser printer , either w-fi or ethernet,
> > that works without hassle with OS X. Any suggestions?
>
> **
> 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
> **



-- 
Jim Dorrance
jim.dorra...@gmail.com
4...@dorrance.eu
www.4d.dorrance.eu

PS: If you know of anyone that needs an experienced 4D programmer to add
energy and experience to their team, please let me know. I have
experience in many areas. Reasonable rates. Remote or Paris only.
**
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: Do I want to use SELECTION TO ARRAY instead of GOTO SELECTED RECORD server-side in V17?

[David Adams via 4D_Tech]

Bernd,

Thanks for the report, it's interesting and believable. In this case, I
have to get the data into memory to send it... I guess I could write to a
file, load that and then send it. Interesting concept, thanks!

On Mon, Sep 17, 2018 at 4:53 PM Bernd Fröhlich via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> David Adams:
>
> > I'm checking for the simplest, least difficult default as that should
> work in the vast majority of cases.
>
>
> Here are my two Eurocents:
> it does not matter how you collect the data, but concatenating the text in
> memory vs. writing to a file makes a HUGE difference when you have lots of
> records.
>
> I have a method in my toolbox  that writes out a selection or a whole
> table into a file.
> Looping through the records and appending each record to a file.
> Works great.
>
> Then I did the same but instead of writing to a file, I appended to a
> textvariable.
> Works well for small amounts of data but is unusable for more than about
> 2 records as it slows down ever more.
> (I am lazy and did not do any pre-sizing, chunking, whatever.)
>
> So if you want to export the data anyway and look for the simplest way,
> then just loop through the data and write into a file.
>
> Greetings from Germany,
> Bernd Fröhlich
> **
> 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: Off topic: small office laser printer Mac OS

[Ken Geiger Gmail via 4D_Tech]

I “third” Brother. 

Sent from my iPhone

> On Sep 17, 2018, at 5:36 AM, Jim Dorrance via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Thanks
> 
> On Mon, Sep 17, 2018 at 1:26 PM Jeffrey Kain via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> Anything by Brother.
>> 
>> I've had really great luck with Brother and macOS, as have some of my
>> colleagues.
>> 
>> 
>>> On Sep 17, 2018, at 7:09 AM, Jim Dorrance via 4D_Tech <
>> 4d_tech@lists.4d.com> wrote:
>>> 
>>> I need to buy a new color laser printer , either w-fi or ethernet,
>>> that works without hassle with OS X. Any suggestions?
>> 
>> **
>> 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
>> **
> 
> 
> 
> -- 
> Jim Dorrance
> jim.dorra...@gmail.com
> 4...@dorrance.eu
> www.4d.dorrance.eu
> 
> PS: If you know of anyone that needs an experienced 4D programmer to add
> energy and experience to their team, please let me know. I have
> experience in many areas. Reasonable rates. Remote or Paris only.
> **
> 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: Off topic: small office laser printer Mac OS

[C E Clements via 4D_Tech]

Another vote for Brother 
I have had a Brother colour laser for 5 years and very happy with it.
It was not cheap but is fast plus auto duplex and wireless.
The auto duplex is a real time and paper saver. In my book auto duplex is a 
“must have” in a printer.

Colin Clements
Sent from my iPhone

> On 17 Sep 2018, at 14:50, Ken Geiger Gmail via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I “third” Brother. 
> 
> Sent from my iPhone
> 
>> On Sep 17, 2018, at 5:36 AM, Jim Dorrance via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>> 
>> Thanks
>> 
>> On Mon, Sep 17, 2018 at 1:26 PM Jeffrey Kain via 4D_Tech <
>> 4d_tech@lists.4d.com> wrote:
>> 
>>> Anything by Brother.
>>> 
>>> I've had really great luck with Brother and macOS, as have some of my
>>> colleagues.
>>> 
>>> 
 On Sep 17, 2018, at 7:09 AM, Jim Dorrance via 4D_Tech <
>>> 4d_tech@lists.4d.com> wrote:
 
 I need to buy a new color laser printer , either w-fi or ethernet,
 that works without hassle with OS X. Any suggestions?
>>> 
>>> **
>>> 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
>>> **
>> 
>> 
>> 
>> -- 
>> Jim Dorrance
>> jim.dorra...@gmail.com
>> 4...@dorrance.eu
>> www.4d.dorrance.eu
>> 
>> PS: If you know of anyone that needs an experienced 4D programmer to add
>> energy and experience to their team, please let me know. I have
>> experience in many areas. Reasonable rates. Remote or Paris only.
>> **
>> 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
> **
**
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: Do I want to use SELECTION TO ARRAY instead of GOTO SELECTED RECORD server-side in V17?

[Chip Scheide via 4D_Tech]

David,
(not on v17)
I've played around with large text, mostly for testing purposes.
large texts (>150meg) 
- very easily cause massive slow downs when trying to append
- can easily crash/hang 4D.

While the *limit* on text maybe 2gig (+/-) my experience is that you 
can not get anywhere near that and expect to be able to manipulate the 
text in any reasonable time.

So
whatever end strategy you use, I would suggest you place a limit on the 
size of the text and export (or whatever) at that point.

Chip
On Sat, 15 Sep 2018 10:40:24 +, Keith White via 4D_Tech wrote:
> Building up a single big text thingy will have RAM (and eventually 
> potentially performance) issues if using straight string/text 
> concatenation for each iteration.  Because each time you add 
> something to a string, a copy is made in RAM which is bound to lead 
> to memory fragmentation and a higher workload for garbage 
> collection.   How significant is this?  No idea.  I've always avoided 
> building up super-massive text as a single thing.
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
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: PDF generation on Windows - Latest Thinking

[ADeeg via 4D_Tech]

For everyone who wants to get small PDF files under 4D windows with the Win
10 PDF printer, but is not interested in purchasing our wonderful PDF plugin
with PDF printer, here is a code snip to reduce the size of PDF files with
the Ghostscript Plugin from Magic Miyako. 

We use it on macOS to reduce the file size of the mac PDFs

Case of 
: ($vl_quality<=20)
$vt_PDFMode:="screen"
: ($vl_quality<=40)
$vt_PDFMode:="ebook"
: ($vl_quality<=60)
$vt_PDFMode:="printer"
Else 
$vt_PDFMode:="prepress"
End case 

// Mac Code for 4D Ghostscript plugin from Magic Miyako
https://github.com/miyako/4d-plugin-gs

ARRAY TEXT($args;0)
APPEND TO ARRAY($args;"-dNOPAUSE")  //important, we can't interact with the
cli
APPEND TO ARRAY($args;"-dBATCH")
APPEND TO ARRAY($args;"-dQUIET")
APPEND TO ARRAY($args;"-sDEVICE=pdfwrite")
APPEND TO ARRAY($args;"-dCompatibilityLevel=1.7")
APPEND TO ARRAY($args;"-dPDFSETTINGS=/"+$vt_PDFMode)
APPEND TO ARRAY($args;"-sOutputFile="+Convert path system to
POSIX($vt_output_path))  //output
APPEND TO ARRAY($args;"-c")
APPEND TO ARRAY($args;".setpdfwrite")
APPEND TO ARRAY($args;"-f")
APPEND TO ARRAY($args;Convert path system to POSIX($vt_input_path))  //Input
GS ($args)


Armin 



4D Tech mailing list wrote
> Chuck,
> 
> the plugin price is listed here: http://www.node.de/indexplug.htm
> 
> The license is per developer. Buy it once and distribute your solutions to
> as many clients and servers as you like.
> 
> Regards Armin





--
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: Do I want to use SELECTION TO ARRAY instead of GOTO SELECTED RECORD server-side in V17

[Bart Davis via 4D_Tech]

> Bernd,
> 
> Thanks for the report, it's interesting and believable. In this case, I
> have to get the data into memory to send it... I guess I could write to a
> file, load that and then send it. Interesting concept, thanks!

No need to write to a file.  Appending text to a text variable is very slow, 
but using TEXT TO BLOB($textToAdd;$blob;UTF8 text without length;*)  is very 
fast.  Give that a try and see the huge speed difference.

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