v17.1 64 bit server crashes

2019-05-15 Thread Chuck Miller via 4D_Tech
Hi All, I am testing on a MAC OSX 10.12.6. When I run 64 bit version of 17.1 it crashes immediately. When I run 32 bit version, it runs. Any ideas as to why this is happening Regards Chuck Chuck

Re: list box issue

2019-05-14 Thread Chuck Miller via 4D_Tech
You are correct it is wrong first time in. Want to keep it that way Sent from my iPhone > On May 14, 2019, at 3:53 PM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Chuck, > you said the column is not enterable - disabled for a check box > a disabled check box shows as light

Re: Connecting to FTP

2019-04-30 Thread Chuck Miller via 4D_Tech
I believe you can’t do secure ftp this way. I think the famous Miyako wrote a wrapper plugin for curl. Check his site out Regards Chuck Sent from my iPhone > On Apr 30, 2019, at 10:03 PM, Robert McKeever via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > IT_SetPort returns 0. > > The FTP

CSV import with version 13

2019-04-29 Thread Chuck Miller via 4D_Tech
Hi. All does anyone have v13 code that will do this they are willing to share. I have new client still at 13 and I need to write import before I can do upgrade Thanks and regards Chuck Sent from my iPhone ** 4D Internet Users

Re: last(?) 2 built app questions :)

2019-04-19 Thread Chuck Miller via 4D_Tech
Yes you are correct, I am not sure where in the package it is Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

Re: trying to Build double clickable app

2019-04-17 Thread Chuck Miller via 4D_Tech
You have to install desktop as well Regards \ Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 mailto:cjmillerinformed-solutions.com Brookline, MA

Re: How to connect to a 4d ODBC server across a network

2019-04-17 Thread Chuck Miller via 4D_Tech
you have to create odbc connection on whatever machine you are running sql from Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

Re: ORDA and 4D selections

2019-04-10 Thread Chuck Miller via 4D_Tech
I think returns will be much faster. That is the only reason Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

Re: Password issue - no password requested

2019-04-08 Thread Chuck Miller via 4D_Tech
You must have clicked save password at some point. Code to remove this has been posted many times. If you can’t find it let me know off line and I will forward one version to you Regards Chuck

Re: Problems with Microsoft Print to PDF

2019-04-03 Thread Chuck Miller via 4D_Tech
Yes when I upgraded to 17.1 using 32 bit client on windows Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

Re: Error connecting to 4D Server

2019-04-03 Thread Chuck Miller via 4D_Tech
when connecting on local machine, I would use localhost and not IP address Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

Re: Finding the proper source code...

2019-03-25 Thread Chuck Miller via 4D_Tech
Perhaps the attachment code is not working Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 mailto:cjmillerinformed-solutions.com Brookline,

Re: Doris Beaulieu 31 Year Anniversary at 4D

2019-03-13 Thread Chuck Miller via 4D_Tech
I agree. Pretty hard to believe she made it all this way working for so many along the way. She must have started when she was still a young teenager Regards and congrats to her Chuck Chuck Miller

Re: Debugger window corruption

2019-03-01 Thread Chuck Miller via 4D_Tech
You should try at least 15.6. Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 mailto:cjmillerinformed-solutions.com Brookline, MA 02446 USA

Re: Printing 4D Write to PDF via Windows 10 "Microsoft Print to PDF"

2019-03-01 Thread Chuck Miller via 4D_Tech
You don’t specify but what version of 4D.I think you may have rot use PDF center 1.2 to make this work. I also don’t see in your code any new area command so perhaps that is the problem Regards Chuck

interesting find

2019-02-20 Thread Chuck Miller via 4D_Tech
I have found something in v17 that I did not think would work I have a method which is always passed a pointer. I made a mistake way back when in v15 The compiler declaration is c_pointer (method;$1) while in the method it was c_text. What is strange is that it has worked in v15 but in 17 it

change in behavior v 15 to v 16 ?

2019-02-15 Thread Chuck Miller via 4D_Tech
In v 15 if you have a the following line of code (with all variables typed) $DocRef:=create document(“”;”TEXT”) you could paste into the finder window In v 16 with exactly the same commands you can not paste into the finder window. Is this expected behavior or not The same behavior is exhibited

Re: v17 conundrum in design

2019-02-11 Thread Chuck Miller via 4D_Tech
Been there done that Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 mailto:cjmillerinformed-solutions.com Brookline, MA 02446 USA

