Re: 4D mobile connector for Wakanda

[Sannyasin Siddhanathaswami]

Miguel,

4D does, but I’ve found Wakanda uses up “seats” faster than expected, but this 
may not be your issue. And sorry, I forget where to check to see if this is 
actually the error. I suspect its in the browser debugger/console (such as 
Firebug). I’m by no means an expert in this. Hopefully someone else will help 
you, otherwise, I’d contact 4D. They might be able to help you get a demo 
running.

--
Sannyasin Siddhanathaswami

On October 3, 2016 at 9:36:45 PM, Miguel Gonzalez 
(magonza...@gmail.com) wrote:

Thank you Sannyasin for your answer.

I thought 4D allows to test 4D mobile and licences will not be an issue.

Regards

Miguel Gonzalez

On 3 October 2016 at 22:53, Sannyasin Siddhanathaswami  wrote:
> I’ve run into a similar issue with not enough licenses for 4D Mobile, or 
> licenses that exist are used up. You might try restarting both 4D and Wakanda 
> to try to get the seats back.
>
> --
> Sannyasin Siddhanathaswami
> **
> 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
> **



--
Miguel Gonzalez
AcuBase Ltd.
**
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: [WOW!] Find in Array discovery

[Douglas von Roeder]

Chip:

Hmm…

Find in array with pointer arrays was introduced quite some time ago.

That was one of the new features in 2.2.3 or it *could* have been a feature
in V3. I think it was V2 because I was working on a project where I really
needed that functionality (GANTT charts in AreaList Pro!!) and that project
never saw the light of day with 4D Server/4D Client.



--
Douglas von Roeder
949-336-2902

On Tue, Oct 4, 2016 at 1:30 PM, Chip Scheide <4d_o...@pghrepository.org>
wrote:

> Given an array of pointers (in this case pointers to fields)
>
> Find in Array will find a pointer to the a field, if it exists, in the
> array!
>
> Ex:
> using Get Listbox Arrays, on a selection listbox, we populate
> aryptr_Column_Vars with pointers to the fields being displayed.
> We populate $My_Pointer with a pointer to one of the fields
> $My_Pointer := ->[Taale1]Field1
>
> (assuming [Table1]Field1 is displayed in the listbox)
>
> Find In Array(aryptr_Column_Vars;$My_Pointer) returns the location
> (column number) of the field pointer in the array
>
> Chip
> **
> 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
**

[WOW!] Find in Array discovery

[Chip Scheide]

Given an array of pointers (in this case pointers to fields)

Find in Array will find a pointer to the a field, if it exists, in the 
array!

Ex:
using Get Listbox Arrays, on a selection listbox, we populate 
aryptr_Column_Vars with pointers to the fields being displayed.
We populate $My_Pointer with a pointer to one of the fields
$My_Pointer := ->[Taale1]Field1

(assuming [Table1]Field1 is displayed in the listbox)

Find In Array(aryptr_Column_Vars;$My_Pointer) returns the location 
(column number) of the field pointer in the array

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

Mac Pro Server Memory Suggestion...

[Robert ListMail]

I have a new client running 4D v11 Server on 2008 (3,1) Mac Pro and I’m 
updating their database to v15…  The current server has 4GBs of ram, I was 
going to upgrade them to 16GBs. If I keep the existing modules, I would upgrade 
them to 12GB or 20GB if I fill all of the slots. Any suggestions? Would I 
likely notice the 20GB memory availability?

Thanks,

Robert

**
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: Version hell on Mac

[Peter Jakobsson]

On 4 Oct 2016, at 20:18, Benedict, Tom  wrote:

> Do you happen to know whether this will cause the On Saving Existing Record 
> Event Trigger Event to occur?

I’m afraid I don’t - good question.

I would imagine not. If it ran trigger code it could screw everything so I 
presume 4D makes it run at a lower level.

Peter

**
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: Memory usage of client when running alongside server

[Alan Tilson]

Hello Jeff,
I am thinking of trying something like what you were testing back in 2014
so I'd love to hear how it has gone the last couple of years?
Thanks,
Alan

