Re: Windows shutdown with 4D Server running as a service

Shouldn’t you first stop the service, which will quit 4D Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 mailto:cjmillerinformed-solutions.com

Re: Prevent Client from Sleeping

The question is to why. I would think you just want to stop the drive from spinning down. Most companies hate when you do that as they want computer to lock after as short period of inactivity On Mac there is a setting to stop drive from spinning down. I bet there is on windows as well Regards

pointer issue

Hi All, The following fails $MetalAmount_ptr:=Get pointer("$MetalAmount_"+String($MetalPos_L)+"_aR") $MetalAmount_ptr->{$Loop_L}:=$metalFactors_aR{$InnerLoop_L} When I changed arrays to process $MetalAmount_ptr:=Get pointer("MetalAmount_"+String($MetalPos_L)+"_aR") $MetalAmount_ptr->{$Loop_L}:=$m

Re: FORMAT NUMBER

Read my previous note. You will need to convert the array to text array and fill as a formatted number using code I already supplied Regards Chuck Sent from my iPhone > On Aug 5, 2019, at 5:59 PM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > if ###,## does not display a blan

Re: FORMAT NUMBER

That is why I asked about version and what you show is truncated not rounded Also I would suppose ###.## would take care of all Didn’t think of that one Regards Chuck Chuck Miller Voice: (617) 73

Re: FORMAT NUMBER

