Re: Detecting field properties that can take nulls

2017-02-20 Thread Jeremy French via 4D_Tech
Have you looked at the SQL system table “_USER_COLUMNS”? See: http://doc.4d.com/4Dv16/4D/16/System-Tables.300-3201182.en.html > On Feb 20, 2017, at 2:52 PM, bob.miller--- via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I've

Re: Detecting field properties that can take nulls

2017-02-20 Thread Jeremy French via 4D_Tech
Hi Bob, I believe you can locate the fields — whose “Map NULL values to Blank values” is unchecked — by exporting the structure. Try this: 1) Export the structure in HTML format. 2) Then open export in a browser, and look in the column titled “Never Null”. A check-mark in the “Never Null”

Re: 4D Server/4D Client runs just fine in a good VM

2017-02-28 Thread Jeremy French via 4D_Tech
What are the versions of Parallels VM and macOS host? How much RAM did you specify in the virtual machine? (For setting, see Actions -> Config -> "Hardware" tab -> "CPU & Memory” theme.) > On Feb 28, 2017, at 11:32 AM, Jim Medlen via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I am using

Re: How to collapse/expand all panes in Property List (v16)

2017-03-26 Thread Jeremy French via 4D_Tech
In v16, control-click works for me to expand/collapse all Property List themes. What happens if you quit and restart 4D? > On Mar 26, 2017, at 9:02 PM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > In v16 it seems I the ability to collapse all panes in the Property List > (when

Re: Weird variable (non-)refresh issue

2017-03-15 Thread Jeremy French via 4D_Tech
Hi Bob, I'm assuming that: 1) you are setting the input form's variable in the **same** method where you call DIALOG. 2) you are calling DIALOG **without** the asterisk parameter. If so, I believe the variable's value will never be displayed in the input form while the dialog is open. That's

Re: CALL FORM: Some notes on a command that's easy to misunderstand

2017-03-17 Thread Jeremy French via 4D_Tech
Hi David, Yes, you need to log in. Notes are only available at livedoc.4d.com . (There is NO note feature at doc.4d.com .) The login link is at the top right of the web page. https://s8.postimg.org/oylrfbtsl/p01_comment_log_in.png Scroll down to

Re: v13 - Select & Create Document

2017-03-14 Thread Jeremy French via 4D_Tech
Hi Chip, The command "Select document” returns (as a function) only the document name. To get the actual path, add the fifth optional parameter which is an array. The first element of the array will have the full path to the saved document. Using your code: -- $File_Path->:=Select

Re: List Box Hidden rows array

2017-03-13 Thread Jeremy French via 4D_Tech
Hi Jim, Have you looked at LISTBOX SET ARRAY with the "lk control array" constant? For the command: http://doc.4d.com/4Dv16/4D/16/LISTBOX-SET-ARRAY.301-3036404.en.html For the control array, see section titled "Managing row display":

Users & Groups (What is "proper access privileges"?)

2017-03-13 Thread Jeremy French via 4D_Tech
What is meant by "proper access privileges" in Users and Groups? Is there a definiton somewere? 3-commands mention "Designer" and "Administrator", who can execute the command. Those commands are: 1) BLOB TO USERS 2) DELETE Users 3) USERS TO BLOB But many other commands do not

Re: 4D Write Pro interface plug in or component?

2017-07-11 Thread Jeremy French via 4D_Tech
Also https://www.youtube.com/watch?v=Q_fFafP-hgs=em-subs_digest > On Jul 11, 2017, at 6:41 AM, Ingo Wolf via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > have a look at >

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

2017-06-29 Thread Jeremy French via 4D_Tech
Hi Kirk, Have you looked at the “Pop up form window” window type? The window immediately closes if the user clicks outside of the window. http://doc.4d.com/4Dv16/4D/16.1/Open-form-window.301-3375260.en.html > On Jun 29, 2017, at 2:02 PM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> >

Re: Max Password Length

2017-06-27 Thread Jeremy French via 4D_Tech
15 alphanumeric characters. See item #5 of “ Adding and modifying users” at: http://doc.4d.com/4Dv16/4D/16.1/Managing-users-and-groups.300-3373309.en.html > On Jun 27, 2017, at 3:05 PM, Jim Medlen via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > What is the maximum Length of a 4D Password ?

Re: 4D Write Pro CSS

2017-04-26 Thread Jeremy French via 4D_Tech
Hi Pat, Programmatically, my workaround for style sheets is to use the new capabilities to: • define bookmarks. • define templates. • build ranges. • create temporary WritePro areas from a single bookmark. • insert temporary WritePro areas into the final WritePro document. In this scheme, the

