Re: JSON Plugin for 4Dv17

2021-04-08 Thread Adam Bevan via 4D_Tech 
This is supported natively.

$vJ_Object:=New object
$vJ_Object.value1:="stuff"
$vJ_Object.value2:="morestuff"
$vJ_Object.value3:="otherstuff"
$vT_Text:=Json Stringify($vJ_Object;*)
TEXT TO DOCUMENT($vT_DocPath;$vT_Text)

Adam Bevan
Argus Productions Inc. 



On Thu, 8 Apr 2021 at 16:34, Tarawerkz via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Hi All,
>
> I have a client whose database application currently outputs a series of
> text files in an exchange with an independent web database.
> In an effort to further streamline this functionality, it have been
> proposed to convert and integrate the various text file output to a JSON
> file format instead.
>
> Is there currently any 4D plugin for creating JSON files in 4D that is
> compatible with 4Dv17 (Windows)?
> Thank you.
>
> Regards,
> Ronnie
> Tarawerkz
>
>
>
>
> **
> 4D Internet Users Group (4D iNUG)
> New Forum: https://discuss.4D.com
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: ON MOUSE ENTER

2020-08-13 Thread Adam Bevan via 4D_Tech 
On mouse enter it triggers only once on entering the list box. If your mouse 
moves within the listbox it would not trigger again and you could not trigger 
any code.
If you use listbox get cell position and on mouse move. This might get you what 
you need.

Sent from my iPad

> On Aug 14, 2020, at 12:17 AM, stardata.info via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> The goal is to know the row number when the mouse arrow is on one row of 
> list box.
> 
> Thanks
> 
> Ferdinando
> 
> Il 12/08/20 17:32, stardata.info ha scritto:
>> 
>> Hi All,
>> 
>> I need to know the arrow number of a list box, when the event " On Mouse 
>> Enter " enter in one row.
>> 
>> Now i use the command OBJECT Get pointer but he not work.
>> 
>> Someone know how i can do?
>> 
>> Thanks
>> 
>> /Ferdinando/
>> 
> **
> 4D Internet Users Group (4D iNUG)
> New Forum: https://discuss.4D.com
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Object notation replacement for use of Self in a script — v18

2020-04-29 Thread Adam Bevan via 4D_Tech 
*OBJECT Get pointer*(Object named;"")

does return the Form object.

If you standardise your naming convention of the form field objects you
could determine the sub object and attribute you're looking for.

example:

FormObj_Wrap_Trim("en_company";"name")


FormObj_Wrap_Trim:

$vT_Object:=*$1*

$vT_Attrib:=*$2*

$vT_FormObjName:=$vT_Object+"_"+$vT_Attrib

$vP_Field:=*OBJECT Get pointer*(Object named;$vT_FormObjName)

Trim($vP_Field->[$vT_Object][$vT_Attrib])

this will get you Form.en_company.name

As I don't know what you have in Trim I'll just leave it as is.

Adam Bevan




On Wed, 29 Apr 2020 at 15:53, Chris Belanger via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Generic programming of vars on a form is very complicated when one uses
> object attributes for the data source.
>
> For example, on screen you make a simple text input object named
> “enCompany”. It’s data source is Form.en_Company.Name (  i.e.
> [Company]Name  )
>
> In ‘classic 4d”, where the data source would be [Company]Name, one can
> code its script:
> TRIM ( Self )
>
> And TRIM would simply take a POINTER, and you can perform operations on
> the data that the user typed into that field. (Such as trim off leading &
> trailing spaces).
>
> But with OBJECT NOTATION, that is all screwed up.
> You cannot get a PTR to, for instance, an object named ‘enCompany’ whose
> data source is  Form.en_Company.Name
> So the script for it cannot be generic.
> It would seem to make sense to be able to do something like:
>
> TRIM ( Form Event.objectName ) — and have some way to actually do anything
> with what the user typed into this element on-screen.
>
> You can’t use TRIM ( Self ) because Self is nil
>
> And v18r3 does not even have a solution to this in its documentation.
>
> It seems we should have some way of getting the user-input data of a
> screen element even if we are using object notation.
>
> We would expect, at the least, something like  OBJECT Get Value (
> ObjectName ) and OBJECT Set Value ( Object Name ) but no!
>
> Any input? Wait for version 20 of 4D?
>
> - Chris
> **
> 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
> **
**
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: QUERY WITH ARRAY - SQL Equivalent?

