Re: UUID query ignores characters 33 to n.... didn't know that!

2018-09-02 Thread Keisuke Miyako via 4D_Tech
it's not that "query ignores characters", it has more to do with how string-to-uuid conversion works. to understand how it works, create a UUID field, create a record, assign a value. e.g. CREATE RECORD([Table_1]) [Table_1]Field_2:="www" you will notice that Field_2 which is a UUID, evaluates

Re: Strange XML problem

2018-09-19 Thread Keisuke Miyako via 4D_Tech
I think it would be more practical if you could elaborate how exactly you "import" the XML (it could mean so many different things) as well as what you mean when you say "some" of the data is missing. we are happy to help, but a piece of XML included in an email does not feel like the right way

Re: 4D v17 pause when printing to Canon ImageRunner printer

2018-09-19 Thread Keisuke Miyako via 4D_Tech
pure speculation, but I will put it out there just in case: first, v15 is 32-bits and carbon, v17 is 64-bits and cocoa. so there is a massive difference there. then, evidently the print option "Hide printing progress option" is no longer supported in 64-bits,

Re: Anyone using FTP_Receive under 64-bit? SOLVED

2018-09-21 Thread Keisuke Miyako via 4D_Tech
it is unfortunate, that the doc does not mention on all pages what is explained here: http://doc.4d.com/4Dv15/4D/15/4D-Internet-Commands-64-bit-version-for-OS-X.300-2048298.en.html quote: Unsupported interface features With respect to OS X user interface specificities, the following features

Re: How to get the current time in a specified time zone

2018-09-24 Thread Keisuke Miyako via 4D_Tech
actually you can get UTC time without a network connection: // v17 C_TIME($t) XML DECODE(Delete string(Timestamp;24;1);$t) // before C_TIME($t) XML DECODE(Delete string(string(Current date;ISO date GMT;Current time);20;1);$t) both of which are effectively "substring" + "time" operations that

Re: Printing A3 format on windows when scaling is not possible

2018-09-26 Thread Keisuke Miyako via 4D_Tech
there should be no reason to use PAGE SETUP, although there is nothing wrong about using it. it's just a convenient shorthand that dates back to the times when 4D had far fewer commands. http://doc.4d.com/4Dv16/4D/16.2/Print-settings-to-BLOB.301-3432852.en.html

Re: CalDAV server from 4D

2019-01-04 Thread Keisuke Miyako via 4D_Tech
a fully featured CalDAV server running on 4D would require the web code to respond to all types of HTTP requests as specified in the related RFC https://en.wikipedia.org/wiki/CalDAV but if you do not need to add, delete or modify events, serving a .ics file is no different to serving a .jpg

Re: 4D Authentication Strategy...

2019-01-04 Thread Keisuke Miyako via 4D_Tech
I would urge you to take a look at the video, https://blog.4d.com/single-sign-on-sso/ it show the code on the client side and the server side that manages authentication. > 2019/01/05 6:36、Robert ListMail via 4D_Tech <4d_tech@lists.4d.com>のメール: > > Tim, I just toggled on the checkbox on the

Re: XPS Viewer on Windows 10 - Removed in new OS installs -

2019-01-16 Thread Keisuke Miyako via 4D_Tech
not fully tested but it's open source so feel free to try: https://github.com/miyako/4d-tips-3rd-party-xps-viewer > 2019/01/17 2:42、Randy Engle via 4D_Tech <4d_tech@lists.4d.com>のメール: > Is there anything in the works as a previewer replacement instead of XPS > viewer?

Re: Annoying square

2018-12-13 Thread Keisuke Miyako via 4D_Tech
it must be the application process splash window. there was a bug in v13 where the window size got messed up. go to database settings, interface, and make the splash window visible if not already. I assume this is mac; when you “show all windows” you should find that the square is a window

Re: How to print a document from LEP?

2018-12-17 Thread Keisuke Miyako via 4D_Tech
if you have already figured out how to do it via the CLI, you are just one step away from doing the same with LEP. if the application (AcroRd32.exe in your case) does not run directly via LEP, you probably need to start it via cmd.exe (the console application). see ex.10

Re: Where the f*** is the knowledge base hidden???

2018-12-20 Thread Keisuke Miyako via 4D_Tech
Evidently, this is standard Mac/Safari behaviour (HSTS). A system Daemon is telling Safari that all *.4d.com access should be forced https: regardless of what was entered in the address bar. (Chrome respects the address, but it will display a warning that the site is insecure).

Re: WA Evaluate JavaScript in 16.4

2018-12-20 Thread Keisuke Miyako via 4D_Tech
originally designed as a "beginner language" JS has some tolerant syntax rules, being OK to omit the line terminator ";" is one of them. of course, this could only work if the end-of-line can be implied without a ";" (for example, by \n) I can understand the motivation to remove all \n from