Re: PROCESS 4D TAGS

2017-04-28 Thread Jeremy French via 4D_Tech
How do you know PROCESS 4D TAGS is failing? Have you confirmed that the process variable "tTemplate" actually contains your template? In other words, does “Document to text” successfully retrieve the template? When the command “Document to text” encounters an error, the command fails

Re: v13 - Accessing user groups in component

2017-05-17 Thread Jeremy French via 4D_Tech
According to the documentation, you are seeing the host’s users and groups from within the component. From the documentation: "the 'Users and Groups' theme can be used from a component but will read the users and groups of the host database (a component does not have its own users and

Re: Saving open windows in Design environment feature

2017-06-25 Thread Jeremy French via 4D_Tech
Hi Jim, Not sure what you mean by “open up the forms themselves”. But if you mean, “how do I access objects on a form name obtained through Design Object Access commands?”, then look at the FORM LOAD and FORM UNLOAD commands. In a component, for example, you can introspect all objects on a

Compatibility Mode v12 (How to change to Unicode?)

2017-05-22 Thread Jeremy French via 4D_Tech
I am examining a Windows 7 4D v12.5 database. The Compatibility tab in Database Settings indicates that the database is in "Compatibility mode". See https://s10.postimg.org/7cx58znuh/compatibility_unicode_mode.png Knowledge Base article #50076 "Unicode Mode vs. Compatibility Mode" says: "The

Re: Disable close button on Splash screen windows v12

2017-05-16 Thread Jeremy French via 4D_Tech
Hi John, Have you looked at "Setting a Default User" in the Design Reference? If you want to allow: 1) Users to never see the 4D Password Dialog; and 2) Users to only see your password system; and 3) 4D password system to keep users out of design environment then take a look at "Setting a

Re: v13+ What table does a set belong to?

2017-06-02 Thread Jeremy French via 4D_Tech
Hi Chip, You could try performing a set operation on a known table set with the unknown set. If the two sets are from **different** tables, the set operation triggers an error. If both sets belong to the **same** table, no error occurs. So iterate over each table performing the set operation

Explorer's "Object List" (How to get consistent wider width?)

2017-06-11 Thread Jeremy French via 4D_Tech
How do we get the Explorer window’s "object list" to consistently retain a wider width? In other words, when I widen the “object list”, how do I get 4D to always use that wider width? When ever I open the Explorer, its “object list” width has reverted to a narrower, default size.

Re: Listbox column width and pointers

2017-09-15 Thread Jeremy French via 4D_Tech
It's better to use an object name in place of a pointer. That's because a pointer could reference more than one object on the form. Object names are unique and so reference only a single object. Here are a couple of things you might try. Try #1 = For calculating the column widths, replace

Re: What happened to 4D documentation in R releases?

2017-10-06 Thread Jeremy French via 4D_Tech
Hi Richard, There is a link titled “What’s New”. This link appears **only** when you view the Language Reference “Table of Contents”.That’s the page that appears after choosing Language Reference for a specific version of 4D. Snapshot of Language Reference’s “Table of Contents"

Re: Number format

2017-10-03 Thread Jeremy French via 4D_Tech
The pattern to control the display of a zero value has 3-parts, separated by a semicolon. Note the 2-semicolons: positive_format;negative_format;zero_format To display nothing for a zero value, put nothing after the second semi-colon. So this display filter will show positive and negative

Re: FORM SET OUTPUT -> project form

2017-10-16 Thread Jeremy French via 4D_Tech
Hi Pat, Use the DIALOG command for a project form, as Tai points out. But the form name "ReportHeaderLandscape" suggests you want to print a header. Perhaps the command you are looking for is "Print form”? "Print form" requires a table. You can change the project form to a table form by —

Re: 4D and Fusion Charts

2017-09-12 Thread Jeremy French via 4D_Tech
Have you looked at these items in the Web Area documentation? 1) Configuring the Web area 2) Using the $4d object See Accessing 4D Methods at http://doc.4d.com/4Dv16/4D/16.2/Programmed-management-of-Web-Areas.300-3434143.en.html#3190797 > On Sep 12, 2017, at 2:53 PM, John S. Poteat via

Re: Is it possible to put a SVG file directly on a form?

2017-09-25 Thread Jeremy French via 4D_Tech
Kirk, Have you tried: 1) Place SVG file in database’s “Resources” folder. 2) Restart 4D. 3) Locate SVG file in "Design -> Tool Box -> Resources". 4) Drag SVG from the Tool Box’s "Resources” window to the form. 5) Resize SVG as needed. Note the Property Inspector’s “Name/ID” attribute records

