Re: selected rows for a collection listbox

Hey John, On Mon, Jul 30, 2018 at 7:05 PM John DeSoi via 4D_Tech <4d_tech@lists.4d.com> wrote: > The selected row numbers matter if you are not using ORDA or a fully > materialized collection of objects. I hesitant to comment directly on what you're doing because frankly you are frequently

Re: ORDA question: how do I add related fields to an entity selection?

or, DA. C_COLLECTION($one;$many) $one:=New collection $many:=New collection For each ($attribute;ds.Table_1) $kind:=ds.Table_1[$attribute].kind Case of : ($kind="storage") : ($kind="relatedEntity") $one.push($attribute) : ($kind="relatedEntities") $many.push($attribute) End case End for

Re: v13 - Record to Blob?

I think this would be very useful as a native command and trivial to implement (already in the plugin API, I think). If you agree, here is the feature request: http://forums.4d.com/Post/EN/17757394/1/17757547 John DeSoi, Ph.D. > On Jul 30, 2018, at 2:40 PM, Keisuke Miyako via 4D_Tech >

Re: selected rows for a collection listbox

Hi Kirk, Great summary, thanks for posting. > On Jul 30, 2018, at 10:27 AM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Eventually I got the concept of manipulating the data in the collection > instead of in the listbox is the key. This is why it doesn't really matter > which

Re: v13 - Record to Blob?

On Jul 30, 2018, at 2:00 PM, Chip Scheide wrote: > I do not see a command that allows this action (directly) > am I missing something, or do I need to write something? No 4D native command. You need Rob’s “API Pack” it has command to go "API Record to BLOB" and “API BLOB to Record" Tim

Re: ORDA question: how do I add related fields to an entity selection?

Thanks Lahav, that works. I’m using an Entity Selection to display on a Listbox and I needed to include some related field columns. Using relation names did the trick. This is all generic code written a long time ago and I’m upgrading it to V17+ORDA. As a thank you for the tip, here is some

Re: v13+ Unicode characters 1-7

Thanks for the suggestion! On Mon, 30 Jul 2018 19:40:03 +, Keisuke Miyako via 4D_Tech wrote: > I don't have anything against those characters, > but may I suggest VT (vertical tab, Char(11)) which displays at \v in > the debugger. > > when you export the values tab-delimited, > vertical

Re: v13 - Record to Blob?

I thought about that... just wondering if there was something native I missed. again, Thanks On Mon, 30 Jul 2018 19:40:49 +, Keisuke Miyako via 4D_Tech wrote: > if you must use native commands only, then > >

Re: v13 - Record to Blob?

if you must use native commands only, then http://doc.4d.com/4D-Language-Reference-17/Communications/SEND-RECORD.301-3729974.en.html http://doc.4d.com/4D-Language-Reference-17/BLOB/DOCUMENT-TO-BLOB.301-3730325.en.html 2018/07/31 3:48、Chip Scheide via 4D_Tech

Re: v13+ Unicode characters 1-7

I don't have anything against those characters, but may I suggest VT (vertical tab, Char(11)) which displays at \v in the debugger. when you export the values tab-delimited, vertical tabs fits all values in the same cell (multi-line). not sure about Excel, but at least it should be that way

Re: v13 - Record to Blob?

I don't recall a Record to BLOB command in 4D. Both API Pack and ObjectTools have that command, though. -- Douglas von Roeder 949-336-2902 On Mon, Jul 30, 2018 at 11:49 AM Chip Scheide via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I do not see a command that allows this action (directly) > am I

v13 - Record to Blob?

I do not see a command that allows this action (directly) am I missing something, or do I need to write something? Thanks Chip --- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ** 4D

Re: Orphaned blobs and SSD drives

Scott Wirth: > Is there a chance that you once had a blob field that was later converted to > another type? If my understanding is correct this can lead to orphan blobs > when the data in that converted field is changed, particularly if the blob > was stored outside the datafile. I read

RE: ORDA question: how do I add related fields to an entity selection?

Hi Julio, You need to name your relations, which then shows up as an entity in your collection, containing the related data. Assuming a table named A and a relation to table B named My_B_Link, after loading a selection of table A into collection My_Col, you can get your related data from

Re: First ORDA runtime error - just like SQL

Did you mean =:or:=in the following line: ("ItemID=:1";$tItemID) Roger T. Reed > On Jul 27, 2018, at 3:41 PM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Jeff, > You know - something wrong. ;-/ > > Maybe a control char? Chars outside of regular ascii? If it's

Re: Orphaned blobs and SSD drives

Bernd, We too have gotten the "Orphaned Blob" error for several years now. I even dedicated some time a few years ago to ask about this at a 4D Kitchen session at the summit. A compact or repair will clean this up at least temporarily. Is there a chance that you once had a blob field that was

ORDA question: how do I add related fields to an entity selection?

Let’s say I have 2 tables in my database, MANY and ONE, where MANY has a many to one relation to ONE. Using a MANY based SELECTION TO ARRAY I can populate arrays with fields from the MANY table, of course, but I can also include fields from the ONE table. If automatic relations is set to true

Re: Confused about ORDA

