Re: Using web areas in v16, is there a way to 'talk back' to 4d...

[Keisuke Miyako via 4D_Tech]

the difference between system vs embedded is more significant on Windows,
but in general, if a JS/CSS/HTML feature is missing, there should be a decent 
polyfill to cover that.

the embedded engine is CEF on v16 64-bit, not the somewhat outdated version of 
WebKit,
which generally delivers excellent results on both platforms.

are you using an existing library "out of the box"?
it might be misjudging the "browser" it is running on.

anyway, you shouldn't move away from embedded web area simply because "the 
display goes hell".

there should be a good explanation at the JS/CSS/HTML level.

2018/01/05 11:31、Lee Hinde via 4D_Tech 
<4d_tech@lists.4d.com> のメール：
Again, once I start using the embedded webkit, where I get call-backs built-in, 
the display goes to hell. It looks fine if I use the system browser. 
(non-embedded.)


**
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: Using web areas in v16, is there a way to 'talk back' to 4d...

[Lee Hinde via 4D_Tech]

Glad you asked, since this is your fault. :-)

I’m displaying a bunch of images. I want the user to be able to double click on 
the image and have 4D pop-up a different dialog.

Again, once I start using the embedded webkit, where I get call-backs built-in, 
the display goes to hell. It looks fine if I use the system browser. 
(non-embedded.)


> On Jan 4, 2018, at 5:14 PM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Lee,
> Be more specific about the scope of "talk back".
> 
> The easiest way to directly allow users to interact with a web area
> displaying a page you created is the filter URL option. This is how I use
> web areas and either do something like popup a 4D menu or make a connection
> to an actual web link. I've never tried filtering URLs on a website I
> loaded from the net.
> 
> Anyway, it's really easy if you make anything the user can click on an
> anchor. And it works using the webkit or not.
> 
> if you've got js doing things on the web page or the user is entering data
> and you need to tap on 4D's shoulder to get it to do something the $4d and
> URL callbacks Miyako linked to is what you need. In that case you may have
> to use the webkit.
> 
> On Thu, Jan 4, 2018 at 3:55 PM, Lee Hinde via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
> 
>> without needing a web server license and without using the 'embedded web
>> rendering engine'?
>> **
>> 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
> **

**
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: Using web areas in v16, is there a way to 'talk back' to 4d...

[Keisuke Miyako via 4D_Tech]

I should have been more clear.

in the examples posted,
$4d is used if the web area is integrated,
but a URL-based callback is used if the web area is system.

2018/01/05 9:50、Lee Hinde via 4D_Tech 
<4d_tech@lists.4d.com> のメール：
Thanks Keisuke, but the integrated webkit can't display the page I'm trying
to render...



**
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: Using web areas in v16, is there a way to 'talk back' to 4d...

[Kirk Brooks via 4D_Tech]

Lee,
Be more specific about the scope of "talk back".

The easiest way to directly allow users to interact with a web area
displaying a page you created is the filter URL option. This is how I use
web areas and either do something like popup a 4D menu or make a connection
to an actual web link. I've never tried filtering URLs on a website I
loaded from the net.

Anyway, it's really easy if you make anything the user can click on an
anchor. And it works using the webkit or not.

if you've got js doing things on the web page or the user is entering data
and you need to tap on 4D's shoulder to get it to do something the $4d and
URL callbacks Miyako linked to is what you need. In that case you may have
to use the webkit.

On Thu, Jan 4, 2018 at 3:55 PM, Lee Hinde via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> without needing a web server license and without using the 'embedded web
> rendering engine'?
> **
> 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: Using web areas in v16, is there a way to 'talk back' to 4d...

[Lee Hinde via 4D_Tech]

Thanks Keisuke, but the integrated webkit can't display the page I'm trying
to render...

I may have to get less fancy so I can use the callbacks.

Thanks.

On Thu, Jan 4, 2018 at 4:32 PM, Keisuke Miyako via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> this example contains both $4d and URL-based callbacks.
>
> https://github.com/miyako/4d-tips-web-area-charts
>
> see also
>
> https://github.com/miyako/4d-utility-compare-webarea-features
>
> ---
>
> either way, web server license is totally unnecessary.
>
> URL-based callback doesn't talk to the web server,
> it simply triggers a form event.
>
> 2018/01/05 8:55、Lee Hinde via 4D_Tech <4d_tech@lists.4d.com d_t...@lists.4d.com>> のメール：
> without needing a web server license and without using the 'embedded web
> rendering engine'?
>
>
>
> **
> 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: Using web areas in v16, is there a way to 'talk back' to 4d...

