Re: Question about storing data outside of datafile

2017-02-17 Thread Chuck Miller via 4D_Tech
When I wrote a document management system, I used FTP to move files to correct locations, which included creating directory etc. FTP is agnostic. No problem with bob to server etc. Another approach might be to create another table that holds document in a blob. On server have a process that

using sql to duplicate remote structure

2017-02-17 Thread Chuck Miller via 4D_Tech
Hi All, I know I have seen commands to do this but can not find on 4d.com. Can someone point me in the right direction to system table documentation Thanks and regards Chuck Chuck Miller Voice:

Re: Emailing from 4d issues

2017-02-28 Thread Chuck Miller via 4D_Tech
Why not look at all headers from a 4D mail that failed and one from outlook that succeeds. Additionally, I have found that authorization is yours not their problem Regards Chuck Chuck Miller

Re: Virtualization - Yea or Nay

2017-02-27 Thread Chuck Miller via 4D_Tech
My thoughts exactly. I had a client that was using VMs for both development and production. All was AOK until they wrote a custom plugin. While testing the plugin on my machine single user all worked great. While testing on virtual. It simply did not work. I spent about 4 weeks trying to fix a

can i do the following in v15

2017-03-30 Thread Chuck Miller via 4D_Tech
I have added fields to table_1 in source code version B. Can I go back to Version A, add fields to a different table. and then add same fields to version B without causing any issues. Source code B has other changes in it that the customer is not ready to implement, but needs the change in

Re: XML or rest services

2017-03-29 Thread Chuck Miller via 4D_Tech
Thanks that's kind of what I thought you would then use 4d tags to get data into table and fields. Is that correct? Sorry for being dense but I do not do any of this type of coding. Regards Chuck Sent from my iPhone > On Mar 29, 2017, at 12:39 PM, Bruno LEGAY via 4D_Tech

XML or test services

2017-03-28 Thread Chuck Miller via 4D_Tech
Hi all for a new client they are asking to implement xml post and get to transfer data to a server. I think rest might be easier can anyone advise. Are there example databases that illustrate either from summit or tech support. Thanks as I don't have much experience in this Regards Chuck

Re: Read Only 4D Server

2017-03-27 Thread Chuck Miller via 4D_Tech
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 > On Mar 25, 2017, at 5:34 PM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Write a

Re: check for duplicates in v15

2017-04-04 Thread Chuck Miller via 4D_Tech
Thanks that must be it I should remember that Regards Chuck Sent from my iPhone > On Apr 4, 2017, at 5:41 PM, Wayne Stewart via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Only the first 1024 characters are indexed. ** 4D

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

2017-04-05 Thread Chuck Miller via 4D_Tech
I just purchased the following: MacBook Pro (Retina, 15-inch, Mid 2015) Processor 2.5 GHz Intel Core i7 memory 16 GB 1600 MHz DDR3 Graphics Intel Iris Pro 1536 MB I had a similar tricked out 2011 machine (16 gig ram, 1 terabyte SSD, replaced dvd with 240 Gig sad). I am really happy with this

run do not walk to roadshow

2017-04-10 Thread Chuck Miller via 4D_Tech
Hi All, If you are not signed up yet for Roadshow and class and one is near you sign up. I know it is hard when a consultant to give up one or two billing days. I always view it as follows. If I get one or two nuggets that I can use within the next few months it is worth it. Needless to say I

Re: Why would you do this? (Execute Formula Question.)

2017-04-20 Thread Chuck Miller via 4D_Tech
Not only do you probably do not need execute you could write in one line of code Object set enabled(button;$1) Regards Chuck Sent from my iPhone > On Apr 20, 2017, at 2:52 PM, Lee Hinde via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I got bit last night with this code: > > *C_BOOLEAN*(*$1*)

Re: PK wizard, how to start?

2017-04-13 Thread Chuck Miller via 4D_Tech
I would not use there have been many posts on how to add primary keys. Whatever tack you take create fields in db while connected ti an empty db and then open real one. I have found that with large dbs, component from 4D bogs down and it is took easy to make a mistake. If desired, I will post