First of all. what version of 4D I would think you can not do all you want with a number. You could do it with a text variable for example in the in display detail form event If $YourNumber_R (is a real) $YourNumber_R:= 100.5 $YourText:=string($YourNumber_R;”###.0”) $YourNumber_R:= 100.52 $You

Re: POS systems

Hank szrezter has one built on 4d. He has been selling it for a long while Regards Chuck Sent from my iPhone > On Aug 3, 2019, at 12:38 PM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Dave, > One of the first big 4D projects I took on was interfacing 4D with an OS/2 > based

Re: Error -1 using SQL.

You can write the code to see if there is already a primary key and not do the alter if there is It is one of the hidden sql tables Array longint(constraintids_al;0) Array longint(tablenumbers_al;0) Begin sql Select constraints_id, table_id From _user_constraints Where constraint_type =‘P’ Int

Re: Writting code to disk

It depends. Generally I use either text to document or blob to document. It takes same overhead as writing 1000 characters. I would recommend using blobs and simply blob to doc at the end Regards Chuck Sent from my iPhone > On Jul 23, 2019, at 1:52 PM, Chip Scheide via 4D_Tech <4d_tech@lists

Re: PDF Viewer

Why do you need a PDF viewer plugin. Just place pdf in a pict field on a mac and voila you can view it. You could also create a web area on a form and simply use that Regards Chuck Chuck Miller Vo

Re: [off]Apple script issue

Thanks it got me the following: Open Script Editor, navigate to File > Open Dictionary and select what you want It appears that print settings does not list sizing so I am stuck Regards Chuck Chuck

[off]Apple script issue

Hi All I have the following apple script created and run via launch external process tell application "Preview" print file "SnapServer:Test_Invoices:Checon_Invoices:2019:04 - April:224747_04_12.PDF" with print dialog print file "SnapServer:Test_Invoices:Checon_Invoices:2019:04 -

Re: command WA OPEN URL(*

Ok I und that if you uncheck use integrated tool kit on form object. The form functions as expected Chuck Sent from my iPhone > On Jul 2, 2019, at 11:27 AM, Charles Miller via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Hi All, > > When I run this command on macs or windows that are not usi

v13 problem

Hi All, I just took over a v13 account and when I log in as administrator, I do not see designer as user. I do not see a splay screen. The plan is to fix known issues nd then move to v17 Can anyone advise how I might get to the structure as administrator and how I might see the designer user n

Re: v 17.1 potential gotcha

Thanks Tim, I will give that a shot and see if that also solves the problem, much more elegant than my solution Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617)

APPLESCRIPT FROM 4D

I Have the following AppleScript which I run and which works fine tell application "Preview" print POSIX file "/Volumes/SnapServer/Test_Invoices/Checon_Invoices/2019/04 - April/224747_04_12.PDF" with print dialog end tell I have the code I use to create it and will share should someone

v 17.1 potential gotcha

Hi all, I have a form (invoice ) that I am printing 1 copy of and printing a second copy using set print destination to create a PDF I made the following discoveries. 1. The print was fine all on page as it should have been 2. When opening PDF (Preview)on Mac, print was not fine. Lost part of he

Re: v15 to v17 Conversion of Obsolete _o_C_STRING/_o_ARRAY STRING Commands

In principal no problem, however it is harder and harder to maintain. I would say fix in one full swoop. Also I would not use 4D to create and index new primary keys using the wizard. I would role my own code. I have posted this code in the past so if you look at archives you should find it. R

Re: How to call Oracle stored procedure

Oracle used to give different results from transact and from a program. I will look tomorrow at code I am using and see if I am calling stored proc. I am inserting only. Regards Chuck Sent from my iPhone > On Jun 13, 2019, at 4:34 PM, Olson, Brad via 4D_Tech <4d_tech@lists.4d.com> > wrote:

Re: Static Pictures to Library Pictures

If you had gone to one of 4D’s road shows, JPR had a db that would do this for you. Perhaps you can request it from 4D. You still have to load each form but it is pretty seamless. Regards Chuck Ch

Re: Running 4D Client/Server on same machine via localhost?

You can. If you are running with normal ports simply enter localhost for ip address to connect Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 m

v17.1 64 bit server crashes

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 M

Re: list box issue

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 grey

Re: Connecting to FTP

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 Logi

CSV import with version 13

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 G

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

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 mailto:cjmillerinformed-solutions

Re: trying to Build double clickable app

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 02446

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

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 mailto:cjmillerinformed-solutio

Re: ORDA and 4D selections

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 mailto:cjmillerinformed-solutio

Re: Password issue - no password requested

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 C

Re: Problems with Microsoft Print to PDF

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 mailto:cjmillerinformed-solutions.com

Re: Error connecting to 4D Server

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

Re: Finding the proper source code...

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, M

Re: Doris Beaulieu 31 Year Anniversary at 4D

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 V

Re: Debugger window corruption

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

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

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

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 th

change in behavior v 15 to v 16 ?

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

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 Registered

Re: v17 conundrum in design

r of times. Mainly 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 h

Re: v17 conundrum in design

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

v17 conundrum in design

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

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

Re: How to display read-only input form

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 on

v17 built client on windows a few issues

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 the

Re: call subform

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

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 visible(*;”Addbutton”;tr

Re: Converting pictures

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

Re: v13+ - plugins

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 mailto:cjmillerinformed-solutions

looking for example of REST calls

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

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 t

Re: Publishing a DB on the WWW. Howto.

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

Re: Windows Server Hardware Recommendations for 4DServer v17 Application

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 > <4d_tech@lis

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

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 Chuc

Re: v16R6 Crashing on Compile

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 an

Re: Longing IDs or UUIDs as primary key?

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

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

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 con

Re: Custom Object Libraries crash 4D V16.4

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

Re: Resetting the table sequence number

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?

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

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 4

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

> > :(Locked($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,

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

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

Volume shadow copy v17

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) 232-1064

v 17 r release

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, I

Re: Notes on converting pictures to v17

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

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

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

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?

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 sql_n

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

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

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 US

list box entry issue

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) C_LONGINT($Colu

Re: Isolating the Cause of a Server Crash

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

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

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 la

Re: New record numbering system and CALL WORKER

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 U

Re: New record numbering system and CALL WORKER

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 Soluti

Re: New record numbering system and CALL WORKER

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 u

Re: Export/ImportSQL

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 Ben

Re: height and width of a fixed prtinted object

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'

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 = :$ConstraintID_t

Re: Fields Missing Getters and setters

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?

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 Solut

Re: Confused about ORDA

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;*) QUERY([T_Loggers_data];[T_Loggers_data]TLD_timestamp>=$TSsectionSta

Re: Assistance Needed

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?

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 ha

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

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 wh

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

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 cha

v16 & 17 components and plugins

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 Chuck

subtables issue

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 th

Re: Objects without Stylesheets suddenly displayed as Wingdings!

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 wa

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

Add the line after convert TRANSFORM PICTURE($vPict;Transparency;0x00FF) Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 mailto:cjmillerinformed-solutions.c

Re: problems with SEND RECORD

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) QUERY([A

Re: 4D Write licensing...

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 Wr

Re: RIP Sujit Shah

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 mailto:cjmillerinformed-s

crashing issue in v15 and v16

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 u

Re: Uppercase Lowercase

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: (617)

Re: Delay process bug

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

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

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

<    1   2   3   4   >