[Keisuke Miyako via 4D_Tech]

this example contains both $4d and URL-based callbacks.

https://github.com/miyako/4d-tips-web-area-charts

see also

https://github.com/miyako/4d-utility-compare-webarea-features

---

either way, web server license is totally unnecessary.

URL-based callback doesn't talk to the web server,
it simply triggers a form event.

2018/01/05 8:55、Lee Hinde via 4D_Tech 
<4d_tech@lists.4d.com> のメール：
without needing a web server license and without using the 'embedded web
rendering engine'?



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

Using web areas in v16, is there a way to 'talk back' to 4d...

[Lee Hinde via 4D_Tech]

without needing a web server license and without using the 'embedded web
rendering engine'?
**
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: On Column Resize event

[Keisuke Miyako via 4D_Tech]

if what you want is equal distribution of growth,
then there is another v16 feature that does that:

https://blog.4d.com/listbox-columns-auto-resizing/

> 2018/01/05 2:13、Piotr Chabot Stadhouders via 4D_Tech <4d_tech@lists.4d.com> 
> のメール：
>
> When setting the Horizontal sizing option of the listbox to grow, the listbox 
> grows when resizing the window, and the last column of the listbox is also 
> resized. This is common beheviour
> What I don't like is that then the "On Column Resize" event also is fired, so 
> now when resizing the window, the code behind the event is executed many 
> times.




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

[ANN] Save $200 - Early Bird Registration Ending

[Brian Young via 4D_Tech]

Early Bird pricing ends in ONE WEEK — January 12th.

 Save $200.   Register today.


You only get one opportunity to be the first to
explore the new technologies unveiled during this
groundbreaking 4D Summit:

- Laurent Ribardière unveils a 4D Revolution during
 an exclusive Master Class.