Re: Automated tasks on 4D Server

2017-04-19 Thread Chuck Miller via 4D_Tech
I sell a component that does this. Free to develop. It is sold to run on server, which in production will need a license. Developer version only runs for about 8 hours. If you want I can forward documentation as well as component for you to test with, please advise Regards Chuck

Re: Tables created with SQL CREATE TABLE command and triggers

2017-03-07 Thread Chuck Miller via 4D_Tech
Yu could simply create tables with only journal field and allow users to adjust as need be. Set triggers to run as needed and uses footprints to run trigger method. I know this last part is not pretty but it may work Regards Chuck

Re: PDFCreator and Windows 7

2017-04-14 Thread Chuck Miller via 4D_Tech
Yup install version 1.2.? they changed comm interface and till it is stable you can not use a new version than that. I will check next wednesday for version we are using at client. I will not be there till then Regards Chuck

Re: Restricting a query

2017-07-31 Thread Chuck Miller via 4D_Tech
Not sure if views work with normal query but I would start there. Regards Chuck Sent from my iPhone > On Jul 31, 2017, at 2:34 PM, 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

Re: Someone help me out, how do you get good information out of 4D

2017-07-13 Thread Chuck Miller via 4D_Tech
Oh come on know many are still around it is just that the circumference has changed Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

Re: 4D Not Seeing A Mounted Network Drive

2017-07-11 Thread Chuck Miller via 4D_Tech
what is the error? It may be do to permissions? It may be due to syntax. I create folders all the time on mounted volumes Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc.

Re: revelation! - Choose

2017-07-06 Thread Chuck Miller via 4D_Tech
You mean you have not memorized all the commands. I am depressed and disappointed in you.  Chuck Sent from my iPhone > On Jul 6, 2017, at 12:45 PM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Thanks to code from Robert Livingston > I found out about a command I had not

Re: Bug with Open Document on macOS Sierra

2017-07-25 Thread Chuck Miller via 4D_Tech
If there are object scripts they run before form method Regards Chuck Sent from my iPhone > On Jul 25, 2017, at 6:51 PM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > 've verified the "no code runs" part both by setting a break point in the > first line of the form method of

Re: An efficient printing approach...

2017-06-30 Thread Chuck Miller via 4D_Tech
I agree you must remove this document. It is fraught with danger to keep there for you. There are massive fines for breaking HIPPA laws Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed

Re: SQL

2017-07-05 Thread Chuck Miller via 4D_Tech
You can simply check field length for phone. I would assume it had something to do with data inconsistency. perhaps insert length too long, or blank for a non NULLAble field Regards Chuck Chuck

Re: QR code

2017-04-26 Thread Chuck Miller via 4D_Tech
It is also built into hm reports. Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 mailto:cjmillerinformed-solutions.com Brookline, MA 02446

Re: Diff 4D Write Documents

2017-04-25 Thread Chuck Miller via 4D_Tech
One other recommendation is to use generate digest to get a hash if hash is same docs are the same Regards Chuck Sent from my iPhone > On Apr 25, 2017, at 10:57 AM, Charles Miller via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > On Mon, Apr 24, 2017 at 5:20 PM, Douglas von Roeder via

Re: Diff 4D Write Documents

2017-04-27 Thread Chuck Miller via 4D_Tech
I would still store difference and not do it on demand Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 mailto:cjmillerinformed-solutions.com

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

2017-04-28 Thread Chuck Miller via 4D_Tech
If you compile with all variables typed and do not generate typing you will get a list of errors and can fix. Certainly it becomes a habit ingrained over time Regards Chuck Chuck Miller Voice: (617)

Re: Re(2): 4D db -> SAAS