Re: Getting a list of menu bars, menu's and menu items

2017-09-26 Thread Jeremy French via 4D_Tech
Hi Randy, I gather you are adding one or more dynamic menus to the menu bar created in the Menu Editor. In that case, you need to work with references, not a positional integer. The positional index works only for menus created in the Menu Editor. Try this, which assumes no hierarchical

Re: Getting a list of menu bars, menu's and menu items

2017-09-26 Thread Jeremy French via 4D_Tech
Hi Rudy, Take a look at the commands in the “Menus” theme: http://doc.4d.com/4Dv16R3/4D/16-R3/Menus.201-3217435.en.html Then in the Application Environment, activate the menu bar you are interested in and loop through the menus and menu items like this: For ($menu_i;1;Count menus)

Re: OB Copy, New Object, or $1

2017-09-03 Thread Jeremy French via 4D_Tech
Hi John, Have you looked at “$myCoolObject" in the Debugger? Does a property named "action" exist? I just tried passing an object argument. The assignment in your line below works, provided the object passed actually exists (i.e., is at a minimum an empty object "{}"): --

Re: Export import all after a crash

2017-10-23 Thread Jeremy French via 4D_Tech
Hi Arnaud, You can pause indexes during the SQL import with: Begin SQL ALTER DATABASE DISABLE INDEXES; ALTER DATABASE DISABLE CONSTRAINTS; End SQL and then after the import completes, restore indexes with: Begin SQL ALTER DATABASE ENABLE INDEXES; ALTER DATABASE

Re: Object Array in ViewPro

2017-11-04 Thread Jeremy French via 4D_Tech
Hi Steve, It would be helpful if you could provide a link to the documentation page containing the example you are referring to. Also, what feature are you talking about? Best regards, Jeremy French > On Nov 4, 2017, at 3:56 PM, Stephen Shaw via 4D_Tech <4d_tech@lists.4d.com> > wrote: > >

How to programmatically set enterable object to transparent?

2017-11-06 Thread Jeremy French via 4D_Tech
In the Property Inspector we can set the background of an object to transparent by checking the “Transparent” attribute. https://s1.postimg.org/6l50ah787j/transparent_attribute.png How do we programmatically set the object’s background to transparent?

Re: High Sierra - Export Text in 4D v13.6

2018-06-06 Thread Jeremy French via 4D_Tech
Have you looked at "Design -> Database Settings -> Database -> Temporary Folder Location”? Is the "Temporary File Location" set to the “Resources” folder? > On Jun 5, 2018, at 4:37 PM, setar accnt via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > there is a .temp file with a long filename >

Re: select from _USER_COLUMNS

2018-06-11 Thread Jeremy French via 4D_Tech
OOPS - CORRECTION (“tab” should be “tag”) Hi Chuck, I believe you are encountering the SQL data type codes. In the SQL implementation, there is "DATA_TYPE" and "OLD_DATA_TYPE". For a chart, see tech note "System table column OLD_DATA_TYPE" at: http://kb.4d.com/assetid=76350

Re: select from _USER_COLUMNS

2018-06-11 Thread Jeremy French via 4D_Tech
Hi Chuck, I believe you are encountering the SQL data type codes. In the SQL implementation, there is "DATA_TYPE" and "OLD_DATA_TYPE". For a chart, see tech note "System table column OLD_DATA_TYPE" at: http://kb.4d.com/assetid=76350 The SQL table "_USER_COLUMNS" reports both the SQL data type

Re: v13 - Text entry area, Returns, and Filters

2018-06-29 Thread Jeremy French via 4D_Tech
Hi Chip, I forgot to add there are 2-starting characters for the filter: 1) tilde forces uppercase; while 2) ampersand does not fore uppercase. - Jeremy French > On Jun 29, 2018, at 12:39 PM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Not working :( > I can not entry a

Re: v13 - Text entry area, Returns, and Filters

2018-06-29 Thread Jeremy French via 4D_Tech
Hi Chip, Try defining the filter using the following pattern: 1) first character is the tilde character; then 2) starting quote character (escaped); then 3) allowed characters in filter, separated with semicolons; then 4) ending double quote character (escaped). The following example allows

Re: Document capture - part 2

2018-02-11 Thread Jeremy French via 4D_Tech
Hi Ken, You can rename a file using the 4D’s built-in command MOVE DOCUMENT. This command lets you move and/or rename a file. http://doc.4d.com/4Dv16R5/4D/16-R5/MOVE-DOCUMENT.301-3480974.en.html - Jeremy French > On Feb