Re: v17 conundrum in design

2019-02-08 Thread Chuck Miller via 4D_Tech
nly quitting and restarting 4D > is enhough to solve this issue. You might try to remove the slash chars, set > a breakpoint at the remaining line and remove it right away and then split > your line again. > > HTH > Koen > >> Op 7 feb. 2019, om 21:39 heeft Chuck Mill

Re: v17 conundrum in design

2019-02-07 Thread Chuck Miller via 4D_Tech
Thanks Steve, I do not think so and the debugger comes up on a NON alp line Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

v17 conundrum in design

2019-02-07 Thread Chuck Miller via 4D_Tech
Hi All, I have an object method that shows no break points either in the method or when I show break points, yet it continues to stop at a particular line of code and it is annoying. Any ideas out there what it might be. Thanks and regards Chuck

Re: Closing a window with another application in focus

2019-02-07 Thread Chuck Miller via 4D_Tech
You’re not kidding when running with built clients sometimes closes window using close box quits 4D on windows 7. Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax:

Re: How to display read-only input form

2019-02-06 Thread Chuck Miller via 4D_Tech
Sure on load use command Object set enterable(*;”@“;false)// This will set all fields and variables to non enterable You will have to use Object set enabled for Check Boxes, Radio button etc. These can not be done as above as it will set all to disabled You could also do a start transaction

v17 built client on windows a few issues

2019-02-06 Thread Chuck Miller via 4D_Tech
Hi All, I am using v17.2 64 bit client. On a variety of windows machines, entering a enter from extended keyboard is causing volume desktop has stopped working and of course 4D just quits. Anyone else having these issues. Also ins Reading quick report documentation the normal menus are not

Re: call subform

2019-01-30 Thread Chuck Miller via 4D_Tech
The AddButton is on subform. So I am not sure what goes on. Should I be setting call subform container in the print form or the subform. Docs look like it should be in subform form method. Is this not the case and yes trace seems to not show anything anywhere Regards Chuck

call subform

2019-01-29 Thread Chuck Miller via 4D_Tech
Hi All, environment v15.6 client server I have created a subform with an add button on it. In the form method I call subform (-999) In object on the subform I have case :(form event=-999) if(read only state(table)) object set visible(*;”Addbutton”;false) else object set

Re: Converting pictures

2018-12-30 Thread Chuck Miller via 4D_Tech
Yes there is. JPR gave a demo of just the ticket , a component that did this. regards chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

Re: v13+ - plugins

2018-12-18 Thread Chuck Miller via 4D_Tech
You could always do this yourself by looking in plugins folder Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

looking for example of REST calls

2018-12-11 Thread Chuck Miller via 4D_Tech
Hi all subj says it all. I may have to connect to a rest server and deliver a file in that manner for one of my clients. As I have never used rest before, I was hoping for an example of how that would be done. I looked on 4D web site and in knowledge base but could not find what I was looking

v17 kind of gotcha

2018-12-05 Thread Chuck Miller via 4D_Tech
I know one should never have two objects on a form with the same name. I have code that creates list boxes on forms. In v16 compiled or source, I get no errors. In v17 I get error as I had named columns the same thing on multiple pages in different list boxes on the same form Regards and hope

Re: Publishing a DB on the WWW. Howto.

2018-12-03 Thread Chuck Miller via 4D_Tech
Look at lightning 4 for 4D you can find it http://www.foundationshell.com/store/ Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

Re: Windows Server Hardware Recommendations for 4DServer v17 Application

2018-11-30 Thread Chuck Miller via 4D_Tech
For your data size I would look at 500 gig suds and 64 or greater memory if you can afford it If you assign 32 gig to cache most will be in memory. You can even preload commonly used data on server startup Regards Chuck > On Nov 30, 2018, at 12:29 PM, Neal Schaefer via 4D_Tech >

Re: Structure Location--Best Practices...?

2018-11-01 Thread Chuck Miller via 4D_Tech
This is what I do as ell. Placing in program folder is problematic on windows and macs these days. I also place the built client on C drive in a new folder named appropriately Regards Chuck

Re: v16R6 Crashing on Compile

2018-10-26 Thread Chuck Miller via 4D_Tech
You can use sql to duplicate the structure use 4d code to export all of the methods and then import them. You would then have to open both structures and. Drag forms. I would stop an try compile with no forms then would move only some of the forms. Additionally I would try compile by creating