2019-09-18 Thread Adam Bevan via 4D_Tech 
 
Because of the SQL gotcha in v12 I always have a case of statement to run
4D queries instead.
For something like what is described, I send the query to another process
and return the array of record ID's.
Allows for the query but doesn't change the selection or current record for
the current process.

I'm not saying SQL is bad, but it's just nice to have the quick ease of
flipping a switch to run native 4D.


Adam Bevan
Developer & CEO, Argus Productions Inc.



On Wed, 18 Sep 2019 at 11:05, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Here goes
>
> C_TEXT($INCLUDED_txt)
> $INCLUDED_txt:=“(“+String(al_Personnel_ID{1})
> for($LOOPL;2;size of array(al_Personnel_ID))
>
> $INCLUDED_txt:= $INCLUDED_txt+”,”+String(al_Personnel_ID{LOOPL})
>
> end for
> $INCLUDED_txt:=$INCLUDED_txt+”)"
> begin sql
> select [Personnel].[field],...
>
> from [Personnel]
> where
> Personnel]Personnel_ID in :$INCLUDED_txt:
>
> end sql
>
> 
>  Chuck Miller Voice: (617) 739-0306
>  Informed Solutions, Inc. Fax: (617) 232-1064
>  mailto:cjmillerinformed-solutions.com
>  Brookline, MA 02446 USA Registered 4D Developer
>Providers of 4D and Sybase connectivity
>   http://www.informed-solutions.com
>
> 
> This message and any attached documents contain information which may be
> confidential, subject to privilege or exempt from disclosure under
> applicable law.  These materials are intended only for the use of the
> intended recipient. If you are not the intended recipient of this
> transmission, you are hereby notified that any distribution, 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 or exemption from
> disclosure as to this communication.
>
> > On Sep 18, 2019, at 11:44 AM, Randy Engle via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> > Hello SQL Afficionados!
> >
> > I need to get a selection of records, based upon an array of ID numbers.
> > (What I want is to end up the arrays... not the selection of records)
> >
> > e.g.
> > QUERY WITH ARRAY([Personnel]Personnel_ID;al_Personnel_ID)
>
> **
> 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
> **
**
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: Help Tips for list boxes?

2019-09-03 Thread Adam Bevan via 4D_Tech 
Yeah I have 1 window which I hide/show and move based on the object I'm
displaying the help for.
I also have a feature which allows me to enter/update the help tip text as
I or my users are using the app.

Adam Bevan
Developer & CEO, Argus Productions Inc.
<https://www.facebook.com/ArgusProductions/>



