date:20171213

RE: Macros - how to insert "<>"

2017-12-13 Thread Randy Engle via 4D_Tech

Chip





Randy Engle, Director
XC2 Software LLC – XC2LIVE!
mailto:  randy.en...@xc2software.com
PH:  800.761.4999 – 415.456.9200


Internet – Hosted – In the Cloud:   On-line Backflow Test Entry!
XC2Live!  - Backflow Program Management
Operational Now! – Call for additional information:  800.761.4999

-Original Message-
From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Chip Scheide 
via 4D_Tech
Sent: Wednesday, December 13, 2017 2:40 PM
To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: Chip Scheide <4d_o...@pghrepository.org>
Subject: Macros - how to insert "<>"

i want to have a 4D marco include the following text, but the macro parser 
chokes.
My HTML-fu is not strong  :)
I believe that the macro parser is choking on the left arrow right arrow, so I 
need some help in escaping them.

 ((<>x_Cr*2)+Current method name+<>x_Cr)

Thanks!
Chip
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing
**
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: Macros - how to insert "<>"

2017-12-13 Thread Chip Scheide via 4D_Tech

Thanks!!
On Thu, 14 Dec 2017 09:44:27 +1100, Wayne Stewart via 4D_Tech wrote:
> 
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
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: Macros - how to insert "<>"

2017-12-13 Thread Wayne Stewart via 4D_Tech




Regards,

Wayne


[image: --]
Wayne Stewart
[image: http://]about.me/waynestewart



On 14 December 2017 at 09:40, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com
> wrote:

> i want to have a 4D marco include the following text, but the macro
> parser chokes.
> My HTML-fu is not strong  :)
> I believe that the macro parser is choking on the left arrow right
> arrow, so I need some help in escaping them.
>
>  ((<>x_Cr*2)+Current method name+<>x_Cr)
>
> Thanks!
> Chip
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing
> **
> 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
**

Macros - how to insert "<>"

2017-12-13 Thread Chip Scheide via 4D_Tech

i want to have a 4D marco include the following text, but the macro 
parser chokes.
My HTML-fu is not strong  :)
I believe that the macro parser is choking on the left arrow right 
arrow, so I need some help in escaping them.

 ((<>x_Cr*2)+Current method name+<>x_Cr)

Thanks!
Chip
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
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: Twin Process for 4D SQL Data Source

2017-12-13 Thread Timothy Penner via 4D_Tech

Following the links I provided should provide a price;
It should be listed next to the checkbox for the expansion.

Pricing could be different depending on your level of partnership;
so the best way to get accurate pricing is to call your account/sales rep.

-Tim





From: Alan Tilson [mailto:alantil...@gmail.com]
Sent: Wednesday, December 13, 2017 1:25 PM
To: Timothy Penner 
Cc: 4D iNug Technical <4d_tech@lists.4d.com>
Subject: Re: Twin Process for 4D SQL Data Source

Hello Tim,
Thanks for the info. Where do I find pricing for ODBC Pro?
Alan

On Wed, Dec 13, 2017 at 4:20 PM, Timothy Penner 
> wrote:
Hi Alan,

> but I couldn't find a place where it is sold for 4d server.

ODBC Pro can be purchased as an expansion when configuring a new server on the 
store:
https://store.4d.com/us/article/4USE16.shtml
https://store.4d.com/us/article/4USD16.shtml

ODBC Pro can also be purchased as an addon for an existing server via the 
'Extend your configuration' on the store:
https://store.4d.com/us/extendConfigurator.shtml

In case you wanted to see it, here is the product page for ODBC Pro:
http://www.4d.com/products/4dv16/4dodbcpro.html

Hope that helps!

-Tim





Timothy Penner
Senior Technical Services Engineer

4D Inc
95 S. Market Street, Suite #240
CA 95113 San Jose
United States

Telephone : +1-408-557-4600
Standard :  +1-408-557-4600
Fax :   +1-408-271-5080
Email : tpen...@4d.com
Web :   www.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: Twin Process for 4D SQL Data Source

2017-12-13 Thread Alan Tilson via 4D_Tech

Hello Tim,
Thanks for the info. Where do I find pricing for ODBC Pro?
Alan

On Wed, Dec 13, 2017 at 4:20 PM, Timothy Penner  wrote:

> Hi Alan,
>
> > but I couldn't find a place where it is sold for 4d server.
>
> ODBC Pro can be purchased as an expansion when configuring a new server on
> the store:
> https://store.4d.com/us/article/4USE16.shtml
> https://store.4d.com/us/article/4USD16.shtml
>
> ODBC Pro can also be purchased as an addon for an existing server via the
> 'Extend your configuration' on the store:
> https://store.4d.com/us/extendConfigurator.shtml
>
> In case you wanted to see it, here is the product page for ODBC Pro:
> http://www.4d.com/products/4dv16/4dodbcpro.html
>
> Hope that helps!
>
> -Tim
>
>
>
>
>
> Timothy Penner
> Senior Technical Services Engineer
>
> 4D Inc
> 95 S. Market Street, Suite #240
> CA 95113 San Jose
> United States
>
> Telephone : +1-408-557-4600
> Standard :  +1-408-557-4600
> Fax :   +1-408-271-5080
> Email : tpen...@4d.com
> Web :   www.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: Twin Process for 4D SQL Data Source

2017-12-13 Thread Timothy Penner via 4D_Tech

Hi Alan,

> but I couldn't find a place where it is sold for 4d server.

ODBC Pro can be purchased as an expansion when configuring a new server on the 
store:
https://store.4d.com/us/article/4USE16.shtml
https://store.4d.com/us/article/4USD16.shtml

ODBC Pro can also be purchased as an addon for an existing server via the 
'Extend your configuration' on the store:
https://store.4d.com/us/extendConfigurator.shtml

In case you wanted to see it, here is the product page for ODBC Pro:
http://www.4d.com/products/4dv16/4dodbcpro.html

Hope that helps!

-Tim






**
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: Twin Process for 4D SQL Data Source

2017-12-13 Thread Alan Tilson via 4D_Tech

Chuck,
4D ODBC Pro is still listed on the 4D website for v16 and it says that it
comes with 4D Developer Professional and with Team Developer Professional,
but I couldn't find a place where it is sold for 4d server.
I prefer using the native core 4D functionalities wherever possible, but it
is interesting that ODBC Pro offers cloning of 4D tables as ODBC tables and
vice versa. One of the things I do regularly is to load data from 4d and
theoretically the same data from the SQL Server system and compare it using
arrays to find records that have changed. If this could be done within one
SQL statement that would be great!
I did see the expression *ConnectionID* in the ODBC Pro docs which implies
that several connections could be open.
Thanks,
Alan