On Sun, Nov 2, 2014 at 9:01 PM, Jeffrey Kain  wrote:

> I’m doing some experiments with running network-intensive client
> applications alongside 4D Server as opposed to running them traditionally
> on a dedicated client on the LAN. My performance results are unequivocal -
> I’m seeing about a 2.5x performance increase when running client alongside
> server, as opposed to running client on the gigabit Ethernet LAN.
>
> In addition to the raw performance improvement of these dedicated client
> applications, the entire system benefits since the data required by these
> clients doesn’t saturate the network.
>
> Sounds great, right? There are two troubling observations, however. Since
> moving to this configuration, I’ve noticed:
>
> 1. Client memory usage on these workstations running next to the server
> increases linearly over time. By linearly, I mean that if I plot memory
> usage over time I get a perfectly straight line. I find it hard to believe
> that the application uses memory like this given the eb and flow of how the
> system is used (peak times, dead times, etc.). It looks like a memory leak,
> but I hate to throw that term around. Eventually I have to restart these
> clients when they get close to the 2GB limit.
>
> 2. Server memory usage increases much faster when I have a few of these
> local clients running than when I don’t. The server has something like 80GB
> of cache memory allocated, and prior to testing this configuration it would
> take well over 30-45 to fill the cache. Now it happens in just 10-12 days.
>
> 3. The server has hung twice in the last 6 weeks (i.e. stopped processing
> data but not crashing per se). Prior to this configuration, the server was
> very stable.
>
> I realize that correlation does not imply causation, but I’m wondering if
> anyone else has experimented with this kind of configuration and if you’ve
> observed anything similar?
>
> Thanks!
>
> Jeff
>
>
> P.S. - The environment is as follows:
>
> Server: Windows Server Enterprise 2008 R2, 192 GB RAM, 1 TB PCIe SSD RAID
> array
> 4D Server: 13.5 (also tested 13.4), 64-bit, 78GB allocated to cache, ~110
> users/900-1100 processes
> Data: 90GB, Index 18GB
> Clients: All Windows 7
> v
> —
> Jeffrey Kain
> Senior Laboratory System Architect
> Health Diagnostic Laboratory, Inc.
>
>
> **
> See how easy it is to extend your 4D solutions to Web and mobile. New
> opportunities await you with 4D v14!
>
> 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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: settings.4DSettings

[Alberto Bachler]

Bob,

Database settings are stored inside the structure file, unless you activate the 
option "Enable User Settings in External File”  in the Security Tab. More info 
in 
http://livedoc.4d.com/4D-Design-Reference-13.4/Database-Settings/Using-user-settings.300-1226542.en.html
 


Alberto.


> El 04-10-2016, a las 12:10, bob.mil...@parker.com escribió:
> 
> Hello Everyone,
> 
> I'm trying to find out where 4D Server stores settings such as port 
> number, memory settings, etc. - at first I thought this was in 
> settings.4DSettings, but in my settings.4Dsettings file there is only a 
> "Automatic_session_management" item.
> 
> The settings.4Dsettings file is mentioned in the Design Reference, but it 
> does not have any schema for what can/should be in it.
> 
> Is there additional documentation on this file?
> 
> Am I correct in that port number and memory settings are stored in an 
> external file?
> 
> Many thanks,
> 
> 
> Bob Miller
> Chomerics, a division of Parker Hannifin Corporation
> 
> 
> 
> **
> 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: Version hell on Mac

[Benedict, Tom]

Peter Jakobsson writes:

>Paul, here's that code snippet. I found it.

>  // Ortwin Zilgen code for instantly upgrading primary keys in a post v13 
> database (Works !)
>
>C_LONGINT($i;$P_SIZE)
>C_TEXT($tableName_t)
>
>$fieldName:="pkUUID"
>
>$P_SIZE:=Get last table number
>
>For ($i;1;$P_SIZE)
>If (Is table number valid($i))
>
>$tableName_t:=Table name($i)
>$statement_t:="ALTER TABLE ["+$tableName_t+"] ADD "+$fieldName+" UUID 
>AUTO_GENERATE PRIMARY KEY;"
>
>Begin SQL
>EXECUTE IMMEDIATE:$statement_t;
>End SQL