On Tue, 3 Sep 2019 at 13:02, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Hi Adam,
> yeah ... I was thinking of doing that.
> Do you have one window for the help tip which you hide and show was
> required, or create a new one each time?
>
> Pat
>
> On Tue, 3 Sep 2019 at 17:50, Adam Bevan via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
>
> >  AJUI_Tip looks nice but it requires a picture object on every page on
> > every form you want it to work.
> > I instead use a window in a new process and call it on mouse enter and
> > leave.
> > Similar result. as well, my custom help tips don't disappear after 5
> > seconds.
> >
> > Adam Bevan
> > Developer & CEO, Argus Productions Inc.
> > <https://www.facebook.com/ArgusProductions/>
> >
> >
> > On Tue, 3 Sep 2019 at 08:22, Pat Bensky via 4D_Tech <
> 4d_tech@lists.4d.com>
> > wrote:
> >
> > > There's no Help Tip option for list boxes ... Anybody know of a way to
> > roll
> > > your own? The On Mouse enter event works, so it could be managed in
> > there.
> > >
> > > Pat
> > >
> > > --
> > > *
> > > CatBase - Top Dog in Data Publishing
> > > tel: +44 (0) 207 118 7889
> > > w: http://www.catbase.com
> > > skype: pat.bensky
> > > *
> > > **
> > > 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
> > > **
> > **
> > 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
> > **
>
>
>
> --
> *
> CatBase - Top Dog in Data Publishing
> tel: +44 (0) 207 118 7889
> w: http://www.catbase.com
> skype: pat.bensky
> *
> **
> 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
> **
**
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: Help Tips for list boxes?

2019-09-03 Thread Adam Bevan via 4D_Tech 
 AJUI_Tip looks nice but it requires a picture object on every page on
every form you want it to work.
I instead use a window in a new process and call it on mouse enter and
leave.
Similar result. as well, my custom help tips don't disappear after 5
seconds.

Adam Bevan
Developer & CEO, Argus Productions Inc.



On Tue, 3 Sep 2019 at 08:22, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> There's no Help Tip option for list boxes ... Anybody know of a way to roll
> your own? The On Mouse enter event works, so it could be managed in there.
>
> Pat
>
> --
> *
> CatBase - Top Dog in Data Publishing
> tel: +44 (0) 207 118 7889
> w: http://www.catbase.com
> skype: pat.bensky
> *
> **
> 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
> **
**
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: save listbox

2019-08-13 Thread Adam Bevan via 4D_Tech 
Chips solution probably the quickest.
I ended up writing to a tab deliminated text file, so I could load it up
into a spreadsheet.

$vH_FileRef:=Create document($vT_FilePath)
LISTBOX GET
ARRAYS(*;$vT_ListboxName;$aT_ColumnNames;$aT_HeaderNames;$aptr_ColumnVars;$aptr_HeaderVars;$aB_ColVisible;$aL_ColStyle)

$ vL_rCount:=Size of array($ aptr_ColumnVars{1}->)
For($vL_rNum;1;$vL_rCount)
CLEAR VARIABLE($vT_TextToWrite)