2017-07-31 Thread Chuck Miller via 4D_Tech
You could split it between different server apps. 200 connections would not be too bad but 1 would be a stretch, so I would have different server apps colocated near customer with built clients. You could also create a web access using active4D, lightening 4D (available from foundation

Re: Missing Pict - 64bit Removes pictures from library

2017-08-09 Thread Chuck Miller via 4D_Tech
You are missing one line of code TRANSFORM PICTURE($Pict_G;Transparency;0x00FF) This will set white background to clear. regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions,

Re: ​Re: UUID vs Longint primary key

2017-08-06 Thread Chuck Miller via 4D_Tech
I am not David but I agree with his assessment. Relational model databases by definition are not supposed to use keys that have no meaning. They are supposed to create relations that have meaning. Even the use of numbers breaks the theoretical rule. The problem is that we have pushed all to use

Re: Preventing Duplicate Data WAS UUID vs Longint primary key

2017-08-07 Thread Chuck Miller via 4D_Tech
perhaps you can use sounded and store that in a hidden field. Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

Re: POINTER TO ARRAY

2017-05-10 Thread Chuck Miller via 4D_Tech
Pointers to locals do work. I pass locals via pointer from method to method all of the time Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

Re: SMTP error 10113 Error with Authentication

2017-05-10 Thread Chuck Miller via 4D_Tech
Is the sending email a gmail account by any chance? Can you try with a different email address/ not gmail? Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617)

printing listbox v 15.4hf2

2017-05-17 Thread Chuck Miller via 4D_Tech
Hi All, I thought there was a tech note on printing list boxes. I need to create and print a hierarchical list box. Specifically a Bill of Material as part of a larger page. Is this possible as part of a printed page. and if so where might I find example to speed me on my way Regards Chuck

Re: built client and versions

2017-05-17 Thread Chuck Miller via 4D_Tech
I know that problem is that at this account we can not allow this type of updates as PCs have special install procedures every time they restart machine OS image etc is downloaded Thanks anyway and regards Chuck Sent from my iPhone > On May 17, 2017, at 3:52 AM, Koen Van Hooreweghe via

Re: How to trap a form save keystroke in an object method ?

2017-05-19 Thread Chuck Miller via 4D_Tech
How about disabling the button until all values are OK. This when you enter a variable or field on form disable and when you exit enable only if pass. Regards Chuck Chuck Miller Voice: (617)

Re: V16 on OSX Application licence

2017-05-19 Thread Chuck Miller via 4D_Tech
You will have to go to system preferences as admin, change to allow any program (only for a moment). Launch new application. If it launches quit Change your preferences back. The next time you launch all should be well I do not think you can easily change to identified app as those come from the

Re: V16 on OSX Application licence

2017-05-19 Thread Chuck Miller via 4D_Tech
Perhaps I am remembering older versions, but it often asks if I want to open the first time I launch Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

Re: V16 on OSX Application licence

2017-05-19 Thread Chuck Miller via 4D_Tech
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

Re: Get table fragmentation

2017-05-30 Thread Chuck Miller via 4D_Tech
One more thing if you are running using SSDs I do not think fragmentation is an issue? Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

Re: Data mining from Oracle Application using 4D

2017-06-02 Thread Chuck Miller via 4D_Tech
We are using native 4d sql and odbc works like a charm. On Mac we are using actual technologies oracle driver. Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617)

running in windows virtual environment question

2017-06-16 Thread Chuck Miller via 4D_Tech
Hi All, At one of my clients we will be running a mirror server and emergency server on windows VMs. It appears that the VMs have more than one IP address a public (172.18.17.xx and private 192.168.26.xx). Can someone advise if this will work and if so is there anything special I need to do.

Re: read from a MS SQL server with 4D

2017-09-13 Thread Chuck Miller via 4D_Tech
As I have said before Microsoft's own web site. See below is a great resource https://docs.microsoft.com/en-us/sql/sql-server/sql-server-technical-documentation Regards Chuck Chuck Miller Voice:

Re: SFTP - Native to 4D?

2017-09-13 Thread Chuck Miller via 4D_Tech
If you look in the archive you will find examples of using applescript to do this Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

Re: What to do about users who won't follow instructions?

2017-10-04 Thread Chuck Miller via 4D_Tech
Yes this is true but tips who do not remember history are doomed to repeat it. A person who consistently does not read instructions fully and then complains may never. Just remember they are customer and tell them you will have to bill them if they continue to not follow instructions, as this

