Re: Getting A Colon In The Root Node Of XML File

the colon symbol is a "namespace" delimiter in XML. if you want to create a root element like dmm:Production_Order_Confirmations you must first define what the "dmm" namespace prefix stands for. the identifier should be a globally unique string, by convention a URL. (it doesn't have to be a real

RE: Getting A Colon In The Root Node Of XML File

Well, Apparently it's not allow to do the following: $root:=DOM Create XML Ref("Production_Order_Confirmations") However, you can do this: $root:=DOM Create XML Ref("Production_Order_Confirmations") DOM SET XML ELEMENT NAME($root;"dmm:Production_Order_Confirmations") Go

Getting A Colon In The Root Node Of XML File

Anyone, Is there a way to get a colon character in the root node of an XML structure? The following is not working: $root:=DOM Create XML Ref("dmm:Production_Order_Confirmations") This will not create the XML structure, however if I remove it, then it will. Our customer is dictating

Re: Tinkering with SQL

Thanks, Tim. > On Aug 6, 2018, at 5:27 PM, Timothy Penner via 4D_Tech <4d_tech@lists.4d.com> > wrote: > >> So, how do I make the SQL case-insensitive? > > http://doc.4d.com/4Dv16R5/4D/16-R5/Database-Parameters.302-3480842.en.html > > Set Database Parameter (SQL Engine case sensitivity) =

Re: Tinkering with SQL

So, how do I make the SQL case-insensitive? > On Aug 6, 2018, at 4:57 PM, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > 4D query is case insensitive whereas SWL by default is not. > > > > ** > 4D Internet

Re: Tinkering with SQL

4D query is case insensitive whereas SWL by default is not. ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub:

Tinkering with SQL

4D v15 I run the following code: The SQL Login goes to the database that is running. DA_SQL_Login2 C_TEXT(tLookFor) tLookFor:="%Mc%" ARRAY TEXT(aFoundNames;0) ARRAY TEXT(aFoundPhones;0) Begin SQL Select FullName, Phone FROM PatientBase WHERE (FullName like :tLookFor) INTO :aFoundNames,

Re: startup progress on server

c.f. ACI0096115 (fixed in v17), ACI0094811 (fixed in v17, 16.3.HF5), ACI0097654 (fixed in 16R6) I recall the workaround prior to the fix was to duplicate the numeric menu reference ( i.e. $menu:=Create menu(1) ) instead of using design mode directly ( SET MENU BAR(1) ) but I may be wrong.

Re: Export text columns containing carriage returns to Excel?

Tom, Actually in this case the problem is that the text field for that row is larger than the 32,767 character limit. All of the text after that blows up the import until we start on the next valid row. I think the original replace string was working as intended There are only 11 cases where we

Re: Export text columns containing carriage returns to Excel?

My initial tests using this technique look pretty good. I exported 100 rows and all but one imported into Excel OK. Most of the text fields don't contain any "s, but one that does caused the import to fail. How are you doubling the "s when using Replace String? I tried Replace

RE: Export text columns containing carriage returns to Excel?

I didn’t have to escape the embedded commas. I think the quotes around all the fields took care of them. You will likely need to experiment. I found that Excel is fussy about CSV. It definitely doesn’t like importing CSV via the import wizard unless there are no embedded delimiters. Tom From:

Re: Export text columns containing carriage returns to Excel?

Tom, That sounds extremely useful. In addition to "" any "s in the text do I also need to \, any commas? I doubt the data source will be too large, but if it is can break the export into a couple of files. We'll only need to do this once. Thanks, Brad Perkins From: "Benedict, Tom" Date:

RE: Export text columns containing carriage returns to Excel?

Brad, Here's a hint that you may (or may not) find useful. I used a single column in the QR Editor to hold the full 'record' I was exporting. I wrapped all the fields with double-quotes and used commas as field delimiters. I also had to escape any embedded quotes by replacing them with

How to access formsSchema.json in the 4D app?

Working with dynamic forms and want to validate a form object. Laurent Esnault showed how to do this is his presentation in DC. He mentioned that formsSchema.json in the 4D app is the thing to use. How can I reference this document from within 4D? I tried various iterations starting with

RE: startup progress on server

> So what’s the recommendation on giving startup progress so they know that the > server hasn’t frozen at some point during the startup method? To the best of my knowledge, we do not recommend any sort of UI on the server. So, it is hard to make a recommendation for something we don’t recommend.

Re: startup progress on server

> On Aug 6, 2018, at 12:39 PM, Timothy Penner via 4D_Tech <4d_tech@lists.4d.com > > wrote: > > Regarding the menu bars on server - > >> Calling SET MENU BAR during On Server Startup >> - this crash will occur in a test database with only this line of code in

Re: Automated Generation of Form Variables

I don't use the form wizard, so I'm not sure I understand what you mean about Form.table.dataClassAttribute. But you can certainly generate your own form with fields and labels in version 17. To generate a field, I use a method like this: //Create field object. //$0 - Field object. //$1

RE: startup progress on server

Regarding the menu bars on server - > Calling SET MENU BAR during On Server Startup > - this crash will occur in a test database with only this line of code in the > On Server Startup method This *was* a known issue, it was filed as ACI0097391. It should be fixed in the latest v16 and v17

Re: Automated Generation of Form Variables

That is a logical step but it's not available that I'm aware of. Perhaps this would be a good feature request. -- Douglas von Roeder 949-336-2902 On Mon, Aug 6, 2018 at 9:25 AM Guru via 4D_Tech <4d_tech@lists.4d.com> wrote: > Is there a way to generate the Form.table.dataClassAttribute and

Automated Generation of Form Variables

Is there a way to generate the Form.table.dataClassAttribute and their labels to populate a form like is done for fields and labels when creating a form via the wizard? -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html

Re: startup progress on server

SET MENU BAR has never actually done anything to change the menu bar on the server, so I think it’s just been ignored all these years. It’s never been a problem until v16R6 Server. Of course, this is the first time we’ve had 64bit on Mac, so it may be related to that. Either way, starting a

Re: TAOW down?

Hi Bob, Currently our ISP in office in Paris is experiencing some issue that impact a few of our Online system, including TAOW. If you have an urgent need for Tech Support, please call our tech support directly by phone. Regards, Add  On 8/6/18, 8:56 AM, "4D_Tech on behalf of Bob Miller

Re: SVG Overlay Layer

Hey Jim, > The annotation svg is much larger than the data svg so the annotation can > pass the boundaries of the data svg I assume you mean that you can annotate outside the viewable area of the svg data image? Kind of like drawing programs where the image is confined to pre-sized rectangle

Re: Export text columns containing carriage returns to Excel?

Brad, My stock answer to questions like this is. Get yourself a copy of : http://www.pluggers.nl/product/xl-plugin/ If you are doing anything serious with excel files this is the easiest and best solution and well worth the outlay. Regards, Dougie

Re: startup progress on server

There could be, sure. John DeSoi makes a good point that it could b the 64bit version as opposed to 32bit. As I mentioned, the startup method was working fine up through v15.4 HF3, which was the last version before jumping to v16R6, but we went right to the 64bit version of that so I’ll have

Re: startup progress on server

We call QUIT 4D directly with no timer. Our On Exit and On Server Shutdown methods already do checks to be sure the processes we started are dead. I’m hoping for sure this is all that is needed. I didn’t think to test if this was only an issue related to 64bit version of server on Mac. I’ll

TAOW down?

Since about 3pm on Friday I've been trying to file a tech support case on taow.4d.com, but I get, "This site can't be reached". Anyone else seeing this? Bob Miller Chomerics, a division of Parker Hannifin Corporation ll

RE: LiveDoc Unresponsive

Add, Thanks for getting back to me! I did get my answers the "manual" way. It's funny how accustomed you become to simply clicking F1... Best, Steve * Stephen J. Orth The Aquila Group, Inc.

Re: LiveDoc Unresponsive

Hi Steve, http://Doc.4d.com is online and functioning. Please connect to it in the meantime while we are sorting out the problem. Regards, Add  On 8/6/18, 8:12 AM, "4D_Tech on behalf of Stephen J. Orth via 4D_Tech" <4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:

Re: v13 - marking field as 'Primary Key'

You can identify primary key with the following code $TableLoop_l is table number Begin SQL SELECT CONSTRAINT_ID FROM _USER_CONSTRAINTS WHERE TABLE_ID = :$TableLoop_l AND CONSTRAINT_TYPE = 'P' INTO :$ConstraintID_txt; SELECT COLUMN_ID FROM _USER_CONS_COLUMNS WHERE CONSTRAINT_ID =

LiveDoc Unresponsive

Is the livedoc website served out of France? I'm unable to reach it. Steve * Stephen J. Orth The Aquila Group, Inc. Office: (608) 834-9213 P.O. Box 690 Mobile:

Re: startup progress on server

Randy, I'll be interested to hear if this permanently fixes the problem. I'm still having random crash on quit errors on 4D Server (16.3HF4, 64-bit). Never a problem in version 15, 32-bit. I have never connected crashing to a status interface, but in my case it has always run in a separate

Re: startup progress on server

Ok. So moving our STARTUP method into a stored procedure using $procID:=New Process(“STARTUP”;512000;”On Server Startup) takes care of BOTH problems. So it looks like the Application Server process on 4D Server v16R6 and higher is more sensitive to interface related commands like

RE: startup progress on server

Randy There might be something else in the mix, all of my databases do a set menu bar during startup and open a window for progress. I'm not having the same crash you are. However I haven't tested with 4D v16r6. Neil Privacy Disclaimer: This message contains confidential information and

RE: Scheduled ISP Maintenance @ 4D Office (France)

Hi, For some reason it appears that the internet has been down since the ISP performed their maintenance. The ISP has been informed and should be working on it. Apologies for the inconvenience. Best Regards, -Tai B. ** 4D

startup progress on server

I’ve spent the morning trying to track down why our database started crashing when we quit 4D Server v16R6 on Mac OS…I haven’t tested yet to see if it affects the Windows version as well. I have tracked down 2 contributors to the crash. 1) Calling SET MENU BAR during On Server Startup