Re: Longing IDs or UUIDs as primary key?

2018-10-24 Thread Chuck Miller via 4D_Tech
No it is just painful let’s assume for some reason record in a many table where assigns to wrong main table which would you rather type in to fix 145764 or a 32 character UUID In my opinion the journal aspect should have been hidden by 4D and the UUID field should have been there but hidden

Re: Help->v11 to v17 Upgrade or New?

2018-10-17 Thread Chuck Miller via 4D_Tech
I would go and using v 11 create new tables using key from main table move data and then upgrade. I would lastly delete the old sub table and mark the link as unused Sent from my iPhone > On Oct 17, 2018, at 4:36 PM, Timothy Penner via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > The main

Re: Custom Object Libraries crash 4D V16.4

2018-10-16 Thread Chuck Miller via 4D_Tech
I think there is 32 bit windows server as well Regards Chuck Sent from my iPhone > On Oct 16, 2018, at 5:29 PM, Julio Carneiro via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Well, this is on Windows, so server is 64-bit and client is 32-bit. No other > options. > >> On Oct 16, 2018, at

Re: Resetting the table sequence number

2018-10-15 Thread Chuck Miller via 4D_Tech
You could also do this c_longint($Variable_L) begin sql select MAX([table]ID_Field) from [table] into :$Variable_L; end sql or query by sql([table];max([table]ID_Field) into :$Variable_L) I am not sue query by sql will work Regards Chuck

Re: What causes a record to be Locked but Locked By has no info?

2018-10-11 Thread Chuck Miller via 4D_Tech
You should test for is in read only mode and if so unload record/ set to read write and then load Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

Re: 4D v17 R2 Object Library Write Pro Toolbar

2018-10-11 Thread Chuck Miller via 4D_Tech
I did the same thing what a bumber Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 mailto:cjmillerinformed-solutions.com Brookline, MA 02446 USA Registered

Re: What causes a record to be Locked but Locked By has no info?

2018-10-11 Thread Chuck Miller via 4D_Tech
ocked($table_p->)) > > // do the locked record stuff > > End case > > > Sure I can manipulate the records between locked and unlocked. The thing is > when I do those sorts of operations everything behaves as expected. This is > some sort of edge case, I just want to

Re: What causes a record to be Locked but Locked By has no info?

2018-10-11 Thread Chuck Miller via 4D_Tech
Kirk In 15 I had found you could lock records think you unlocked them and then unloaded but they would remain locked until you quit server. What happens in your car if you select a different record. Do both show as locked only first or only the second Regards Chuck Sent from my iPhone >

Volume shadow copy v17

2018-10-10 Thread Chuck Miller via 4D_Tech
Hi All, Has anyone implemented this feature and tested to make sure it works as advertised. Thanks and regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617)

v 17 r release

2018-10-10 Thread Chuck Miller via 4D_Tech
Hi All, I thought I saw a post that v17 R 2 was available for download and can’t find it. I would like to download Thanks and regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions,

Re: Notes on converting pictures to v17

2018-10-09 Thread Chuck Miller via 4D_Tech
Yup after your CONVERT PICTURE($vPict;$codec) You need the next line of code TRANSFORM PICTURE($vPict;Transparency;0x00FF)

scrolling issue on v15 and still on v16

2018-10-03 Thread Chuck Miller via 4D_Tech
Hi All, I have a output form (Not list box). This was created many moons ago in v 3. with multi lines. In one table we have close to 2 million records. I know no one would do this in real life but during testing if you scroll down toward the bottom, all look fine. If you go to end or someplace

Re: button picture problems in v16 and v17

2018-09-21 Thread Chuck Miller via 4D_Tech
Actually source was available. I have it. Fixed the issues I was having. I did look at the tech note and the link for Miyako’s component was broken so any ideas where I might find it Thanks and regards Chuck

button picture problems in v16 and v17

2018-09-20 Thread Chuck Miller via 4D_Tech
Hi All, I am using user mode component created many moons ago. I have updated my input forms and now none of the pictures for the buttons show up. The input forms are of course in the host db. Buttons on those forms are inside the images folder and appear during editing. I have copied the same

Re: v13 - SQL alter table, what is wrong?

