Managing AV Vendors

[Sujit Shah via 4D_Tech]

Recently I have seen a growing number of support issues where the AV
software blocks the program or simply deletes the application folder itself
identifying it as a virus. The ones I have had most problems with are
Norton  and a Trend Micro. I submit my builds to them get it white listed
 but this has not helped much either.

All my builds are signed by Comodo but that only removes one of many
windows installation alerts.

I am not sure what makes other applications safe but not mine.

Is there anything else I can do?


-- 

xxx
"There must be ingenuity as well as intention, strategy as well as
strength. "
**
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
**

Re: v13+ What table does a set belong to?

[Jeremy French via 4D_Tech]

Hi Chip,

You could try performing a set operation on a known table set with the unknown 
set. 

If the two sets are from **different** tables, the set operation triggers an 
error. If both sets belong to the **same** table, no error occurs.

So iterate over each table performing the set operation until you encounter no 
error.

Something like this, which I tested before posting. It seems to work.:

C_LONGINT(error_i)
C_TEXT($known_empty_set)
C_TEXT($unknown_set_t)
C_BOOLEAN($done)
C_BOOLEAN($found)

$unknown_set_t:="unknown_set"
CREATE EMPTY SET([Storage];$unknown_set_t)

$known_empty_set:=Generate UUID
$table_i:=0
Repeat 

$table_i:=$table_i+1

CREATE EMPTY SET(Table($table_i)->;$known_empty_set)

ON ERR CALL("TRAP_ERROR")
error_i:=0
DIFFERENCE($unknown_set_t;$known_empty_set;$known_empty_set)
ON ERR CALL("")

If (error_i=0)
$found:=True
End if 
error_i:=0

If ($table_i=Get last table number)
$done:=True
End if 

CLEAR SET($known_empty_set)

Until ($done | $found)

If ($found)
ALERT("Set belongs to "+Table name($table_i)+".")
Else 
ALERT("Cannot determine table owning set.")
end if

- Jeremy French


> On Jun 2, 2017, at 5:22 PM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Is there *any* way to determine what table a random set belongs to?

**
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
**

Re: syntax : pointer to an element of a sub-array of 2D array

[Douglas von Roeder via 4D_Tech]

Tim:

Auto correct? Ah, OK, I'll give you that one. :-)


--
Douglas von Roeder
949-336-2902

On Fri, Jun 2, 2017 at 3:40 PM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com
> wrote:

> On Jun 2, 2017, at 5:24 PM,Douglas von Roeder  wrote:
>
> > On Fri, Jun 2, 2017 at 12:20 PM, Tim Nevels via 4D_Tech <
> > 4d_tech@lists.4d.com> wrote:
> >
> >> quest to master a nuisance of the 4D language regarding pointers.
> >
> > "nuisance" (S/B "nuance")
> >
> > Careful, there - that floor is slippery, Dr. Freud!  ;-)
>
> I curse thee oh Steve Jobs for providing us with auto-correct to make
> people say more stupid things than they normally would. :)
>
> Also a big thank you to Doug for breaking my balls on this one. :)
>
> I hope you are planning to attend 4D Summit 2018 in Washington DC. I’ll be
> there.
>
> Rumor has it that 4D v17 is going to be a game changing version.
>
> Tim
>
> 
> Tim Nevels
> Innovative Solutions
> 785-749-3444
> timnev...@mac.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
**

Re: syntax : pointer to an element of a sub-array of 2D array

[Tim Nevels via 4D_Tech]

On Jun 2, 2017, at 5:24 PM,Douglas von Roeder  wrote:

> On Fri, Jun 2, 2017 at 12:20 PM, Tim Nevels via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> quest to master a nuisance of the 4D language regarding pointers.
> 
> "nuisance" (S/B "nuance")
> 
> Careful, there - that floor is slippery, Dr. Freud!  ;-)

I curse thee oh Steve Jobs for providing us with auto-correct to make people 
say more stupid things than they normally would. :)