Re: HTTP Body Size

2018-02-08 Thread Jeremy French via 4D_Tech
Hi Doug, When you use "HTTP Request" command with the "HTTP Post method" constant, I believe you also need to submit request headers. In particular, headers such as: Content-Length Content-Type Regards, Jeremy > $vl_Status:=HTTP Request(HTTP Post Method;”MYURL”;$vx_Request;$vx_Response) >

Re: HTTP Body Size

2018-02-07 Thread Jeremy French via 4D_Tech
Hi Doug, Instead of a text variable, you can also use a blob variable to avoid the size limitation. http://doc.4d.com/4Dv16R5/4D/16-R5/WEB-GET-HTTP-BODY.301-3481155.en.html Best regards, Jeremy French > On Feb 7, 2018, at 4:25 AM, Douglas Cryer via 4D_Tech <4d_tech@lists.4d.com> > wrote: >

Re: Temporarily changing the system date format

2018-02-23 Thread Jeremy French via 4D_Tech
What is the field type in which the dates are stored? Date or alpha? > On Feb 23, 2018, at 6:51 PM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Using v16 ... > > I am in the UK I'm working on a publishing project for a customer in the > US. Part of the project requires certain

Re: Break points stopped working

2018-02-26 Thread Jeremy French via 4D_Tech
In the Design Environment, try looking at Run -> Runtime Explorer -> Breaks. You may see the disabled break points, which you can click to reactivate. > On Feb 26, 2018, at 2:41 PM, John Baughman via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I must have accidentally disabled break points.

Re: v17 PDF-Manuals

2018-07-30 Thread Jeremy French via 4D_Tech
I’d like to see 4D PDF Documentation in the format used for v11’s Upgrade manual. Here’s a link to: 4D v11 SQL Upgrade http://download.4d.com/Documents/Products_Documentation/LastVersions/Line_11/VIntl/PDF_Format/4D_v11_Upgrade.pdf I suggest looking at the PDF in a PDF reader — **not** a web

Re: ORDA question: how do I add related fields to an entity selection?

2018-07-31 Thread Jeremy French via 4D_Tech
Hi Julio, Have you looked at: http://doc.4d.com/4Dv17/4D/17/dataClassAttributerelatedDataClass.303-3884018.en.html Relation attributes have 3-properties: 1) kind 2) name 3) relatedDataClass The "kind" property tells you the type of relation: one or many. The "name" property is the name you

Re: Memory leak with dynamic variables in list boxes?

2018-07-26 Thread Jeremy French via 4D_Tech
Hi Michael, As pointed out by Oliver and Kirk, use LISTBOX GET ARRAYS to confirm the object names you think are present in the list box are in fact assigned as the object name to a header or footer. If not, you will get a nil pointer. So, see if the value for "FTR_Names_aT{$Ndx}" is present in

Re: Scheduled ISP Maintenance @ 4D Office (France)

2018-08-06 Thread Jeremy French via 4D_Tech
The URLs are still unreachable as of Monday morning, August 6th Eastern Daylight Time. It’s impossible to connect to: Taow.4d.com Livedoc.4d.com Forums.4d.com > On Aug 3, 2018, at 6:25 PM, Timothy Penner via 4D_Tech

Re: Multi-Style Reference Toggle

2018-08-07 Thread Jeremy French via 4D_Tech
For multi-style text areas, take a look at: http://doc.4d.com/4Dv17/4D/17/ST-SET-OPTIONS.301-3729984.en.html > On Aug 7, 2018, at 12:18 PM, Tom Dillon via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > In a multi-style text area, is it possible, like in 4D Write, to toggle the > display between

Re: 4d Write fonts missing

2018-08-17 Thread Jeremy French via 4D_Tech
“Times" is present but its spelling is different. Take a look at the list of fonts included with High Sierra: https://support.apple.com/en-us/HT206872\ > On Aug 17, 2018, at 11:32 AM, JOHN BAUGHMAN via 4D_Tech > <4d_tech@lists.4d.com> wrote: > >

Re: Execute on Server Method Attribute

2018-07-14 Thread Jeremy French via 4D_Tech
Does the database compile with compiler option “All variables are typed”? Have you tried assertions to test each parameter has the expected value type (test, date, time, pointer, pointed array type)? The failed assertion will be displayed on the server. > On Jul 14, 2018, at 10:12 AM, Stephen

Re: 4D Write PRO expressions

