Re: Adding fields to tables using SQL

IMPORT STRUCTURE is powerful, but I don't think it can modify existing tables... http://doc.4d.com/4Dv16/4D/16/IMPORT-STRUCTURE.301-3036688.en.html maybe the plugin entry-point is more forgiving (haven't tried) https://github.com/miyako/4d-plugin-structure-access > 2017/03/03 5:56、bob.miller--- v

Re: Bug or feature?

from what you describe, - the Compiler - ON ERROR CALL - JSON Parse all seem to be working as expected. if there is a bug, I would argue that it is in the documentation, for furnishing the wrong kind of expectations in these features. --- the alternative, to "correct" any of the aforementioned

Re: Email Component

from what you describe, it sounds like a problem in Internet Commands v16, not the component that presumably generates the HTML. F.Y.I. you can use v15 Internet Commands with v16, just install it in the Plugins folder inside the database folder, and it will take precedence over the one inside the

Re: Bug or feature?

? one that includes such options as "send information (e.g. Info Component log) to the developer", etc. > 2017/03/04 8:50、Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> のメール： > if the dialog popping up is confusing to the end-user, > maybe a different, more serious

Re: query re database setting on 4D server v15.4

Hello, 64-bit Mac (Server or Client) can only use the New Layer, regardless of the settings. 32-bit Mac Clients can adapt "can adapt their protocol dynamically (doc)", they start with the New Layer or automatically switch during initial connection. http://doc.4d.com/4Dv15/4D/15.4/Network-and-Cli

Re: Saved query files (.4df) and changes from v12 to v15 - automated conversion?

Thank you Arnaud your code gave me the needed inspiration :) https://github.com/miyako/4d-component-classic-query-editor/ 2017/03/07 5:42、Arnaud de Montard via 4D_Tech <4d_tech@lists.4d.com> のメール： I just translated some comments, and, again, I never ended the job. HTH… *

Re: RESOURCE LIST & XLIFF Resource Files

Hello, the command RESOURCE LIST was never associated with XLIFF. resource commands that work with XLIFF are: STRING LIST TO ARRAY http://doc.4d.com/4Dv15/4D/15.4/STRING-LIST-TO-ARRAY.301-3274706.en.html and Get indexed string http://doc.4d.com/4Dv15/4D/15.4/Get-indexed-string.301-3274707.en.

Re: RESOURCE LIST & XLIFF Resource Files

so I guess you used the "STR# to XLIFF" tool; you drag and drop an RSR file, and you get a "en.lproj" folder. there is no need to even open the file, let alone parse it with native 4D commands. just put it inside your Resources folder, and the line e.g. STRING LIST TO ARRAY(14950;$strings) wil

Re: WEB SERVICE CALL parsing error

when you process the WSDL (if there is one) using the built-in Wizard of 4D, you would see orange flags, denoting "complex" types. http://doc.4d.com/4Dv15/4D/15.4/Subscribing-to-a-Web-Service-in-4D.300-3285567.en.html Note: If the parsing of the WSDL file reveals the presence of complex type para

Re: PHP EXECUTE in a loop

PHP Execute restarts after a set number of calls. PHP max requests http://doc.4d.com/4Dv15/4D/15.4/SET-DATABASE-PARAMETER.301-3274410.en.html if you always call PHP from the same process, and you can keep track of the number of calls, perhaps you could restart it every now and then: relaunch_4d_

Re: Dynamic PDF Page Extraction...

1. these are LEP based; probably not performant in a loop... https://github.com/miyako/4d-component-poppler https://github.com/miyako/4d-component-pdftk 2. this one is Mac only https://github.com/miyako/4d-plugin-pdf-kit 3. this one is not very good with Japanese text (returns duplicates) http

Re: osx open url vs osascript FYI