Also a big thank you to Doug for breaking my balls on this one. :)

I hope you are planning to attend 4D Summit 2018 in Washington DC. I’ll be 
there. 

Rumor has it that 4D v17 is going to be a game changing version. 

Tim


Tim Nevels
Innovative Solutions
785-749-3444
timnev...@mac.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
**

Re: [off] Textwrangler

[Ronald Rosell via 4D_Tech]

Sweet!  I’d been using Printfolder for this, with mixed results. 

I also found that you could copy the Textwrangler document into a spreadsheet 
in NeoOffice and it’ll retain the formatting:  subfolders in column B, file 
names in Column C, etc.
__

Ron Rosell
President
StreamLMS


> On Jun 2, 2017, at 1:47 PM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I accidentally dragged a folder into blank document.
> 
> Text wrangler then proceeded to give me a complete directory listing of 
> the folder, and all of its sub folders
> as text
> Cr delimted
> 
> Chip
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing 
> **
> 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
**

Re: Feature request : Set Belongs to (Setname) -> table reference

[Douglas von Roeder via 4D_Tech]

Chip:

Added my vote.

--
Douglas von Roeder
949-336-2902

On Fri, Jun 2, 2017 at 2:37 PM, Chip Scheide via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> test of feature request:
> A useful function would be to be able to determine what table a set
> belongs to.
> I.e. Does the Set "My_Set" contain records from [Table1], [Table2],
> [Table...], [TableN]
>
> This would help to eliminate issues with (accidentally) trying to do
> set manipulations on sets from different tables.
>
> I envision, as I put in the title
> Set Belongs to (Setname) -> table reference of some sort (pointer,
> table number, etc)
>
> 4D (the software), internally "knows" which set(s) belong to which
> table.
> Why can't we, developers, see this information?
>
> link to vote:
> http://forums.4d.fr/Post//19505952/1/
>
> hope someone like the idea
>
> Chip
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing
> **
> 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
**

Re: [off] Textwrangler

[Jeffrey Kain via 4D_Tech]

Nice...

> On Jun 2, 2017, at 4:47 PM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I accidentally dragged a folder into blank document.
> 
> Text wrangler then proceeded to give me a complete directory listing of 
> the folder, and all of its sub folders
> as text
> Cr delimted

**
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
**

[off] Textwrangler

[Chip Scheide via 4D_Tech]

I accidentally dragged a folder into blank document.

Text wrangler then proceeded to give me a complete directory listing of 
the folder, and all of its sub folders
as text
Cr delimted

Chip
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
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
**

Re: syntax : pointer to an element of a sub-array of 2D array

[Garri Ogata via 4D_Tech]

Greetings,

Using Get pointer is another way of doing as well.

C_LONGINT($iField;$iTable;$iColumn)
C_TEXT($t2DAName;$tWorld;$t2DAColumn)
C_POINTER($p2DA;$pCol2)

ARRAY TEXT($at2D;3;3)
ARRAY TEXT($atCol2;0)

$at2D{2}{1}:="hello"
$at2D{2}{2}:="world"
$at2D{2}{3}:="by"

$pat2D:=->$at2D

RESOLVE POINTER($pat2D;$t2DAName;$iTable;$iField)

$iColumn:=2
$t2DAColumn:=$t2DAName+"{"+String($iColumn)+"}"

$pCol2:=Get pointer($t2DAColumn)

$tWorld:=$pCol2->{2}




From: 4D_Tech <4d_tech-boun...@lists.4d.com> on behalf of Chip Scheide via 
4D_Tech <4d_tech@lists.4d.com>
Sent: Friday, June 2, 2017 7:55 PM
To: 4D iNug Technical
Cc: Chip Scheide; Tim Nevels
Subject: Re: syntax : pointer to an element of a sub-array of 2D array

I understand your thinking  :)

but...
as this is going to be in a (compiled - I hope) component, I need to
validate the hell out of the parameters, ESPECIALLY, pointers; as
conceptually the component will be a black box.

