RE: Way to get chosen ID field name?

Hi, I believe the following Tech Tip can help: http://kb.4d.com/assetid=77571 Best Regards, -Tai B. ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html

RE: Way to get chosen ID field name?

Hi, Sorry I spoke too soon, I thought you wanted to find the primary key fields name for a table, but you wanted the Name set in the preferences. I am not sure why you need this, but it is stored at the end of the following file: ...\4D\Resources\default.4DPreferences It is an xml formatted

RE: selection based list box

Hi, Have you tried passing 0 for the row number? According to the documentation: "If position is 0 and if the action parameter contains Listbox replace selection or is omitted, all the rows of the listbox are selected. If the action parameter contains Listbox remove from selection, all the

RE: How to show / hide all on Property List in v16?

Hi, Bugs reports have already been made on the expand/collapse all shortcuts. ACI0097204: [136792] Discrepancy Between Observed Behavior and Documented Behavior - Doc says that shortcut on Mac OS is Command+Click, that doesn't work but Control+Click seems to work. (32 bit) ACI0097205:

RE: Exporting/Importing Table Relations

Hi, It is possible to perform an export of the structure definition which contains the relationships. Most of the items are identified by UUIDs that 4D generates automatically. You may be able to parse the file and recreate the relationships by code as the relationships also contain the table

RE: FORM SET OUTPUT -> project form

Hi Pat, I think DIALOG might be the command you are looking for. http://doc.4d.com/4Dv16R4/4D/16-R4/DIALOG.301-3317982.en.html Best Regards, -Tai B. ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html

RE: identify duplicates

Hi David, Would the DISTINCT VALUES command help? http://doc.4d.com/4Dv16R4/4D/16-R4/DISTINCT-VALUES.301-3317277.en.html Best Regards, -Tai B. -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of David Witton via 4D_Tech Sent: Tuesday, October 31, 2017

RE: identify duplicates

Hi David, Perhaps using GROUP BY like Neil suggested in an SQL call in a similar fashion to the following will help: Begin SQL SELECT tbl.fld_1,tbl.fld_2,tbl.fld_3,Count(*) AS recCount FROM tbl GROUP BY tbl.fld_1,tbl.fld_2,tbl.fld_3 HAVING Count(*)>1 INTO

RE: Download 4Dv16R5

Hi Cannon, You can download them from: http://download.4d.com/Products/Current/4D_16R5/Installers/ Best Regards, -Tai B. -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Cannon Smith via 4D_Tech Sent: Thursday, May 10, 2018 12:55 PM To: 4D iNug

RE: stylized text

Hi, The documentation states http://doc.4d.com/4Dv16R6/4D/16-R6/ST-SET-ATTRIBUTES.301-3547533.en.html : "The startSel and endSel parameters can be used to designate the selection of text to which to apply the style modification(s) within the object. In startSel, you pass the position of the

RE: Graphing in 4Dv15

Hi, I have seen people using the Web Area to display charts using JS. Some have mentioned D3, Highcharts, and Google Charts. Maybe others can chime in with other references. Best Regards, -Tai B. -Original Message- From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of

RE: 4D 64-bit font darkness

Hi, What parts of 4D? On Windows, I opened 32-bit and 64-bit 4D v17 side by side and didn't see any seemingly noticeable difference between the two in terms of 4D's UI, the method editor, and a simple text variable object on a detail form. I did notice that the font on the Welcome Wizard was

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

Hi, For some reason it appears that the internet has been down since the ISP performed their maintenance. The ISP has been informed and should be working on it. Apologies for the inconvenience. Best Regards, -Tai B. ** 4D

RE: Check mark strangeness

Your assumption is true and it depends on the version of 4D that the Database was created in. http://doc.4d.com/4Dv15/4D/15/Unicode-mode-for-methods.300-2018652.en.html Best Regards, -Tai B. ** 4D Internet Users Group (4D

RE: SVG - Simple Example

Hi, A command that I find very useful is the SVGTool_SHOW_IN_VIEWER command. You pass the SVG document to it and it will display it in a new window which also allows you to toggle to it's XML source. Piggybacking off the earlier example: C_TEXT($svg;$ref) C_PICTURE($pict) $svg:=SVG_New //

RE: Query for null/empty UUID

Hi, Not sure if these are the Best Solutions, but there are two Tech Tips regarding this topic: Find and fix all Blank or Null UUID fields in an entire database: http://kb.4d.com/assetid=77576 A utility method that tests for a NIL UUID http://kb.4d.com/assetid=77266 Hopefully this helps.