for opening documents plugin https://github.com/miyako/4d-plugin-shell-execute component (internally LAUNCH EXTERNAL PROCESS) https://github.com/miyako/4d-component-sublaunch in particular, the escaping of paths is quite robust, not just double-quoting the whole string. but going back to the or

Re: Host Structure in a component

the code "seems OK..." doesn't it work inside a different host? what if you rename the arrays to something different? local variables are permitted in that context, but sometimes strange things occur. ** 4D Internet Users Grou

Re: htaccess and .gz

the web server has a built-in compression feature, Web HTTP compression level Web HTTP compression threshold http://doc.4d.com/4Dv16R2/4D/16-R2.1620/Web-Server.302-3112186.en.html so normally you shouldn't have to care about gunzipping files yourself. 2017/03/13 21:18、Andrea Angeli via 4D_Tech

Re: v13 - Select & Create Document

and for multiple files, there is an optional array parameter to receive all paths. > 2017/03/15 6:36、John Baughman via 4D_Tech <4d_tech@lists.4D.com> のメール： > After the call to Select document, the system variable Document contains the > full path to the document selected. ***

Re: Unique Files Verification Software (Mac)

for simply synchronising two directories possibly on a separate volume, rsync has been around for quite some time. https://en.wikipedia.org/wiki/Rsync but I may be getting wrong the "this" in "anything that will do this". > 2017/03/15 6:56、Robert ListMail via 4D_Tech <4d_tech@lists.4D.com> のメール：

Re: Unique Files Verification Software (Mac)

I guess Git does a pretty decent job at tracking changes and movements in a designated directory, but if you feel 4D give you the strength and flexibility to do exactly what you want, I have nothing against it. > 2017/03/15 8:46、Robert ListMail via 4D_Tech <4d_tech@lists.4D.com> のメール： > Chip, th

Re: tab seperated text - what to use for Cr