Input (via method call) -> component -> result

actually the problems of Type testing the 2D array, and referencing 1
dimension of the 2D array WILL STILL exist even if I use 2 methods.

In many cases I can let 4D type manage parameters for me. If I define a
longint, or text as a parameter 4D will insure that that is what I will
get in the component. However, with a pointer, what does the pointer
point to?
an array, a text variable, (not in v13, but eventually) a C_Object, a
listbox etc...
So, type validation  of the item being pointed to is needed.


In the specific instance, I will have unto 3 pointers to either arrays
or to 2D arrays. I can test Array vs 2D Array, BUT since 4D does not
give us a Type test for 2D arrays (might be a feature request) that
still does not validate the type of the 2D array, Pointer, text,
longing, some other (completely) invalid type. I have found (just not
posted to other thread yet) that Type will indeed return the correct
value when I test the type of 1 dimension of a 2D array, even though a
pointer.

However, that does not resolve, and I will still have to deal with, the
issue of referencing a sub-array of a 2D array through a pointer (this
thread). As I will have to resize each array element of the 2D array to
match the field counts for the corresponding table.

However, as I recently posted I have found a functional workaround,
Thanks to Keisuke, COPY ARRAY.

Finally :
> I totally understand if this has now become a quest to master a nuisance of
the 4D language regarding pointers.
Yes  :)
Well not master so much as determine it is indeed a limitation of 4D.

Chip
On Fri, 02 Jun 2017 14:20:00 -0500, Tim Nevels via 4D_Tech wrote:
>
> Here’s a crazy idea. Just provide 2 methods instead of 1 and skip all
> the parameter type validation.
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
lists.4d.com
lists.4d.com
Information about the 4D Tech Mailing List <4D_Tech@lists.4D.com>, 4D Biz 
Mailing List <4d_...@lists.4d.com>, and 4D Pub Mailing List 
<4d_...@lists.4d.com ...



Archive:  http://lists.4d.com/archives.html
4D Mailing List Archives - lists.4d.com Mailing 
Lists
lists.4d.com
4D Mailing List Archives. 4D has a rich history of community participation on 
our email lists. The email list archives provide a wealth of shared information 
and ...



Options: http://lists.4d.com/mailman/options/4d_tech
[http://lists.4d.com/images/mailman/gnu-head-tiny.jpg]

4D_Tech list: member options login 
page
lists.4d.com
Unsubscribe: By clicking on the Unsubscribe button, a confirmation message will 
be emailed to you. This message will have a link that you should click on to ...



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
**

Feature request : Set Belongs to (Setname) -> table reference

[Chip Scheide via 4D_Tech]

test of feature request:
A useful function would be to be able to determine what table a set 
belongs to.
I.e. Does the Set "My_Set" contain records from [Table1], [Table2], 
[Table...], [TableN]

This would help to eliminate issues with (accidentally) trying to do 
set manipulations on sets from different tables.

I envision, as I put in the title
Set Belongs to (Setname) -> table reference of some sort (pointer, 
table number, etc)

4D (the software), internally "knows" which set(s) belong to which 
table.
Why can't we, developers, see this information?

link to vote:
http://forums.4d.fr/Post//19505952/1/

hope someone like the idea

Chip
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
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
**

v13+ What table does a set belong to?

[Chip Scheide via 4D_Tech]

Is there *any* way to determine what table a random set belongs to?

Thanks
Chip
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
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
**

Re: syntax : pointer to an element of a sub-array of 2D array

[Arnaud de Montard via 4D_Tech]

> Le 2 juin 2017 à 20:56, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> a 
> écrit :
> 
> [...]
> Table and Field numbers
> Table and Field pointers

Just a suggestion, a "combo" makes possible to code fields in a single longint 
in place of pointers or pair of numbers table+field. Nice to put a field 
reference in json, for example.  

• decimal offset
  $combo_l:=($tableNumber*10)+$fieldNumber
...
  $tableNumber:=$combo_l\10
  $fieldNumber:=$combo_l%10

• bit offset
  $combo_l:=($tableNumber << 16) + $fieldNumber
...
  $tableNumber:=$combo_l >> 16
  $fieldNumber:=$combo_l & 0x

For my own I prefer the 1st, easier to read… and I don't feel concerned by max 
for table and field number - 32767  ;-)