>End if
>End for

Do you happen to know whether this will cause the On Saving Existing Record 
Event Trigger Event to occur?

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: Working on a specific xliff file

[Peter Bozek]

On Tue, Oct 4, 2016 at 6:44 PM, Andrea Angeli  wrote:

> Is it possible to read a specific xliff file using Get indexed string. My
> idea is to use the xliff file with the Web Server so if you choose to read
> a page in a specific language I can load menù and buttons in the
> appropriate xliff file and get the translation.
>

AFAIK, you cannot. It is not a good idea to have group with the same ID in
several files.

I would rather do something like having different offset for different
languages (like en:10 000 - 10 999, de: 11 000 - 11 999, es: 12 000 - 12
999 etc.) Different languages can still have different XLF files.


-- 

Peter Bozek
**
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: Multi Sort Array bug

[Keith Culotta]

Richard,

It looks like it is sensitive about case, but not like I expected.  It puts 
lowercase before UPPERCASE instead of after ("a",97 before "A",65) when it's 
comparing the same letter in the same [[position]] in a string.  I was 
expecting a sort like you'd get if all letters were converted to one case, and 
then sorted.

ARRAY TEXT($arr;0)
APPEND TO ARRAY($arr;"A")
APPEND TO ARRAY($arr;"a")
APPEND TO ARRAY($arr;"B")
APPEND TO ARRAY($arr;"b")
APPEND TO ARRAY($arr;"C")
APPEND TO ARRAY($arr;"c")
APPEND TO ARRAY($arr;"D")
APPEND TO ARRAY($arr;"d")
APPEND TO ARRAY($arr;"E")
APPEND TO ARRAY($arr;"e")

MULTI SORT ARRAY($arr;>)  // results=> aAbBcCdDeE
SORT ARRAY($arr)  // results=> aAbBcCdDeE

ALL RECORDS([Table_1])
ARRAY TO SELECTION($arr;[Table_1]Sorting)
ORDER BY([Table_1];[Table_1]Sorting)
SELECTION TO ARRAY([Table_1]Sorting;$arr)  // results=> aAbBcCdDeE

Keith - CDI

> On Oct 4, 2016, at 11:40 AM, Richard Wright  
> wrote:
> 
> Hmm. So the Design Reference has always been wrong? In the Order By Editor 
> section, Sort Levels paragraph:
> 
> "When sorting the contents of fields, 4D is not case sensitive (i.e., “Smith” 
> = “smith”) or diacritical sensitive (i.e., “Aá” = “Aa”). However, if you are 
> using an international version of 4D and your operating system is diacritical 
> sensitive (e.g., “Aá” ¦ “Aa”), sorting operations will also take diacritical 
> marks into account”
> 
> http://doc.4d.com/4Dv15R5/4D/15-R5/Order-by-editor.300-2964328.en.html
> 
> As far as I know I’m using the English version of 4D, not an international 
> version (although I don’t know to verify that).
> 
> 
> 
>> Date: Mon, 3 Oct 2016 22:46:37 +0200
>> From: Keisuke Miyako 
>> 
>> there has always been 2 levels of text comparison in 4D,
>> one for search, find, equality operators,
>> and another for sort, order by, greater/less than operators.
>> 
>> sorting has always been case sensitive.
>> 
>>> 2016/10/04 1:28、Richard Wright  のメール：
>>> Apparently Multi Sort Array performs case-sensitve searches, unlike 
>>> anything else in 4D.
> 

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

Working on a specific xliff file

[Andrea Angeli]

Hi,

Is it possible to read a specific xliff file using Get indexed string. My idea 
is to use the xliff file with the Web Server so if you choose to read a page in 
a specific language I can load menù and buttons in the appropriate xliff file 
and get the translation.

I try to find read 4d documentation, but it seems that I cannot get the 
reference number of the xliff opened file and I cannot use open file or open 
resource file to put in the 3th parameter of  Get indexed string.

I should wrote my own method to read a specific xliff file?

Thanks in advance

Andrea
**
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: Multi Sort Array bug

[Richard Wright]

