Re: Icon & Picture Button Sources...

Here's a simple example inspired by the 4d-component-generate-icon. //- $width:=3 $opacity:=80 $rw:=40 $color:="black" // normal $svg:=SVG_New (58;58) $ref:=SVG_New_rect ($svg;9;9;$rw;$rw;2;2;$color;"white";$width) SVG_SET_OPACITY ($ref;0;$opacity)

RE: Icon & Picture Button Sources...

Robert, No, I am using a program called MicroAngelo to build and edit the images. It's just a matter of copy/pasting the images we want for each state. The program has a "disabled" mode which allows us to make the 4th image appear disabled. It's rather easy and quick. Let me know if you would

Re: Longing IDs or UUIDs as primary key?

Rudy, I did something similar once, partly to see how hard it would be. I would not race into doing it again unless there was some really compelling reason. Assuming there is that compelling reason the process worked something like this: a) go through every table affected and add the UUID field

Re: Longing IDs or UUIDs as primary key?

Here's a possible approach to automating, but it depends last question. If you change a longint to an alpha field, the new new alpha field retains the longint value. You could send the modified Structure with the longint fields changed to alpha. When the Structure sees that a Datafile is not

Re: Longing IDs or UUIDs as primary key?

Rudy For me this always choose UUID for primary key and never use them to link between tables. The overhead from space is not so great Andy I never want to type in uuid to find related records etc Regards Chuck On Wed, Oct 24, 2018 at 10:52 AM Two Way Communications via 4D_Tech <

Re: Longing IDs or UUIDs as primary key?

it is more of a situation of: - Do I **really** want to type a UUID to try to follow/check on related records when something goes pear-shaped? - Do I want my admin(s) to have to type a UUID to try to chase related records? - Do I want to have to work with UUIDs, other then knowing that they

Re: Longing IDs or UUIDs as primary key?

It made no sense to me to abandon my longint primary keys used for relational integrity and uniqueness in a long standing system when 4D would automatically establish and maintain a new UUID primary key for the purposes of replication and sharing right along side my working longint field.

RE: Longing IDs or UUIDs as primary key?

>- Do I **really** want to type a UUID to try to follow/check on related >records when something goes pear-shaped? >- Do I want my admin(s) to have to type a UUID to try to chase related records? >- Do I want to have to work with UUIDs, other then knowing that they exist and >are inplace as

Re: Longing IDs or UUIDs as primary key?

[some emoji that expresses a slight sense of relief, but not necessarily a feeling of being surprised] > On Oct 24, 2018, at 11:01 AM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > No it isn't. > >> On Oct 24, 2018, at 11:59 AM, Keith Culotta via 4D_Tech >>

Re: Longing IDs or UUIDs as primary key?

Hi Chip, Another way to look at this is in terms of separating the logical structure from the data. Using UUIDs compels you to think about the logical structure separately from the contents. That's a good thing. I agree it can be useful to have a unique serial number on some tables. But that

RE: Longing IDs or UUIDs as primary key?

I use UUID for links between tables, I wouldn't ever go back to longint keys. They are faster than sequential keys in a lot of respects (long discussion)... I love them. Neil -- Privacy Disclaimer: This message contains confidential information and is intended only for the named

Longing IDs or UUIDs as primary key?

I have an application with a big database file ( + 60 GB), with 128 tables. (4D v17) All id fields and foreign keys are of type longint. Now, for replication and sharing purposes, I would like to change the type to UID. The process seems quite cumbersome: to start, I need to remove the

Re: Using listbox as output form replacement

Hi Jim, No, this will not work in user mode. To use a listbox in that way (generic), you need to put it in an input form, to start with. You can only use it by programming, using DIALOG. Regards, Rudy Mortier Two Way Communications bvba > On 24 Oct 2018, at 02:13, Jim Crate via 4D_Tech

Re: Using listbox as output form replacement

Hi Jim, I have a couple of thoughts about this. First, for user mode output forms I stick with plain, old 4D output forms. It's really the best. Second, I totally support the direction you're going with using a Dialog and a listbox instead of MODIFY/DISPLAY SELECTION. I would encourage you to try

Re: Icon & Picture Button Sources...

Actually, I prefer to roll my own. I start by googling ‘ icons’, i.e. ‘validate icons’, 'customer icons' …. Then I copy the picture I like into Pixelmator. I put 4 identical pictures in a row, same size. Then I tweak them for the 4 states: normal, hovered over, clicked , and disabled.

Re: Longing IDs or UUIDs as primary key?

RE: never use them to link between tables Is using them to link between tables (establish 4D Relations, correct?) a hazardous practice? Thanks, Keith - CDI > On Oct 24, 2018, at 10:49 AM, Charles Miller via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Rudy > > For me this always choose UUID

Re: Longing IDs or UUIDs as primary key?

To be clearer on the purpose: There are many customers who use my application. What I want to achieve is that they can ’share’ data. In order to do that, I really do need a UUID, because I intend to exchange the records (and related records) between their individual databases. Obviously this

Re: Longing IDs or UUIDs as primary key?

No it isn't. > On Oct 24, 2018, at 11:59 AM, Keith Culotta via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Is using them to link between tables (establish 4D Relations, correct?) a > hazardous practice? ** 4D Internet Users

Re: Longing IDs or UUIDs as primary key?

