Re: Install 4D v15 for Windows client mode usage

2017-02-23 Thread Charles Miller via 4D_Tech
How about on windows zip the entire folder and on mac zip the application. The write a script to unzip and put in the correct place Regards Chuck On Wed, Feb 22, 2017 at 4:16 PM, Justin Leavens via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I have a customer site with a mix of Windows machines

Re: Question about storing data outside of datafile

2017-02-15 Thread Charles Miller via 4D_Tech
On Wed, Feb 15, 2017 at 9:43 AM, Randy Engle via 4D_Tech < 4d_tech@lists.4d.com> wrote: > However, we found that storing blobs in external file had detrimental > effects in certain cases. > If you've got 1000s and 1000s of blobs, these are all stored as individual > files on disk. > When copying

Re: can i do the following in v15

2017-03-30 Thread Charles Miller via 4D_Tech
On Thu, Mar 30, 2017 at 12:55 PM, Timothy Penner via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Tech Tip: Avoid adding tables to multiple copies of a structure > PRODUCT: 4D | VERSION: 12.5 | PLATFORM: Mac & Win > Published On: August 27, 2013 > If using multiple copies of a structure and

Re: v13 - Converting a v12 data file - missing records

2017-03-29 Thread Charles Miller via 4D_Tech
On Wed, Mar 29, 2017 at 4:37 PM, Chip Scheide via 4D_Tech < 4d_tech@lists.4d.com> wrote: > So... my question is: > What is going on?? > Why are the parent and child records missing? > Ideas? > > Thanks > No idea but - how are they related? Also I might want to run MSC on v12 before convert on a

Re: XML or rest services

2017-03-29 Thread Charles Miller via 4D_Tech
On Wed, Mar 29, 2017 at 3:23 PM, Ortwin Zillgen via 4D_Tech < 4d_tech@lists.4d.com> wrote: > > 4D tags work just fine for creating XML I know that what I need to know is how to get data from XML into 4D without having access to source. I would have thought I could use 4D tags. That is question

Re: XML or should be rest services

2017-03-28 Thread Charles Miller via 4D_Tech
I of course mean rest services not test and I know I would need web license or rest license Chuck Sent from my iPhone > On Mar 28, 2017, at 8:43 PM, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Hi all for a new client they are asking to implement xml post and get to >

Re: Larry Sharpe

2017-03-16 Thread Charles Miller via 4D_Tech
On Wed, Mar 15, 2017 at 5:17 PM, Lee Hinde via 4D_Tech <4d_tech@lists.4d.com > wrote: > Larry passed away last week.. Obit here: http://www.mtdemocrat.com/ > obituaries/larry-sharpe/ obituaries/larry-sharpe/> > Sorry to hear about this. My thoughts and prayers are

Re: 4D Server - Not letting go of users

2017-03-16 Thread Charles Miller via 4D_Tech
On Thu, Mar 16, 2017 at 1:27 PM, Randy Engle via 4D_Tech < 4d_tech@lists.4d.com> wrote: > If a client/user does a force quit (i.e. Task Manager), > Their user account on 4D Server persists, and takes up a license. > I used to think that these would fall off in a short amount of time, but I >

Re: Anyone using v16 in WAN

2017-04-04 Thread Charles Miller via 4D_Tech
On Tue, Apr 4, 2017 at 3:38 PM, Charles Miller wrote: > This is true, you need to use the new network layer with a 64 bit MAC >> server... legacy network doesn't exist. >> >> >> Neil >> >> > Ohm thanks to all. This was not how I understood it. OK what about when I

check for duplicates in v15

2017-04-04 Thread Charles Miller via 4D_Tech
Hi All I have in pseudo code the following distinct values on a text field, that can be anywhere from 5 or 6 characters to >1000 These text fields are supposed to bed unique in in fact are. However, the resultant array is not the same size as numbers of records. I know it is the same, as I

Re: delete or truncate

2017-04-04 Thread Charles Miller via 4D_Tech
On Tue, Apr 4, 2017 at 2:04 PM, Douglas von Roeder via 4D_Tech < 4d_tech@lists.4d.com> wrote: > It's a command whose function is to clear all the tablespace allocated to > records in a given table along with the associated indexes. > > Delete selection is used to delete one or more records,

Re: Anyone using v16 in WAN

2017-04-04 Thread Charles Miller via 4D_Tech
On Tue, Apr 4, 2017 at 3:37 PM, Dennis, Neil via 4D_Tech < 4d_tech@lists.4d.com> wrote: > > This is true, you need to use the new network layer with a 64 bit MAC > server... legacy network doesn't exist. > > > Neil > > Ohm thanks to all. This was not how I understood it. Regards Chuck --

Re: 4D Compiler

2017-04-04 Thread Charles Miller via 4D_Tech
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

Re: 4D Compiler

2017-04-04 Thread Charles Miller via 4D_Tech
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

Re: Anyone using v16 in WAN

2017-04-04 Thread Charles Miller via 4D_Tech
On Tue, Apr 4, 2017 at 12:36 PM, John DeSoi via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Are folks having trouble with the new network layer using it in 32 bit > mode or 64 bit mode? Just wondering if 64 bit mode is also problematic. It is my understanding that 32 mode only runs on old network

delete or truncate

2017-04-04 Thread Charles Miller via 4D_Tech
I seem to remember a tech note or example that would fix index problems that you would have when deleting most of the record in a able or or truncating it. I can not seem to find it. I wanted to make sure that if we run a repair after doing this that all will be as it should. The two tables we are

Re: 4D World Tour 2017 (OFF) Hardware advice for the latest 4D Development

2017-04-05 Thread Charles Miller via 4D_Tech
On Wed, Apr 5, 2017 at 2:26 PM, Lee Hinde via 4D_Tech <4d_tech@lists.4d.com> wrote: > I don’t even recognize the guy in the mirror. How could you that guy is me;) Chuck -- - Chuck Miller Voice: (617)

Re: Dynamic Method Creation & Content Changing

2017-04-20 Thread Charles Miller via 4D_Tech
On Thu, Apr 20, 2017 at 3:18 PM, truegold via 4D_Tech <4d_tech@lists.4d.com> wrote: > Clearly that would be obvious right? It was obvious but it was part of your original question. I try to read your questions very carefully for the nuggets Regards Chuck --

Re: Automated tasks on 4D Server

2017-04-19 Thread Charles Miller via 4D_Tech
On Tue, Apr 18, 2017 at 10:28 PM, James Crate via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I agree it’s not very difficult to write a job scheduler, but it’s > tedious, and only a couple minutes to set up a process to run periodically. > In this case the new jobs I am adding all need to run

Re: Read Only 4D Server

2017-04-19 Thread Charles Miller via 4D_Tech
On Mon, Mar 27, 2017 at 9:19 AM, Chuck Miller via 4D_Tech < 4d_tech@lists.4d.com> wrote: > How about setting app to allow opening of read only version and first open > developer version why I locks it or better yet open first with built single > user > > Regards > > Chuck > > Sent from my iPhone

Re: Dynamic Method Creation & Content Changing

2017-04-20 Thread Charles Miller via 4D_Tech
On Thu, Apr 20, 2017 at 1:40 PM, truegold via 4D_Tech <4d_tech@lists.4d.com> wrote: > Read method (the one I need to insert lines into) into a text array where > each element is a single line of code or comments or just white space. The > number of elements in the array would match the number of

Re: Saved query files (.4df) and changes from v12 to v15 - automated conversion?

2017-03-06 Thread Charles Miller via 4D_Tech
On Mon, Mar 6, 2017 at 3:25 PM, truegold via 4D_Tech <4d_tech@lists.4d.com> wrote: > Our users have also found the new query dialog less intuitive. They > expressed that having to use popup buttons required extra steps. And > because some checkboxes are now hidden in the popup they forget about

Re: Strategy to allow one user to drop another from the server...

2017-03-06 Thread Charles Miller via 4D_Tech
On Mon, Mar 6, 2017 at 4:23 PM, rooftop99--- via 4D_Tech < 4d_tech@lists.4d.com> wrote: > > In a large client/server install we are implementing a function to allow > one user (client) to drop another from the server. It seems that > regardless of how much training is given, inevitably someone

query re database setting on 4D server v15.4

2017-03-06 Thread Charles Miller via 4D_Tech
when the checkbox on compatibility for use legacy network layer (ignored on OS X 64 bit) is checked. What does this mean. If built server is 64 bit but clients are 32 bit which network layer is used. another way to ask Is Ignored on OSXC 64 bit related to server or client Regards Chuck --

Re: Saved query files (.4df) and changes from v12 to v15 - automated conversion?