$vL_Count:=$aT_ColumnNames
for($vL_cNum;1;$vL_cCount)
if(length($vT_TextToWrite)#0)
$vT_TextToWrite:=$ vT_TextToWrite +Char(tab)
end if
Case of
:(Type($vptr_Column->{$vL_cNum})=Is Text)
$vT_TextToWrite:=$vT_TextToWrite+$vptr_Column->{$vL_cNum}

: (Type($vptr_Column->{$vL_Num})=Is date)
$vT_TextToWrite:=$vT_TextToWrite+String(Year
of($vptr_Column->{$vL_Num}))+"-"+String(Month
of($vptr_Column->{$vL_Num}))+"-"+String(Day of($vptr_Column->{$vL_Num}))

:(Type($vptr_Column->{$vL_cNum})=Is Time)
$vT_TextToWrite:=$vT_TextToWrite+String($vptr_Column->{$vL_cNum};HH MM SS)

:(Type($vptr_Column->{$vL_cNum})=Is Longint)
$vT_TextToWrite:=$vT_TextToWrite+String($vptr_Column->{$vL_Num})

else   // unsupported array types
// don't write to text file.
end case
end for   // each column

$vH_FileRef:=Append document($vT_FilePath)
SEND PACKET($vH_FileRef;$vT_TextToWrite)
end for   // each row

CLOSE DOCUMENT($vH_FileRef)

Adam Bevan
Developer & CEO, Argus Productions Inc.



On Tue, 13 Aug 2019 at 15:29, Peter Mew via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Hi
> Does anyone have a routine, component, plugin, or pointer to the right
> direction, that will save the contents of an array based listbox, so that
> the data can be restored at a later date
> thanks
> -pm
> 4d v13
> **
> 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
> **
**
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: Drag n drop (between processes)

2019-08-12 Thread Adam Bevan via 4D_Tech 
I throw the data i want dropped into an object for dragndrop. Then when i drop 
I know what iam getting as i include the table and record numbers. Where i 
dragged it from(process,form,object) are also included. Made my listbox drag an 
drop so much easier to handle and very generic.

Sent from my iPhone

> On Aug 12, 2019, at 3:06 PM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I am dragging and dropping 1 or more records from 1 process onto a 
> listbox in a second process.
> 
> I see that I can use the pasteboard to mange the data during this 
> action.
> 
> However(dragging 1 record)
> I am looking at the data types returned by GET PASTEBOARD DATA TYPE
> com.4d.private.pid & com.4d.private.Form.Object -- neither of these 
> makes much sense to me.
> 
> By using GET PASTEBOARD DATA i get a blob which is either
> 4 bytes (com.4d.private.pid)
> or
> 524 bytes (com.4d.private.object.form)
> 
> I do not know what to do with either of these blocks of data... can 
> someone point me in the right direction.
> 
> The drop area is allowed to accept data from 5 different tables.
> I need to be able to differentiate which table the data is from, & 
> which record(s) were dropped.
> 
> Once I have which ever of the above data types hand, what do I do with 
> them to extract the needed information.
> 
> Thanks
> Chip
> 
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing 
> **
> 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
> **
**
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: printing listboxes

2019-08-12 Thread Adam Bevan via 4D_Tech 
Hi Chip,

I know that 'calculated' columns do print in v12 and v16. The only thing I
haven't done is use relate one in my 'calculated' column methods.

Adam Bevan
Developer & CEO, Argus Productions Inc.


On Mon, 12 Aug 2019 at 13:28, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> I have code which allows me to print a listbox using Print object.
>
> I dynamically build a listbox for use on screen.
> If a user wants to print the listbox, I use the same process to build a
> separate listbox for reporting (as this is generic code for printing
> list boxes).
>
> What I am observing is complex data gathering fails when printing which
> works correctly when displayed.
> The code (see below for an example) is placed into the listbox as a
> calculation column, in a selection listbox.
> When the listbox is displayed on screen, the data (description) is
> properly displayed.
>
> However, the same data is NOT printed, the column where the description
> is to be displayed, is empty of any text. Which leads me to believe
> that the calculation in the calculated column is not being executed.
>
> Any Ideas on how to go about getting this to function correctly?
>
>
> Example calculated column code, the below code is in a method call, and
> is the "calculation" when inserting the calculation column.
>
>
> QUERY([Lab_Adjustments];[Lab_Adjustments]Adjustment_ID=[Adjustments]Adjustment_ID)
> RELATE ONE([Lab_Adjustments]Lab_Inventory_ID)  //gets the laboratory
> inventory record
> RELATE ONE([Lab_Inventory]Inventory_Item_ID)  //gets the inventory item
> record
> $0:=[Inventory_Items]Description
>
>
> 4D v13
> Thanks
> Chip
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing
> **
> 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
> **
**
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: Creating Hierarchical Listbox

2019-07-29 Thread Adam Bevan via 4D_Tech 
Hi Peter,

Sounds like your top level rows have columns populated with data inbetween
blank data (columns 7&9)
I would recommend re-ordering the rows so that 7&9 become 6&7.

APPEND TO ARRAY ($aptr_HierarchyList; ->Column_1)
APPEND TO ARRAY ($aptr_HierarchyList; ->Column_2)
APPEND TO ARRAY ($aptr_HierarchyList; ->Column_3)
APPEND TO ARRAY ($aptr_HierarchyList; ->Column_4)
APPEND TO ARRAY ($aptr_HierarchyList; ->Column_5)
APPEND TO ARRAY ($aptr_HierarchyList; ->Column_6)
APPEND TO ARRAY ($aptr_HierarchyList; ->Column_7)
LISTBOX SET HIERARCHY(*;$vT_ListboxName;True;$aptr_HierarchyList->)

I also like to set the background colour of top level rows to a light grey
and set the font style to bold, using:

$vL_ColumnCount:=Size of array($aptr_HierarchyList->)
For ($vL_ColumnNum;1;$vL_ColumnCount)
   OBJECT SET RGB
COLORS($aptr_HierarchyList->{$vL_ColumnNum}->;$vL_BlackColour;$vL_LightGreyColour)
  OBJECT SET FONT STYLE($aptr_HierarchyList->{$vL_ColumnNum}->;Bold)
End for   //($vL_ColumnNum;1;$vL_ColumnCount)



Adam Bevan
Developer & CEO, Argus Productions Inc.




On Mon, 29 Jul 2019 at 16:47, Peter Mew via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Hi
> I havent used this kind of listbox before so a few pointers would be
> gratefully received.
> At the moment my listbox contains 9 columns, some hidden, some not.
> One of the arrays holds information as to whether a row is designated as
> "start" or "end"
> If a row is designated as "Start", columns 1,2,3,4,5,7.9 are populated the
> remaining columns are ""
> if a row is designtaed as "End", columns 6,8,9 are populated the remaining
> columns are ""
> I want the start columns to be the top level, and the end columns to be the
> second level of the hierarchy.
> So I can collapse the rows to show only the top level rows (starts), or
> expand the rows to show the top level rows with the second level rows
> underneath them, sorted in chronological order.
> Start
> End
> Start
> End
> ...
> Is what I'm asking even possible and if so how do I go about it.
> I considered using ListBox Set Row Height and setting the row height to 0,
> so as not to display it. but this command is not available in v13
> thanks for any help
>
> -pm
> 4D v13.6  Mac OS High Sierra
> **
> 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
> **
**
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: Selection-Based Listbox Sizing/Printing...

2019-07-12 Thread Adam Bevan via 4D_Tech 
You could print to a text var using the print variable frame. This
unfortunately does not work on listboxes... funny.
I agree that it would be a kluge.

When I print off data with listboxes I use Print Object instead of Print
Record. I have much finer control over where and what I print off.

Adam Bevan
Developer & CEO, Argus Productions Inc.
<https://www.facebook.com/ArgusProductions/>


On Fri, 12 Jul 2019 at 14:31, Robert ListMail via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Hi Adam, normally each list box will have a different number of rows, but
> typically in the 1-3 range. This page (tight with many other objects)
> contains several note fields below these list boxes and where they can grow
> as needed. Optimally it would be best if objects grew as needed and spilled
> onto a second page if needed.
>
> One thought I had would be to populate a TEXT var with the listbox data
> and set that to print variable frame… It seems like a kluge and that a
> better solution might be available.
>
> Thanks,
>
> Robert
>
>
> > On Jul 12, 2019, at 3:15 PM, Adam Bevan via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> > Hi Robert,
> >
> > I take it that listbox 1 could have more or less rows than listbox 2.
> > You would like to show each row of both listboxes.
> >
> > This would depend on the customer and if there is enough room on the page
> > to display all rows of both listboxes.
> >
> > You could limit the number of rows printed on the initial page, say 5
> rows.
> > If there are more than the 5 rows add a comment "continued on page X".
> > On page "X" you could then continue printing the listbox rows.
>
> **
> 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
> **
**
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: Stylesheet Search?

2019-07-12 Thread Adam Bevan via 4D_Tech 
Build a report.

Open each form using 'form load'.
Call 'form get objects' then call 'object get style sheet' for each object.


Adam Bevan
Developer & CEO, Argus Productions Inc.



On Fri, 12 Jul 2019 at 14:22, Robert ListMail via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Is there a way to search for a specific Stylesheet? I inherited a DB where
> many objects reference a blank stylesheet name. I guess I could create a
> stylesheet with a blank name but I’d prefer to find all of the objects that
> are referencing an non existent stylesheet.
>
> Thanks,
>
> Robert
> **
> 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
> **
**
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: Selection-Based Listbox Sizing/Printing...

2019-07-12 Thread Adam Bevan via 4D_Tech 
Hi Robert,

I take it that listbox 1 could have more or less rows than listbox 2.
You would like to show each row of both listboxes.

This would depend on the customer and if there is enough room on the page
to display all rows of both listboxes.

You could limit the number of rows printed on the initial page, say 5 rows.
If there are more than the 5 rows add a comment "continued on page X".
On page "X" you could then continue printing the listbox rows.

Adam Bevan
Developer & CEO, Argus Productions Inc.



On Fri, 12 Jul 2019 at 14:08, Robert ListMail via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> When printing a form with Print Record where you have two list boxes
> beside each other, how might you define the size of the listbox to
> accommodate all of the data in the selection?
>
> Thanks,
>
> Robert
> **
> 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
> **
**
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: Modelling graph image

2018-03-19 Thread Adam Bevan via 4D_Tech 
A few years ago I built my own graph method using the svg commands. It did all 
you’ve indicated but the coloured/symbol points. Though that would have been 
easy to add.

I did not use the graph command though.

Sent from my iPhone

> On Mar 17, 2018, at 3:43 AM, STARDATA via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi everyone!
> Is there any way which i can manipulate the result of the function GRAPH()
> to obtain a graphic similar to the mail attached? Are SVG commands somehow
> helpful? 
> What i wanna do is color the points over a certain value as you can see for
> those yellow points and give a color to a value limiter as shown in the
> image by the blue and green lines.
> 
> Many thanks to everyone will come in help!
> 
> Cheers!
> 
> 
> 
>  
> 
> 
> 
> --
> Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: User environment "List of Tables" Stuck - TeamViewer - Yech!

2017-07-14 Thread Adam Bevan via 4D_Tech 
Must be my problem too. Though it would only happen on my windows 10
machine.
My mac is unaffected by the issue.

Adam Bevan
Developer & CEO, Argus Productions Inc.



On 13 July 2017 at 21:07, Randy Engle via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> I seem to have found the culprit!:  TeamViewer
>
> A client wanted me to use this to access his system remotely.
>
> I was previously considering buying TeamViewer for our support (over
> Webex).
>
> What a giant PITB!
>
> Randy Engle
> XC2 Software LLC – XC2LIVE!
>
> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Randy
> Engle via 4D_Tech
> Sent: Thursday, July 13, 2017 7:58 PM
> To: '4D iNug Technical' <4d_tech@lists.4d.com>
> Cc: Randy Engle <4d.l...@xc2.us>
> Subject: User environment "List of Tables" Stuck - Arrrgghhh!!!
>
> Just today in the last hour or two:
>
> When viewing user environment, display the "List of Tables"
>
> It appears in the middle of the screen, small squarish window.
> Can't move it, can't enlarge it.
>
> Cant' scroll through list.
>
> Can select displayed tables, nothing else
>
> "List of Tables" menu item has no effect.
>
> Also, property list for any form is in the same state.
> Exactly Same location as Table List window, can't move it, resize it.
>
> Happens with any 4D DB,
> Created a new one.
> Used another instance of 4D
>
> Restarted machine, threw out "window bounds"  (This is v15r5 - Windows -
> been using this for a few months, no problem) Chanted Krishna, did the
> hokey-pokey, etc.
>
> Currently re-installing.
>
> WTF ???
>
> Any ideas, voodoo?
>
> Thanks
>
> Randy Engle
> XC2 Software LLC – XC2LIVE!
>
>
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
>
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**