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

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

Re: Empty 2D arrays - how to determine type

2017-06-01 Thread John DeSoi via 4D_Tech
This is what I used before Type worked correctly: C_LONGINT($0) C_POINTER($1) C_BLOB($blob) VARIABLE TO BLOB($1->{0}{0};$blob) //puts 5 bytes: BLVR+type $0:=$blob{4} John DeSoi, Ph.D. > On Jun 1, 2017, at 4:14 PM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I need to deter

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

2017-06-01 Thread Timothy Penner via 4D_Tech
It almost seems like you are doing the inverse of what is described here: http://kb.4d.com/assetid=48814 Try this: C_POINTER($ptr) ARRAY TEXT($My_Array;5;10) $ptr:=->$My_Array{1} My_Method ($ptr) -Tim ** 4D Internet Users Gro

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 Undefine

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 undef

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 Us

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

2017-06-01 Thread Chip Scheide via 4D_Tech
I have a pointer to a 2D array Array text($My_Array;5;10) $ptr:=->$My_Array I know that $ptr->{2} will reference the sub-array (of 10 elements) at element 2. I need to provide a pointer to this sub-array ex: My_Method(->($ptr->{1})) The above syntax does not seem to work, can someone help with

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://li

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 advan

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 disconc

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