2017-03-07 Thread Charles Miller via 4D_Tech
On Tue, Mar 7, 2017 at 1:23 AM, Paul Lovejoy via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Chuck, > > As a developer I’ve already offered the functionality to query in the > selection, join to the existing selection or use a query result to exclude > from the selection. > You missed my point.

Re: Adding fields to tables using SQL

2017-03-02 Thread Charles Miller via 4D_Tech
On Thu, Mar 2, 2017 at 3:56 PM, bob.miller--- via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I've tried this with SQL: > > ALTER TABLE GlobalPricebook ADD TRAILING PB_LTPrefix01 VARCHAR (20) NOT > NULL > Base upon v15 docs I do not see the ability to add NOT NULL or NULL to command. I assume you

auto update of clients

2017-03-02 Thread Charles Miller via 4D_Tech
Hi All, we are moving from v11 directly to v15.4. I have built client server merged application and set too allow auto client updates. When I try to upgrade v11 built client, I get the following error on both mac and windows: Error code: -10509 Can't open database "MHD BMS-source-prod".

Re: 4D db -> SAAS

2017-07-31 Thread Charles Miller via 4D_Tech
You could turn into server version by adding customer field to each table and after every query query for that customer. It would entail. A customer table Witt user name customer and field for related queries Regards Chuck Sent from my iPhone > On Jul 31, 2017, at 3:04 PM, Don Lapin via

selection based list box

2017-08-15 Thread Charles Miller via 4D_Tech
Hi All, Version 15.4hf2 I have a selection based list box with following code on double click event *If *(*Not*(InDoubleClick_B)) InDoubleClick_B:=*True* *C_BOOLEAN*(INV_InventInspLocked) *FORM SET INPUT*([InventoryPhotos];"Input") *C_LONGINT*($LBCol_L;$LBRow_L) *LISTBOX GET CELL

Re: selection based list box

2017-08-15 Thread Charles Miller via 4D_Tech
gt; Hope this helps. > > Best Regards, > Tai B. > > > > > -Original Message----- > From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Charles > Miller via 4D_Tech > Sent: Tuesday, August 15, 2017 12:54 PM > To: 4D iNug Technical > Cc: Charle

Re: Thinking through object/text fields: Findings summarized, advice solicited

2017-07-14 Thread Charles Miller via 4D_Tech
I think just one more thing and that is a caveat. You can NOT access object fields with SQL. You would have to write a sql fn call that would return the data to you. I for one will not be using object fields until they become available through sql. As much as I like the idea, I move to much data

SQL Issue

2017-07-17 Thread Charles Miller via 4D_Tech
Environment MAC 4D v15 internal sql Given the following code Begin SQL update [Tracking] set [Tracking].[IssueDate] = :$NewTracking_d where [Tracking].[PatientRef] = :$PatientRef_L and [Tracking].[TestRef] = 62; End SQL Where all fields are correct I see a warning on the Set Line and when run,

Re: Trace buttons disappeared (OS X 11.12, 4D v14.6)

2017-07-18 Thread Charles Miller via 4D_Tech
You can also do this with code // //User name (OS): Chuck Miller //Date and time: 08/09/16, 13:36:59 // //Method: ut_ResetWindowDefaults //Description //This method will delete

errors on built client

2017-07-18 Thread Charles Miller via 4D_Tech
Hi all, environment Mac server v15.4hf2 server (64 bit) windows built client (32 bit) I am getting errors 1209 (Can not receive request) and then 1 (read failed) on the client, which I think mean connection lost in some way. Can anyone confirm. It would be great if 4D errors were more

Re: Function to return the date/time of the next scheduled backup

2017-07-12 Thread Charles Miller via 4D_Tech
I have not but it would appear that you would first open the xml get last backup date and time The get backup frequency and perform a calculation I do not think backup save next date in the xml Hope this helps chuck On Wed, Jul 12, 2017 at 4:42 PM, Tony Ringsmuth via 4D_Tech <

Re: How to close a modal window if user clicks outside of it?

2017-06-29 Thread Charles Miller via 4D_Tech
On Thu, Jun 29, 2017 at 2:02 PM, Kirk Brooks via 4D_Tech < 4d_tech@lists.4d.com> wrote: > > I open a modal dialog within another form. I want to close this if the user > moused to or clicks on something outside the form. Since I'm working with a > modal dialog it just beeps. > > I tried using the

error number