Hmm. So the Design Reference has always been wrong? In the Order By Editor 
section, Sort Levels paragraph:

"When sorting the contents of fields, 4D is not case sensitive (i.e., “Smith” = 
“smith”) or diacritical sensitive (i.e., “Aá” = “Aa”). However, if you are 
using an international version of 4D and your operating system is diacritical 
sensitive (e.g., “Aá” ¦ “Aa”), sorting operations will also take diacritical 
marks into account”

http://doc.4d.com/4Dv15R5/4D/15-R5/Order-by-editor.300-2964328.en.html

As far as I know I’m using the English version of 4D, not an international 
version (although I don’t know to verify that).



> Date: Mon, 3 Oct 2016 22:46:37 +0200
> From: Keisuke Miyako 
> 
> there has always been 2 levels of text comparison in 4D,
> one for search, find, equality operators,
> and another for sort, order by, greater/less than operators.
> 
> sorting has always been case sensitive.
> 
>> 2016/10/04 1:28、Richard Wright  のメール：
>> Apparently Multi Sort Array performs case-sensitve searches, unlike anything 
>> else in 4D.

**
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: Version hell on Mac

[Ortwin Zillgen]

> Paul, here’s that code snippet. I found it.
> 
>  // Ortwin Zillgen code for instantly upgrading primary keys in a post 
> v13 database (Works !)
> 
> C_LONGINT($i;$P_SIZE)
> C_TEXT($tableName_t)

it was already common sense to proceed like that, at least with the 
die4Dwerkstatt-people. Then I wrote this article 
 to 
emphasise:
ADD THE UUID-FIELD BEFORE CONVERTING TO V14 AND MAKE THIS PRIMARY KEY
Sorry for shouting here, but it still seems not to be common sense.

I had to follow-up with this article, for those being perplexed by V13-behaviour


Peter, always a pleasure


Regards
O r t w i n  Z i l l g e n
-
   
 
member of developer-network 

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

Setting the time frame on 4D Server montior

[Kirk Brooks]

Can I either configure or programmatically set the time frame for the
monitor graph on 4D server? The only way I know how to do it is by
reight-clicking on the graph after I start it. I frequently forget to set
it to something longer than the default.

Thanks

-- 
Kirk Brooks
San Francisco, CA
===
**
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: Version hell on Mac

[Randy Jaynes]

This is the track I took as well because being an OEM database, I don’t want to 
have to deal with mapping every single 4DD file I open up.

I’d be interested in seeing the SQL code as well, but your #2 is the best piece 
of advice I could offer as well.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com • (845) 359-0298 • PrintPoint, Inc • 57 Ludlow Lane • 
Palisades, NY 10964 


 

> On Oct 4, 2016, at 10:49 AM, Peter Jakobsson  wrote:
> 
> 
> 
>> We’ve seen with v15 the biggest thing seems to be the unique keys, 
>> presumably with uuids. How did you handle that? Did you just have uuids 
>> added onto all your tables?
> 
> Ah !
> 
> Well you can either spend 2 days doing it (as I did once)……or you can get 
> hold of a bit of SQL code originally posted by Ortwin Zilgen and do it in 
> about 20 seconds.
> 
> The general consensus is:
> 
> [1] - forget trying to map your old primary keys (IDs) to new ones. Keep all 
> your code as it is and IDs as they are
> 
> [2] - create new UUID primary keys for every table and let 4D have control of 
> them. You keep control of the old ones (which are now demoted to ‘business 
> logic’ layer primary keys)
> 
> In principle therefore, the new UUIDs basically work like the old record 
> numbers except they’e now just saved into the record. I’ve done this in a few 
> databases and it’s the most transparent way - basically no thought required 
> and lets you sleep well.
> 
> I’ll see if I can dig out that piece of SQL code…
> 
> Peter
> 
> 
> **
> 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
**

settings.4DSettings

[bob . miller]

Hello Everyone,

I'm trying to find out where 4D Server stores settings such as port 
number, memory settings, etc. - at first I thought this was in 
settings.4DSettings, but in my settings.4Dsettings file there is only a 
"Automatic_session_management" item.

