Re: Log integration issue in mirror database

2019-05-19 Thread Keith Culotta via 4D_Tech
I saw error "Cannot find any record with that primary key" when a field marked "unique" had lost its index. After indexing the field the problem went away. Keith - CDI > On May 19, 2019, at 10:47 AM, Charles Miller via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Is there any way you are

Re: v17 64Bit Label Format Numbers

2019-05-17 Thread Keith Culotta via 4D_Tech
label. BEEP worked the same way. It will also print the value for [Table]Object.FirstName when a field has been so edited. However, like the String command, only one label in the selection will print when that appears on the form. Keith - CDI > On May 16, 2019, at 5:44 PM, Keith Culotta via

Re: v17 64Bit Label Format Numbers

2019-05-16 Thread Keith Culotta via 4D_Tech
The good news is that you can enter this into the field on the label: String([Inventory]Sell1;"$###,##0.00"). The bad news is that it seems only one label from the selection will print when that is on the form :( Keith - CDI > On May 16, 2019, at 5:25 PM, Clive Wilson via 4D_Tech

Re: Using the HELP Menu for my own purposes.

2019-04-29 Thread Keith Culotta via 4D_Tech
The exception to the menu being empty for a standard build (with no additional components or plugins) is the SVG Component. It has a help file of its own inside 4D that needs to be removed at some point. Show 4D Contents and navigate to 4D/Contents/Components/4D SVG.4dbase. Show Contents of 4D

Re: Fast way to highlight a listbox entity selection

2019-04-17 Thread Keith Culotta via 4D_Tech
Hi JPR, Fuzziness is a good description, but things stand in sharper relief today. I was more focused on the syntax than the mechanics and for no particular reason started out with collections. Converting the app to an entity selection approach is turning out to be much easier than expected,

Re: Fast way to highlight a listbox entity selection

2019-04-16 Thread Keith Culotta via 4D_Tech
ction > command can be helpful BUT it does move the actual entity data to the > collection. For something like a 40k element entity selection this might > matter. So be sure to stick with your entity selection when it's large. And > in this case the data would be in entitySelectio

Re: Fast way to highlight a listbox entity selection

2019-04-16 Thread Keith Culotta via 4D_Tech
want to do > that (if you don’t have to)?”, comes to mind. :-) > > -- > Douglas von Roeder > 949-336-2902 > > > On Tue, Apr 16, 2019 at 7:22 AM Keith Culotta via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > >> Justin, >> >> Thank you for the su

Re: Fast way to highlight a listbox entity selection

2019-04-16 Thread Keith Culotta via 4D_Tech
compiled mode before the change. Still have the spinning wheel however. Keith - CDI > On Apr 16, 2019, at 9:22 AM, Keith Culotta via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Justin, > > Thank you for the suggestion. > > I switched the deselect-all code

Re: Fast way to highlight a listbox entity selection

2019-04-16 Thread Keith Culotta via 4D_Tech
heel appears for three minutes. The highlight then appears and control is returned to the app. The fewer the records being highlighted, the shorter the macOS wheel spins. Regards, Keith - CDI > On Apr 15, 2019, at 7:50 PM, Justin Carr via 4D_Tech <4d_tech@lists.4d.com> > wrote: > &g

Fast way to highlight a listbox entity selection

2019-04-15 Thread Keith Culotta via 4D_Tech
Hello, I'm looking for a fast way to highlight a selection of rows in an entity selection listbox. The way I am aware of works OK unless the listbox gets a large number of rows. Adding records to the Selected Items name in the Property list does not highlight the listbox contents. The

Re: Count in Text