2017-06-29 Thread Charles Miller via 4D_Tech
Hi all environment 15.4hf2 windows built client (32 bit volume desktop) mac OSX 64 bit server We get the following error read failed Error code 1 Cannot receive request reply Error code :1209 Any changes after last save action will be lost 4D's description of these errors does not give a hint of

Re: SQL

2017-07-06 Thread Charles Miller via 4D_Tech
great eyes. I think you have it as the apostrophes are different. One is different than the other. regards chuck On Thu, Jul 6, 2017 at 3:34 AM, Jerker Stenberg via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi Robert > Can it be the [DOCTOR_CODE] ? '10289’ seems odd, should prob. be '10289' > or

Re: Triggers and modified by fields in roll-your-own user

2017-07-05 Thread Charles Miller via 4D_Tech
Why not an interprocess array on server open connection add and then remove at end Regards Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

Re: Triggers and modified by fields in roll-your-own user

2017-07-05 Thread Charles Miller via 4D_Tech
Why not an interprocess array on server open connection add and then remove at end Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

Re: SQL

2017-07-05 Thread Charles Miller via 4D_Tech
What is the other system. Is it also 4D? and if so what version? If not what is it? What might have changed there? Regards Chuck On Wed, Jul 5, 2017 at 12:13 PM, Robert McKeever via 4D_Tech < 4d_tech@lists.4d.com> wrote: > The site is running v11, and communicates with the other system by SQL.

Re: Diff 4D Write Documents

2017-04-25 Thread Charles Miller via 4D_Tech
Textwrangler and BBEdit have compare doc options as well Sent from my iPhone > On Apr 25, 2017, at 4:32 PM, Douglas von Roeder via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Kirk: > > That's a sound approach. > > In addition to the hash, my thinking is to store changed documents as >

Re: Diff 4D Write Documents

2017-04-25 Thread Charles Miller via 4D_Tech
I would not generate on demand, as you have no control re size of document. I might store differences between current version and previous with new table where doc is stored I would also store doc in record and not outside of data unless you are willing to create doc mgt system as well

Re: TIP-Finding Callers of the Current Method

2017-04-27 Thread Charles Miller via 4D_Tech
On Thu, Apr 27, 2017 at 10:29 AM, Alan Tilson via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I just found the Method/Search Callers menu item that searches for Callers > of the current Method, so if you have not used this please check it out. > I have been using both. Stating the obvious, you must

Re: Licence hair restorer?

2017-04-27 Thread Charles Miller via 4D_Tech
On Thu, Apr 27, 2017 at 12:40 PM, David Hudson via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Should have been simple - upgrade a database to my current licence version > of 4D Professional (licence installed, fully working, Mac 4D v15 R5). > > Then create a double-clickable app: compile, build

Re: How to tell compiler not to duplicate declarations in "Generate Typing"

2017-04-27 Thread Charles Miller via 4D_Tech
On Thu, Apr 27, 2017 at 2:49 PM, Kirk Brooks via 4D_Tech < 4d_tech@lists.4d.com> wrote: > > I think it used to work that way a few versions ago but I may be wrong. To > me it would make these sort of 'custom' declaration methods more useful. It never worked that way. I agree this would be a

Re: Diff 4D Write Documents

2017-04-25 Thread Charles Miller via 4D_Tech
On Mon, Apr 24, 2017 at 5:20 PM, Douglas von Roeder via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I've been asked to update the code in an Audit Trail system so it will work > with 4D Write documents. Rather than simply tracking that there's been a > change and showing the old document vs the new

Re: ​Re: UUID vs Longint primary key

2017-08-07 Thread Charles Miller via 4D_Tech
It might be my memory, but I do not think that is how it worked in the beginning I was working on relational model dbs before SQL was a language Rdb at DEC for example. That was one of the ket differences between model types how you created and maintained the relations. I do not believe that

Re: 4D Server v11 License

2017-08-22 Thread Charles Miller via 4D_Tech
This will work but I am not the person looking to buy. Regards Chuck Sent from my iPhone > On Aug 22, 2017, at 6:16 AM, Koen Van Hooreweghe via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Hi Chuck, > > Maybe you can ask your 4D rep if you can buy v15 license with maintenance > contract

voting for feature requests on the forum

2017-06-20 Thread Charles Miller via 4D_Tech
Hi all, there are a few feature requests I want to vote for on forum, but as I have not done this before can not find where to do it can someone excuse my stupidity and tell me I can not read the XXX manual as there is not one. Thanks and regards Chuck --

