Re: Arrow on Windows

2019-04-29 Thread Arnaud de Montard via 4D_Tech
> Le 29 avr. 2019 à 09:59, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > [...] > unicode give you plenty of choices: Very true, unicode is our friend. As an example, a method I use to represent some keyboard keys. The link to wiki in comments is a french-but-interesting

Re: Form and DIALOG

2019-04-29 Thread Arnaud de Montard via 4D_Tech
> Le 29 avr. 2019 à 10:05, Jeremy Roussak via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Is it safe to use the object returned by the Form command as a means of > passing data back to the caller?[...]there’s nothing in the documentation, as > far as I can see, to indicate whether this is

Re: not enough space in memory

2019-04-19 Thread Arnaud de Montard via 4D_Tech
> Le 16 avr. 2019 à 20:14, Peter Mew via 4D_Tech <4d_tech@lists.4d.com> a écrit > : > > Hi > I'm trying to load a large, 1.5G, audio file into a blob using document to > blob Hi Peter, what for? You could load parts of the document: RECEIVE PACKET ( docRef ; receptBlob ;

Re: ORDA and 4D selections

2019-04-10 Thread Arnaud de Montard via 4D_Tech
> Le 10 avr. 2019 à 02:46, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Chuck, > There is no reason to use ORDA if you need a regular selection. Just use > the classic 4D query commands. It depends, for example you have a nice modern orda based interface and want to print

Re: ORDA and 4D selections

2019-04-10 Thread Arnaud de Montard via 4D_Tech
> Le 9 avr. 2019 à 21:21, Douglas von Roeder via 4D_Tech <4d_tech@lists.4d.com> > a écrit : > > “There are simply too many notes.” :-) I'd naturally try in code editor something starting with "entity selection to..." or "selection from...". I dislike command naming starting with a verb

Re: Printing Structure Diagram

2019-04-03 Thread Arnaud de Montard via 4D_Tech
> Le 30 mars 2019 à 21:05, rooftop99--- via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > > Thank you Chip, > > I am aware of the xml and html exports. I have used the xml export for > several purposes. My question is, how do I get the printed visual structure > digram I need using

Re: PDF viewing alternative in v17/64 bit

2019-03-27 Thread Arnaud de Montard via 4D_Tech
> Le 27 mars 2019 à 15:01, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Just ran into a nice surprise in 4D v17 on 64-bit using the embedded "Blink" > web area... it has a very nice cross-platform PDF viewer built in. Just pass > the path of a PDF into WA Open URL and it

Re: Printing a PDF document from 4D

2019-03-20 Thread Arnaud de Montard via 4D_Tech
> Le 19 mars 2019 à 15:03, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > [...] > so I think it is preferable to generate PDF by code than to "print" it, if > possible. (like with the pluggers plugin) I have not used it myself, but as far as I can remember when a friend

Re: Reporting progress

2019-03-20 Thread Arnaud de Montard via 4D_Tech
> Le 20 mars 2019 à 11:00, Jeremy Roussak via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > I’d like to give feedback about the process of a multi-step task - something > like > [...] > I’m sure this must have been done often before and I don’t want to re-invent > the wheel. Any suggestions

Re: Printing forms modified with Duplicate Object

2019-03-07 Thread Arnaud de Montard via 4D_Tech
> Le 7 mars 2019 à 15:48, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > [...] > 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: "Attempting to retype using a pointer"

2019-02-28 Thread Arnaud de Montard via 4D_Tech
> Le 28 févr. 2019 à 08:53, Jeremy Roussak via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > [...]Those values happened to be pointers to variables (created by OBJECT > DUPLICATE and so necessarily referenced using pointers)[...] Hi Jeremy, just curious, why not names instead of pointers on

Re: Epoch time in milliseconds

2019-02-22 Thread Arnaud de Montard via 4D_Tech
> Le 22 févr. 2019 à 15:43, Alan Tilson via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > It seems Timestamp always returns the GMT time zone, correct? Yes: "Timestamp returns the current UTC time…". Good thing BTW… > So to get a localized timestamp one would need to adjust the result?

Re: Write Hex Bytes

2019-02-21 Thread Arnaud de Montard via 4D_Tech
> Le 21 févr. 2019 à 22:09, Peter Mew via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Hi > This is driving me mad, so I hope someone will point me in the right > direction. > I have a string of text. > I can find its length in Hex. now I want to write this length as 4 hex > bytes, into the

