Re: Corrupted Explorer Window

You can close it and then reopen it with the shift key down. v i n c e n td el a c h a u x Bee green - keep it on the screen > On 17 Feb 2017, at 02:07, Sujit Shah via 4D_Tech <4d_tech@lists.4d.com> wrote: > > The 4D Explorer window has gone

Re: v13 - 202 user processes on server, 1 client

various user side tasks/processes. On Mon, 20 Feb 2017 08:43:24 -0800, Kirk Brooks via 4D_Tech wrote: > Chip, > Did you note what they were doing? > > On Mon, Feb 20, 2017 at 8:39 AM, Chip Scheide via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > >> I was just looking at the server computer for

v13 - 202 user processes on server, 1 client

I was just looking at the server computer for another reason not related to 4D. The console window of 4D server was showing 202 user processes. There is/was 1 user connected, me. There were NO open user processes on the client side. I attempted to 'Abort' some of the processes - to no effect. I

Detecting field properties that can take nulls

Hello All, In troubleshooting a recent problem, I found that I had inadvertently unchecked "Map NULL values to Blank values" on a field definition. I'd like to scan the database to see if I may have made the same mistake for any other fields. I'm coming up short on a way to do that using Get

Re: Detecting field properties that can take nulls

Have you looked at the SQL system table “_USER_COLUMNS”? See: http://doc.4d.com/4Dv16/4D/16/System-Tables.300-3201182.en.html > On Feb 20, 2017, at 2:52 PM, bob.miller--- via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I've

Re: How to not close all windows on restart - v16

I've uploaded some pix of a "workspace palette" that I use. It doesn't solve the issue that Kirk has reported but it is a handy creating open groups of methods. In the first pix , work is tracked at the issue level so it allows me to quickly

Vexing, un clear SQL error

**Apologies for double posting - just noticed I neglected to add a subject. I need some help with this from some of you SQL gurus. Here's a simple look up function (Partner_get_name) that uses SQL: If ($partner_id>0) If ([PARTNERS]ID#$partner_id) Begin SQL SELECT Name_dba, Name_display,

Re: Detecting field properties that can take nulls

the way forward is EXPORT STRUCTURE, which gives you an XML representation of the structure in full detail. read http://blog.4d.com/detailed-analysis-database-structure/ includes a utility that converts the XML to JSON. > 2017/02/21 4:52、bob.miller--- via 4D_Tech <4d_tech@lists.4d.com> のメール： >

Re: Vexing, un clear SQL error

Hi Tim, Yeah, I was wondering about that error code too. It hadn't occurred to me the problem could be the transit lag between the client the server but that would account for what I'm seeing. Interesting idea about the wrapper. Maybe I'll make a specific error handling method for these sorts of

Re: Vexing, un clear SQL error

Tim, I am also thinking about setting a semaphore at the start and end - but that seems like the wrong path because I can't believe the SQL server can only accomodate one operation from the entire database at a time. On Mon, Feb 20, 2017 at 12:57 PM, Tim Nevels via 4D_Tech < 4d_tech@lists.4d.com>

Re: Detecting field properties that can take nulls

Hi Bob, I believe you can locate the fields — whose “Map NULL values to Blank values” is unchecked — by exporting the structure. Try this: 1) Export the structure in HTML format. 2) Then open export in a browser, and look in the column titled “Never Null”. A check-mark in the “Never Null”

Re: JPR_Text2Pict and Objects, a perfect engagement...

Hi, How can you embed a carriage return so you can have multiple lines? Regards, Wayne Wayne Stewart about.me/waynestewart On 9 November 2015 at 04:38, JPR wrote: > [JPR] > > Hi All, > > The first version of JPR Text2Pict method has been made in 2000. It's purpose >

Re: Survey on 4D’s strategy for implementing Preemptive Processing / worker processes

Jim, are you using Ruby/Rails with 4D in any way…? Thanks, Robert > On Nov 3, 2016, at 8:11 PM, James Crate wrote: > > Ruby/Rails apps - processing large numbers of files; performing slow fuzzy > search on slices of data;