2019-04-09 Thread Keith Culotta via 4D_Tech
> > On Tue, Apr 9, 2019 at 4:29 PM Keith Culotta via 4D_Tech > <4d_tech@lists.4d.com> wrote: >> >> ...and this. It's probably slower than using Position, but I'd have to test >> to be sure. (3 Lengths and 1 Replace string) >> >> C_LONGINT($cou

Re: Count in Text

2019-04-09 Thread Keith Culotta via 4D_Tech
...and this. It's probably slower than using Position, but I'd have to test to be sure. (3 Lengths and 1 Replace string) C_LONGINT($count;$len1;$len2;$lenFind) $string:="This message and any attached documents contain information which maybe confidential, subject to privilege or exempt from

Re: Code signing works on one app but fails on another

2019-03-21 Thread Keith Culotta via 4D_Tech
I have been copying lines similar to these and then pasting them into the Terminal. Not sure about the details of these steps, but the app installs and runs. The pkg file ends up in the Home folder. // At the $ prompt (if the app is in the Documents folder) xattr -cr "Documents/myApp.app"

Re: Can't get to development mode!

2019-03-12 Thread Keith Culotta via 4D_Tech
I have seen it ignore the Development mode menu selection until I closed an open window. or Does it go to the compiled version, requiring you to select "restart interpreted" from the "run" menu. Keith - CDI > On Mar 12, 2019, at 5:49 PM, Doug Hall via 4D_Tech <4d_tech@lists.4d.com> >

Loose Object attribute typing

2019-03-12 Thread Keith Culotta via 4D_Tech
This seems to be a really advantageous way to use objects. It compiles and returns good results. I can see where caution would be advised, but is using an object this way going to break eventually as the 4D language matures, or is it an advantage of objects? //

Re: How to display read-only input form

2019-02-06 Thread Keith Culotta via 4D_Tech
I have simulated that effect with code like this: If (Read only state([Docs])) & (Form event=On After Edit) vContent:=[Docs]Content End if Where vContent is editable (no entry filter). Keith - CDI > On Feb 6, 2019, at 3:31 PM, Jim Crate via 4D_Tech <4d_tech@lists.4d.com> > wrote: >

Re: How to display read-only input form

2019-02-06 Thread Keith Culotta via 4D_Tech
Can you call Modify Record with code either lock and reload the record(s), or disable entry for all objects? Keith - CDI > On Feb 6, 2019, at 3:31 PM, Jim Crate via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > From a listbox view, I’d like to open the input form for a record but not > allow

Re: How to get the Window ref of the 4D 64 bit app window

2019-01-31 Thread Keith Culotta via 4D_Tech
Doing WINDOW LIST($aWin) in On Startup will return the window's ref in the array (on the Mac anyway). Keith - CDI > On Jan 31, 2019, at 4:40 PM, Peter Hay via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Hi, > > I'm trying to get the Window reference of 4D's application window so that I > can

Re: How to Create a Browser-Like Tabbed Interface

2019-01-21 Thread Keith Culotta via 4D_Tech
A tab control will not report a click when the click is on the current tab "page", but Safari seems to work that way too (no reaction to a click on the current page's tab). Clicking another of the tab's areas will generate a click. SVG pictures offer a good way to see clicks. You'll always

Re: v13- Chasing Relations

2019-01-08 Thread Keith Culotta via 4D_Tech
Would these help? https://doc.4d.com/4Dv17/4D/17/GET-RELATION-PROPERTIES.301-3729513.en.html https://doc.4d.com/4Dv17/4D/17/dataClassAttributerelatedDataClass.303-3884018.en.html

Re: Related Fields in a Listbox (Manual Relations)

2018-11-16 Thread Keith Culotta via 4D_Tech
ks. Just what I needed! > > Sannyasin Siddhanathaswami > On Nov 16, 2018, 9:09 AM -1000, Keith Culotta via 4D_Tech > <4d_tech@lists.4d.com>, wrote: > These have worked: > > // ok > GET AUTOMATIC RELATIONS($o;$m) // before the listbox displays > SET AUTOMATIC RELATIONS(True;$m)

Re: Related Fields in a Listbox (Manual Relations)

2018-11-16 Thread Keith Culotta via 4D_Tech
These have worked: // ok GET AUTOMATIC RELATIONS($o;$m) // before the listbox displays SET AUTOMATIC RELATIONS(True;$m) // better : (Form event=On Display Detail) // in the listbox method RELATE ONE([many]linkField) Keith - CDI > On Nov 16, 2018, at 12:54 PM, Sannyasin

Re: Making a selection

2018-11-09 Thread Keith Culotta via 4D_Tech
Nothing built in, but one option is to put an invisible rectangle on a form, and make it visible and act like a selection rectangle when the mouse goes down. Another is to overlay (or underlay) a form sized picture on the form and use SVG to produce the selection rectangle. SVG is nice in

Re: Listbox multiple select

2018-11-09 Thread Keith Culotta via 4D_Tech
Look here at the "Selection Mode" section of the Listbox's Property list. http://doc.4d.com/4Dv16/4D/16.4/List-box-specific-properties.300-3998930.en.html Keith - CDI > On Nov 9, 2018, at 7:54 AM, vagelis fallias via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Hello all, > how do I make a

Re: Reindex

2018-11-06 Thread Keith Culotta via 4D_Tech
If you open the data file using your own copy of the structure, maybe your copy of the structure has a field indexed that the client's copy does not have indexed? Keith - CDI > On Nov 6, 2018, at 11:52 AM, stardata.info via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > 1 - I select the tre

Re: Longing IDs or UUIDs as primary key?

2018-10-24 Thread Keith Culotta via 4D_Tech
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: > >

Re: Longing IDs or UUIDs as primary key?

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

2018-10-24 Thread Keith Culotta via 4D_Tech
[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

Re: Longing IDs or UUIDs as primary key?

2018-10-24 Thread Keith Culotta via 4D_Tech
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: Icon & Picture Button Sources...

2018-10-24 Thread Keith Culotta via 4D_Tech
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: Shared Object - NOT!

2018-10-22 Thread Keith Culotta via 4D_Tech
If a method creates an object ($no:=new object), the object is destroyed when the method ends? and if a method creates a new shared object ($nso:=new shared object), the object continues to exist after the method ends, but the reference to it is lost? Does 4D know to clear the object in this

Re: can an array be added to a Form's object list i.e. Form.Array?

2018-10-02 Thread Keith Culotta via 4D_Tech
to the data object is whatever choice is made. > > It sounds like you're describing a situation where the data object includes > things like the choice lists. > > It's not a case of one being better than the other, more a case of > different approaches to managing the form

Re: can an array be added to a Form's object list i.e. Form.Array?

2018-10-02 Thread Keith Culotta via 4D_Tech
or for each value of ChoicesArray: OB SET(Form;"ChoicesArray"+string($i); ChoicesArray{$i}) ? Keith > On Oct 2, 2018, at 3:10 PM, Keith Culotta via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > You can save ChoicesArray to the Form object with OB SET > ARRAY(For

Re: can an array be added to a Form's object list i.e. Form.Array?

2018-10-02 Thread Keith Culotta via 4D_Tech
You can save ChoicesArray to the Form object with OB SET ARRAY(Form;"myarr";ChoicesArray). http://doc.4d.com/4Dv17/4D/17/OB-SET-ARRAY.301-3730702.en.html Also 'JSON Stringify array' will produce a string that can be reconstituted with JSON PARSE ARRAY. FORM.myarr:=$stringifiedArray

Using a custom namespace in SVG

2018-09-17 Thread Keith Culotta via 4D_Tech
I'm taking a shot at using a custom namespace, but can't find an example of its implementation in 4D SVG. Experimenting, I noticed that all three attributes below assigned with SVG_SET_ATTRIBUTES worked without returning an error when created, when used with SVG_GET_ATTRIBUTES, or when opened

Re: New record numbering system and CALL WORKER

2018-08-27 Thread Keith Culotta via 4D_Tech
Does the speed penalty apply to reading values from Storage, or just to writing values to Storage? Thanks, Keith - CDI > On Aug 26, 2018, at 8:57 AM, John DeSoi via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Storage is the best option for interprocess communications if you want to use >

Re: Line count - compiled component vs interpreted

2018-08-24 Thread Keith Culotta via 4D_Tech
age- > From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Keith Culotta via > 4D_Tech > Sent: Friday, August 24, 2018 11:10 AM > To: 4D iNug Technical <4d_tech@lists.4d.com> > Cc: Keith Culotta > Subject: Line count - compiled component vs interpreted &g

Line count - compiled component vs interpreted

2018-08-24 Thread Keith Culotta via 4D_Tech
Hello, A compiled component of mine is throwing an error message from within a host database. It is correct to display the error message under its current conditions. However, the error is reported on line 35 of the offending method, but the method has only 25 lines, blank lines and all. Any

Re: SVG - Simple Example

2018-08-24 Thread Keith Culotta via 4D_Tech
A basic approach could be like this: --- C_TEXT($svg;$ref) C_PICTURE($pict) $svg:=SVG_New // this new svg document is referred to as "$svg" $ref:=SVG_New_rect ($svg;10;10;100;100) // refer to this new rectangle in "$svg" as "$ref" SVG_SET_FILL_BRUSH ($ref;"red")

Re: Sending Text Messages From 4D

2018-08-22 Thread Keith Culotta via 4D_Tech
This has been working for us, but we only use it occasionally. $err:=SMTP_QuickSend ($Host;$FromAddress;$msgTo;$subject;$message;0;25;$vAuthUserName;$sequence) where $msgTo is a text/phone# like 555...@vtext.com Keith - CDI > On Aug 22, 2018, at 9:04 AM, Tim Nevels via 4D_Tech

Re: How to show subtotals in a list box

2018-08-20 Thread Keith Culotta via 4D_Tech
Starting at the top and working down an array based listbox: A column could be "manually" subtotaled by inserting rows at the break points of a sorted column. These rows would need a marker in an invisible column so they could be deleted in the next sort or selection change. Or add a numeric

Re: Anyone using FTP_Receive under 64-bit?

2018-08-15 Thread Keith Culotta via 4D_Tech
FTP_Receive used to show the progress of the download. That is no longer available, and I think throws an error if it's used. I think the cURL plugin shows the progress, or allows you to figure it out somehow. Keith - CDI > On Aug 15, 2018, at 4:10 PM, Allan Udy via 4D_Tech

Re: SVG IDs in Listbox Cells

2018-08-14 Thread Keith Culotta via 4D_Tech
Can you then $svg:=SVG_Open_picture (agRM_Graph{1}) $ref:=SVG_Find_ID ($svg;"Value1") SVG_SET_ATTRIBUTES ($ref;"fill-opacity";"1";"stroke-opacity";"1") agRM_Graph{1}:=SVG_Export_to_picture ($svg) ? Keith - CDI > On Aug 14, 2018, at 9:40 AM, Cannon Smith via 4D_Tech <4d_tech@lists.4d.com> >

Re: V17 and Edit menu (Copy)

2018-08-09 Thread Keith Culotta via 4D_Tech
I just had an instance (v17 Mac) where "command C" and "command V" to copy and paste some form objects between two forms had no effect. It worked when I used the menus with the mouse. That also seems to have cured the problem. This happens on such rare occasions that I've been blaming my

Re: Memory leak with dynamic variables in list boxes?

2018-07-27 Thread Keith Culotta via 4D_Tech
Would something like this help... ARRAY REAL(aFoot;0) // Use this array to give each column a unique REAL footer var in the loop Append To Array(aFoot;0) LISTBOX INSERT COLUMN(*;$lbName;$i;"C"+$iStr;$nilPtr;"H"+$iStr;$nilPtr;"Foot"+$iStr;aFoot{Size of array(aFoot)}) in the

Re: Listbox Type?

2018-07-24 Thread Keith Culotta via 4D_Tech
Maybe this command : http://doc.4d.com/4Dv17/4D/17/LISTBOX-GET-TABLE-SOURCE.301-3730224.en.html Keith - CDI On Jul 24, 2018, at 11:56 AM, Bob Miller via 4D_Tech <4d_tech@lists.4d.com> wrote: Hi Everyone, Is there a way to tell through the language whether a listbox is an "Array Type"

Re: Who’s got the gazpacho?

2018-07-19 Thread Keith Culotta via 4D_Tech
Sorry, looking for the Paula Deen list. Keith - CDI ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub:

Re: Drag n drop between processes

2018-07-10 Thread Keith Culotta via 4D_Tech
Hope this is on topic... During : (Form event=On Begin Drag Over) in the source list, I put the information about the item being dragged on the Pasteboard LOAD RECORD([Item]) C_OBJECT($obj) OB SET($obj;"$rec";Record number([Item]))

Re: New way to get into Design Mode - v16?

2018-07-09 Thread Keith Culotta via 4D_Tech
Where the menu was empty before, the standard action "design" could be added to it. Keith - CDI > On Jul 9, 2018, at 10:54 AM, Bob Miller via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I'm digging through the docs - is there a new way to get into the Design > mode in v16? > > Up to v15,

Re: UUID version 4 needed

2018-07-06 Thread Keith Culotta via 4D_Tech
$a:=Substring(Generate UUID;13;1) ALERT($a) Mac 16.225201 64bit - returns a "4" (client/server) Mac 17.224978 64bit - returns a "4" Char 15 is random. v16 tested on Macs of various ages and 10.12, 10.13. Keith - CDI > On Jul 6, 2018, at 10:33 AM, Piotr Chabot Stadhouders via 4D_Tech >

Re: Quitting without IP var?

2018-07-03 Thread Keith Culotta via 4D_Tech
If using v17, shared Storage solves the problem. It takes the place of IP vars. http://livedoc.4d.com/4D-Language-Reference-17/Objects-Language/Storage.301-3730714.en.html // // Method: setQuit // INPUT1: Boolean - Quit? //

Re: 4D Write licensing...

2018-06-28 Thread Keith Culotta via 4D_Tech
As I recall, any interaction with aWrite document requires the user to have a license. You could store a PDF copy of a document for others to print or view. Keith - CDI > On Jun 28, 2018, at 2:47 PM, Robert ListMail via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > I appreciate your response;

Re: Counting lines of text

2018-06-27 Thread Keith Culotta via 4D_Tech
That sounds like a job for TEXT TO ARRAY ( varText ; arrText ; width ; fontName ; fontSize {; fontStyle {; *}} ) Keith - CDI > On Jun 27, 2018, at 4:31 PM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I have a need to know how many lines a block of text will occupy. > Given: >

Re: Uppercase Lowercase

2018-06-20 Thread Keith Culotta via 4D_Tech
...and check the length is = Keith - CDI > On Jun 20, 2018, at 2:32 PM, Keith Culotta via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > or > C_BOOLEAN($0) > C_TEXT($1;$2) > $0:=(Position string ($1; $2; *) = 1) > > Keith - CDI > >> On Jun 20, 2018, at

Re: Uppercase Lowercase

2018-06-20 Thread Keith Culotta via 4D_Tech
or C_BOOLEAN($0) C_TEXT($1;$2) $0:=(Position string ($1; $2; *) = 1) Keith - CDI > On Jun 20, 2018, at 2:19 PM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > How about > > C_BOOLEAN($0) > C_TEXT($1;$2) > $0:=(Replace string ($1; $2; *) = “”) > >> On Jun 20, 2018, at 3:05 PM,

Re: Build with code signing

2018-06-11 Thread Keith Culotta via 4D_Tech
Would this still be relevant: http://kb.4d.com/assetid=76697 ? Keith - CDI > On Jun 11, 2018, at 12:34 PM, Peter Bozek via 4D_Tech <4d_tech@lists.4d.com> > wrote: > >> Can someone please direct me to documentation on how to code sign apps for >> MacOS with 4D. I need the entire process in a

Re: Flexible SVG ID Strategy

2018-06-05 Thread Keith Culotta via 4D_Tech
The easiest way I've found to move the objects in a group is to SVG_SET_TRANSFORM_TRANSLATE the group when the mouse is moving. Later if you UNGROUP, the translation needs to be spread out over the group's children so they don't jump to new locations. You can use SVG_Get_root_reference in a

Re: Why are columns of a non-focusable listbox not enterable?

2018-05-25 Thread Keith Culotta via 4D_Tech
Try something like this: OBJECT SET ENTERABLE(*;"LB1";False) OBJECT SET FOCUS RECTANGLE INVISIBLE(*;"LB1";True) FORM GET ENTRY ORDER($aNames;*) DELETE FROM ARRAY($aNames;1) // the is "LB1" FORM SET ENTRY ORDER($aNames) Keith - CDI > On May 25, 2018, at 1:08 PM, Piotr Chabot Stadhouders via

Re: "Your password does not allow you to use this form"

2018-05-24 Thread Keith Culotta via 4D_Tech
This happened to me recently on a Mac that had no printers yet added to the Print System. Keith - CDI > On May 24, 2018, at 3:48 PM, Keisuke Miyako via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > could it be that the table has no defined output forms (and the editor is > somehow looking for

Re: Picture resources Related Question

2018-04-27 Thread Keith Culotta via 4D_Tech
The Picture Library is still in 17b, but you can only add a new pic to by loading it from a volume. Pics in the library can still be assigned to form objects. Keith - CDI > On Apr 27, 2018, at 2:42 PM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Is the Picture library

Re: Picture resources

2018-04-27 Thread Keith Culotta via 4D_Tech
Take a look at this Tech Tip and its link to Tech Tip 76775: http://kb.4d.com/assetid=77713 The code must be run the the older version of 4D, the one compatible with the depreciated picture format. Keith - CDI > On Apr 27, 2018, at 2:09 PM, Dave Tenen via 4D_Tech <4d_tech@lists.4d.com> >

Re: MSC Warnings

2018-04-24 Thread Keith Culotta via 4D_Tech
Try this. I don't remember if it was the stylesheet property at that time or another property, but you can see if it works. I have changed an object type that had no stylesheet in Properties to another type that had a stylesheet. After doing that the hidden stylesheet appeared and could be

Re: ORDA on switch?

2018-04-12 Thread Keith Culotta via 4D_Tech
The table must have a primary key field to be seen. The old table was created before primary keys were used. Keith - CDI > On Apr 12, 2018, at 10:33 AM, Keith Culotta wrote: > > C_OBJECT($entAll) > $entAll:=ds.Table_1.all() > > The code works in a new structure. > It

ORDA on switch?

2018-04-12 Thread Keith Culotta via 4D_Tech
C_OBJECT($entAll) $entAll:=ds.Table_1.all() The code works in a new structure. It fails in a converted structure with the error "Unknown Member Function". Compatibility: "Use object notation..." is checked. "Expose with 4D Mobile Service" is checked for the Table and Fields. The database was

Re: ORDA query & pointers syntax question

2018-04-11 Thread Keith Culotta via 4D_Tech
name(pTable) >> $fieldName:=Field name(pField) >> QUERY(ds[$tableName];ds[$tableName][$fieldName]=$aValue) >> >> When an object property name is on a variable, you can use the >> “object[property]” syntax. >> >> hth >> julio >> >>&g

ORDA query & pointers syntax question

2018-04-11 Thread Keith Culotta via 4D_Tech
Hello, I didn't recognize a solution for this in the docs. When the table and field are unknown until execution time, any suggestions on what the ORDA approach to this type of query would be? QUERY(pTable->;pField->=$aValue) Thanks - Keith - CDI

Re: Multi-Table Query Into JSON?

2018-03-23 Thread Keith Culotta via 4D_Tech
The "Movable form dialog box" type became available for "Open form window" at some point. It is also constant 5. A "Plain form window" with Cancel in the Deactivate event is user friendly, but will probably appear behind a floating window. Keith - CDI > On Mar 23, 2018, at 12:15 PM,

Re: time entry filter

2018-03-12 Thread Keith Culotta via 4D_Tech
4D will interpret entries like 1.25p as 13:25:00, or 1.25 as 01:25:00 without requiring a filter. Keith - CDI > On Mar 12, 2018, at 8:07 AM, Randy Jaynes via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Does anyone know of a filter string or something that can be done so people > don’t have

Re: Barber Pole Progress Indicator for Foundation

2018-02-21 Thread Keith Culotta via 4D_Tech
If you don't mind using the Progress component, this would work: http://livedoc.4d.com/4D-Progress-16-R6/Progress-bars/Progress-SET-PROGRESS.301-3712491.en.html Keith - CDI > On Feb 21, 2018, at 4:57 PM, Douglas von Roeder via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > I'm working with a

Re: Delivery problem

2018-02-21 Thread Keith Culotta via 4D_Tech
That works. Dignity restored. Keith - CDI > On Feb 21, 2018, at 12:11 PM, Timothy Penner via 4D_Tech > <4d_tech@lists.4d.com> wrote: > >> So I build a quick sample app for a client and send a zipped copy. He >> writes back and says his Mac won't open it because it’s from an undignified >>

Delivery problem

2018-02-21 Thread Keith Culotta via 4D_Tech
So I build a quick sample app for a client and send a zipped copy. He writes back and says his Mac won't open it because it’s from an undignified developer Keith - CDI ** 4D Internet Users Group (4D iNUG) FAQ:

Wayback machine: 6.5 Client lost a form

2018-02-05 Thread Keith Culotta via 4D_Tech
Hello, A customer gets a "Form not found" error when trying to access a Table form on one of their PCs. All other PCs can view the form. No user logged into this one PC can view the form. It's a virtual Windows XP environment when accessing 4D. Does anyone remember where the temp folder for the

Re: ImageCaptureCore - to Variable?

2018-02-01 Thread Keith Culotta via 4D_Tech
maybe another time, if I find where it starts. > On Jan 31, 2018, at 6:46 PM, Keisuke Miyako via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > but you receive binary RGB data in chunks, > and you have to build your own JPG, PNG, TIFF, whatever, by code. > > do you really want to go down that

ImageCaptureCore - to Variable?

2018-01-31 Thread Keith Culotta via 4D_Tech
Hello, I'm experimenting with 4d-plugin-ica and it's working. Is it possible to avoid scanning to a disk file? I tried ICA SET SCAN OPTION ($scanner;Scanner transfer mode;String(Scanner transfer mode data)) and can see a BLOB is being built. Using BLOB TO PICTURE and BLOB TO VARIABLE (with a

Re: ADA Compliance ???

2018-01-24 Thread Keith Culotta via 4D_Tech
No direct experience, but a couple of resources. Government rules: https://www.access-board.gov/guidelines-and-standards/communications-and-it/about-the-ict-refresh/final-regulatory-impact-analysis#_Toc471376906 DOJ Quick Check: https://www.justice.gov/crt/software-accessibility-checklist Real

Re: User Custom Forms

2018-01-23 Thread Keith Culotta via 4D_Tech
I used an inherited form in the user enterable form, so some changes could be made in the development environment without destroying the User's changes. Also, could OBJECT DUPLICATE be used during On Load to give a new object a name like "[Table1]Field1"? Keith - CDI > On Jan 23, 2018, at

Re: Anyone been using R5 for real work?

2018-01-19 Thread Keith Culotta via 4D_Tech
R5 has been very solid to the extent I've used it. I'm using dot notation and the new FORM object to get a floating window to communicate with instances of a subform containing a SVG picture. The FORM object is very convenient. I haven't tried to access tables. Keith - CDI > On Jan 19,

Re: File Size

2018-01-15 Thread Keith Culotta via 4D_Tech
Today I saw that somewhere around 1997 the answer to this 6÷2(1+2) changed from 1 to 9, also because of techno-cultural influences. Keith - CDI > On Jan 15, 2018, at 2:10 PM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > On Jan 15, 2018, at 2:00 PM, Wayne Stewart wrote: > >> I'm

Tip: SVG internal error Trace

2018-01-15 Thread Keith Culotta via 4D_Tech
In case I am not the last one to know... When an internal SVG error message pops up on the screen, the Trace button is disabled in the dialog, but Trace is still available to display the offending line of code. You can use the option-command-click and select from the pop-up menu while the

Re: Database locked in merged application

2017-12-21 Thread Keith Culotta via 4D_Tech
Re: So it looks like the data file which is wrapped up inside the application can’t be used After opening the app's package, doing a "Get Info" on the contents, making permissions R/W, and then building the app, that message went away in the built application. I had set the DB preference to

Re: Slow characters visualization

2017-11-20 Thread Keith Culotta via 4D_Tech
Just to confirm, I have also seen the issue on my MacBook Pro since v15 was introduced. It was intermittent, and I have not experienced it for a while. Sometimes quitting 4D and restarting would help. Other times it would restart with the problem still present. I never saw a clear pattern

Re: Normalization question

2017-11-08 Thread Keith Culotta via 4D_Tech
Something that stood out in a recent thread about the definition of the Relational Model was a statement that said related fields should contain meaningful information. This was a surprise, especially since the use of UUIDs has been such a convenience. I took 'meaningful' to imply 'user

Re: Normalization question

2017-11-08 Thread Keith Culotta via 4D_Tech
[Project]<--[ProjectEmployeeType]--> [Employee] ? Keith - CDI > On Nov 8, 2017, at 2:06 PM, John Baughman via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Given a Project table and an Employee table where Employees can be Project > Principles, Project Managers, and Project Supervisors,

Re: identify duplicates

2017-10-31 Thread Keith Culotta via 4D_Tech
The third parameter of DISTINCT VALUES really saves work. Here is a strategy to find dups in a field within a selection. The set can be a listbox highlight set. // // Method: DuplicatesToSet // - // INPUT1: Pointer - field //

Re: pointers to arrays (and List Box Basics)

2017-10-31 Thread Keith Culotta via 4D_Tech
A past discussion mentioned creating arrays on the fly using a Listbox command that creates columns. This is for an array listbox. http://livedoc.4d.com/4D-Language-Reference-16.2/List-Box/LISTBOX-INSERT-COLUMN.301-3433513.en.html C_POINTER($NilPtr) LISTBOX INSERT

Re: Resizable subforms

2017-10-26 Thread Keith Culotta via 4D_Tech
ew host form? >> Is the Write Pro object within the subform for sure set to grow? >> >> Keith - CDI >> >>> On Oct 26, 2017, at 12:47 PM, Pat Bensky via 4D_Tech < >> 4d_tech@lists.4d.com> wrote: >>> >>> Nothing grows ... not

Re: Resizable subforms

2017-10-26 Thread Keith Culotta via 4D_Tech
PM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Nothing grows ... not the subform or any of it contents. > > On 26 October 2017 at 16:00, Keith Culotta via 4D_Tech <4d_tech@lists.4d.com >> wrote: > >> If the WP object in a form is set to gr

Re: Resizable subforms

2017-10-26 Thread Keith Culotta via 4D_Tech
If the WP object in a form is set to grow, and that is used in a subform which is set to grow, the WP object should grow the way you are thinking when the host form is resized. Keith - CDI > On Oct 26, 2017, at 4:32 AM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Using v16: >

Re: SVG add object question

2017-10-23 Thread Keith Culotta via 4D_Tech
// A heads up about embedding a SVG area into another SVG area. // Getting the ID of the embedded object requires SVG Find element IDs by rect // It does not seem to work using SVG Find element ID by coordinates $svg:=SVG_New $svgArea:=SVG_New SVG_New_text ($svg;"This is a test";10;10)

Re: SVG add object question

2017-10-22 Thread Keith Culotta via 4D_Tech
A nice solution! Just to be sure, it was to use ".svg" rather than "svg"? $svgPictureRef:=SVG_New_embedded_image ($svgCopyrightLayer_Ref;$interPicture;5;0;“.svg“) rather than $svgPictureRef:=SVG_New_embedded_image ($svgCopyrightLayer_Ref;$interPicture;5;0;“svg“) As displayed in the web

Re: SVG add object question

2017-10-22 Thread Keith Culotta via 4D_Tech
I think I recall a discussion a while back about SVG_Add_object not working well when the object being added was another svg document. Two svg docs can be "combined" using SVG_ELEMENTS_TO_ARRAYS, and SVG_Add_object for each reference in the doc being added. This technique doesn't produce a

Re: Is a package preferred?

2017-10-20 Thread Keith Culotta via 4D_Tech
I switched back to folders for development. It's easier to manipulate the app's supporting folders and files. Users get a package, but like Chip said, you have to guard against the unintentional use of the datafile within the package. Keith - CDI > On Oct 19, 2017, at 5:41 PM, Robert

Re: v13 - How to clear Array list box selection

2017-10-16 Thread Keith Culotta via 4D_Tech
Something along the lines of the listbox variable being a BOOLEAN array. The highlighted rows are TRUE. Keith - CDI > On Oct 16, 2017, at 4:36 PM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I have an array based listbox. > I make a select the first row. > I drag n drop

Re: FORM SET OUTPUT -> project form

2017-10-16 Thread Keith Culotta via 4D_Tech
I think PRINT RECORD and PRINT SELECTION require a Table Form. A project form is printed with PRINT FORM. Keith - CDI > On Oct 16, 2017, at 5:39 AM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Using v14: > > I get an error with > > *FORM SET OUTPUT*("ReportHeaderLandscape")

Re: SVG Scale

2017-09-19 Thread Keith Culotta via 4D_Tech
Sorry, there is also this: SVG_SCALING_CENTERED ( svgObject ; scale {; x ; y} ) http://doc.4d.com/4Dv16/4D/16/SVG-SCALING-CENTERED.301-3202422.en.html Keith - CDI > On Sep 19, 2017, at 11:03 AM, Jim Dorrance via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Hi, > > I am looking for a very

Re: SVG Scale

2017-09-19 Thread Keith Culotta via 4D_Tech
Here is a sample with the attributes hard coded: 100 and 2. Comment out (and in) the middle section to see the effect. $svg:=SVG_New $ref:=SVG_New_circle ($svg;100;100;20) SVG_SET_TRANSFORM_SCALE ($ref;2;2) SVG_SET_ATTRIBUTES ($ref;"cx";String(100/2);"cy";String(100/2))

Scheduler App request

2017-09-15 Thread Keith Culotta via 4D_Tech
I saw the following from an Apple Reseller. Does anyone have a solution? I can forward the info to him. We have 8-10 trucks on the road every day performing deliveries, installations, service calls, etc. For 30 years we have used old fashion pen and paper to create a schedule but our

Re: [OFF] PCI/DSS compliance

2017-09-08 Thread Keith Culotta via 4D_Tech
pper lines anymore. > > ​Were you involved in the overall certification PCI certification process? > I'm wondering about stuff like the internal paper handling aspects of the > deal. Any insight is welcome. > > Thanks much!​ > > > On Thu, Sep 7, 2017 at 1:51 PM, Keith Culot

Re: [OFF] PCI/DSS compliance

2017-09-07 Thread Keith Culotta via 4D_Tech
Kirk, I can't say that I understand the nuances of the system to the point of having any details to contribute, but after lots of trying to figure it out the thing that finally allowed us to pass the scan was to use a VPN. We open only the VPN ports and the ports required by the credit card

Re: SVG component question

2017-09-05 Thread Keith Culotta via 4D_Tech
----- > > > >> On 05 Sep 2017, at 19:19, Keith Culotta via 4D_Tech <4d_tech@lists.4d.com> >> wrote: >> >> I think a 'text' element's text can only be set when it is created, unlike a >> textArea. So the item that needs to be changed wi

  1   2   >