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

2018-09-17 Thread 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

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

2018-09-17 Thread 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

Using a custom namespace in SVG

2018-09-17 Thread 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

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

2018-09-17 Thread 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

RE: Understanding a Runtime Error message

2018-09-17 Thread 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:

v13 - SQL alter table, what is wrong?

2018-09-17 Thread 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]

Re: Understanding a Runtime Error message

2018-09-17 Thread 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

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

2018-09-17 Thread 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

Re: v16 - playing videos stored in the database

2018-09-17 Thread 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

RE: v16 - playing videos stored in the database

2018-09-17 Thread 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.

Understanding a Runtime Error message

2018-09-17 Thread 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)

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

2018-09-17 Thread 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:

Re: Do I want to use SELECTION TO ARRAY instead of GOTO SELECTED RECORD server-side in V17

2018-09-17 Thread 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

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

2018-09-17 Thread 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));

RE: Understanding a Runtime Error message

2018-09-17 Thread 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

Re: Understanding a Runtime Error message

2018-09-17 Thread 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

Re: Do I want to use SELECTION TO ARRAY instead of GOTO SELECTED RECORD server-side in V17?

2018-09-17 Thread 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

Off topic: small office laser printer Mac OS

2018-09-17 Thread 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

Re: Off topic: small office laser printer Mac OS

2018-09-17 Thread 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

Re: Off topic: small office laser printer Mac OS

2018-09-17 Thread 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

Re: Off topic: small office laser printer Mac OS

2018-09-17 Thread 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>

Re: Do I want to use SELECTION TO ARRAY instead of GOTO SELECTED RECORD server-side in V17?

2018-09-17 Thread 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 <

Re: Off topic: small office laser printer Mac OS

2018-09-17 Thread 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

Re: Off topic: small office laser printer Mac OS

2018-09-17 Thread 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 >

Re: Do I want to use SELECTION TO ARRAY instead of GOTO SELECTED RECORD server-side in V17?

2018-09-17 Thread 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

Re: PDF generation on Windows - Latest Thinking

2018-09-17 Thread 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

Re: Do I want to use SELECTION TO ARRAY instead of GOTO SELECTED RECORD server-side in V17

2018-09-17 Thread 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