-- 
Arnaud de Montard 



**
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
**

Re: syntax : pointer to an element of a sub-array of 2D array

[Douglas von Roeder via 4D_Tech]

On Fri, Jun 2, 2017 at 12:20 PM, Tim Nevels via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> quest to master a nuisance of the 4D language regarding pointers.



"nuisance" (S/B "nuance")

Careful, there - that floor is slippery, Dr. Freud!  ;-)


--
Douglas von Roeder
949-336-2902
**
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
**

Re: syntax : pointer to an element of a sub-array of 2D array

[Chip Scheide via 4D_Tech]

I understand your thinking  :)

but...
as this is going to be in a (compiled - I hope) component, I need to 
validate the hell out of the parameters, ESPECIALLY, pointers; as 
conceptually the component will be a black box. 

Input (via method call) -> component -> result

actually the problems of Type testing the 2D array, and referencing 1 
dimension of the 2D array WILL STILL exist even if I use 2 methods.

In many cases I can let 4D type manage parameters for me. If I define a 
longint, or text as a parameter 4D will insure that that is what I will 
get in the component. However, with a pointer, what does the pointer 
point to?
an array, a text variable, (not in v13, but eventually) a C_Object, a 
listbox etc...
So, type validation  of the item being pointed to is needed.


In the specific instance, I will have unto 3 pointers to either arrays 
or to 2D arrays. I can test Array vs 2D Array, BUT since 4D does not 
give us a Type test for 2D arrays (might be a feature request) that 
still does not validate the type of the 2D array, Pointer, text, 
longing, some other (completely) invalid type. I have found (just not 
posted to other thread yet) that Type will indeed return the correct 
value when I test the type of 1 dimension of a 2D array, even though a 
pointer.

However, that does not resolve, and I will still have to deal with, the 
issue of referencing a sub-array of a 2D array through a pointer (this 
thread). As I will have to resize each array element of the 2D array to 
match the field counts for the corresponding table.

However, as I recently posted I have found a functional workaround, 
Thanks to Keisuke, COPY ARRAY.

Finally :
> I totally understand if this has now become a quest to master a nuisance of 
the 4D language regarding pointers.
Yes  :)
Well not master so much as determine it is indeed a limitation of 4D.

Chip
On Fri, 02 Jun 2017 14:20:00 -0500, Tim Nevels via 4D_Tech wrote:
> 
> Here’s a crazy idea. Just provide 2 methods instead of 1 and skip all 
> the parameter type validation. 
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
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
**

Re: syntax : pointer to an element of a sub-array of 2D array

[Tim Nevels via 4D_Tech]

On Jun 2, 2017, at 2:00 PM,Chip Scheide wrote:

> Maybe I am too ambitious...
> 
> (from Host)
> 
> Build_Table_Arrays(->$Table_Names_array;->$Table_num_array;->$Table_Pointer_array)
> This call would build 1D arrays with the (respectively) table names 
> (formatted for users), Table numbers, and pointers to the tables.
> 
> The 'trick' is that I want to allow a slightly different call to the 
> same component method
> 
> Build_Table_Arrays(->$Struct_Names_array;->$Struct_num_array;->$Struct_Pointer_array)
> Where $Struct_ is a 2D array which will contain not only Table, but 
> also field information; so the resulting arrays would contain 
> (respectively) ALL table and field names (formatted for the users), ALL 
> Table and Field numbers, and pointers to ALL tables and Fields.
> 
> And this is where the dereferencing a pointer to a 2D array, sub-array 
> access problem is occurring, inside the component method and it's 
> internal method calls for parameter validation (my post on Type issue), 
> and for resizing the sub-array(s) for field information (this post).
> 
>   
> *Of course* 
>  
> the methods in the component that do type validation, and array 
> resizing ALL require pointers as parameters, because these methods are 
> themselves ALSO exposed as part of the Utility component package I am 
> trying to create   :)
> 
> ... and now my head hurts again...

