Re: Query By Attribute vs Map NULL values to blank values

2017-10-10 Thread Keisuke Miyako via 4D_Tech
it's probably an omission in the structure editor. by default the property is on, but you can change the field type to text or whatever, disable it, and switch back to object. it sounds crazy but it should work. > 2017/10/10 14:52、John Baughman via 4D_Tech <4d_tech@lists.4D.com> のメール: > > I

Re: San Fransisco Font

2017-10-09 Thread Keisuke Miyako via 4D_Tech
keep in mind that since v13, you can find in design your "default" stylesheet and replace it with "Automatic". it's how 4D replaced all its internal dialogs. > 2017/10/10 13:34、Sujit Shah via 4D_Tech <4d_tech@lists.4d.com> のメール: > An easy sprint or 2 for the > hundreds of forms in the DB.

Re: San Fransisco Font

2017-10-09 Thread Keisuke Miyako via 4D_Tech
> 2017/10/10 12:41、Wayne Stewart via 4D_Tech <4d_tech@lists.4d.com> のメール: > <>WGD_o.Font:=New object > <>WGD_o.Font.Name:=OBJECT Get font(*;"auto") as I mentioned in my other post, changing the font according to what you get from this, or any other ways to obtain the system font name, is going

Re: San Fransisco Font

2017-10-09 Thread Keisuke Miyako via 4D_Tech
no, it simply means that the form is specifically designed. https://developer.apple.com/macos/human-interface-guidelines/visual-design/typography/ > 2017/10/10 10:57、Sujit Shah via 4D_Tech <4d_tech@lists.4d.com> のメール: > > "Automatic style sheets manage the font as well as its size and color" >

Re: Query By Attribute vs Map NULL values to blank values