Re: Epoch time in milliseconds

2019-02-20 Thread Arnaud de Montard via 4D_Tech
> Le 19 févr. 2019 à 23:51, Peter Jakobsson via 4D_Tech <4d_tech@lists.4d.com> > a écrit : > > > Actually I just realised this may be a timezone issue rather than a precision > issue. > > I’ve done it this way: [...] You may be interested by 2 methods from Bruno Legay about epoch in the

Re: Set Time question

2019-02-14 Thread Arnaud de Montard via 4D_Tech
> Le 10 févr. 2019 à 18:41, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Just to add a little more to this. Me too, forgot to mention CALL FORM: has a message queue, can receive parameters, can call its own window, allows to execute almost any method in the context of the

Re: Relation naming for ORDA in v17? Best Practices anyone?

2019-02-09 Thread Arnaud de Montard via 4D_Tech
> Le 9 févr. 2019 à 15:31, John DeSoi via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > I always use singular table names and the relationship names are singular or > plural based on their type. [...] Hi, using grammatical rules makes reading code closer to human langage. But I prefer to

Re: Remote Runtime Error (What is an "entity set"?)

2019-02-09 Thread Arnaud de Montard via 4D_Tech
> Le 9 févr. 2019 à 05:52, Jeremy French via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > [...] > Questions: > > 1) What is an “entity set”? (Note the word “set” rather than “collection” in > the error message.) Hi again, from this page:

Re: Remote Runtime Error (What is an "entity set"?)

2019-02-09 Thread Arnaud de Montard via 4D_Tech
> Le 9 févr. 2019 à 05:52, Jeremy French via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > [...] 2) Why are “Edit” and “Trace” buttons disabled? Hi Jeremy, I've seen that quite often (component, server, others…). I suppose in this case internal error from DB engine is displayed to client

Re: Relation naming for ORDA in v17? Best Practices anyone?

2019-02-08 Thread Arnaud de Montard via 4D_Tech
> Le 8 févr. 2019 à 20:18, Christian Sakowski via 4D_Tech > <4d_tech@lists.4d.com> a écrit : > >> I went much simpler… > > This is quite the same, but the problem with this approach is, that i cannot > parse relations generically. I do agree, a name that allows to identify the function is

Re: Relation naming for ORDA in v17? Best Practices anyone?

2019-02-08 Thread Arnaud de Montard via 4D_Tech
> Le 8 févr. 2019 à 19:50, Ed Hammond via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Have any of you come up with a convention for naming relations for use with > ORDA? What have you found that works? or doesn't? Hi Ed, the relation name is the direction in which we go from one field to

Re: Set Time question

2019-02-08 Thread Arnaud de Montard via 4D_Tech
> Le 8 févr. 2019 à 17:48, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > [...] Is there a way to trap use actions like that so I can block the > On timer code from running? Each new SET TIMER "kills" the previously set one, so it allows to postpone or cancel next 'On timer'.

Re: How to display read-only input form

2019-02-07 Thread Arnaud de Montard via 4D_Tech
> Le 6 févr. 2019 à 22:31, Jim Crate via 4D_Tech <4d_tech@lists.4d.com> a écrit > : > > [...] > I thought about using DIALOG, [...] I would stop using legacy display commands (display/modify selection, add/modify record… maybe I forget some). IMHO 4D modern way to display a form is dialog,

Re: Command Symbol as part of Title of Button

2019-01-17 Thread Arnaud de Montard via 4D_Tech
Hi John, I use the following method to get the unicode value from some 4D constants: + //UI_KeyboardGetChar (keyCode_l) -> code //$0 code representing the keyCode_l //keyCode_l: 4D constant //example: Char(UI_KeyboardCharCode (Tab key)) -> "⇥"

Re: v13- Chasing Relations

2019-01-10 Thread Arnaud de Montard via 4D_Tech
> Le 10 janv. 2019 à 20:21, cjmiller--- via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > You could run it on server Running a method on server is great if there a lot of data to read and/or write, because it avoids the transfer of these data through network. Here the data is very small,

Re: v13- Chasing Relations

2019-01-10 Thread Arnaud de Montard via 4D_Tech
> Le 10 janv. 2019 à 19:52, Charles Miller via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > You can use data form the following two 4d tables without having to > loop through each of your tables/fields [...] Yes, but it's always slower in C/S (specially when it's far far away): using system