2018-09-17 Thread Chuck Miller via 4D_Tech
I think it should be ALTER TABLE [Anmlprot_File_Link] ADD [Journal_Key] [Primary KEY] This is from the 4D docs ALTER TABLE sql_name {ADD column_definition [PRIMARY KEY] [TRAILING] | DROP sql_name | ADD primary_key_definition | DROP PRIMARY KEY | ADD foreign_key_definition | DROP CONSTRAINT

Re: v13 - SQL alter table, what is wrong?

2018-09-17 Thread Chuck Miller via 4D_Tech
I missed th v13 part. Is the field already set as indexed and unique. If not I would bet alter table would not work. I do not know what would happen in newer versions if you tried to assign UUID inside 4D without it being a UUID field Have you tried other data types. Regards Chuck

Re: PDF generation on Windows - Latest Thinking

2018-09-12 Thread Chuck Miller via 4D_Tech
I think it does run on windows 10 Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 mailto:cjmillerinformed-solutions.com Brookline, MA 02446

list box entry issue

2018-09-05 Thread Chuck Miller via 4D_Tech
Hi All, Environment 4D v15.6 client server I have an array based list box where there are 3 arrays. Only array 3 can be entered Under the list box object I have the following code Case of : (Form event=On Load) //EDIT ITEM(DefaultValue_ar;1) : (Form event=On Double Clicked)

Re: Isolating the Cause of a Server Crash

2018-08-31 Thread Chuck Miller via 4D_Tech
Are you running any virus detective on that machine. If so you should skip 4D folders Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

Re: 4D Write Pro WP feature request - need your support

2018-08-29 Thread Chuck Miller via 4D_Tech
I also have one client that is a huge 4d write user. We also need to have ability to convert to Microsoft word. Additionally, there are some things we do not seem to be able to do in write pro so for now, we will be maintain 4d write licenses across multiple servers and standalone dos. At the

Re: New record numbering system and CALL WORKER

2018-08-28 Thread Chuck Miller via 4D_Tech
Thanks. As I said I was not sure. Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 mailto:cjmillerinformed-solutions.com Brookline, MA 02446

Re: New record numbering system and CALL WORKER

2018-08-27 Thread Chuck Miller via 4D_Tech
It does, but remember if you already have multiple transactions, you will have to keep track and may have to suspend that many times Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed

Re: New record numbering system and CALL WORKER

2018-08-26 Thread Chuck Miller via 4D_Tech
OK i have done this many times with a table. You have multiple records in the table, one for each id you need. I usually make that records key name ([table]field). If you have to keep track of released numbers, you can add a blob field. I would not be adding object fields as you can not access

Re: Export/ImportSQL

2018-08-20 Thread Chuck Miller via 4D_Tech
Hi pat I have out code to clone data in v11 at one of summits. If you install that code it should get all data for you. I am in Alaska on vacation so can not get I for you till I return. Please advise if you have it. Regards Chuck Sent from my iPhone > On Aug 20, 2018, at 1:22 PM, Pat

Re: height and width of a fixed prtinted object

2018-08-08 Thread Chuck Miller via 4D_Tech
Thanks that did it not sure how I missed it as I looked at the command in documentation Thanks and regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

Re: v13 - marking field as 'Primary Key'

2018-08-06 Thread Chuck Miller via 4D_Tech
You can identify primary key with the following code $TableLoop_l is table number Begin SQL SELECT CONSTRAINT_ID FROM _USER_CONSTRAINTS WHERE TABLE_ID = :$TableLoop_l AND CONSTRAINT_TYPE = 'P' INTO :$ConstraintID_txt; SELECT COLUMN_ID FROM _USER_CONS_COLUMNS WHERE CONSTRAINT_ID =

Re: Fields Missing Getters and setters

2018-08-03 Thread Chuck Miller via 4D_Tech
You can use sql to identify which are primary keys for each table and use sql to set primary key Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

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

Re: Confused about ORDA

2018-07-29 Thread Chuck Miller via 4D_Tech
Nope it always worked this way. If you have * at end of line and do not identify what query format will be & (and) is assumed This QUERY([T_Loggers_data];[T_loggers_readings]FK_REAP=[REAP_sections]FK_REAP;*)

Re: Assistance Needed

2018-07-27 Thread Chuck Miller via 4D_Tech
If you are a partner call your sales person Regards Chuck Sent from my iPhone > On Jul 27, 2018, at 1:14 PM, Robert McKeever via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > A client wants his ancient (4D 2003) database upgraded to 4D v16. > > I have the source, and a 10.6.8 environment under

Re: Does MSC database compact work for large data files?

2018-07-26 Thread Chuck Miller via 4D_Tech
I do not think this will work any longer because A. Indices that point to related records and on related records can not be turned off B. A primary key or in fact any key that is set as unique must have indexing turned on Sometimes it is better to use sql to recreate data file. Now that v16

Re: 13.x Quick Report Export Max Output File Size?

2018-07-24 Thread Chuck Miller via 4D_Tech
What OS are you running it could be an OS limit Regards Chuck Sent from my iPhone > On Jul 24, 2018, at 12:13 PM, Benedict, Tom via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > I'm exporting data from 4D to a text file using the 4D Quick Report Editor in > v13.x. It stopped writing to disk

Re: 4DIC - Hiding the authentication username in outgoing emails

2018-07-18 Thread Chuck Miller via 4D_Tech
I would think not. That probably is against google rules or any email that needs authentication. Think of it this way. You have a gmail account and authenticate but you want to send email as someone else and hide who you are. Sounds like spammers dream You could send all from one email and

v16 & 17 components and plugins

2018-07-18 Thread Chuck Miller via 4D_Tech
Hi All, I am starting upgrade and can not see to find the following in install image 4D POP 4D Pack Any ideas where that they might be, or have they been deprecated Thanks and regards Chuck

subtables issue

2018-07-15 Thread Chuck Miller via 4D_Tech
Hi All, I have a situation I have not encountered and am stumped. I have been asked by a person to upgrade pictures in a v17 db. When I open the structure, I still see subtables there. I also see the tables that have been created as part of conversion. What gives? The new tables appear to be

Re: Objects without Stylesheets suddenly displayed as Wingdings!

2018-07-12 Thread Chuck Miller via 4D_Tech
I have code that will report on any object on forms with no font or style sheets assigned Please advise if you want it Regards Chuck Sent from my iPhone > On Jul 11, 2018, at 10:44 PM, Bob Miller via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I've not ever seen this before today, when I

Re: Converting pictures on 4D forms (Windows) to get transparency

2018-07-09 Thread Chuck Miller via 4D_Tech
Add the line after convert TRANSFORM PICTURE($vPict;Transparency;0x00FF) Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

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)