- Build proficiency during Advanced Training.
- New product announcement — expand your toolkit.
- Impressive technical sessions.
- Talk directly to the 4D Team.
- Meet and share with the 4D community.



 Treat yourself to

 a terrific time,

  in a remarkable city,

 during an exceptional year for 4D.


 Paris, France • March 20th-22nd, 2018
   http://events.4d.com/summit/

 Washington, D.C., USA • April 3rd-5th, 2018
   http://events.4d.com/summit/us/washington/





   /%  %@@.
  @@  %  @.
    , .
  @@    @@.
  @@@.@  %%%  .
  @.   @@  %%   @@.
  @@@.  ,((%  @. &
  @@. .,   (* %%%  @@@  ,  &,
  .  (  %%.###  *@@@,
  @@@. /. *,   /*#((.###  %@,
  @.  ,  //,   /(,(##* .,
  @@@.  /  ,   /(*(((##  ,@@,
  @@. /  **.   //*   .((#  @,
  .  ...   //.   (/  @@@,
  @@.  /.  .  *//     @@,
  @  *,.   *///,   ##  @,
   .*,, *.   ## ,
  *.  ###
  ###
  ###
  ###





**
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: Log File does not correspond to data file after compacting

[Arnaud de Montard via 4D_Tech]

> Le 4 janv. 2018 à 16:44, Janie Marlow via 4D_Tech <4d_tech@lists.4d.com> a 
> écrit :
> 
> v2004, 10.6.8
> 
> Yesterday I compacted my databases' data file, something I had not done since 
> v6 or before. Afterwards, when I opened the database, I was presented with a 
> series of alerts:
> 
> * The correct Log file for this data file could not be found. Try to find it. 
> If you cannot find the Log File, make a full backup of the data before 
> creating a Log File.
> * The Log File does not correspond to the data file.
> * A Log File is necessary to use this database.
> 
> I experimented with renaming the data file, but I could not get past the 
> alerts, so I ended up going back to using the uncompacted file.
> 
> I've searched the docs, and I cannot find any special instructions regarding 
> compacting a data file when using a Log File.
> 
> It doesn't say anything about unclicking "Use Log File" before compacting, 
> but is that what I should do?
> or should I backup immediately before compacting?

Hi Janie, 
not sure that this is the issue, could be… 

I've not found it in the docs, but I believe the journal path is stored in the 
.4dd file. So when 4D opens a .4dd that was journaled, it reads that path and 
then you have 2 possibilities:
A/ the journal is not found
4D alerts you and offers these choices:
  show 4d where it is (open dialog)
  create a new journal (create dialog)
  forget the journal
B/ journal is found
then 4d checks if 4dd/journal state are consistent, 2 possibilities (again):
  B1/ consistent -> all right
  B2/ not consistent -> alert, you must repair, open the MSC and so on - a kind 
of endless loop when you know you don't have to repair!!

If the 4dd has been compacted, supposing that:
- compacting makes journal inconsistent with 4dd (I don't know)
- the journal is still "visible" (valid path)
you may be in the B2 ugly situation. In other words (and to make it shorter…), 
try to find where is the journal, rename it, open the 4dd and see it it's 
better. 

-- 
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: Update from v12.6 to v16.3-64 (Mac)

[Arnaud de Montard via 4D_Tech]

> Le 4 janv. 2018 à 08:40, Jörg Knebel via 4D_Tech <4d_tech@lists.4d.com> a 
> écrit :
> 
> I’m ending up not able to go to the design environment and the “Trace” in On 
> Startup is ignored.

It sounds like you're not logged in as designer or developer licence is 
missing. 
I recommend to set the primary keys before, if it's not done already.

-- 
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: Log File does not correspond to data file after compacting

[Jeffrey Kain via 4D_Tech]

Log files are invalidated after a compact prior to 4D v11. Your only choice is 
to make a new one after a full backup.  

> On Jan 4, 2018, at 12:50 PM, Lee Hinde via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Did any of those dialogs give you the option of creating a new log file?
> 
> 
>> On Jan 4, 2018, at 7:44 AM, Janie Marlow via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>> 
>> v2004, 10.6.8
>> 
>> Yesterday I compacted my databases' data file, something I had not done 
>> since v6 or before. Afterwards, when I opened the database, I was presented 
>> with a series of alerts:
>> 
>> * The correct Log file for this data file could not be found. Try to find 
>> it. If you cannot find the Log File, make a full backup of the data before 
>> creating a Log File.
>> * The Log File does not correspond to the data file.
>> * A Log File is necessary to use this database.
>> 
>> I experimented with renaming the data file, but I could not get past the 
>> alerts, so I ended up going back to using the uncompacted file.
>> 
>> I've searched the docs, and I cannot find any special instructions regarding 
>> compacting a data file when using a Log File.
>> 
>> It doesn't say anything about unclicking "Use Log File" before compacting, 
>> but is that what I should do?
>> or should I backup immediately before compacting?
**
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: Update from v12.6 to v16.3-64 (Mac)

[Lee Hinde via 4D_Tech]

That sounds like a license issue. Have you installed your v16 license?



> On Jan 3, 2018, at 11:40 PM, Jörg Knebel via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi All,
> 
> Could someone please refresh my memory on how to upgrade an application from 
> v12 to v16 on Mac?
> 
> I’m ending up not able to go to the design environment and the “Trace” in On 
> Startup is ignored.
> 
> Thanks
> 
> Cheers
> Jörg
> **
> 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: Log File does not correspond to data file after compacting

[Lee Hinde via 4D_Tech]

Did any of those dialogs give you the option of creating a new log file?


> On Jan 4, 2018, at 7:44 AM, Janie Marlow via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> v2004, 10.6.8
> 
> Yesterday I compacted my databases' data file, something I had not done since 
> v6 or before. Afterwards, when I opened the database, I was presented with a 
> series of alerts:
> 
> * The correct Log file for this data file could not be found. Try to find it. 
> If you cannot find the Log File, make a full backup of the data before 
> creating a Log File.
> * The Log File does not correspond to the data file.
> * A Log File is necessary to use this database.
> 
> I experimented with renaming the data file, but I could not get past the 
> alerts, so I ended up going back to using the uncompacted file.
> 
> I've searched the docs, and I cannot find any special instructions regarding 
> compacting a data file when using a Log File.
> 
> It doesn't say anything about unclicking "Use Log File" before compacting, 
> but is that what I should do?
> or should I backup immediately before compacting?
> 
> Thank you -
> Janie


**
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: On Column Resize event

[Chip Scheide via 4D_Tech]

Piotr,
'On Timer' can be used to limit execution of the On Column Resize event.
I have seen a similar problem with other resizing situations.

Basically - you start a timer for a .5 second or so, then On timer 
executes the code.
This reduces the number of times the code runs.

For differentiating between manual resizing of a column vs auto 
resizing via a window resize, you could try setting a flag. Set the 
flag in 'On Mouse Enter', and clearing it in 'On Mouse Leave', in the 
context of the listbox. Then in the code for resizing if the flag is 
set the user has the mouse in the listbox and is resizing manually. If 
not, then the user is resizing the window.

Chip
On Thu, 4 Jan 2018 17:13:23 +, Piotr Chabot Stadhouders via 4D_Tech 
wrote:
> Hi,
> 
> In 4D v16 there is a new feature so an "On Column Resize" event is 
> triggered "live" during resizing of a listbox:
> https://blog.4d.com/execute-action-upon-listbox-column-resizing/
> 
> I have a lot of code behind that event in our application that now is 
> executed too many times, so I don't like this at all. I have to 
> eliminate this code, because it is based on the idea a user resizes 
> the column.
> 
> Apart from this fact, there is something else :
> When setting the Horizontal sizing option of the listbox to grow, the 
> listbox grows when resizing the window, and the last column of the 
> listbox is also resized. This is common beheviour
> What I don't like is that then the "On Column Resize" event also is 
> fired, so now when resizing the window, the code behind the event is 
> executed many times.
> What I don't understand is how I can know if the event is triggered 
> by a user resizing the column, or if it is triggered by something 
> else (in this case resizing the window)
> 
> Does anybody know of a way to detect this?
> 
> Gr,
> 
> Piotr
> 
> **
> 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
**

On Column Resize event

[Piotr Chabot Stadhouders via 4D_Tech]

Hi,

In 4D v16 there is a new feature so an "On Column Resize" event is triggered 
"live" during resizing of a listbox:
https://blog.4d.com/execute-action-upon-listbox-column-resizing/

I have a lot of code behind that event in our application that now is executed 
too many times, so I don't like this at all. I have to eliminate this code, 
because it is based on the idea a user resizes the column.

Apart from this fact, there is something else :
When setting the Horizontal sizing option of the listbox to grow, the listbox 
grows when resizing the window, and the last column of the listbox is also 
resized. This is common beheviour
What I don't like is that then the "On Column Resize" event also is fired, so 
now when resizing the window, the code behind the event is executed many times.
What I don't understand is how I can know if the event is triggered by a user 
resizing the column, or if it is triggered by something else (in this case 
resizing the window)

Does anybody know of a way to detect this?

Gr,

Piotr

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

Log File does not correspond to data file after compacting

[Janie Marlow via 4D_Tech]

v2004, 10.6.8

Yesterday I compacted my databases' data file, something I had not 
done since v6 or before. Afterwards, when I opened the database, I 
was presented with a series of alerts:


* The correct Log file for this data file could not be found. Try to 
find it. If you cannot find the Log File, make a full backup of the 
data before creating a Log File.

* The Log File does not correspond to the data file.
* A Log File is necessary to use this database.

I experimented with renaming the data file, but I could not get past 
the alerts, so I ended up going back to using the uncompacted file.


I've searched the docs, and I cannot find any special instructions 
regarding compacting a data file when using a Log File.


It doesn't say anything about unclicking "Use Log File" before 
compacting, but is that what I should do?

or should I backup immediately before compacting?

Thank you -
Janie
**
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: Securing ODBC Connections?

[Alan Tilson via 4D_Tech]

Chuck,
Thanks for the info. My user isn't familiar with using Excel & ODBC but
we'll give it a go.
Keisuke,
Thank you for responding. I was wondering about the precise situation that
you discuss, that to trace the connection we must have a functional method.
I did find the 32 bit ODBC driver installer finally, after looking all over
for a place to download it (it is rather hidden!).
So we have the driver connecting to 4D Server ok, but the actual ODBC
connection fails.
And I'll create a receiving method and see what we learn, but this has been
pushed back a bit on the priority list so it may be a few days...
Alan

On Tue, Jan 2, 2018 at 4:35 PM, Keisuke Miyako via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> keep in mind also that an incomplete authentication method will reject the
> connection.
> the code should
>
> 1. explicitly call "change current user" and
> 2. return "true"
>
> http://doc.4d.com/4Dv16R4/4D/16-R4/On-SQL-Authentication-
> database-method.301-3316871.en.html
>
> in other words, an empty "on sql authentication" database method with no
> code would reject the connection.
> by contrast, if the database method does not exist, the connection is
> accepted.
>
> ---
>
> another factor to consider is that the ODBC driver version must match that
> of 4D.
> R releases have a different driver to .x releases.
>
> the architecture (32 or 64-bit) must match that of the client (Access) not
> 4D.
>
> http://doc.4d.com/4Dv16R4/4D/16-R4/4D-ODBC-Driver.100-3454244.en.html
>
> (the OP is about v13 so this point is probably irrelevant)
>
> ---
>
> finally, note that in v13 the full installer of 4D doesn't actually
> install the ODBC driver.
> rather, it installs the installer for ODBC driver (on Windows).
>
> > 2018/01/03 2:10、Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> のメール：
> > If you put a trace in sql authentication method and see what happens.
>
>
>
>
> **
> 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: Update from v12.6 to v16.3-64 (Mac)

[Chip Scheide via 4D_Tech]

you need to put a menu action for design - the old option f at the 
splash screen stops working (v14?)
also if you have not already done so you will need to setup primary 
keys (likely uuids) for all tables for logging (and backup?) purposes.

On Thu, 4 Jan 2018 18:40:30 +1100, Jörg Knebel via 4D_Tech wrote:
> Hi All,
> 
> Could someone please refresh my memory on how to upgrade an 
> application from v12 to v16 on Mac?
> 
> I’m ending up not able to go to the design environment and the 
> “Trace” in On Startup is ignored.
> 
> Thanks
> 
> Cheers
> Jörg
> **
> 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: Update from v12.6 to v16.3-64 (Mac)

[Stephen J. Orth via 4D_Tech]

We did the same, all work completed in V13 then jumped to V15 R5.  Again, from 
V15 R5 to V16 we are finding no issues at this point in time.  All 32 bit...


Steve

*
  Stephen J. Orth
  The Aquila Group, Inc. Office:  (608) 834-9213
  P.O. Box 690   Mobile:  (608) 347-6447
  Sun Prairie, WI 53590

  E-Mail:  s.o...@the-aquila-group.com
*
-Original Message-
From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Jeffrey Kain 
via 4D_Tech
Sent: Thursday, January 04, 2018 7:33 AM
To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: Jeffrey Kain 
Subject: Re: Update from v12.6 to v16.3-64 (Mac)

We skipped v14 and had no problems, FWIW. We did our primary key changes in 
v13, and then moved to v15 without any issues. And our v16 upgrade had almost 
zero issues whatsoever (32-bit)... you could probably do 12->13->16 and save a 
few steps.

--
Jeffrey Kain
jeffrey.k...@gmail.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: Update from v12.6 to v16.3-64 (Mac)

[Jeffrey Kain via 4D_Tech]

We skipped v14 and had no problems, FWIW. We did our primary key changes in 
v13, and then moved to v15 without any issues. And our v16 upgrade had almost 
zero issues whatsoever (32-bit)... you could probably do 12->13->16 and save a 
few steps.

--
Jeffrey Kain
jeffrey.k...@gmail.com




> On Jan 4, 2018, at 3:44 AM, 4dialog via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> I think you have to take it step by step, 12 - 13, 13-14, 14-15...
> The step from 13 - 14 is the heavy one where 14 demands primary keys for
> every table.
> 
> Take a look at the upgrade doc:
> http://doc.4d.com/4Dv15/4D/15/Conversion-to-4D-v15.100-1931124.en.html
> 
> Here you have ref. to the other upgrade docs as well.
> 
> Good luck :)

**
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: Update from v12.6 to v16.3-64 (Mac)

[Jörg Knebel via 4D_Tech]

> On 4 Jan 2018, at 19:44 AEDT, 4dialog via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Here you have ref. to the other upgrade docs as well.
> 
> Good luck :)

Thanks mate.
**
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: Update from v12.6 to v16.3-64 (Mac)

[4dialog via 4D_Tech]

I think you have to take it step by step, 12 - 13, 13-14, 14-15...
The step from 13 - 14 is the heavy one where 14 demands primary keys for
every table.

Take a look at the upgrade doc:
http://doc.4d.com/4Dv15/4D/15/Conversion-to-4D-v15.100-1931124.en.html

Here you have ref. to the other upgrade docs as well.

Good luck :)



-
Hilsen
--
Helge Antonsen
4Dialog as
Tel: +47 64 000 164
Mob: +47 90 15 56 19
Web: www.4dialog.no 
--
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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**