Re: v13- Chasing Relations

2019-01-10 Thread Arnaud de Montard via 4D_Tech
> Le 8 janv. 2019 à 21:47, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > given a pointer to a table, or a pointer to a field of a table, > I want to be able, for the current record of this table, to : Hi Chip, I use this for foreign keys: //DB_getForeignKeys (aTable_p)

Re: Pasting Spreadsheet Data into 4D Records

2018-12-25 Thread Arnaud de Montard via 4D_Tech
> Le 24 déc. 2018 à 20:44, Alan Tilson via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > [...] > I probably should have said that I potentially have hundreds of copy/paste > operations to do! When users have to do it very often, it's more efficient to copy in spreadsheet / paste in 4D than

Re: Storing Dates and Times From Different Time Zones

2018-12-21 Thread Arnaud de Montard via 4D_Tech
> Le 20 déc. 2018 à 18:54, Nate Rheaume via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > We have clients that are accessing the same server database from different > time zones. We would like to store date/time using GMT and then display it in > the users local time zone. As I understand,

Re: Understanding Unicode Characters

2018-12-21 Thread Arnaud de Montard via 4D_Tech
> Le 20 déc. 2018 à 00:07, Robert ListMail via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > [...] why is the unicode value written as “U+2022”, do you ever have to type > “U+”? Hi Robert, you can use an hex value in 4d code by replacing "U+" with "0x": ASSERT(8226=0x2022)

Re: Appearance of Tab Control objects

2018-12-18 Thread Arnaud de Montard via 4D_Tech
> Le 17 déc. 2018 à 23:54, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Using v17 - > Is there any way to control the appearance of tab control objects? Hi Pat, I don't think it's possible, I seem to remember it's "system inherited". But there was a nice example of tab

Re: Coding/Development Style Guide?

2018-12-15 Thread Arnaud de Montard via 4D_Tech
> Le 14 déc. 2018 à 18:35, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Hi Chip, > > Thanks for pointing out that forms can be inherited. I still have inherited, but in recent jobs I use subforms instead. They offer more solutions to design "shared parts" of UI. --

Re: Coding/Development Style Guide?

2018-12-14 Thread Arnaud de Montard via 4D_Tech
> Le 14 déc. 2018 à 16:48, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > We have a family simple but effective set of rules for naming variables. > [...] Hi, we're using something similar for variables (except it's suffixes: myText_t, myDate_d, myTwoDimentionalArrayText_a2t,

Re: 4D Structure Export...

2018-12-08 Thread Arnaud de Montard via 4D_Tech
> Le 7 déc. 2018 à 23:11, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > >> [...] > I see how one would get the modified date for the method using METHOD GET > MODIFICATION DATE, but I don’t see a METHOD GET MODIFIED BY. Thinking that Current user works already on server

Re: v17 kind of gotcha

2018-12-06 Thread Arnaud de Montard via 4D_Tech
> Le 6 déc. 2018 à 18:48, Charles Miller via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Ok thanks for the update but I am having these problems in a v17 dB. The > error does not occur in v16 or v15 I suppose v17 throws an error because it's less permissive. Did you check there is no

Re: v17 kind of gotcha

2018-12-05 Thread Arnaud de Montard via 4D_Tech
> Le 5 déc. 2018 à 19:18, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > I know one should never have two objects on a form with the same name. I have > code that creates list boxes on forms. In v16 compiled or source, I get no > errors. In v17 I get error as I had named

Re: [TIP]: Esoteric method for calculating Excel column references

2018-12-05 Thread Arnaud de Montard via 4D_Tech
> Le 2 déc. 2018 à 00:00, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > I had need to calculate column references for an Excel spreadsheet for > columns greater than 26. You know, so you can come up with the reference > like: A1:AG1. Hi Kirk, I had the same problem in the

Re: Related Fields in a Listbox (Manual Relations)

2018-11-18 Thread Arnaud de Montard via 4D_Tech
> Le 16 nov. 2018 à 20:36, Keith Culotta via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Actually, "ok" and "better" are reversed in the examples. More efficient to > let the Automatic Relations do the work. Yes, I was surprised when I read ;-) Sannyasin, • using on display detail

Re: Current time (*) incorrect today on v17?

2018-11-05 Thread Arnaud de Montard via 4D_Tech
> Le 5 nov. 2018 à 09:42, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com > > a écrit : > > 16R4 and later offers Timestamp > > http://doc.4d.com/4Dv17/4D/17/Timestamp.301-3730728.en.html > > >