Re: 4D Write licensing...

2018-06-28 Thread Chuck Miller via 4D_Tech
Whether editing or printing, the user needs a license Regards Chuck Sent from my iPhone > On Jun 28, 2018, at 3:47 PM, Robert ListMail via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > I appreciate your response; however, this does not answer my question. If I > have one license and the 4D

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

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

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

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

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: A thought on re-indexing of a large database after repairs, compacting etc

2018-04-22 Thread Chuck Miller via 4D_Tech
OK I don;t get it. We have a data base of over 200 Gig with many millions of records. We run using SSD,s in an Areca RAID. 1 Terabyte SSDs. I can tell you that when we restored from a backup up and rebuilt indices it took not more than 20 minutes to so. It does not matter if it is by table or

Re: windows script issue

2018-04-16 Thread Chuck Miller via 4D_Tech
OK I get it. How can I turn this into a bat file that returns a value? as it works from command prompt Thanks and regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax:

Re: 4D 15.5 on MacOs High Sierra 10.13.4

2018-04-16 Thread Chuck Miller via 4D_Tech
Try creating another account on the same machine and see what happens. You could also delete all 4D preferences and see if that changes the situation Chuck Chuck Miller Voice: (617) 739-0306

windows script issue

2018-04-13 Thread Chuck Miller via 4D_Tech
Hi All, I need to run a command line script on windows to retrieve a password. I have filled a text variable to use with launch external process and set to pasteboard. When I run from cmd prompt. I get expected results but when tun from launch external process I get nothing no in, no out no

Re: Room available at the Grand Hyatt Washington

2018-03-28 Thread Chuck Miller via 4D_Tech
we feel your pain 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: When your Extreme router is too slow... (5N)

2018-03-23 Thread Chuck Miller via 4D_Tech
I am using an Asus router and am very happy with it. There is a third party guru who is always patching and fixing. I am not on a gig network but constantly get wireless speeds close to what my sip (RCN) provides Regards Chuck

Re: Import from Excel

2018-03-07 Thread Chuck Miller via 4D_Tech
No need to export. Save as a text file and you can import that Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

Re: Remember password

2018-02-26 Thread Chuck Miller via 4D_Tech
Not that I have found, but you can remove saved passwords at every log in which has the same result Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

  1   2   >