Kirk, I am not suggesting using SS numbers, or anything the user can change/touch as a linking value. a longint (or other sequential value [text] - like a license plate) generated for each new record for each table which is used explicitly for identifying the record and possibly linking

Re: Longing IDs or UUIDs as primary key?

There are other options which may be more attractive if you are willing to put more work in your synchronization code. I did something like this years ago before UUIDs existed. You need to be able to identify shared records (which can be a UUID field without it being the primary key) and then

v13 - Why does this query not work?

Structure: [Bench_Protocols] <- [BnchProt_File_Link] -> [Attached_Files] QUERY SELECTION BY FORMULA([Bench_Protocols];([BnchProt_File_Link]Bench_Protocol_ID=[Bench_Protocols]Bench_Protocol_ID)) I have tried: QUERY SELECTION

Re: v13 - Why does this query not work?

Doug, Thanks no compatibility setting - so it must already be on. I realized that the auto relations should not come into play - but when things are not working, you try ... well... whatever. :) I know about query execution, but have never really looked into it. I will. On Wed, 24 Oct 2018

Re: Longing IDs or UUIDs as primary key?

Sorry, forgot the UUID properties would still have to be set for the fields after all that. Again, SQL? Name it the "No way, YOU click the 'OK to Update' button" method. > On Oct 24, 2018, at 12:01 PM, Keith Culotta via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Here's a possible approach to

Re: v13 - Why does this query not work?

Chip, I may be wrong but I don’t think you can query a table based on a many table relation. I would… RELATE MANY SELECTION([BnchProt_File_Link]Bench_Protocol_ID) RELATE ONE SELECTION( [BnchProt_File_Link];[Bench_Protocols] ) John John Baughman Kailua, Hawaii (808)

Re: v13 - Why does this query not work?

Chip: Check your settings in Database Settings/Compatability - check the query by formula uses SQL joins and you'll want to Execute QbF on Server, as well. :-) I don't think that Auto relations comes into play. Try creating the join yourself, a la: QUERY BY

Re: v13 - Why does this query not work?

Chip: The compatibility setting is there if the structure is older than V11, I'd assume, because this feature is essentially SQL, which was introduced in V11. Check out the docs for QbF - it says auto relations aren't used "as a rule" but gives a couple of instances when the are used. Thomas

Re: Longing IDs or UUIDs as primary key?

why not: - Add UUID as needed. - populate Using Send/receive record during synchronization repeat for each record to import - read the record to import - verify the UUID of the imported record - if it exists -- do whatever record merging you need - if it does not exist, assign a NEW

RE: Longing IDs or UUIDs as primary key?

I and Admin(s) may need to see/work with the relational key to attempt to determine why/if something is F-ed. off the top of my head scenario: invoice does not show expected line items. -(for me) first step examine raw data to see if the 'missing' line item(s) exist. -- to do this you need to

Re: Longing IDs or UUIDs as primary key?

No it is just painful let’s assume for some reason record in a many table where assigns to wrong main table which would you rather type in to fix 145764 or a 32 character UUID In my opinion the journal aspect should have been hidden by 4D and the UUID field should have been there but hidden

Re: v13 - Why does this query not work? [resolved]

I do not know why... but doing a simple query now works. John, all of the following queries (now) work. : ($Selected_Search="has Inventory") QUERY SELECTION([Bench_Protocols];[Bnchprot_LabInv_Link]Bench_Protocol_ID=[Bench_Protocols]Bench_Protocol_ID) : ($Selected_Search="has Attached

Re: Icon & Picture Button Sources...

Thanks Rudy and Stephen, you’ve given me some things to consider. It’s been a long time since I’ve customized buttons. Back in 1994 I used photoshop to create some custom buttons but it seems it’s been a while. I’ve inherited many different apps over the years and never paid close attention to

Re: Longing IDs or UUIDs as primary key?

how do you do this? > In 4D list boxes, a column can be set up to show an ellipsis in the > middle of a string (instead of the end) when a column is too small. > This is perfect for UUID columns. Just make them wide enough to only > show the first and last 3 characters. Just as easy as a

Re: Longing IDs or UUIDs as primary key?

> On 24 Oct 2018, at 16:52, Two Way Communications via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > The process seems quite cumbersome: to start, I need to remove the ‘primary > key’ flag from all the ID fields Rudy - Just to add to the many useful contributions made so far, I found a way to

Re: Longing IDs or UUIDs as primary key?

I've heard lots of comments over the years talking about how hard it is to work with UUIDs. I’d like to offer a different perspective. I switched to UUIDs from longints for primary keys 7 or 8 years ago. It took some careful programming to migrate the datafiles in place, but it was _so_ worth

Re: Icon & Picture Button Sources...

Stephen, are you photoshopping the other states manually creating the other button versions...? Thanks, Robert Sent from my iPhone > On Oct 23, 2018, at 7:15 PM, Stephen J. Orth > wrote: > > If you want to create a multi-state button, which is what you are describing, > you simply

Re: Icon & Picture Button Sources...

you can also use 4D code to do something similar https://github.com/miyako/4d-component-generate-icon 2018/10/24 16:24、Robert ListMail via 4D_Tech <4d_tech@lists.4d.com>のメール: Stephen, are you photoshopping the other states manually creating the other button