Re: What to do about users who won't follow instructions?

2017-10-04 Thread Chuck Miller via 4D_Tech
OK how about another option Implement foot runner ? and send a file to execute. One line of instructions. Here run this! Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617)

Re: 4D v16.2 false record locks

2017-10-15 Thread Chuck Miller via 4D_Tech
I assume he flew 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

Re: 4D Server 15.3 crashes a server when choosing a datafile

2017-09-06 Thread Chuck Miller via 4D_Tech
Have you tried creating a new data file? What happens if you launch the last good structure? Do you really mean machine crashes or is it the application ? Hope this helps Regards Chuck Sent from my iPhone > On Sep 6, 2017, at 1:15 AM, Paul Lovejoy via 4D_Tech <4d_tech@lists.4d.com> > wrote:

Re: Convert 4D data MSSQL

2017-09-07 Thread Chuck Miller via 4D_Tech
You might try to use arrays to update and not individual records Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

Re: Love 4D's math interpretation...

2017-09-28 Thread Chuck Miller via 4D_Tech
Are just discovering this this has been 4D since version 1.x. Math precedence is only with parens. That is why I often perform calculations on multiple lines. Make it easier to read Regards Chuck

Re: 4D v16 issues

2017-09-25 Thread Chuck Miller via 4D_Tech
You might but be aware if you use cross table reports in quick reports, they are not as yet available in 64 bit client. If you compile 64 bit server and 32 bit client on macs you use the new network layer Regards Chuck

Re: 4D Server v11 License

2017-08-22 Thread Chuck Miller via 4D_Tech
They can not be legit buying license in this way Regards Chuck Sent from my iPhone > On Aug 21, 2017, at 9:06 PM, Ronnie Teo via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Hi, thanks for your replies. > The reason why the customer needs v11 server is this These are new > users from a

Re: SQL Pivot

2017-10-04 Thread Chuck Miller via 4D_Tech
In 4D? I have not looked but don;t believe it is implemented. If using SQL server try the following web site for help https://technet.microsoft.com/en-us/library/ Regards Chuck

Re: 4D Client as Web Server - How to monitor

2017-10-04 Thread Chuck Miller via 4D_Tech
Couldn’t you launch a server process and look for web server running on a client? I don’t use web server so don’t know if a name or what name is there. but if it is you can find out if running already Additionally I believe execute on client does exist. Not sure but you could launch a server

Re: Export import all after a crash

2017-10-22 Thread Chuck Miller via 4D_Tech
Or you could use in error call and simply skip the bad records. I would also try opening I. C/S and use sql to fill a me empty data file you can use same on error stuff. Regards Chuck Sent from my iPhone > On Oct 22, 2017, at 1:20 PM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> > wrote:

Re: localisation (again)

2017-12-12 Thread Chuck Miller via 4D_Tech
Much better than my choice which was substring till the period and then num Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

Re: Twin Process for 4D SQL Data Source

2017-12-13 Thread Chuck Miller via 4D_Tech
I have not but it seems to me to be a lot of work as you will have to get data/orrays/variables between processes and it would also seem to me that you could choose only one to put in a new process Regards Chuck

Re: Drop Down Menu Form Event

2017-11-17 Thread Chuck Miller via 4D_Tech
I would always use on clicked for drop downs, combo boxes, check boxes, buttons, radio buttons. Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

mirror set up

2017-11-17 Thread Chuck Miller via 4D_Tech
Hi All, we are finally going to implement mirrors at one of my clients. For a variety of reasons, we are not going to use soap. I was thinking of the following options 1. One main machine create new log, copy to shared volume Now I can branch Option 1. Create a second text file that the

Re: 4D v6.8

2017-11-14 Thread Chuck Miller via 4D_Tech
I think that machine is much too new I used to keep a really old machine around just for that but gave up Regards Chuck Sent from my iPhone > On Nov 14, 2017, at 11:16 AM, Jody Bevan via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > my old (1st version of MacBook Air has on it) That just

Re: 4D v6.8