Re: What would cause PROCESS 4D TAGS to "not work"

2017-05-23 Thread Charles Miller via 4D_Tech
Check you preference compatibility and make sure you have correct options checked. Also make sure method is available for 4d tags Regards Chuck Sent from my iPhone > On May 23, 2017, at 5:07 PM, Ed Hammond via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > PROCESS 4D TAGS experts! > > > I

Re: Importing Data from a SQL-database (Firebird} [ was: How to detect EOL character in text file]

2017-05-16 Thread Charles Miller via 4D_Tech
On Tue, May 16, 2017 at 6:26 PM, Keisuke Miyako via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I think SQL EXECUTE SCRIPT is more suited for managing long SQL statements, > rather than creating a method with Begin SQL~End SQL > Just remember that all linked arrays must be process arrays Regards

built client and versions

2017-05-16 Thread Charles Miller via 4D_Tech
Hi All, If I build clients with 15.4 hot fix 2 and then build server with 15.5 (If and when it comes out). Will client connect and work. I would guess same issue for earlier versions. If I built with 15.3 hot fix x and then built server with 15.45 will it connect? Is there anything I have to be

concurrent user issue

2017-06-08 Thread Charles Miller via 4D_Tech
Hi all, Environment Mac OS 10.10.5. 4D server 15.2 (we will be moving shortly. Multiple servers running on machine. The server has 52 licenses. I go connection error that max users had been reached. Problem is when I went to all servers running. It shown one connection from 4D and 10 sql

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

2017-06-15 Thread Charles Miller via 4D_Tech
On Thu, Jun 15, 2017 at 11:53 AM, Kirk Brooks via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Nigel, > Yeah, that sounds like regular rolling on the floor laughing material... > > It's a good tip though. Thanks > Actually it sounds like a big money maker to me. No laughing matter. Regards Chuck

Re: Linux in the future?

2017-06-16 Thread Charles Miller via 4D_Tech
At one of my clients we have a 180 gig data file on previous iteration of cylinder mac with attached SSD raid it to about 30 minutes to repair and rebuild indices for that data file, so I think it is pretty fast as Neil said Regards Chuck Sent from my iPhone On Jun 16, 2017, at 10:31 AM,

Re: Securing ODBC Connections?

2017-06-06 Thread Charles Miller via 4D_Tech
You should also have an on sql connection method with log in info we have code that looks like the following *SET QUERY DESTINATION*(Into current selection) *Case of * *: *(*User in group*(ONSQLAuthenUser_txt;" ")) *CHANGE CURRENT USER*("SQL_ReadOnly";"12345") *: *(*User in

Re: 4D v16.2 false record locks

2017-09-18 Thread Charles Miller via 4D_Tech
This has been a longstanding issue. When I first wrote Informed RecordLock(tm) component in v11. Even after I put all tables in read only mode, I could and did lock records using select with lock. Some remained locked after process ended. Regards Chuck On Mon, Sep 18, 2017 at 10:10 AM, Jeffrey

Re: ODBC import from Access into v15

2017-09-20 Thread Charles Miller via 4D_Tech
ns.com > On Sep 19, 2017, at 12:46 PM, Charles Miller via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Hi all, > > I have a db that is used to convert some data. When it was a v11 database, > I had no trouble importing from access data file >

ODBC import from Access into v15

2017-09-19 Thread Charles Miller via 4D_Tech
Hi all, I have a db that is used to convert some data. When it was a v11 database, I had no trouble importing from access data file Using same ODBC connection I can not import to v15. Anyone importing from access and if so how. Regards Chuck --

macros documentation

2017-09-07 Thread Charles Miller via 4D_Tech
Hi All I have looked on 4d and perhaps I am blind, but I am looking for documentation on Macros. Where might I find it Regards Chuck -- - Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064 Informed

Re: macros documentation

2017-09-07 Thread Charles Miller via 4D_Tech
wrote: > Hello, > > Here is the documentation : > http://doc.4d.com/4Dv16R3/4D/16-R3/Creating-and-using- > macros.300-3230741.en.html > > Regards, > > Olivier > > > > > > Le 7 sept. 2017 à 17:40, Charles Miller via 4D_Tech < > 4d_tech@lists.4d

Re: Convert 4D data MSSQL

2017-09-07 Thread Charles Miller via 4D_Tech
One more thing. If you can create a true stored procedure in MS sql server. and execute by passing in that would be faster ads well Try this link https://technet.microsoft.com/en-us/library/ It will show you transact sql server commands etc On Thu, Sep 7, 2017 at 5:21 PM, Justin Will via

Re: Connecting to SQL on a PC

2017-09-12 Thread Charles Miller via 4D_Tech
The same way, except the drivers are already there. There is an ODBC admin function similar to Mac Log in could be different depending on how access is set up. Regards Chuck Chuck Miller Voice:

Re: 4D crash

2017-10-02 Thread Charles Miller via 4D_Tech
I am not having this problem but I would remove kaspersky and not use US security feel a it is hazardous. Have you run mac on structure. If not you should Regards Chuck On Fri, Sep 29, 2017 at 2:15 AM stardata.info via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi All, > > I use 4D V13 an V15 on

Re: 4D crash

2017-10-02 Thread Charles Miller via 4D_Tech
As I said virus detective probably not related to crash. Kaspersky is on unacceptable list for US govt and many states. Have you tried MSC have you tried with an new empty data base Regards Chuck On Mon, Oct 2, 2017 at 10:31 AM stardata.info via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi

Re: 4D server "pausing" every 15 minutes

2017-08-24 Thread Charles Miller via 4D_Tech
I have noticed similar issues when using 4D fn calls from single user to 4D. when testing with light load not problem and it appears it is not a synchronous call but under any regular to heavy load, it appears synchronous. Indeed at 2 or 3 summits again Neil Dennis and I had this discussion. He

Re: 4D Server v11 License

2017-08-21 Thread Charles Miller via 4D_Tech
It does not, but once again I would hope 4D would chime in here. Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 mailto:miller.cjaygmail.com

Re: Can't start a Transaction

2017-11-14 Thread Charles Miller via 4D_Tech
Perhaps the object does not have an on clicked event. In any case how do you know it has not started. Have you put trace there to see if the event fires Regards Chuck On Tue, Nov 14, 2017 at 4:53 PM, John Baughman via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I have button on an input form I am

Re: localisation (again)

2017-12-12 Thread Charles Miller via 4D_Tech
If this is always a long why is the striking .XX or ,XX It might be simpler but I would first doa substrinmg from 1 to position of either , or . and then a num on that. You will have to identify what system you are on and what localization is set to and then understand what localization

Re: Twin Process for 4D SQL Data Source

2017-12-13 Thread Charles Miller via 4D_Tech
Hi Alan, Is there not a command that allows you to switch. I seem to remember somethingt like Use Local but could not find it Regards Chuck On Wed, Dec 13, 2017 at 1:12 PM, Alan Tilson via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hello Chuck, > You are probably right. I just counted 14

wa open url command in v15

2017-11-16 Thread Charles Miller via 4D_Tech
Hi All, I am using this command to open a pdf file on a 4D form. It does not work on everyones mac. (I don’t know about PC’s) I have the web area set as follows: opem external link checked Use integrated web kit checked Access 4D methods checked Preview is default pdf viewer on both machines

Re: 4D Backup causes 4D Remote to hang (15.4)

2017-11-14 Thread Charles Miller via 4D_Tech
I would quit 4D server, delete preferences and recreate using menu commands re backup. Perhaps that us trhe problem. Also check where the backup is going to if a HD try a different location Regards and hiope this helps Chuck On Tue, Nov 14, 2017 at 10:25 AM, Jim Crate via 4D_Tech <

Re: 4D v6.8

2017-11-21 Thread Charles Miller via 4D_Tech
riginal MacBook > air. > > Jody > > > On Nov 16, 2017, at 2:32 PM, Charles Miller via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > Great idea I have 10.6.8 server running as a VM ware partition for > exactly > > that reason. Jody, if you can nto get this

List box issue

2017-11-21 Thread Charles Miller via 4D_Tech
I know I have seen this before. I have a list box on a window opened with dialog. The list box is not visible all the time, The entire height of the list bnox does no show unless I manually resize the window. When I do it does. I can not remember what the fix is. The list box is array based and is

Re: wa open url command in v15

2017-11-16 Thread Charles Miller via 4D_Tech
Try removing it. > > http://osxdaily.com/2014/10/05/delete-adobe-acrobat-reader-safari-plugin/ > > John DeSoi, Ph.D. > > > > On Nov 16, 2017, at 11:13 AM, Charles Miller via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > Even with that setting, on my m

Re: wa open url command in v15

2017-11-16 Thread Charles Miller via 4D_Tech
Miyako posted. > I've been using if for a while and works with PDFs and pretty much any > other type of file. > > > On Thu, Nov 16, 2017 at 9:13 AM, Charles Miller via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > Hi All, > > > > I am using this command to o

Re: 4D v6.8

2017-11-16 Thread Charles Miller via 4D_Tech
Great idea I have 10.6.8 server running as a VM ware partition for exactly that reason. Jody, if you can nto get this I will be more than happy to install 6.87 and remove whatever you tell me from the source. I bought 10.6.8 server from Apple for about 20 bucks. I would bet it is still available.

Re: open gmail in browser from 4D

2017-11-02 Thread Charles Miller via 4D_Tech
Good try but no. I want to open a new mail message from inside a 4D application. When I enter open url(“mailto:some mail”;"https://mail.google.com/“) it still opens my default email program. I tried downloading the gmail application but that does the same thing. Regards Chuck On Wed, Nov 1,

Re: [Warning] Settings properties values on object field by object notation

2017-10-31 Thread Charles Miller via 4D_Tech
It must be a duck, cause calling this standard behavior is quackers. There are many issues with object fields. I for one refuse to use them (Yes I know how powerful they are and can be) as I do so much with sql and can not get them using a sql statement. I have commented before that 4D should not

Re: Help with SQL login

2018-05-09 Thread Charles Miller via 4D_Tech
Try adding the port to ip address and I always connect using IP not DB so connection would look like 192.168.5.12:19812 Regards Chuck On Wed, May 9, 2018 at 4:47 PM, Stephen Shaw via 4D_Tech < 4d_tech@lists.4d.com> wrote: > > > Chuck > > Thanks for answering > > SQL is running and shows the

Re: Failed To Create A Listening Socket ?

2018-05-11 Thread Charles Miller via 4D_Tech
Make sure this is only instance of 4d running on machine Regards Chuck On Fri, May 11, 2018 at 12:51 AM Wayne Stewart via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Allan, > > On any 4D port is what I meant (the db engine port, the sql port, the > web port etc etc etc) > > Regards, > > Wayne > > >

Re: Web Service Call in 4Dv15

2018-05-11 Thread Charles Miller via 4D_Tech
Are you running new version on a different machine. Are any of the ports blocked. Can you try reaching another soap server outside and see if that works. You could set up a test as a developer and create your own call structure Regards Chuck On Fri, May 11, 2018 at 7:06 AM Ronnie Teo via

Re: Standalone application connection to 4D Server

2018-05-08 Thread Charles Miller via 4D_Tech
It all depends. How much data is exchanged? How automated do you need it to be? How often will you be doing this? Is data movement bi-directional? The most straightforward IMO is SQL, but you could also use SOAP, text(XML files), HTTPS Regards Chuck On Tue, May 8, 2018 at 10:48 AM, David

Re: Standalone application connection to 4D Server

2018-05-08 Thread Charles Miller via 4D_Tech
If you use SQL there is no additional licensing needed. The other SOAP or HTTPS means another license either for soap server or web server on the 4d server Regards Chuck On Tue, May 8, 2018 at 11:53 AM, Kirk Brooks via 4D_Tech < 4d_tech@lists.4d.com> wrote: > David, > What version of 4D are

Re: setting up mirror

2018-05-15 Thread Charles Miller via 4D_Tech
Thanks for your update. I assume you have a process on mirror that runs and delays itself for x amount of time. What happens if you try and create a second log but first has not been integrated. What do you do? Would you mind sharing code. I know it should be pretty simple, but I always would

Re: setting up mirror

2018-05-15 Thread Charles Miller via 4D_Tech
OK I guess I knew that but what happens if you never do a backup (We will not be backing up the master data file any longer. Are You?) to numbers in second part, when the last one is Datafile[0004-].journal Regards Chuck On Tue, May 15, 2018 at 3:25 PM, Tim Nevels via 4D_Tech <

stylized text

2018-05-22 Thread Charles Miller via 4D_Tech
Given the following *ST SET PLAIN TEXT*($StyleNote_txt;"Note : As of July”) *ST SET ATTRIBUTES*($StyleNote_txt;1;4;Attribute bold style;1) Where should the text be bolded. One might think all of the word Note, but it does not. If you change the code to *ST SET

Re: stylized text

2018-05-22 Thread Charles Miller via 4D_Tech
between characters. > > | a | b | c | d | e | > 1 2 3 4 5 6 > > WP > > range.start, range.end, WP SELECT, WP SET ATTRIBUTES, etc. > > count characters > > a b c d e > 1 2 3 4 5 > > 2018/05/23 5:44、Charles Miller via 4D_Tech <4d_tech@lists.4

Programmatic control of reject new connections

2018-05-24 Thread Charles Miller via 4D_Tech
Hi All, subj says it all;. Has anyone figured out a way to control this setting via program? If it can be done can anyone please advise how. If not would others like the ability to do this. I would so that when I distribute new versions, I can start with that set when I have code that has to

Re: setting up mirror

2018-05-15 Thread Charles Miller via 4D_Tech
I assume that means you rename the .journal file to something like DataFileXX.journal, where X is nex number in line or DataFile.X where extension is next number in line or better yet DataFileMMDDHHMMSS.journal. That way unless run more than once per second you will

Re: __Orphan___xxxx methods

2018-06-09 Thread Charles Miller via 4D_Tech
They are not just fro deleted forms. I havr checked many times and have only found very few that were missing, so I always check them out On Sat, Jun 9, 2018 at 11:28 AM Chip Scheide via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I believe that mostly they are object methods from deleted forms, >

Re: Printing Write Pro to PDF

2018-06-19 Thread Charles Miller via 4D_Tech
I think it sued work if you set window title to the name, the document would have that name. Not sure about now. Regards Chuck On Tue, Jun 19, 2018 at 5:10 PM, Randy Jaynes via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Has anyone successfully used WP Print to print a 4D Write Pro area in v16 >

Re: mobile? wot?

2018-05-31 Thread Charles Miller via 4D_Tech
I think second half is optimistic right now I think concentrating I IOS only. Android may come by I wouldn’t hold my breath Chuck On Thu, May 31, 2018 at 1:28 PM Mike Kerner via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hello, 4D whackers, it's been a while. > I just saw an email from LR and the

Re: add file from disk to 4dwrite area

2018-06-03 Thread Charles Miller via 4D_Tech
I think you need to convert form pdf or pict to a JPEG or png. Picts are deprecated by Apple ad well as 4d. PDFs can not be viewed in that way on PCs Chuck On Sun, Jun 3, 2018 at 10:54 AM 4dialog via 4D_Tech <4d_tech@lists.4d.com> wrote: > Is there a way to add a picture/ pdf file from disk to

character count in 4d Write

2017-12-27 Thread Charles Miller via 4D_Tech
Hi all, Environment 4D 15.5 client server. On Mac client I have been using *WR SET SELECTION *($mainarea;*WR Count *($mainarea;wr nb characters);*WR Count *($mainarea;wr nb characters)) I find the number returned is not really at the end, as whem I append another 4D write area. gthe last 2 or 3

Re: Curious about "functional programming"

2017-12-21 Thread Charles Miller via 4D_Tech
I view it a little differently although my CS backround is old (graduated in 1983 with MS)., Procerdural is a style which is baed upon a language, COBOL for example ios a procedural based language. C++ is an object based language. Not sure if this helps Happy holidays to all and to all a good

Re: MS SQL Server Deletion Issue

2017-12-21 Thread Charles Miller via 4D_Tech
Hi ware you connecting to SQL server. Are you logging in or using windows autghentication fiorm machine. I woiuld try the other and see if there is a difference Regards Chuck On Thu, Dec 21, 2017 at 3:04 PM, Stephen J. Orth via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Is there a known issue in

Re: Query Editor Date format not available...+

2018-01-11 Thread Charles Miller via 4D_Tech
In addition. I know this is cosmetic, but it bothers me. The form header is query, the button displays query and the drop down displays search in selection. Shouldn’t it be query in selection Regards Chuck On Thu, Jan 11, 2018 at 4:22 AM, Ingo Wolf via 4D_Tech <4d_tech@lists.4d.com > wrote: >

Re: Can I use METHOD GET NAMES in the Host to get methods from a component?

2018-01-18 Thread Charles Miller via 4D_Tech
Don’t think so. In any event it would only return available methods (those shared between component and host) so you would not get all any way Regards Chuck On Thu, Jan 18, 2018 at 3:22 PM, Kirk Brooks via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Doesn't look like it but maybe there is

  1   2   3   >