2018-07-17 Thread Jeremy French via 4D_Tech
Hi Miyako, What’s the difference between these 2-URLs. doc.4d.com cdn.doc.4d.com - Jeremy French > On Jul 17, 2018, at 4:16 PM, Keisuke Miyako via 4D_Tech > <4d_tech@lists.4d.com> wrote: > >

Re: subtables issue

2018-07-15 Thread Jeremy French via 4D_Tech
Hi Chuck, In answer to your several questions: > ...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 there. I believe 4D deprecated subtables starting with v11. When

Re: Problems installing built application

2018-07-22 Thread Jeremy French via 4D_Tech
Hi Don, Have you tried the following? In 4D, build the merged app. But do not use the signed application option. That is, leave the check box "signed application" unchecked. After the merge app is built, perform signing in Terminal. Replace with pertinent information the following place

Re: 4D v17 -> v16 data file backward compatibility

2018-07-24 Thread Jeremy French via 4D_Tech
v17 structure cannot be opened in earlier 4D version. But v17 data file can still be opened in v15 or v16. More details at: http://doc.4d.com/4Dv17/4D/17/Principles-for-conversion.200-3811872.en.html > On Jul 24,

Re: Drag n drop between processes - native Pasteboard only?

2018-07-10 Thread Jeremy French via 4D_Tech
Hi Chip, You don't need to use sets. Follow Keith's scheme, but without using 4D objects (which were not available until v14.) On Begin Drag, place the record's unique key in the text pasteboard. Or if there's more than one record, store a delimited list of the record keys in the text

Re: Any way to determine how a field's data storage is set?

2018-07-07 Thread Jeremy French via 4D_Tech
Hi John, In the exported XML structure, I believe there are 2-attributes whose presence/absence indicate where the field’s data will be stored: 1) in the record. 2) in the data file but outside of the record. 3) in an external file outside of the data file. The 2-XML attributes are: 1)

Re: UUID version 4 needed

2018-07-07 Thread Jeremy French via 4D_Tech
Is the version number being decoded correctly? According to Wikipedia, there are several variants of encoding UUIDs: 1) Little-endian 2) Big-endian 3) Mixed-endian To decode the UUID version number, you need to know what encoding variant was used: Little-endian, Big-endian or Mixed-endian.

Re: OPEN PRINTING JOB - how to hide the message window?

2018-07-09 Thread Jeremy French via 4D_Tech
Hi Pat, On the Mac you can show/hide the print progress message on a per print job basis. Call SET PRINT OPTION with the option "Hide printing progress option". The call to SET PRINT OPTION should be done **before** the call OPEN PRINTING JOB. See:

Re: problems with SEND RECORD

2018-07-03 Thread Jeremy French via 4D_Tech
Since you encountering more records than expected, do all records in the table “Approval” have False assigned assigned to the field “approved”? Try this in your method: ALL RECORDS([Approvals]) $count_all := Records in selection([Approvals]) QUERY([Approvals];[Approvals]approved=False)

Re: Import from Excel

2018-03-08 Thread Jeremy French via 4D_Tech
Hi Tim, Just tried the Tech Note using v16 without success. Apparently PHPExcel is deprecated. It’s successor is PHPSpreadsheet at: https://github.com/PHPOffice Could you possibly do a new edition of your Tech Note using PHPSpreadsheet and v16? Best regards,

Re: v13+ setting the current (working) directory

2018-04-23 Thread Jeremy French via 4D_Tech
Try 4D’s “SET ENVIRONMENT VARIABLE”. Look for “_4D_OPTION_CURRENT_DIRECTORY”. http://doc.4d.com/4Dv16R6/4D/16-R6/SET-ENVIRONMENT-VARIABLE.301-3547509.en.html > On Apr 23, 2018, at 12:56 PM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > the 'default' directory (on a Mac) for

How to Determine Field Type from XML Structure Export?

2018-04-19 Thread Jeremy French via 4D_Tech
When we export an XML structure, what does the "type" attribute indicate? For example, here is a snippet, from an XML Structure Export, for 3-fields: date, time and boolean. --- --- The above "type" attribute values do *NOT* correspond with the values returned the 4D command "Type".

Re: 4d16 r6 documentation

2018-03-31 Thread Jeremy French via 4D_Tech
What is “HAS”? See: "which HAS is.” — 1st paragraph below "I plan to upgrade HAS” — 2nd paragraph below > On Mar 31, 2018, at 5:04 AM, John Baughman via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > R releases are the pre-releases of the next shipping version (v17). v16R6 is > the latest R

Re: Write Pro setting print options