Re: Current time (*) incorrect today on v17?

2018-11-05 Thread Arnaud de Montard via 4D_Tech
> Le 4 nov. 2018 à 20:01, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Seems like Current time(*) from a client might be cached incorrectly as an > optimization, since Current time and Current time(*) on the server both > returned correct values. Looks like. But I'm

Re: Current time (*) incorrect today on v17?

2018-11-04 Thread Arnaud de Montard via 4D_Tech
> Le 4 nov. 2018 à 18:34, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Looks like restarting the server fixes it. Sorry, I did not see you mentioned v17. For my own I see my alert twice a year since v12: seems to be a deep solid bug. I've heard in Europe Daylight Saving

Re: Current time (*) incorrect today on v17?

2018-11-04 Thread Arnaud de Montard via 4D_Tech
> Le 4 nov. 2018 à 17:23, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Is anyone else seeing that current time (*) called from a Mac client to a > Windows server running 4D v17 (HF3) is returning a time that's an hour ahead? > > The Windows time on the server is current,

Re: Opening a verify log

2018-10-31 Thread Arnaud de Montard via 4D_Tech
> Le 29 oct. 2018 à 23:18, Robert McKeever via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > 4D v16.3, Mac OS 10.11.6. > > [...] > > But, what can I use to see the log files without using BBEdit? Even when > verifying the data file, its log file opens blank in a browser as well. Firefox

Re: Help->v11 to v17 Upgrade or New?

2018-10-18 Thread Arnaud de Montard via 4D_Tech
> Le 17 oct. 2018 à 21:45, Robert ListMail via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > [...] > > Also, the client originally said the new database would not have to migrate > data forward from the old system and now they are wanting to have the data > too. Most of the I write the new

Re: Sets and the twinned process (Execute on server)

2018-10-17 Thread Arnaud de Montard via 4D_Tech
> Le 17 oct. 2018 à 17:58, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > [...] a process set created on the > client side is available to a trigger method which runs on the server. > > I have an EOS method that does some queries and creates a set. I notice > that set is

Re: v13 - Change Button Shortcut

2018-10-15 Thread Arnaud de Montard via 4D_Tech
> Le 12 oct. 2018 à 22:47, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Is there a way to globally change the key shortcut assigned to a button > across multiple forms. > > I inadvertently use Command (control) + Esc as short cut rather then > just Esc for form cancel

Re: Where is best place to save data outside data file

2018-10-10 Thread Arnaud de Montard via 4D_Tech
> Le 9 oct. 2018 à 17:50, Jody Bevan via 4D_Tech <4d_tech@lists.4d.com> a écrit > : > > [...] > 1. Is this the right location I should be saving this kind of information? Unless it represents a huge amout of data / traffic, I think I'd choose to write this on server side. -- Arnaud de

Re: v13 - Relate One Selection issue

2018-10-03 Thread Arnaud de Montard via 4D_Tech
> Le 2 oct. 2018 à 20:10, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > [...] > > I ask because it is not, even after a restart of 4D The doc says it should: "The RELATE ONE SELECTION command creates a new selection of records for the table oneTable, based on the selection

Anyone using int64 field?

2018-09-25 Thread Arnaud de Montard via 4D_Tech
(the object says it all) -- Arnaud de Montard ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub:

Re: 2 Factor Authentication

2018-09-19 Thread Arnaud de Montard via 4D_Tech
> Le 19 sept. 2018 à 20:39, Peter Bozek via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > On Wed, Sep 19, 2018 at 7:49 PM Timothy Penner via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > >> Did you go to the 4D Summit? >> >> If so, then you should have access to this: >>

Re: Do I want to use SELECTION TO ARRAY instead of GOTO SELECTED RECORD server-side in V17

2018-09-19 Thread Arnaud de Montard via 4D_Tech
> Le 18 sept. 2018 à 18:50, Dani Beaubien a > écrit : > > This has been a very interesting discussion. I decided to test the various > techniques using the code I pasted below. > [...] Thanks for testing :-) Some thoughts… - I had surprises with tests using a single string of the same

Re: Do I want to use SELECTION TO ARRAY instead of GOTO SELECTED RECORD server-side in V17