Re: Storing Dates and Times From Different Time Zones

2018-12-20 Thread Keisuke Miyako via 4D_Tech
oops! this works for the time but not the date! 2018/12/21 11:02、Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>>のメール: XML DECODE($ISO;$d) ** 4D Internet Users Group (4D iNUG) Ar

Re: Storing Dates and Times From Different Time Zones

2018-12-20 Thread Keisuke Miyako via 4D_Tech
is this a competition? then here's my entry: $ISO:=String(Current date;ISO date GMT;Current time) C_DATE($d) C_TIME($t) XML DECODE($ISO;$d) XML DECODE($ISO;$t) ** 4D Internet Users Group (4D iNUG) Archive:

Re: Storing Dates and Times From Different Time Zones

2018-12-20 Thread Keisuke Miyako via 4D_Tech
this works for dates...but not very practical, obviously. C_DATE($d) C_TIME($t) $dbp:=Get database parameter(Dates inside objects) SET DATABASE PARAMETER(Dates inside objects;String type with time zone) $d:=JSON Parse("\""+$ISO+"\"";Is date) XML DECODE($ISO;$t) SET DATABASE PARAMETER(Dates

Re: v16 Replacement for 4D-Pack command: 'AP Get table info'

2018-12-11 Thread Keisuke Miyako via 4D_Tech
EXPORT STRUCTURE http://doc.4d.com/4Dv17/4D/17/EXPORT-STRUCTURE.301-3729506.en.html look for leave_tag_on_delete="true" http://www.4d.com/dtd/2007/base.dtd; > > 2018/12/11 17:11、Jörg Knebel via 4D_Tech <4d_tech@lists.4d.com>のメール: > > I need the value returned in “destruct”. > Is

Re: Runtime error ST GET OPTIONS

2018-12-14 Thread Keisuke Miyako via 4D_Tech
I would use an intermediate local variable instead of using an object notation property directly as a command/function parameter. not all commands work with properties. --- the grammar makes a distinction between a value and a variable which is a container of a value. formulae that evaluate

Re: Windows Server Machine TCP Overload?

2018-12-14 Thread Keisuke Miyako via 4D_Tech
quick Google results, so don't quote me on this https://support.microsoft.com/en-us/help/832017/service-overview-and-network-port-requirements-for-windows other pages (old, window server 2008-ish) says the number socket ports is 65535-49152=16383 but the range can be expanded with "netsh" e.g

Re: v13 - Exporting tab delimited

2018-11-28 Thread Keisuke Miyako via 4D_Tech
I suppose the right way to create a "cell" with multiple lines in TSV is to use vertical tab char(11) instead of CRLF, but the last time I checked, Excel doesn't handle VT well. (Numbers does). for CSV with quotes I published https://github.com/miyako/4d-component-csv which follows the various

Re: Transferring Build Mac Client via Google Drive Web Interface Fails

2018-11-28 Thread Keisuke Miyako via 4D_Tech
the target path can be found in the build project for instance, in this example, the path is accessible with the code If (Is macOS) $path:=$BuildApp.BuildMacDestFolder Else $path:=$BuildApp.BuildWinDestFolder End if $path:=$path+"Final Application"+Folder separator

Re: TAOW (Mojave and CREATE THUMBNAIL)

2018-11-28 Thread Keisuke Miyako via 4D_Tech
TAOW is a support portal. of course, a large portion of all support cases has an underlying bug, but still, the primary objective there is to offer support. partners who open a support case on TAOW, has the advantage of communicating with a 4D member of staff. the bug is prioritised because

Re: v13 - Exporting tab delimited

2018-11-28 Thread Keisuke Miyako via 4D_Tech
you can export related fields. the component expects an object array as JSON. you just use 4D commands to populate that array however way you like. true, Selection to JSON does not activate automatic relations, but it is by no means the only way to create an object array. the component is quite

Re: Integration with card payment terminal

2018-11-28 Thread Keisuke Miyako via 4D_Tech
it seems like they offer a REST API https://epayments.developer-ingenico.com/documentation/sdk/ 2018/11/24 16:24、macjimbo via 4D_Tech <4d_tech@lists.4d.com>のメール: Has anyone integrated a 4D application with a chip & pin terminal eg Ingenico?

Re: v13 - Exporting tab delimited

2018-11-28 Thread Keisuke Miyako via 4D_Tech
that's fair, exporting XML spreadsheets only makes sense if the idea is to open it with Excel. for CSV or TSV with proper quotation of data that contains CR, LF, quotes, commas, etc. the example https://github.com/miyako/4d-component-csv is for v15 and above but the core regex stuff might be

Re: PDF - TEXT CONVERSION

2018-11-28 Thread Keisuke Miyako via 4D_Tech
it generally fails you when passed a complex PDF (redundant text, etc) but you could try: https://github.com/miyako/4d-component-poppler https://github.com/miyako/4d-plugin-PDF2TEXT this might work too (but you would have to research the syntax) https://github.com/miyako/4d-plugin-gs

Re: v16.4 Desktop application, Rejected

2018-11-28 Thread Keisuke Miyako via 4D_Tech
2018/11/27 1:20、Carl Aage Wangel via 4D_Tech <4d_tech@lists.4D.com>のメール: But I am at a bit of a loss as where to find OpenSSL in 4D and how to update the libraries (same for jQuery). the file names are libeay32.dll and ssleay32.dll on windows. but again, the ones

Re: SQL query for the current date

2018-12-03 Thread Keisuke Miyako via 4D_Tech
I would hazard a guess that the CURRENT_DATE() function is called for every record (row) in the table. to verify: create a project method "CD" published for SQL: $0:=Current date place a break point. --- then do ARRAY DATE($ad;0) Begin SQL SELECT Field_2 from Table_1 WHERE {FN CD() AS

Re: 4D Mojave full disk access

2018-12-03 Thread Keisuke Miyako via 4D_Tech
full disk access on Mojave protect system directories that store private and sensitive information, such as browser history, call history, geolocation, messages and contacts. https://developer.apple.com/videos/play/wwdc2018/702 see slide #22 for full list 2018/12/04 5:49、JOHN BAUGHMAN via

Re: Mojave

2018-12-03 Thread Keisuke Miyako via 4D_Tech
Hello, there are 4 Mojave related issues listed on the 17.0HF 4 fix list. https://bugs.4d.fr/fixedbugslist?version=17.0_HF4 ACI0098799On macOS 10.14.x (Mojave), unexpected white vertical line is displayed in the Administration window. ACI0098805Unexpected error "Could not open the specified

Re: v17 kind of gotcha

2018-12-05 Thread Keisuke Miyako via 4D_Tech
in addition to accidental duplicates by SQL, it was also possible to end up when a listbox is grouped, duplicated and ungrouped. (ACI0069120 fixed in 12.6) also possible for headers and footers via OBJECT DUPLICATE (ACI0083469, fixed in 15.1 HF1) MSC added checks for duplicate object names (see

Re: CONVERT PICTURE not seeming to work for me...

2018-12-06 Thread Keisuke Miyako via 4D_Tech
quicktime is only necessary if you want to convert qti images (v2004 or earlier used this format to handle jpeg on windows) you also need to enable quicktime with set database parameter. for pict (quickdraw, not quicktime) you just need 32-bit i.e. altura mac2win

Re: View Pro

2018-12-06 Thread Keisuke Miyako via 4D_Tech
I have posted a demo goto 3. WA page, click JS, select a code snippet and click Execute. click Method and run directly from editor to see how it works. https://github.com/miyako/4d-tips-view-pro-javascript ** 4D Internet

Re: Transform picture

2018-12-04 Thread Keisuke Miyako via 4D_Tech
in general, I would avoid applying multiple scale transforms, but rather, restore the original size (scale is not resampling, the original image does not change) and apply a new scale factor. 2018/12/05 4:53、Peter Mew via 4D_Tech <4d_tech@lists.4d.com>のメール: It

Re: Resource Pictures

2018-11-23 Thread Keisuke Miyako via 4D_Tech
some converted structures contain negative picture resources IDs. you must first assign them positive IDs, but this must be done manually. find in design, search negative number. double click search result (form object). confirm that the object is a resource picture. in property list, change

Re: One Set of Code for Form Object Populated Forms as well as Field-Based Detail View Forms

2018-11-23 Thread Keisuke Miyako via 4D_Tech
it is not a bug. the 1st generation of form design in 4D was to bind process variables to objects and use variables directly in code. the 2nd generation of form design (v12) was to keep the bound variable empty and use pointers to reference dynamic variables. the main difference was in the

Re: TAOW (Mojave and CREATE THUMBNAIL)

2018-11-25 Thread Keisuke Miyako via 4D_Tech
it is already registered and fixed in the latest nightly build. problem only manifests if the width is a multiple of 4. ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options:

Re: Selection-based Listbox Deletions...

2018-11-20 Thread Keisuke Miyako via 4D_Tech
thank for the correction, I was wrong; I had totally missed that piece of information. so the delete "subrecord" standard action applies to selection based list boxes too. I should have read between the lines in the original post that if the button was active, it must be responding to the

Re: Explorer bottom toolbar not displaying...

2018-11-20 Thread Keisuke Miyako via 4D_Tech
or, just close the Explorer and bring it back while holding down the shift key. Open form window (...;*) window bounds are reset with the shift key. 2018/11/21 4:37、Randy Jaynes via 4D_Tech <4d_tech@lists.4d.com>のメール: First guess is to quit 4D and throw out the

Re: Selection-based Listbox Deletions...

2018-11-20 Thread Keisuke Miyako via 4D_Tech
the "delete subrecord" standard action was updated to work as "delete selection" in v2004, which works on list forms and list subforms (with focus). but selection-based list box did not exist back then, and it was never further updated to work for list boxes. using it outside the context of a

Re: Selection-based Listbox Deletions...

2018-11-20 Thread Keisuke Miyako via 4D_Tech
"current selection" obviously needs qualification; of which table. the table is implied in the context of a list form (modify/display selection), but for list subforms it is the master table of the subform object, as defined in its property list. you can have multiple sub forms on the same form,

Re: LAUNCH EXTERNAL PROCESS, v15, on MacOS Mojave

2018-11-19 Thread Keisuke Miyako via 4D_Tech
could you not simply do OPEN URL ($path) //default app OPEN URL ($path;"Preview") //specified app http://doc.4d.com/4Dv15/4D/15.6/OPEN-URL.301-3817577.en.html 2018/11/19 22:56、Two Way Communications via 4D_Tech <4d_tech@lists.4d.com>のメール: The syntax I use is:

Re: http get, error 30 when ran as service (v15 windows)

2018-11-20 Thread Keisuke Miyako via 4D_Tech
in our office, when we use the local internet service provider's DHCP, we randomly get error #30 when trying to access some large U.S. services such as Google. if we use Google's DHCP 8.8.8.8. the call succeeds. apparently some ISPs fail to resolve certain foreign domain names. haven't tried,

Re: Form Scaling & Optimal Fonts...

2018-11-19 Thread Keisuke Miyako via 4D_Tech
are you sure? just tested, OBJECT Get font on an automatic stylesheet object returns .SF NS Text as for the search widget, it was released with v12 so the stylesheet is "Default", not automatic. but I agree, it's badly designed. 2018/11/19 23:46、Jeffrey Kain via 4D_Tech

Re: TAOW (Mojave and CREATE THUMBNAIL)

2018-11-25 Thread Keisuke Miyako via 4D_Tech
for reference: ACI0098954 https://bugs.4d.fr/fixedbugslist?Version=17.0_HF4 2018/11/25 18:18、Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>>のメール: it is already registered and fixed in the latest nightly build. problem only manifests if the width is a m

Re: v16.4 Desktop application, Rejected

2018-11-25 Thread Keisuke Miyako via 4D_Tech
OpenSSL 9.8 is the copy used by the integrated PHP. 4D is not using PHP in the context of a public web server. it has no impact on security. I wasn't aware of jQuery, but it looks like the welcome dialog uses it. again, it has no impact on security. --- as for keeping the libraries up-to-date:

Re: JSON from Google Sheet to Property Object

2018-11-26 Thread Keisuke Miyako via 4D_Tech
you are confusing property names and array positions. $lastName:=$convertedObject[“ID”][“6015906”][“Last Name”] this would infer {"ID":{"6015906":{"Last Name":__here_}}} if the target is [ [ID,First Name,Last Name], [5912029,Sannyasin,Siddhanathaswami], [6015906,Mayuran,Sokkan] ] then the

Re: Need to convert HTML page with table to JSON

2018-11-27 Thread Keisuke Miyako via 4D_Tech
the web site you mentioned uses this file https://github.com/abdmob/x2js but the real challenge is to cajole HTML code that is not strictly XML 2018/11/28 14:41、Tim Nevels via 4D_Tech <4d_tech@lists.4d.com>のメール: Anyone have some sample code they can share, or

Re: LAUNCH EXTERNAL PROCESS, v15, on MacOS Mojave

2018-11-20 Thread Keisuke Miyako via 4D_Tech
for sure you can open word or excel documents. what you can't do is specify which version of Word (if there are multiple installations) is launched. 2018/11/20 18:42、Two Way Communications via 4D_Tech <4d_tech@lists.4d.com>のメール: Yes, I could. But sometimes it

Re: Form Scaling & Optimal Fonts...

2018-11-18 Thread Keisuke Miyako via 4D_Tech
> 2018/11/11 7:43、Robert ListMail via 4D_Tech <4d_tech@lists.4d.com>のメール: > > Form Scaling... Is this still a thing? :) The feature was originally introduced to compensate for the DPI difference (72 on Mac, 96 on Windows). There is an interesting background story on why the 2 camps decided on

Re: V15 and SQL

2018-11-18 Thread Keisuke Miyako via 4D_Tech
could it be possible that triggers are disabled by code? http://doc.4d.com/4Dv15/4D/15/ALTER-TABLE-DISABLE-TRIGGERS.300-2048419.en.html http://doc.4d.com/4Dv15/4D/15/ALTER-DATABASE-DISABLE-TRIGGERS.300-2048403.en.html > 2018/11/15 8:25、Robert McKeever via 4D_Tech <4d_tech@lists.4d.com>のメール: > a

Re: Transferring Build Mac Client via Google Drive Web Interface Fails

2018-11-19 Thread Keisuke Miyako via 4D_Tech
the information about where a file was downloaded from, is stored in extended file attributes. it had nothing to do with code signature or md5 checksum. if necessary, you can clear it with cli xattr -rc you can sign a built app from the cli or from 4D, but in addition to that, you need to

Re: v13- Chasing Relations

2019-01-08 Thread Keisuke Miyako via 4D_Tech
I follow every 1-to-n and n-to-1 relations in this component https://github.com/miyako/4d-component-classic-query-editor mind you, relations can be circular... 2019/01/09 5:47、Chip Scheide via 4D_Tech <4d_tech@lists.4d.com>のメール: --- if there are 1 or more

Re: MSC: why "Checking list of deleted records ..." persists?

2019-01-13 Thread Keisuke Miyako via 4D_Tech
https://doc.4d.com/4Dv17/4D/17/Compact-page.300-3743562.en.html check out "Compact address table" > 2019/01/13 1:29、Spencer Hinsdale via 4D_Tech <4d_tech@lists.4d.com>のメール: > > Isn’t there an option for Compact to drop Address Tables? This invalidates > any Log Files but gives table(s) a clean

Re: Property List

2019-01-09 Thread Keisuke Miyako via 4D_Tech
perhaps you are using TeamViewer QuickConnect https://kb.4d.com/assetid=77767 2019/01/09 23:41、stardata.info via 4D_Tech <4d_tech@lists.4d.com>のメール: Hi all, I use 4D V13.4 for one my application on windows. If i chose to see the Property list in the designer environment for one form, the

Re: 4D Remote hanging at 3am after upgrading to Hi Sierra. Need logging advice.

2019-01-03 Thread Keisuke Miyako via 4D_Tech
F.Y.I. ACI0098967 fixes the App Nap slowdown which could apply to a 4D Server with no active user interface (i.e. Admin Window). this is v17 build 230086 from 23rd Nov. https://bugs.4d.fr/fixedbugslist?branch=17 for other versions I offer https://github.com/miyako/4d-plugin-prevent-app-nap

Re: REDRAW WINDOW not working v17?

2019-01-03 Thread Keisuke Miyako via 4D_Tech
a few pieces of information would be appreciated: - is this Mac or Windows? - is this 64-bit only? I guess you reference the variable in your On Display Detail, but that event doesn't fire unless the detail area needs to be redrawn (activated, deactivated, selection changed). that was always

Re: ListBox - assign pulldown array ?? a la ALPro for Data Entry

2019-01-03 Thread Keisuke Miyako via 4D_Tech
the original post specified v13, which restricts options. v14 has OBJECT SET LIST BY REFERENCE which makes life a lot easier. http://doc.4d.com/4Dv16/4D/16.4/OBJECT-SET-LIST-BY-REFERENCE.301-3978434.en.html c.f. http://forums.4d.com/Post/FR/27013321/1/27039356#27039356 2019/01/02

Re: v16 - playing videos stored in the database

2018-09-15 Thread Keisuke Miyako via 4D_Tech
on the client side, technically it could be as easy as having an HTML5 video tag and specify an mp4 file as its src attribute, but for performance you can't just serve a large video file directly from the web folder as if it were a still jpeg photo. you would need a purpose build video

Re: v16 - playing videos stored in the database

2018-09-15 Thread Keisuke Miyako via 4D_Tech
if you must serve directly from 4D, conceptually, the On Web Connection database method must process the "range" HTTP header, https://developer.mozilla.org/en-US/docs/Web/HTTP/Range_requests and return the requested video segment. you could either splice the BLOB stored in your database

Re: good job needs good doc

2018-09-14 Thread Keisuke Miyako via 4D_Tech
The URL should be localised for each R release, you should be able to restore it with "Factory Settings". http://doc.4d.com/4dv16r6/help/command/ja/ ja = fr, en, etc. > 2018/09/13 0:44、Arnaud de Montard via 4D_Tech <4d_tech@lists.4d.com>のメール: > > When I use 4dv16r6, I'd like the alt clic

Re: 4d will not start ssl on 443

2019-03-29 Thread Keisuke Miyako via 4D_Tech
the helpertool prompt is only presented if you start the web server by code, menu or click. there is no dialog if the "start web server on startup" database setting is enabled. this is to avoid the UI showing up on an unattended service. I did not get any q. from helpertool when started up 4d

Re: SFTP

2019-03-27 Thread Keisuke Miyako via 4D_Tech
I do not support (by which I mean test) versions before v16, but plugin architecture has basically not changed since v14. that said, if you mean v14 mac, you need to use the 32-bit version (carbon). > 2019/03/27 3:08、Ed Heckman のメール: > Is there a version of this plugin that works for v14? (We're

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

2019-04-03 Thread Keisuke Miyako via 4D_Tech
the text edit setting "smart dashes" may convert double hyphens to dash, which is not what you want in this context. https://support.apple.com/kb/PH23628?locale=ja_JP=en_US a single hyphen must be used with a short option name (-f) a double hyphen must be used with a short option name (--force)

Re: Best scripting language to use with LEP (docx to PDF)

2019-04-06 Thread Keisuke Miyako via 4D_Tech
I might be mistaken, but my understanding is that Word on Windows embeds hyperlinks when exporting to PDF, whereas Word on Mac doesn't (same with any app that performs print-to-pdf using the system feature) another approach maybe to use wkhtmltox

Re: Form Print Settings (And Their Little Secrets)

2019-04-06 Thread Keisuke Miyako via 4D_Tech
can you not call PAGE SETUP https://doc.4d.com/4Dv17/4D/17.1/PAGE-SETUP.301-4179624.en.html followed by GET PRINT OPTIONS https://doc.4d.com/4Dv17/4D/17.1/GET-PRINT-OPTION.301-4179604.en.html ? 2019/04/06 4:18、Ben Sokal via 4D_Tech <4d_tech@lists.4d.com>のメール:

Re: Form Print Settings (And Their Little Secrets)

2019-04-06 Thread Keisuke Miyako via 4D_Tech
early versions of 4D used forms for multiple purposes: QUERY BY EXAMPLE IMPORT TEXT EXPORT TEXT MODIFY SELECTION DISPLAY RECORD PRINT LABEL etc. most things were done using just table forms, with little to no code. --- now, instead of storing print settings in forms, you can simply use BLOBs

Re: Best scripting language to use with LEP (docx to PDF)

2019-04-06 Thread Keisuke Miyako via 4D_Tech
if you go down the automation (applescript) route, be sure where you create the result document. Word is sandboxed, so you can only export to the temporary folder in 4D code $path:=Temporary folder+"com.microsoft.Excel"+Folder separator this would be for CFBundleShortVersionString > 14 i.e.

Re: Printing Structure Diagram

2019-03-30 Thread Keisuke Miyako via 4D_Tech
you should note that native XSLT is removed in 64-bit so you need to either use a 32-bit or an alternative solution such as https://github.com/miyako/console-xsltproc or https://github.com/miyako/4d-plugin-xslt > 2019/03/31 8:29、Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com>のメール: > Check this

Re: Printing Structure Diagram

2019-03-30 Thread Keisuke Miyako via 4D_Tech
alternatively, you create a form with one picture object, sized to fit your paper size. you use TRANSFORM PICTURE with the Translate option which allows you to "trim" the SVG at any location without bitmap resampling (which is what happens when you convert to PNG or combine pictures). you print

Re: Current Time(*) timezone

2019-02-25 Thread Keisuke Miyako via 4D_Tech
Current time(*) and Current date(*) are returned the server's timezone. if daylight saving ended on the server side, but not on the client side, nothing is done to convert the value across timezones. the advantage of using Timestamp (UTC) is that it is agnostic to timezones. 2019/02/26 6:21、Jim

Re: 4D JSON Date Bug

2019-02-25 Thread Keisuke Miyako via 4D_Tech
Note: variable names are not supported to start with a number ($4dDate) the line OB SET($obj;"apiDate";"2019-02-24") does not set a date value. it sets a string that looks like a date to some people. try something like $obj:=New object OB SET($obj;"d1";Current date) OB

Re: user-agent html formatting on android outlook

2019-02-26 Thread Keisuke Miyako via 4D_Tech
are you sure this is actually an issue specific to Active4D? it is not uncommon for mail servers or even clients to automatically create plain text versions of an HTML message. it sounds like your tags have been removed that way. you might want to widen your scope of investigation to search

Re: Comparing two structures...

2019-02-26 Thread Keisuke Miyako via 4D_Tech
I suppose you could export the structure in XML format (no command yet in v13 but you can always do it from the menu) and compare. https://doc.4d.com/4Dv17/4D/17.1/Exporting-and-importing-structure-definitions.300-4201101.en.html 2019/02/27 11:42、Robert ListMail via 4D_Tech

Re: Printing forms modified with Duplicate Object

2019-03-06 Thread Keisuke Miyako via 4D_Tech
have you looked into the "Print object" command? you don't need to duplicate an object, you can print the same object as many times as you like, at any position (decimal, not integer positioning) with 17R you can define an object (JSON) representation of a form from scratch, or take an existing

Re: Printing Page Subforms in Columns/Rows in v17

2019-03-04 Thread Keisuke Miyako via 4D_Tech
printing is not supported for page subforms. it's as simple as that. the only way to "print" a page subform is to FORM LOAD and Print object. I don't understand how 4D picks the table for the page subforms, but it uses the same output form as before!

Re: Highlighting rows using Row Font Color Array

2019-03-03 Thread Keisuke Miyako via 4D_Tech
see blog https://blog.4d.com/customize-highlight-color-upon-listbox-row-selection/ 2019/03/04 6:14、James Knight via 4D_Tech <4d_tech@lists.4d.com>のメール: Does anyone know a way to work around this?

Re: Write Hex Bytes

2019-02-21 Thread Keisuke Miyako via 4D_Tech
you're right, I re-read the OP, the task was to process a single value 78,487,500 or 0xCC9FAD04; not 4 separate decimal values 78, 48, 75 and 00 > 2019/02/22 9:43、Justin Carr via 4D_Tech <4d_tech@lists.4d.com>のメール: > > C_BLOB($vX_Data) > C_LONGINT($vL_Offset) > > $vL_Offset:=0 > LONGINT TO

Re: Write Hex Bytes

2019-02-21 Thread Keisuke Miyako via 4D_Tech
> 2019/02/22 9:45、Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com>のメール: > the task was to process a single value 78,487,500 or 0xCC9FAD04; correction: decimal 78,487,500 is 0x04AD9FCC > If I have a number 78487500, this translates to CC 9F AD 04. but PC byte ordering will gi

Re: Write Hex Bytes

2019-02-21 Thread Keisuke Miyako via 4D_Tech
it sounds like you are over-thinking :) you could just do SET BLOB SIZE($bytes;4) $bytes{0}:=78 $bytes{1}:=48 $bytes{2}:=75 $bytes{3}:=00 then BLOB TO DOCUMENT. not need to go through hex. 2019/02/22 9:27、Peter Mew via 4D_Tech <4d_tech@lists.4d.com>のメール: If I

Re: Replacing FootRunner in v16

2019-02-23 Thread Keisuke Miyako via 4D_Tech
the 4DCODE tag is a good place to start: https://doc.4d.com/4Dv16/4D/16/4D-Transformation-Tags.300-3035918.en.html I hate that my videos are online but what can you do: https://www.youtube.com/watch?v=R2QCWSBVcHM > 2019/02/23 17:33、Peter Adam via 4D_Tech <4d_tech@lists.4d.com>のメール: > I am going

Re: Help LEP macOS to open the Emoji viewer

2019-03-10 Thread Keisuke Miyako via 4D_Tech
thanks for your informative reply. I've tried your plugin, but it seems that the plugin only accepts one modifier key. This code opens (only with debugger) the macOS Spotlight and close spotlight after you step over "POST VIRTUAL KEY" $modifiers:=Command key mask+Control key mask

Re: Lep Redirect

2019-03-11 Thread Keisuke Miyako via 4D_Tech
first, you should check the documentation of the command you use, to see if they support stdOut output. ( " -o - " or something like that) if not, you might want to consider calling it via bash or some other shell program. c.f. https://kb.4d.com/assetid=77974 https://kb.4d.com/assetid=76658

Re: Printing forms modified with Duplicate Object

2019-03-07 Thread Keisuke Miyako via 4D_Tech
that has been my experience, in particular when I wrote my own label editor. https://github.com/miyako/4d-component-label-editor it was useful, because the old label editor could only position objects in mac points (1/72 of an inch) but I see that the doc says C_LONGINT.

Re: Help LEP macOS to open the Emoji viewer

2019-03-09 Thread Keisuke Miyako via 4D_Tech
which version of macOS? the code is not allowed in Terminal on Mojave; osascript is not allowed to send keystrokes (1002) https://www.reddit.com/r/MacOS/comments/9lwlsv/script_editor_not_allowed_to_send_keystrokes/ on top of that, to grant automation to 4D, you must have a specific key

Re: Help LEP macOS to open the Emoji viewer

2019-03-09 Thread Keisuke Miyako via 4D_Tech
P.S. to post keystrokes programmatically https://github.com/miyako/4d-plugin-virtual-key to do it the proper way (it seems, not tested) https://developer.apple.com/documentation/appkit/nsapplication/1428455-orderfrontcharacterpalette?language=objc

Re: Printing a PDF document from 4D

2019-03-19 Thread Keisuke Miyako via 4D_Tech
printing an HTML is not always easy (especially pagination) even with a good media specific CSS. https://github.com/miyako/4d-component-wkhtmltopdf besides, printing is a blocking process (only 1 job at a time) and not thread safe so I think it is preferable to generate PDF by code than to

Re: Apple Notary Service

2019-03-15 Thread Keisuke Miyako via 4D_Tech
> I think Miyako has something on his github account... Notarisation goes one step further than a normal code sign. This example only deals with code signing. https://github.com/miyako/4d-utility-build-application c.f. http://forums.4d.com/Post/FR/26869162/1/26874716#26874716 Further

Re: OAuth

2019-03-10 Thread Keisuke Miyako via 4D_Tech
so the first thing to do is Google the docs with the keyword "urn:ietf:wg:oauth:2.0:oob" https://www.google.com/search?client=safari=en=site:developer.service.hmrc.gov.uk+urn:ietf:wg:oauth:2.0:oob=UTF-8=UTF-8 > oob callbacks

Re: OAuth

2019-03-10 Thread Keisuke Miyako via 4D_Tech
if the service provider does not support oob callbacks then you need to start a TCP listener session on localhost. c.f. https://github.com/miyako/console-tcp-listener of course you can use 4D Internet Commands or the built-in web server. if oob is supported (you need to check with the service

Re: change in behavior v 15 to v 16 ?

2019-02-18 Thread Keisuke Miyako via 4D_Tech
evidently this is standard behaviour; or rather, technical limitation. the file / folder select dialog is detached from the main application menu. you can, however, paste from the contextual menu. this is limited to 64-bit (cocoa), it was reported in the early days of 64-bit and the reply from

Re: On Drag Over Behavior

2019-02-14 Thread Keisuke Miyako via 4D_Tech
Hello, you can use SET CURSOR 9019 for no-entry, 9016 for plus. https://doc.4d.com/4Dv17/4D/17/SET-CURSOR.301-3729694.en.html > 2019/02/15 1:55、John J Foster via 4D_Tech <4d_tech@lists.4d.com>のメール: > > I have an interface with an Listbox on the left side and four text variables > on the

Re: On Drag Over Behavior

2019-02-14 Thread Keisuke Miyako via 4D_Tech
I think the cursor no longer changes automatically in 4D cocoa (64-bit), v16 and above. 2019/02/15 9:48、Jeremy French via 4D_Tech <4d_tech@lists.4d.com>のメール: Then try dragging to the drop variable. When the pointer is over the drop variable, does the cursor

Re: Error 30 When Using HTTP Get or HTTP Request

2019-02-11 Thread Keisuke Miyako via 4D_Tech
in case you missed it, the blog link that Tim posted does explain how you can lower your TLS threshold on the 4D side with SET DATABASE PARAMETER. 2019/02/12 8:15、4dinug via 4D_Tech <4d_tech@lists.4d.com>のメール: I would rate my chances at getting them to re-deploy

Re: How to display read-only input form

2019-02-06 Thread Keisuke Miyako via 4D_Tech
DIALOG is quite capable of handling input / output forms, as long as you have activated the "make fields enterable in dialog" compatibility setting (since v2004). there is no need to use F. SET INPUT or F. SET OUTPUT. a list type subform or selection based listbox have their own input form

Re: 4D Selection from SQL Query

2019-02-05 Thread Keisuke Miyako via 4D_Tech
alternatively, I guess we can SELECT __ROW_ID == record number (not all tables have a primary key). https://doc.4d.com/4Dv17/4D/17/Replication-via-SQL.300-3786654.en.html https://doc.4d.com/4Dv17/4D/17/CREATE-SELECTION-FROM-ARRAY.301-3729926.en.html 2019/02/06 3:31、Randy Engle via 4D_Tech

Re: change in behavior v 15 to v 16 ?

2019-02-19 Thread Keisuke Miyako via 4D_Tech
yes right-click should work with the 64-bit system dialog. as for Request(), I would first create a new DB and confirm that there are no issues with the particular version your are using. SET MENU BAR(1) $req:=Request("";"copy and paste me") > 2019/02/20 1:53、Charles Miller のメール: > > Thanks do

Re: Epoch time in milliseconds

2019-02-19 Thread Keisuke Miyako via 4D_Tech
$P_timeString:=String(Current date(*);ISO date GMT;Current time(*)) does this not invoke 2 calls to the server in C/S mode? would rather use Timestamp https://blog.4d.com/timestamp-is-now-available/ or else an "execute on server" rapper. otherwise, I compared with a plugin call

Re: WR ON COMMAND in Write Pro

2019-02-08 Thread Keisuke Miyako via 4D_Tech
I don't think that's possible. I suppose WR ON COMMAND made more sense for 4D Write which was a completely opaque product. with Write Pro we can create our own contextual menu (Dynamic popup menu + INVOKE ACTION) so rather than trapping the existing menu, the way to customise behaviour would

Re: Popup/Dropdown element 0

2019-01-29 Thread Keisuke Miyako via 4D_Tech
it's a v14 feature https://download.4d.com/Demos/4D_v14/HDI/Use-Popups-with-Variables.zip > 2019/01/30 7:13、Jim Crate via 4D_Tech <4d_tech@lists.4d.com>のメール: > The v15 and v16 documentation doesn’t mention using a text variable for a > popup/dropdown. Do you have some info on how that would

<    2   3   4   5   6   7   8   9   10   11   >