Re: Old 4D Transporter (ResTransporter) or Equivalent

[Nigel Greenlee via 4D_Tech]

Peter

This may not be exactly what you need.

 I recently had need to look in some Resource files to see what was there..as I 
am sure you know we used to have ResEdit. I came across an app call Resilla 
which allows you to look in the resources, you might find that a useful way to 
view the resources you are trying to extract,

Nigel Greenlee

> On 5 Jul 2020, at 12:14, Peter Jakobsson via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi Folks
> 
> Many thanks for all the tips - much appreciated.
> 
> I managed to solve my problem with Spencer’s suggestion to write my own 
> Transporter in 4D using DOCUMENT TO BLOB(file;*) to split the resource fork 
> away and save it as a data fork.
> 
> That let me transfer to Windows.
> My old structure and data now work fine in my Windows 7 VM with 4D 2004 
> server.
> 
> Many thanks again for the useful responses !
> 
> Regards
> 
> Peter
> 
> **
> 4D Internet Users Group (4D iNUG)
> New Forum: https://discuss.4D.com
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Time to work on this task..

[Nigel Greenlee via 4D_Tech]

John


Yeah. 


Think i have not been digging around in that bit for a while(since V16), its 
not the manifest i need to read-that tells the commands(which I will probably 
do something with later-less annoying for what i am doing-its the constants.xlf 
and they do seem to generally be in the same format(i will ignore some old plug 
ins)


i just need to slightly remodel the way i read the 4D constants.

Nigel Greenlee




> On 24 Mar 2020, at 16:27, John DeSoi via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> Hi Nigel,
> 
> Do you mean old plugins that store information in resource (rsrc) files? I 
> think anything recent uses a JSON file (manifest.json).
> 
> John DeSoi, Ph.D.
> 
> 
>> On Mar 24, 2020, at 6:08 AM, Nigel Greenlee via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> Also..whilst i am at..anyone written anything reliable they would like to 
>> share that gets the constants used by plug ins..there are different formats 
>> in different plug ins and i would like to get the constants list similar to 
>> how i get them for the 4D code.
> 
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Time to work on this task..

[Nigel Greenlee via 4D_Tech]

Hi

So this one is for the deep divers. I am working on a project whilst all my 
other projects are a bit on hold,  that has been a background task for me for a 
while. I won't bore everyone with WHY I am doing this, but i suspect this same 
information is applicable to other developers as I have seen posts on the 
subject.

As some of you know you can delve into the 4D resources and extract some 
information about 4D Commands and there parameters. There are are actually two 
relevant files. One is the 4DSyntax.xlf on the (en.)lproj folder and the other 
is gram.4dSyntax in the resources folder. The later one i found rather 
unhelfpul for my purposes as the ‘paramters’ are described by letters and the 
same letters can mean different things. The xlf is nicer stuctured for me-and 
someone has posted a nice parser on the forums that will read the document 
which always saves work(thank you-Maurice Inzirillo i think).

So where i am is that in the absence of 4D producing something which defines 
that data types for each command i am proposing producing a JSON file(for 
English commands), and wondered if this is of interest to anyone else.

 if it is i would be happy to discuss the formatting(maybe it should have the 
command number as well as the name to make translation to other languages 
easier) . Maybe other people have better ideas on how to encapsulate a few 
oddifties(repeating parameters 2..n, Optional parameters), better ways to 
describe a parameter that is a table or a field or a variable or a *. at the 
moment the Json looks something like this(just a short extract), a shared 
concept would probably be better than me inventing a wheel that only suits me, 
and by having others involved it would mean we could section up the document 
for validation to ensure it does not have mistakes. At the moment it includes 
handling for the latest V18 command parameters although i have been extracting 
using V17(and i am not currently extracting the 4D write pro commands)  This is 
of limited use to most programmers but for some of us this data helps us create 
better code validation tools(if anyone really wants to know what i am doing let 
me know and if it interests you, you will be welcome to try it out)



{
"Command Name": "collection.combine",
"Command Parameters": [
"col2",
"index"
],
"Parameter Data Types_1": [
42
],
"Parameter Flags_1": [
"Mandatory"
],
"Parameter Data Types_2": [
6,
9
],
"Parameter Flags_2": [
"Optional",
"Optional"
]
}


Any interest?..before humanity dies out.(hell... most us must be ‘at risk’).

Also..whilst i am at..anyone written anything reliable they would like to share 
that gets the constants used by plug ins..there are different formats in 
different plug ins and i would like to get the constants list similar to how i 
get them for the 4D code.


Nigel Greenlee





**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: MySQL connection from 4D

[Nigel Greenlee via 4D_Tech]

Jeff

Indeed i did look at that(-its overkill for what i need) but it does say on 
there it works for Mysql V4 and up-hence why i am wondering of 4D in itself 
won’t connect to and older version.

Thanks

Nigel

> On 28 Oct 2019, at 15:54, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> If you don't get anywhere with SQL LOGIN (which should work, given the right 
> driver settings), Pluggers Software sells the MyConnect plug-in which works 
> perfectly and is very fast/reliable.
> 
> https://www.pluggers.nl/product/myconnect-plugin/
> 
> We've been using it for many years performing crucial functions interfacing 
> 4D with our web stack that run 24x7x365.
> 
>> On Oct 28, 2019, at 11:40 AM, Nigel Greenlee via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> Should I be doing something else other that SQL 
>> LOGIN(ODBC:xx.xx.xx.xx;username;password) for a MySQL server?
> 
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

MySQL connection from 4D

[Nigel Greenlee via 4D_Tech]

Hi


I am pretty sure other people are connecting to MySQL from 4D so i am hoping 
someone can advise me on where my problems may lie.

Pre-amble:—

I want to connect to the database of an Asterisk Telephone server. We have 
established that the database is accessible on the network and using 
‘sequel-pro’ i can connect from my Mac(Seqel-pro bypasses ODBC manager so its 
not that helpful in diagnosing my problem).

I have also been able to setup and test an ODBC connection using the ODBC 
manager on WIndows, as i was not having much luck getting a connection from 4D 
to the MySQL database on my mac i switched my efforts to there.