2018-03-22 Thread Jeremy French via 4D_Tech
Hi Pat, Have you tried calling the command WP USE PAGE SETUP *after* INVOKE ACTION? That is, the following call sequence works: INVOKE ACTION WP USE PAGE SETUP WP PRINT Also remember that the 4D Write Pro area must have the focus when INVOKE ACTION is called. Best regards, Jeremy > On Mar

Re: Multi-Table Query Into JSON?

2018-03-22 Thread Jeremy French via 4D_Tech
What is “template mode” for OB Copy? > On Mar 22, 2018, at 9:14 PM, Keisuke Miyako via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > if you are interested in getting an object array, you should not go through > json, you should procedurally use OB commands (OB copy in template mode). you > can

Re: Codesigning

2018-10-14 Thread Jeremy French via 4D_Tech
Have you tried entering this wording (taken from the screen shot you posted) — using the same case and spacing as shown below: Developer ID Application: Jeremy Roussak (6PT289NM55) > On Oct 14, 2018, at 9:54 AM, Jeremy Roussak via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > > What do I put

Re: Setting up an entity / collection listbox in code

2018-10-29 Thread Jeremy French via 4D_Tech
> It’s great to be able to make generic listboxes and set them up entirely in > code. It’s easy for array-based and selection-based listboxes, but can it be > done for entity/collection boxes? Yes. It's even more easy using collections. > In other words, are there LISTBOX SET xx calls to

Re: Checkbox in collection based listbox

2018-11-07 Thread Jeremy French via 4D_Tech
Hi Andrew, Did you set the “Data type" to “Boolean” in the Property List's “Data Source” theme? (The default data type is “String", which will only display “True” or “False” for Boolean values.) - Jeremy French > On Nov 7, 2018, at 2:57 AM, Andrew Hickey via 4D_Tech <4d_tech@lists.4d.com>

Re: Collection of Telemetry Data

2018-11-09 Thread Jeremy French via 4D_Tech
For communicating, take a look at: http://doc.4d.com/4Dv17R2/4D/17-R2.1720/HTTP-Request.301-3856768.en.html > On Nov 9, 2018, at 2:39 AM, Robert ListMail via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > I imagine this

Re: 4Dv17 + Windows 10 + VirtualBox

2018-11-12 Thread Jeremy French via 4D_Tech
Hi Pat, This reminds me of the the expression "The pump must be primed". With respect to building merged client/server apps where clients wil run on both platforms, "the pump must be primed". This means the initial client/server merge is performed on **each** platform. (This is the pump

Re: Placing a picture or graphic object

2018-11-11 Thread Jeremy French via 4D_Tech
Hi Peter, Ok, so the line is 1px wide and 60px high. You want to keep the line's dimensions but relocate the line to top = 0, left =55. Use absolute coordinates (which occur when the asterisk parameter is present.) Specify the top left coordinates as (x=55, y=0) Specify the bottom right

Re: INVOKE ACTION only works when I trace through it

2018-11-11 Thread Jeremy French via 4D_Tech
Hi Pat, Can you simply assign tEditText to the field after returning from the method *PicturePathSelect*? That is: *PicturePathSelect* (->tEditText) // choose a pic, copy pathname to tEditText [someTable]someField := tEditText Regards, Jeremy French > On Nov 11, 2018, at 12:39 PM, Pat

Re: Current time (*) incorrect today on v17?

2018-11-04 Thread Jeremy French via 4D_Tech
Are the server and client in the same time zone? In the US the time changed — in the early morning of November 4th — from daylight saving time to standard time. So, do both the server and client computers automatically set the date and time? If not, is the client still on daylight saving time?

Re: Annoying square

2018-12-16 Thread Jeremy French via 4D_Tech
Hi Carl, The 4D iNUG list is plain text only. (That’s why your screen shot wasn’t published.) But you can share images on the list (indirectly) by providing a link to the image. See https://postimages.org which offers free image posting. Just upload your screenshot

Re: View Pro

2018-12-05 Thread Jeremy French via 4D_Tech
Hi Jeremy, I believe 4D View Pro is actually a 4D web area. The 4D View Pro spread sheet is based on SpreadJS. SpreadJS documentation (difficult to read) is at: http://help.grapecity.com/spread/SpreadJSWeb/webframe.html#welcome.html You can use the command WA Evaluate JavaScript to do some

Re: v13+ Opening a structure interpreted

2018-09-13 Thread Jeremy French via 4D_Tech
Hi Chip, Yes. Open 4D first. Choose “File -> Open -> Open Local Database. After highlighting the database, do the following: On PC, click the drop down menu icon found on the “Open” button On Mac, click the “Options” button at bottom left. For both platforms a drop menu then appears. Choose

Transparency (Object property vs RGB color "Background color none")

2019-04-02 Thread Jeremy French via 4D_Tech
What is the difference between RGB Color constant "Background color none" Object Property "Transparent" checkbox = Transparent unchecked = If the object property "Transparent" is unchecked, then OBJECT SET RGB

What is "DirectWrite API" and "GDI API"?

2019-03-03 Thread Jeremy French via 4D_Tech
What is the meaning of: 1) DirectWrite API 2) GDI API used in the following sentence: "This is because the calculation of the best size for a list box is based on the DirectWrite API while other objects are based on the GDI API.” See “ Tech Tip: Differences of OBJECT GET BEST SIZE Behavior”