On Wed, Dec 13, 2017 at 1:51 PM, Charles Miller via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Hi Alan,
>
> Is there not a command that allows you to switch. I seem to remember
> somethingt like Use Local but could not find it
>
> Regards
>
>
> Chuck
>
> On Wed, Dec 13, 2017 at 1:12 PM, Alan Tilson via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
> > Hello Chuck,
> > You are probably right. I just counted 14 logins to the SQL Server in 1
> min
> > 50 sec so I ran a test logging in and out 20 times and this took 2.03
> > seconds.
> > There would have to be some overhead associated with using a separate
> > process so I doubt there would be any gain.
> > It just seems rather clunky to have to login in and out and to not just
> be
> > able to specify which source to use or even to be able to use both
> > simultaneously like Access can do!
> > Thanks,
> > Alan
> >
> >
> > On Wed, Dec 13, 2017 at 12:46 PM, Chuck Miller via 4D_Tech <
> > 4d_tech@lists.4d.com> wrote:
> >
> > > I have not but it seems to me to be a lot of work as you will have to
> get
> > > data/orrays/variables between processes and it would also seem to me
> that
> > > you could choose only one to put in a new process
> > >
> > > 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 Dec 13, 2017, at 12:28 PM, Alan Tilson via 4D_Tech <
> > > 4d_tech@lists.4d.com> wrote:
> > > >
> > > > Hello everyone,
> > > >
> > > > I find myself switching data sources frequently (20 or more times in
> a
> > > few
> > > > minutes-I'll count the number...) back and forth between 4D and my
> > > client's
> > > > MS SQL Server based system. So today I've been contemplating the idea
> > > that
> > > > I might put all my 4D SQL code in a separate process so that my each
> > > > process could stay logged into either 4D/Local or the SQL Server.
> > > >
> > > > Has anyone tried this? If so, please share your thoughts on the
> > benefits
> > > > and complications and even solutions that this approach offers!
> > >
> > > **
> > > 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
> > **
> >
>
>
>
> --
> 
> -
>  Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064
>  Informed Solutions, Inc.
>  Brookline, MA 02446 USA

Re: localisation (again)

2017-12-13 Thread Alan Chan via 4D_Tech

Alternative simplified version of Num for this situation

C_REAL($0;$num)  //same as ES_num yet support decimal
C_TEXT($1)
C_LONGINT($len;$i;$k;$j)
$num:=0
$len:=Length($1)
For ($i;$len;1;-1)
$k:=Character code($1[[$i]])
If (($k>47) & ($k<58))
$num:=$num+(($k-48)*(10^($len-$i-$j)))
Else 
If ($k=46)  //decimal
$num:=$num*(10^-($len-$i-$j))
$len:=$i
$j:=1  //$j+1
Else 
$len:=$len-1
End if 
End if 
End for 
If ($k=45)
$num:=$num*-1
End if 
$0:=$num

Alan Chan

4D iNug Technical <4d_tech@lists.4d.com> writes:
>Hi
>But Thats what I'm doing, and its not working.
>
>The string looks like "12345.12345" and the Conversion looks like
>
>C_REAL($Number)
>C_TEXT($NumString)
>$NumString:-"12345.12345"
>$Number:=Num($NumString;".")
>
>On a UK system $Number = 12345.12345
>On a German system $Number = 12345
>
>any ideas would be very welcome
>Im considering using replace string on $numString to replace "." with the
>local separator, in this case ","
>
>thanks
>-pm
>
>On Wed, Dec 13, 2017 at 2:32 AM, Chuck Miller via 4D_Tech <
>4d_tech@lists.4d.com> wrote:
>
>> Much better than my choice which was substring till the period and then num
>>
>> 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 Dec 12, 2017, at 7:22 PM, Keisuke Miyako via 4D_Tech <
>> 4d_tech@lists.4d.com> wrote:
>> >
>> > the second "separator" argument for Num() has existed and has been a
>> "must use" feature since v11 for i18n.
>> >
>> > http://doc.4d.com/4Dv16/4D/16.3/Num.301-3651255.en.html <
>> http://doc.4d.com/4Dv16/4D/16.3/Num.301-3651255.en.html>
>>
>> **
>> 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
>**

**
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 Write Pro Sample DB on YouTube

2017-12-13 Thread Tim Nevels via 4D_Tech

On Dec 13, 2017, at 11:28 AM, Paul Dennis wrote:

> I appreciate that 4d has got round to providing us with a tool bar. Can
> somebody please tell the designers who seem to rule the roost that we dont
> need great big icons and clunky fonts. What is the obsession ? Please can we
> have something like the original 4d write style.

You are provided all the source code and images. So you take what you like and 
replace what you don’t like. Or you can build your own completely from scratch.

That’s the beauty of how they have implemented 4D Write Pro. It is totally up 
to you to provide any interface you want with as much detail, or as simple as 
you think is best. This is just a starting point to provide an example of how 
to do that. And for the lazy ones that don’t want to spend any time on a custom 
UI.

If you want the original 4D Write style interface, you can easily create it 
yourself. 

I prefer this to the old way of 4D doing things where you took what they gave 
you and that was the end of it. I will take this example and remove some items 
that I feel my users don’t need to be burdened with.  And I will change the 
icons to colorized versions and a bit smaller. Then they will my the UI of my 
existing 4D applications.

Tim

Tim Nevels
Innovative Solutions
785-749-3444
timnev...@mac.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: Twin Process for 4D SQL Data Source

2017-12-13 Thread Charles Miller via 4D_Tech

Hi Alan,

Is there not a command that allows you to switch. I seem to remember
somethingt like Use Local but could not find it

Regards


Chuck

On Wed, Dec 13, 2017 at 1:12 PM, Alan Tilson via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Hello Chuck,
> You are probably right. I just counted 14 logins to the SQL Server in 1 min
> 50 sec so I ran a test logging in and out 20 times and this took 2.03
> seconds.
> There would have to be some overhead associated with using a separate
> process so I doubt there would be any gain.
> It just seems rather clunky to have to login in and out and to not just be
> able to specify which source to use or even to be able to use both
> simultaneously like Access can do!
> Thanks,
> Alan
>
>
> On Wed, Dec 13, 2017 at 12:46 PM, Chuck Miller via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
> > I have not but it seems to me to be a lot of work as you will have to get
> > data/orrays/variables between processes and it would also seem to me that
> > you could choose only one to put in a new process
> >
> > 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 Dec 13, 2017, at 12:28 PM, Alan Tilson via 4D_Tech <
> > 4d_tech@lists.4d.com> wrote:
> > >
> > > Hello everyone,
> > >
> > > I find myself switching data sources frequently (20 or more times in a
> > few
> > > minutes-I'll count the number...) back and forth between 4D and my
> > client's
> > > MS SQL Server based system. So today I've been contemplating the idea
> > that
> > > I might put all my 4D SQL code in a separate process so that my each
> > > process could stay logged into either 4D/Local or the SQL Server.
> > >
> > > Has anyone tried this? If so, please share your thoughts on the
> benefits
> > > and complications and even solutions that this approach offers!
> >
> > **
> > 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
> **
>



-- 
-
 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)
FAQ:  http://lists.4d.com/faqnug.html
Archive:

Re: Twin Process for 4D SQL Data Source

2017-12-13 Thread Alan Tilson via 4D_Tech

Hello Chuck,
You are probably right. I just counted 14 logins to the SQL Server in 1 min
50 sec so I ran a test logging in and out 20 times and this took 2.03
seconds.
There would have to be some overhead associated with using a separate
process so I doubt there would be any gain.
It just seems rather clunky to have to login in and out and to not just be
able to specify which source to use or even to be able to use both
simultaneously like Access can do!
Thanks,
Alan


On Wed, Dec 13, 2017 at 12:46 PM, Chuck Miller via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> I have not but it seems to me to be a lot of work as you will have to get
> data/orrays/variables between processes and it would also seem to me that
> you could choose only one to put in a new process
>
> 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 Dec 13, 2017, at 12:28 PM, Alan Tilson via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> > Hello everyone,
> >
> > I find myself switching data sources frequently (20 or more times in a
> few
> > minutes-I'll count the number...) back and forth between 4D and my
> client's
> > MS SQL Server based system. So today I've been contemplating the idea
> that
> > I might put all my 4D SQL code in a separate process so that my each
> > process could stay logged into either 4D/Local or the SQL Server.
> >
> > Has anyone tried this? If so, please share your thoughts on the benefits
> > and complications and even solutions that this approach offers!
>
> **
> 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
**

Twin Process for 4D SQL Data Source

2017-12-13 Thread Alan Tilson via 4D_Tech

Hello everyone,

I find myself switching data sources frequently (20 or more times in a few
minutes-I'll count the number...) back and forth between 4D and my client's
MS SQL Server based system. So today I've been contemplating the idea that
I might put all my 4D SQL code in a separate process so that my each
process could stay logged into either 4D/Local or the SQL Server.

Has anyone tried this? If so, please share your thoughts on the benefits
and complications and even solutions that this approach offers!

Thanks,
Alan Tilson
**
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: AreaList Pro version 10 - The new breakthrough in 4D user interface

2017-12-13 Thread Randy Engle via 4D_Tech

Phil,

Congrats on getting this out!


Randy Engle, Director
XC2 Software LLC – XC2LIVE!

-Original Message-
From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Philippe 
Ganter via 4D_Tech
Sent: Wednesday, December 13, 2017 6:39 AM
To: 4D iNug Technical <4d_tech@lists.4D.com>
Cc: Philippe Ganter 
Subject: AreaList Pro version 10 - The new breakthrough in 4D user interface

AreaList Pro version 10 has been released.

www.e-node.net/alp

This version offers 32-bit and 64-bit support for 4D v16 and above.

Version 10 also brings tons of new features and tremendous granularity. 

It fully supports v8 API and v9 API: your existing code should not require any 
changes.

• Direct data display from a MySQL database Set a MySQL server as data source 
and display its data in AreaList Pro v10 though one single line of code, with 
hundreds of formatting options available.

• Global settings and templates
- Global area settings: 
-> Area = 0 : apply to all areas to be created (defining an area 
-> “template”) Area = -2 : apply to all existing areas, but not to areas 
-> to be created Area = -3 : apply to all existing areas in current 
-> process only
- Global column settings: 
-> Column = 0 : apply to all columns to be created (defining a column 
-> “template”) in either a specific area, or in area 0, -2 or -3 as 
-> above Column = -2 : apply to all existing columns in either a 
-> specific area, or in area -2 or -3 as above for existing areas
- Global row settings: 
-> Row = -2 : apply to all rows in either a specific area, or in area -2 
-> or -3 as above for existing areas

• New commands
- Move a column (AL_MoveColumn)
- Duplicate a column (AL_DuplicateColumn)

• Grouping columns and headers
- Group columns together
- Dragging a group of columns
- Column group header (above the column individual headers or replacing them) – 
row and cell properties can be used with Row = -3
- Hierarchy row merged into one cell that goes across several columns

• Area display features
- Zooming an entire area (smaller or larger display, factor 0.1 to 5)
- Display Transposed (rotate rows ↔ columns) – This allows “palette” style 
interface, with different data types among “rows”
- Multi-level break processing (ala PrintList Pro) including in hierarchical 
lists
- Many new “appearance” settings: system, automatic, custom pictures or 10 
different OSX/Windows standard themes
- Show/hide vertical scrollbar

• Column features
- Minimum column width for any column(s)
- New properties to enable/disable each column's sorting, dragging or resizing
- “Use ellipsis” settable for headers, specific columns, individual rows, 
footers, and even individual cells
- Popup entry type is now a column property: 0 = default (depends on data 
type), 1 = date, 2 = time
- Limiting entry string length (length limit is now a column property)
- Define a formula instead of a callback for a calculated column

• Other cool features
- CSV format in Copy / Drag from an area
- Named selections as sources
- Entry placeholder support
- Formatting at cell level: ALP_Cell_Format and ALP_Cell_Flags
- Formatting at row level (font, color, alignment, spacing, etc.): ALP_Row_Flags
- Show a longint value as picture in Field or Array Display (e.g. “star rating” 
display)
- Access row and cell properties for header and footer (Header: row = 0, 
Footer: row = -1)

• Miscellaneous
- Hide row dividers in empty areas (ALP_Area_ShowRowDividers is now 3-state)
- Custom picture above vertical scrollbar (old AL_SetHeaderOptions) including 
callback on mouse down or up
- Override row/cell bottom row divider color (set a specific color for the 
bottom divider of a given row or cell)
- ALP_Column_EntryAllowReturn: allow/disallow return in specific columns 
regardless of the area settings (ALP_Area_EntryAllowReturn)
- Single line headers in “grid” mode (i.e. several lines per row, 
ALP_Area_AltHdrRowsInGrid>1)
- Single line footers in “grid” mode (i.e. several lines per row, 
ALP_Area_FtrRowsInGrid>1)
- Drag and move a column (physically reorder the column) even when not running 
in compatibility mode
- New API replacement of AL_SetInterface: appearance + sort indicator properties

Best regards,
--
Philippe Ganter
e-Node
forums.e-node.net



































**
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: localisation (again)

2017-12-13 Thread Chip Scheide via 4D_Tech

as a work around:
$Loc:=position("."; imported_Text_Number)
$Text_Integer:=substring($imported_Text_Number;1;$Loc-1)
$Integer:=Num($Text_Integer)
$Text_Integer:=substring(imported_Text_Number;$Loc+1)
$Decimal:=num($Text_Integer)
$Final_Value:=$Integer+($Decimal/(10*length($Text_Integer)))

Given "1234.5678" the above should give you
Integer=1234
$Decimal:=5678
$Final_Value=1234.5678

Please note: all of the above code typed in email 

On Tue, 12 Dec 2017 23:13:20 +, Peter Mew via 4D_Tech wrote:
> The imported file is always a string and the part I need is always a
> substring that looks like "123456.1234567890"
> The decimal separator is always a period
> The num function needs to work on systems that have either the period or
> the comma, as the native decimal separator
> thanks
> -pm
> 
> On Tue, Dec 12, 2017 at 10:19 PM, Charles Miller via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> If this is always a long why is the striking .XX or ,XX
>> It might be simpler but I would first doa substrinmg from 1 to position of
>> either , or . and then a num on that.
>> You will have to identify what system you are on and what localization is
>> set to and then understand what localization created text file for import
>> 
>> 
>> Regards
>> 
>> Chuck
>> 
>> On Tue, Dec 12, 2017 at 4:24 PM, Peter Mew via 4D_Tech <
>> 4d_tech@lists.4d.com
>>> wrote:
>> 
>>> Hi
>>> I thought I had this understood, but aparrently not.
>>> Im Importing some numbers from a file as strings.The Numbers have a
>> period
>>> as decimal point.
>>> Because they are long decimal numbers and I need to do some calculations
>> I
>>> convert them to longints with NUM()
>>> everything works fine on a UK system that has its decimal point as a
>> period
>>> When I run on a German system that has its a comma as its decimal point
>> the
>>> conversion screws up
>>> So I tried using NUM(string;".") as the conversion (I thought, to force
>> the
>>> Decimal point to be a period)
>>> but this seems to make no difference as the conversion,  is still
>> sccrewed
>>> up.
>>> Could Someone point me in the direction of what I've misunderstood.
>>> Thanks
>>> -pm
>>> Im testing this by changing the localisation on the mac to German, and
>>> comma as the decimal point.
>>> Mac OS 10.10.5 4D v13.6
>>> **
>>> 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
>>> **
>> 
>> 
>> 
>> 
>> --
>> 
>> -
>>  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)
>> 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
> **
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
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: Stack level in 4DDebugLog.txt

2017-12-13 Thread Timothy Penner via 4D_Tech

Do you have code that can reproduce this?

If so, what does the call chain look like in the debugger if you trace it? Does 
it show 30 calls deep or 2 calls deep?

Can you supply the code and or debug logs that show this?

-Tim


Sent from my Verizon, Samsung Galaxy smartphone




 Original message 
From: Piotr Chabot Stadhouders 
Date: 12/13/17 12:23 AM (GMT-08:00)
To: 4D iNug Technical <4d_tech@lists.4d.com>, Chip Scheide 
<4d_o...@pghrepository.org>, Timothy Penner 
Subject: RE: Stack level in 4DDebugLog.txt

Hi Chip, Tim,

Could there be some other weird reason why the stack level increases and 
doesn't decrease?
Maybe calling plugin commands, or maybe EXECUTE METHOD?
Maybe a bug in the debug log?
Maybe something in Windows 10?

I know nearly for sure that there is no recursion, and still the stack level 
increases
At some point I am in a method I know it is stack level 2 (for example), but 
the debug level tells me I am in level 30. How is this possible?

Gr,

Piotr

> -Oorspronkelijk bericht-
> Van: Chip Scheide [mailto:4d_o...@pghrepository.org]
> Verzonden: maandag 11 december 2017 19:21
> Aan: 4D iNug Technical <4d_tech@lists.4d.com>
> Onderwerp: RE: Stack level in 4DDebugLog.txt
>
> Piotr,
> don't forget the possibility of indirect recursion too.
> Method_A call Method_B which calls Method_C which calls Method_A
>
>
> On Mon, 11 Dec 2017 18:11:32 +, Timothy Penner via 4D_Tech wrote:
> > It could be recursion. The debug logs should help you determine
> > exactly what is being called.
> >
> > If method1 calls method1 which calls method1 again (and again and
> > again and again), it would increase the stack level each time it
> > calls itself.
> >
> > -Tim
> >
> >
> >
> >
> >
> 
> **
> > 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
> >
> 
> **
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing

**
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: localisation (again)

2017-12-13 Thread Peter Mew via 4D_Tech

Hi
But Thats what I'm doing, and its not working.

The string looks like "12345.12345" and the Conversion looks like

C_REAL($Number)
C_TEXT($NumString)
$NumString:-"12345.12345"
$Number:=Num($NumString;".")

On a UK system $Number = 12345.12345
On a German system $Number = 12345

any ideas would be very welcome
Im considering using replace string on $numString to replace "." with the
local separator, in this case ","

thanks
-pm

On Wed, Dec 13, 2017 at 2:32 AM, Chuck Miller via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Much better than my choice which was substring till the period and then num
>
> 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 Dec 12, 2017, at 7:22 PM, Keisuke Miyako via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> > the second "separator" argument for Num() has existed and has been a
> "must use" feature since v11 for i18n.
> >
> > http://doc.4d.com/4Dv16/4D/16.3/Num.301-3651255.en.html <
> http://doc.4d.com/4Dv16/4D/16.3/Num.301-3651255.en.html>
>
> **
> 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: 4D Write Pro Sample DB on YouTube

2017-12-13 Thread Tilman Haerdle via 4D_Tech

Hello Paul,

who is "we"?

No offense, many people surely prefer unchanged appearances over new looks one 
might have to get used to, especially if they require additional layout 
adaptations. I assume there is a sizable group of people who prefer a new 
appearance for many other reasons.

Life is really easier if you start to understand and even appreciate other 
people's ideas and approaches.

Please remark that I also didn't speak of "old, tiny, unclickable, ugly" icons 
for the old toolbar. No need to judge, neither set of UIs.

Best regards,
Tilman
> Am 13.12.2017 um 10:37 schrieb Paul Dennis via 4D_Tech <4d_tech@lists.4d.com>:
> 
> I appreciate that 4d has got round to providing us with a tool bar. Can
> somebody please tell the designers who seem to rule the roost that we dont
> need great big icons and clunky fonts. What is the obsession ? Please can we
> have something like the original 4d write style.
> Thanks
> Paul
> 
> 
> 
> --
> Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
> **
> 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: 4D Write Pro Sample DB on YouTube

2017-12-13 Thread Paul Dennis via 4D_Tech

I appreciate that 4d has got round to providing us with a tool bar. Can
somebody please tell the designers who seem to rule the roost that we dont
need great big icons and clunky fonts. What is the obsession ? Please can we
have something like the original 4d write style.
Thanks
Paul



--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
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: Stack level in 4DDebugLog.txt

2017-12-13 Thread Piotr Chabot Stadhouders via 4D_Tech

Hi Chip, Tim,

Could there be some other weird reason why the stack level increases and 
doesn't decrease?
Maybe calling plugin commands, or maybe EXECUTE METHOD?
Maybe a bug in the debug log?
Maybe something in Windows 10?

I know nearly for sure that there is no recursion, and still the stack level 
increases
At some point I am in a method I know it is stack level 2 (for example), but 
the debug level tells me I am in level 30. How is this possible?

Gr,

Piotr

> -Oorspronkelijk bericht-
> Van: Chip Scheide [mailto:4d_o...@pghrepository.org]
> Verzonden: maandag 11 december 2017 19:21
> Aan: 4D iNug Technical <4d_tech@lists.4d.com>
> Onderwerp: RE: Stack level in 4DDebugLog.txt
> 
> Piotr,
> don't forget the possibility of indirect recursion too.
> Method_A call Method_B which calls Method_C which calls Method_A
> 
> 
> On Mon, 11 Dec 2017 18:11:32 +, Timothy Penner via 4D_Tech wrote:
> > It could be recursion. The debug logs should help you determine
> > exactly what is being called.
> >
> > If method1 calls method1 which calls method1 again (and again and
> > again and again), it would increase the stack level each time it
> > calls itself.
> >
> > -Tim
> >
> >
> >
> >
> >
> 
> **
> > 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
> >
> 
> **
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing

**
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: Macros - how to insert "<>"

Re: Macros - how to insert "<>"

Re: Macros - how to insert "<>"

Macros - how to insert "<>"

RE: Twin Process for 4D SQL Data Source

Re: Twin Process for 4D SQL Data Source

RE: Twin Process for 4D SQL Data Source

Re: Twin Process for 4D SQL Data Source

Re: localisation (again)

4D Write Pro Sample DB on YouTube

Re: Twin Process for 4D SQL Data Source

Re: Twin Process for 4D SQL Data Source

Twin Process for 4D SQL Data Source

RE: AreaList Pro version 10 - The new breakthrough in 4D user interface

Re: localisation (again)

Re: Stack level in 4DDebugLog.txt

Re: localisation (again)

Re: 4D Write Pro Sample DB on YouTube

RE: 4D Write Pro Sample DB on YouTube

RE: Stack level in 4DDebugLog.txt

20 matches

Site Navigation

Mail list logo

Footer information