2018-09-17 Thread Arnaud de Montard via 4D_Tech
> Le 17 sept. 2018 à 16:15, Bart Davis via 4D_Tech <4d_tech@lists.4d.com > > a écrit : > > No need to write to a file. Appending text to a text variable is very slow, > but using TEXT TO BLOB($textToAdd;$blob;UTF8 text without length;*) is very > fast. Give

good job needs good doc

2018-09-12 Thread Arnaud de Montard via 4D_Tech
When I use 4dv16r6, I'd like the alt clic shortcut on a command to open the good version of doc. Of course not, it drives me nuts. Any idea? Where are documented the links we can use? -- Arnaud de Montard ** 4D Internet

Re: table/field token

2018-09-07 Thread Arnaud de Montard via 4D_Tech
> Le 7 sept. 2018 à 00:28, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > I tested with a recent nightly build (17.226877) > > I have [Table_1] but as I type [xx:1] and hit enter, it tokenises as [Table_1] > same with [:1] Hi Miyako, many thanks for testing :-) I didn't

Re: table/field token

2018-09-06 Thread Arnaud de Montard via 4D_Tech
> Le 6 sept. 2018 à 17:38, Richard Wright via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > I thought you were saying that these characters were not allowed as of v16 R4 > even without enabling the new feature. I’m just hoping that 4D will never > require us to enable the new feature or, if

Re: table/field token

2018-09-06 Thread Arnaud de Montard via 4D_Tech
> Le 6 sept. 2018 à 08:20, Arnaud de Montard via 4D_Tech <4d_tech@lists.4d.com> > a écrit : > > Hi Tim, > I did not get your first response from the list. No matter as I can read it > cited under Richard's response, but I wonder about that gap?? oops I'm wrong

Re: table/field token

2018-09-06 Thread Arnaud de Montard via 4D_Tech
> Le 6 sept. 2018 à 01:31, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > [...] > > e.g. [contacts:2] but maybe [contacts] is NOT table #2 Hi Miyako, to be clearer, this is screen capture of method editor (supposing it's a similar mechanism to the interpreter):

Re: table/field token

2018-09-06 Thread Arnaud de Montard via 4D_Tech
Hi Tim, I did not get your first response from the list. No matter as I can read it cited under Richard's response, but I wonder about that gap?? -- Arnaud de Montard ** 4D Internet Users Group (4D iNUG) Archive:

table/field token

2018-09-05 Thread Arnaud de Montard via 4D_Tech
Migrating from v14r5 to v16r6, dot notation on. In fomulas referencing fields, I have things like this: TimeStampToText([:2]:3) In v16r6, such token is no longer recognised ; I've found 2 turnarounds : 1/ add the table/field names before the token: TimeStampToText ([aTable:2]aField:3) 2/

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

2018-09-03 Thread Arnaud de Montard via 4D_Tech
> Le 3 sept. 2018 à 00:45, Jim Labos - infobase via 4D_Tech > <4d_tech@lists.4d.com> a écrit : > > [...] > > What do you all think? Is this a bug? An annoying gotcha? Did you already > all know this and I am the only one who didn't? QUERY([aTable];[aTable]longint=Num("123xxx") We are not

Re: [offish] Code to make your head hurt

2018-08-16 Thread Arnaud de Montard via 4D_Tech
> Le 16 août 2018 à 01:29, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > interpretably it does work - with locals! > > tomorrow Ill try compiled... Second syntax of MULTI SORT ARRAY does not work? -- Arnaud de Montard

Re: SVG IDs in Listbox Cells

2018-08-15 Thread Arnaud de Montard via 4D_Tech
> Le 15 août 2018 à 16:21, Cannon Smith via 4D_Tech <4d_tech@lists.4d.com > > a écrit : > > LISTBOX GET CELL COORDINATES Hi Cannon, I'm afraid I had not seen this command exists since v14r5 - I must get old and blind. Thanks for better code :-) BTW, it seems

Re: SVG IDs in Listbox Cells

2018-08-15 Thread Arnaud de Montard via 4D_Tech
> Le 15 août 2018 à 11:36, jim.dorrance--- via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > [...] calculate the scrollbar positions and find the cell. 2 methods (c4d format) for that…

Re: Conversion to WritePro

2018-08-15 Thread Arnaud de Montard via 4D_Tech
> Le 15 août 2018 à 15:30, Bernd Fröhlich via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > [...] > Seems like the space between lines is not kept as before. > > Don´t quite know how to proceed now. > Luckily the old 4D Write still works in V17. > I guess I just stick to it until (hopefully)

Re: SVG IDs in Listbox Cells

2018-08-13 Thread Arnaud de Montard via 4D_Tech
> Le 13 août 2018 à 19:01, Cannon Smith via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > You know how you can give SVG elements IDs and then use SVG Find element ID > by coordinates during a click or mouse over event to figure out what element > the mouse is over in an SVG picture? I’d like

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

2018-08-06 Thread Arnaud de Montard via 4D_Tech
> Le 4 août 2018 à 00:25, Timothy Penner via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > [...] > > The ISP @ our French Headquarters is doing a scheduled maintenance that > started 20 minutes ago and is planned to last another 4 hours 10 minutes. It seems they found refuge in an ice

Re: Fields Missing Getters and setters

2018-08-05 Thread Arnaud de Montard via 4D_Tech
> Le 3 août 2018 à 18:36, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > I am trying to insure that all of my intended primary key fields - are > primary keys. > [...] > > Am I missing something? Yes ;-) I think it's better to use structure xml description instead of SQL:

Re: v13 - marking field as 'Primary Key'

2018-08-05 Thread Arnaud de Montard via 4D_Tech
> Le 3 août 2018 à 18:12, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Thanks, > I do not really use the online docs > but it is nice to know SQL script example. ++ /* tables and primary keys */ CREATE TABLE Agence ( PK INT32 NOT NULL UNIQUE AUTO_INCREMENT,

Re: v13 - Record to Blob?

2018-07-31 Thread Arnaud de Montard via 4D_Tech
> Le 30 juil. 2018 à 21:56, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > I thought about that... > just wondering if there was something native I missed. I use this: It's old, needs to be adapted for object fields.

Re: Execute on Server Method Attribute

2018-07-16 Thread Arnaud de Montard via 4D_Tech
> Le 15 juil. 2018 à 04:47, Ben Kershaw via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Is one of those arrays a pointer array? I’m guessing so, because that doesn’t > work and results in that error message. A pointer to other array types works > fine, but not a pointer array. Sorry. > >

Re: Cannot delete if related many issue

2018-07-09 Thread Arnaud de Montard via 4D_Tech
> Le 7 juil. 2018 à 17:52, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Arnaud, > a couple of other thoughts > - are any/all of the related tables very large in record count size? this > might be a cache thing... > maybe 4D is 'thrashing' loading indexes etc, then

Re: UUID version 4 needed

2018-07-07 Thread Arnaud de Montard via 4D_Tech
> Le 6 juil. 2018 à 16:05, Piotr Chabot Stadhouders via 4D_Tech > <4d_tech@lists.4d.com> a écrit : > > And in fact, my 4D generated UUID is rejected by the web service, saying it > isn't a 4 version UUID with

Re: Cannot delete if related many issue

2018-07-07 Thread Arnaud de Montard via 4D_Tech
> Le 5 juil. 2018 à 13:12, Arnaud de Montard via 4D_Tech <4d_tech@lists.4d.com> > a écrit : > > I have a database in which Deletion Control is set as in the object for a lot > of relations. Today, deleting 10 records in a table having ~2 billion records > took a

Cannot delete if related many issue

2018-07-05 Thread Arnaud de Montard via 4D_Tech
I have a database in which Deletion Control is set as in the object for a lot of relations. Today, deleting 10 records in a table having ~2 billion records took an incredible time, cache as shark teeth, unable to connect and so on. Finally we had to kill the server. After setting Deletion

Re: 4Dv16R6: Object on form still active when another object is on top

2018-06-28 Thread Arnaud de Montard via 4D_Tech
> Le 28 juin 2018 à 11:08, Two Way Communications via 4D_Tech > <4d_tech@lists.4d.com> a écrit : > > Has anyone else noticed this? > > I have a form that shows enterable variables, popups, picture buttons and > rulers. > > In some cases I want to disable these objects. I put a rectangle

Re: v13 - Konstants [Solved]

2018-06-27 Thread Arnaud de Montard via 4D_Tech
> Le 27 juin 2018 à 18:02, Jody Bevan via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Chip and Keisuke: > > Very interesting thread. We have been using 4D Pop extensively for several > years. > > If UUID are required, and 4D Pop is not handling them right, then I guess we > need to write

Re: select from _USER_COLUMNS

2018-06-15 Thread Arnaud de Montard via 4D_Tech
> Le 11 juin 2018 à 22:33, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > What values can be returned in $DataType_aL It seems that they do not equal > 4D data types (I did not expect it to) Is there a chart I can not find that > lists them? See here:

Re: Save Record($vptr_Table->)

2018-06-11 Thread Arnaud de Montard via 4D_Tech
> Le 10 juin 2018 à 23:18, Jody Bevan via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Sujit: > > I do not think it is a table number issue in our code. We built the local > pointer early into the new process by code similar to > $vptr_Table:=->[StandardOrder] > > In one last try, before

Re: __Orphan___xxxx methods

2018-06-10 Thread Arnaud de Montard via 4D_Tech
> Le 9 juin 2018 à 17:28, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > I believe that mostly they are object methods from deleted forms, Easy to reproduce: delete a form object without deleting its method object before, you get an orphan. (un)works this way since v11. --

Re: Icons On Tab Control

2018-06-03 Thread Arnaud de Montard via 4D_Tech
> Le 3 juin 2018 à 14:35, Stephen J. Orth via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > May be a dumb question, but I noticed in the Tab Control documentation > (V16.3) it says icons can be displayed on each tab, however I don't see any > documentation on how that is accomplished. > >

Re: v13 - Null values

2018-06-02 Thread Arnaud de Montard via 4D_Tech
> Le 1 juin 2018 à 20:39, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > I meant - I was looking for a command which behaved like Nil(), but for > Null. Hi Chip, I had a bad recent experience with a legacy db in which check box "convert Null to empty" was sometimes on,

Re: Pointer to field using field name

2018-05-19 Thread Arnaud de Montard via 4D_Tech
> Le 19 mai 2018 à 20:22, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > I don't even know if 4D > supports tables with more than 1000 fields (probably does now) but that > just seems like incredibly - esoteric - design, at best. 2^32 is the max for fields and tables. Using

Re: Pointer to field using field name

2018-05-19 Thread Arnaud de Montard via 4D_Tech
> Le 19 mai 2018 à 09:28, Jim Dorrance via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > I use maxint because it is a constant:) Yes, in the tread under Benoit suggested something similar: • store: $combo_l:=($tableNum << 16)+$fieldNum • extract: $tableNum:=$combo_l >> 16

Re: Pointer to field using field name

2018-05-18 Thread Arnaud de Montard via 4D_Tech
> Le 18 mai 2018 à 22:41, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > won't 10K could overflow 32-bit integer? > I would use 32768 as multiplier... Why? 2^(32-1) > 2,000,000,000 I use more: $tableAndField:=(100,000*tableNum)+fieldNum -- Arnaud

Re: Pointer to field using field name

2018-05-18 Thread Arnaud de Montard via 4D_Tech
> Le 17 mai 2018 à 19:24, Alan Tilson via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > [...] > Is there something wrong with this? > > EXECUTE FORMULA("$pField:=->["+tablename+"]"+fieldname) > ​ > It seems to work and it also seems like it would be fast! Not sure, it calls the interpreter

Re: Options To Put Data Into Existing Excel Spreadsheets?

2018-05-08 Thread Arnaud de Montard via 4D_Tech
> Le 8 mai 2018 à 09:14, Douglas Cryer via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > 2CV to a Ferrari What's the difference? -- Arnaud de Montard

Re: Constants - Can I make a Date Constant?

2018-05-01 Thread Arnaud de Montard via 4D_Tech
> Le 30 avr. 2018 à 21:33, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > for example : !00/00/00! //KdateNull -> date c_date($0) $0:=!00/00/00! -- Arnaud de Montard ** 4D Internet Users Group (4D

Re: [Tip?] Test path name and Posix

2018-04-30 Thread Arnaud de Montard via 4D_Tech
> Le 28 avr. 2018 à 19:05, Arnaud de Montard via 4D_Tech <4d_tech@lists.4d.com> > a écrit : > > >> Le 27 avr. 2018 à 19:29, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> a >> écrit : >> >> Test Path Name FAILS (file/folder does not exist)

Re: [Tip?] Test path name and Posix

2018-04-28 Thread Arnaud de Montard via 4D_Tech
> Le 27 avr. 2018 à 19:29, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Test Path Name FAILS (file/folder does not exist) if given a POSIX > formatted path. Normal behaviour, doc says "You can pass either a relative or absolute pathname, expressed in the syntax of the

Re: A thought on re-indexing of a large database after repairs, compacting etc

2018-04-23 Thread Arnaud de Montard via 4D_Tech
> Le 23 avr. 2018 à 07:51, Paul Lovejoy via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Chuck, > > You know the old saying: “A watched pot never boils.” > Watching 4D reload the same table with 7 million records 8 times to generate > 8 indexes is kind of like that. > > I don’t have the

4d servers down

2018-04-22 Thread Arnaud de Montard via 4D_Tech
livedoc, taow, 4dbb web servers do not respond. So do you? -- Arnaud de Montard ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options:

Re: A thought on re-indexing of a large database after repairs, compacting etc

2018-04-22 Thread Arnaud de Montard via 4D_Tech
> Le 22 avr. 2018 à 11:08, Paul Lovejoy via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Hi, > > I guess our database of 120gb, running on a 32 bit machine doesn’t benefit > from this. We were working on the most recent R release and yesterday we went > to 15.5. > When reindexing the

Re: How to Determine Field Type from XML Structure Export?

2018-04-20 Thread Arnaud de Montard via 4D_Tech
> Le 20 avr. 2018 à 04:16, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > if you do an introspection using SQL, > > Begin SQL > SELECT * FROM _USER_COLUMNS INTO LISTBOX :L > End SQL > > you'd see 2 columns, DATA_TYPE and OLD_DATA_TYPE Here's a picture of the result:

Re: What happened to LISTBOX Get Information?

2018-04-20 Thread Arnaud de Montard via 4D_Tech
> Le 19 avr. 2018 à 16:43, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Ah ha! - it's been renamed: LISTBOX Get property > > On Thu, Apr 19, 2018 at 7:26 AM, Kirk Brooks wrote: > >> LISTBOX Get Information isn't in the language ref for v16r or v17 and

Re: v13+ On Err Call - overhead?

2018-04-18 Thread Arnaud de Montard via 4D_Tech
> Le 16 avr. 2018 à 18:38, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > What kind of over head is there on setting and clearing On Err Call? > > If On Err Call is being set and cleared in a loop, is there a > significant overhead issue? I tested that 3 or 4 years ago:

Re: 4D Summit

2018-03-23 Thread Arnaud de Montard via 4D_Tech
> Le 20 mars 2018 à 12:10, Wayne Stewart via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Hi, > > I’m sitting in in the master class by Laurent in Paris. > > Absolutely fantastic, if you haven’t booked for Washington yet you need to > break open the piggy bank now and book! Yes, v17 is THE

Re: Collections

2018-03-16 Thread Arnaud de Montard via 4D_Tech
> Le 16 mars 2018 à 14:11, Epperlein, Lutz (agendo) via 4D_Tech > <4d_tech@lists.4d.com> a écrit : > > For another reason using collections see this feature request: > http://forums.4d.com/Post/DE/19953344/1/19953345#19954007 see also:

Re: Collections

2018-03-16 Thread Arnaud de Montard via 4D_Tech
> Le 16 mars 2018 à 03:43, Keith Goebel via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Hi all. > 4D seem to be really fired up about the new Collection object available in > upcoming versions. > I’ve read the examples given in the blurb, but I have yet to read anything > that would give

Re: Blank Listbox

2018-02-23 Thread Arnaud de Montard via 4D_Tech
> Le 23 févr. 2018 à 16:42, Spencer Hinsdale via 4D_Tech <4d_tech@lists.4d.com> > a écrit : > > my blank list boxes are always arrays, out of sync same here: columns empty in a listbox (lb) means on column shorter or longer that others. How is filled the lb in group4: selection to array,

Re: query for empty string

2018-02-15 Thread Arnaud de Montard via 4D_Tech
> Le 15 févr. 2018 à 05:03, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > >> but I'm still trying to wrap my brain around the sorts of situations that >> might require using length=0 > > as mentioned in the previous post, > there are some (non) characters that has a

Re: Problem with PDF Creation into Temporary Folder (Follow-up)

2018-02-03 Thread Arnaud de Montard via 4D_Tech
> Le 3 févr. 2018 à 16:28, Stephen Shaw via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > I have now spent some time on this: > > 3. Error -43 is returned on the following line >$error:=SMTP_Attachment ($smtp_id; $document; 2; 0; ””; ”application/PDF”) Sounds linked to SMTP_Attachment…

  1   2   3   >