Re: 4D JSON Date Bug

2019-02-24 Thread Jeremy French via 4D_Tech
Hi Bart, If you store a date in an Object as a string, 4D interprets that date as a UTF date. So “2019-02-24” (giving only the date but not time) is interpreted as midnight on the 24th. That is at the stroke of midnight when the 24th day **starts**. When you retrieve the value around 6:30 PST

Re: Write Pro: Styling tables

2019-03-17 Thread Jeremy French via 4D_Tech
Hi Pat, "WP Get elements" returns a collection. So the first row is element 0. https://doc.4d.com/4Dv17R3/4D/17-R3/WP-Get-elements.301-3920772.en.html - Jeremy > On Mar 17, 2019, at 9:36 AM, Pat Bensky via 4D_Tech

Re: Write Pro: Styling tables

2019-03-17 Thread Jeremy French via 4D_Tech
Hi Pat, The docs seem to indicate we can’t apply style sheets to tables. See https://doc.4d.com/4Dv17R4/4D/17-R4/4D-Write-Pro-Attributes.300-403.en.html#Paragraph_3936745 - Jeremy > On

Re: Loose Object attribute typing

2019-03-12 Thread Jeremy French via 4D_Tech
Have you looked at the command “Value type” to test the value type of an object value? Value type https://doc.4d.com/4Dv17R3/4D/17-R3/Value-type.301-3906446.en.html Remember that the “String” command simply returns a string

Re: Printing forms modified with Duplicate Object

