Re: Data mining from Oracle Application using 4D

2017-06-01 Thread Bruno LEGAY via 4D_Tech 
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
**

Re: Empty 2D arrays - how to determine type

2017-06-01 Thread Kirk Brooks via 4D_Tech 
Chip,
I believe you can use the Type function on the zero array. Given ARRAY
LONGINT($aArray;0;0) you could call:

Type($array{0})

​and it will return Array longint. ​


On Thu, Jun 1, 2017 at 3:14 PM, Chip Scheide via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> I need to determine the type of a 2D array, which maybe empty (i.e.
> size 0 x 0), which is at the end of a pointer
> In the method where the 2D array is declared Type(My_Array{0}) returns
> 18 (Array text)
> BUT when the 2D array is passed via pointer (to a component)
> Type($ptr->{0}) returns undefined in an interpreted database.
>
> Any ideas??
> Example (note all typed in email):
> Array text(My_Array;0;0)
>
> $type:=Type(My_Array{0})  //$Type = 18 -- Array text
> My_method(->My_array)
>
> //My_Method
> c_pointer($1;$Array)
> c_longint($Type)
>
> $Array:=$1
> $Type:=Type($Array->)  //$Type = 13 -- Array 2D
>
> if ($Type= 13)
>   $Type:=Type($Array->{0})  //$Type = 5 (interpreted) -- Is Undefined
>   // WTF! ! ! !
> end if
>
>
> 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
> **




-- 
Kirk Brooks
San Francisco, CA
===

*The only thing necessary for the triumph of evil is for good men to do
nothing.*

*- Edmund Burke*
**
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: Empty 2D arrays - how to determine type

2017-06-01 Thread Keisuke Miyako via 4D_Tech 
F.Y.I.

Type() returns 18 in the subroutine as well, in v16.

it seems like you are pushing the limits of v13 in terms of generic coding.

> 2017/06/02 6:14、Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> のメール：
>
> if ($Type= 13)
>  $Type:=Type($Array->{0})  //$Type = 5 (interpreted) -- Is Undefined
>  // WTF! ! ! !
> end if




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

Empty 2D arrays - how to determine type

2017-06-01 Thread Chip Scheide via 4D_Tech 
I need to determine the type of a 2D array, which maybe empty (i.e. 
size 0 x 0), which is at the end of a pointer
In the method where the 2D array is declared Type(My_Array{0}) returns 
18 (Array text) 
BUT when the 2D array is passed via pointer (to a component) 
Type($ptr->{0}) returns undefined in an interpreted database.

Any ideas??
Example (note all typed in email):
Array text(My_Array;0;0)

$type:=Type(My_Array{0})  //$Type = 18 -- Array text
My_method(->My_array)

//My_Method
c_pointer($1;$Array)
c_longint($Type)

$Array:=$1
$Type:=Type($Array->)  //$Type = 13 -- Array 2D

if ($Type= 13)
  $Type:=Type($Array->{0})  //$Type = 5 (interpreted) -- Is Undefined
  // WTF! ! ! ! 
end if


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

v13+ - Method editor, lists

2017-06-01 Thread Chip Scheide via 4D_Tech 
Is there a way to permanently change what is displayed in the lists 
(lower section of method editor) when it is open?


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

2017-06-01 Thread info--- via 4D_Tech 
how abouts


Grüße/regards
Ortwin Zillgen
**
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
**

Data mining from Oracle Application using 4D

2017-06-01 Thread rooftop99--- via 4D_Tech 
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
**

Re: Macro anyone?

2017-06-01 Thread Chip Scheide via 4D_Tech 
Yeah.. I can imagine !

:)

On Wed, 31 May 2017 20:28:40 -0700, Robert Livingston wrote:
> – Boom, the method is sorted.
> 
> 
> **************
> *************
> 
> It can be a little disconcerting if you accidentally apply this Macro 
> to some random method. It will instantly turn into an alphabetized 
> mess. Fortunately, the Undo Command will restore its original state.
---
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: TEXT TO ARRAY won't break solid text

2017-06-01 Thread Don Lapin via 4D_Tech 
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).

Thanks,
Don


>Don Lapin:
>
>> Does anyone know how to measure the size of an unbroken text string,
>in a particular font, size, etc, such as --
>> 
>> But because TEXT TO ARRAY doesn't work on the codes, I get --
>
>
>I think this was one of the reasons I still use hmFree www.hmplugins.com/en/hmFree/Features-134.html>
>
>Greetings from Germany,
>Bernd Fröhlich
>**
>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
**

TEXT TO ARRAY won't break solid text

2017-06-01 Thread Bernd Fröhlich via 4D_Tech 
Don Lapin:

> Does anyone know how to measure the size of an unbroken text string, in a 
> particular font, size, etc, such as --
> 
> But because TEXT TO ARRAY doesn't work on the codes, I get --


I think this was one of the reasons I still use hmFree 


Greetings from Germany,
Bernd Fröhlich
**
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
**