Re: Detecting field properties that can take nulls

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

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

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)

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

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

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

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

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"?)

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?

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?

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

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

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

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

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

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

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: v13+ What table does a set belong to?

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

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

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?

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

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

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

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?

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

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

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

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

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

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?

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

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

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

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

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

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

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

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

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

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

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

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?

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?

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)

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

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

“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

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

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

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

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

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?

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?

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

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?

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

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

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

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?

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

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

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

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

> 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

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

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

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

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

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?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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"?)

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

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)

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

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

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

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

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: Arrays in objects

This stores the headers in an object, and retrieves the headers from that object as arrays: // construct the get header/value pairs $c:new collection $c.push(New object("header";"A";"value";"AV")) $c.push(New object("header";"B";"value";"BV")) // add more headers // the object you want

Notarize Custom Workflow (Submit your software)

The presentation slides for "All About Notarization” show, on page 129, a submission and response. QUESTION — How quickly does the "Result" response appear? See image of page at: https://i.postimg.cc/sXMqksFh/p129-submit-your-software.png --- Details at: All About Notarization

Re: Username/password dialog timeout in v17

Perhaps in "Database Settings -> Client-server -> Client-Server Connections Timeout”. > On Jun 20, 2019, at 9:14 PM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > if the timeout that 4D Server will allow 4D Remote to stay at the > username/password dialog can be adjusted?

Re: Drag & drop a file - what am I missing?

Hi Pat, Take a look at the documentation for "Get file from pasteboard” at: https://doc.4d.com/4Dv17/4D/17.2/Get-file-from-pasteboard.301-4387094.en.html Put the following in the object method of a text variable and

POSIX Path Syntax (How to convert from 4D POSIX to Terminal POSXIX?)

How do we resolve POSIX file path syntax between 4D and Mac Terminal? This Mac system path has a space in the folder name "Final Application": Macintosh HD:Users:jeremyfrench:Desktop:test_notarize_01:test_notarize_01_Build:Final Application:test_notarize_01.app: 4D's POSIX shows the space in

Re: View Pro: Setting column widths

Hi Pat, When there is no 4D command to do something in 4D Write Pro, try javascript. I suggest using an anomymous javascript function. Build your javascript code using a 4D Object with the “New formula” command. The basic shell — for an anonymous javascript function in 4D code — is the

Re: 4D View - create spans?

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

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:

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

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

  1   2   >