Thanks Lahav, This does put it more into perspective. I actually was trying to find out which way to go to optimize the speed as much as possible. And although a difference of 150 ms does sound ridiculous, I assume that with more data, and used repetitively in loops, it will be a substantial

Re: selected rows for a collection listbox

I can elaborate on this a little bit - I've been working with collection based list boxes quite a bit recently. A good starting point is the blog : https://blog.4d.com/multilevel-collection-in-different-listboxes/ https://blog.4d.com/display-a-collection-in-a-listbox/ and Laurant's demo from the

Re: v17 PDF-Manuals

I’d like to see 4D PDF Documentation in the format used for v11’s Upgrade manual. Here’s a link to: 4D v11 SQL Upgrade http://download.4d.com/Documents/Products_Documentation/LastVersions/Line_11/VIntl/PDF_Format/4D_v11_Upgrade.pdf I suggest looking at the PDF in a PDF reader — **not** a web

Re: Orphaned blobs and SSD drives

Bernd, We’ve had this problem with 2 tables in a large DB for years... since 2011. We don’t have anything stored outside the data file. We’ve never been able to identify any data loss. I’ve posted here a few times in the past about this. No solutions so far. Paul Lovejoy > On 30 Jul 2018,

Re: Orphaned blobs and SSD drives

Keisuke Miyako: > to be clear, > > "BLOB" in this context means object, text, picture or BLOB field (anything > that can be saved outside the record). Ah, OK. > the table doesn't have any of those 4 types? It does have textfields but those are all set to be stored in the record (just

Re: Tabbed design windows are the best

Yeah - it's nice to tear off a group of windows that are related, like having a group of tabs in one window open for credit card processing and another group open for invoicing. It would be cool if you could right-click on a group in the Home tab of the Explorer and select something like 'Open

Re: selected rows for a collection listbox

Thanks was not aware, but gathered from the continuing discussion Chip On Mon, 30 Jul 2018 13:45:35 +, Keisuke Miyako via 4D_Tech wrote: > Hi, > > v17 introduced a new (4th) kind of list box. > > the coding style is quite radical compared to conventional list boxes, > based on heavy usage

Re: v17 PDF-Manuals

I like having the PDF manuals. I do not often use them, but when I need them they are indispensable For v2003 -> v15 I have been using Help viewer (mac) to present the html docs. What I find with this approach is that the internal links are fine, and top level index (table of contents) are

Re: selected rows for a collection listbox

Chip, In v17 you can associate a listbox with a collection or object in addition to the data sources we're accustomed to: arrays, current selection or named selection. John and Miyako are talking about about one of these new ones. On Mon, Jul 30, 2018 at 6:34 AM Chip Scheide via 4D_Tech <

Re: Tabbed design windows are the best

someone (below/previously) suggested that you can 'tear off' a tab to start a new window Chip On Mon, 30 Jul 2018 07:38:51 -0600, Jody Bevan via 4D_Tech wrote: > I will have to read the upgrade notes again to see how to do that > Chip. Having 5-10 different tabbed windows would work well I

Re: selected rows for a collection listbox

Hi, v17 introduced a new (4th) kind of list box. the coding style is quite radical compared to conventional list boxes, based on heavy usage of "This", "Form", and member functions. 2018/07/30 22:34、Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> のメール： what do you

Re: Tabbed design windows are the best

I will have to read the upgrade notes again to see how to do that Chip. Having 5-10 different tabbed windows would work well I think. Jody > On Jul 30, 2018, at 7:36 AM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Ive not used it - > but > > based on current work style..

Re: Tabbed design windows are the best

Ive not used it - but based on current work style.. - I can see where it could be useful to keep related methods in the same window pane - I can see how I would HATE it as I at time have 50+ windows open which would be useless in a single tabbed window. I expect I'll use an amalgam of the

Re: selected rows for a collection listbox

John, what do you mean by a 'collection' listbox? if the listbox is from a selection then the highlighted record(s) are in the set specified by: highlight set property and the selected row(s) should be the select record number(s) if the listbox is an array then the selected item(s) are True

V17 client crash on open

I’ve just updated our company’s 4D-based ERP app from v15.5 to v17.0. Compiled server app (macOS) and mix of Windows and macOS clients. All works well except for one macOS client. No matter what I do 4D crashes trying to open. Crash log: Process: 4D [1985] Path:

Re: Orphaned blobs and SSD drives

to be clear, "BLOB" in this context means object, text, picture or BLOB field (anything that can be saved outside the record). the table doesn't have any of those 4 types? 2018/07/30 15:57、Bernd Fröhlich via 4D_Tech <4d_tech@lists.4d.com>のメール: Funny thing is: that

Re: v17 PDF-Manuals

Thanks for the offer Jorg, I have been working with acrobat since v1 so know it well. Even managed to get product as a case study on the adobe V4 install cd ! Its so easy to do thats why I cant understand why 4D havent resolved this. I also agree about the blog. Its useful but it has fragmented

Re: Orphaned blobs and SSD drives

Tim Nevels: > Orphaned blobs are not serious. They are due to a bug in 4D. It’s not really > corruption. It’s just some blobs — the ones attached to blob fields that you > have set to store the blob outside the record but in the data file — are > hanging around in the data file and they are