not sure if Excel supports it, (FileMaker does) but the formal way to include multiple lines in a TSV field is to use the vertical tab character Char(11). (side-note: Char(11) shows up as \v in the debugger, although you can't it in literal text) if you are interested I can share a set of metho

Re: Weird variable (non-)refresh issue

to refresh variables on display, one must CALL PROCESS(-1) http://doc.4d.com/4Dv15/4D/15/CALL-PROCESS.301-2006854.en.html > 2017/03/16 4:56、bob.miller--- via 4D_Tech <4d_tech@lists.4d.com> のメール： > > I've tried throwing in a REDRAW(variablename) and even a DELAY > PROCESS(Current process;60) - bu

Re: tab seperated text - what to use for Cr

to be pedantic, you need to do more than double quote the values, in case the value themselves contain a double quote. and then, importing gets even more messy, since the values may or may not be quoted. anyway, I've published the component here: https://github.com/miyako/4d-component-csv > 201

Re: 4D V16 fails to launch external programs asynchronously

it (ACI0096092) is also fixed in 16.0 Hotfix 1 (16.0 Hotfix 2 is the latest) > 2017/03/22 5:16、Julio Carneiro via 4D_Tech <4d_tech@lists.4d.com> のメール： > Downloading V16R2 to confirm that it is fixed. ** 4D Internet Users Group

Re: repost : Printer selection issue

I think what you describe is a "32-bit" thing. the code SET CURRENT PRINTER("_192_168_1_33") PRINT SETTINGS(Page setup dialog) shows "any printer" on v16 32-bit, the default printer on v16 64-bit. - even using 32-bit, once you have chosen the printer in the page setup dialog, and stored that s

Re: repost : Printer selection issue

the label editor, as well as regular forms, only accepts integer units. the label editor appears to accept decimal coordinates, but it is only a unit converter, internally the values are always stored in points (integer). remarkably, the "Print object" command works with decimal coordinates, as d

Re: SVG Text Width and Height

Hello, could you not simply set text-anchor to middle? ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech

Re: SVG Text Width and Height

in general, it is best to instruct the rendering engine to decide how to align objects, rather than to compute the exact coordinates yourself. "text-anchor" (start, middle, end) should take care of horizontal align in , but vertical align is going to be difficult since 4D does not support "domi

Re: 4D Query error, Beware

there has been a couple of fixes related to the database engine (transactional query in particular) in recent nightly builds, part of the reasons why some hot-fixes were released during a relatively short time span. 4D v16.0 Hotfix 2 (http://bugs.4d.fr/fixedbugslist?Version=16.0_HF2) ACI0096496

Re: [4DTidbits Blog] Epoch & Unix Timestamp Conversion

you could also... C_LONGINT($yearPosition;$monthPosition;$dayPosition) C_TEXT($digitPosition) GET SYSTEM FORMAT(Short date year position;$digitPosition) $yearPosition:=Num($digitPosition) GET SYSTEM FORMAT(Short date month position;$digitPosition) $monthPosition:=Num($digitPosition) GET SYSTEM FO

Re: 4D email client from Dave Batton, where to get the old sample 4DB ?

Web 2.0 Pack was released more than 10 years ago (v2004). then, the Live Window Plugin was the predecessor to the Web Area form object introduced in v11.2. I am afraid the project (TinyMCE or something similar) has very limited value today. 2017/03/26 0:15、Armin Deeg via 4D_Tech <4d_tech@lists.

Re: 4D email client from Dave Batton, where to get the old sample 4DB ?

it seems the "beta" eventually became http://kb.4d.com/assetid=75229 https://www.youtube.com/watch?v=Q4TUnyuRfhs HTML Email Component By Thomas Maul, 4D Germany Technical Note 09-12 but again, it is v11. 2017/03/27 7:14、Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com<mail

Re: 4D v15.4: Internet commands *SOLVED*

my speculation is that the new line characters have been removed so that the base64 string can now be incorporated more easily as data URIs in SVG and HTML, but I do not know the full story. as a stop-gap measure I posted this plugin https://github.com/miyako/4d-plugin-base64 2017/03/15 1:45、Tw

Re: HTTP Patch request

just pass "PATCH" as text literal to HTTP Request. standard constants (GET, POST, etc) are string constants too. 2017/03/28 0:09、Tom Swenson via 4D_Tech <4d_tech@lists.4d.com> のメール： However, there doesn’t seem to be a Constant for a HTTP patch method Any ideas? Sugg

Re: OPEN PRINTING FORM

FORM LOAD the command was so useful, it can now be used outside of a printing context. > 2017/03/28 10:04、Sujit Shah via 4D_Tech <4d_tech@lists.4d.com> のメール： > I see this command is not available in v15. > What is the replacement? *

Re: HTML Editor in 4D

I think it depends on the application. for instance, in sone cases, using a regular text input for editing the HTML and a web area for preview might turn out to be better than a single object. ** 4D Internet Users Group (4D iN

Re: y2038 -- is 4D ready?

so code to convert date to epoch time like that one just recently discussed (Re: [4DTidbits Blog] Epoch & Unix Timestamp Conversion) could potentially have trouble... > 2017/03/29 0:37、Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> のメール： > Just reading an article about the next Y2K - y2038. > IN

Re: Methods starting with a number

I guess SQL/import export would break since it adds an underscore to illegal field names. perhaps the same with XML export of structure. if has been working for some time, maybe it's not such a high priority, but you'd also want to be prepared for dot-notation support whenever that is going to

Re: Anyone using v16 in WAN

Hello, I think it is important to investigate whether the instability is specific to application code or not. for instance, it is possible to create a bare bone copy of you database with the export structure command. you can then open a copy of your production data with that structure file. i

Re: delete or truncate

ALL RECORDS + DELETE SELECTION, or selecting all records and deleting them in User Mode logs "delete" action for each record in the journal file. TRUNCATE TABLE, on the other hand, has its own single action in the journal file. "Truncate" clears the address table, whereas "Delete" does not. the

Re: Question about passing JSON to 4D

WEB GET VARIABLES only parses form variables (x-www-form-urlencoded). and then, jQuery post() only sends x-www-form-urlencoded. http://stackoverflow.com/questions/5529685/post-doesnt-send-data-as-json-but-as-x-www-form-urlencoded-instead so with this setup, you are basically working with a strin

Re: Question about passing JSON to 4D

have you tried... C_OBJECT($body) WEB GET HTTP BODY($body) ? it might work if you are lucky... 2017/04/05 23:31、Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> のメール： On the 4D side all I need is: WEB GET HTTP BODY($body) and $body contains the text of postData which

Re: Migrating Tables with Relations Between Structures

when you copy multiple tables in the structure editor, you get the table as well as the relation. pasting it back to the structure editor removes all ancillaries such as indexes and links, but the plugin entry-point allows you to re-create them. https://github.com/miyako/4d-plugin-structure-acce

Re: Project Method not found in Quick Report Editor

did you call set allowed methods? ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tec

Re: Project Method not found in Quick Report Editor

is the method made available for components? > 2017/04/07 1:43、John Baughman via 4D_Tech <4d_tech@lists.4D.com> のメール： > I tried another method with the same results. ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.c

Re: Copy out of read only variable/field

you set the field to non-enterable+focusable. 2017/04/07 6:16、Dennis, Neil via 4D_Tech <4d_tech@lists.4d.com> のメール： I'm questioning if this is possible? Anyone? ** 4D Internet Users Group (4D iNUG)

Re: Listbox row select

in general, selected list items are grey when inactive (does not have focus) > 2017/04/07 8:38、Sujit Shah via 4D_Tech <4d_tech@lists.4d.com> のメール： > > I am getting 2 different row highlight (colors) > > - When row is selected indirectly LISTBOX SELECT ROW (grey) > - When row is directly clicked (b

Re: Unexpected External Call Back...

sounds like method with "execute on server" property. > 2017/04/08 12:39、Robert ListMail via 4D_Tech <4d_tech@lists.4D.com> のメール： > "External Call Back” was part of the call chain. ** 4D Internet Users Group (4D iNUG) FAQ: h

Re: Unexpected Command Key Shortcuts (15.4)

in fact, command+L is defined twice, once in File > Open > Form and again in Method > Goto Line when you are using the method editor. similar situation with File > Open > Method and Method > Open Definition both of which are command + K. it is a bad factory setting, in my opinion, as a r

Re: Off topic, sending binary files

perhaps you could add another call to LEP that would chmod +x immediate before you call LEP on to execute scamimage... > 2017/04/09 20:09、Peter Mew via 4D_Tech <4d_tech@lists.4d.com> のメール： > The binary is a command line program called scanimage, which allows me to > interface with a flatbed scann

Re: Replacing - OAuth.bundle

Hello, in general, only the source files (plain text) are expected to be under source-control, as well as common format documents such as PDF or images. large binary files are expected to be published under "Releases". 4D is an unusual case, because the source code (the structure file) is actua

Re: PK wizard, how to start?

if you can find the component in Explorer, there should be a shared method that triggers the dialog. right click and run it... ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d

Re: Questions about the 'Sum' function

Sum() has been improved to work with indexes since v11, with arrays since v13. if the restriction is still there, perhaps one can "selection to array" as a workaround. > 2017/04/14 0:06、Keith White via 4D_Tech <4d_tech@lists.4d.com> のメール： > > QUERY([ClientInvoices]; blah blah blah..) > nThisCusto

Re: How can I suppress the web server creating default index.html?

just goto preferences > web > settings (path) and remove "index.html" > 2017/04/14 23:37、Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> のメール： > Can I suppress 4D's urge to create that page if it's missing? ** 4D Internet User

Re: Clean Slate - Modern User Experience.

Hello, if you could spare some time to go through the various "HDI" examples, especially those themes on the listbox, I think it would be a good way to get tuned with the current development styles in 4D. ftp://ftp.4d.com/SAMPLE_DATABASES/4D/ HTML/SVG/Objects are obviously modern and cool, but

Re: Converting Little Endian Byte Representation To a String

I think this will do it: ASSERT("840003123456770"=Get_value ("02ABC877FAFB0200")) using primary school maths only... -- C_TEXT($1;$0) Case of : (Count parameters=1) C_TEXT(hex;$e;$total) C_LONGINT($i) $hex:=$1 For ($i;1;Length($hex);2) //hex byte code to integer string $byte:=Substring($

Re: Converting Little Endian Byte Representation To a String

oops, had some type mismatches (result of combining 2 methods) -- C_TEXT($1;$0) Case of : (Count parameters=1) C_TEXT(hex;$exp;$total) C_LONGINT($i) $hex:=$1 For ($i;1;Length($hex);2) //hex byte code to integer string $byte:=Substring($hex;$i;2) $code:="" PROCESS 4D TAGS($code;$code) If (

Re: Remedial question about components

Hello, + to check current execution context Structure file=Structure file(*) this is documented (see example 2) http://doc.4d.com/4Dv15/4D/15.4/Structure-file.301-3274414.en.html + when the host and component share the same methods names this is also documented (see Naming conflicts: masking m

Re: Remedial question about components

I think you can do something like $name:="test" (""#METHOD Get path(Path project method;$name)) is a "local" method (""#METHOD Get path(Path project method;$name;*)) //with asterisk is a "host" method > 2017/04/18 19:16、David Adams via 4D_Tech <4d_tech@lists.4d.com> のメール： > As far as I know,

Re: Remedial question about components

to recap, why do you need to know from a compiled component if the host is interpreted? > 2017/04/18 19:16、David Adams via 4D_Tech <4d_tech@lists.4d.com> のメール： > > is there a way to find out if the host is compiled without having the > host pass that information into the component? **

Re: Converting Little Endian Byte Representation To a String

Hello, I think there was a bug in the carry-over logic, I've uploaded a cleaner version here: https://github.com/miyako/4d-tips-text-integer-maths > 2017/04/19 2:03、Cannon Smith via 4D_Tech <4d_tech@lists.4d.com> のメール： > Thanks, Miyako! That does indeed work and is plenty fast as well. I really

Re: Top Menu Vs Sidebar (Web Applications)

perhaps the screen aspect ratio has some part to play, you'd rather not block the whole top (or bottom) strip unless you really have a lot of menus. but then, responsive UI's (like Google) tend to collapse their side menu in button on a square or portrait screen. finally, the human eye is better

Re: Automated tasks on 4D Server

some time ago our Tech Support (not me) posted this: https://github.com/4D-JP/sample-outside-call-for-windows please don't freak out because of the language, the sample code is what's important. basically, you configure the Windows Task Scheduler to run a script (JS) periodically. the script co

Re: Components and custom constants files

maybe one or more constants are redefining default 4D constants with a different type. > 2017/04/19 13:01、David Adams via 4D_Tech <4d_tech@lists.4d.com> のメール： > The argument list for the method named "MessageHub_Unsubscribe" in the > component "MesageHub" is incompatible with the database or comp

Re: 4D Write Pro CSS

http://doc.4d.com/4Dv15/4D/15.4/Supported-tags.300-3274727.en.html explains proprietary CSS attributes such as and Click here > 2017/04/23 1:12、Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> のメール： > its own subset of HTML/CSS attributes and tags, specified in this manual." ***

Re: 4D Write Pro CSS

Hello, if the question is "which experimental CSS is supported in 4D Write Pro?", then I think you might be asking the wrong question. quote: "4D specific tags" means 4D XHTML with a 4D namespace and 4D CSS styles. http://doc.4d.com/4Dv16/4D/16/WP-EXPORT-DOCUMENT.301-3048103.en.html in other wor

Re: Preventing On Start Up from Running

Hello, find {Get 4D folder}/Favorites v16/Local/ open the 4DLink file with a text editor, in the element database_shortcut, add skip_onstartup_method="true", save, and open it with 4D. > 2017/04/24 5:13、Mitchell Shiller via 4D_Tech <4d_tech@lists.4d.com> のメール： > > I accidentally inserted some r

Re: Why does 4D have uppercase UUIDs?

I wasn't aware of the argument that they should always be lowercase. it's true that the native function on Windows (UuidCreate, UuidToString) creates lowercase, but on Mac (NSUUID.UUIDString, CFUUIDCreate/CFUUIDCreateString) they are uppercase and also hyphenated. uppercase-non-hyphenated seems

Re: 4D Write Pro CSS

Hello, > I want to create HTML files and open them in 4D Write Pro. > The docs state that the .4wp format is HTML, but if I try to import even a > very simple HTML document, it fails. I am sorry to say this won't work. 4D Write Pro is not a Web Browser, it so happens that a 4D Write Pro documen

Re: v13 - 4D tool bar visible?

"Tool bar height" returns 0 if it is hidden. http://doc.4d.com/4Dv15/4D/15.4/Tool-bar-height.301-3274612.en.html > 2017/04/27 5:54、Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> のメール： > Is it possible to programmatically determine if the 4D toolbar is > currently displayed? **

Re: Components, forms & menu bars

the "active menu bar" form property needs to be activated for a menu to work while a dialog is running. but, to set this property, you also need to first associate a menu with that form. so, even if the plan is to use a menu reference (|MR...|) passed from host, you need to set a menu from the c

Re: PROCESS 4D TAGS

if the document is not correctly loaded, as others have speculated: 1. given this is Mac, could there be a hidden file extension? 2. Given no encoding is not specified, could it be saved in UTF-16? Document to text doesn't update OK, the only way to know that it worked is to check that the receiv

Re: location of Macros for version 16

you can have your own Macros V2 folder in your database folder, or even a component database folder. http://doc.4d.com/4Dv15/4D/15.4/Creating-and-using-macros.300-3285561.en.html > 2017/05/02 9:46、Jörg Knebel via 4D_Tech <4d_tech@lists.4d.com> のメール： > Could someone be so kind and tell me where I

Re: Tip: Code to get all thread-safe commands

also check out the "How Do I?" example http://blog.4d.com/preemptive-processes-for-4d-language/ http://download.4d.com//Demos/4D_v15_R5/HDI_Command_name.zip another important piece of the puzzle is PROCESS PROPERTIES http://doc.4d.com/4Dv16R2/4D/16-R2.1620/PROCESS-PROPERTIES.301-3111842.en.html

Re: Preemptive mode flaw

is "code injection" even a problem? preemptive mode is all about multi-tasking. I would expect minimal communication between those tasks, literally, they should be "preemptive". it's true you can start a preemptive process with CALL WORKER, but that is not required, you can also use New process o

Re: Preemptive mode flaw

first up, I myself am still in the process of learning how workers work, and I totally agree one should probably start with small POCs or relatively minor tasks before going full on. what I think I leaned so far: keep in mind a CALL WORKER can create a new worker if the previous one was killed.

Re: Preemptive mode flaw

the reason why I think > CALL WORKER("Preemptive_Worker";"MethodWithCooperativeCode") or more specifically > CALL WORKER("Preemptive_Worker";"MethodWithPreemptiveCode") > CALL WORKER("Preemptive_Worker";"MethodWithCooperativeCode") is not a problem goes like this: 4D performs 2 checks; checkin

Re: Bar code

Hello, the plugin returns a regular picture (you have the choice between PNG and SVG) so you should be able to use regular picture commands, such as PICTURE PROPERTIES, TRANSFORM PICTURE, or even picture operators. http://doc.4d.com/4Dv16R2/4D/16-R2.1620/PICTURE-PROPERTIES.301-3111814.en.html ht

Re: 4D Write Pro Interface component

the 4D Write Pro feature "horizontal ruler" was added in 16R2 http://blog.4d.com/4d-write-pro-horizontal-ruler/ > Anyone know how to get that ruler to show? ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug

Re: Lost window cursor

/4D.app/Contents/Resources/Cursors https://drive.google.com/file/d/0B_M-9bo2YDhdODRLbVdOd3J6UDg/view?usp=sharing > 2017/05/11 7:25、Keith Goebel via 4D_Tech <4d_tech@lists.4d.com> のメール： > I expected the cursor to be somewhere inside the 4D Application folders but I > can't find it. > Anyone know

Re: POINTER TO ARRAY

because local variable do not have a name in compile mode, Get pointer (which works on names) does not work for local variables. 2017/05/11 6:39、stardata.info via 4D_Tech <4d_tech@lists.4d.com> のメール： Someone know because? **

Re: Resources v14

your XLIFF file is already a resource, you don't have to load it explicitly. if the file is inside your current localisation folder (Resources/en.lproj) it is automatically loaded when you start your application, and automatically re-loaded each time you activate a window in design mode. to acces

Re: 4D_Pack Replacement commands in v16

EXPORT STRUCTURE gives all the information (and more) you could get for a table, field, relation or index. there is a nice demo on the official blog: http://blog.4d.com/detailed-analysis-database-structure/ > 2017/05/10 19:29、Jörg Knebel via 4D_Tech <4d_tech@lists.4d.com> のメール： > > Would someon

Re: OBJECT SET ENABLED

out of interest, why would you want to over-ride the enabled/disabled state of an object with standard action? B.T.W. until v13, automatic (a.k.a. standard action) objects needed to have an associated variable. since v14, they work with form-local variables, which implied that they now identif

Re: Win32API - sys_LogonUser vs 4D Single-Sign on

I have no experience with sys_logonuser, but the SSO implementation in 4D goes like this: user logs in to Windows (obviously) use connect to 4D Server no login dialog is displayed; the user is connected as "Current client authentication" - additionally - on the server side, LDAP LOGIN, LDAP Searc

Re: OBJECT SET ENABLED

well, I can confirm that this does work: OBJECT SET ACTION(*;"Button";Object No standard action) OBJECT SET ENABLED(*;"Button";False) OBJECT SET ACTION(*;"Button";Object Next page action) OBJECT SET ENABLED(*;"Button";True) > 2017/05/11 9:39、Sujit Shah via 4D_Tech <4d_tech@lists.4d.com> のメール： >

Re: PDF Manuals for v16

Hello, we (4D Japan) used the same process to publish our PDF documentation in Japanese, the files are uploaded here for your convenience: http://library.4d-japan.com/REFERENCE/v16/EN/ > Any information when we can expect the PDF-Manuals for v16? *

Re: Circumflex strangeness with v15 on OS X 10.10.5

how is the user typing the circumflex character? assuming the U.S. keyboard layout is used, option+I would enter a combining circumflex with yellow background. following it with another letter would yield the accented character. but other keyboard layouts (U.S. extended, or FR, for example) have ot

Re: Hex Colour Picker in Listbox

a good place to start would be: Select RGB Color http://doc.4d.com/4Dv16/4D/16.1/Select-RGB-Color.301-3374833.en.html OPEN COLOR PICKER http://doc.4d.com/4Dv16/4D/16.1/OPEN-COLOR-PICKER.301-3374843.en.html > 2017/05/11 17:47、Douglas Cryer via 4D_Tech <4d_tech@lists.4d.com> のメール： > > Automatical

Re: Finding where a filter or format is used in a structure

you could FORM GET NAMES , iterate with FORM LOAD, FORM GET OBJECTS, OBJECT Get filter and process the results. alternatively, you could create a copy of the structure, delete the filter in toolbox and run MSC verify. 2017/05/12 20:08、Paul Lovejoy via 4D_Tech <4d_tech@lists.4d.com

Re: How to detect EOL character in text file

if you are on v14 or later, "Document to text" will normalise the end-of-line to whichever one you prefer. http://doc.4d.com/4Dv15/4D/15.4/Document-to-text.301-3274243.en.html it's better than using regex not knowing what the end-of-line is in the loaded text. 2017/05/13 17:16、Jörg Knebel via 4

Re: Missing Edit Menu

in general (regardless of version, that is), you need to call SET MENU BAR in new each process if want a menu bar to show up, you also need to have the "active menu bar" property for a form if you want the menu to respond during a dialog. the property is only selectable if you have associated a me

Re: Is it possible to do a search in the file system from 4D

This message contains a digitally signed email which can be read by opening the attachment. ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://

Re: Importing Data from a SQL-database (Firebird} [ was: How to detect EOL character in text file]

This message contains a digitally signed email which can be read by opening the attachment. ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://

Re: Is it possible to do a search in the file system from 4D

as long as the files are moved on the same file system, and the files are moved or edited, and not over-written (many applications do that silently...) then you might be able to track those files by keeping their number. https://github.com/miyako/4d-plugin-file - I am working on a side-project

Re: Importing Data from a SQL-database (Firebird} [ was: How to detect EOL character in text file]

I think SQL EXECUTE SCRIPT is more suited for managing long SQL statements, rather than creating a method with Begin SQL~End SQL http://doc.4d.com/4Dv15/4D/15/SQL-EXECUTE-SCRIPT.301-2007434.en.html ** 4D Internet Users Group (

Re: Is it possible to do a search in the file system from 4D

DOCUMENT LIST with the "Recursive parsing" options gives you all the file paths contained in a folder (since v13) http://doc.4d.com/4Dv15/4D/15.4/DOCUMENT-LIST.301-3274226.en.html it has some other useful options too (Ignore invisible, Absolute path) tha makes a lot of previous code for recursiv

Re: Can't delete methods

have tried deleting those 4 methods on the home tab of Explorer, as opposed to the methods tab? ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: htt

Re: SSL RC4 cipher problems

I think you need to specifically set a list with SET, or else the default hard-coded setting is used but the function returns "". you could set a value found here https://wiki.mozilla.org/Security/Server_Side_TLS and compare the results (you don't need to restart the web server) > 2017/05/23 7:

Re: Compatibility Mode v12 (How to change to Unicode?)

> 1) What happens to the existing text data in records (and indexes) if I > check-mark "Unicode" in the Compatibility tab? the data is unchanged but the index will be rebuilt the next time you open the application (structure+data). behaviour of string-related features are all different in Unicod

Re: Compatibility Mode v12 (How to change to Unicode?)

there is a way to apply a specific encoding for each table during conversion ftp://ftp-public.4d.fr/Documents/Products_Documentation/LastVersions/Line_11/VIntl/PDF_Format/4D_v11_Upgrade.pdf see the description for "multilang.txt" > 2017/05/23 19:42、Alan Chan via 4D_Tech <4d_tech@lists.4d.com> のメ

Re: OB Get on Time Field

the same question was posted on the forums a couple of days ago. time values are represented in milliseconds, so a date string, the first part of which is the year 2017, approximates to 2 seconds past midnight. > 2017/05/25 8:32、Tom Dillon via 4D_Tech <4d_tech@lists.4d.com> のメール： > > OB Get($OBGen

Re: OB Get on Time Field

OB Get is simply doing the reverse of OB SET, which sets milliseconds for time. If you want to convert an ISO GMT timestamp to 4D local date or time you can use the Date and Time commands, which were upgraded in v14: $timestamp:="2017-05-25T23:00:00.294Z" //next day in Japan $date:=Date($times

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