After some flapping around I established that the my-sql connector we had did 
not match the my-sql server which is running 3.5x. Later drivers on the pc 
would not connect but the 3.5 driver does connect to the MySQL database From 
Windows(as you know the odbc administrator on PC

The problem in a nutshel:—


However when i try to get my 4D app to to perform a login i get a stack 
overflow problem from 4D V17.(recursive errors eventually returning control to 
me!).

Does anyone know if 4D is able to connect to a MySQL server running version 3x? 

Should I be doing something else other that SQL 
LOGIN(ODBC:xx.xx.xx.xx;username;password) for a MySQL server?

Nigel Greenlee
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Confused array type in an object

[Nigel Greenlee via 4D_Tech]

Hi.

I am looking for a better solution than what i currently have..this has 
probably been encountered by others.

I am creating some code on 4D V17 but I can not really use collections or 
.notation as this is going to get deployed on V16 and will not be upgraded for 
at least a few months(and i am not sure that would solve this problem anyway).

I am retrieving an object from a connected source(Magento FYI)... from the 
object  we get a sub entity object and that sub entity may itself contain a 
subentity etc etc(we are mapping data to go into our system). I am trying to 
write something agnostic and generic so i am not expecting to ‘hard wire’ any 
behaviour for a specific entity into the code that extracts the data.

So at each ‘entity’ level I get the attribute names and types. where the 
attribute type is 38 or 42 this is a ‘sub entity’ so we are going to get that 
object and call back into the same code to go down a level.

 Now on V16 of course i wont get a type 42 but actually a type 42 SHOULD(as i 
understand it) mean the object (element) contains an object and that object 
SHOULD be a ‘complex’ object and my understanding is that should be an array of 
objects(else it would not be a collection)? Have i misunderstood that? 

So i should be able to write(for a type 42 attribute)..

OB Get Array($ObjData;$attributeName;$aObjSubObject) //Where $aObjSubObject is 
an Array Object

(and mostly that works)….


However

I am finding a case where
Attribute Type =42 
Attribute Name=“additional_information"

...and the object looks like this:-

{account_status:null,additional_information:[Check / Money 
order],amount_ordered...

in that object ‘additional_information’ looks like
additional_information:[Check / Money order]

which as any JSON/4D object fool can see(LOL) is an array type object(of text 
in this case) not a collection of objects. When i retreive it as an array of 
objects I get the correct number of elements(1) but the value of the element(1) 
is NULL because its not [{…


indeed if I write:-


OB Get Array($ObjData;$attributeName;$aTextarray) //Where $aTextarray is an 
Array of type text

This indeed gets the values from the object..which would be absolutely fine(and 
a work around might be to get both, as neither error, and then look at whether 
the values in the object array are null and if they are then its an array of 
values).

So my question is this. What is a better way to find out what the type of data 
in the attribute is? What am I missing in my understanding of the structure of 
an/this object.

OB Get type returns 42(matching the attribute type of course!). It feels like 
the attribute is Shrodingers Cat- existing as a collection of cats and not a 
collection of cats at the same time. 


Nigel Greenlee



**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Options To Put Data Into Existing Excel Spreadsheets?

[Nigel Greenlee via 4D_Tech]

Allan

I think I have the code you refer to. if it is the component that uses vbs 
scripts(such as application_arrange_windows.vbs)..this might have been 
something other than Miyakos’ code.. contact me off list and i can put a copy 
of this on a drop box for you.

C_TEXT($1)
C_TEXT($2)
C_TEXT($3)
C_TEXT($4)

SCPT_XL_SetParameter ("XCEL_WORKBOOK_NAME";$1)
SCPT_XL_SetParameter ("XCEL_SHEET_NAME";$2)
SCPT_XL_SetParameter ("XCEL_RANGE";$3)
SCPT_XL_SetParameter ("XCEL_VALUE";$4)

SCPT_XL ("range_set_value”)

Nigel





> On 7 May 2018, at 09:44, Allan Udy via 4D_Tech <4d_tech@lists.4d.com> wrote:
>  application_arrange_windows
> Hi All,
> 
> I'm up the proverbial creek without a paddle...
> 
> Years ago (v11) we started using the 'Excel Library' component put together 
> (I think) by Keisuke.  For the life of me I can no longer find a source 
> version of this (if there ever was one), and it appears that any online link 
> to the component no longer exists.
> 
> At one point we did get the component upgraded to work in a v14 database.  
> Seems (under MacOS at least) that it's still working under v16, but it's 
> plainly only 32-bit.  Due to a couple of other reasons we now need to look at 
> taking this single-user app to 64-bit, and of course it won't work.  :-(
> 
> I have found Keisuke's 4d-plugin-xls  
> (https://github.com/miyako/4d-plugin-xls), but this does not appear to 
> contain options to find and set cell ranges as the earlier component did, nor 
> is there any sensible documentation, so it's not really useable.
> 
> I'm aware of Pluggers XL Plugin, but at 600 Euro it's going to be hard sell 
> for our client when only basic use is made of Excel  (Open a spreadsheet, 
> find a couple of named cells, put data in those cells, save the spreadsheet).
> 
> Are there any other options out their to interface a 4D app with an Excel 
> spreadsheet?
> 
> Cheers,
> Allan Udy
> 
> Golden Micro Solutions Ltd, Blenheim, New Zealand
> http://www.golden.co.nz
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://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: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Macro to check that local variables are declared in a method?

[Nigel Greenlee via 4D_Tech]

Bob

I have a component that declares all my variables(not just locals). Locals were 
simple-everything else was hard. It relies on you having a definable format(i.e 
type is at end or demarked by _ ) and having consistent(even if varying) way of 
identifying type (e.g _at is is array text and _atxt is array text  and _t is 
txt and _txt is text. if it finds something that it does not understand it 
decalres it(commented out) as //C_UNKNOWN($_somethingprobablyatypo_xxx).

The definitions are editable and you set them up when you put the component 
it(it installs a couple of methods in your code and does not alter your 
structure so taking it back out does not break your code). I have been using it 
on several systems for over a year with differing decalration systems and so 
far it has been very good(it does some other things besides decalring 
variables..will auto put a header on your methods and auto put code in if you 
want it..i have it put $_l_FormEvent:=Form Event ..Case of..:($_L_formevent=on 
clicked)..end case in all new object methods for example).

You would be welcome to have a copy to try out-i would welcome feedback on 
whether it can work for others. (if you do want to try it let me know your 
naming convention so I can confirm it will work with the code).-i have versions 
for V14,15,AND 16.

Nigel Greenlee




> On 27 Apr 2018, at 11:54, Bob Miller via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> Hello,
> 
> Has anyone created a macro to check a method to make sure all its local 
> variables are declared?
> 
> I've thought about undertaking such a thing, but as it probably involves 
> getting into regular expressions, I've been looking forward to doing this 
> with some dread.
> 
> If anyone has done this already and is willing to share, I'd be much 
> obliged!
> 
> The "tough" issue for me is "how to identify a local variable":
> - it begins with a $
> - it may end with any of these characters: space, equals, semicolon, 
> colon, dash, left paren, left curly brace, end of line, or any arithmetic 
> or comparison operator
> - it is not fully enclosed in quotes; example: "$ ###,###.00" is a format, 
> not a local variable, but I'm ignoring EXECUTE ON SERVER, etc.
> 
> I'm probably making a mountain out of a molehill, but hey, that's what 
> this list is for - to let people show me exactly that.  I appreciate it.
> 
> 
> Bob Miller
> Chomerics, a division of Parker Hannifin Corporation
> 
> 
> ll
> "PLEASE NOTE: The preceding information may be confidential or privileged. It 
> only should be used or disseminated for the purpose of conducting business 
> with Parker. If you are not an intended recipient, please notify the sender 
> by replying to this message and then delete the information from your system. 
> Thank you for your cooperation."
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://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: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Listbox question

[Nigel Greenlee via 4D_Tech]

Ferdinando

I want to share with you how i manage listbox scroll bars

1) In the on load section of the form i call a wrapper method with pointer to 
the list box area(i have never updated these to use the object name but that 
should really be done).

LB_SetScrollBar (->SCRIPTS_lB_Scripts;-2;-2)  the -2 here sets them to visible 
if i want them invisible it is -3 -3




I have put the code for that method here. 
https://www.dropbox.com/s/j6fmfrmt954ue8c/LbSetScroll.txt?dl=0

This is a nice method-i (originally) wrote(with others) when we moved from AL 
many years ago. you can use it to hide/swap/show vertical or horizontal or set 
the scroll position


2) in the form resize i call another bit of code
LB_ShowHideScrollonResize(->SCRIPTS_lB_Scripts)

I have put the code for that method here. 
https://www.dropbox.com/s/kfjyfp8i3uw02wm/LB_ShowHideScrollonResize.txt?dl=0

This method works out if the scroll bars need to be displayed(based on the 
column widths and the number of rows and the size of the listbox area-It calls 
the first method))




Hope this is useful to someone


Nigel Greenlee
(This gun is for hire..available for tackling any 4D job anywhere)







> On 18 Oct 2017, at 17:14, stardata.info via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi All,
> 
> I use 4D V15.4 on windows.
> In one layout i use the listbox object, and in settings area i have setting 
> the scrol bar like automatic.
> I have only one row in this list box, but 4D show the same the scroll bar.
> 
> Someone know the reason?
> 
> Thanks
> Ferdinando
> **
> 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: v13 - odd compiler error

[Nigel Greenlee via 4D_Tech]

Chip

Ah..The joy of auto declared variables removes this problem for me..so much 
that when i work on databases that don’t do the declarations for me it is a 
pain.

Nigel Greenlee

> On 12 Oct 2017, at 22:36, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> well your "friend"  ;) was right...
> DUH!
> c_pointer($43;
> 
> of course, I have copy pasted, into a new method window, deleting the 
> original, compacted, and had *just* finished manually retyping the 
> method (not long fortunately)...
> 
> 
> 
> On Thu, 12 Oct 2017 10:26:01 -1000, David Adams via 4D_Tech wrote:
>> Check if there is a typo and you've declared $43 instead of $3. The errors
>> you describe are almost exactly what I would expect in this case. Not that
>> I've ever done anything like that...but it happened to a friend once or
>> twice.
>> **
>> 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
> **

**
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: VOIP caller ID interface

[Nigel Greenlee via 4D_Tech]

Joe

I have been writing an interface to the Asterisk VOIP software(Using PHP). At 
this point  I am waiting for the client to decide how they want the interface 
to work-if you are using Asterisk I can offer some assistance (I found there 
documentation somewhat obtuse and the sample 4D Code that was published as a 
tech-note a few years back needed some finesssing to get the full information 
on queues etc.

My plan is to link telephone numbers to customers where the number may not be a 
number published on the record as a number to contact the customer on so when 
an incoming call comes we can look up the client and if not identified by the 
software allow the number to be ‘tagged’ to a customer-my thinking being that 
often customers call from personal mobiles or call from numbers external to the 
business-so Fred from Hokey Company 2000 may call from his 07 number..but 
we dont want sales people calling Hokey Company 2000 on the 07xxx number or to 
even show that number on the customer record.

Nigel Greenlee



> On 8 Oct 2017, at 09:35, Peter Bozek via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> On Sun, Oct 8, 2017 at 2:11 AM, Joe Dombroski via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> Has anyone extracted caller ID from a VOIP phone and used it to open a
>> client record in 4D?
>> 
>> 
>> 
> I am now solving same problem so would be interested in answer as well.
> 
> I am able to communicate with certain routers (Fritzbox, which are quite
> nice German routers) that offer call monitoring, including VoIP calls,
> through telnet - like interface where router writes all call events. But
> need a solution that would work with any router.
> 
> It seems that SIP analyzers work by snipping the TCP communication, and I
> do not want to go that way. I was looking at TR-069 protocol that can be
> used to monitor router performance, but it seem that cannot be used to get
> VoIP events in real time. There are some extensions of the protocol that
> seems promising, but that would require a lot of investigation and testing.
> As I did not found any description how to do it, it is open question if it
> is even possible.
> 
> --
> 
> 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
> **

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

oh sweet

[Nigel Greenlee via 4D_Tech]

All


How long have i wanted this….



https://blog.4d.com/passing-data-back-and-forth-between-forms/?utm_content=buffer15244&utm_medium=social&utm_source=twitter.com&utm_campaign=buffer

joy joy joy of 4D


Nigel Greenlee
**
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: Listbox Spacing Between Columns

[Nigel Greenlee via 4D_Tech]

Douglas

I undertook a project a long long long time back to convert a pretty rich 
framework(for its time) from Area List to Listbox..to put that in time context 
it was when you could not buy any licences for Area List!

 At the time LB did not have anything like the abilities it had now but i can 
say i have never missed Area List and implement very easy listbox areas on all 
my forms even on new databases where i have only put bits of the framework 
in-including nice stuff like putting formula based columns onto field based 
listboxes. .(I would happily undertake to move anyone to listbox if you you 
want to farm the job out). 



Nigel Greenlee




> On 24 Sep 2017, at 20:20, Douglas von Roeder via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Sannyasin:
> 
> "I’m looking again seriously at Listboxes as a replacement for ALP. It’s
> close, but there’s a couple things that don’t quite work well in Listboxes
> for heavy data editing. I do both the programming and the data editing for
> this, so little glitches and funky UI things make a difference!"
> 
> I haven't delved into LB's at much depth. Part of it is that ALP does what
> I need it to do and, to their credit, LB's are an easy transition from
> grouped scrollable areas. Having done multiple"no new features" upgrades
> from legacy versions of 4D this year, I appreciate that.
> 
> In contrast, I worked on a project where LB's were required (ALP was not
> allowed) and it was absolutely clear that "the little glitches and funky UI
> things make a difference" to the point of having to figure out a *lot* of
> work arounds. I offered to buy ALP for the client but they were adamant
> so the UI was limited but chacun a son gout.
> 
> BTW, converting the array to a text array and keeping the numeric array
> hidden might be your best bet. If LB's offer calculated columns, that would
> be a piece of cake.
> 
> 
> --
> Douglas von Roeder
> 949-336-2902
> 
> On Sat, Sep 23, 2017 at 8:10 PM, Sannyasin Siddhanathaswami via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> Me too! (well not a couple of decades—at least 1 decade)
>> 
>> I’m looking again seriously at Listboxes as a replacement for ALP. It’s
>> close, but there’s a couple things that don’t quite work well in Listboxes
>> for heavy data editing. I do both the programming and the data editing for
>> this, so little glitches and funky UI things make a difference!
>> 
>> 
>> Sannyasin Siddhanathaswami
>> 
>> On Sep 23, 2017, 5:04 PM -1000, wrote:
>> 
>> Sorry, that’s about it for me. I’ve been using AreaList Pro for a couple of
>> decades…
>> **
>> 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
**

Re: Command numbers and names and using Execute

[Nigel Greenlee via 4D_Tech]

Pat


An excellent point. 

Where i think that won't work though-if i am understanding correctly is this...

 Lets say i write the following piece of very odd code(why you would write this 
i do not know but its an example)..

if(themoonisblue)
$_t_ExecuteText:=(“Array Text($_at_MyText;0)”)
else
$_t_ExecuteText:=(“Array longint($_al_MyLongint;0)”)
end if
Execute formula($_t_ExecuteText)

and presumably if you are using Footrunner(maybe that tokenises the code so 
maybe footrunner does not have a localization issue) or your own version of 
code from text(like what I have) then it also would still need manual 
translation to either the local command name or the command ID

if you are doing something like the above- reading the V16 manual- you need to 
modify the way the text is stored to modify the syntax to the tokensyntax-so 
using the command number of the command typed and storing that as :Cxxx as 
described in Miyakos email. 

Actually that new syntax is really useful if you are running code from text via 
a series of execute statements as not only will it cope with localization but 
also field/table renaming-although for me my approach will be to create the 
tokenised version of the text as extra field.


Nigel Greenlee


> On 21 Sep 2017, at 18:24, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> FYI - in V15 and later you don't need to bother with the command numbers
> any more:
> 
> "
> Compatibility note: Since a command name may vary from one 4D version to
> the next (commands renamed), this command was used in previous versions
> 
> of the program to designate a command directly by means of its number,
> especially in non-tokenized portions of code. This need has diminished over
> time as
> 
> 4D continues to evolve because, for non-tokenized statements (formulas), 4D
> now provides a token syntax. This syntax allows you to avoid potential
> problems
> 
> due to variations in command names as well as other elements such as
> tables, while still being able to type these names in a legible manner (for
> more
> 
> information about this point, refer to the Using tokens in formulas section).
> Furthermore, by default, the English language version is used starting with
> 4D
> 
> v15; however, the "Use regional system settings" option on the Methods Page of
> the Preferences allows you to continue using the French language in a
> 
> French version of 4D."
> 
> HTH!
> Pat
> 
> On 21 September 2017 at 17:39, Arnaud de Montard via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> 
>>> Le 21 sept. 2017 à 17:51, Nigel Greenlee via 4D_Tech <
>> 4d_tech@lists.4d.com> a écrit :
>>> 
>>> For ($i;1;1)  //well i know there are less than 1 commands for
>> the next few years at least:)
>> 
>> you can exit the loop when ok = 0, see here:
>> <http://forums.4d.com/Post/FR/16080071/3/16455667#16455667>
>> 
>> --
>> Arnaud
>> 
>> 
>> **
>> 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
>> **
>> 
> 
> 
> 
> -- 
> *
> CatBase - Top Dog in Data Publishing
> 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
> **

**
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: Command numbers and names and using Execute

[Nigel Greenlee via 4D_Tech]

Paul.

When i was writing my rather excellent(even though i say so myself) auto 
variable declaring code I wanted the command and command numbers. I just looked 
up what i did

I ran this bit of code :- 
ARRAY TEXT(SC_at_CommandNames;0)
For ($i;1;1)//well i know there are less than 1 commands for the next 
few years at least:)

  $_t_CommandName:=Command name($i)
If ($_t_CommandName#"")
   APPEND TO ARRAY(SC_at_CommandNames;$_t_CommandName)
End if 
End for 

Now of course you could store the command id ($i) in an array write the 
‘English’ command  name and number to an xml. and when in a French version load 
the ‘French names’ and IDS compare them to the ones in your text and replace 
the english command with the french command or execute the command by ID
storing your text in the following format:


$_t_CommandName:=Get_CommandName($EnglishCommand)<-in which you lookup the ID 
of the command in your xml document(veryfast) and return the ID of that command 
and then get the localised command name

or you could store a version of your text in which the name is replaced with:
$_t_CommandName:=Command name(numberofcommand) when you save the text of your 
execute-in this case you could just hold the local command ids in an array.
Execute($_t_CommandName)

Either way you have to convert from the language you wrote the statement in to 
an ID and then get the localised name of the command from the ID


Hope thats enough for you

Nigel Greenlee

> On 21 Sep 2017, at 16:34, Paul Lovejoy via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi everyone,
> 
> I want to use the Execute command in a multi-lingual environment use it to 
> execute 4D commands such as ARRAY TEXT(). Of course, this would fail as is on 
> a French version of 4D. I believe there’s a way to use Execute() with the 
> internal command numbers but I can’t find anything in the docs or the 
> knowledge base.
> 
> Does anyone know how to do this?
> 
> Thanks in advance,
> 
> 
> Paul
> **
> 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: Server Process "Frozen"-ish

[Nigel Greenlee via 4D_Tech]

I have server side processes that run in the background. Because i like to 
start as little as necessary at startup my code ‘automatically’ starts the 
process.

So in my code(where it writes the jobs into a table for the server to process). 
After the client side(or server side) has written a task it calls.

$_L_PostActionProcesser:=Execute on 
server("DATA_BackgroundRecordHandler";128000;"Post Save Data Processor";True;*) 

That makes sure the process is running. 

Now I know the process should not quit-but you never know what might happen. I 
have not come across it quitting for no reason but i have come across reasons 
to ‘end’ the process. The above ‘solution’ makes sure it is running(and avoids 
starting it at startup on the server). 

Just a workaround suggestion..

Nigel Greenlee.




> On 11 Sep 2017, at 07:43, Bernd Fröhlich via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Cannon Smith:
> 
>> I’ve seen something odd since upgrading our customers to v16.1 a few months 
>> ago. This is on 64-bit server, both platforms. There are a few background 
>> processes that continually run on the servers, waking up every few seconds 
>> to see if there is work to be done. This has worked without problem for a 
>> decade now, but starting with v16.1 we occasionally have a process the just 
>> sort of quits.
>> 
>> By occasionally, I mean maybe once in 2-3 months per server. Little enough 
>> that I didn’t pay much attention at first—just relaunched the server. But 
>> cumulatively (across all servers) it has happened probably 20-30 times in 
>> the last few months.
>> 
>> By the process sort of quitting, I mean that the tasks it is supposed to 
>> take care of just stop getting taken care of. The activity monitor shows the 
>> process is still there and nothing I have noticed seems out of the ordinary. 
>> It’s like the code just quit executing in that process.
>> 
>> I know I need to get more detailed information and will start trying to do 
>> that, but wonder if anyone has experienced anything similar that might give 
>> me a starting place to look?
> 
> 
> Same here. 4D V16.1 32 Bit on OS X 10.11.6.
> A background process does some reporting, sends and receives mails, etc.
> Every once in a while it just stops. No idea why. At least I am not the only 
> one.
> Now we just have to find what is common on all our servers...
> 
> 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
> **

**
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 and Git Connection

[Nigel Greenlee via 4D_Tech]

Neil.

I would be interested in getting some info on doing this. 

I would like to move my repositories  from local stores to a github. When i 
tried to set it up i was getting a problem with MaxBuffer size(not sure if I 
need to start with an empty(ish) directory on the local drive.

Anything you can share on getting things rolling would be most welcome.

PS i am now have some a nice code versioning solution that i am looking to take 
to the next stage and looking for some funding.


Nigel Greenlee




> On 22 Aug 2017, at 17:04, Lee Hinde via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> When are you doing your commits? With each method? Daily? Neil suggested he 
> was looking for incremental commits. Which seems ‘noisy’.
> 
> 
> 
>> On Aug 22, 2017, at 9:00 AM, Drew Waddell via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>> 
>> I have done this.  I used Macros to run methods that would commit the text 
>> of the methods edited to a Git repo, there is an on save event.  It's 
>> definitely not perfect but it helps my team track changes and look up 
>> potentially "ghost" changes in our codebase.
>> 
>> Drew Waddell
>> Development Team Lead
>> Orchard Software
>> 
>> -Original Message-
>> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Dennis, 
>> Neil via 4D_Tech
>> Sent: Tuesday, August 22, 2017 10:17 AM
>> To: '4D iNug Technical'
>> Cc: Dennis, Neil
>> Subject: 4D and Git Connection
>> 
>> I recall that someone has worked with Git as a 4D code repository but I 
>> don't exactly remember where I heard it.
>> 
>> I'm looking to automatically check out and check in 4D methods to Git as 
>> they are modified via a 4D client. To give you the full picture we want to 
>> use TFS and single sign on to connect to TFS which can be setup as a Git 
>> repository. The Git repository in TFS will store any changes our team makes 
>> to the 4D server's code. Has anyone done this or can anyone point me in the 
>> right direction?
>> 
>> Neil
>> 
>> 
> 
> **
> 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: UUID vs Longint primary key

[Nigel Greenlee via 4D_Tech]

+2

Nigel Greenlee


> On 4 Aug 2017, at 12:09, Marcus Straßmann via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> +1
> 
> 
> MacStrass - Marcus Straßmann
> Softwareentwicklung und Beratung
> Auf der Markscheide 35
> D-44807 Bochum
> 
> Mobil: +49 (173) 374 39 92
> eMail: macstr...@macstrass.de
> 
> Am 04.08.2017 um 10:39 schrieb Herr Alexander Heintz via 4D_Tech 
> <4d_tech@lists.4d.com>:
> 
>>> Someone can explain when is better use UUID and when Longint field in 
>>> primary key?
>> 
>> If you can even remotely think of a scenario where you might ever be 
>> challenged to merge databases, go with a UUID!!!
>> It will save you incredible headaches!
>> Switched to UUIDs long ago, never looked back, best decision ever!
>> 
>> Of course if such a scenario is unthinkable, you can use longints
>> 
>> **
>> 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
**

Re: Listbox Printing

[Nigel Greenlee via 4D_Tech]

Jim

FYI. If you want to print a list box The code is rather slow. Its actually 
better to convert it to a Quick report.

The following code will print any listbox area. As you can see I have not 
optimised this for V16. I need to look at the way it is setting the font and 
size etc, it also uses some formats from my system -should not take much to 
adapt this to your needs.(I tried it with a million rows i think and it was 
pretty impressive)

ARRAY TEXT($arrColNames;0)  
ARRAY TEXT($arrHeaderNames;0)
ARRAY POINTER($arrColVars;0)
ARRAY POINTER($arrHeaderVars;0)
ARRAY BOOLEAN($arrColsVisible;0)
ARRAY POINTER($arrStyles;0)

C_LONGINT($left;$Top;$Right;$Bottom;$MaxRows;$MaxPortrait;$MaxHeight;$MaxWidth)


LISTBOX GET 
ARRAYS(DB_b_OutputArrays;$arrColNames;$arrHeaderNames;$arrColVars;$arrHeaderVars;$arrColsVisible;$arrStyles)<—use
 your listbox area reference here
$TotalWidth:=0
For ($i;1;Size of array($arrColNames))
$TotalWidth:=$TotalWidth+LISTBOX Get column 
width(*;$arrColNames{$i})

End for 
//$OK:=PRINT_SetSIZE ("A4";"P”)<—This is  piece of code  i have 
that sets the print size-its 


$QRarea:=QR New offscreen area  
QR SET REPORT TABLE($QRarea;DB_l_CurrentDisplayedForm)
$ColumnNumber:=0
For ($i;1;Size of array($arrColNames))

RESOLVE 
POINTER($arrColVars{$i};$vsVarName;$vlTableNum;$vlFieldNum)
If ($vlTableNum>0) | ($vsVarName#"")
$ColumnNumber:=$ColumnNumber+1
If ($vlTableNum>0)

$Field:=Field($vlTableNum;$vlFieldNum)
Else 
$Field:=Get pointer($vsVarName)
End if 
$HeadVar:=$arrHeaderVars{$i}
QR INSERT 
COLUMN($QRarea;$ColumnNumber;$Field)
C_TEXT($title;$displayFormat)
C_LONGINT($hide;$repeatedValue)
C_LONGINT($size)

$type:=Type(($Field)->)
$Format:=""
  //LB_SetFormat ($Area;1;"";$i;$i;3)
Case of 
: (($type=1)) & ($Format="")
$Format:="|AccountsNZ"
: (($Type=8)) & ($Format="")
$Format:="|integers"
: (($type=9)) & ($Format="")
$Format:="|Longint"

: ($type=Is time) & 
($Format="")  
$Format:="&/5"
: ($type=4) & ($Format="")
$Format:=""

Else 
$Format:=""
End case 

C_TEXT($object)
QR GET INFO 
COLUMN($QRarea;$ColumnNumber;$title;$object;$hide;$size;$repeatedValue;$displayFormat)
$ColumnWidth:=LISTBOX Get column 
width(*;$arrColNames{$i})
$Hide:=Num(($ColumnWidth=0) | 
($arrColsVisible{$i}=False))

$ColumnTitle:=OBJECT Get 
title($HeadVar->)

QR SET INFO 
COLUMN($QRarea;$ColumnNumber;$ColumnTitle;$object;$Hide;$ColumnWidth;1;$Format)
If (True)
QR SET TEXT 
PROPERTY($QRarea;$ColumnNumber;qr title;_O_qr font;_o_Font number(<>FontBold))

QR SET TEXT 
PROPERTY($QRarea;$ColumnNumber;qr title;qr font size;<>FontDefaultBoldSize)
QR SET TEXT 
PROPERTY($QRarea;1;-1;qr bold;1)
  //QR SET TEXT 
PROPERTY($QRarea;1;-1;qr text color;0xFF00)

QR SET TEXT 
PROPERTY($QRarea;$ColumnNumber;qr detail;_O_qr font;_o_Font number(<>FontPlain))
 

Re: Restricting a query

[Nigel Greenlee via 4D_Tech]

Jarosz

Actually you don’t need to build your own query editor. All you actually need 
to do is make sure you wrap any calls to the query editor(and to any query in 
general) so you can apply to any query a client filter



> On 31 Jul 2017, at 19:38, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Jarosz,
> For that you'll want to build your own query editor. To achieve that sort
> of separation of data you'll need to be careful that all queries and
> selections created by relations are segregated by client.
> 
> On Mon, Jul 31, 2017 at 11:34 AM, jarosz via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
> 
>> I have a table which contains records for 10 different clients.
>> I'd like to give a client the ability to search the table for only his
>> records and not be able to see any of the other clients' records.
>> 
>> Is it possible to do this using the standard 4D Query editor by always
>> applying an additional search criteria eg clientID=xxx?
>> 
>> Or do I need to build my own custom query editor?
>> I'm using 4D 15.4.
>> 
>> I'd be interested to hear how others have approached this...
>> 
>> Many thanks
>> 
>> Michael Jarosz
>> 
>> 
>> 
>> 
>> --
>> View this message in context: http://4d.1045681.n5.nabble.
>> com/Restricting-a-query-tp5753437.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
>> **
> 
> 
> 
> 
> -- 
> Kirk Brooks
> San Francisco, CA
> ===
> 
> *The only thing necessary for the triumph of evil is for good men to do
> nothing.*
> 
> *- Edmund Burke*
> **
> 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
**

Strange Error

[Nigel Greenlee via 4D_Tech]

Hi

One of my clients is still using 4D V12. Today an error came up that I have not 
seen before and of course the immediate assumption is that I have put the alert 
message in. The alert appears on a form in compositiing mode where the code 
loads a web form(that may or may not be relevant-but that is something i have 
changed on the form recently).  I tried opening the same record and did not get 
an error so i am thinking this error is not something i need to worry about.

I just wondered if anyone else has seen this message before and if you ever 
idendified a cause.

The alert says

Alert

TECHNICAL ERROR

Details:
Error thrown: [object Object]
Text status: Error


Any information anyone can provide will be useful before i get asked what is 
causing it.


Nigel Greenlee


**
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: Use of Objects vs Global Variables (Was 'Arrays vs Objects...)

[Nigel Greenlee via 4D_Tech]

Global Variables.

Regardless of the relative merits of Arrays vs Object. I would like to relay my 
dislike in general of Global variables. I have been working with 4D since 
before the concept existed-since 4D V2(Globals came in with V3). Yes i am one 
of the old boys.

Back then we did not have multiple processes and when V3 arrived we were all 
amazed and in awe of the ability to have multiple processes and I think we all 
went mad for interprocess(global) variables.(i think we all had singing dancing 
palettes on the screen doing fancy things to update themselves from other 
processes). 

Now if we were working in Javascript the concept of a global variable would 
very much be considered something to be avoided like the plague. Global 
variables are extremely useful but also extremely prone to problems, and over 
the past couple of years-any javascript tutorial tells you to try and avoid 
them, in 4D  I  have really cut down on my use of them.

In my opinion a global variable should in general only be used for two things.
1) You want to set a value(or group of values) and through the life of the 
programme they do not change once set(so here you are using them like a 
constant)
2) You want to maintain an array that will be written to by multiple processes.

With point 2 you must protect the arrays with semaphores so only one process 
alters the arrays at any one time-and often where these are used there might be 
other ways to do it.

I have just this week been dealing with 2 different structures where the 
liberal use of interprocess arrays has lead to problems. Problems that do not 
show up in testing and probably show that that the way the routines has been 
used has changed over time. In both cases-different companies-different 
programmers-different stuff an error shows up just occasionally. In one of 
those systems discussion with the client shows that the usage of interprocess 
variables has caused ‘strange’ unexplained un-investigated things to happen 
where process A is changing the contents of <>Variable just at the point when 
process B is about to send the contents of <>Variable that process B had set to 
a document (‘sometimes we get a situation where the same order document is 
created twice’!!)..and they have just restarted the machine to get rid of the 
problem in the past(a practice that means you think the problem is 4D not the 
way the code is written).

Simply protecting the handling so only one process at a time can modify the 
interprocess variables and arrays would have avoided all this. I suspect the 
original programmer never intended the functionality to be running in multiple 
processes at the same time and used interprocess arrays to (I think) make it 
easier to display the data on a form that is in a different process. Beyond the 
idea of a form in a different process i don’t see any purpose in the arrays in 
this case being interprocess-they are being constantly changed and as such 
should at best have been process arrays, In fact in a modern context(this was 
written way before that) where we have been able to pass pointers to local 
variables since 4D V11(??-maybe it was before that) I would generally argue 
that programming using locals is much better-and that could be local objects or 
local arrays. These really show that an interprocess array was used for 
convenience where it was not really needed and changes to code did not include 
a proper assessment of the impact-just because you can do something and it 
works once does not mean it is tested or fit for purpose.

In most of my code over the past few years I have moved so far away from <> 
variables that if i have more than a few-maybe a variable holding the user name 
or something like that which does not change(and even there I use a function 
..UTIL_GetUser(“Name”)..). I have even moved largely away from process 
variables and arguable could move further from them by not using variable names 
on screen objects. Convincing clients to let me change their code and actually 
changing it is not easy-in one case about the changes to the code are on a live 
system running uncompiled and this morning i am going to be attempting to apply 
a knife to this code.


Most code i write now is ‘self contained’ -I attempt to set all values used in 
the method is passed in to the code -either as parameters or an object or a 
pointer to something so that i end up with something more like a javascript 
function. Myreturn:=MyMethod(something;something;something). Using this style 
of coding means i am far more likely to get an error if there is one EVERY TIME 
rather than a head scratching randomly appearing one and my code does not rely 
on the perceived value of a variable.

Consider

If(<>SOmething=1)
//do something
end if

as soon as you have more than process where <>something is set you run the risk 
that at some point process A will set <>something to 1 and before it tests if 
<>something =1 process b changes <>something to 0

Packages-building an installer

[Nigel Greenlee via 4D_Tech]

Hi

I wondered if anyone else has used ‘Packages’ for creating an installer(maybe 
you can suggest a similar product). I am creating a simple installer for an 
in-house application-i will rather give the users a link to an installer than a 
.zip as they have a habit of installing stuff on the desktop.(this is on OSX 
only)

I know this is slightly ‘off topic'

I am however having two problems:-

The first is with permissions. If i zip the .4dbase up and send it to a machine 
the installed app runs fine. However when i create an installer package(with 
user persmissions set to Owner Root and user Admin(i also tried user Wheel) The 
installed application does not have the correct permissions and wants to open 
read only. I wondered if anyone has a suggestion to overcome that.

The second problem I have i with making an icon in the doc. I have written an 
Applescript which runs after the install. and this should make an icon in the 
Doc and relaunch the doc. If i run the Applescript it works fine but when i 
attach it to my installer to run automatically it seems to fail. I wondered if 
anyone might know a reason why the script might fail when it is executed from 
an installer.

(the script could be better)
set the_choice to "Add Application" as string
if the_choice is "false" then error number -128
try
if word 1 of the_choice is "Add" then

set persistent_what to "persistent-apps"
set this_file to "/applications/xx.app" as string<<—here we 
have the app name
do shell script "defaults write com.apple.dock " & 
persistent_what & " -array-add 
'tile-datafile-data_CFURLString"
 & this_file & 
"_CFURLStringType0'"

end if

tell application "Dock"
quit
repeat
try
activate
exit repeat
end try
end repeat
end tell
on error error_message number error_number
if error_number is not -128 then -- not user cancelled
display dialog "Error: " & error_number & return & error_message
end if
end try

Thanks to anyone who can point me in the right direction.



**
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: An efficient printing approach...

[Nigel Greenlee via 4D_Tech]

Robert

I have not looked at your report at all. 

Two things spring to my mind.

1) if the report could be produced in excel could you not use ODBC to extract 
the data from 4D(Not my prerered option  but it it should be feasible)

2) More practically(and something i did recently). Could you not create a 
template in Excel(nice headers and all that bananas). and then inject the data 
into it from 4D(this is not actually complicated especially on OSX as you can 
use LEP)…i recently had something i was converting where the users told me that 
‘it used to make the document into an excel document..i mean on oS9..and nobody 
has done anything to fix it! I wrote some code to put the columns and rows into 
an excel document-i pick up an existing template in which widths etc are 
already set and fill the rows(pretty snappy too). I did not bother about how to 
get say a totals column on the template to automatically be updated because it 
was not in the scope of what i was doing but i believe that should be possible.

For anyone interested here is the (pretty agnostic) code i used-it-i think its 
pretty straigthforward reading.


https://www.dropbox.com/s/6dyd0uk6m2u6mx0/TabDeltoXL.txt?dl=0

If you are on OSX
> On 30 Jun 2017, at 18:54, Robert ListMail via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I was tasked with creating this report in 4D where I chose to use Print 
> Form…. Since it took me an embarrassingly long time to create this and since 
> it could be done from scratch in Excel in 20 minutes… I wanted to hear from 
> the smarter 4D Developers at large.  So, how would you build a report like 
> this in 4D? Also, how much time might you budget or estimate…?
> 
> https://www.dropbox.com/s/c0kgzg9uwed840i/2017_06_27_16_52_46_OCR.pdf?dl=0
> 
> Thanks,
> 
> Robert
> 
> **
> 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
**

Localization from a component...

[Nigel Greenlee via 4D_Tech]

Hi

I wondered if anyone else has experienced a problem with localisation from a 
component.

I have just been testing some code in an uncompiled component and am getting an 
issue with a 4D crash. Its very specific and totally repeatable(I will work 
around the problem-its easy for me to go a different way), I wondered if this 
is a known bug(I will register it after next week)

I have the following in a component ...

$_Txt_CurrentDatabaseLocalizatio:=Get database localization(Current 
localization)<—works fine
$_Txt_DefaultDatabaseLocalizatio:=Get database localization(Default 
localization)<-works fine
$_Txt_InternalDatabaseLocalizati:=Get database localization(Internal 4D 
localization)<-crash


Anyone else seen this? Anyone have a logical reason why that iteration of the 
command should crash.


Nigel Greenlee
**
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: Array Summary Sum Utility Method

[Nigel Greenlee via 4D_Tech]

Sannyassin

Surely here you could be utilizing  2D arrays? 

e.g
Array (aInvoices)-1D
array (aInvoiceItems)-1D
array (ainvoiceValue)-1D

Array (ainvoiceItemNumbers)-2D)-on row per invoice one column per item
array (ainvoiceitemDescription)-2D Ditto
Array(aInvoiceItemQuantitySold)-2D Ditto
Array(aItemSoldAmount-2D

You don’t say if you are displaying these arrays on screen-obviously the 2D 
arrays can’t be displayed on screen.

With the above representation in a listbox on screen the ‘summarisation’ column 
could be a formula based column
eg. Sum(aItemSoldAmount{rownumber}. You can insert the ‘summary’ column in 
dynamically. 

The following brief(unrelated) example shows how to insert a formula based 
column in a listbox

$Formula:=“LB_SUMMARISE(->”+aItemSoldAmount+”)”)
LISTBOX INSERT COLUMN 
FORMULA($area->;$ColumnNumber;$ColumnName;$Formula;$Type;$HeaderName;$ptr3->)

There are a couple of limitations of formula based listbox columns though-cant 
have a footer and cant sort on them.







> On 20 Jun 2017, at 23:25, Sannyasin Siddhanathaswami via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Aloha,
> 
> Does anyone have a utility method for summarizing (and summing) a set of 
> arrays?
> 
> For example with Invoice Line Items:
> 
> Arrays:
> aItemNumbers
> aItemDescription
> aQuantitySold
> aExtendedSoldAmount
> 
> Of course, with invoice line items there are multiple records with item 
> numbers. I want a summary array where there is only 1 element with an item 
> number, and the aQuantitySold, and aExtendedSoldAmount gets summed.
> 
> I know there’s lots of ways to do this, but didn’t want to reinvent the wheel 
> if possible.
> 
> Thanks!
> 
> Sannyasin Siddhanathaswami
> **
> 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: What are some causes of Plugin and Component folder synchronization errors?

[Nigel Greenlee via 4D_Tech]

Kirk..Could be i have heard funny things happen with the new protocol..

I can tell you a funny story though about a load balancer.

 I was working on a project(non-4D related) in which we were setting up users 
mobiles phones. The setup made a connection into the company infrastructer, we 
kept getting stuck with some phones just not getting a connection..lots of 
angst and a big blame fest…threats to throw us out of the building etc…weeks 
in(when nearly finished) they found the load balancer had a IP in its balancing 
list that no longer existed-so when we started setting up 10 phones at a time 
one of them would get directed to that IP and nothing would happen!

Good luck with network…

Nigel Greenlee


> On 15 Jun 2017, at 16:29, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Nigel,
> I've narrowed it down to some issue with the network. There isn't anything
> particularly huge in the plugin or network folders. But watching the actual
> data transfer (that is, watching the graph on Little Snitch) I see that the
> download just stops and then 4D times out and puts up the "Couldn't sync
> Plugins folder" message. Just contacted my guy at the colo asking if they
> installed any load-balancing stuff as first thought. He says no.
> 
> I wonder if this is an artifact of the 4D network protocol?
> 
> On Wed, Jun 14, 2017 at 10:14 PM, Nigel Greenlee via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> A few months back I was testing something out that resulted in my creating
>> large files(>2gb) inside my .4dbase(package). When i logged in from
>> ‘client’ to server i noticed a significant load on folder synching and the
>> synching would then fail.
>> 
>> It is worth checking you have not ended up with something large in your
>> folder that is synching to client.
>> 
> -- 
> Kirk Brooks
> San Francisco, CA
> ===
> 
> *The only thing necessary for the triumph of evil is for good men to do
> nothing.*
> 
> *- Edmund Burke*
> **
> 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...why have i forgotten this.

[Nigel Greenlee via 4D_Tech]

Tim

Thanks. I found the second of those options by accident(when i added a macro V2 
folder to a component)..but its not the way for me to go in this case…what is 
annoying about that actually is that it means i have to removed any macros from 
my component before I install because that macro is getting called instead of 
the macro i have in the host database(and so gets an error because the ‘call 
back’ method it is calling is in the component and not shared with the client). 
That makes using a macro when developing a plug in a bit of a pain because you 
need to remove it before you distribute the component. Anyone else found this?

I think i remember doing it the option 1 way before and will do that again.


Nigel Greenlee

> On 14 Jun 2017, at 15:28, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> On Jun 14, 2017, at 2:47 AM,Nigel Greenlee wrote:
> 
>> I think old age has crept up on me.
>> 
>> I have some macros which I use in my development structure. I want those 
>> macros to work client server(i normally develop on single user). 
>> 
>> The Macros V2 folder is next to the .4db at the same level as plug ins, 
>> components folders etc. In Client server thie Macros V2 folder does not get 
>> copied to the client cache. 
>> 
>> I seem to remember tackling this before but cant find what i did and cant 
>> remember how to get the macros on the ’server’  to auto implement on the 
>> client.
>> 
>> Thanks to anyone who can set me straight
> 
> The "Macros v2” currently lives at “~/Library/Application Support/4D/Macros 
> v2/“ on macOS. It is not automatically distributed to 4D Clients when running 
> 4D Server. If you want this you have 2 options:
> 
> 1. Put a copy of “Macros v2” in your “Resources” folder. That will get it 
> automatically to your 4D Client “Resources” folder. Then write some code to 
> move it to it’s final home at “~/Library/Application Support/4D/Macros v2/“ .
> 
> 2. Put “Macros v2” folder in a component next to the .4DB or .4DC file. The 
> macro .xml will then be automatically distributed to 4D Client AND 4D will 
> integrate the macros with the other macros already on the 4D Client machine. 
> This allows you to include some macros with a component and 4D will recognize 
> them. It’s a feature most do not know about. I know it works because I’ve 
> used it in 2 of my own components.
> 
> 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
> **

**
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: What are some causes of Plugin and Component folder synchronization errors?

[Nigel Greenlee via 4D_Tech]

Kirk

I don’t know if the following information has any relevance to you issue.  A 
few months back I was testing something out that resulted in my creating large 
files(>2gb) inside my .4dbase(package). When i logged in from ‘client’ to 
server i noticed a significant load on folder synching and the synching would 
then fail. 

It is worth checking you have not ended up with something large in your folder 
that is synching to client.

Nigel Greenlee




> On 14 Jun 2017, at 21:26, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi folks,
> 
> A couple of users are suddenly getting these errors attempting to login to
> our server over WAN. One had recently upgraded his OS to Sierra and I
> thought it might be something to do with that. I deleted all his old 4D
> folders, reinstalled the db and still got a plugin sync error. I'm using
> Sierra 12.6 so it's a mystery to me why his machine barfs and I don't.
> 
> Then another user, at the same location, noticed a computer there was
> throwing the component sync error.
> 
> I've typically seen this sort of thing involve network lag issues but there
> are other users on that same network apparently having no issues.
> 
> Any thoughts?
> 
> Thanks
> 
> -- 
> Kirk Brooks
> San Francisco, CA
> ===
> 
> *The only thing necessary for the triumph of evil is for good men to do
> nothing.*
> 
> *- Edmund Burke*
> **
> 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 and Sage

[Nigel Greenlee via 4D_Tech]

Pat

I have code for this:..it uses the ODBC plug in but should be converted to just 
use SQL i think.



Nigel
> On 13 Jun 2017, at 12:17, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> We've had a few enquiries from customers and prospects about interfacing
> with Sage and I'd like to get an idea of how much work would be involved in
> setting this up.
> Basically we need to:
> - Extract data into our 4D database
> - Push data from 4D to Sage
> 
> Standard stuff I guess :)
> 
> We'll be using 4D v16.
> 
> I'm guessing this could be done via ODBC.
> 
> ​What tools would be required? EG:
> - 4D ODBC Pro?
> - ​Sage developer account?
> 
> I'd be interested to receive quotes form 4D developers who have done this
> on setting it up for us.
> 
> Pat Bensky
> 
> -- 
> *
> 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
> **

**
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...why have i forgotten this.

[Nigel Greenlee via 4D_Tech]

Hi.

I think old age has crept up on me.

I have some macros which I use in my development structure. I want those macros 
to work client server(i normally develop on single user). 

 The Macros V2 folder is next to the .4db at the same level as plug ins, 
components folders etc. In Client server thie Macros V2 folder does not get 
copied to the client cache. 

I seem to remember tackling this before but cant find what i did and cant 
remember how to get the macros on the ’server’  to auto implement on the client.


Thanks to anyone who can set me straight




Nigel Greenlee
**
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: v16 Component Compiler error

[Nigel Greenlee via 4D_Tech]

Kirk

Probably unlrelated..but i am getting an error from 4D pop in V16-i used the 
application maker and when it build the application i then get and error..so it 
seems someone at 4D needs to pop in to the pop plugs and fix some things.

> On 4 Jun 2017, at 05:00, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> Bob,
> I'm betting that one of the components has the offending culprit in it -
> either a variable name or method name. And the method may be invisible
> which makes it even more challenging to identify.
> 
> On Sat, Jun 3, 2017 at 8:41 PM, Bob Finnerty via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> Well, yes
>> 
>> But I may have stumbled on the answer: It seems to be related in some way
>> to 4DPop - when I remove these components, the error disappears..
>> 
>> Not sure why, exactly
>> 
> 
> -- 
> Kirk Brooks
> San Francisco, CA
> ===
> 
> *The only thing necessary for the triumph of evil is for good men to do
> nothing.*
> 
> *- Edmund Burke*
> **
> 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: V16 on OSX Application licence

[Nigel Greenlee via 4D_Tech]

Ok. So today i tried (and i checked on the Apple site) to right click to allow 
the application-no joy. In OSX system preferences the ‘allow applications from 
unidentified developers’ does not exist any more. SO do that mean i have to 
build with XML keys to make it work?..i am going to test that out shortly.



Nigel Greenlee
 
> On 19 May 2017, at 20:12, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> If that is so easy, why does 4D itself not do this
> 
> 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 May 19, 2017, at 12:31 PM, Timothy Penner via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> Hi Nigel,
>> 
>> If "the application can't be opened" because of the unidentified developer, 
>> you can usually bypass this by right-clicking on the application and 
>> choosing "Open" or by moving the application to the root of the 
>> /Applications/ folder (i.e. /Applications/YourApp.app).
>> 
>> However the best way to work with this behavior is to become an identified 
>> developer by signing your application. To do this you must first join the 
>> Apple Developer Program to obtain a application signing certificate, and 
>> then sign your application. And preferably distribute your application via a 
>> Signed DMG. See here: http://kb.4d.com/assetid=77688 
>> 
>> 
>> -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
> **

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

V16 on OSX Application licence

[Nigel Greenlee via 4D_Tech]

Hi

I am building a small application for internal deployment in a company. I am 
trying to deploy using the unlimited desktop(partner programme).


 However when i try to launch that application on OSX it will not launch- just 
a message

“The application …can’t be opened"

After a bit of head scratching(have i included the licence etc) I now think the 
OS is blocking the application because it is not from an ‘identified develop’. 

How do i set the developer to an identified one?

Or does anyone know if maybe my problem is something else



Nigel Greenlee


**
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: Is it possible to do a search in the file system from 4D

[Nigel Greenlee via 4D_Tech]

Hi

On OSX this is easy to do-something like this should work

$_t_DocumentPath:=<—known name  //if a partialthe image path is know
$_txt_OSASCRIPT:="mdfind "+Char(34)+$_t_DocumentPath+Char(34)
$_t_InputStream:=""
$_t_OutputStream:=""
LAUNCH EXTERNAL PROCESS($_txt_OSASCRIPT;$_t_InputStream;$_t_OutputStream)




> On 16 May 2017, at 07:59, John Baughman via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I am thinking that perhaps using Launch External Process there might be a way 
> to search for a file and get back the path to the file if found.
> 
> I have a method that recursively crawls through a volume or folder to locate 
> a file, but it is relatively slow. It is pasted below. Any ideas to make this 
> more efficient or know how to use LEP to do a file search. Needs to work on 
> both Mac and Windows.
> 
> Thanks,
> 
> John
> 
> //Method: SearchFolderContents_Jut
> C_TEXT($1;$folderPath;$2;$documentToFind;$0;$pathToDocumentFound)
> $folderPath:=$1
> $documentToFind:=$2
> $pathToDocumentFound:=""
> 
> DOCUMENT LIST($folderPath;$aDocuments)
> $found:=Count in array($aDocuments;$documentToFind)
> 
> If ($found>0)
>  $pathToDocumentFound:=$folderPath+$documentToFind
>   
> End if 
> 
> If ($pathToDocumentFound="")
>FOLDER LIST($folderPath;$aFolders)
>   
>For ($i;1;Size of array($aFolders))
>$pathToDocumentFound:=SearchFolderContents_Jut 
> ($folderPath+$aFolders{$i}+Folder separator;$documentToFind)
>If ($pathToDocumentFound#"")
>$i:=Size of array($aFolders)+10
>   
>End if 
>   
> End for 
>   
> End if 
> 
> $0:=$pathToDocumentFound
> **
> 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: Hex Colour Picker in Listbox

[Nigel Greenlee via 4D_Tech]

Sorry meant to put a link on that

https://www.dropbox.com/s/oxt7nh2q6w078iw/ComplimentaryColours?dl=0


> On 11 May 2017, at 09:47, Douglas Cryer via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hello all,
> 
> I have a list of colours in my system and I have a corresponding hex colour 
> code field but nobody has really used it.  I want to do a few things:
> Automatically map common colours to hex colours (via a lookup
> Provide a hex colour picker that I can use in a listbox
> Use the returned/edited hex colour to do one of the following:
> Set the text colour to the chosen hex value
> Set the row or cell colour to the chosen hex value
> Is there an example of this anywhere?
> 
> Regards,  Dougie
> 
> 
> telekinetix Limited- J. Douglas Cryer
> Phone : 01234 761759  Mobile : 07973 675 218
> 2nd Floor Broadway House, 4-6 The Broadway, Bedford MK40 2TE
> Email : jdcr...@telekinetix.com   Web : 
> http://www.telekinetix.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
**

Re: Hex Colour Picker in Listbox

[Nigel Greenlee via 4D_Tech]

Doug

This may be of no use at all to you ..on the other hand..

Some while back i picked up a document off the web of complimentary colours I 
translated it into 4D Code. This helps if you are doing any kind of row 
shading, it just builds an array of RGB references and their colour names and 
has the rgb of one step two step and 3 step lighter. I was using it in an SVG 
charting mechanism.





> On 11 May 2017, at 09:47, Douglas Cryer via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hello all,
> 
> I have a list of colours in my system and I have a corresponding hex colour 
> code field but nobody has really used it.  I want to do a few things:
> Automatically map common colours to hex colours (via a lookup
> Provide a hex colour picker that I can use in a listbox
> Use the returned/edited hex colour to do one of the following:
> Set the text colour to the chosen hex value
> Set the row or cell colour to the chosen hex value
> Is there an example of this anywhere?
> 
> Regards,  Dougie
> 
> 
> telekinetix Limited- J. Douglas Cryer
> Phone : 01234 761759  Mobile : 07973 675 218
> 2nd Floor Broadway House, 4-6 The Broadway, Bedford MK40 2TE
> Email : jdcr...@telekinetix.com   Web : 
> http://www.telekinetix.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
**

Re: 4D_Pack Replacement commands in v16

[Nigel Greenlee via 4D_Tech]

> On 10 May 2017, at 11:29, Jörg Knebel via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi,
> 
> Would someone please care to mention where one can find the replacement for 
> commands from the Pack like:
> 
> 
> _o_AP Get table info  
> 
> 
> 
> And where the hell are the PDF-Manuals for v16?
> **
> 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
> **

AP Get table info (table; invisible; destruct) 


GET TABLE PROPERTIES(Table;Invisible) but if you want to know the other 
attributes… seems you can’t have that information now. maybe seems odd(of 
course the depracted command still works for now)


Nigel Greenlee

 
**
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: Diff 4D Write Documents

[Nigel Greenlee via 4D_Tech]

Kirk

Just to throw a  curved ball to the mix…

 I use in  a different context some DIFF code in 4D-I did not write it. 

I have tried using the DIFF command (On osx) and for my purposes the DiFF code 
i have which produces arrays of differences and is more preferable for me. 

This is however being used as part of my own code control code so the 
parameters of what you want from the code may be very different. It picks up a 
document(or 2) and compares them.

 I put the code into a component because it can only run compiled-it was 
painfully slow uncompiled (and in my case i am using it in development so my 
code is not compiled).

Calling DIFF via LEP(not sure how this would be called on WIndows) is like 
this(with my notes). The problem with this is you have to write code to 
‘humanise’ the results-i started to write something for my purposes but have 
not progressed to completion.

C_TEXT($_t_NewDocumentPath;$_t_OldDocumentPath;$_txt_OSASCRIPT;$_t_InputStream;$_t_OutputStream)
C_TEXT($1;$2)
$_t_NewDocumentPath:=Convert path system to POSIX($1)//$1 is the new document 
path
$_t_OldDocumentPath:=Convert path system to POSIX($2)//$2 is the old document 
path
$_txt_OSASCRIPT:="DIFF -iwc "+Char(34)+$_t_OldDocumentPath+Char(34)+" 
"+Char(34)+$_t_NewDocumentPath+Char(34)
$_t_InputStream:=""
$_t_OutputStream:=""
LAUNCH EXTERNAL PROCESS($_txt_OSASCRIPT;$_t_InputStream;$_t_OutputStream)
  //(Information)
  //***from(Old)file with modification time(note the***)
  //---to(new)file with modfication time(note the---)
  //line of stars(longer than this)-seperator
  //***1***this means the old file from range
  ///this will always be at least one line it gives a context the line content 
is here(this can be multiple lines
  //the context lines start with two spaces
  //the differing lines start with a char
  //! (space) means a line this part of a group of one or more lines that 
changed between the fwo files-there will be a block of lines in the to file to 
correspond
  //+ an inserted file in the (new)?? that corresponds to nothing in the (old) 
file
  //- a  deleted line in the  old file that corresponds to nothing in the new 
file


Happily provide you with source code for the 4D DIFF -I found it on one of the 
4d code sharing sites-written by David Dancy.

I have put the code into a structure. 

https://www.dropbox.com/sh/64mcnxej3nh2h2p/AAD-wgNga2x2P75rdRyast0Fa?dl=0

I too use BBedit(best text editor ever in my opinion) on the mac-never been 
able to(had the time to) work out how to call it via an OSA(Applescript) and 
get the compare results text back.

> On 25 Apr 2017, at 23:50, Douglas von Roeder via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Kirk:
> 
> My current thinking is to store the entire document but a PDF is harder to
> futz with and it *would* save a bit of disk space. I'm leaning toward just
> setting up a folder for each quote and dropping a changed document in it.
> Disk space is copious and free and I don't need "chain of custody" type
> practices. The issue that my client is dealing with is that some of the
> sales reps have futzed with some of the quote documents. By adding this
> feature the sales reps will know that their 4D Write documents will be
> tracked by the audit trail and that should cut out almost all of the few
> instances of mischief.
> 
> DeltaWalker might do the trick. I've been using it on the Mac for a couple
> of years and it works fine but it is a little slow. It its favor, the
> Windows version operates via the command line. Word has a compare feature,
> though I've never programmed Word to run from the command line, and then
> there's this online service , too.
> 
> I like the idea of using diffchecker.com but who knows how long it will be
> available.
> 
> Next step is to contact the client and ask them how automagic the diff
> function needs to be.
> 
> Thanks for your suggestions.
> 
> --
> Douglas von Roeder
> 949-336-2902
> 
> On Tue, Apr 25, 2017 at 3:20 PM, Kirk Brooks via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> Doug,
>> On Tue, Apr 25, 2017 at 1:32 PM, Douglas von Roeder via 4D_Tech <
>> 4d_tech@lists.4d.com> wrote:
>> 
>>> In addition to the hash, my thinking is to store changed documents as
>>> versions of the original ("reference") document instead overwriting the
>>> original.
>>> 
>> 
>> ​If the formatting isn't important (headers, footers, page numbers) I'd
>> just save the body text without formatting. Save them into a related table
>> of 'versions' with the hash and date and stuff. If they want the formatting
>> and the whole smash I'd save them as a PDF. ​The point is you want to
>> prevent changing that archive copy.
>> 
>> 
>>> Next step is to find an app that will do a diff that I can display for
>> the
>>> ​ ​
>>> end user.
>>> 
>> ​I found an app called Deltawalker that's pretty good. ​
>> 
>> 
>> --
>> Kirk Brooks
>> San Francisco, CA
>> ===
>> 
>> *The only thing necessary for the tri

Re: Dynamic Method Creation & Content Changing

[Nigel Greenlee via 4D_Tech]

John

You should not really have much trouble with 4D SET METHOD..I Use it all the 
time(in development not in a live enviroment)

METHOD SET CODE($_t_methodName;$_t_MethodText)

just need to make sure method is not open in the design enviroment or you will 
get an error


Nigel
> On 22 Apr 2017, at 17:01, truegold via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> Hi Nigel,
> 
> I’m not sure if it would be easier to use foot runner. I do know that the 
> strategy I worked through works pretty well. Here’s the almost final result 
> (needs to be tested further)...
> 
> The send user has a UI and supplies two pieces of data: a study name 
> (actually an abbreviation or acronym) and a position in a string (1-80 
> positions) where the position will have a single character code. These become 
> part of the names of the list, list items, and methods.
> 
> With those two pieces of data I am able to auto-generate several new 4D 
> lists, insert into existing 4D list, create two new methods with code 
> formatted correctly, and…
> 
> I couldn’t figure out how to get the Method Set Code command working so I 
> used Rob’s API Create Method to create the new 4D methods. Works great!!!
> 
> I could not get API Set Method to work. In fact it always crashes in 4D v15r2 
> (Mac). So, at this time, I’ll have to 
> 
> I opted for just auto-generating the code fragments (new case dispatches with 
> a couple lines of code) and displaying them in three text variables. Each 
> text variable corresponds to the method that needs to be updated. I also auto 
> open the three methods so they don’t have to search for them. BTW, the user 
> currently has access to design and makes minor tweaks from time to time. This 
> won’t work in compiled but they’ve never run in compiled in over 25 years.
> 
> Then, for each text var, they can select all and copy the code fragment and 
> place it into the proper routine. All they need to do is go to the bottom of 
> the case dispatch and add these lines there. About as simple as it gets - and 
> yes they could still mess up.
> 
> If I could get Rob’s API Set Method to not crash (or understand how 4D’s 
> Method commands work) I might be able to fully automate it. But until...
> 
> Anyway what used to be a nightmare of steps and rereading of the cryptic docs 
> (and fraught with error) has been reduced to a minute or two exercise.
> 
> Exactly what I was after.
> 
> Finally, creating an new study is an infrequent exercise. So they might not 
> revisit this for another year or more. But when they do it’s now a simple 
> thing.
> 
> Appreciate,
> John...
> 
>> Its always an issue when you probably wish it was a different way but it has 
>> been written and now you have to deal with it..no budget for a proper 
>> redo..no will for it either!.
>> 
>> I would certainly consider though using Footrunner for code you you write(I 
>> don’t use footrunner as i have my own solution internal to my code)..i 
>> assume you can automatically create the footrunner document and that 
>> probably easier to ‘patch’ sections of code and sub-calls into than putting 
>> into 4D itself..and you could be running a compiled solution then.
> 
> **
> 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: Dynamic Method Creation & Content Changing

[Nigel Greenlee via 4D_Tech]

John

Its always an issue when you probably wish it was a different way but it has 
been written and now you have to deal with it..no budget for a proper redo..no 
will for it either!.

 I would certainly consider though using Footrunner for code you you write(I 
don’t use footrunner as i have my own solution internal to my code)..i assume 
you can automatically create the footrunner document and that probably easier 
to ‘patch’ sections of code and sub-calls into than putting into 4D itself..and 
you could be running a compiled solution then.


Nigel

> On 21 Apr 2017, at 16:24, truegold via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> Hi Nigel,
> 
> First I know the issue of using 4D List as a short cut for using a real 
> lookup of records in a table, aka choice list, for example. I have a client 
> who has an app (I have inherited this one as well) where there are hundreds 
> of these and they are having the kinds of problems you mentioned.  I am 
> slowly replacing them with table based choice list lookups.
> 
> But after reading your thoughts I realize that in this case I am not really 
> doing anything dynamically EXCEPT when things need to be setup for a new 
> study. And in this case without rewriting the application it must be handled 
> the way I have described. So keep in mind that I have not been tasked to 
> rewrite the App but only help them make this aspect of it easier.
> 
> SO the dynamic is really a one time thing. What I am really trying do is 
> automate it and reduce the chances for error and not have to go through 
> obscure notes to figure it out.
> 
> There are several NEW 4D lists that must be created each time they create a 
> new study. Then these list need to referenced and part of the mechanism is by 
> adding the names of these list to another meta list. That’s where the insert 
> list items comes in.
> 
> Then there are two new methods created each time that use these NEW list. An 
> the list names and number are the only thing that changes inside of this 
> wrapper method that calls another method with these list names as parameters.
> 
> Outside of header and some variable declarations there is a single line of 
> code which is the method and parameter list. Not much to validate here.
> 
> As to writing code inside another method that’s trickier. I might just open 
> the methods and present the code lines for them to copy them in.
> 
> It’s not as bad as you think (or else I am a bit delusional! Sometimes it’s 
> hard to tell. ) and on the surface it seems quite easy.
> 
> I’ll be explaining it to the client today and see what they think. If they 
> say go for it then I’ll give it a try and see if I can get most of it 
> automated.
> 
> I hope that explains it better. Always hard to explain when you’re trying not 
> to be verbose.
> 
> Appreciate,
> John...
> 
>> 4D lists can suck if they are being edited..I remember having trouble with a 
>> system a while back where users complained that some drop downs did not have 
>> something in that should have been there..testing showed that we had code 
>> nicely adding to the 4D list that was being used in the drop down..lots of 
>> head scratching..probably a blame fest..then we worked out what was going 
>> to..the list we being written to by other clients overwriting the list. and 
>> the user had a list different to what they expected.
>> 
>> In General I avoid using a 4D list for anything dynamic…a table with  
>> something like…
>> OWNER(User)<-create one ‘system’ owned list for each list name and where no 
>> user specific version use the system version…(Duplicate records or combine 
>> system owned with private owned)
>> LIST_NAME
>> LIST_ITEM_NAME
>> NAME_ABBREV
>> STUDY_REF 
>> ..(and a record ID)
>> Would be probably be a better way to handle a dynamic list and easier to 
>> then relate something like study steps ..step items…step item options..etc
>> 
>> In my humble you should never need to have code edit itself for this kind of 
>> purpose. The code should support and be supported by the data and switches 
>> in the data should define the route through the code…that will always be 
>> more robust and easier to write than code that writes code. 
>> 
>> Code that writes code is hard to validate:)..i know this ..lets say in your 
>> code you have a line $_t_InsertStatement:=“IF(<>MyBadlyNamedVariable)” 1stly 
>> you have to be sure that variable exists. and then if someone decides 
>> somewhere to change the name of the variable it wont automatically change in 
>> your hardcoded insert line and somewhere you will be getting calls about an 
>> error..even worse is when 4D changes the name of the a function call or the 
>> parameters.
>> 
>> Just my tuppence worth.
> 
> **
> 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: 

Re: Dynamic Method Creation & Content Changing

[Nigel Greenlee via 4D_Tech]

John



4D lists can suck if they are being edited..I remember having trouble with a 
system a while back where users complained that some drop downs did not have 
something in that should have been there..testing showed that we had code 
nicely adding to the 4D list that was being used in the drop down..lots of head 
scratching..probably a blame fest..then we worked out what was going to..the 
list we being written to by other clients overwriting the list. and the user 
had a list different to what they expected.

In General I avoid using a 4D list for anything dynamic…a table with  something 
like…
OWNER(User)<-create one ‘system’ owned list for each list name and where no 
user specific version use the system version…(Duplicate records or combine 
system owned with private owned)
LIST_NAME
LIST_ITEM_NAME
NAME_ABBREV
STUDY_REF 
..(and a record ID)
Would be probably be a better way to handle a dynamic list and easier to then 
relate something like study steps ..step items…step item options..etc

In my humble you should never need to have code edit itself for this kind of 
purpose. The code should support and be supported by the data and switches in 
the data should define the route through the code…that will always be more 
robust and easier to write than code that writes code. 

Code that writes code is hard to validate:)..i know this ..lets say in your 
code you have a line $_t_InsertStatement:=“IF(<>MyBadlyNamedVariable)” 1stly 
you have to be sure that variable exists. and then if someone decides somewhere 
to change the name of the variable it wont automatically change in your 
hardcoded insert line and somewhere you will be getting calls about an 
error..even worse is when 4D changes the name of the a function call or the 
parameters.

Just my tuppence worth.


> On 21 Apr 2017, at 00:42, truegold via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> Hi David,
> 
> First this is an App I took over and am maintaining. The client brought this 
> to my attention because after working in the app since the late 80’s it’s 
> still not clear and easy to remember all the steps (even with documentation) 
> it takes to get things to the point of usability.
> 
> As I look at it I see several 4D list that need to be created. I see list 
> items that need to be inserted into existing 4D list. I see several methods 
> that have to be created (using generic routines where all that changes are 
> the parameters names), and several methods that have to have code inserted 
> into case statements.
> 
> So most of seems to me can be automated. Probably need a UI of some sort to 
> add the name, abbreviation, and study number. (Then I can generate most 
> things on the fly and view ten in the UI before it’s committed.)
> 
> All of this is for setting things up so that another routine will be run that 
> reprocesses all this information crafting necessary records that are used 
> based upon all these new constructs. And then, finally, the study can begin 
> and data captured.
> 
> BTW, I’m intentionally trying not to explain everything as it’s a long and 
> winding road…
> 
> Brittle? I suppose. But if automated less chance for error I think. Less need 
> to reread and restudy somewhat unintuitive notes (yes I could rewrite them so 
> they are clearer).
> 
> Anyway, my main concern was with dynamic method creation and inserting lines 
> of code into existing methods. If it can be done then it’s something I might 
> pursue - if the client thinks it might be worth it.
> 
> Otherwise I’ll trudge through the notes and create the structure manually.
> 
> Kind of a proof in concept is what I’m after.
> 
> Thanks for your thoughts,
> John…
> 
> 
>> A method is just a block of text. The magic in the method comes from 4D's
>> interpreter. I modify methods via code and also do lots of code generation
>> for my standard housekeeping sort of code. You can get and set the text
>> however you like.
>> 
>> With that said, I don't see why you would do it in this case. It sounds
>> like you've got some user configurable data that you need to do lookups on
>> or otherwise manipulate. (Or are they a sort of decision-tree or driving a
>> logic cascade?) Right now you're keeping it in a 4D list and are proposing
>> to bake it into code. I think that the problem is that you're using lists
>> for data that should be in the data file. Before baking the data into code,
>> try and answer the question "how would I do this using the data file?" The
>> data file is a great place to keep user-specific config data and such. If
>> not there, then in a disk file. Putting the data into the data file makes
>> is easier to see, reuse, validate, etc.
>> 
>> Speaking of validation, it sounds like the setup is a bit brittle and easy
>> to mess up. Another solid argument for the data file. You need a UI for the
>> configuration entry which creates the configuration data. Then you can have
>> a *different* piece of code that interprets and validates the configuration

Re: Methods, Components, Comments, and Tooltips

[Nigel Greenlee via 4D_Tech]

Tom

I handle forms in my version control. I use a method to get all form objects 
into an object-its an object of my own format…here is a sample below. Pretty 
extensive. I have code to pack and unpack the form objects so i can compare 
current version of a form with the last one (not using diff) to tell me in 
plain english what is changed. The object is put into t blob and written out to 
a version control document

the object is build using a call like this...

CORE_T_ParseFormName:=$_aT_FormNames{$_L_Index}
FORM LOAD($_aT_FormNames{$_L_Index})
C_OBJECT($CORE_ob_FormObject)
CLEAR VARIABLE($CORE_ob_FormObject)
CORE_GetFormObjects ($_aT_FormNames{$_L_Index};0;->$CORE_ob_FormObject)

I have put a copy of CORE_GetFormObjects on my 
dropbox..https://www.dropbox.com/s/banb0mpgllkj8na/CORE_GetFormObjects.txt?dl=0 
its fairly self explanatory if a little wordy..its shockingly fast i mean 
really uncompiled ‘boom' all them form objects parsed into an object faster 
than a fast thing.

If I was modifying it i would not have the constants hard coded as i now have 
code I got from the forum for reading the names of all 4D constants.


Three caveats….

1) if you try to get the menu bar of the form i think you just get the current 
menu bar(i build my menus on the fly anyway so this is not an issue for 
me)..but it can lead to you being told the menu bar has changed!
2) If you use inherited forms when you parse a form you get the inherited form 
objects and you can have an object named the same on the inherited form as on 
the inheriting form(!) and when you get the form objects they don't always come 
in the same order, this can lead to an object x on the inherited form being 
found in the array of objects before the object on the inheriting form on pass 
and then next time after-which can lead to you reporting that the object type 
has changed-i just make sure my object names on inherited forms are unique!
3)There are a couple of properties you can't get-they are as follows:-
//the following form setting cannot be obtained in code
//Markers
//access
//menu bar
//print settings
//appearance
//form type
//inherited form table
//inherited form name
//save geometry
(This is on V14 maybe on 15/16 you can get these)


this(without much comment) is the code i use to report the differences between 
two form objects(current and previous) 
https://www.dropbox.com/s/9u16tzd9db6689i/Diff_CompareForms.txt?dl=0



{"Form Name":"CODE_CHANGES","Number of Pages":2,"Fixed Width":false,"Fixed 
Height":false,"Form Title":"","Form Menu":"","Active Form Events":["On 
Load","On Validate","On Clicked","On outside Call","On Double CLicked","On 
drop","On menu selected","on Plug in area","on data change","On drag over","On 
timer","On after keystroke","on after edit","On begin drag over","On bound 
variable change","On mac toolbar button","On page change"],"Form 
Objects":[{"Page Number":1,"Name":"oCODLBChangesVIewer","Variable 
Name":"CODE_abo_MethodChanges","Type":7,"Type Name":"Object type 
listbox","Multiline option":0,"Multiline option Name":"Multiline Auto","Style 
Sheet":"__automatic__","Font Name":".SF NS Text","Font Size":12,"Font 
Style":0,"Font Style Name":"Plain","Is visible?":true,"Foreground 
Colour":"Foreground Color","Background Colour":"Foreground Color","Alternate 
Background Colour":"Foreground Color","Left Position":144,"Top 
Position":55,"Right Position":495,"Bottom Position":604,"Horizontal 
Resize":0,"Horizontal Resize Name":"Resize horizontal None","Vertical 
Resize":0,"Vertical Resize Name":"Resize Vertical None","Horizontal 
Alignment":1,"Horizontal Alignment Name":"Align …lots more here-cutting this as 
its a long bit of text


I have recently added a ‘watcher’ process which looks for all forms modified 
since the last time it looked(it looks every few mins) and if a form is 
modified runs code to compare it and save a new version of the object out. 
Happy to hear from anyone with comment/critique on this code.


> On 20 Apr 2017, at 14:04, Benedict, Tom via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Lutz writes:
> 
>> we use a modified version of the mentioned vc-framework component. It saves 
>> all changes in the code to text files
>> immediately and keeps track of the timestamps of the changes in an external 
>> database. The text files can be
>> committed to a source code versioning tool like svn, mercurial, git ...
> 
>> We extended it a bit to allow reimporting of the exported code. So we are 
>> able to switch between branches and
>> we can do team development without a development server and dev clients. All 
>> members of our team use single user >instances of 4D. The result of the 
>> development will be compiled into a built/merged server application.
>> A very old version (V13 yet) with import code can be found on Github: 
>> https://github.com/elutz/vc-framework-v13
> 
> Do your apps use 4D forms? If so, how do you deal with them with respect to 
> version control?
> 
> Thanks,
> 
> Tom Benedict

Re: Methods, Components, Comments, and Tooltips

[Nigel Greenlee via 4D_Tech]

Ok..taking this off list..will email you.

> On 20 Apr 2017, at 12:46, Epperlein, Lutz (agendo) via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Hi Nigel,
> 
> basically I'm interested, we are following a similar approach. I should 
> explain it a bit.
> 
> At first we use a modified version of the mentioned vc-framework component. 
> It saves all changes in the code to text files immediately and keeps track of 
> the timestamps of the changes in an external database. The text files can be 
> committed to a source code versioning tool like svn, mercurial, git ...
> This is the basic idea behind the vc-framework. 
> 
> We extended it a bit to allow reimporting of the exported code. So we are 
> able to switch between branches and we can do team development without a 
> development server and dev clients. All members of our team use single user 
> instances of 4D. The result of the development will be compiled into a 
> built/merged server application. 
> A very old version (V13 yet) with import code can be found on Github: 
> https://github.com/elutz/vc-framework-v13
> 
> But there are some disadvantages of this approach, all based on the 
> limitations of 4D's way to handle the code. 
> At first, the comparison of the exported and the present code in the database 
> is based only on timestamps, that is a bit fragile. Most of the time it 
> works, but if problems are happening the solution is sometimes difficult and 
> a bit time consuming (re-export and re-import of thousands of methods). 
> Another problem is the reliability of the component since 4D V15. Very often 
> the immediate export of the code doesn't work and you have to trigger it 
> manually. If the developer forget this additional step, he will check in only 
> a part of his new code.
> Because of that we don't recommend to take it 1:1 regardless we are using it 
> a quite long time. 
> As a task we have to invest time to improve and adapt the component to make 
> it more reliable again.
> 
> I hope, there were some interesting thoughts ...
> 
> Regards
> Lutz
> 
> **
> 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: Methods, Components, Comments, and Tooltips

[Nigel Greenlee via 4D_Tech]

Luiz

I have a nice set of code that exports the code, including the forms(as 
objects),and all the database settings including table structure,  and 
maintains a history(in an external database) of everything using a modified 
DIFF . I would be happy to give you a copy of my component(including source) 
for doing this(i would need to change it a a bit  to work for you as it does a 
couple of other things-sets a header on the methods (and you might want that 
but you might want it different), and declares all my variables(you would not 
want that as I doubt it will comply with your naming convention). The code is 
set up for single user usage-so if you do client server development i would 
need to rethink some stuff on there-which i need to do anyway.


There are other people around with similar tools.

> On 20 Apr 2017, at 11:16, Epperlein, Lutz (agendo) via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
>> 1 - how does one get access to the 4D source code outside of 4D?  Is there a 
>> magic
>> command to get 4D to regurgitate its code into plain text?
> 
> METHOD GET CODE
> Since V13
> Than you can do what you want with the text. An example is the VC-Framework 
> component by J. Fletcher: https://github.com/4D/vc-framework-v13
> 
> 
> Regards Lutz
> 
> **
> 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: v13 and OS X 10.12

[Nigel Greenlee via 4D_Tech]

Chip

Maybe this article will be of some relevance and assistance

http://osxdaily.com/2017/04/11/run-macos-virtual-machine-easy-parallels/


> On 13 Apr 2017, at 17:15, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I am slowly leap frogging versions of OS X and 4D.
> Moving from 4D v2003 and v12 to v13, and OSX 10.6.8 to 10.9.?
> 
> The next step will be to move to v14, 15, or 16 of 4D before moving to 
> 10.0(?), .11(?), .12(?).
> 
> However in the mean time, we need to replace a Mac computer, and a new 
> Mac will have 10.12 on it, no choice. If it matters it will likely be a 
> mini, although an iMac is also possible.
> 
> I understand the compatibility matrix, and v13 was released and dead 
> before OS X 10.12
> 
> What I need is some information on real world functionality of v13 on 
> 10.12.
> At the moment I have no components, and no plugins other then come with 
> 4D (i.e. 4D pop, SVG etc), and most of these could be removed.  
> 
> I will be looking at Keisuke's iCal plugin/component (I have not had 
> time to even determine which one it is).
> 
> Any feed back is helpful -- 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: 4D Compiler

[Nigel Greenlee via 4D_Tech]

Heinz, Timothy.

I completely agree. A strict nomenclature with typing is essential.

 In fact its the only way i too have been able to implement auto declaration in 
my code-not just locals-i was inspired by your comment about doing it for 
locals on here a while back to go back and complete work i had done on code 
previously-of course its harder pulling out variables than locals or 
interprocess-so it was a hell of a job to do (Trust me its a thing of beauty 
but there were about 50 attempts of running this across including a few bad 
failures with my code before i weeded out all the gotchas)..i might now go back 
and provide a way of allowing definition of the nomenclature so it could be 
used with other conventions(I use a convention where the type is after a 
’group' and before the name(xxx_type_name) and i know a lot people use 
Name_type and i define screen variables such as buttons (but) or radio  buttons 
as rb rather than all longints as (l) and a couple of other other usages for 
listboxes, drop downs etc

Here however I have taken over pre-existing work where beyond having adopted S 
for strings at some point there is nothing currently in place. Yes I would love 
to make sure the 69,000 guessing points are sorted-but it will take time. There 
are other pressing challenges such as no usage to speak of of style sheets and 
a variety of form implementation ranging.

So give me time and we will see how i progress.




> On 7 Apr 2017, at 17:35, Herr Alexander Heintz via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> This is where strict variable nomenclature with typing info helps a lot.
> You can easily create a method that can gather all locals in a piece of code, 
> and add the declarations at the top of a method.
> You can even apply that automatically using METHOD GET CODE and METHOD SET 
> CODE.
> OTOH if you have no variable nomenclature with typing…
> 69000 typing errors.
> Forget it, seriously...
> 
>> Am 07.04.2017 um 18:29 schrieb Timothy Penner via 4D_Tech 
>> <4d_tech@lists.4d.com>:
>> 
>> Nigel,
>> 
>>> I tried David Adams suggestion of trying ‘all vars are declared’ and at 
>>> 69000 errors decided that was not the way to go!
>> 
>> You really should try to fix those...That is 69,000 places that 4D is 
>> guessing what the variable type should be - instead of you explicitly 
>> telling 4D what the variable type should be. All you need to do is use 
>> C_TEXT or C_LONGINT or C_* at the top of your methods to declare what the 
>> variables are. This is the best practice after all.
>> 
>> Just my 2 cents.
>> 
>> -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
>> **
> 
> **
> 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 Compiler

[Nigel Greenlee via 4D_Tech]

Douglas.

Yes that is kind of what i thought and can remember the old days  so would kind 
of expect it to have failed after one of those passes and-when you have fixed 
of type x get more but that really was not what i saw-i had syntax errors( to 
many” }"or “)” etc) and variables re-declared differently etc but and i had 
only cleared about half of them when it suddenly found all the 
$Something:=confirm(“something”;”Yes”;”No”)..lots of them and if else else etc. 

I did notice though that when I cleared ‘general’ errors(Which oddly where not 
at the top) that did seem to allow it to find more..I finally got through this 
one after 2 days at it(I tried David Adams suggestion of trying ‘all vars are 
declared’ and at 69000 errors decided that was not the way to go!..and could 
not run his retokenise code because this is a live system i am working on and 
its V12). Its feels better to me to have a system that does at least 
syntactically correct and is compilable.

Of course now i got some ‘fallout’ I found that at least one Variable was used 
in a 4D Write document and the same var(Interprocess) was a number and then 
somewhere else a string..changed the name of the variable in the string and 
then was told a document was not working…Can anyone think of other examples 
where a var might be used in a way that does not show up in 
forms/methods/scripts?

Nigel Greenlee




> On 6 Apr 2017, at 21:47, Douglas von Roeder via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Nigel:
> 
> A couple of thoughts on this…
> 
> I couldn't find this documented but 4D's compiler does three "passes"
> through the source code (when you're not typing all of your variables).
> IIRC, the compiler displays what it's doing for each pass but newer
> versions of 4D + modern hardware are so fast that I haven't seen the
> "label" appear in the compiler window.
> 
> For the sake of argument, lets' say that the three passes are something
> like syntax, declarations, and then parameter type matching. There must be
> no errors in one phase before the compiler will move on to the next.
> Perhaps what you're seeing is that as you resolve errors during the syntax
> phase, those changes engender issues within that same phase.
> 
> Once the issues in the syntax phase are resolved, the compiler will run the
> declarations phase and will report those errors.
> 
> Rinse, lather, repeat for the next phase.
> 
> 
> Second issue is that 4D's compiler used to scan methods sequentially, based
> on ID, and would check parameters based on the parameter list that exists
> for the first instance of a method.
> 
> This was my observation of the early versions of the compiler so it could
> be observer error/bias and 4D could have completely revamped how the
> compiler functions. Also, in the 25 years or so since I made this
> observation, I've never gone back and checked. :-)
> 
> Having just done a 2004 to 15 conversion, I saw the same behavior you're
> experiencing and it was *not* a pleasant feeling. Most of the time I
> compile it really is just a "spell check", so it was unnerving to compile -
> error fix - compile and get more errors - error fix - compile and get
> different errors. No fun at all but an inherent part of the process of
> "getting to done".
> 
> 
> 
> --
> Douglas von Roeder
> 949-336-2902
> 
> On Wed, Apr 5, 2017 at 1:56 AM, Nigel Greenlee via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> David
>> 
>> Thanks for the insight. I think i might try that-day 2 and half already of
>> this! Hopefully the compile with ‘all vars are declared should show me what
>> is not declared(!)…i would love to be able to run my code(which i spoke
>> about on here) that now auto sets the declarations of variables at the top
>> of methods and declares everything that does not comply with the naming
>> convention and is not declared as //C_UNKNOWN..but alas not much naming
>> convention in play. I will try your re-tokenize code shortly.
>> 
>> My next ‘side task’(now that i have my updated code repository
>> working-although not installed on the system i am talking about here yet)
>> is to write something that will report repeating methods-methods and
>> scripts that are identical or near identical, and i think as part of that I
>> will get it to report if there are invalid method names in new process(I
>> find it annoying that ‘find unused methods’ shows any methods called only
>> in new process or from a menu as uncalled)
>> 
>> As with most people my own code never assumes parameters these days-with
>> all vars passed put into locals which really helps with parameter checking
>&

Re: 4D Compiler

[Nigel Greenlee via 4D_Tech]

Tim

I bow to your knowledge on this. I only go back as far as version 2.5 of 4D and 
in my first year of work did not have the compiler. I suspect there is little 
of the original David Hemmo code in the current compiler now. 

> On 7 Apr 2017, at 02:34, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
>> On Apr 6, 2017, at 7:52 PM, Lee Hinde wrote:
>> 
>> On Apr 6, 2017, at 3:09 PM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>>> 
>>> I wonder whatever happened to the original 4D Compiler writer David Hemmo?
>> 
>> David’s at Apple now.
> 
> I wonder what group he works in. You think he’s in the group that works on 
> compilers, LLVM, Clang and all the super low level stuff?
> 
>>> When he wrote 4D Compiler back in 1990 I thought he was a programming 
>>> god... 
>> 
>> So did ACIUS, given the original pricing.
> 
> I don’t remember the 4D Compiler 1.0 price. Was it $999?  I do remember that 
> you got 4D Compiler on a floppy diskette that was a key disk you could not 
> copy. I remember having to pass that disk around at the place I worked 
> whenever anyone wanted to compile and it asked for the diskette.
> 
> 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
> **

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

[Nigel Greenlee via 4D_Tech]

David

Thanks for the insight. I think i might try that-day 2 and half already of 
this! Hopefully the compile with ‘all vars are declared should show me what is 
not declared(!)…i would love to be able to run my code(which i spoke about on 
here) that now auto sets the declarations of variables at the top of methods 
and declares everything that does not comply with the naming convention and is 
not declared as //C_UNKNOWN..but alas not much naming convention in play. I 
will try your re-tokenize code shortly.

My next ‘side task’(now that i have my updated code repository working-although 
not installed on the system i am talking about here yet) is to write something 
that will report repeating methods-methods and scripts that are identical or 
near identical, and i think as part of that I will get it to report if there 
are invalid method names in new process(I find it annoying that ‘find unused 
methods’ shows any methods called only in new process or from a menu as 
uncalled)

 As with most people my own code never assumes parameters these days-with all 
vars passed put into locals which really helps with parameter checking in the 
code-and very few vars not passed(so a big reduction in process vars and 
virtually no interprocess)..but we are someway from even starting on that here

I will go vote..

Nigel Greenlee

> On 4 Apr 2017, at 22:58, David Adams via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> Nigel,
> 
> The Compiler changed some versions back and no longer detects all error sin
> one pass...at least in certain situations. A few tips and things to look
> out for:
> 
> * If you've got a missing method, the Compiler usually stops reporting
> errors, even if there are multiple cases of the problem.
> 
> * Sometimes, code doesn't seem to be scanned. I use a method to retokenize
> all methods (pasted below) which helps. Note that you get an error on this
> most of the time when the method tries to retokenize itself.
> 
> * If you compile with 'all variables are typed ' (and you are likely to
> find more genuine errors this way), then periodically do a syntax check
> with 'type the variables.' If you've got inconsistent declarations, this
> can turn them up.
> 
> There are still a number of things that the compiler won't do - even in V16:
> 
> * Check parameter list lengths and detect extra params in some cases.
> 
> * Check parameter list lengths and detect missing params in any case.
> (There's no syntax to declare a method parameter as optional in 4D.)
> 
> * Check method name references, like with New process, ON ERR CALL, etc.
> There's also still no way to declare that a parameter is a method reference.
> 
> I've already got a feature request in at forums.4d.fr for these
> improvements. If you like these ideas, or have related suggestions, please
> comment and vote here:
> 
> Compiler/Typing Improvements: Detect some runtime errors in advance
> http://forums.4d.fr/Post/EN/19107688/1/19107689
> 
> I have to say, I've got zero evidence to make be believe that the forum
> voting makes any difference at all...but I'm new over there. So, maybe I
> does. I do know that 4D officially ignores comments on this list, so
> everything here is just chat. If, like many of us, you don't guess how to
> vote properly, here's a Tech Tip that Tim Penner kindly pointed out not too
> long ago:
> 
> Tech Tip: How to vote for a feature request
> http://kb.4d.com/assetid=76726
> 
> Here's that method I promised earlier. The subroutine names are pretty
> self-explanatory.
> 
> If (False)
>  Method_RetokenizeAllCode
> 
>// Adapted from a NUG thread in September of 2015.
>// From: Vincent de Lachaux
>// Date: Wednesday, September 23, 2015
>// Subject: Re-Tokenize Methods Procedurally
>// To: 4D iNug Technical<4d_tech@lists.4d.com>
> End if
> 
> C_BOOLEAN($1;$confirm_first)
> 
> $confirm_first:=True
> If (Count parameters>=1)
>  $confirm_first:=$1
> End if
> 
> C_BOOLEAN($continue)
> $continue:=True
> 
> If (System_IsCompiled )
>//Method_AlertIfRunningCompiled ("Method retokenization does not work
> in compiled mode.")
>  $continue:=False
> End if
> 
> OK:=0
> If ($continue & $confirm_first)
>  C_TEXT($message)
>  $message:=""
>  $message:=$message+"Please make a backup of the structure if you haven't
> already."+Char(Carriage return)+Char(Carriage return)
>  $message:=$message+"Close any methods currently open in the Design
> environment before proceeding."+Char(Carriage return)+Char(Carriage return)
>  $message:=$message+"Retokenize all methods now?"
> 
>  CONFIRM($message)
>  $continue:=OK=1
> End if
> 
> If ($continue)
>  C_TEXT($icon_path)
>  C_LONGINT($progress_id)
>  C_BOOLEAN($enable_close)
>  $icon_path:=Resources_GetImageFilePath ("Validate_Code_Large.png")
>  $enable_close:=True
>  $progress_id:=Progress_Open ("Retokenizing all
> code";$icon_path;$enable_close)
> 
>  ARRAY TEXT($method_paths_at;0)
>  METHOD GET PATHS(Path all objects;$method_paths_at;*)
> 
>  C_LONGINT($paths_count)
>  

Re: 4D Compiler

[Nigel Greenlee via 4D_Tech]

Tim

Oh that this was V15!!!..its not a complaint about the compiler its doing a a 
damned fine job here its like Mr Trebus living 
room(https://en.wikipedia.org/wiki/Edmund_Trebus)

> On 4 Apr 2017, at 17:31, Charles Miller via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> On Tue, Apr 4, 2017 at 12:23 PM, Nigel Greenlee via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> Chuck
>> 
>> Yep thats pretty much what i am figuring..but I was just curious if anyone
>> know what the 'trigger points’ that cause it to give up are-if we knew what
>> they were we could clear up those errors first(I have been at this one all
>> day today and most of yesterday)
>> 
> 
> If it was closer to the decade I was doing real computer science stuff I
> might have been better able to tell you, but alas that stuff has all passed
> me by
> 
> Regards
> 
> Chuck
> 
> 
> -- 
> -
> 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 Sever 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
**

Re: 4D Compiler

[Nigel Greenlee via 4D_Tech]

Chuck

If it was closer to the days when i wrote load of errors i might have worked 
out(but then i was so daft i could not have worked it out)..now that i am 
clever enough to work it out i don’t need to work it out because i don't write 
100s of errors

…end of a long day clearing 100*n errors get to (100*n)/2 and I was back to 
(100*n)+100 then back to (100*n)-200 and then up again to (100*n)+200 …getting 
the real meat of missing end ifs etc now!  
LOL



> On 4 Apr 2017, at 17:31, Charles Miller via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> On Tue, Apr 4, 2017 at 12:23 PM, Nigel Greenlee via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> Chuck
>> 
>> Yep thats pretty much what i am figuring..but I was just curious if anyone
>> know what the 'trigger points’ that cause it to give up are-if we knew what
>> they were we could clear up those errors first(I have been at this one all
>> day today and most of yesterday)
>> 
> 
> If it was closer to the decade I was doing real computer science stuff I
> might have been better able to tell you, but alas that stuff has all passed
> me by
> 
> Regards
> 
> Chuck
> 
> 
> -- 
> -
> 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 Sever 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
**

Re: 4D Compiler

[Nigel Greenlee via 4D_Tech]

Chuck

Yep thats pretty much what i am figuring..but I was just curious if anyone know 
what the 'trigger points’ that cause it to give up are-if we knew what they 
were we could clear up those errors first(I have been at this one all day today 
and most of yesterday)

Nigel Greenlee

> On 4 Apr 2017, at 17:19, Charles Miller via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:y a
> 
> On Tue, Apr 4, 2017 at 12:05 PM, Nigel Greenlee via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> Just out of curiosity does anyone know why the compiler does this(its a
>> long time since i have had more than 2 errors in the compiler because i
>> compile everytime i change a piece of code to check for syntax before i
>> even test it)
> 
> 
> I would think that at times when compiler hits an error it can not go
> further down that path of logic, so it can not report errors later in that
> code
> 
> Regards
> Chuck
> 
> 
> -- 
> -
> 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 Sever 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
**

4D Compiler

[Nigel Greenlee via 4D_Tech]

Hi

I have always been curious-but really never had to see this in this way. 

I am currently updating a system which has never been compiled-not with a view 
to compiling but to clear up syntax errors. So i started with some number of 
errors(somewhat north of 100)…i cleared some stuff..and then suddenly i had 
some more errors.

In the past I always thought this was because errors of one type had been 
cleared(ie. syntax) and now it could see bad assignments. But in this case it 
was not so..and the errors now reported are probably more significant

Just out of curiosity does anyone know why the compiler does this(its a long 
time since i have had more than 2 errors in the compiler because i compile 
everytime i change a piece of code to check for syntax before i even test it)


Nigel Greenlee



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

Component Capabilities

[Nigel Greenlee via 4D_Tech]

All

I recently posted regarding some work i have been doing to move(and improve) my 
code management functionality from my database to a component. The main 
objective of this was speed. Having moved all my code relating to methods i am 
now looking at the code i have that stores a binary version of a 4D form. I 
have perfectly working in code in my (host) database but i really would like to 
move as much of this one to my component as possible.-it does a fair bit of 
‘heavy lifting reading all the properties of each object on each page of each 
form and building an object(for the form)  and then comparing the object to the 
previous version.

What i am really interested in is to know what others who have undertaken this 
kind of thing have done to get around :


METHOD GET CODE($_Txt_MethodName;$_t_MethodText;*) ... (ETC)

This of course cannot be executed on the component when it is compiled(and 
there is no point in this component if it is not compiled).-i had a try of 
running it in an execute statement-but that did not work(unless i missed 
something)!


With project methods etc I am getting them on the host and passing the code to 
the component for processing-it returns(if required) updated code, to be honest 
that is good enough for speed. I am pretty happy with the results



Now i am dealing with forms where I get lots of raw information.

(for example)...

OBJECT GET EVENTS(*;"";$_aL_FormEvents)  //gets a list of the form events
FORM GET VERTICAL RESIZING($_Bo_vResize;$_L_minHeight;$_L_MaxHeight)
FORM GET HORIZONTAL RESIZING($_Bo_hResize;$_L_mWidth;$_L_MaxWidth)

...and I wondered if anyone has found a way to do this kind of thing from a 
compiled component on the uncompiled structure. If it can't i will just move 
the object process(comparison to old version of form) but I thought maybe I am 
missing a trick…

I looked at the work done in the unit testing programme from Mark Schaak-to see 
what cleverness he might be up to and notice that in there he has ready to go 
code for the host component which creates methods-but i could not see anything 
more complex than that(in this case i don’t need to create methods on the host 
database-they already exist and I am nor distributing this code)

any ideas?


Nigel Greenlee









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

Regex

[Nigel Greenlee via 4D_Tech]

Hi.

I am not very good with regex and looking for some ideas. 

The following regex says if matches

$_RegexString:=\\b(?i)On*

$_t_text=(LONG TEXT CONTAINING) somewhere the word O2FX2I

$_bo_IsFound:=Match regex($_RegexString;$_t_Text;1;$_l_Start;$_l_End)

My regex should be only finding if the word(In this case ‘on’) if the beginning 
of a word in the text(so should find if my regex word was ‘o2' but not ‘on’)

Can anyone guide me what my regex string should have been-my head is hurting:)

Nigel Greenlee


**
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: Host Structure in a component-Enhancing 4D Code-you really want to see this

[Nigel Greenlee via 4D_Tech]

Hi

Thanks(scroll down for link to a nice video)

Dont really know what was going on. Think i was being blind to an accidental 
reference to $tableNums. All working now.-replaced the locals with process vars 
and tidied it up and its all good. 

Incidentally i had lots of fun with updating records using an execute immediate 
statement with a built line of the update where part of the update was a long 
bit of text that contained sections lifted from my code-all kinds of characters 
i there, even wrapped in [ ] i was getting errors-changed to not using 'execute 
immediate’ and my errors went away.

Does anyone know a better way of to check if the table/structure exists.? i 
currently call this..and other than a Session Variable(<>DIff_bo_TablesChecked) 
don’t know of a way to avoid it

Begin SQL
CREATE DATABASE IF NOT EXISTS DATAFILE  <>; 
 Use LOCAL DATABASE DATAFILE  <> AUTO_CLOSE;  
EXECUTE IMMEDIATE :SQLTEXT;
Use database SQL_Internal;
End SQL


This code is for my own Code Manager. I have existing and long standing code 
that runs on my system setting method headers and saving out copies of the code 
and writing to a changes document a summary of the changes to a method. This 
code has always been a bit slow(there is a detectable delay as you close 
methods)

 I have always been guilty of forgetting to type my variables  and inspired by 
a comment on here about extracting variables from a method returned to a half 
baked piece of code I had that did the same..the difference was I want to 
extract not just locals i want to extract all the variables and make sure 
declarations are made at the top of methods. 

Being a bit obsessive I have been beating through this in my spare time over 
the past couple of weeks. Extracting Locals and interprocess variables was 
pretty easy the challenge was how to successfully extract variables. I was 
EVENTUALLY happy with the result of this(plenty of gotchas along the 
way)-having a method that ran over all my code and build the declarations.

The problem then was that it too was a bit slow-parsing a long method line by 
line uncompiled is just never going to be rocket fast so I wanted to move it to 
a component. I already had a component as part of my code manager because 
DIFFING two methods(based on 4D code published by David Dancy) was REALLY slow 
uncompiled and I had put that in a component.

I slowly moved parts of my 'variables extractor’ to the component till i had 
something that could be included in my code manager to build the variables on 
method save-now i can extract the variables from even in a large method in just 
about no time.

The SQL code I was working on was to  to store the history of changes in an 
external structure(I had already started on that-previously this was written 
out to a document and of limited use). Moving them to an external database 
means I can now easily create a view of method changes to show all the history 
of a piece of code, and do some things around that(fix/revert/report etc) 
...thats my next little side project.

 The compiled component code manager is now working the way I want and this 
nicely enhances my code

I thought i would share a little video of what happens in my code…

https://www.dropbox.com/s/j5x0vy45j1ikocg/Automatical%20Typing%20of%20variables.mp4?dl=0
 


Answers to inevitable questions:-

Did i have to change my structure to do this? Not at all. The are a couple 
methods in my host code-less now than before the component and I hoping to 
reduce them down further as well.

How does it know the type of the variables? I use a naming convention so it 
recognises by the variable type..if you have no naming convention it would be 
hard to do. I read the compiler directives as well

What about $1 etc? it recognises them by assignment(or from the compiler 
directives).  Almost always my code has $_l_MyVariable:=$1(In the top of the 
code) so we can deduce that $1 is a longint(and $_l_MyVariable:=$1-> means $1 
is a pointer!). I have considered using assignments to work out the type of all 
variables-but as I use a naming convention It was work I did not need to do.

What about ‘badly’ named variables. If i lazily type For($i;1;…)..old habits 
die hard! then the code wont know what the variable is so will declare 
//C_UNKNOWN..so i can just find them and fix ‘em..-

Could a different naming convention be used? Yes. -i have currently hard coded 
my naming convention but i plan to change that to pick up a document in which 
any naming convention can be defined

Could a different header model by used Yes-again i currently have my 
headers(different rules for project methods, form methods, triggers, object 
methods) hard coded  i also plan to change this to pick up the header 
definitions from documents.

What about if there are methods you don’t want this to happen in. I have a few 
method like that-as this code was in my ma

Host Structure in a component

[Nigel Greenlee via 4D_Tech]

I know this topic has been covered in General before but there are some things 
I am not sure about and i seem to be having a problem.

I want to get the details of a host structure in a COMPILED component.


ARRAY LONGINT($tableNums;0)
ARRAY TEXT($tableNames;0)
Begin SQL
 SELECT TABLE_ID
 FROM _USER_TABLES
 INTO :$tableNums;

 SELECT TABLE_NAME
 FROM _USER_TABLES
 INTO :$tableNames;
End SQL

I know that code works inside the host database uncompiled and my reading 
suggested this is how i should be getting the structure in the component. 
However i am getting an error(just after this SQL. (error 1430) the variable 
does not exist.

I was wondering if anyone could enlighten me where I am going wrong here.


Thanks.

Nigel Greenlee


 


**
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: osx open url vs osascript FYI

[Nigel Greenlee via 4D_Tech]

David

This works for me launching(all sorts of) documents..(OSX there is a another 
bit bit i have for windows)

$_t_DocumentPath:=<—full path to document
If (Test path name($_T_DocumentPath)=Is a document)
$_t_PosixPath:=Convert path system to POSIX($_t_DocumentPath)

$_t_FilePath:=$_t_char+$_t_PosixPath+$_t_Char
$_t_applicationName:=UTIL_GetDocApps ($_t_DocumentType;True)  //do some stuff 
to check what app they want(not entirely necessary  This will only ask once!-so 
could be launching an HTML doc with preferred browser for example

If ($_t_applicationName#"")
  //now we must checkt the applicaiton exist
$_t_ApplicationPath:=System folder(Applications or program files)

If (Not(Test path name($_t_ApplicationPath+$_t_applicationName)=Is a document))
  //i am not faffing about looking for apps installed somewhere else..
LAUNCH EXTERNAL PROCESS("open "+Char(34)+$_t_PosixPath+Char(34))

Else 
LAUNCH EXTERNAL PROCESS("open -a "+Char(34)+$_t_applicationName+Char(34)+" 
"+Char(34)+$_t_FilePath+Char(34))

End if 

Else 
LAUNCH EXTERNAL PROCESS("open "+Char(34)+$_t_PosixPath+Char(34))

End if 




> On 13 Mar 2017, at 07:08, David Ringsmuth via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Bernd,
> 
> Yes, html was what I first tried.
> 
> David Ringsmuth
> 
> From: Bernd Fröhlich via 4D_Tech
> Sent: Saturday, March 11, 2017 4:57 AM
> To: 4d_tech@lists.4d.com
> Cc: Bernd Fröhlich
> Subject: Re: osx open url vs osascript FYI
> 
> David Ringsmuth:
> 
>> I tried many different things to launch a .htm on OSX using OPEN URL, and it 
>> would not automatically open the document.
> 
> 
> Have you tried using ".html" instead of ".htm"?
> What happens if you doubleclick your .htm-document in the finder?
> 
> 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
> **
> 
> **
> 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: RESOURCE LIST & XLIFF Resource Files

[Nigel Greenlee via 4D_Tech]

Steven

I don’t have an exact solution for you. but the following might give you some 
pointers on the way to go. I got this code from the 4DBB-I DID NOT WRITE IT 
MYSELF. it extracts all the 4D constants from the constants xliff file.

C_POINTER($1;$constantNames_p_at)
C_POINTER($2;$constantIDs_p_at)

C_TIME($constantsXLIFFFile_h)
C_TEXT($constantsXLIFFFile_t)
C_TEXT($elementName_t;$elementPrefix_t;$constantName_t;$constantID_t)
C_BOOLEAN($transUnitFound_f;$targetFound_f)
C_LONGINT($SAXEvent_l;$pos_l)

ARRAY TEXT($attributeNames_at;0)
ARRAY TEXT($attributeVals_at;0)

$constantNames_p_at:=$1
$constantIDs_p_at:=$2

$constantsXLIFFFile_t:=(Application file)+Folder separator+"Contents"+Folder 
separator+"Resources"+Folder separator+"en.lproj"+Folder 
separator+"4D_ConstantsEN.xlf"

$constantsXLIFFFile_h:=Open document($constantsXLIFFFile_t;Read mode)

If (OK=1)

Repeat 
$SAXEvent_l:=SAX Get XML node($constantsXLIFFFile_h)
Case of 

: ($SAXEvent_l=XML start element)
SAX GET XML ELEMENT($constantsXLIFFFile_h;$elementName_t;\
$elementPrefix_t;$attributeNames_at;$attributeVals_at)

  // Need to locate the "target" element for each constant "trans-unit".
Case of 
: ($elementName_t="trans-unit")
$pos_l:=Find in array($attributeNames_at;"id")
If ($pos_l>0)
$constantID_t:=$attributeVals_at{$pos_l}
  // Ignore the first trans-unit in each group, it's not a constant.
If ($constantID_t#"@_0")
$transUnitFound_f:=True
$constantID_t:=Substring($constantID_t;3)
Else 

End if 
End if 

: ($elementName_t="target")
If ($transUnitFound_f)
$targetFound_f:=True
$transUnitFound_f:=False
End if 
End case 

: ($SAXEvent_l=XML DATA)
  // With the target located, we have the constant name.
If ($targetFound_f)
SAX GET XML ELEMENT VALUE($constantsXLIFFFile_h;$constantName_t)
APPEND TO ARRAY($constantNames_p_at->;$constantName_t)
APPEND TO ARRAY($constantIDs_p_at->;Num($constantID_t))
$constantName_t:=""
$constantID_t:=""
$targetFound_f:=False
End if 

End case 
Until ($SAXEvent_l=XML end document)

CLOSE DOCUMENT($constantsXLIFFFile_h)
End if 

> On 9 Mar 2017, at 02:07, Steven via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> Miyako’s reply confirms that RESOURCE LIST does not work with XLIFF files, as 
> I suspected.  
> 
> So having extracted my STR# resources into XLIFF files (with the help of 
> Miyako's component, thanks again), what I would like to do is replicate its 
> functionality, i.e. extract arrays of the ‘ids’ and ’resnames’ of all of the 
> ‘group’ elements present within those XLIFF files.  I am confident that that 
> can be done, but as I said I am entirely out of my depth with respect to XML 
> and native 4D XML commands.  
> 
> Any direction, better yet, sample code would be greatly appreciated.  
> 
> Thanks in advance.
> 
> Steven Prins
> Santa Fe, NM
> 
> 
>> On Mar 8, 2017, at 3:32 AM, 4d_tech-requ...@lists.4d.com wrote:
>> 
>> Message: 3
>> Date: Wed, 8 Mar 2017 03:08:52 +
>> From: Keisuke Miyako mailto:keisuke.miy...@4d.com>>
>> To: 4D iNug Technical <4d_tech@lists.4d.com >
>> Subject: Re: RESOURCE LIST & XLIFF Resource Files
>> Message-ID: <7fd1fa79-e659-4e63-a649-592762650...@4d.com 
>> >
>> Content-Type: text/plain; charset="utf-8"
>> 
>> Hello,
>> 
>> the command RESOURCE LIST was never associated with XLIFF.
>> 
>> resource commands that work with XLIFF are:
>> 
>> STRING LIST TO ARRAY
>> http://doc.4d.com/4Dv15/4D/15.4/STRING-LIST-TO-ARRAY.301-3274706.en.html 
>> 
>> 
>> and
>> 
>> Get indexed string
>> http://doc.4d.com/4Dv15/4D/15.4/Get-indexed-string.301-3274707.en.html 
>> 
>> 
>> see also:
>> 
>> Appendix C: XLIFF architecture
>> http://doc.4d.com/4Dv15/4D/15.4/Appendix-C-XLIFF-architecture.300-3285323.en.html
>>  
>> 
>> 
>>> 2017/03/08 1:22、Steven via 4D_Tech <4d_tech@lists.4d.com 
>>> > のメール：
>>> Does the 4D command “RESOURCE LIST” still work with XLIFF string resource 
>>> files?
>> 
> 
> **
> 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: Tables created with SQL CREATE TABLE command and triggers

[Nigel Greenlee via 4D_Tech]

Pat

Ah Relationships-well you never mentioned them I was thinking of an 
Autistic System:)

…i guess there is no way other than external database file with 500 or so  
tables(that should be enough:))  as mentioned by Tim Nevels (You can easily 
automate the creation of the tables of course through your uncompiled structure.

(i would still put this in an external datafile if it where me! data can live 
there and not in the main database and therefore remain intact on upgrade)..

Nigel




> On 8 Mar 2017, at 14:34, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> Hi Nigel,
> A cunning plan, but wouldn't work because
> a) only one database can be active at a time, so only one table would be
> accessible.
> b) We allow the customer to define their own relations between their
> tables, and that wouldn't be possible.
> 
> But I like your outside-the-box thinking :)
> Pat
> 
> On 8 March 2017 at 12:43, Nigel Greenlee via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
> 
>> Pat
>> 
>> OK..
>> 
>> 
>> Let me suggest something crazy then...
>> 
>> 1) You create an external data(file) with a single table(with a trigger)..
>> Lets call this the template.-we never use the template
>> 
>> 2) When a user wants to create a custom table you duplicate the
>> template(Using LEP)..rename the ‘copy’ to reflect the custom table name.
>> The copy has a single table with a trigger(a generic trigger i
>> assume)..and a single field(UUID auto generate)..
>> 
>> 3) You use alter to alter the name of the table in the copy and add the
>> custom fields
>> 
>> So you end up with N external data-files one for each custom table.
>> 
>> …maybe someone has a better way
>> 
>> Nigel
>> 
>> 
>> 
>>> On 8 Mar 2017, at 12:32, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com>
>> wrote:
>>> 
>>> Hi Nigel,
>>> Yeah I did look into that option as well, but it doesn't solve the
>> trigger
>>> problem. Triggers are essential to us!
>>> Pat
>>> 
>>> On 8 March 2017 at 12:19, Nigel Greenlee via 4D_Tech <
>> 4d_tech@lists.4d.com>
>>> wrote:
>>> 
>>>> Pat
>>>> 
>>>> A sideways question for your concept.
>>>> 
>>>> 1) Are you creating the tables in the main structure or using the
>> external
>>>> datafile( CREATE DATABASE IF NOT EXISTS DATAFILE
>>>> <<$_t_CustomTablesPath>>;) .(I use an external datafile structure for
>> some
>>>> things-very useful..it could be useful in your scenario as the created
>>>> tables and data could remain intact with new builds.
>>>> 
>>>> 
>>>> I have not tested to see if you can set the trigger code on a table in
>> an
>>>> external data file and if you can do it compiled..the external datafile
>> is
>>>> not compiled..but i suspect the answer is no!
>>>> 
>>>> I guess the other option is to go back to the days before we had
>> triggers
>>>> and set a process to look for modified records in the created tables…
>>>> 
>>>> Nigel Greenlee
>>>> 
>>>> 
>>>> 
>>>> 
>>>> 
>>>> 
>>>>> On 8 Mar 2017, at 10:10, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com>
>>>> wrote:
>>>>> 
>>>>> Hi Arnaud,
>>>>> Yes, but the thing is that the TABLES will not be missing, only the
>>>> custom
>>>>> fields that the client created. Now if there was a REGENERATE MISSING
>>>>> FIELDS function ...
>>>>> 
>>>>> On 8 March 2017 at 09:59, Arnaud de Montard via 4D_Tech <
>>>>> 4d_tech@lists.4d.com> wrote:
>>>>> 
>>>>>> 
>>>>>>> Le 8 mars 2017 à 10:19, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com
>>> 
>>>> a
>>>>>> écrit :
>>>>>>> 
>>>>>>> [...] Also I've realised that there is another fundamental problem
>> with
>>>>>> the idea
>>>>>>> of allowing customers to create new fields: when we issue a program
>>>>>> update,
>>>>>>> those custom fields - and their data - will be lost!
>>>>>> 
>>>>>> See GET MISSING TABLE NAMES and REGENERATE MISSING TABLE:
>>>>>> <http://doc.4d.com/4Dv16/4D/16/GET-MISSING-TAB

Re: 4D v15.4: Sequence number issue / Duplicate key error

[Nigel Greenlee via 4D_Tech]

Rudy

In my vast head banging experience of this its usually that a record has been 
created with no ID, or in the case of sequence the 4D sequence is out of sync. 

My suspicions would be records in transactions or record deletions

Two suggestions..

1) Put some code in the ‘save’ part of the record that check the ID is unique 
before you save it.

if(Record number([Table])=-3)/if it is a new record not saved yet then there 
should be nothing with the id on
$_l_Max:=0
else
$_l_Max:=1//this record
end if
$ID:=[table]id

SET QUERY DESTINATION(Into variable;$_l_RecordCount)
Repeat
query([table];[table]id=$ID)
if($_l_RecordCount> $_l_Max)
$ID:=$ID+1 //..the id will clash
end if
until($_l_RecordCount<=$_l_Max)
SET QUERY DESTINATION(Into current selection)
[table]id:=$ID

1) add a UUID(auto increment) primary key make your existing ID not the 
primary/unique(no need to change relations or anything like that) and put 
something in to watch for duplicates and report them to you-then you can look 
at how they are happening without users having an issue). 




Rebuilding the index hides the problem because it resets the sequence number.



.
> On 8 Mar 2017, at 12:26, Two Way Communications via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Hi all,
> 
> I ran into an issue while using SEQUENCE NUMBER in 4D v15.4, in a 
> client-server setup.
> 
> I put the result in a field called ‘ID’, which is the primary key for that 
> table, and by default is unique. Auto increment is off.
> The code is running in a transaction.
> 
> Frequently, users get the error ‘Cannot save the record, DUPLICATE KEY’.
> Then, I go to the structure and rebuild the index on that field (ID).
> 
> They try again, and the record is saved without a problem.
> 
> After a while, though, and after other users have added records to this 
> table, the problem re-occurs.
> Rebuilding the index again fixes the problem.
> 
> I have exported the data to a tab delimited file, truncated the table, and 
> imported the data. Problem is still there.
> I have compacted the data file. Same problem.
> 
> Any ideas what can be the cause?
> 
> Kind regards,
> 
> Rudy Mortier
> Two Way Communications bvba  -
> 
> 
> **
> 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: Tables created with SQL CREATE TABLE command and triggers

[Nigel Greenlee via 4D_Tech]

Pat

OK..


Let me suggest something crazy then...

1) You create an external data(file) with a single table(with a trigger).. Lets 
call this the template.-we never use the template

2) When a user wants to create a custom table you duplicate the template(Using 
LEP)..rename the ‘copy’ to reflect the custom table name.
The copy has a single table with a trigger(a generic trigger i assume)..and a 
single field(UUID auto generate)..

