Re: Old 4D Transporter (ResTransporter) or Equivalent

2020-07-10 Thread 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

Re: Time to work on this task..

2020-03-24 Thread Nigel Greenlee via 4D_Tech
ion 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 anyt

Time to work on this task..

2020-03-24 Thread 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

Re: MySQL connection from 4D

2019-10-28 Thread Nigel Greenlee via 4D_Tech
; 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 t

MySQL connection from 4D

2019-10-28 Thread 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

Confused array type in an object

2019-08-09 Thread 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

Re: Options To Put Data Into Existing Excel Spreadsheets?

2018-05-07 Thread 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)

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

2018-04-28 Thread 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

Re: Listbox question

2017-10-19 Thread 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)

Re: v13 - odd compiler error

2017-10-13 Thread 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" ;)

Re: VOIP caller ID interface

2017-10-08 Thread 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

oh sweet

2017-10-06 Thread 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_medium=social_source=twitter.com_campaign=buffer joy joy joy of 4D Nigel Greenlee ** 4D Internet

Re: Listbox Spacing Between Columns

2017-09-25 Thread 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

Re: Command numbers and names and using Execute

2017-09-22 Thread Nigel Greenlee via 4D_Tech
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: > >> >>> L

Re: Server Process "Frozen"-ish

2017-09-13 Thread 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

Re: 4D and Git Connection

2017-08-22 Thread 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

Re: UUID vs Longint primary key

2017-08-04 Thread 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 >

Re: Listbox Printing

2017-08-02 Thread 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

Re: Restricting a query

2017-08-01 Thread 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>

Strange Error

2017-07-26 Thread 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

Packages-building an installer

2017-07-11 Thread 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

Re: An efficient printing approach...

2017-07-03 Thread 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

Localization from a component...

2017-06-22 Thread 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

Re: Array Summary Sum Utility Method

2017-06-21 Thread 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

Re: What are some causes of Plugin and Component folder synchronization errors?

2017-06-15 Thread Nigel Greenlee via 4D_Tech
e. 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

Re: What are some causes of Plugin and Component folder synchronization errors?

2017-06-14 Thread 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

Re: 4D and Sage

2017-06-14 Thread 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

Macros...why have i forgotten this.

2017-06-14 Thread 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

Re: v16 Component Compiler error

2017-06-04 Thread 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

Re: V16 on OSX Application licence

2017-05-22 Thread 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

V16 on OSX Application licence

2017-05-19 Thread 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

Re: Is it possible to do a search in the file system from 4D

2017-05-16 Thread 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

Re: Hex Colour Picker in Listbox

2017-05-11 Thread 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

Re: Hex Colour Picker in Listbox

2017-05-11 Thread 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

Re: 4D_Pack Replacement commands in v16

2017-05-10 Thread 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?

Re: Diff 4D Write Documents

2017-04-27 Thread 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

Re: Dynamic Method Creation & Content Changing

2017-04-22 Thread 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,

Re: Dynamic Method Creation & Content Changing

2017-04-22 Thread 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

Re: Dynamic Method Creation & Content Changing

2017-04-21 Thread 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

Re: Methods, Components, Comments, and Tooltips

2017-04-20 Thread 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)

Re: Methods, Components, Comments, and Tooltips

2017-04-20 Thread 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

Re: v13 and OS X 10.12

2017-04-13 Thread 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

Re: 4D Compiler

2017-04-09 Thread 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

Re: 4D Compiler

2017-04-07 Thread Nigel Greenlee via 4D_Tech
ors - 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 < >

Re: 4D Compiler

2017-04-07 Thread 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

Re: 4D Compiler

2017-04-04 Thread Nigel Greenlee via 4D_Tech
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 >&

4D Compiler

2017-04-04 Thread 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

Component Capabilities

2017-03-23 Thread 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

Regex

2017-03-22 Thread 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

Re: Host Structure in a component-Enhancing 4D Code-you really want to see this

2017-03-16 Thread 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

Host Structure in a component

2017-03-13 Thread 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

Re: osx open url vs osascript FYI

2017-03-13 Thread 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)

Re: Tables created with SQL CREATE TABLE command and triggers

2017-03-08 Thread Nigel Greenlee via 4D_Tech
ur 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 d

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

2017-03-08 Thread 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

Re: Tables created with SQL CREATE TABLE command and triggers

2017-03-08 Thread Nigel Greenlee via 4D_Tech
n 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

Re: Tables created with SQL CREATE TABLE command and triggers

2017-03-08 Thread 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

Re: Old doesn't work with object fields....or rather Objects in General

2017-02-23 Thread 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'