2019-03-07 Thread Jeremy French via 4D_Tech
Can we use real values for positioning and width/height with the "Print object" command? > On Mar 6, 2019, at 7:41 PM, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > have you looked into the "Print object" command? > > you can print … at any position (decimal, not integer

Re: Easy dynamic field highlighting

2019-02-17 Thread Jeremy French via 4D_Tech
Impressive! Polished! > On Feb 16, 2019, at 10:20 PM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > … adding dynamic field highlighting on the fly … improved animation ** 4D Internet Users Group (4D iNUG) Archive:

Re: v17 conundrum in design

2019-02-09 Thread Jeremy French via 4D_Tech
Using the Runtime Explorer window, ave you tried clicking "Delete All" for Break and Catch, even if no breaks or catches are listed? > On Feb 7, 2019, at 3:39 PM, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > no break points either in the method or when I show break points, yet

Re: On Drag Over Behavior

2019-02-14 Thread Jeremy French via 4D_Tech
Have you checked the property inspector for the drop variable? In particular are these 2-properties check-marked for the drop variable? 1) “Droppable” in the “Action” theme 2) “On drop” in the “Event” theme Also, if the “On drop” event code has $0, make sure $0 returns 0 or simply (for the

Re: On Drag Over Behavior

2019-02-14 Thread Jeremy French via 4D_Tech
Hi John, Using the pasteboard for drag and drop is so much easier. 4D changes clipboards briefly during the drag and drop events. Whatever was in the pasteboard **before** “On Begin Drag Over” is restored **after** the “On Drop” event completes. This means you can store drag information in

Re: Query by Formula Count of Records in Related Table

2019-02-18 Thread Jeremy French via 4D_Tech
Can you use ORDA? $entity_selection_o:=ds.theTable.query("theOneToManyRelationName.length = 0 OR theOneToManyRelationName.length > x") USE ENTITY SELECTION($entity_selection_o) Now each record in the current selection for theTable either has either no related records or more than x-related

Remote Runtime Error (What is an "entity set"?)

2019-02-08 Thread Jeremy French via 4D_Tech
The following runtime error appears on remote client in interpretive mode: 1802 — The “XX” entity set cannot be found https://i.postimg.cc/8c643XbC/p01-entity-set-error.png The documentation has a **different** description for error

Re: Popup/Dropdown element 0

2019-01-31 Thread Jeremy French via 4D_Tech
Hi Miyako, Your example database: https://doc.4d.com/4Dv16/4D/16.4/Pop-up-MenusDrop-down-Lists.300-3998943.en.html shows assigning a “Form” object to store the popup’s current state. The object assigned to

Re: use (storage)

2019-02-01 Thread Jeremy French via 4D_Tech
Hi David, No locking occurs with "Use (Storage)” by itself. But locking does occur for **first level** attributes of Storage. So “Use (Storage.pref)” performs locking in other processes. To prevent “Storage.pref” from being updated in a separate process, call: Use (Storage.pref) // make

Re: Web area and not secure site

2019-04-11 Thread Jeremy French via 4D_Tech
Have you tried making these calls in the form’s “form method”. In the form’s “On Load” event WA OPEN URL(*;$objName_webArea_t;"about:blank") WA SET PAGE CONTENT(*;$objName_webArea_t;"";"file:///“) SET TIMER(-1) In the form’s “On Timer” event SET TIMER(0)

Re: trying to Build double clickable app

2019-04-17 Thread Jeremy French via 4D_Tech
Hi Chip, As Chuck points out, did you specify the location of Unlimited Desktop? That is, Choose DESIGN -> BUILD APPLICATION. Select the “Application” tab. Check-mark “Build stand-alone application”. Click the ellipsis button (ie, “…”) and select 4D Volume Desktop. Click BUILD. - Jeremy > On

Re: Code signing works on one app but fails on another

2019-04-24 Thread Jeremy French via 4D_Tech
Hi Pat, Did you specify that DropDMG **also** sign the dmg file? In other words, your app is signed and the DMG file is also signed. You can sign the DMG through a DropDMG preference. See “DropDMG -> Preferences -> Configurations”. Look for “Signing”, and enter your Apple Developer

4D View Pro (How to set the"options.autoFitType" property?)

2019-04-26 Thread Jeremy French via 4D_Tech
How do I set the “options.autoFitT” type property? I am using the command "WA Evaluate JavaScript” to access more features of 4D View Pro (which uses SpreadJS from GrapeCity.) When I invoke “activeSheet.autoFitColumn”, I would like to **include** column header text for column resizing (as well

Re: WA SET PAGE CONTENT - doesn't work first time

2019-05-04 Thread Jeremy French via 4D_Tech
Is the “On Timer” event check-marked for the form? Is the Web Area’s “use embedded Web rendering engine” property check-marked? > On May 4, 2019, at 10:20 AM, Jeremy French via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Hi Pat, > > Try this (in the form’s form metho

Re: WA SET PAGE CONTENT - doesn't work first time

2019-05-04 Thread Jeremy French via 4D_Tech
Hi Pat, Try this (in the form’s form method) to initialize the web area: - Case of : (Form event=On Load) WA OPEN URL(*;$objName_webArea_t;"about:blank") WA SET PAGE CONTENT(*;$objName_webArea_t;"";"file:///") SET TIMER(-1) : (Form

4D Write Pro R4 (How to insert a table between 2-existing tables?)

2019-05-10 Thread Jeremy French via 4D_Tech
=== GIVEN === 1) 2-tables created one after the other: "A", "B". 2) A reference available to each table. 3) An empty string separates each-table. $range_o:=WP Create range(wpArea_o;wk end text;wk end text) WP SET TEXT($range_o;"";wk append;wk include in range)

4D Write Pro (where is list of reserved attributes?)

2019-05-17 Thread Jeremy French via 4D_Tech
Can I change a 4D Write Pro table’s id attribute to some custom value? A recent 4D Tech Tip "Write Pro Object Attributes" says: "With a 4D Write Pro object custom attributes and values can be assigned to the 4D Write Pro object as long as the attribute is not a reserved attribute.” Where do we

Re: 4D View - create spans?

2019-05-21 Thread Jeremy French via 4D_Tech
Hi Pat, Interesting 4D View Pro question. I just tried the following code; it merges cells. Remember that the index to rows and columns is zero based. For example, row #3 is index #2. This example merges 6 columns at row 4, column 1. Wrapping the javascript into an object is Miyako's

4D Moving Dialog (What does italicized text mean?)

2019-05-21 Thread Jeremy French via 4D_Tech
What do italicized rows indicate in the “Moving Dialog”? What is the difference between plain text rows and italicized rows? Example: https://i.postimg.cc/28KLB1PX/move-dialog.png ** 4D Internet Users Group (4D iNUG) Archive:

  1   2   >