Re: 4D v16.4 Built database won't open in Mojave

2018-11-05 Thread Walt Nelson via 4D_Tech
Koen,

Yes, I did do that. Transferred using AirDrop between the two machines.

Were you able to get the Built App to launch successfully? Anyone else?

Thanks,
Walt


> On Nov 4, 2018, at 11:59 PM, Koen Van Hooreweghe via 4D_Tech 
> <4d_tech@lists.4d.com > wrote:
> 
> In the past I experienced a similar issue. Seems to be a some kind of 
> permissions problem. Could you try to zip your app, transfer the zip to your 
> MacBook and unzip it on that machine.

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Changing Picture/3D Button Sets Dynamically...

2018-11-05 Thread Keisuke Miyako via 4D_Tech
object set format allows you to reassign the picture source dynamically. the 
syntax is proprietary but you can call object get format on a preconfigured 
object and work your way from there.

alternatively, you could place a picture object on top of a blank button and 
implement a dynamic picture button that way.



**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Current time (*) incorrect today on v17?

2018-11-05 Thread Keisuke Miyako via 4D_Tech
Hi, timestamp is agnostic to timezone which is why it wasn’t caught by the bug.

2018/11/05 19:14、Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com>のメール:

So Timestamp uses a completely different -source- for determining time than 
Current time and Current date?



**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: v13 - Why can a record NOT be Pushed?

2018-11-05 Thread Chip Scheide via 4D_Tech
Thanks Kirk,
I found the problem I was having.

PUSH RECORD can't push a record if there is no record to push...
so as you suggested no selection.

On Mon, 5 Nov 2018 13:51:18 -0800, Kirk Brooks via 4D_Tech wrote:
> Stack is full?
> The record is not selected?
> 
> I was trying to use PUSH & POP the other day for something. It caused me to
> re-read the docs about it and I found that over the years I'd forgotten the
> whole idea for these two commands is to allow you to PUSH the record you
> are currently using to allow you to do queries on the same table without
> having to save it first. They aren't there to allow editing multiple
> records in the same process because a process, at least in  have 1 current record at a time.

Yes I know that about Push and Pop

In this case I have a complicated set of inter relations (some as 
relational lines and some not) and in many cases trying to get related 
records loses the current starting record, so pushing and piping 
insures that I end up on the same starting record.

This is in a situation where I have :
* A storage unit, in side are 1 or more containers
* - Container (Type -S) - this is allowed to have (many) of either or 
both of 2 other types of containers, or end products
* -- Type B container - holds end products
* -- Type R container - holds only other containers, of Type B

There are 2 types of end products (End Product S and End Product I)


The interface allows drag n drop on list boxes to populate the various 
containers.
As well as printing the contents of the containers, at every level.

I was having issues after printing, then switching to a different 
page/listbox.

all of the above is probably TMI - but there it is  :)


Thanks again
 
> On Mon, Nov 5, 2018 at 1:46 PM Chip Scheide via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> I am getting this error, and i can not figure out why.
>> 
>> Thanks
>> Chip
>> ---
>> Gas is for washing parts
>> Alcohol is for drinkin'
>> Nitromethane is for racing
>> **
>> 4D Internet Users Group (4D iNUG)
>> Archive:  http://lists.4d.com/archives.html
>> Options: https://lists.4d.com/mailman/options/4d_tech
>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>> **
> 
> 
> 
> -- 
> Kirk Brooks
> San Francisco, CA
> ===
> 
> *We go vote - they go home*
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://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)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: v13 - Why can a record NOT be Pushed?

2018-11-05 Thread Kirk Brooks via 4D_Tech
Stack is full?
The record is not selected?

I was trying to use PUSH & POP the other day for something. It caused me to
re-read the docs about it and I found that over the years I'd forgotten the
whole idea for these two commands is to allow you to PUSH the record you
are currently using to allow you to do queries on the same table without
having to save it first. They aren't there to allow editing multiple
records in the same process because a process, at least in  wrote:

> I am getting this error, and i can not figure out why.
>
> Thanks
> Chip
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **



-- 
Kirk Brooks
San Francisco, CA
===

*We go vote - they go home*
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

v13 - Why can a record NOT be Pushed?

2018-11-05 Thread Chip Scheide via 4D_Tech
I am getting this error, and i can not figure out why.

Thanks
Chip
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Changing Picture/3D Button Sets Dynamically...

2018-11-05 Thread Robert ListMail via 4D_Tech
How might you implement changing or swapping picture (or 3D Button) sets on the 
fly?  I see the picture source can take a variable. Think about the flexibility 
we have with a display or entry filter where the filter definition is centrally 
defined with almost no effort. Have you had the buttons assigned centrally 
before…?  The more I think of this, I can see this could be part fo a 
dynamically generated form and not just the buttons.

Thanks,

Robert

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

v13 (+?) - is there a way to "see" the stack?

2018-11-05 Thread Chip Scheide via 4D_Tech
Is there some way to determine if, and what record(s) are on the stack 
for either the database, or (better) a single table?

something like the following, whatever is required to do **Records on 
stack**:
Push ([table])
do stuff
Push ([table])
do more stuff

for($i;1;**Records on stack([table])**)
 Pop record([table])
end for

Thanks
Chip

---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Backing up a VM - is it dangerous ?

2018-11-05 Thread Tim Nevels via 4D_Tech
On Nov 5, 2018, at 2:00 PM, Peter Jakobsson wrote:

> Many thanks for the useful replies.
> 
> I’ve contacted the IT contractor to try to negotiate a new backup strategy.
> 
> Hopefully it will be less of a sweat than the China trade talks :-)

Peter,

If you just enable 4D Backup you should be find as long as you have an idea 
when IT is doing the backup of your 4D Server machine. 

As you know, 4D Backup will make a guaranteed good copy of your live, running 
4D Server data file. So when IT does a backup of the machine they will backup 
the 4D Backup file. Only issue is if at the exact time 4D Backup is running 
they run the backup the copy of the backup file may corrupted. But if you know 
when they are doing the backup, just schedule 4D Backup to not run near that 
time. 

I had been doing this with one of my clients for many years. They are running a 
VM that 4D Server runs on. IT told me they are doing a snapshot every night on 
that machine at 3am. So I just set 4D Backup to run at 2am. Been working great.

Now that client has moved to v17 and I’ve got Volume Shadow Support running on 
4D Server. So any snapshots they do will now guarantee the data file is valid 
if the snapshot is restored. Still running 4D Backup, but now IT thinks 4D is a 
real, first class VM citizen since it has VSS. 

Tim

*
Tim Nevels
Innovative Solutions
785-749-3444
timnev...@mac.com
*

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Current time (*) incorrect today on v17?

2018-11-05 Thread Cannon Smith via 4D_Tech
All of our customers also had to relaunch their servers yesterday. They are all 
on v16r6. Must be a new bug as I don’t remember this happening in the past.

--
Cannon.Smith
Synergy Farm Solutions Inc.
Hill Spring, AB Canada
403-626-3236




> On Nov 4, 2018, at 12:01 PM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> This completely broke credit card processing until I could track this down. 
> Thanks for confirming that this is a widespread issue.

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Backing up a VM - is it dangerous ?

2018-11-05 Thread Peter Jakobsson via 4D_Tech
Many thanks for the useful replies.

I’ve contacted the IT contractor to try to negotiate a new backup strategy.

Hopefully it will be less of a sweat than the China trade talks :-)

Peter

> On 5 Nov 2018, at 13:36, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Definitely not safe prior to v17.

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Backing up a VM - is it dangerous ?

2018-11-05 Thread Jeffrey Kain via 4D_Tech
Definitely not safe prior to v17.  With v17 there's support for Volume Shadow 
Copy which puts the datafile in a safe state prior to VMWare taking a snapshot.


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