Here’s a crazy idea. Just provide 2 methods instead of 1 and skip all the 
parameter type validation. 

Build_Table_Arrays(->$Table_Names_array;->$Table_num_array;->$Table_Pointer_array)
Build_Struct_Arrays(->$Struct_Names_array;->$Struct_num_array;->$Struct_Pointer_array)

Then there is no need to test for the array type pointer. As an intelligent 
programmer you will always use the correct method name depending on if you are 
passing a 1D array pointer or a 2D array pointer. Right? :)

Problem solved. Workaround found. Life continues on. Head will no longer hurt. 

I totally understand if this has now become a quest to master a nuisance of the 
4D language regarding pointers. It’s a tricky area for sure when dealing with 
2D arrays. Sure it’s always best to "validate the hell out of” all parameters. 
But sometimes the answer is to just not ask the question. Like the old saying 
“Doctor it hurts when I move my arm this way.” And the doctor replies “well, 
don’t move your arm that way”. :)

Tim


Tim Nevels
Innovative Solutions
785-749-3444
timnev...@mac.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
**

Re: syntax : pointer to an element of a sub-array of 2D array

[Chip Scheide via 4D_Tech]

Yep :)

I am not sure... Does this work in newer versions of 4D, or is this 
something that should be entered as a bug?
Array text(My_2D-Array;5;10)
c_pointer($ptr;$ptr2)
$ptr:=->My_2D_Array

$ptr2:=->$ptr->{1}  // <- this fails : Field variable or table expected
$ptr2:=->($ptr->{1}) // this fails : Field variable or table expected
$test:=$ptr->{1}  // as expected this gets the value of the array at 
$ptr->{1} element zero

I found a solution (workaround actually)
- As Keisuke suggested COPY ARRAY will resolve the specific 
problem.(Implemented)

So:
// method to get table names etc
// For each table - get table info and if appropriate get field info

COPY ARRAY($Name_Array->{$i};$Temp_Names) 
   //$Name_Array is a pointer to a 2D Text array 
   //$Temp_Names is a 1D Text array
utl_struct_Field_Arrays ($i;->$Temp_Names) //populate Temp array with 
field names for table $i
COPY ARRAY($Temp_Names;$Name_Array->{$i}) // copies the temp array to 
the correct place in 2D array


The actual method allows the creation of upto 3 2D arrays, at the same 
time, for table information
Table & Field names
Table and Field numbers
Table and Field pointers


THANKS Everyone for the help


On Fri, 2 Jun 2017 14:58:33 +, Keisuke Miyako via 4D_Tech wrote:
> sometimes its much easier to simply COPY ARRAY the whole array and back.
> 
>> 2017/06/02 22:46、Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> の
>> メール：
>> 
>> And this is where the dereferencing a pointer to a 2D array, sub-array
>> access problem is occurring, inside the component method and it's
>> internal method calls for parameter validation (my post on Type issue),
>> and for resizing the sub-array(s) for field information (this post).
> 
> 
> 
> 
> **
> 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
> **
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
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
**

Re: Data mining from Oracle Application using 4D

[Chuck Miller via 4D_Tech]

We are using native 4d sql and odbc works like a charm. On Mac we are using 
actual technologies oracle driver.

Regards

Chuck

 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 Jun 2, 2017, at 1:05 PM, Benedict, Tom via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Rooftop99 says:
> 
> 
> 
>> I have a large Oracle database from which I need to regularly extract 
>> specific data using a 4D
> 
>> application.  Is there a preferred way to connect the two for data mining?  
>> ODBC, or ???
> 
>> Anyone doing this with success and willing to share the connection 
>> architecture?
> 
> I only have experience connecting 4D with SQL Server, not Oracle, so there 
> may be some platform specific considerations, but I'm thinking you could 
> simply use 4D native SQL commands to connect and call a stored procedure in 
> Oracle. You would need to set up DSN on the client side for the Oracle 
> connection.. The extracted data would populate arrays in 4D.
> 
> If the queries are ad hoc and need to change, you might better off with a 
> Oracle or SQL specific plugin, but if you aren't doing Inserts or Updates in 
> Oracle I think native 4D SQL should meet your needs.
> 
> HTH,
> 
> Tom Benedict
> Optum
> 
> This e-mail, including attachments, may include confidential and/or
> proprietary information, and may be used only by the person or entity
> to which it is addressed. If the reader of this e-mail is not the intended
> recipient or his or her authorized agent, the reader is hereby notified
> that any dissemination, distribution or copying of this e-mail is
> prohibited. If you have received this e-mail in error, please notify the
> sender by replying to this message and delete this e-mail immediately.
> **
> 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
**

Re: Data mining from Oracle Application using 4D

[Benedict, Tom via 4D_Tech]

Rooftop99 says:



>I have a large Oracle database from which I need to regularly extract specific 
>data using a 4D

>application.  Is there a preferred way to connect the two for data mining?  
>ODBC, or ???

>Anyone doing this with success and willing to share the connection 
>architecture?

I only have experience connecting 4D with SQL Server, not Oracle, so there may 
be some platform specific considerations, but I'm thinking you could simply use 
4D native SQL commands to connect and call a stored procedure in Oracle. You 
would need to set up DSN on the client side for the Oracle connection.. The 
extracted data would populate arrays in 4D.

If the queries are ad hoc and need to change, you might better off with a 
Oracle or SQL specific plugin, but if you aren't doing Inserts or Updates in 
Oracle I think native 4D SQL should meet your needs.

HTH,

Tom Benedict
Optum

This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity
to which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.
**
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
**

Re: 4D web server protected by a proxy server - pdfs don't come through

[Jim Hays via 4D_Tech]

It turns out the blocked/corrupted PDFs were caused by Cisco Meraki
firewall malware protection when they traveled from LAN to DMZ.

On Wed, May 31, 2017 at 6:23 PM, Jim Hays  wrote:

> Yes.  Most answers say something like replace (pseudo code)
> target="_blank" with target="_document", and make it download instead of
> display in browser.  It has the same problem though.
> I few messages said there was a bug in Chrome some years ago, but this
> happens with multiple browsers.
>
> Tomorrow I'm hoping the IT person will turn off the firewall and
> anti-virus temporarily and we'll see if that makes a difference.
>
> Thanks,
>
> Jim
>
> On Wed, May 31, 2017 at 6:12 PM, Keisuke Miyako via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
>> did you Google for that error message?
>>
>> 2017/06/01 6:52、Jim Hays via 4D_Tech <4d_tech@lists.4d.com> d_t...@lists.4d.com>> のメール：
>> "Resource interpreted as Document but transferred with MIME type
>> application/pdf"
>>
>>
>>
>> **
>> 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
**

Re: syntax : pointer to an element of a sub-array of 2D array

[Keisuke Miyako via 4D_Tech]

sometimes its much easier to simply COPY ARRAY the whole array and back.

> 2017/06/02 22:46、Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> のメール：
>
> And this is where the dereferencing a pointer to a 2D array, sub-array
> access problem is occurring, inside the component method and it's
> internal method calls for parameter validation (my post on Type issue),
> and for resizing the sub-array(s) for field information (this post).




**
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
**

Re: Data mining from Oracle Application using 4D

[Pat Bensky via 4D_Tech]

Mac or Windows? If you're on a Mac, check out the Actual ODBC drivers:
http://www.actualtech.com/products.php

Pat

On 1 June 2017 at 18:47, rooftop99--- via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> Hi All,
>
> I have a large Oracle database from which I need to regularly extract
> specific data using a 4D application.  Is there a preferred way to connect
> the two for data mining?  ODBC, or ???  Anyone doing this with success and
> willing to share the connection architecture?  Many thanks in advance...
>
> Kirk
> **
> 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
> **




-- 
*
CatBase - The Database Publishing Solution
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*
**
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
**

Re: syntax : pointer to an element of a sub-array of 2D array

[Chip Scheide via 4D_Tech]

Everyone who has replied so far.
Thanks

I am still struggling with this, but I am now closer, and have some 
direction, I'll report back my final solution.

The actual implementation I am working on is :
In a component, a method which can build 1 or more arrays of table and 
field information from the structure of the host.
Maybe I am too ambitious...

(from Host)
  
Build_Table_Arrays(->$Table_Names_array;->$Table_num_array;->$Table_Pointer_array)
This call would build 1D arrays with the (respectively) table names 
(formatted for users), Table numbers, and pointers to the tables.

The 'trick' is that I want to allow a slightly different call to the 
same component method
  
Build_Table_Arrays(->$Struct_Names_array;->$Struct_num_array;->$Struct_Pointer_array)
Where $Struct_ is a 2D array which will contain not only Table, but 
also field information; so the resulting arrays would contain 
(respectively) ALL table and field names (formatted for the users), ALL 
Table and Field numbers, and pointers to ALL tables and Fields.

And this is where the dereferencing a pointer to a 2D array, sub-array 
access problem is occurring, inside the component method and it's 
internal method calls for parameter validation (my post on Type issue), 
and for resizing the sub-array(s) for field information (this post).

  
*Of course* 
 
the methods in the component that do type validation, and array 
resizing ALL require pointers as parameters, because these methods are 
themselves ALSO exposed as part of the Utility component package I am 
trying to create   :)

... and now my head hurts again...
:)

Thanks
Chip




---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
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
**

Re: v13+ - Method editor, lists

[Chip Scheide via 4D_Tech]

Arnaud,
Thanks

I use the lists - very occasionally, for reference to Konstant values, 
mostly for Field/variable type values.
i.e. Type(My_Pointer ->) = 12  // <- what the hell does 12 mean?

I think your ideas about additional use for the 'lists area' is a good 
one -- I'd vote for it ;)