2017-11-13 Thread Chuck Miller via 4D_Tech
You can contact 4d Sales they can give you an ftp address. If this does not work, email me directly and I will look at my old CDs from 4D Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed

Re: SQL error

2017-11-01 Thread Chuck Miller via 4D_Tech
Hi all I have noted in the past that fn calls fail when you have an existing method turn it into fn call and r5un unless you restart. If you create a new method and mark as fn no restart is needed. Regards Chuck

open gmail in browser from 4D

2017-11-01 Thread Chuck Miller via 4D_Tech
Hi All 4d Version 15.x. I want to be able to open a new mail message when company uses google mail in a browser window. Google hosts their domain. Has anyone done this. I need a solution for macs and windows. Has anyone done this. I have tried open URL and it only opens Mail on my mac. Not

Re: Tip: Exporting to a target folder in a package

2017-10-24 Thread Chuck Miller via 4D_Tech
Why would you let users put stuff in resources folder. The problem is if you are on client server client adds to resource folder how do you get document to server when you next deliver version to client resource gets overwritten when connecting to a new version Chuck Sent from my iPhone >

Re: Primary Key in 4Dv15

2017-10-24 Thread Chuck Miller via 4D_Tech
If you are not too far along I would consider not using 4Ds built in method to create these keys. I and others have posted code to do this. Second you can check tables to ignore primary keys but that means data will not be backed up for those tables Regards Chuck Sent from my iPhone > On

Re: Primary Key in 4Dv15

2017-10-24 Thread Chuck Miller via 4D_Tech
Sorry I disagree create new key fields in v15 with empty data file just don't use built in stuff roll your own. Then when you open real data file all will work as expected. You can not make type of uuid before v15 as far as I know Regards Chuck Sent from my iPhone > On Oct 24, 2017, at 6:22

Re: identify duplicates

2017-10-31 Thread Chuck Miller via 4D_Tech
As has been recommended distinct values is your friend but it really depends upon what you mean by duplicates. For example Charles and Karl are the same name but in different languages. So what do you mean by duplicates. Also is case important or do able and Able equal each other Regards

setting up mirror

2018-05-14 Thread Chuck Miller via 4D_Tech
Hi All, I am finalizing code to set up a mirror and then an emergency server. I have two trains of thought, both of which use a shared folder to move the log file into Option 1 Create a second text file after the journal has been copied and on the mirror, have a process that runs every x

Re: Help with SQL login

2018-05-09 Thread Chuck Miller via 4D_Tech
Are you sure that 1. SQL server is running 2. you are trying to connect to same place Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

Re: Picture Buttons in v16

2018-05-09 Thread Chuck Miller via 4D_Tech
This is the code we used //Method: dev_convertPicLibToJPEG //Description //convert picture library pictures to JPEG for upgrade to v16 - set transparent background // Parameters // If (User in group(Current user;"Design Access

FN call issues

2018-05-07 Thread Chuck Miller via 4D_Tech
Hi all, Environment 4D 15.6 windows server running 32 bit mac 4D running 32 bit version of 4D I log into server using sql and run code that looks like text_txt:=select {fn MethodName() as text from [tablename] into :global variable;” sql login begin sql execute immediate : text_txt; end

Re: stylized text

2018-05-23 Thread Chuck Miller via 4D_Tech
HI Thanks for the info. I think it would be a great idea to put this in the documentation, as it is far from intuitive. This is especially true when working from the first character in the text. I for one would never see that there was a space counted in position one even though t did not

connect to a pervasive sql database

2018-05-23 Thread Chuck Miller via 4D_Tech
Hi All, Has anyone done this. I am looking to select some data from a table and import into customer 4D database so as to mark invoices paid. Is the driver only available for windows or is there a UNIX version that can be used on a MAC Thanks and regards Chuck

Re: v13+ Progress component, and other components

2018-06-11 Thread Chuck Miller via 4D_Tech
What happens if you check this method as shared. Remember you are running in your own process. Not sure if this does anything. Regards Chuck Sent from my iPhone > On Jun 11, 2018, at 10:21 AM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > closing the progress object >

Mirror and backup

2018-06-08 Thread Chuck Miller via 4D_Tech
Hi All, I am just writing and testing code to have a mirror server and have a few questions 1. I assume that we will be backing up mirror on a daily basis? Does this cause any problems? 2. If we try and integrate a log file when backup is running what happens? 3. If we are integrating a log

query issue

2018-06-07 Thread Chuck Miller via 4D_Tech
env v 15.x I have the following set up order table order line table related auto to order invoice line table related auto to order line packing list table related auto to invoice one table I have the following queries QUERY([Order];[Order]Order_ID=$OrderIDS_aL{$Loop_L}) // on record found

Re: Time Machine error -8003 when restoring 4D structures

2018-06-18 Thread Chuck Miller via 4D_Tech
It does. How about using 4d backup and then backing that up.You could run it every hour on your structure only. Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617)