> On Nov 5, 2018, at 6:17 AM, Peter Jakobsson via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Though I hopefully won’t be visiting the dentist anytime soon, Laurence 
> Olivier's words to Dustin Hoffman spring to mind…..”is it safe !?”  ;)

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Backing up a VM - is it dangerous ?

2018-11-05 Thread Kirk Brooks via 4D_Tech
Peter,
In a low transaction environment it's probably not an issue. But if the
copy happens to take place during a cache flush you can wind up with a
corrupted datafile. It's easily fixed by MSC but a record or two may be
lost. I've experienced this myself by making a copy of a live datafile on a
system with maybe 10 users logged in at the moment. It works most of
the time but fails a non-trivial number of times.

I would try to convey to the vendor that the architecture of 4D is not one
that lends itself to this type of backup.

If they won't give you an external drive the backup and log file is the
final word. Client's risk, client's choice.

On Mon, Nov 5, 2018 at 3:17 AM Peter Jakobsson via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> What are the implications of backing up the VM while 4D server is still
> running ? On the old days this would have been a complete no-no because of
> un-flushed caches, locked datafiles and all sorts of issues. Is anybody
> running this particular configuration ?
>

-- 
Kirk Brooks
San Francisco, CA
===

*We go vote - they go home*
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: Backing up a VM - is it dangerous ?

2018-11-05 Thread Epperlein, Lutz (agendo) via 4D_Tech
It will work, but it is *not* safe.

I would use a 4D backup anyway on the same drive the vm works. In this case 
they save with the snapshot of the vm the 4D backup files too.
Or you have to dive into the feature of volume shadow copies and the supporting 
of them by 4D.

Regards
Lutz


> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Peter 
> Jakobsson
> via 4D_Tech
> Subject: Backing up a VM - is it dangerous ?
> 
> Hi
> 
> One of my sites contracts out their server maintenance, procurement and 
> general
> support to an IT contractor. The contractor is fairly adaptable and I have 
> good
> professional relations with them, however I still have to work within certain 
> “overall
> parameters”.
> 
> One of these is that their 5-user 4D accounts server runs on a VM (Virtual 
> Machine).
> When I asked them about an external drive to hold the 4D backups, they 
> replied “don’t
> worry, the whole VM gets backed up once per day and the backup is held on 
> external
> drives”.
> 
> What are the implications of backing up the VM while 4D server is still 
> running ? On the
> old days this would have been a complete no-no because of un-flushed caches, 
> locked
> datafiles and all sorts of issues. Is anybody running this particular 
> configuration ?
> 
> Though I hopefully won’t be visiting the dentist anytime soon, Laurence 
> Olivier's words
> to Dustin Hoffman spring to mind…..”is it safe !?”  ;)
> 
> regards
> 
> Peter

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Backing up a VM - is it dangerous ?

2018-11-05 Thread Peter Jakobsson via 4D_Tech
Hi

One of my sites contracts out their server maintenance, procurement and general 
support to an IT contractor. The contractor is fairly adaptable and I have good 
professional relations with them, however I still have to work within certain 
“overall parameters”.

One of these is that their 5-user 4D accounts server runs on a VM (Virtual 
Machine). When I asked them about an external drive to hold the 4D backups, 
they replied “don’t worry, the whole VM gets backed up once per day and the 
backup is held on external drives”.

What are the implications of backing up the VM while 4D server is still running 
? On the old days this would have been a complete no-no because of un-flushed 
caches, locked datafiles and all sorts of issues. Is anybody running this 
particular configuration ?

Though I hopefully won’t be visiting the dentist anytime soon, Laurence 
Olivier's words to Dustin Hoffman spring to mind…..”is it safe !?”  ;)

regards

Peter
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Video viewer on Webarea on Windows 7

2018-11-05 Thread Kirk Brooks via 4D_Tech
Jim,
On Sun, Nov 4, 2018 at 5:42 PM Jim Labos - infobase via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> I am using URL's and they work on Win7 on Chrome but not Explorer. So
> certain it's not a URL problem.


> It may be the Webkit use so I'll check that.
>