3) You use alter to alter the name of the table in the copy and add the custom 
fields

So you end up with N external data-files one for each custom table.

…maybe someone has a better way

Nigel



> On 8 Mar 2017, at 12:32, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> Hi Nigel,
> Yeah I did look into that option as well, but it doesn't solve the trigger
> problem. Triggers are essential to us!
> Pat
> 
> On 8 March 2017 at 12:19, Nigel Greenlee via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
> 
>> Pat
>> 
>> A sideways question for your concept.
>> 
>> 1) Are you creating the tables in the main structure or using the external
>> datafile( CREATE DATABASE IF NOT EXISTS DATAFILE
>> <<$_t_CustomTablesPath>>;) .(I use an external datafile structure for some
>> things-very useful..it could be useful in your scenario as the created
>> tables and data could remain intact with new builds.
>> 
>> 
>> I have not tested to see if you can set the trigger code on a table in an
>> external data file and if you can do it compiled..the external datafile is
>> not compiled..but i suspect the answer is no!
>> 
>> I guess the other option is to go back to the days before we had triggers
>> and set a process to look for modified records in the created tables…
>> 
>> Nigel Greenlee
>> 
>> 
>> 
>> 
>> 
>> 
>>> On 8 Mar 2017, at 10:10, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com>
>> wrote:
>>> 
>>> Hi Arnaud,
>>> Yes, but the thing is that the TABLES will not be missing, only the
>> custom
>>> fields that the client created. Now if there was a REGENERATE MISSING
>>> FIELDS function ...
>>> 
>>> On 8 March 2017 at 09:59, Arnaud de Montard via 4D_Tech <
>>> 4d_tech@lists.4d.com> wrote:
>>> 
>>>> 
>>>>> Le 8 mars 2017 à 10:19, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com>
>> a
>>>> écrit :
>>>>> 
>>>>> [...] Also I've realised that there is another fundamental problem with
>>>> the idea
>>>>> of allowing customers to create new fields: when we issue a program
>>>> update,
>>>>> those custom fields - and their data - will be lost!
>>>> 
>>>> See GET MISSING TABLE NAMES and REGENERATE MISSING TABLE:
>>>> <http://doc.4d.com/4Dv16/4D/16/GET-MISSING-TABLE-NAMES.
>> 301-3036706.en.html
>>>>> 
>>>> 
>>>> --
>>>> Arnaud de Montard
>>>> 
>>>> 
>>>> 
>>>> 
>>>> **
>>>> 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
>>>> **
>>>> 
>>> 
>>> 
>>> 
>>> --
>>> *
>>> 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
>>> **
>> 
>> **
>> 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: Tables created with SQL CREATE TABLE command and triggers

[Nigel Greenlee via 4D_Tech]

Pat

A sideways question for your concept.

1) Are you creating the tables in the main structure or using the external 
datafile( CREATE DATABASE IF NOT EXISTS DATAFILE  <<$_t_CustomTablesPath>>;) 
.(I use an external datafile structure for some things-very useful..it could be 
useful in your scenario as the created tables and data could remain intact with 
new builds.


I have not tested to see if you can set the trigger code on a table in an 
external data file and if you can do it compiled..the external datafile is not 
compiled..but i suspect the answer is no!

I guess the other option is to go back to the days before we had triggers and 
set a process to look for modified records in the created tables…

Nigel Greenlee






> On 8 Mar 2017, at 10:10, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> Hi Arnaud,
> Yes, but the thing is that the TABLES will not be missing, only the custom
> fields that the client created. Now if there was a REGENERATE MISSING
> FIELDS function ...
> 
> On 8 March 2017 at 09:59, Arnaud de Montard via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> 
>>> Le 8 mars 2017 à 10:19, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> a
>> écrit :
>>> 
>>> [...] Also I've realised that there is another fundamental problem with
>> the idea
>>> of allowing customers to create new fields: when we issue a program
>> update,
>>> those custom fields - and their data - will be lost!
>> 
>> See GET MISSING TABLE NAMES and REGENERATE MISSING TABLE:
>> >> 
>> 
>> --
>> Arnaud de Montard
>> 
>> 
>> 
>> 
>> **
>> 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
>> **
>> 
> 
> 
> 
> -- 
> *
> 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
> **

**
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: Old doesn't work with object fields....or rather Objects in General

[Nigel Greenlee via 4D_Tech]

David

This slightly changes the topic of the OLD on Object fields to a more detailed 
discussion of the ‘shortcomings' of objects….

(On the topic of the former in my case if I am creating an object in code its 
likely to be created with the same key order each time so if the ’stringified' 
version old is not =current then its changed-and even if it was not in the same 
order it has changed so it is modified). 

Dealing with the Form Meta data..I would really like it if 4D implemented the 
object and form meta data concept because you could extract easily the entire 
representation of a form which is what I currently do with some really 
interesting code-and i know  a number of others have done similar-maybe those 
of us who are interested in such could pool our code and end up with a common 
concept of the structure of the Meta object (Object keys named in a common way, 
common thinking of how to represent form elements etc)-waiting for 4D could be 
a while-probably there is stuff other people are doing that is better than mine.

I will throw some stuff here..if you or others  want to work this up feel free 
to come back to me:

There are a couple of Form Propeties and Object properties you cant(I think) 
get. This was a note i made in my code

 //the following form settings cannot be obtained in code(V14)
  //Markers
  //access
  //menu bar
  //print settings
  //appearance
  //form type
  //inherited form table
  //inherited form name
  //save geometry

and there is an interesting problem that occurs if you have an inherited 
form(took me a while to work out what the hell was going on)…if an inherited 
form has an object named ‘variable1’ and the form itself also has ‘variable1’ 
When you parse the form you get the objects of the form and the objects of the 
inherited form. When you get the variable associated with ‘variable1’ you might 
get the one from the form or the one from the inherited form..and it seems 
random which order you get the objects in-i had to make sure my object names on 
inherited forms where unique.


For your delectation I have put a copy of my version of a  form export (this is 
for a very basic auto made 4D form-i have some really complex forms-and the 
code building this may not be perfect) on my dropbox-

https://www.dropbox.com/s/sr3xfqrxfqton1p/FORM_PO_Purchase_Order_Item_Input.txt?dl=0
 

 

(Its easier as a human to read this if you replace the , with cr)

I build an object with the data put the object in a blob and create a document 
for safe keeping. In Previous attempts at this I used XML and boy did that get 
ugly!  I have code that reads this format back in and is able to compare the 
current version of a form with a saved version of the form-I do not have fancy 
code that reads this and creates or fixes a form or anything, it just tells me 
what has physically changed.

I would propose:
1) A common way for creating a form(and its objects) in an object.
2) A common way for comparing two complex objects where the ‘structure’ of the 
objects is known producing a either a human readable(string) of changes or an 
object representing the changes. e.g a way of comparing two representations of 
a form.