RE: v17 - anyone know what OS is required (on a Mac)

Hi, Most of the demos are v16.x and v16Rx, most likely the most recent releases at the time of the summit are going to be used. The certification matrixes for both can be found on the download site: http://www.4d.com/downloads/products.html If you want to follow along with the slides, we've

RE: Icon & Picture Button Sources...

4D v16R6+ has a set of new icons to replace the old ones: https://blog.4d.com/icon-modernization-continues/ They should be located at the installed location in a resources > images > buttons folder. Best Regards, -Tai B. -Original Message- From: 4D_Tech

RE: Can Designer Groups Be Deleted?

Hi, http://doc.4d.com/4Dv17R2/4D/17-R2.1720/Managing-users-and-groups.300-3839424.en.html Under "Creating and configuring access groups" "Keep in mind that once a group has been created, it cannot be deleted. If you want to deactivate a group, you just need to remove any users it contains."

RE: Command Symbol as part of Title of Button

Hi, Have you tried the OBJECT SET TITLE command? OBJECT SET TITLE(*;"Button";Char(8984)+"T") Works for me on Windows and Mac, 4Dv16 and 4Dv17. Best Regards, -Tai B. ** 4D Internet Users Group (4D iNUG) Archive:

RE: Command Symbol as part of Title of Button

Hi, Hmm, not sure if it's just my machines or possibly caused by the emoji & symbol editor. But copying and pasting the character as a text character and not as an emoji/symbol allows me to paste the command symbol into the properties list Title section, the form editor and running the form

RE: Making sense of a crash report

Hi, The crash states an important item in Notes "Translocated Process" This means the application was translocated (moved) and is being run from a real-only location. Apple has been becoming more strict in how applications are distributing it and this appears on Macs due to distribution of

RE: Open a document in compiled: ok, but when with standalone get message: invalid path name

Hi, Something else to try is maybe running as Administrator. Perhaps it is a permissions issue. Also where is the file located? Maybe you can try a simple new file on the desktop and call it with a simple hardcoded method to make sure it works in the first place to confirm it may have

RE: v16 - playing videos stored in the database

Hi, Perhaps the following two Tech Tips can give you an idea on how to implement your feature: If HTML5 is available: http://kb.4d.com/assetid=77517 If Youtube is available: http://kb.4d.com/assetid=77911 Best Regards, -Tai B.

RE: exe file that can launch 4D client as well as Chrome?

Hi, Another command within 4D that can be used is the OPEN URL command: https://doc.4d.com/4Dv17R3/4D/17-R3/OPEN-URL.301-3906494.en.html ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options:

RE: Can't get to development mode!

Hi, Can you create a brand new database? If so you should have developer access on a .4DB file. If not do you have a developer license installed? Best Regards, -Tai B. ** 4D Internet Users Group (4D iNUG) Archive:

RE: 4D View Pro question

Hi, The VP Area is only available as a form object at the moment. If you mean how do you do this as an offscreen area you would probably have to build yourself a form that opens hidden from view and process your excel file in the VP Area then close the form when complete. Best Regards, -Tai

RE: Konstants - trying to determine where it is defined

4D's constants? I believe its in the xliff located at {4D vXX}\{4D, 4D Server, or 4D VD...}\Resources\en.lproj\4D_ConstantsEN.xlf I only have INTL installed so the en might be different based on local. -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Chip

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

Hi, According to the Documentation https://doc.4d.com/4Dv17R4/4D/17-R4/Moving-dialog-box.300-4085734.en.html "...the dependent objects appear in italics..." Best Regards, -Tai B. -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Jeremy French via 4D_Tech

RE: v15 - change method properties, more then one at a time

Hi Chip, I see this feature in the explorer's Methods section. At the bottom click on the gear drop down button and there is a "Batch Settings of attributes..." item. This is on v15.6. -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Chip Scheide via

RE: How do I access a component form from a host

Hi, It should be available in the drop down for the "List Form" property of a Subform object's property list: Scroll down to the "Using a component subform (host database)" section for more details and images:

RE: 4D v18.0 LTS - Form Wizard Missing

To add onto that. Project mode does have a "shortcut" way to add fields and field titles to the form: https://kb.4d.com/assetid=78416 Best Regards, -Tai B. -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Tom Benedict via 4D_Tech Sent: Wednesday, February

RE: Bar code

Hi All, Just another tip: It might be a little overkill in some cases, but 4D View Pro has built-in formulas to convert a value to a barcode and qr codes. The formulas start with "=BC_CO..." for most of the bar codes and "=BC_QRCODE()" for the qrcode. More information on the 11 types: