Re: First experiments with 4D View PRO

I am of similar mind as Jeff in regard to charging if one just uses for the extra Listbox features. There are times where the features of being able to show pictures, numbers, Strings, etc in the same column of the Listbox has proved very useful. Having done this in our shell, it means we

Re: First experiments with 4D View PRO

For what it's worth, I don't see why the handful of listbox improvements aren't just rolled into the v17 upgrade. For those who need 4D View spreadsheet type stuff, it's available to buy (in a primitive form to be sure), but the new listbox features would be universally appreciated. -- Jeffrey

Re: First experiments with 4D View PRO

Keisuke, With all due respect, I will stay with the listbox for the time being. Clearly, 4D View Pro is not ready yet to be used. I can’t see any benefit at all by trying to figure out the json schema. Regards, Rudy Mortier Two Way Communications bvba > On 17 May 2018, at 22:44, Keisuke

RE: Pointer to field using field name

> $code:="$4deval($1->:=->["+$tablename+"]"+$fieldname+")" > PROCESS 4D TAGS($code;$code;->$pField) This is a nice little gem to keep in mind :) Thanks Neil -- Privacy Disclaimer: This message contains confidential information and is intended only for the named addressee. If you are

Re: Pointer to field using field name

alternatively $tablename:="Table_1" $fieldname:="ID" $code:="$4deval($1->:=->["+$tablename+"]"+$fieldname+")" PROCESS 4D TAGS($code;$code;->$pField) EXECUTE FORMULA("$pField:=->["+tablename+"]"+fieldname) ** 4D Internet

Re: First experiments with 4D View PRO

a 4D View Pro document is stored in an object. http://doc.4d.com/4Dv16R6/4D/16-R6/Handling-4D-View-Pro-areas.300-3631583.en.html schema: /Applications/4D/4D v17/4D.app/Contents/Components/4D ViewPro.4dbase/Resources/4DViewSchema.json you can use regular OB commands or object notation to

Re: Pointer to field using field name

On May 17, 2018, at 2:00 PM, Alan Tilson wrote: > Thank you Koen, Dennis & Chip, > > I probably should have said what I was doing...which is that I'm copying > certain fields from a sister table with some of the same field names. So I > step though all the sister table fields and load the values

Re: First experiments with 4D View PRO

Hi Keisuke, Thanks for elaborating on this. However, I can’t imagine that the only purpose is to open 4D View files, and I am sure that additional functionality will be added in future versions. (at least, that’s what we’ve been told at the summit) It’s just that, at this point, the 4D View

RE: Pointer to field using field name

> It seems to work and it also seems like it would be fast! > EXECUTE FORMULA("$pField:=->["+tablename+"]"+fieldname) Unless something has changed, this will not work compiled. Neil Privacy Disclaimer: This message contains confidential information and is intended only for the named

Re: Pointer to field using field name

Thank you Koen, Dennis & Chip, I probably should have said what I was doing...which is that I'm copying certain fields from a sister table with some of the same field names. So I step though all the sister table fields and load the values (except for the first one which is the ID field) into the

Re: Pointer to field using field name

that approach will break if you change the field name, assuming the field name is hardcoded. depending on your needs you can do this (code written in email so...): this code can be run as needed, at process startup (use process vars), or it can be run at database startup (use Interprocess

RE: Pointer to field using field name

To get a field pointer to a field from the field name you can loop through the table incrementing the field number until you find the correct name and return a pointer to it, this is very fast since it is all in memory. For ($i;1;Get last field number($TableNumber)) If (Is field number

Re: Pointer to field using field name

Hi Alan, If you have the table number, you can loop over the fields of that table and compare the name to the given name to get the field number and thus the field pointer. Something like: //$foundtable is the table number //if pointer given, $foundtable := Table($tablepointer) For ($i;1;Get

Pointer to field using field name

​Hello out there, Is it possible to extract a pointer to a field from the table number or pointer and the field name? I'm loading a field using EXECUTE FORMULA and building the [tablename]fieldname into the formula, which serves my purposes but seems rather awkward! Thanks, Alan ​

Re: Analyzing .4BL Files

Thanks Chip, Randy, and Jeff. Thanks to your suggestions I was able to track down something that I should have know but did not. The RESTORE command will convert a .4BL to a .journal file. From there I can use the MSC to look at it or, even better, the LOG FILE TO JSON command which is nice for

Re: First experiments with 4D View PRO

4D has studied how the classic 4D View plugin has beeb used in various applications, and found that there were essentially two distinct usages; "as a list" and "as a spreadsheet". based on that understanding, two different paths have been defined to carry on the 4D View legacy: 1. a set of

Re: Analyzing .4BL Files

I was just looking at this tech note last week http://kb.4d.com/assetid=77626 It’s a 4D Summit attendee only database, but I was impressed at how well it worked. Now I have to go look at LogTools. Randy

Re: Analyzing .4BL Files

Pretty sure LogTools can open a 4BL. It's a great utility to have in your tool chest. -- Jeffrey Kain jeffrey.k...@gmail.com > On May 16, 2018, at 11:59 PM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > i never done this with 4bl files, just a suggestion > open with a text

First experiments with 4D View PRO

Has anyone played around with 4D View Pro already? I tried to put object arrays into the 4D View Pro area, like it was a listbox. And although it does work with a listbox (4D v16R6), the 4D View Pro area stays empty. Any idea how to even add columns and rows in 4D View Pro? I guess one could