Without knowing which version of 4D and MacOS we're talking about I can
share a few other caveats I've come across:

If webkit won't play it and IE won't play it you can't play it within a web
area on windows

Mojave breaks the webkit in v15 (Sierra and Hi Sierra don't)

Try declaring your HTML doc as HTML5 (you may already but your snippet
didn't)

The webkit in v17 is much more robust


If you are bound to the particular version of 4D this is on think about a
workaround that opens the video in the browser window - although you've
still got the problem of IE not playing it on win7.

-- 
Kirk Brooks
San Francisco, CA
===

*We go vote - they go home*
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Current time (*) incorrect today on v17?

2018-11-05 Thread Kirk Brooks via 4D_Tech
Miyako,
So Timestamp uses a completely different -source- for determining time than
Current time and Current date?

On Mon, Nov 5, 2018 at 12:45 AM Keisuke Miyako via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> 16R4 and later offers Timestamp
>
> http://doc.4d.com/4Dv17/4D/17/Timestamp.301-3730728.en.html
> https://blog.4d.com/timestamp-is-now-available/
>
-- 
Kirk Brooks
San Francisco, CA
===

*We go vote - they go home*
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Current time (*) incorrect today on v17?

2018-11-05 Thread Arnaud de Montard via 4D_Tech

> Le 5 nov. 2018 à 09:42, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com 
> > a écrit :
> 
> 16R4 and later offers Timestamp
> 
> http://doc.4d.com/4Dv17/4D/17/Timestamp.301-3730728.en.html 
> 
> 
> https://blog.4d.com/timestamp-is-now-available/ 
> 
I had forgotten  :-(

-- 
Arnaud de Montard 




**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Current time (*) incorrect today on v17?

2018-11-05 Thread Keisuke Miyako via 4D_Tech
16R4 and later offers Timestamp

http://doc.4d.com/4Dv17/4D/17/Timestamp.301-3730728.en.html

https://blog.4d.com/timestamp-is-now-available/

2018/11/05 17:40、Arnaud de Montard via 4D_Tech 
<4d_tech@lists.4d.com>のメール:
I'd like to have 4D functions for UTC:



**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Current time (*) incorrect today on v17?

2018-11-05 Thread Arnaud de Montard via 4D_Tech

> Le 4 nov. 2018 à 20:01, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> a 
> écrit :
> 
> Seems like Current time(*) from a client might be cached incorrectly as an 
> optimization, since Current time and Current time(*) on the server both 
> returned correct values.

Looks like. But I'm wondering about that "optimisation", given Current time(*) 
is slower than Current time and seems to send a request to the server. 


> This completely broke credit card processing


I don't like to use local time since I noticed that nightly processes could 
create records with timestamps prior to records created before (sic), I use 
timestamps UTC based instead. I'd like to have 4D functions for UTC:

In waiting, see Miyako's nice use of XML DECODE in the same thread. I used it 
to get zone offset in seconds:
 

-- 
Arnaud de Montard 



**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: 4D v16.4 Built database won't open in Mojave

2018-11-05 Thread Koen Van Hooreweghe via 4D_Tech
Hi Walt,

In the past I experienced a similar issue. Seems to be a some kind of 
permissions problem. Could you try to zip your app, transfer the zip to your 
MacBook and unzip it on that machine.

HTH
Koen

> Op 5 nov. 2018, om 02:30 heeft Walt Nelson via 4D_Tech <4d_tech@lists.4d.com> 
> het volgende geschreven:
> 
> I have built a stand-alone Application v16.4 database on a Mac OS machine 
> running High Sierra (10.13.6).
> 
> I successfully create an empty datafile and run it on the same High Sierra 
> (10.13.6) machine.
> 
> I transfer the entire stand-alone built database to a laptop running Mojave 
> (10.14).
> 
> When opening that database, I get the following error: ‘You cannot open this 
> database because the data file (or one of its segments) is locked.’ with an 
> OK button.
> 




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Knesselare
Belgium
tel +32 495 511.653

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**