2017-10-09 Thread Keisuke Miyako via 4D_Tech
the "map null to blank" property was originally introduced in v11, as a way to tell SQL that pre-existing NULLs (which could typically be created by adding fields) should not be considered NULLs in SQL. otherwise, as far as SQL is concerned, NULLs should never be mapped to blanks. (that is why the

Re: Import from RTF

2017-10-09 Thread Keisuke Miyako via 4D_Tech
a simple converter: https://github.com/miyako/4d-plugin-RTF2TEXT > 2017/10/10 0:41、stardata.info via 4D_Tech <4d_tech@lists.4d.com> のメール: > I use 4D V15 on windows and i need to import from an RTF file. > Is possible to do using 4D?

Re: San Fransisco Font

2017-10-09 Thread Keisuke Miyako via 4D_Tech
on the use of system font: the only correct (that is, intended) way to use the system font in 4D is to use it indirectly with the automatic stylesheet feature. it is NOT recommended to use "system font" via the default stylesheet, or any stylesheet, except the automatic stylesheet, or change

Re: Making LOG EVENT thread-safe

2017-10-08 Thread Keisuke Miyako via 4D_Tech
LAUNCH EXTERNAL PROCESS becomes thread safe in 16R5 http://forums.4d.com/Post/FR/21049933/1/21050200#21050200 which opens many possibilities, the logger command on Mac, for example. perhaps we need not focus on LOG EVENT anymore...

Re: OPEN COLOR PICKER or OBJECT SET RGB COLORS inconsistencies

2017-10-01 Thread Keisuke Miyako via 4D_Tech
Hello, in your original post you mentioned the "web safe" color profile, a collection of 216 colors. find "burnt orange" (FF6600) in that pane, and select it. switch to "RGB" (second from left) and click the cogwheel. select device color space (the one that 4D uses). you will see that the hex

Re: No longer able to get to user / design mode

2017-10-01 Thread Keisuke Miyako via 4D_Tech
Hi, the keyboard shortcut to invoke the process popup menu is: Alt+Shift+right click(Windows) Option+Command+right click (Mac OS) http://doc.4d.com/4Dv16R4/4D/16-R4/Managing-menu-bars.300-3330257.en.html > 2017/10/01 13:36、Michael McCall via 4D_Tech <4d_tech@lists.4d.com> のメール: > > Regarding

Re: OPEN COLOR PICKER or OBJECT SET RGB COLORS inconsistencies

2017-09-29 Thread Keisuke Miyako via 4D_Tech
on the color picker panel you should find a cogwheel icon, which allows you to pick a color space. after all, RGB is not an absolute definition unless you also specify the color space. when you use the picker tool, it will always return the RGB in the generic (NSCalibratedRGBColorSpace) space,

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

2017-09-27 Thread Keisuke Miyako via 4D_Tech
you could also use Create menu($) to duplicate it in memory. > 2017/09/28 1:20、Two Way Communications via 4D_Tech <4d_tech@lists.4d.com> > のメール: > I eventually realised that I need to call SET MENU BAR($i) for every menu bar > I want to get the menus and menu items for,

Re: Making LOG EVENT thread-safe

2017-09-26 Thread Keisuke Miyako via 4D_Tech
sometimes you will see a kind of "comment" line in the request log, in particular "TTF" or time to forget, which describes a change of state in the process: a: automatic relation b: record stack c: current record d: current selection e: transaction these are not real "requests", in that the

Re: Making LOG EVENT thread-safe

2017-09-26 Thread Keisuke Miyako via 4D_Tech
be recorded in the debug log without the use of a LOG EVENT... 2017/09/26 21:27、Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>> のメール: doesn't have to be that way; you can have a local external database on the client side. http://doc.4d.com/4Dv15/4D/15/USE-

Re: Making LOG EVENT thread-safe

2017-09-26 Thread Keisuke Miyako via 4D_Tech
doesn't have to be that way; you can have a local external database on the client side. http://doc.4d.com/4Dv15/4D/15/USE-DATABASE.300-2288124.en.html but I am slightly puzzled how LOG EVENT is in the spotlight. preemptively logging can make things more complicated, look at 4DRequestsLog.txt /

Re: v13+ is there a size limit to receive packet?

2017-09-26 Thread Keisuke Miyako via 4D_Tech
you should use BLOB instead of TEXT with RECEIVE PACKET, with a stop char or max size, which you like. just remember to clear the BLOB every iteration and save as you go. don't use arrays (defeats the purpose of chunking), don't use text (bloats the size and adds overhead for decoding). >

Re: Listbox Spacing Between Columns

2017-09-24 Thread Keisuke Miyako via 4D_Tech
I guess string like "123,456" evaluates as an undefined, variable name in v15 or later. http://doc.4d.com/4Dv15/4D/15/Get-pointer.300-2018637.en.html 2017/09/25 7:43、Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> のメール: (in v15 they started choking execution)

Re: Listbox Spacing Between Columns

2017-09-24 Thread Keisuke Miyako via 4D_Tech
even if it doesn't seem applicable to your immediate deployment target, it is good practice as a programmer to not assume that a thousand (decimal) separator would always be a comma (period). 2017/09/25 7:43、Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> のメール:

Re: Command numbers and names and using Execute

2017-09-21 Thread Keisuke Miyako via 4D_Tech
ARRAY TEXT is command #222 so you could do EXECUTE FORMULA(":C222(...)") C must be uppercase. c.f. http://doc.4d.com/4Dv16/4D/16.2/Using-tokens-in-formulas.300-3432926.en.html > 2017/09/22 0:34、Paul Lovejoy via 4D_Tech <4d_tech@lists.4d.com> のメール: > > I want to use the Execute command in a

Re: Form with Custom Grow Box

2017-09-19 Thread Keisuke Miyako via 4D_Tech
Hello, I think the bottom-right grow box is deprecated (v14, Mac OS X Lion, Windows) a window can now be resized from any side. > 2017/09/19 15:58、Piotr Chabot Stadhouders via 4D_Tech <4d_tech@lists.4d.com> > のメール: > I am not talking about maximize / minimize but on Windows the area in the >

Re: CONVERT PDF TO PICTURE

2017-09-18 Thread Keisuke Miyako via 4D_Tech
image-magick (plugin) might also work https://github.com/miyako/4d-plugin-imagemagick ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options:

Re: Query & Order by on non indexed fields

2017-09-14 Thread Keisuke Miyako via 4D_Tech
you can also find out whether a query (not sort) used an index with DESCRIBE QUERY EXECUTION http://doc.4d.com/4Dv15/4D/15.4/DESCRIBE-QUERY-EXECUTION.301-3273970.en.html ** 4D Internet Users Group (4D iNUG) FAQ:

Re: Query & Order by on non indexed fields

2017-09-14 Thread Keisuke Miyako via 4D_Tech
whether an index is used or not depends on the context. of course, 4D can't use an index that does not exist, but otherwise, just because an index is defined it doesn't mean that it will be used. the exact same query/sort condition may not alway use indexes, it depends on the current selection

Re: Can system tables be UPDATEd in a compiled database?

2017-09-13 Thread Keisuke Miyako via 4D_Tech
SQL system tables are virtual and read-only, but you can enable or disable journaling though other means: http://doc.4d.com/4Dv15/4D/15/ALTER-TABLE.300-2288140.en.html > 2017/09/13 22:17、Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> のメール: > Can system tables be UPDATEd in a compiled database?

Re: Edit in list / subform / 4D v16

2017-09-12 Thread Keisuke Miyako via 4D_Tech
to edit in list you need to click twice; that means to click an already selected line with an interval longer than that of a double click. the exact threshold is adjustable at the system level. ** 4D Internet Users Group (4D

Re: OBJECT get variable type

2017-09-11 Thread Keisuke Miyako via 4D_Tech
thank you for sharing. to be honest, I have never used the "filter" feature since it is not compatible with Japanese by design (we don't use a keyboard with 10,000 keys, so before/after keystroke doesn't make sense). I was hopeful it might work with filtering ASCII by length, well, apparently

Re: OBJECT get variable type

2017-09-11 Thread Keisuke Miyako via 4D_Tech
you can set a (rather simplistic) length limit to a variable by code. OBJECT SET FILTER(*;"__object_name_here";"! &@"+("#"*$maxlen)) http://doc.4d.com/4Dv15/4D/15.4/OBJECT-SET-FILTER.301-3273846.en.html http://doc.4d.com/4Dv15/4D/15.4/Filter-and-format-codes.300-3285353.en.html but I still

Re: Inconsistency in Begin SQL/End SQL

2017-09-10 Thread Keisuke Miyako via 4D_Tech
Hello, it's explained in the docs. http://doc.4d.com/4Dv16/4D/16/literal.300-3201194.en.html quote: for the decimal value 15, you can write X'0f'. > Anyone notice this before? Anyone care? ** 4D Internet Users Group (4D

Re: v16 Listboxes and the Control Array

2017-09-10 Thread Keisuke Miyako via 4D_Tech
you could add a hidden column, omitting the variable name to create a form local array, then LISTBOX SET ARRAY to use that hidden column to double as one of its control arrays. http://doc.4d.com/4Dv16/4D/16.2/LISTBOX-SET-ARRAY.301-3433517.en.html I'm starting to experiment with it but can

Re: OBJECT get variable type

2017-09-08 Thread Keisuke Miyako via 4D_Tech
Hello, the variable type property serves two purposes: to filter the display in the property list, and to declare the data source variable type in case no variable name is defined. otherwise, you only need to know OBJECT Get type which is constant for the object, and OBJECT Get pointer which

Re: macros documentation

2017-09-07 Thread Keisuke Miyako via 4D_Tech
Hello, on_load has been available since v11. perhaps your folder is not named "Macros v2" some macro examples: https://github.com/miyako?utf8=✓=repositories=macro (but I am not sure if any uses on_load in particular) 2017/09/08 1:48、Charles Miller via 4D_Tech

Re: Quickbooks 2014/4D 2014/QB SDK 13.0

2017-09-05 Thread Keisuke Miyako via 4D_Tech
you could start from here: https://github.com/miyako/4d-tips-quickbook-integration > 2017/09/06 8:18、Douglas von Roeder via 4D_Tech <4d_tech@lists.4d.com> のメール: > What's the best approach to take for that. ** 4D Internet

Re: SVG component question

2017-09-05 Thread Keisuke Miyako via 4D_Tech
an SVG picture has a "rendering tree", which is the backend of the displayed image. it also has a "dom tree", which is the parsed xml structure in memory. SVG SET ATTRIBUTES with no optional * works on the rendering tree, which is useful if you want to alter the image in a "volatile" way. for

Re: Widget questions

2017-09-04 Thread Keisuke Miyako via 4D_Tech
the challenge is a bit more complex than that. the "On Load" event for a widget is fired when a widget is created, which is when the page is displayed for any pages other than 0 or 1. this is documented. http://doc.4d.com/4Dv15/4D/15.4/Form-event.301-3274360.en.html > • On Load and On Unload:

Re: Losing Hightlighted Records in a Listbox

2017-09-04 Thread Keisuke Miyako via 4D_Tech
you just have to COPY SET ("$userset";"$userset") on whatever the name of your highlight set. > 2017/09/04 12:01、Sannyasin Siddhanathaswami via 4D_Tech > <4d_tech@lists.4d.com> のメール: > I can understand if changing the selection causes the highlight to be lost, > but then, how do I set the

Re: Widget performance

2017-09-01 Thread Keisuke Miyako via 4D_Tech
Hello, that widget is one of my own favourites, especially how it manages focus with gaussian blur. you might want to make sure your images are Retina ready on v14 or above, but otherwise not much has changes since v13 (which added OBJECT GET SUBFORM CONTAINER SIZE and FORM GOTO PAGE *)

Re: TEXT TO DOCUMENT With Special Characters

2017-08-31 Thread Keisuke Miyako via 4D_Tech
have you tried receiving the response with a variable declared as object? if that doesn't work, then I guess you could receive BLOB, convert to text, and parse. it is always better to receive BLOB as opposes to text, picture or object, when you can't be sure of what goes on on the server side.

Re: TEXT TO DOCUMENT With Special Characters

2017-08-31 Thread Keisuke Miyako via 4D_Tech
、Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> as long as you use "document to json" ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Optio

Re: TEXT TO DOCUMENT With Special Characters

2017-08-31 Thread Keisuke Miyako via 4D_Tech
Hello, it's true that the commands were introduced to promote JSON, among other things, but as long as you use "document to json" to restore the text, the BOMs are removed anyway, so I can't see how the existence of a BOM could be such a big problem. 2017/08/31 23:25、Cannon Smith via 4D_Tech

Re: Image Export to Excel

2017-08-30 Thread Keisuke Miyako via 4D_Tech
I totally agree, XL is the best. you might also want to take a look at HMFREE ADDON https://www.hmplugins.com https://www.hmplugins.com/en/hmFree/Features-134.html quote: • Create native Excel (*.xls) files * Based on the ExcelFormat library (same as Keisuke Miyako's XLS II-Plugin), but with

Re: Subform will not appear

2017-08-28 Thread Keisuke Miyako via 4D_Tech
yes, running a form that contains a list directly from the design process, clashes with the application process also displaying a list, if both forms try to list a selection from the same table. this is since v14. better to start a new process. another caveat since v14 is that one must not

Re: Does 4D have a syntax for applying Sum() to an item in an object field?

2017-08-28 Thread Keisuke Miyako via 4D_Tech
I see where you are coming from; the Doc Center refuses to show v16 material (redirection loop). http://livedoc.4d.com/4D-Language-Reference-16-R3/On-a-Series/Sum.301-3218821.en.html the example for Sum() is on the page for Average(). please don't ask me why.

Re: Widget performance

2017-08-25 Thread Keisuke Miyako via 4D_Tech
there is a "duplicate by matrix" menu in the form editor, which allows you to quickly experiment with tens of thousands of objects. maybe it is the execution code setup code that is taking 2 seconds. in my experience, a form with thousands of form objects is nothing uncommon. > 2017/08/25

Re: Listbox header OSX

2017-08-25 Thread Keisuke Miyako via 4D_Tech
Hello, the Header of a listbox takes after the appearance of a standard menu bar. on Windows 10, the menu bar happens to be white and has no borders and so does the Header. but you can configure system appearances (themes) and that will have an effect on Headers too. as for borders on Mac,

Re: Save As using memorized path and suggested file name

2017-08-22 Thread Keisuke Miyako via 4D_Tech
for that, I think you are over-thinking it, just lookup the DOCUMENT system variable which contains the full path. > 2017/08/23 4:10、Steve Slanec via 4D_Tech <4d_tech@lists.4d.com> のメール: > then I could get the path, append the suggested file name, and pass the whole > string to Select document()

Re: Save As using memorized path and suggested file name

2017-08-22 Thread Keisuke Miyako via 4D_Tech
on mac I think the settings can be found in /Users/{me}/Library/Preferences/com.4d.4d.plist in other words you can retrieve it with defaults https://developer.apple.com/legacy/library/documentation/Darwin/Reference/ManPages/man1/defaults.1.html 2017/08/23 4:10、Steve Slanec via 4D_Tech

Re: Unable to Compile - Crash - looking for ideas

2017-08-20 Thread Keisuke Miyako via 4D_Tech
maybe you could run METHOD GET CODE on all methods just to see if all methods are accessible. if it really comes down to that, I guess you could run METHOD SET CODE on all methods too. or, you could trash (helps if the trash is empty) some methods to exclude them from the compiler. compilation

Re: UTF-8 to ASCII during data export issues

2017-08-16 Thread Keisuke Miyako via 4D_Tech
also there is a chance that your "encoding" attribute doesn't match the XML content. I find it hard to believe that a program exists which can't process UTF-8. or maybe you are using BLOB (in which case the content is not UTF-8), but the "encoding" says that it is, hence the error. in that

Re: UTF-8 to ASCII during data export issues

2017-08-16 Thread Keisuke Miyako via 4D_Tech
try blob instead of text. > Compatibility note: Beginning with version 12 of 4D, when you use BLOB type > parameters, the command automatically considers that the character set used > for BLOBs is MacRoman. For better efficiency, it is strongly recommended to > use Text type parameters for

Re: Listbox Printing

2017-08-14 Thread Keisuke Miyako via 4D_Tech
FORM LOAD simply loads the form definition. the data source (variables and arrays) are not bound automatically in print. you need to populate the objects by their names: SET PRINT PREVIEW(True) If (OK=1) OPEN PRINTING JOB FORM LOAD("Form1") $aA:=OBJECT Get pointer(Object named;"Column1")

Re: Listbox Printing

2017-08-14 Thread Keisuke Miyako via 4D_Tech
I am not sure I understand your code; are you not supposed to populate the arrays AFTER you call FORM LOAD (unless the listbox already exists in the current form) ? > 2017/08/14 23:29、Keith Culotta via 4D_Tech <4d_tech@lists.4d.com> のメール: > > I tried with the name as well. It works that way

Re: Listbox Printing

2017-08-13 Thread Keisuke Miyako via 4D_Tech
have you tried using the object name instead ? > 2017/08/13 5:46、Keith Culotta via 4D_Tech <4d_tech@lists.4d.com> のメール: > $obj:=(->Box_Sum) ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive:

Re: Anybody using the TimePicker widget - TimePicker SET STEP

2017-08-10 Thread Keisuke Miyako via 4D_Tech
it works on ON LOAD, but the widget's variable must be declared with C_TIME, or set to create a form local (no variable name, type=time in property list.) and the widget must be used on page 0 or 1. > 2017/08/10 16:13、John Baughman via 4D_Tech <4d_tech@lists.4D.com> のメール: > The sample code in

Re: Relative path in SVG DOM

2017-08-10 Thread Keisuke Miyako via 4D_Tech
unless there is a way to define the base URL, I don't think it is possible to specify relative paths in SVG which is itself not a file on disk. my guess would be that the path is considered a name, searched in the current directory of the executable. unless the SVG is a file on disk, I think

Re: SEND / RECEIVE RECORD questions

2017-08-10 Thread Keisuke Miyako via 4D_Tech
RECEIVE R. command is capable of processing records sent from pre-v11 versions, it looks at the header and converts ANSI to Unicode text as necessary. > 2017/08/11 5:51、Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> のメール: > And what about changes across 4D versions? Like attempting to RECEIVE >

Re: Animated Notifcation

2017-08-09 Thread Keisuke Miyako via 4D_Tech
did you mean... > AnotherTip 2.0 is available > ——— > > AJAR SA is pleased to announce a new release of the 4D widget : Another Tip > 2.0 > > This new release 2.0 adds new animation functionalities. > > A new revamp Lab is provided, to help you build your tip styles. > >

Re: Method Header Strategies

2017-08-09 Thread Keisuke Miyako via 4D_Tech
that's what I thought at first but then the "False" block already does that job. > 2017/08/10 7:58、Guy Algot via 4D_Tech <4d_tech@lists.4d.com> のメール: > My guess… So you can click the triangle and hide everything in the header?

Re: Relative path in SVG DOM

2017-08-09 Thread Keisuke Miyako via 4D_Tech
the doc could have been worded better, I suppose. relative path means relative to the SVG image file. the doc assumes your SVG is itself inside the Resources folder, in fact at the top level. > 2017/08/09 18:55、Two Way Communications via 4D_Tech <4d_tech@lists.4d.com> > のメール: > No, it isn’t.

Re: Relative path in SVG DOM

2017-08-08 Thread Keisuke Miyako via 4D_Tech
is your SVG image itself a file inside the Resources folder? > 2017/08/09 2:45、Two Way Communications via 4D_Tech <4d_tech@lists.4d.com> > のメール: > However, if I put this inside the xlink:href attribute of the image, it does > not show up in the SVG.

Re: JSON Tools Was: Re: C-objects and memory use

2017-08-08 Thread Keisuke Miyako via 4D_Tech
it seems this view just keeps coming up... I think it is important to understand that 4D didn't look at JSON and implement it as Object and Array Object, doing a really bad job at it, as it were, no, it happened the other way round... Object and Array Object were implemented first, and then

Re: External data storage question

2017-08-04 Thread Keisuke Miyako via 4D_Tech
what happens if you do [myTable]myPicture:=[myTable]myPicture*0 before you load the new jpg ? your trigger is running, so the picture is touched for the database, we can assume that. but the picture on form is not updated, so it sounds like a ref count issue for the form. besides, you

Re: Listbox Printing

2017-08-02 Thread Keisuke Miyako via 4D_Tech
https://github.com/miyako/4d-tips-print-form-print-object-combo 2017/08/03 12:34、miyako > のメール: I don't see any reasons why they won't work in tandem. ** 4D Internet Users

Re: Listbox Printing

2017-08-02 Thread Keisuke Miyako via 4D_Tech
have you looked into "Print object"? http://doc.4d.com/4Dv16/4D/16/Print-object.301-3035768.en.html > 2017/08/03 3:18、James Crate via 4D_Tech <4d_tech@lists.4d.com> のメール: > > I am printing a listbox on a form which just has a detail section (i.e. Print > Form). The listbox is printing, but

Re: Fastest way to get text into a BLOB?

2017-08-01 Thread Keisuke Miyako via 4D_Tech
I have found the C_TEXT + ARRAY BLOB combo to be quite useful. textual data are represented in the text which is a JSON catalog. arbitrary data are referenced by a number in the JSON, which is the element number for the BLOB array. > 2017/08/01 10:44、David Adams via 4D_Tech

Re: zipping files

2017-07-27 Thread Keisuke Miyako via 4D_Tech
what happens if you replace tokenised constants with their literal values? > 2017/07/28 6:24、Jody Bevan via 4D_Tech <4d_tech@lists.4d.com> のメール: > That is fine, and I now have a plugin that loads at startup and when I write > code the plugin command shows up as a plugin and the constants as

Re: 4D Forums feature request - keep it the same

2017-07-27 Thread Keisuke Miyako via 4D_Tech
the forum is also where online services offered as part of the partner program are available, such as downloads and discussions of nightly builds, beta/R versions and source code of 4D internal components / widgets. you might have not noticed, but forum accounts are already tied to partner

Re: Cross platform JSON Problem

2017-07-27 Thread Keisuke Miyako via 4D_Tech
you are using an old version, which uses "float" for real, not "double" https://github.com/miyako/4d-plugin-json ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive:

Re: Strange Error

2017-07-26 Thread Keisuke Miyako via 4D_Tech
in other words the cause is in the html / javascript and 4D is simply relaying an uncaught exception. perhaps you are using the system wa and the os was updated recently. perhaps the page is hosted remotely and updated recently. perhaps the code received malformed dynamic data it was not

Re: LOG File TO JSON - How does it name the files

2017-07-25 Thread Keisuke Miyako via 4D_Tech
just set the size to "1" and see for yourself: $path:=System folder(Desktop) LOG FILE TO JSON($path;1) I got JournalExport.json JournalExport2.json ... JournalExport10.json so there is not underscore. > 2017/07/26 7:09、Jody Bevan via 4D_Tech <4d_tech@lists.4d.com> のメール: > > Does anyone know

Re: v13 - Host methods, and components

2017-07-24 Thread Keisuke Miyako via 4D_Tech
METHOD GET NAMES http://doc.4d.com/4Dv16/4D/16.1/METHOD-GET-NAMES.301-3376032.en.html will return a list of shared method names. > 2017/07/25 5:47、Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> のメール: > if not, is there some way to determine if a method exists in the host, from a > component?

Re: v13 - Host methods, and components

2017-07-24 Thread Keisuke Miyako via 4D_Tech
> Can I, form a component, use "Get Method Paths" to determine if a method > exists in the host? yes, you pass the optional * http://doc.4d.com/4Dv15/4D/15.4/METHOD-GET-PATHS.301-3273681.en.html > Additionally, Am I right, I can call a host database method from a component > (as long as I

Re: 4Dv16 VM app still not playing nice with Finder

2017-07-23 Thread Keisuke Miyako via 4D_Tech
ACI0097097: On Drop is not fired during 'boot time' ...would it not be possible to do the same test in On Startup? 2017/07/24 2:21、Steve Slanec via 4D_Tech <4d_tech@lists.4d.com> のメール: As far as I know, there is no other way to tell what datafile was used to launch

Re: Need help identifying a crash source

2017-07-22 Thread Keisuke Miyako via 4D_Tech
for reference: the issue is in question is ACI0096430 http://bugs.4d.fr/fixedbugslist?Version=15.4_HF1 tip: some query examples for the URL http://bugs.4d.fr/fixedbugslist?Version=15.4 http://bugs.4d.fr/fixedbugslist?Version=16_R3 http://bugs.4d.fr/fixedbugslist?Branch=16 > 2017/07/23

Re: Resizing Window in Code keeping Background Image centered

2017-07-20 Thread Keisuke Miyako via 4D_Tech
I notice after sending the message that this sentence makes no sense. but the main point stands, that you would want to use the other command if you want the resize to work as if done manually. > 2017/07/21 9:26、miyako のメール: > SET WINDOW RECT is not the command to resize

Re: Resizing Window in Code keeping Background Image centered

2017-07-20 Thread Keisuke Miyako via 4D_Tech
SET WINDOW RECT is not the command to resize the window, it is (since v2004) a command to resize the form. http://doc.4d.com/4Dv15/4D/15.4/RESIZE-FORM-WINDOW.301-3274595.en.html but since RESIZE FORM WINDOW does not take the window reference as an argument, you would need to use CALL FORM in

Re: Image Export to Excel

2017-07-19 Thread Keisuke Miyako via 4D_Tech
the component was meant to be a simple demonstration of how one can call AppleScript and VBA from 4D. it was never meant to be an "out of the box" kind of production tool. if possible, you should consider writing your own script rather than using the component "as is". calling those segmented

Re: Collections in v16R4

2017-07-19 Thread Keisuke Miyako via 4D_Tech
you can open multiple windows using SDI, each with its own menu bar. but many developers who requested SDI support seem to have a single window app in mind. SDI is only available for engined applications. since SDI is not (yet) available in the design environment. for now, you can't quickly

Re: Arrays vs Object for Key/Value pair lookups

2017-07-17 Thread Keisuke Miyako via 4D_Tech
the "Find" commands accept wild cards and evaluate using collation algorithms (case-insensitive comparison plus some other locale specific rules) is it really fair to compare the two against object keys? > 2017/07/18 9:44、David Adams via 4D_Tech <4d_tech@lists.4d.com> のメール: > > * Sequential Find

Re: version of openssl in 15.4 mac

2017-07-17 Thread Keisuke Miyako via 4D_Tech
you could also... $version:="" $param:=Get database parameter(94;$version) but it is good to make it a habit of reading the release notes for every update. ** 4D Internet Users Group (4D iNUG) FAQ:

Re: Print Project Form

2017-07-16 Thread Keisuke Miyako via 4D_Tech
the command is called Print form, it can not be more obvious! http://doc.4d.com/4D-Language-Reference-15.4/Printing/Print-form.301-3273939.en.html > 2017/07/17 6:26、Robert Livingston via 4D_Tech <4d_tech@lists.4d.com> のメール: > Is it possible to print a project form?

Re: CROP A PDF DOCUMENT

2017-07-14 Thread Keisuke Miyako via 4D_Tech
this might work https://github.com/miyako/4d-plugin-imagemagick documented here https://github.com/miyako/4d-plugin-imagemagick/blob/master/ImageMagick/06-32%20ImageMagick.pdf 2017/07/15 6:40、stardata.info via 4D_Tech <4d_tech@lists.4d.com>

Re: Very Simple Way to Access Server with Two Copies of Remote from the Same Machine

2017-07-14 Thread Keisuke Miyako via 4D_Tech
I don't think it is necessary to create copies if you are connecting to different servers. just use open -n https://developer.apple.com/legacy/library/documentation/Darwin/Reference/ManPages/man1/open.1.html but you do need to create a copy and give it a ClientLocal folder if you need to

Re: v13+ - How to do a 'Find in array' with a picture array?

2017-07-13 Thread Keisuke Miyako via 4D_Tech
perhaps you should use an array of pointers (pointers to pictures) instead. > 2017/07/13 2:03、Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> のメール: > any ideas? code? ** 4D Internet Users Group (4D iNUG) FAQ:

Re: Automatic Font

2017-07-12 Thread Keisuke Miyako via 4D_Tech
some developer use $autofont:=OBJECT Get font(*;"") but $autofont:=_o_Font name(0) also works. but to set at runtime, I think it is better to OBJECT SET STYLE SHEET(*;"";Automatic style sheet) OBJECT SET STYLE SHEET(*;"";Automatic style sheet_additional) OBJECT SET STYLE

Re: Object field storage: Questions and alternatives

2017-07-11 Thread Keisuke Miyako via 4D_Tech
one more thing, it is not incorrect to do something like { "\u0066\u006F\u006F":"\u0062\u0063\u0072" } instead of {"foo":"bar"} it's an extreme example, but it happens all the time in non-ASCII JSON. I may prefer one over the other, but really I don't care, and nor should I care, because it

Re: Object field storage: Questions and alternatives

2017-07-11 Thread Keisuke Miyako via 4D_Tech
Hello, I think it would not be telling the full story if you just focus on how UTF-16 takes double the size for standard ASCII, and therefore uneconomic. and I am not speaking because UTF-16 actually takes less space than UTF-8 for Japanese text. one must take into account that standard

Re: Packages-building an installer

2017-07-11 Thread Keisuke Miyako via 4D_Tech
I believe there are some nice applications that makes the process easier, but you can still use basic command line tools to deploy a built 4D desktop application for macOS. if you want to create an installer package, the steps are: 1. sign the application and move it to /Applications (locally)

Re: revelation! - Choose

2017-07-10 Thread Keisuke Miyako via 4D_Tech
"Choose" is a useful tool in specific cases but I would not use it everywhere. 1. unlike Case of~End case, Choose evaluates all expressions. for example you can do something like Case of :(Count parameters>0) //do something with $1 :(Count parameters>1) //do something with $2 :(Count

Re: Object Field Questions and Comments

2017-07-09 Thread Keisuke Miyako via 4D_Tech
but I think the term "hash table" has only been mentioned in describing how the keys are indexed stored, not the values. > 2017/07/10 13:48、David Adams via 4D_Tech <4d_tech@lists.4d.com> のメール: > So, do you know anything about the indexing scheme? Or anything about the > hash table?

Re: Object Field Questions and Comments

2017-07-09 Thread Keisuke Miyako via 4D_Tech
> 2017/07/09 20:00、David Adams via 4D_Tech <4d_tech@lists.4d.com> のメール: > > { > "date":"2017-01-01", > "items_total": 37, > "request_max": 12, > "request_min: 0 > } an object is not just an opaque container of JSON string. a date value is converted to ISO string (so it is larger, if you

Re: Object Field Questions and Comments

2017-07-09 Thread Keisuke Miyako via 4D_Tech
I don't think there is any difference between what you call text and binary, what you report sounds more like the difference between UTF-16 and UTF-8. technically, the 2:1 ratio you describe is variable, but I understand for all practical purposes in ASCII, you could say that it is pretty much a

Re: 4D v16 Table/Field numbers

2017-07-03 Thread Keisuke Miyako via 4D_Tech
That is right, you can prevent recycling field numbers by with the "ADD TRAILING" feature http://doc.4d.com/4Dv16/4D/16/ALTER-TABLE.300-3201314.en.html In any case, a field created with a recycled number will not contain values from its former life if you compact the data file. > 2017/07/03

Re: Dynamic Tabs using hierarchical list

2017-07-01 Thread Keisuke Miyako via 4D_Tech
> 2017/07/02 4:47、truegold via 4D_Tech <4d_tech@lists.4d.com> のメール: > C_LONGINT(Tab_Control) this is the most important line, that you explicitly declare the data source as a list. alternatively the tab control object can by associated to a text array, in which case an ambiguous line like

Re: 4Dv16 VM app still not playing nice with Finder

2017-06-30 Thread Keisuke Miyako via 4D_Tech
quick correction 2017/06/30 21:23、Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>> のメール: If ($path="@.4dd") | ($path="@.data") OPEN DATA FILE($path) $0:=-1 End if the application will restart the moment OPEN DATA FILE (or RESTART

Re: 4Dv16 VM app still not playing nice with Finder

2017-06-30 Thread Keisuke Miyako via 4D_Tech
you are over thinking it. just put something like C_LONGINT($0) $path:=Get file from pasteboard(1) If ($path="@.4dd") | ($path="@.data") OPEN DATA FILE($path) $0:=-1 End if > 2017/06/30 16:02、Steve Slanec via 4D_Tech <4d_tech@lists.4d.com> のメール: > > When I add $0:=-1 to the end of my On Drop

Re: Set Print Option clarity needed

2017-06-29 Thread Keisuke Miyako via 4D_Tech
printing has always been a global operation. after all, it is the application that is doing printing, not the process. so if you OPEN PRINTING JOB in a process and hold (TRACE for example; just close the progress window on Mac) then call SET PRINT OPTION in a different process, you get the

Re: 4Dv16 VM app still not playing nice with Finder

2017-06-29 Thread Keisuke Miyako via 4D_Tech
the primary file that 4D should open is always the structure file, not the data file. that said, if you insist on drag and drop of a data file (which is wrong), you can use the On Drop database method. http://doc.4d.com/4Dv15/4D/15.4/On-Drop-Database-Method.300-3274338.en.html and $0:=-1 to

Re: Optimizing and improving 4D queries.

2017-06-28 Thread Keisuke Miyako via 4D_Tech
do you have cluster b-tree indexes for that field? > 2017/06/29 9:55、John DeSoi via 4D_Tech <4d_tech@lists.4d.com> のメール: > > 4D reports the table is not fragmented. I have not tried compacting or > rebuilding indexes yet. You might give this a try to see if it makes a > difference.

Re: Error -19191

2017-06-28 Thread Keisuke Miyako via 4D_Tech
auto upgrading to a different major version is only available in v13->v14 or later. see http://kb.4d.com/assetid=76989 also http://doc.4d.com/4Dv16/4D/16/Overview.300-3130240.en.html > 2017/06/29 10:45、Costas Manousakis via 4D_Tech <4d_tech@lists.4d.com> のメール: > We’ve seen this error when a

Re: Rotate Picture in 4D

2017-06-27 Thread Keisuke Miyako via 4D_Tech
http://blog.4d.com/component-source-code-sharing-4d-partners/ good news is that svg component is open source ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html

<    4   5   6   7   8   9   10   11   >