Re: SOAP with complex data structures

2016-10-18 Thread Keisuke Miyako
the web service wizard does admit it has limitations and throws a yellow flag,
but now that we have METHOD SET CODE and DOM XML commands
I guess it's quite possible to write a better parser.

is the WSDL (file or URL) one you are willing to share?

> Did somebody tried that? Any advice or suggestions?


宮古 啓介
セールス・エンジニア

株式会社フォーディー・ジャパン
〒150-0043
東京都渋谷区道玄坂1-10-2 渋谷THビル6F
Tel: 03-6427-8441
Fax: 03-6427-8449

keisuke.miy...@4d.com
www.4D.com/JP

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

Re: How to determine if a SET exists?

2016-10-18 Thread Kirk Brooks
David,
On Tue, Oct 18, 2016 at 5:12 PM, David Adams  wrote:

> I thought that I already had a Set_Exists("Set_Name") : Boolean
> function...but I didn't. Thanks for the conversation,

​Almost always ready to converse. And "yeah, I thought I had that too"
until I tried to find it.

Thanks for actually testing out a solution.​

-- 
Kirk Brooks
San Francisco, CA
===
**
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
**

Re: How to determine if a SET exists?

2016-10-18 Thread John DeSoi
I thought about this as a feature request, but I have not officially posted it 
yet. It would be really useful if 4D could call a method of your choosing when 
an object goes out of scope (no more references to it). Lots of other languages 
have something like this which allows you to ensure that resources are freed 
when an object is no longer needed. Then you could attach sets, named 
selections, and other types of resources to the object and clean them up when 
the object is no longer referenced.


John DeSoi, Ph.D.


> On Oct 18, 2016, at 5:52 PM, Sujit Shah  wrote:
> 
> It is so easy to lose track of which objects have been created / cleared.

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

Re: How to determine if a SET exists?

2016-10-18 Thread David Adams
I thought that I already had a Set_Exists("Set_Name") : Boolean
function...but I didn't. Thanks for the conversation, this code works in
V13 (what I have open right now):

C_BOOLEAN($0;$exists)
C_TEXT($1;$set_name)

$set_name:=$1

Error:=0

ErrorHandler_Install ("ErrorHandler_SuppressError")

C_BOOLEAN($is_in_set)
$is_in_set:=Is in set($set_name)

ErrorHandler_InstallPrevious

$exists:=Error=0 // You could test for error 39 to be a bit more specific.

$0:=$exists

...this assumes that you install a valid error handler, otherwise you'll
get some other error...
**
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
**

Re: Parsing unnamed parameters from urls

2016-10-18 Thread Keisuke Miyako
> Matches letters, digits and underscores. Equivalent to [A-Za-z0-9_].

I suppose that is a good enough definition.

according to the docs:

> Match a word character. Word characters are 
> [\p{Alphabetic}\p{Mark}\p{Decimal_Number}\p{Connector_Punctuation}\u200c\u200d].

http://userguide.icu-project.org/strings/regexp


宮古 啓介
セールス・エンジニア

株式会社フォーディー・ジャパン
〒150-0043
東京都渋谷区道玄坂1-10-2 渋谷THビル6F
Tel: 03-6427-8441
Fax: 03-6427-8449

keisuke.miy...@4d.com
www.4D.com/JP

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

Re: How to determine if a SET exists?

2016-10-18 Thread Douglas von Roeder
On Tue, Oct 18, 2016 at 10:46 AM, Kirk Brooks  wrote:

> Doug,
> I thought about that too. But then I'm fiddling around with the current
> selection.
>
> I guess there's no issue with simply re-creating a set if it has no records
> in it..
>

Kirk:

Agreed.

I just ran a bit of code (V12) to understand what errors are thrown using
set commands.

Use set throws error 39 if the referenced set does not exist. However,
Records in set returns 0 *without* throwing an error. Hmm…

Your point about recreating the set is valid but that also sidesteps the
possibility that you have a "bug" in your code (a logic error vs syntax),
right?


One way to get around the "lack of a stack" is to use code to create one or
many sets and return an Object with metadata about the set. To create named
selections, I use an Object that's filled with default values by
*SEL_BaseClass_Init.
*The Object can be used in the method in which it's created, passed as
a parameter, or added to the Object as an item.


This is from the code in the *_Init* method:

C_TEXT($scope_T)
SEL_Scope_Set ($h_;SEL_Scope_Local)
  //SEL_Scope_Set ($h_;SEL_Scope_IP)
  //SEL_Scope_Set ($h_;SEL_Scope_Process)

C_TEXT($action_T)
  //SEL_Action_Set ($h_;SEL_Action_Cut)
SEL_Action_Set ($h_;SEL_Action_Copy)

ARRAY LONGINT($tableNumber_AL;0)
OT_Array_Set ($h_;"$tableNumber_AL";->$tableNumber_AL)


  //Do not assign a "default" value
  //SEL_TablePtr_Assign ($h_;<>pNil)
  //<>pNil:=SEL_TablePtr_Get($h_)


C_BOOLEAN($clearAfterUse_F)
SEL_ClearAfterUse_Set ($h_;True)
  //<>BooleanNil:=SEL_ClearAfterUse_Get($h_)

 SEL_RIS_Set ($h_;<>LongintNil)
  //<>LongintNil:=SEL_Ris_Get($h_)

SEL_SelRecNum_Set ($h_;<>LongintNil)
  //<>LongintNil:=SEL_SelRecNum_Get($h_)

SEL_SelSize_Set ($h_;<>LongintNil)
  //<>LongintNil:=SEL_SelSize_Get($h_)

SEL_FirstSelRecNum_Set ($h_;<>LongintNil)
  //<>LongintNil:=SEL_FirstSelRecNum_Get($h_)

SEL_LastSelRecNum_Set ($h_;<>LongintNil)
  //<>LongintNil:=SEL_LastSelRecNum_Get($h_)

$0:=$h_

When this code completes execution, I have an Object with the defaults of
cutting the current selection and creating a local named selection.

 I add pointers to the tables in which a named selection will be created
and then call *SEL_CurrentSel_Create*


Here's the test code for *SEL_CurrentSel_Create*:

ALL RECORDS([Contacts])
REDUCE SELECTION([Contacts];10)

ALL RECORDS([Proposals])
REDUCE SELECTION([Proposals];10)

  //OT Clear (<>SEL_Handle)

  //Modify this code to use the base class
C_LONGINT($selHandle_L)
$selHandle_L:=*OT_MasterObject_Return* ("SEL")<= this code calls
*SEL_BaseClass_Init*

  //Default values
if(False)
 *SEL_Action_Set* ($selHandle_L;SEL_Action_Copy)
*SEL_Scope_Set* ($selHandle_L;SEL_Scope_Local)

*SEL_Action_Set* ($selHandle_L;SEL_Action_Cut)
*SEL_Scope_Set* ($selHandle_L;SEL_Scope_Process)
  end if


*SEL_TablePtr_Assign* ($selHandle_L;->[Contacts])
*SEL_TablePtr_Assign* ($selHandle_L;->[Proposals])

$selHandle_L :=*SEL_CurrentSel_Create* ($selHandle_L)


REDUCE SELECTION([Proposals];0)
REDUCE SELECTION([Contacts];0)


*SEL_CurrentSel_Restore* ($selHandle_L)

*OT_Object_Clear* ($selHandle_L)

  //Should have 10 records in each table
REDUCE SELECTION([Proposals];0)
REDUCE SELECTION([Contacts];0)



Or, if you need to put it all on one line (!)

$selHandle_L:=*SEL_CurrentSel_Create* (*SEL_TablePtr_Assign* (
*OT_MasterObject_Return* ("SEL");->[Contacts]))


And the nice thing about using a 4D Object is that you don't have to muck
with *OT_Object_Clear* ($selHandle_L).  :-)



--
Douglas von Roeder
949-336-2902
**
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
**

RE: Interpreted vs. Compiled - current comparison

2016-10-18 Thread Dennis, Neil
> Are there any recent comparative performance tests available?

Every database will perform differently based on how it is written. Some 
commands are compiled directly to machine code in these they may execute up to 
100x faster, others require calls to the 4D engine. Some will have no 
improvement such as a query.

Compiling does not speed up network, or database operations, so the speed 
advantage is only seen in method execution (code that is not DB operations). 
Things like sort array won't speed either up unless you rolled your own sort, 
the 4D commands internally run at compiled speeds. Loops and things where you 
modify variables or arrays will greatly speed up.

I think it is good to write/make code so it can be compiled no matter how you 
decide to execute the code in production. The compiler catches a lot of 
programming mistakes that are easy to fix once you know where they are. So if 
you adopt that philosophy then you could run it compiled and weigh the 
differences.

Neil






--


Privacy Disclaimer: This message contains confidential information and is 
intended only for the named addressee. If you are not the named addressee you 
should not disseminate, distribute or copy this email. Please delete this email 
from your system and notify the sender immediately by replying to this email.  
If you are not the intended recipient you are notified that disclosing, 
copying, distributing or taking any action in reliance on the contents of this 
information is strictly prohibited.

The Alternative Investments division of UMB Fund Services provides a full range 
of services to hedge funds, funds of funds and private equity funds.  Any tax 
advice in this communication is not intended to be used, and cannot be used, by 
a client or any other person or entity for the purpose of (a) avoiding 
penalties that may be imposed on any taxpayer or (b) promoting, marketing, or 
recommending to another party any matter addressed herein.
**
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
**

Re: Interpreted vs. Compiled - current comparison

2016-10-18 Thread Kirk Brooks
David,
I'll amplify what Jeff said by including text manipulation including web
areas.

As a rule of thumb I'd say anything your databases do that takes long
enough to put up a progress indicator (except printing and some searches)
will be faster by a factor of 3 - 20+.

On Tue, Oct 18, 2016 at 9:51 AM, David Rose  wrote:

> I am wondering, though, how much of an improvement in performance will we
> see if we compile. Have improvements in CPUs resulted in a smaller or
> larger difference between interpreted and compiled databases? Are there any
> recent comparative performance tests available?
>

-- 
Kirk Brooks
San Francisco, CA
===
**
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
**

Re: How do you populate an Excel spreadsheet using 4D?

2016-10-18 Thread Charlie Vass
See Tech Note: Exporting the Smart Way — Using Smart Templates 
.

Charlie Vass
4D TS

> On Oct 18, 2016, at 12:35 AM, Steve Makohin  wrote:
> 
> Does anyone know how to populate a formatted Excel spreadsheet using 4D, and
> do so under 4D's control? My preferred method is to have 4D replace "tags"
> in the spreadsheet with its own values. I'd also prefer if someone already
> has the code to do this. I'll be coding in v14.
> 
> I've written a sophisticated Excel spreadsheet generator for another client,
> but I'm wondering if there's an easier, simple way to go about this when the
> spreadsheet is of a known, fixed format.
> 
> -Steve
> 
> **
> 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
> **

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

Re: How to determine if a SET exists?

2016-10-18 Thread Kirk Brooks
Randy,
That was my first thought too. In this case I need to know if the set has
been attempted to be created.

But maybe not. Have to work with what I have I suppose.

On Tue, Oct 18, 2016 at 8:16 AM, Randy Engle <4d.l...@xc2.us> wrote:

> Kirk,
>
> It's not 100% what you are looking for, but I'm pretty sure you can do a
> "Records in Set"
>
> $0:=Records in Set("MySet")
>
> If the set does not exist, it will return 0.
>
> Of course this is also true if the set exists with zero records in it.
>  ;-)
>
-- 
Kirk Brooks
San Francisco, CA
===
**
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
**

Interpreted vs. Compiled - current comparison

2016-10-18 Thread David Rose
I have been working on a half dozen small 4D databases in the past several 
years, and have gotten away with running them interpreted in production with 
no complaints from users. I am wondering, though, how much of an improvement 
in performance will we see if we compile. Have improvements in CPUs resulted 
in a smaller or larger difference between interpreted and compiled 
databases? Are there any recent comparative performance tests available? 



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

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

Re: How do you populate an Excel spreadsheet using 4D?

2016-10-18 Thread bob . miller
RE> How do you populate an Excel spreadsheet using 4D?

I'm using Plugger's excellent Excel plugin; it is a bit pricey, but very 
full featured and solid as a rock.

http://www.pluggers.nl/product/xl-plugin/

Miyako also published a free plugin that does some Excel functions; I 
evaluated that, but it didn't go far enough for what I was looking for - 
multiple sheets, styles applied, etc.


Bob Miller 
Chomerics, a division of Parker Hannifin Corporation



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

Re: SOAP with complex data structures

2016-10-18 Thread Benedict, Tom
>
>I can build XML containing the structures and according to documentation, I
>can pass it to SOAP call with 'Web Service manual' parameter, but want to
>ask beforehand: Did somebody tried that? Any advice or suggestions?
>

We do it and it works. It was long ago so I don't recall what issues we may 
have encountered, but it's still working.

Sorry I'm not much help.

Tom Benedict
Optum

This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity
to which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.
**
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
**

Re: Parsing unnamed parameters from urls

2016-10-18 Thread Lee Hinde
I'll try it, but the cheat sheet I was using said that w

Matches letters, digits and underscores. Equivalent to [A-Za-z0-9_].

On Mon, Oct 17, 2016 at 8:45 PM, Keisuke Miyako 
wrote:

> would it not be safer to specify
>
> [^/]* = "anything but a forward slash"
>
> instead of \\w which can match word breaks other than a forward slash?
>
> > 2016/10/18 10:00、Lee Hinde  のメール:
> >
> > $match:="/api/(\\w+)/(\\w+)/"
>
>
>
> 宮古 啓介
> セールス・エンジニア
>
> 株式会社フォーディー・ジャパン
> 〒150-0043
> 東京都渋谷区道玄坂1-10-2 渋谷THビル6F
> Tel: 03-6427-8441
> Fax: 03-6427-8449
>
> keisuke.miy...@4d.com
> www.4D.com/JP
>
>
**
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
**

SOAP with complex data structures

2016-10-18 Thread Peter Bozek
I am using SOAP calls to sommunicate within 4D apps and with external (PHP)
web applications, but now have a little more complex request: I got WSDL
that contain quite complex structures (arrays of structures containing
another structures or arrays.)

I can build XML containing the structures and according to documentation, I
can pass it to SOAP call with 'Web Service manual' parameter, but want to
ask beforehand: Did somebody tried that? Any advice or suggestions?

TIA.

-- 

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

Re: How to determine if a SET exists?

2016-10-18 Thread Douglas von Roeder
Kirk:

IIRC, activate an error handler prior to calling the command that uses the
set.

--
Douglas von Roeder
949-336-2902

On Tue, Oct 18, 2016 at 8:16 AM, Randy Engle <4d.l...@xc2.us> wrote:

> Kirk,
>
> It's not 100% what you are looking for, but I'm pretty sure you can do a
> "Records in Set"
>
> $0:=Records in Set("MySet")
>
> If the set does not exist, it will return 0.
>
> Of course this is also true if the set exists with zero records in it.
>  ;-)
>
> Randy Engle
> XC2 Software LLC
>
> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Kirk
> Brooks
> Sent: Tuesday, October 18, 2016 7:35 AM
> To: 4D iNug Technical <4d_tech@lists.4d.com>
> Subject: How to determine if a SET exists?
>
> Hi all,
> Is there a way to determine if a set exists? So far the only thing I've
> come up with requires keeping track of them as they are created. This is OK
> but unverifiable.
>
> It would be nice to have the equivalent of the 'Is a list' function.
>
>
>
> **
> 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
> **
>
**
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
**

RE: How to determine if a SET exists?

2016-10-18 Thread Randy Engle
Kirk,

It's not 100% what you are looking for, but I'm pretty sure you can do a 
"Records in Set"

$0:=Records in Set("MySet")

If the set does not exist, it will return 0.

Of course this is also true if the set exists with zero records in it.   ;-)

Randy Engle
XC2 Software LLC

-Original Message-
From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Kirk Brooks
Sent: Tuesday, October 18, 2016 7:35 AM
To: 4D iNug Technical <4d_tech@lists.4d.com>
Subject: How to determine if a SET exists?

Hi all,
Is there a way to determine if a set exists? So far the only thing I've come up 
with requires keeping track of them as they are created. This is OK but 
unverifiable.

It would be nice to have the equivalent of the 'Is a list' function.



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

How to determine if a SET exists?

2016-10-18 Thread Kirk Brooks
Hi all,
Is there a way to determine if a set exists? So far the only thing I've
come up with requires keeping track of them as they are created. This is OK
but unverifiable.

It would be nice to have the equivalent of the 'Is a list' function.

-- 
Kirk Brooks
San Francisco, CA
===
**
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
**

Re: Questions about workers

2016-10-18 Thread Keisuke Miyako
but is that not totally expected?

a worker is a process that does not die, like the good old application process.

so of course the last created record must stay locked until it gets unloaded, 
or the worker is instructed to die.

> 2016/10/18 12:56、David Belote  のメール:
>
> I did discover what I think is a Worker bug in doing these simple tests.  
> Each time I ran these little tests, the very last record that was created and 
> then saved by the Worked is edit locked.  It can’t be deleted.



宮古 啓介
セールス・エンジニア

株式会社フォーディー・ジャパン
〒150-0043
東京都渋谷区道玄坂1-10-2 渋谷THビル6F
Tel: 03-6427-8441
Fax: 03-6427-8449

keisuke.miy...@4d.com
www.4D.com/JP

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

Re: Indexed field

2016-10-18 Thread Keisuke Miyako
there is v13 educational DB

ftp://ftp.4d.com/SAMPLE_DATABASES/4D/4D_v13/demo_dbs/4DIndexes.zip

that teaches basic principles.



宮古 啓介
セールス・エンジニア

株式会社フォーディー・ジャパン
〒150-0043
東京都渋谷区道玄坂1-10-2 渋谷THビル6F
Tel: 03-6427-8441
Fax: 03-6427-8449

keisuke.miy...@4d.com
www.4D.com/JP

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

How do you populate an Excel spreadsheet using 4D?

2016-10-18 Thread Steve Makohin
Does anyone know how to populate a formatted Excel spreadsheet using 4D, and
do so under 4D's control? My preferred method is to have 4D replace "tags"
in the spreadsheet with its own values. I'd also prefer if someone already
has the code to do this. I'll be coding in v14.

I've written a sophisticated Excel spreadsheet generator for another client,
but I'm wondering if there's an easier, simple way to go about this when the
spreadsheet is of a known, fixed format.

-Steve

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

Re: Questions about workers

2016-10-18 Thread Chip Scheide
probably adding either:
- reduce selction([table];0)
or
- unload record([table])
would resoleve this problem

On Mon, 17 Oct 2016 21:56:07 -0600, David Belote wrote:
> 
> I did discover what I think is a Worker bug in doing these simple 
> tests.  Each time I ran these little tests, the very last record that 
> was created and then saved by the Worked is edit locked.  It can’t be 
> deleted.
**
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
**

PHP random errors

2016-10-18 Thread Pat Bensky
For some time I've been using this code to convert decimal to hexadecimal:

$phpOK:=PHP Execute("";"dechex";$hex;$code)

​Lately it has started throwing up errors randomly. I'll get:

*Error when executing the method "ConvertDecimalToHexadecimal" at line
number 43*

*FastCGI client error in context "{context}".*
*Environment info: UseExternalServer = {use_ext}, ip = {ip}, port = {port},
ExecutablePath = {path}.*

*Error code: 500*
*FastCGI client error in context "{context}".*
*Environment info: UseExternalServer = {use_ext}, ip = {ip}, port = {port},
ExecutablePath = {path}.*
*component: 'FCGI'*
*task 57, name: '1-Publishing Project '*


And then I run the same code again and the error occurs with a different
character.

Any ideas?

Thanks

Pat
-- 
*
CatBase - The Database Publishing Solution
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*
**
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
**

Re: Execution Control Buttons in V15R5 Debugger

2016-10-18 Thread Paul Dennis
I couldnt agree more, whats the point of these changes. I would like words
instead of icons and sorted tables is still not fixed.



--
View this message in context: 
http://4d.1045681.n5.nabble.com/Execution-Control-Buttons-in-V15R5-Debugger-tp5747958p5747968.html
Sent from the 4D Tech mailing list archive at Nabble.com.
**
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
**

Re: HTML Tag Mismatch Finder!

2016-10-18 Thread Sujit Shah
I don't want to sound too pessimistic. From what you describe it has a
WYSIWYG preview. I am surprised that no one finds a WYSIWYG editor useful.
I have no intention to use it as a primary means for generating code. Its
just so much more easier to visualize what you are coding without having to
go back and forth. When working on several 100 lines of code, I can jump to
the section I want by just clicking on the section in the visual editor.

For the time being I will keep working with MS Expression Web. I then copy
paste into other editors for validation.

On Tue, Oct 18, 2016 at 8:03 PM, Bernd Fröhlich  wrote:

> John DeSoi wrote:
>
> > Not a WYSIWYG editor, but BBEdit has a nice document syntax checker.
>
> Actually BBEdit is very close to a WYSIWIG editor.
> You can open a "preview"-window that instantly displays the changes that
> are made to the HTML-code.
> Very nice feature.
> (Won´t work with 4D tags though)
>
> Greetings from Germany,
> Bernd Fröhlich
> **
> 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
> **
>



-- 

xxx
"There must be ingenuity as well as intention, strategy as well as
strength. "
**
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
**