On Fri, 2 Jun 2017 10:19:06 +0200, Arnaud de Montard via 4D_Tech wrote:
> 
>> Le 1 juin 2017 à 22:57, Chip Scheide via 4D_Tech 
>> <4d_tech@lists.4d.com> a écrit :
>> 
>> Is there a way to permanently change what is displayed in the lists 
>> (lower section of method editor) when it is open?
> 
> In the current method, set it as you like then use menu Method/save 
> as template 
> 
> 
> I don't use lists since a while… what do you use them for? 
> 
> I wish the bottom zone could display/edit these:
> • method properties (execute on server, shared between component and 
> host, etc. 
> • the very missing last modification date/user
> • method comments (more natural than input through explorer IMHO)
> • path of the current method in explorer home page
> • resource folder items (drag'n drop to code)
> …
>  (french)
> 
> -- 
> Arnaud de Montard 
> 
> 
> 
> 
> **
> 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
> **
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
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
**

Re: syntax : pointer to an element of a sub-array of 2D array

[Arnaud de Montard via 4D_Tech]

> Le 1 juin 2017 à 22:10, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> a 
> écrit :
> 
> I have a pointer to a 2D array
> Array text($My_Array;5;10)
> $ptr:=->$My_Array
> [...]
> The above syntax does not seem to work, can someone help with syntax?

Turnarounds I could find (execute formula, Get pointer, plugins…) always failed 
in some particular situation (compiled, component, etc.). While considering a 
2D array is a collection of 1D arrays (columns) is safe:

• pass one column:

array text($data_a2t;5;10)
myMethod(->$data_a2t{2})

• pass all columns:

array text($data_a2t;5;10)
array pointer($arr2Dcolumn_ap;0)
for($i;1;size of array($data_a2t))
 append to array($arr2Dcolumn_ap;->$data_a2t{$i})
end for
myMethod(->$arr2Dcolumn_ap)

-- 
Arnaud de Montard 



**
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
**

Re: TEXT TO ARRAY won't break solid text

[Arnaud de Montard via 4D_Tech]

> Le 1 juin 2017 à 13:09, Don Lapin via 4D_Tech <4d_tech@lists.4d.com> a écrit :
> 
> Hi Bernd,
> 
> I got an email back from 4D support; the contact thinks that there is a bug 
> in that command, and filed ACI0096891. But of course I don't know if they are 
> going to fix it in v14. 
> 
> I'm waiting on hmplugins to send a license number for hmFree...would like to 
> use the command that returns text length (I'm guessing it's in pixels).

Vincent de Lachaux wrote a "text to array" using SVG, it is somewhere in SVG 
demo. There's also a "formatted string length" in it, AFAICR. 

-- 
Arnaud de Montard 


**
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
**

Re: v13+ - Method editor, lists

[Arnaud de Montard via 4D_Tech]

> Le 1 juin 2017 à 22:57, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> a 
> écrit :
> 
> Is there a way to permanently change what is displayed in the lists 
> (lower section of method editor) when it is open?

In the current method, set it as you like then use menu Method/save as template 


I don't use lists since a while… what do you use them for? 

I wish the bottom zone could display/edit these:
• method properties (execute on server, shared between component and host, etc. 
• the very missing last modification date/user
• method comments (more natural than input through explorer IMHO)
• path of the current method in explorer home page
• resource folder items (drag'n drop to code)
…
 (french)

-- 
Arnaud de Montard 




**
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
**

Re: Data mining from Oracle Application using 4D

[rooftop99--- via 4D_Tech]

Thank you Bruno,

I will contact you direct for more information about your component.  Is it 
compatible with v16.R2 Windows Server/Client?   


Kirk

> On Jun 1, 2017, at 10:24 PM, Bruno LEGAY via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi Kirk,
> 
>> I have a large Oracle database from which I need to regularly extract 
>> specific data using a 4D application.  Is there a preferred way to connect 
>> the two for data mining?  ODBC, or ???  Anyone doing this with success and 
>> willing to share the connection architecture?  Many thanks in advance...
> 
> I will say it will depend..
> 
> It depends where you want to implement your business logic (Oracle side or 4D 
> side), 
> it depends on the volume of data you need to process (extracting a large 
> amount of data to summarize it into a small amount of data would be faster if 
> you do it on Oracle server side, no point moving data around in this case)
> etc... 
> 
> To achieve the best performance/speed/flexibility, I would say 4D for OCI is 
> the way to go (but I may be biased ;-)).
> It requires Oracle client libraries being installed on the client side and 
> the 4D for OCI plugin.
> So if deploying the Oracle client libraries is not an issue for you this is 
> the way to go.
> 
> OCI is a C API from Oracle (Oracle Call Interface).
> 4D for OCI will give you access to the Oracle OCI API (and it will take care 
> of memory management and type conversion for you).
> 4D for OCI coding can be a bit challenging at times. There is plenty of 
> documentation for the Oracle OCI api (with C code samples) and then you have 
> to apply that information to 4D for OCI.
> 
> The Oracle client libraries are available on Mac OS X and Windows.
> 
> 
> We do sell a component to make 4D for OCI coding very simple and optimized 
> (as well as provide retrocompatibility with the old "4D for Oracle").
> Contact us privately if you are interested or if you need 
> help/coaching/training on 4D for OCI.
> 
> 
> For ODBC, you will also need to deploy Oracle client libraries AFAIK.
> 
> 
> HTH 
> Bruno
> 
> **
> 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
**