Re: Delay process bug

2018-06-18 Thread Chuck Miller via 4D_Tech
i use delay process for years with no issues, however, I do not think I ever delay for more than 15 minutes. Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

Re: Delay process bug

2018-06-13 Thread Chuck Miller via 4D_Tech
What does that mean? If you have a cron job process running on server that wakes every 5 minutes to check and launch other processes. Is that what you consider short term scheduling? Regards Chuck

issue on windows 10 and 4D 15

2018-06-15 Thread Chuck Miller via 4D_Tech
Hi All, I have one windows ten machine where pictures of buttons do not display properly. They do on all other instances. We have deleting local files, reinstalling 4D, to no avail. Any ideas out ther greatly appreciated Thanks and regards. Chuck

Re: issue on windows 10 and 4D 15

2018-06-15 Thread Chuck Miller via 4D_Tech
Buy that will be a lot of work. I would guess I can run code to change all pict to pngs in the library. I do not think it is just one form. That is the problem BTW the right click and changes did not seem to work Regards Chuck

select from _USER_COLUMNS

2018-06-11 Thread Chuck Miller via 4D_Tech
Given the following code select COLUMN_NAME, DATA_TYPE, DATA_LENGTH, COLUMN_ID from _USER_COLUMNS where TABLE_ID = :$TableNumber_L into :$Cname_atxt, :$DataType_aL, :$DataLength_aL, :$ColumnID_aL; What values can be returned in $DataType_aL It seems that they do not equal 4D data types (I

Re: Updating a structure - data goes AWOL

2018-06-14 Thread Chuck Miller via 4D_Tech
How about using sql to bring data from old database into new one Regards Chuck Sent from my iPhone > On Jun 14, 2018, at 8:36 PM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I'm updating a client's database from an old version of my app, in 4D v12, > to the latest version,

Re: RIP Sujit Shah

2018-06-22 Thread Chuck Miller via 4D_Tech
Also, not sure I ever met him, but my thoughts and prayers are with his family Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

crashing issue in v15 and v16

2018-06-20 Thread Chuck Miller via 4D_Tech
Hi All, In light of the wingdings issue on windows ten, I wrote the following two methods Please note that if you have a write pro are on a form, the bolded line crashes on Macs every time. I have tried v15.6, v16r6 both 32 bit and 64 bit Hope these help someone else out Regards Chuck Begin

Re: Uppercase Lowercase

2018-06-20 Thread Chuck Miller via 4D_Tech
If using sql you can select case sensitivity, but be careful, as it will be set for every sql query where clause Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax:

Re: Primary Key in 4Dv15

2017-10-26 Thread Chuck Miller via 4D_Tech
OK this works in one way. However, if you have a primary key named something else it will fail use the following code to return primary key column number C_LONGINT($0;$1;$TableNumber_L) $TableNumber_L:=$1 $Primary_key_field_id_L:=-9 C_TEXT($ConstraintID_txt) C_LONGINT($Primary_key_field_id_L)

Re: problems with SEND RECORD

2018-07-03 Thread Chuck Miller via 4D_Tech
OK If you are going to do this, why not go all the way C_LonGINT($RECORDSINTABLE;$ALLRECORDS;$NOTAPPROVED;$APPROVED) $RECORDSINTABLE:=RECORDS IN TABLE([Approvals]) > ALL RECORDS([Approvals]) > ALLRECORDS:= Records in selection([Approvals]) SET QUERY DESTINATION(INTO VARIABLE;$NOTAPPROVED)

Mirror design question

2018-01-08 Thread Chuck Miller via 4D_Tech
Hi All, environment v15 production machine mac Mirror windows box I have a table that is used to control cron jobs. I can do one of the following 1. Not include this table in journal so it never moves to the mirror. 2. Add a field to the table that is text (Production or Mirror) If I do this

Re: "Are you sure you want to open the structure file in read only mode" - Windows 7

2018-01-11 Thread Chuck Miller via 4D_Tech
I always install directly on c:/My apps name folder/My app Fir built servers. I even have had trouble running off C drive at all, so i have taken to installing on a second drive. Regards Chuck

Re: SMTP error 10113 Error with Authentication

2018-01-24 Thread Chuck Miller via 4D_Tech
when using gmail at least you need the SMTP_Auth ($smtp_id_l;MAIL_UserName_s;MAIL_Password_s;2) to have the additional param (2) to match with smtp port 587 which is secure Hope this helps Regards Chuck

Re: The writing is on the wall

2018-01-25 Thread Chuck Miller via 4D_Tech
Unless something has changed, it is not just plug ins quick report on 64 does not support cross tab reports Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617)