Let know if you or others are interested.

Nigel Greenlee


> On 23 Feb 2017, at 00:12, David Adams via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
>> Seems really inefficient, but it work
> 
> 4D has taken pains to say that object fields *are not JSON*. They can be
> represented as JSON, but they aren't stored or accessed as JSON internally.
> So, it does seem like a good bug report/feature request to make Old work
> correctly on object fields. In fact, it's probably one of the more
> important field types that it could work on it. Having to serialize it and
> run an expensive comparison ourselves feels a bit over the top.
> 
> If you put in a feature request/bug report, shoot a note over here so that
> any of us that care can go and vote for your idea.
> 
> Speaking of objects and feature requests, Cannon "Object Module" Smith made
> a fantastic feature request the other day:
> 
> http://forums.4d.fr/Post/EN/19051683/1/19051684
> 
> The idea is to have an automatic, internal C_OBJECT-type structure (a
> dictionary) maintained by 4D for each widget on a form. If they did this,
> you wouldn't see anything different on the form, but if you wanted to
> associated custom attributes or data with the widget (rules, bindings,
> hints, extra lookup data, filters, formats, privileges, etc.), you would
> know right where to get/set the data. It may sound like a small thing, but
> it would be a *huge* win. Just massive. You can do something on this order
> now with a custom C_OBJECT in a form or process, but the init/cleanup cycle
> is kind of 'heavy'. Also, that makes the price of admission high enough
> that most people won't do it. Many will never even have the chance to
> understand why this is s