Re: SVG Overlay Layer

The annotation svg is much larger than the data svg so the annotation can pass the boundaries of the data svg On Mon, Aug 6, 2018 at 4:05 PM, John J Foster via 4D_Tech < 4d_tech@lists.4d.com> wrote: > > Hi Jim, > > I see! > > I thought that was just a dialog. > > Cool UI and smooth control. > >

Re: v13 - marking field as 'Primary Key'

Arnaud, Thanks I did this: on error call - just make the error go away for every table for every field is this my "primary key' field? sql command as text to set primary key on the field execute immediate(above sql command) (trying to set a primary key, as primary key

Re: SVG Overlay Layer

> Hi Jim, I see! I thought that was just a dialog. Cool UI and smooth control. John... > The On Hover annotation balloon is another svg image on top of the data > svg image ** 4D Internet Users Group (4D iNUG) Archive:

Re: Export text columns containing carriage returns to Excel?

if you can get to the 'user' environment there is an export option for XML (File -> export -> data to file -> File tab) in the dialog there is an option for format - in the drop down list there is an xml option. This may work for you -- do not know - never used it. another option might be :

Re: Scheduled ISP Maintenance @ 4D Office (France)

The URLs are still unreachable as of Monday morning, August 6th Eastern Daylight Time. It’s impossible to connect to: Taow.4d.com Livedoc.4d.com Forums.4d.com > On Aug 3, 2018, at 6:25 PM, Timothy Penner via 4D_Tech

Re: Scheduled ISP Maintenance @ 4D Office (France)

> Le 4 août 2018 à 00:25, Timothy Penner via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > [...] > > The ISP @ our French Headquarters is doing a scheduled maintenance that > started 20 minutes ago and is planned to last another 4 hours 10 minutes. It seems they found refuge in an ice