Re: Converting _O_PLATFORM PROPERTIES to Get system info

2018-12-11 Thread Chip Scheide via 4D_Tech
depending on what property you are looking for, I have found the simplest way to manage which platform (Windows/Mac) is to use the 4D Konstant 'Folder separator': if (Folder separator = ":") //this is a Mac do_Mac_Stuff else //this is Windows do_Windows_stuff end if Depending on your

Re: Form Scaling & Optimal Fonts...

2018-12-07 Thread Chip Scheide via 4D_Tech
to me - form scaling means: I hit a key (press a button, whatever) and the form enlarges - think of Command/Control + on a web page. think of the designer form control 50% 100% 200% 400% I have implemented this in v13 by using Object Set Font Size(+/-1) on everything on the form (list forms

Re: Formula as Variable

2018-12-07 Thread Chip Scheide via 4D_Tech
vtFormula:="([ItemDiscounts]BasePrice*(1-([ItemDiscounts]PerCentDiscount*0.01)))" my_sort(->[ItemDiscounts];vtFormula;">") `My_sort c_pointer($1;$Table) c_text($2,$Formula;$Table_Name;$Direction;$3) $Table:=$1 $Formula:=$2 $Direction:=$3 $Table_Name:=table name($Table) $Formula:="Order by

Re: CONVERT PICTURE not seeming to work for me...

2018-12-07 Thread Chip Scheide via 4D_Tech
Where do you find this font? I can't seem to find it listed in my system fonts :) On Thu, 6 Dec 2018 20:26:06 -0500, Charles Miller via 4D_Tech wrote: > font of great info --- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing

Re: Form Scaling & Optimal Fonts...

2018-12-07 Thread Chip Scheide via 4D_Tech
I have a followup question: if you can not apply a color to the style sheet then that would mean manually (programmatically) applying a color to every object on a form every time the form is displayed. -- A PITA to be sure. BUT.. once a color is applied via code (Object Set Color, or Object Set

v13 - Odd behavior

2018-11-30 Thread Chip Scheide via 4D_Tech
I was testing some code. The method presents the user with a confirmation dialog, and returns value as the user response. I copied my intended message, and the method call for the confirmation into a testing method (so I can run just the message). $msg:="blah blahl Blah"

RE: Windows Server Hardware Recommendations for 4DServer v17 Application

2018-11-30 Thread Chip Scheide via 4D_Tech
Always... more is better faster is better :) On Fri, 30 Nov 2018 17:29:42 +, Neal Schaefer via 4D_Tech wrote: > Thanks Chuck! Good point on the Pro versions of SSDs. Our data file > is 32GB, and 14GB index file (about 1080 indexed fields). Would love > your thoughts on appropriate RAM

RE: [off-ish] Regex help

2018-11-29 Thread Chip Scheide via 4D_Tech
ps://regexr.com/440ee > > This is a nice tool which provides explanations for your regex too. > > Regards Lutz > > >> -Original Message- >> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Chip >> Scheide via >> 4D_Tech >>

Re: v13 - Exporting tab delimited

2018-11-28 Thread Chip Scheide via 4D_Tech
I did get a copy, and opened it. - Thanks I pulled some of the regex from it. hence the questions earlier about why the results from the regex. BTW - my impression on the CSV export is that it would work for a simple one table export, but that a complex export (like an invoice) would not really

Re: [off-ish] Regex help

2018-11-28 Thread Chip Scheide via 4D_Tech
Peter Thanks for that explanation! On Wed, 28 Nov 2018 20:27:40 +0100, Peter Bozek wrote: > On Wed, Nov 28, 2018 at 7:30 PM Chip Scheide via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > >> Thanks Kirk, >> >> According to Wiki : >> . - matches any sin

Re: [off-ish] Regex help

2018-11-28 Thread Chip Scheide via 4D_Tech
ing($text;$aPos{1};$aLen{1}) > > $start:=$aPos{0}+$aLen{0} // move up to the next match > > End while > > > On Wed, Nov 28, 2018 at 9:51 AM Chip Scheide via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > >> can anyone who has a clue help me?

[off-ish] Regex help

2018-11-28 Thread Chip Scheide via 4D_Tech
can anyone who has a clue help me? I am looking at some code: Match regex($folderPathMotif;$File_Path;1;$path_pos;$path_len) where: ARRAY LONGINT($path_pos;0) ARRAY LONGINT($path_len;0) $folderPathMotif:="(.*:)" and File_Path is, well.., a file path on a Mac (so folder separator is ":") When

Re: v13 - Exporting tab delimited

2018-11-28 Thread Chip Scheide via 4D_Tech
Keisuke, a text file is being created (tab delimited, or CSV) as the exact use case for the export may vary by user. Some may/will want to open in excel, others may want to use the data in other programs. A text file is basic, can (in principle) be opened by anything. (not) XML for 3 reasons

RE: v13 - Exporting tab delimited

2018-11-28 Thread Chip Scheide via 4D_Tech
colon ";" instead > of a tab. So you can use double click to open it (again on Windows). > > Regards > Lutz > >> -Original Message- >> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of >> Chip Scheide via >> 4D_Tech >

Re: v13 - Exporting tab delimited

2018-11-28 Thread Chip Scheide via 4D_Tech
you type Alt-Return (on Windows) >>> or Control-Option-Return (on MacOS). >>> >>> I don't remember what the Character Code is for that character, but >>> that's what you'll need to include in your extract script. I seem to >>> recall that it is a ne

Re: v13 - Exporting tab delimited

2018-11-27 Thread Chip Scheide via 4D_Tech
> recall that it is a newline. Google should be able to help you. > > Hope this helps, and sorry it doesn't have more details. > > Tom Benedict > Optum > >> On November 27, 2018 at 2:07 PM Chip Scheide via 4D_Tech >> <4d_tech@lists.4d.com> wrote: >> &

v13 - Exporting tab delimited

2018-11-27 Thread Chip Scheide via 4D_Tech
I would like to be able to embed a return and/or line feed into column in a tab delimited file (opening with Excel). ex: data data text data with return more data data Excel will give me: Col1Col2Col3 DataDatatext data with more data data I can not

Re: Create text object

2018-11-27 Thread Chip Scheide via 4D_Tech
well... not exactly programatically - it does require a creating an object (or duplicating an existing one). - You can place a text object anywhere on the form (I am assuming you mean a static text object, like a field/variable label). - Name to object. - set the property 'invisible by

Re: Explorer bottom toolbar not displaying...

2018-11-22 Thread Chip Scheide via 4D_Tech
Tim, listbox columns etc are saved -- does this include list boxes that are dynamically built? i.e. are simply empty place holders in the designer environment? Chip > On Nov 21, 2018, at 7:48 PM, John DeSoi wrote: > >> I'm happy there is a simpler work-around than finding some obscure >>

Re: Explorer bottom toolbar not displaying...

2018-11-22 Thread Chip Scheide via 4D_Tech
I got 2 new monitors at work, moved from 22" -> 24" Now... windows that were previously (or never) opened on the 22" monitor now opens so that 1/2 is on one screen and 1/2 on the other... Chip > I'm happy there is a simpler work-around than finding some obscure > file to delete. But it

Re: Audit File Updates via Triggers...

2018-11-20 Thread Chip Scheide via 4D_Tech
Kirk, since I don't have objects yet... Trigger actions - 1 method tracking actions (including created and modified) - 4 methods On Tue, 20 Nov 2018 12:48:01 -0800, Kirk Brooks via 4D_Tech wrote: > Robert, > My thoughts on the created by/modified by stuff: > > 1) I moved all this to a single

Re: Audit File Updates via Triggers...

2018-11-20 Thread Chip Scheide via 4D_Tech
I use 2 fields (nearly) every table, some linking (many to many) tables do not have this. [Table]Created_Who [text] [Table]Modifed_Who [text] both fields track the same info Current User, Date, time (in that order and that format) This info is updated, most often by a trigger, using the

Re: Redrawing List Subform...

2018-11-20 Thread Chip Scheide via 4D_Tech
a listbox (selection) has to have it's content updated to show a change in display. Use set, use named selection, query <[table]>. if you: - delete a record from the list - but do not remove it from the current selection (which seems to force the redraw) the listbox still shows the deleted

Re: Selection-based Listbox Deletions...

2018-11-20 Thread Chip Scheide via 4D_Tech
the old sub records are no longer sub records. make the button no action Confirm with the user use set() delete selection([table]) repopulate the listbox if you are using a set to track the originally displayed records (I do this), difference the selected set from the tracking set use original

Re: v13 - how to manage not enough stack space error

2018-11-16 Thread Chip Scheide via 4D_Tech
Thanks I actually have this in place due to the fact that the initial call is for one parent (i.e maternal or paternal lineage), and subsequent (recursive) calls are for both parents; however I am reluctant to use the level limit as I do not know what a 'real' limit is. With a breeding

Re: v13 - how to manage not enough stack space error

2018-11-15 Thread Chip Scheide via 4D_Tech
ack memory and meory data. Call it before > exit get memory stats. You housl now have a ballpark of how much emory each > call takes. You can then perhaps use a counter. > > Regards > > Chuck > > On Thu, Nov 15, 2018 at 11:20 AM Chip Scheide via 4D_Tech < > 4d_te

[off] no matter how bad the code you have/wrote/work on....

2018-11-15 Thread Chip Scheide via 4D_Tech
it can not be this bad https://news.ycombinator.com/item?id=18442941 Chip --- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ** 4D Internet Users Group (4D iNUG) Archive:

v13 - how to manage not enough stack space error

2018-11-15 Thread Chip Scheide via 4D_Tech
I have a recursive routine (genology) The routine is fine and works as expected - as long as the data is valid. I was working in my test data, which I have apparently F*&^%ed and the routine recurses until I get a stack error and 4D crashes (stand alone). How can I manage this so that I can

Re: Placing a picture or graphic object

2018-11-12 Thread Chip Scheide via 4D_Tech
Peter, here is code I use for moving things. it simplifies the whole process for me. I no longer have to remember exact syntax etc. Note you can use a pointer to a n active object (button, variable etc), or pass Nil as $1 and the object name in $4 for static objects (text, etc) //Project

Re: Listbox multiple select

2018-11-09 Thread Chip Scheide via 4D_Tech
never tried to implement this... you would probably have to : use On Mouse down, and on mouse up, to get the coords of the dragged over area. then estimate/calculate how many lines were to be selected based on row height. Then use the listbox command to highlight those rows. I might note that

Re: Semaphores and Server-Side Data Updates in Multi-User Environment

2018-11-09 Thread Chip Scheide via 4D_Tech
my outline for this would be as follows. I am not up to v16 yet, so this will be a 'classic' solution, use of call worker might simplify this. write a deamon (a process which spends most of it's life asleep), is started at server startup. Deamon : repeat loop examine IP array, or

Re: Forms Stop Receiving Certain Events

2018-11-09 Thread Chip Scheide via 4D_Tech
the configuration is pretty simple. Open the database, go to: Database settings : Backup : Configure turn on the check box(es) you want to be backed up and add any additional file(s) you want set your destination, and schedule. the .4BK file obtains whatever is supposed to be backed up. The 4BL

Re: Forms Stop Receiving Certain Events

2018-11-09 Thread Chip Scheide via 4D_Tech
Krik, I just checked, and On Clicked and buttons does work regardless of form event, but I think this depends on the event. I know some events, like On Timer, On Before/after Keystroke will not work if the form event is not checked at the form level. Chip On Fri, 9 Nov 2018 06:57:15 -0800,

Re: Forms Stop Receiving Certain Events

2018-11-09 Thread Chip Scheide via 4D_Tech
depending on what your form method looks like, it does not hurt (much) to simply turn everything on. Chip On Fri, 9 Nov 2018 09:24:16 -0500, Sandor Szatmari via 4D_Tech wrote: > OK, so it looks like there's some strange bug I ran into. For some > reason most of the events for my forms got

Re: Listbox multiple select

2018-11-09 Thread Chip Scheide via 4D_Tech
Click on one line/row. Then (platform dependent) - Shift click on the end of the selection you desire for a contiguous selection - Command (Mac), or Control (windows) click on discontiguous rows. Note: Option/Alt click on a previously selected row and drag to move/drag multiple rows from a

Re: Forms Stop Receiving Certain Events

2018-11-09 Thread Chip Scheide via 4D_Tech
this is not correct. The structure (.4DB) is a separate entity from the data (.4DD) Other then having added tables and/or fields, rolling back the structure to a previous one (say yesterday) is simple and is not a significant issue. If you have added fields and/or tables then there can be

Re: Reindex

2018-11-06 Thread Chip Scheide via 4D_Tech
you probably need to grab not just the 4DD but ale the index files too On Tue, 6 Nov 2018 16:07:15 +0100, stardata.info via 4D_Tech wrote: > hi all, > sometimes I need to take data files from one application running on > some my customer without close the application. > I notice that when I

Re: Sorting an array of email addresses

2018-11-06 Thread Chip Scheide via 4D_Tech
there is a setting to use or ignore the "@" as a wildcard I am not sure if it can be turned off/on dynamically CHip On Tue, 6 Nov 2018 10:17:13 +, David Samson via 4D_Tech wrote: > Would this be reliable since they all contain the "@" sign? You might have " > i...@abc.com" and "i...@def.com".

Re: v13 - Why can a record NOT be Pushed?

2018-11-05 Thread Chip Scheide via 4D_Tech
t boxes to populate the various containers. As well as printing the contents of the containers, at every level. I was having issues after printing, then switching to a different page/listbox. all of the above is probably TMI - but there it is :) Thanks again > On Mon, Nov 5, 2018 at 1:46 PM Ch

v13 - Why can a record NOT be Pushed?

2018-11-05 Thread Chip Scheide via 4D_Tech
I am getting this error, and i can not figure out why. Thanks Chip --- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ** 4D Internet Users Group (4D iNUG) Archive:

v13 (+?) - is there a way to "see" the stack?

2018-11-05 Thread Chip Scheide via 4D_Tech
Is there some way to determine if, and what record(s) are on the stack for either the database, or (better) a single table? something like the following, whatever is required to do **Records on stack**: Push ([table]) do stuff Push ([table]) do more stuff for($i;1;**Records on

Re: v13 - UUID COLLISION!!! [observation]

2018-10-29 Thread Chip Scheide via 4D_Tech
Billion) ticket :p Chip On Mon, 29 Oct 2018 14:53:29 -0400, Chip Scheide via 4D_Tech wrote: > UUID value ="E092AB501E1D41F5A5D15B56E835D2EE" > this value appears to be duplicated in my database! > > ideas? thoughts? > Chip > --- > Gas is for washing

RE: v13 - UUID COLLISION!!!

2018-10-29 Thread Chip Scheide via 4D_Tech
90 > > E-Mail: s.o...@the-aquila-group.com > * > > > -Original Message- > From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Chip > Scheide via 4D_Tech > Sent: Monday, October 29, 2018 1:53 PM > To:

v13 - UUID COLLISION!!!

2018-10-29 Thread Chip Scheide via 4D_Tech
UUID value ="E092AB501E1D41F5A5D15B56E835D2EE" this value appears to be duplicated in my database! ideas? thoughts? Chip --- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ** 4D Internet

Re: Longing IDs or UUIDs as primary key?

2018-10-24 Thread Chip Scheide via 4D_Tech
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: v13 - Why does this query not work? [resolved]

2018-10-24 Thread Chip Scheide via 4D_Tech
e_Link]Bench_Protocol_ID) > RELATE ONE SELECTION( [BnchProt_File_Link];[Bench_Protocols] ) > > John > > > John Baughman > Kailua, Hawaii > (808) 262-0328 > john...@hawaii.rr.com <mailto:john...@hawaii.rr.com> > > >> On Oct 24, 2018, at 7:32 A

Re: v13 - Why does this query not work?

2018-10-24 Thread Chip Scheide via 4D_Tech
ery plan(Description in text > format) > > > $path_T:="Query Path"+Char(13)+Get last query path(Description in text > format) > > > SET TEXT TO PASTEBOARD($plan_T+Char(13)+Char(13)+$path_T) > > > HTH. > -- > Douglas von Roeder > 949-336-29

v13 - Why does this query not work?

2018-10-24 Thread Chip Scheide via 4D_Tech
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: Longing IDs or UUIDs as primary key?

2018-10-24 Thread Chip Scheide via 4D_Tech
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?

2018-10-24 Thread Chip Scheide via 4D_Tech
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?

2018-10-24 Thread Chip Scheide via 4D_Tech
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?

2018-10-24 Thread Chip Scheide via 4D_Tech
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: ORDA Entity From

2018-10-23 Thread Chip Scheide via 4D_Tech
can you wrap the call to create the entity, tracking the detail(s) you want to track as you create the entity? On Tue, 23 Oct 2018 13:49:07 -0700, Douglas von Roeder via 4D_Tech wrote: > Neil: > > I asked, essentially, the same question yesterday and got no response. > > Given that ORDA is a

Re: Shared Object - NOT!

2018-10-21 Thread Chip Scheide via 4D_Tech
Not to mention how much old/legacy code would likely break > > the language might be more consistent if 4D got rid of all native > scalar types and treating everything as an object, > but there is a performance advantage (memory footprint and speed) in > having scalar native types.

Re: Scope of entity selection

2018-10-18 Thread Chip Scheide via 4D_Tech
Christian, I *think* that the intent was to pass an ordered collection from process to process. i.e. - process 1 order the data in whatever manner is desired. - pass the collection from process 1 to process 2 - process 2 receive the ordered collection and do stuff with it, in the order in which

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

2018-10-17 Thread Chip Scheide via 4D_Tech
At some point, v18(?), 4D will completely drop support for subtables. as I understand: a simple conversion to the current version will allow all the functions of existing subtables to continue working -- without -- any change to code. As noted by Tim Penner, but typo-ed :), this applies to a

[off] Holy Geez! Boston Dynamics - Spot

2018-10-16 Thread Chip Scheide via 4D_Tech
~15 min video https://www.youtube.com/watch?v=AO4In7d6X-c Chip --- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ** 4D Internet Users Group (4D iNUG) Archive:

Re: v13 - Why would a query fail to change current reocrd?

2018-10-16 Thread Chip Scheide via 4D_Tech
, Pat Bensky via 4D_Tech wrote: > Chip, > You haven't got a SET QUERY DESTINATION somewhere have you? > Pat > > On Mon, 15 Oct 2018 at 23:24, Chip Scheide via 4D_Tech > <4d_tech@lists.4d.com> > wrote: > >> Background >> - I use 2 tables to manage li

RE: how do I turn it into a component or a database

2018-10-16 Thread Chip Scheide via 4D_Tech
I just DLed the two github libraries they are BOTH from v17r3 so the versioning/feature set maybe important On Tue, 16 Oct 2018 09:30:54 +, Epperlein, Lutz (agendo) via 4D_Tech wrote: > @Pat: No, this is the wrong approach. Did you looked at the github > repositories? > The sources are

v13 - Why would a query fail to change current reocrd?

2018-10-15 Thread Chip Scheide via 4D_Tech
Background - I use 2 tables to manage listboxes. - I am on an entry form, which includes a selection listbox. - I am trying to display, in a dialog (Mac so a type 34 sheet window), a different listbox (array) to allow the user to make a selection. before the below code executes, the current

Re: Resetting the table sequence number

2018-10-15 Thread Chip Scheide via 4D_Tech
2 things: 1 - why not all records order by([table];[table]ID_Field;<) $New_Sequence_Value:=[table]ID_Field+1 then you are sure to exceed the last assigned value. 2 - try assigning **Table*($iTableNumber)* to a local variable, and then dereference, sometime 4D does not like to dereference

Re: v13 - Change Button Shortcut

2018-10-15 Thread Chip Scheide via 4D_Tech
Thanks! > >> 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 (c

v13 - Change Button Shortcut

2018-10-12 Thread Chip Scheide via 4D_Tech
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 buttons... I just found this. I would prefer NOT to have to manually go through every entry and listing

Re: Defining and documenting Objects

2018-10-12 Thread Chip Scheide via 4D_Tech
David, Any chance you might make this system available to the rest of us poor and unworthy? as a component? for a fee? Chip On Fri, 12 Oct 2018 15:35:03 +1100, David Adams via 4D_Tech wrote: > > Anyway, with all of that stuff in place, you then can build your own type > declaration and

Re: Defining and documenting Objects

2018-10-12 Thread Chip Scheide via 4D_Tech
I recently went through my code and removed IP vars, to future proof my code for pre-emptive possibilities. I went from >500, including sets, to 1 which is a set. Have not done Process vars, still in v13 so Chip On Thu, 11 Oct 2018 18:09:23 -0600, Jody Bevan via 4D_Tech wrote: > > Our

Re: What causes a record to be Locked but Locked By has no info?

2018-10-11 Thread Chip Scheide via 4D_Tech
if the record is new - other processes can not see it. if the record existed before the transaction, then it should show what process/user/etc has hold of it. beginning (I think) in v13 - if the table is read only, a selected record shows as locked. Chip On Thu, 11 Oct 2018 14:17:45 -0400,

Re: What causes a record to be Locked but Locked By has no info?

2018-10-11 Thread Chip Scheide via 4D_Tech
Read only On Thu, 11 Oct 2018 10:48:12 -0700, Kirk Brooks via 4D_Tech wrote: > I have a method that tests if a record is locked and if it is attempts to > figure out by whom: > > $text:="["+Table name($1)+"] " > > LOCKED BY($1->;$process;$4Duser;$machineName;$p_Name) > PROCESS >

Re: List Box Font Color Expression, how?

2018-10-11 Thread Chip Scheide via 4D_Tech
John, the property fires during On display detail (v13) in the listbox property: Row Font Color enter a method which executes your conditional(s) and returns an RGB color value (longint) Chip On Wed, 10 Oct 2018 15:43:49 -1000, JOHN BAUGHMAN via 4D_Tech wrote: > In a Selection based list box

Re: Pictures Outside Datafile - Calculate Path

2018-10-10 Thread Chip Scheide via 4D_Tech
any incremental backup software will note when the files were last backed up and skip those that have not changed since the last backup as to the deleted record issue, if deletions are allowed, the process of deleting a record which is (or possibly is) associated with an external file (picture

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

2018-10-09 Thread Chip Scheide via 4D_Tech
I believe that Get 4D Folder works for this sort of thing I would think either: 4D folder, or Log folder Chip On Tue, 9 Oct 2018 09:50:48 -0600, Jody Bevan via 4D_Tech wrote: > In my previous 26+ years of 4D coding I did not have to concern > myself with the same computer being used by

Re: Notes on converting pictures to v17

2018-10-08 Thread Chip Scheide via 4D_Tech
email contacts to supp...@printpoint.com > <mailto:supp...@printpoint.com> > > > > >> On Oct 8, 2018, at 11:19 AM, Chip Scheide via 4D_Tech >> <4d_tech@lists.4d.com> wrote: >> >> I have done this, although in v13. I found that all my images now

Re: Notes on converting pictures to v17

2018-10-08 Thread Chip Scheide via 4D_Tech
I have done this, although in v13. I found that all my images now have white backgrounds any way to fix this without manually editing every single one?? On Mon, 8 Oct 2018 08:12:44 -0700, Kirk Brooks via 4D_Tech wrote: > I'm preparing to move a large, established project from v15 to v17 and >

Re: Defining and documenting Objects

2018-10-04 Thread Chip Scheide via 4D_Tech
I do not use objects - not up to a version of 4D that supports them, yet. My thought on handling documentation of an object's contents... this is probably worth what you are paying for it... :) 1 - In every system, or component install a comment only method outlining your conventions. This

Re: v13 - Relate One Selection issue

2018-10-03 Thread Chip Scheide via 4D_Tech
s von Roeder > 949-336-2902 > > > On Wed, Oct 3, 2018 at 5:57 AM Arnaud de Montard via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > >> >>> Le 2 oct. 2018 à 20:10, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> >> a écrit : >>>

Re: v13 - Relate One Selection issue

2018-10-02 Thread Chip Scheide via 4D_Tech
Thanks Tim, it appears to have been one or more damaged indices Cihp On Tue, 02 Oct 2018 16:00:36 -0500, Tim Nevels via 4D_Tech wrote: > On Oct 2, 2018, at 2:00 PM, Chip Scheide wrote: > >> given this table configuration >> >> Animal <-- Animal_Sample_Link ---> Samples >> >> if

v13 - Relate One Selection issue

2018-10-02 Thread Chip Scheide via 4D_Tech
given this table configuration Animal <-- Animal_Sample_Link ---> Samples if there is at least 1 [Sample_Animal_Link] record shouldn't the following code load the animal record(s)? QUERY([Sample_Animal_Link];[Sample_Animal_Link]Sample_ID=[Samples]Sample_ID) RELATE ONE

Re: Finally v17 PDF-Manuals

2018-09-28 Thread Chip Scheide via 4D_Tech
link? > Thank you 4D > ** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com >

Re: v13-v16 thread safe component

2018-09-20 Thread Chip Scheide via 4D_Tech
Thanks On Thu, 20 Sep 2018 13:25:55 -0500, John DeSoi via 4D_Tech wrote: > >> On Sep 20, 2018, at 11:40 AM, Chip Scheide >> <4d_o...@pghrepository.org> wrote: >> >> I have been looking through the v16 and v17 documentation, I do not see >> where it says that pasteboard commands do not work

Re: v13-v16 thread safe component

2018-09-20 Thread Chip Scheide via 4D_Tech
. I would assume, may be the problem :), that since an IP set can be changed from outside the preemptive thread that it would be a problem, just like an IP variable. Chip On Thu, 20 Sep 2018 10:22:51 -0500, John DeSoi via 4D_Tech wrote: > Chip, > >> On Sep 20, 2018, at 9:24 AM, Chip

v13-v16 thread safe component

2018-09-20 Thread Chip Scheide via 4D_Tech
this is Long, I am sorry, TL;DR how can you make code thread safe when it maybe necessary under some conditions (which would themselves be not thread safe) to reach into a separate process to get or set values. (I need a means to manage IP sets which is thread safe, OR I need a way to Set and

[Tip/Gotcha] - Pasteboards

2018-09-19 Thread Chip Scheide via 4D_Tech
There are 2 pasteboards - the docs mention this... There is the pasteboard = clipboard -- accessible all time EXCEPT during drag n drop There is the pasteboard # clipboard -- accessible ONLY during drag n drop The 2 do not cross. If you put something on the pasteboard during form events: On

v13 - Pasteboard size

2018-09-19 Thread Chip Scheide via 4D_Tech
I am getting the following result: Pasteboard data size($Transfer_Sig) = -102 $Transfer_Sig = "com.4d.private.Data.Transfer" I am trying to transfer data from 1 process to another using the pasteboard. I use semaphores to protect writing and reading from the pasteboard Source process: I use a

Re: Debugger - catch whenever a variable changes

2018-09-18 Thread Chip Scheide via 4D_Tech
lol -- I had to look at the post date myself, I was thinking "...when did I post that?!?!?" what I have taken to doing is using the runtime explorer in the 'Catch' tab (stop sign) and setting a formula in there (evaluation to TRUE stops execution) I *WISH* that you could copy/paste into the

Re: v13 - SQL alter table, what is wrong?

2018-09-18 Thread Chip Scheide via 4D_Tech
> > On Mon, Sep 17, 2018 at 6:46 PM Chip Scheide via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > >> Chuck, >> Thanks but... >> >> http://livedoc.4d.com/4D-SQL-Reference-14/Syntax-rules/primary-key-definition.300-1198391.en.html >> >> Sa

Re: v13 - SQL alter table, what is wrong?

2018-09-17 Thread Chip Scheide via 4D_Tech
gt; disclosure, printing, copying, storage, modification or the taking of > any action in reliance upon this transmission is strictly > prohibited. Delivery of this message to any person other than the > intended recipient shall not compromise or waive such > confidentiality, privilege

Re: v13 - SQL alter table, what is wrong?

2018-09-17 Thread Chip Scheide via 4D_Tech
Mon, Sep 17, 2018 at 3:49 PM Chip Scheide via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > >> trying to set a new field in a new table as primary key >> >> $SQl_Command:="ALTER TABLE [Anmlprot_File_Link] ADD PRIMARY KEY >> (Journal_Key)" >> >

v13 - SQL alter table, what is wrong?

2018-09-17 Thread Chip Scheide via 4D_Tech
trying to set a new field in a new table as primary key $SQl_Command:="ALTER TABLE [Anmlprot_File_Link] ADD PRIMARY KEY (Journal_Key)" Begin SQL Execute Immediate : $Sql_Command end SQL table : [Anmlprot_File_Link] exists Field : Journal_Key exists as a field in [Anmlprot_File_Link]

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

2018-09-17 Thread Chip Scheide via 4D_Tech
David, (not on v17) I've played around with large text, mostly for testing purposes. large texts (>150meg) - very easily cause massive slow downs when trying to append - can easily crash/hang 4D. While the *limit* on text maybe 2gig (+/-) my experience is that you can not get anywhere near that

RE: v13(+?) - Components and host processes

2018-09-14 Thread Chip Scheide via 4D_Tech
thanks > According to the docs, Processes are in the Unshared category of objects: > http://doc.4d.com/4Dv15/4D/15.6/Interaction-between-components-and-host-databases.300-3836723.en.html#516546 > > What you can do is this; > > 1) create a method in the host database that returns the data you

v13(+?) - Components and host processes

2018-09-14 Thread Chip Scheide via 4D_Tech
can/does a component see the current state of a host process? In a component, I have a line of code in a for (count tasks) loop PROCESS PROPERTIES($i;$Proc_Name;$Proc_State;$Proc_Time) (context of the component) The processes name is correctly returned, but the process state returned is 0

Re: v13+ Opening a structure interpreted

2018-09-13 Thread Chip Scheide via 4D_Tech
t; > Chuck > > Regards > > > > On Thu, Sep 13, 2018 at 1:20 PM Chip Scheide via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > >> I set a database to run compiled, I now want to open it interpretedly. >> I can not load the database because there are uncompiled compon

v13+ Opening a structure interpreted

2018-09-13 Thread Chip Scheide via 4D_Tech
I set a database to run compiled, I now want to open it interpretedly. I can not load the database because there are uncompiled components. Is there a key combination which will allow me to choose the how to open the database (compiled or interpretedly)? Thanks Chip --- Gas is for

Re: 4D Write (v15) Images Slanted

2018-09-12 Thread Chip Scheide via 4D_Tech
just make sure that the jpeg is saved as the least compression possible (in photoshop save as image quality 12) the final image should come out OK On Wed, 12 Sep 2018 22:11:26 +0200, Peter Jakobsson via 4D_Tech wrote: > Hi > > It appears I’ve solved this - it needed to be a JPEG. But I presume

RE: v13 - screen redraw

2018-09-05 Thread Chip Scheide via 4D_Tech
s.4d.com] On Behalf Of Chip > Scheide via 4D_Tech > Sent: Wednesday, September 05, 2018 2:37 PM > To: 4D iNug Technical <4d_tech@lists.4d.com> > Cc: Chip Scheide <4d_o...@pghrepository.org> > Subject: v13 - screen redraw > > I have a small form I am trying to get

Re: v12 - included form (original subform)

2018-09-04 Thread Chip Scheide via 4D_Tech
Thanks! > http://doc.4d.com/4Dv16/4D/16.3/GET-HIGHLIGHTED-RECORDS.301-3652453.en.html > > is the generic equivalent of UserSet > > 2018/09/05 2:56、Chip Scheide via 4D_Tech > <4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>>のメール: > > Records in set(&quo

v12 - included form (original subform)

2018-09-04 Thread Chip Scheide via 4D_Tech
Updating an old application I have a parent form, on which is a subform (included list form) from another table. everything works as expected, except... I can not determine which record(s) the user has selected. if I: - all records (have a list of records) - select 3 records Records in

Re: Re(2): 4D Write Pro WP feature request - need your support

2018-08-30 Thread Chip Scheide via 4D_Tech
login On Wed, 29 Aug 2018 15:49:26 -0700, Don Lapin via 4D_Tech wrote: > I would suggest keeping the pressure on them. They've gone every > which-way about promising 4D Write Pro features. As it has been > delivered, it is unusable. I've the same issue with Word > compatibility. > > When I

RE: 4D Write Pro WP feature request - need your support

2018-08-29 Thread Chip Scheide via 4D_Tech
.doc is probably an issue as it is a proprietary format from MS. .docx might not be such an issue as it is "open" and is supposed to be based on xml. On Wed, 29 Aug 2018 18:22:02 +, Michael McCall via 4D_Tech wrote: > doc export option we will be unable to use it. This is an essential >

Re: Set Environment Variable

2018-08-29 Thread Chip Scheide via 4D_Tech
what I am using YMMV SET ENVIRONMENT VARIABLE("_4D_OPTION_HIDE_CONSOLE";"true") SET ENVIRONMENT VARIABLE("_4D_OPTION_BLOCKING_EXTERNAL_PROCESS";"true") // wait for it to finish On Wed, 29 Aug 2018 10:14:02 -0600, Jody Bevan via 4D_Tech wrote: > I am using the Launch External Process to get

Re: Using local variables and set and named selection names in a recursive situation

2018-08-29 Thread Chip Scheide via 4D_Tech
Pat, I am less familiar with named selections...I am assuming that they operate in a similar manner to sets (see below). With sets: -$setname is a PROCESS set, and is NOT available on server -setname is a process set + is available on server -<>set name is an interprocess set, and (I believe) is

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