Re: Document capture

2018-01-25 Thread Chuck Miller via 4D_Tech
Yes the O/S is fine but if you ever want to open the folder on a PC or MAC be prepared to wait. The more files the longer the wait. At least that has been my experience Regards Chuck Sent from my iPhone > On Jan 25, 2018, at 3:35 PM, Peter Bozek via 4D_Tech <4d_tech@lists.4d.com> > wrote:

Re: Object focusable/tabable properties

2018-01-24 Thread Chuck Miller via 4D_Tech
Do you want some one to be able to click in and not tab. If not you could use on enter event and deal with what you want cursor to do and where it should move to Regards Chuck Chuck Miller Voice:

Re: Problem with PDF Creation into Temporary Folder

2018-02-04 Thread Chuck Miller via 4D_Tech
It also depends upon when doc was created. Sometimes the O/S needs time to update itself. I have found that occasionally I have created a document and I have to wait via a repeat loop that looks like this Create document DocFound_B:=false repeat delay process(current process;60) test to see of

Re: [v16-Mac] Syntax check hits me with 3,300 + Errors...

2018-02-18 Thread Chuck Miller via 4D_Tech
When you do that be careful to set your preferences otherwise all numbers will be typed as real Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

Re: v13 Compiled vs Interp execution

2018-02-22 Thread Chuck Miller via 4D_Tech
As an aside I would use a local variable so command would look like this c_real($MyNumber_R) $MyNumber_R:=500.0 $real:=2*(MAXLONG-$MyNumber_R) I do this so that 4D does not reset results based upon what it thinks it should do I think it will work even without the .0 Regards Chuck

issue with MSC

2018-02-21 Thread Chuck Miller via 4D_Tech
Hi All, Environment Mac OS X 10.11.6 4D version 15.5 and 15.4 hf2 I have tried to run using both version. I run mac check and it tells me there are anomalies and to open th log file created, which I do nothing appears in safari or chrome or firefox. Any ideas as to what I can do tho fix this

Re: Securing ODBC Connections?

2018-01-02 Thread Chuck Miller via 4D_Tech
Not sure we need more info. Is the ODBC driver 32 or 64 bit. If you put a trace in sql authentication method and see what happens. Can you connect from excel? Access is a little out of the ordinary for me have never tried to access 4D from it Regards Chuck Sent from my iPhone > On Jan 2,

Re: Changes to variable initialization in v16?

2018-08-01 Thread Chuck Miller via 4D_Tech
In my opinion it is. It is too easy to make changes with unexpected results. for one. Security for another re control of source code. Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed

  1   2   >