The settings.4Dsettings file is mentioned in the Design Reference, but it 
does not have any schema for what can/should be in it.

Is there additional documentation on this file?

Am I correct in that port number and memory settings are stored in an 
external file?

Many thanks,


Bob Miller
Chomerics, a division of Parker Hannifin Corporation



**
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: Version hell on Mac

[Peter Jakobsson]

Paul, here’s that code snippet. I found it.


  // Ortwin Zilgen code for instantly upgrading primary keys in a post v13 
database (Works !)

C_LONGINT($i;$P_SIZE)
C_TEXT($tableName_t)

$fieldName:="pkUUID"

$P_SIZE:=Get last table number

For ($i;1;$P_SIZE)
If (Is table number valid($i))

$tableName_t:=Table name($i)
$statement_t:="ALTER TABLE ["+$tableName_t+"] ADD "+$fieldName+" UUID 
AUTO_GENERATE PRIMARY KEY;"

Begin SQL
EXECUTE IMMEDIATE:$statement_t;
End SQL

End if 
End for 


**
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: Version hell on Mac

[Peter Jakobsson]

> We’ve seen with v15 the biggest thing seems to be the unique keys, presumably 
> with uuids. How did you handle that? Did you just have uuids added onto all 
> your tables?

Ah !

Well you can either spend 2 days doing it (as I did once)……or you can get hold 
of a bit of SQL code originally posted by Ortwin Zilgen and do it in about 20 
seconds.

The general consensus is:

[1] - forget trying to map your old primary keys (IDs) to new ones. Keep all 
your code as it is and IDs as they are

[2] - create new UUID primary keys for every table and let 4D have control of 
them. You keep control of the old ones (which are now demoted to ‘business 
logic’ layer primary keys)

In principle therefore, the new UUIDs basically work like the old record 
numbers except they’e now just saved into the record. I’ve done this in a few 
databases and it’s the most transparent way - basically no thought required and 
lets you sleep well.

I’ll see if I can dig out that piece of SQL code…

Peter


**
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: Version hell on Mac

[Paul Lovejoy]

Peter,

Thanks for your input. 

When you made the transition, what were the biggest pitfalls?

We prepared a move from v12 to v13. A big job was to convert lots of grouped 
scrollable areas to listboxes. We had tons of those in the app.

We’ve seen with v15 the biggest thing seems to be the unique keys, presumably 
with uuids. How did you handle that? Did you just have uuids added onto all 
your tables?


Thanks,

Paul


> On 03 Oct 2016, at 15:25, Peter Jakobsson  wrote:
> 
> 
>> Is anyone else in a similar situation? What did you do / are you doing?
> 
> I took one straight from v11 to v15 (on installation was Windows, one was 
> Mac). Same reason as you - had to get to El Capitan comfort zone.
> 
> It wasn’t a big multinational but it was a complex database dealing with 
> money and running about 12 business in total. It has triggers all over the 
> place, 4D Write, usual mix of UI forms including widgets, lots of reports, 
> PDF printing and and included areas etc. It’s more stable now than it was in 
> v11.
> 
> Plugins are AealistPro and 4D Write.
> 
> I’d say you’ll have more problems staggering your upgrade than going straight 
> to v15. I know what you mean about “transiting through the intermediates” and 
> I used to think that too but now I’d say go direct to a “safe zone” without 
> transiting through the “danger zone”.
> 
> Just my 2 pence, of course. All structures are different and take all advice 
> that comes !
> 
> Best Regards
> 
> Peter
> 
> **
> 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: 4D mobile connector for Wakanda

[Miguel Gonzalez]

Thank you Sannyasin for your answer.

I thought 4D allows to test 4D mobile and licences will not be an issue.

Regards

Miguel Gonzalez

On 3 October 2016 at 22:53, Sannyasin Siddhanathaswami  wrote:
> I’ve run into a similar issue with not enough licenses for 4D Mobile, or 
> licenses that exist are used up. You might try restarting both 4D and Wakanda 
> to try to get the seats back.
>
> --
> Sannyasin Siddhanathaswami
> **
> 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
> **



-- 
Miguel Gonzalez
AcuBase Ltd.
**
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
**