Calling java

[Piotr Chabot Stadhouders via 4D_Tech]

Hi all,

We need to call some java classes from within 4D.
These classes deliver an interface to interact with a smart card connected to 
the local PC
Does anybody have an opinion how to handle this?
I don't see any other way than to use these java classes, and one way or the 
other call this java in 4D

Gr,
Piotr

**
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: SQL query for the current date

[Jeffrey Kain via 4D_Tech]

Thanks for the idea... very clever.  Unfortunately 4D still won't do an indexed 
query in this case like it does when passed a literal.


> On Dec 3, 2018, at 7:49 PM, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> SQL functions such as CURRENT_DATE() seems to return a TIMESTAMP, which may 
> or may not match a native date value.
> 
> for that reason, a C_DATE FN wrapper method seems inevitable if you want to 
> query the database for date values using SQL.

**
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: SQL query for the current date

[Keisuke Miyako via 4D_Tech]

I would hazard a guess that the CURRENT_DATE() function is called for every 
record (row) in the table.

to verify:

create a project method "CD" published for SQL:

$0:=Current date

place a break point.

---

then do

ARRAY DATE($ad;0)

Begin SQL

SELECT Field_2 from Table_1
WHERE  {FN CD() AS TIMESTAMP} = Field_2
INTO :$ad;

End SQL

or

ARRAY DATE($ad;0)

Begin SQL

SELECT Field_2 from Table_1*/
WHERE Field_2 = {FN CD() AS TIMESTAMP}
INTO :$ad;

End SQL

either way, the method is called for all records in table.

if, for example we use a subquery:

ARRAY DATE($ad;0)

Begin SQL

SELECT Field_2 from Table_1
WHERE Field_2 = (SELECT {FN CD() AS TIMESTAMP} FROM Table_1 LIMIT 1)
INTO :$ad;

End SQL

then of course CD() is called only once.

by the way, SQL does not support native date (only) type except when cast from 
a 4D expression or literals.

http://doc.4d.com/4Dv15/4D/15/4D-SQL-engine-implementation.300-2288119.en.html

{ d '2013-10-02' }
{ t '13:33:41' }
{ ts '1998-05-02 01:23:56.123' }

SQL functions such as CURRENT_DATE() seems to return a TIMESTAMP, which may or 
may not match a native date value.

for that reason, a C_DATE FN wrapper method seems inevitable if you want to 
query the database for date values using SQL.

> 2018/12/01 4:00、Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com>のメール:
>
> I'm trying to query 4D Server via the SQL engine from another application, 
> and it seems like if you use CURRENT_DATE() or CURDATE(), the query is always 
> sequential even if an index is available.
>
> Example:
>
>  SELECT InvoiceID from Invoices
>  WHERE CreatedDate=CURRENT_DATE()
>
> ... does a sequential scan of the Invoices table, even though 
> Invoices.CreatedData is indexed. This takes a very long time - probably close 
> to a half an hour.
>
> If I rewrite the where clause as:
>
>  WHERE CreatedDate='2018-11-30'
>
> ... it takes milliseconds.
>
> Is there a trick to being able to write a script that can generically select 
> against the current date?  This is from some php code, fyi... but it's easily 
> reproduced inside of 4D itself.




**
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 Mojave full disk access

[JOHN BAUGHMAN via 4D_Tech]

Thanks for chiming in Keisuke.

Looks like this particular security protection included in Mojave should not be 
anything to worry about for general file access from 4D. 

Amin’s code is certainly good to keep around. Thanks again Amin!

John



> On Dec 3, 2018, at 2:22 PM, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> full disk access on Mojave protect system directories that store private and 
> sensitive information,
> such as browser history, call history, geolocation, messages and contacts.
> 
> https://developer.apple.com/videos/play/wwdc2018/702
> 
> see slide #22 for full list
> 
> 2018/12/04 5:49、JOHN BAUGHMAN via 4D_Tech 
> <4d_tech@lists.4d.com>のメール:
> does one still have access to and remain able to create and move files within 
> the database folder? What about 4D Backup to an external disk?
> 
> 
> **
> 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
> **

**
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 Mojave full disk access

[Keisuke Miyako via 4D_Tech]

full disk access on Mojave protect system directories that store private and 
sensitive information,
such as browser history, call history, geolocation, messages and contacts.

https://developer.apple.com/videos/play/wwdc2018/702

see slide #22 for full list

2018/12/04 5:49、JOHN BAUGHMAN via 4D_Tech 
<4d_tech@lists.4d.com>のメール:
does one still have access to and remain able to create and move files within 
the database folder? What about 4D Backup to an external disk?


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

[Keisuke Miyako via 4D_Tech]

Hello,

there are 4 Mojave related issues listed on the 17.0HF 4 fix list.

https://bugs.4d.fr/fixedbugslist?version=17.0_HF4

ACI0098799On macOS 10.14.x (Mojave), unexpected white vertical line is 
displayed in the Administration window.
ACI0098805Unexpected error "Could not open the specified document because it is 
already in use" when saving a 4D Write and 4D View file on disk on macOS Mojave 
10.14 .
ACI0098908In the method editor, the frame of the auto-completion suggested 
window is no more displayed. On macOS 10.14.x only (Mojave).
ACI0098954Issues with images badly rendered in 4D on macOS 10.14.x (Mojave).

the first one sounds like an SVG issue.

> 2018/12/04 8:30、Cannon Smith via 4D_Tech <4d_tech@lists.4d.com>のメール:
> Do you have more specific information about this 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: Publishing a DB on the WWW. Howto.

[Walt Nelson via 4D_Tech]

Nolen,

As Chuck Miller said, you can check out 4D Lightning to avoid all that nasty 
HTML stuff! ;-0

Here is a link to a demo database using 4D Lightning.

http://www.grahamlangley.co.uk/ 

Graham Langley is the author of 4D Lightning & is very responsive to questions 
& feature requests.

To purchase go here:

http://www.foundationshell.com/product/lightning-2-0-for-4d/ 


Feel free to shoot us any questions you might have.

Thanks,
Walt Nelson (Seattle)
New stuff coming!
www.foundationshell.com 
w...@foundationshell.com 


> On Dec 2, 2018, at 5:56 PM, Nolen via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> Is there a public or demo database anyone can recommend which will help me 
> understand how to achieve this?

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

[Cannon Smith via 4D_Tech]

Hi Jim,

Do you have more specific information about this issue?

Thanks.

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




> On Dec 3, 2018, at 2:54 PM, Jim Hays via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> We had a problem with SVG graphics in v17.0 on Mojave - fixed with v17 HF3.

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

Error in backup index definitions

[Jeffrey Kain via 4D_Tech]

I'm trying to compact my structure file, but it seems to be failing due to this 
error in the "Compacting Backup Index Definitions" step:

Problem on index definition [index 
#1339] : Field reference is invalid


I queried the _User_Indexes system table, but there is no index #1339 (it skips 
over this one).  Is there a way to reset the backup index definitions, wherever 
they are?
**
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: Mojave

[Jim Hays via 4D_Tech]

We had a problem with SVG graphics in v17.0 on Mojave - fixed with v17 HF3.

On Fri, Nov 30, 2018 at 4:47 PM Cannon Smith via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Thanks John and Kirk. I appreciate the feedback. If anyone else has more
> information, feel free to chime in.
>
> Thanks.
>
> --
> Cannon.Smith
> Synergy Farm Solutions Inc.
> Hill Spring, AB Canada
> 403-626-3236
> 
> 
>
>
> > On Nov 30, 2018, at 9:59 AM, John Baughman via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> > I had to convert all my pict format graphics, static and in the picture
> library.  Otherwise 4D would crash when a form containing one or more of
> them was displayed.
> >
> > 16R6.. client is experimenting with a couple of clients running Mojave.
> So far no complaints since fixing the pics. Not tried server yet.
>
> **
> 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
> **
**
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 Mojave full disk access

[JOHN BAUGHMAN via 4D_Tech]

Armin,

Not sure what a DMS folder is, but does one still have access to and 
remain able to create and move files within the database folder? What about 4D 
Backup to an external disk?

Perhaps your code should be implemented just as a normal practice 
regardless.

John


John Baughman
1331 Auwaiku Street
Kailua, Hawaii  96734
(808) 262-0328
john...@hawaii.rr.com

> On Dec 3, 2018, at 10:09 AM, ADeeg via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> 4D Tech mailing list wrote
>> Armin,
>>  Thanks! 
>> 
>>  Could you expand on what you mean by “full disk access”? In Mojave what
>> becomes inaccessible?
>> John
> 
> John, as an example. My App scans the emails from Apple Mail and shows them
> inside a Listbox to work with them (grab attachments, archieve to clients,
> reply,delete, ..) then I move them into a DMS folder. Without full disk
> access it does not work in the usual behaviour like on previous macOS.
> 
> Regards Armin
> 
> 
> 
> 
> 
> --
> Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
> **
> 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
> **

**
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 Mojave full disk access

[ADeeg via 4D_Tech]

4D Tech mailing list wrote
> Armin,
>   Thanks! 
> 
>   Could you expand on what you mean by “full disk access”? In Mojave what
> becomes inaccessible?
> John

John, as an example. My App scans the emails from Apple Mail and shows them
inside a Listbox to work with them (grab attachments, archieve to clients,
reply,delete, ..) then I move them into a DMS folder. Without full disk
access it does not work in the usual behaviour like on previous macOS.

Regards Armin





--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
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 Mojave full disk access

[JOHN BAUGHMAN via 4D_Tech]

Armin,

Thanks! 

Could you expand on what you mean by “full disk access”? In Mojave what 
becomes inaccessible?

John



> On Dec 3, 2018, at 3:38 AM, ADeeg via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> Hi,
> 
> if your app needs full disk access an macOS 10.14.x Mojave and newer, then
> the users have to grant the access for your 4D application.
> 
> 
> I use this to check the access privileges:
> 
> C_TEXT($in;$out;$err;$path)
> If ((<>SystemVersion="Mac 10.14") | (<>SystemVersion="Mac 10.15") |
> (<>SystemVersion="Mac 10.16"))
>   ARRAY TEXT($art_Text;0)
>   $path:=Replace string(System folder(Documents
> folder);"Documents";"Library")+"Safari:"
>   FOLDER LIST($path;$art_Text)
>   If (Size of array($art_Text)=0)
> ALERT("Bla Bla Bla need full disk access bla bla!")
>   $in:=""
>   $out:=""
>   $err:=""
>   SET ENVIRONMENT 
> VARIABLE("_4D_OPTION_BLOCKING_EXTERNAL_PROCESS";"false")
>   LAUNCH EXTERNAL PROCESS("open
> x-apple.systempreferences:com.apple.preference.security?Privacy_AllFiles";$in;$out;$err)
>   End if 
> End if 
> 
> The second LEP call opens system preferences with the needed pane
> 
> Armin
> 
> 
> 
> --
> Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
> **
> 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
> **

**
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: Publishing a DB on the WWW. Howto.

[JOHN BAUGHMAN via 4D_Tech]

Nolan,

As others have pointed out, you have lots of ways to go. I use Xojo 
(xojo.com ) to create web apps to talk to 4D using much of 
what you will find in David Adam’s book “4D Web Companion”. I did a demo of 
what I am doing at a 4DMethod meeting recently which you can find at 
https://4dmethod.com/2018/04/16/april-25th-meeting-4d-with-a-xojo-web-app-front-end-john-baughman/
 
.

No matter what you do, you should read David’s book. I found that once 
his example code is installed in a 4D database, it can be used with any web 
front end you decide to go with. I am currently in the process of converting an 
IOS app that front ends a 4D database using David’s code/approach to a Xojo 
WebApp front end. in the process I have not had to change any of David’s 4D 
code. In fact both the IOS app and the Xojo Web app work are being used 
simultaneously by my client during this rewrite phase.

John


John Baughman
(808) 262-0328
john...@hawaii.rr.com

> On Dec 3, 2018, at 9:08 AM, webmaster namethatplant.net via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Nolen -
> 
> There are many, many more options today than there used to be (browse the 
> iNug archives for some lively discussions), but David Adams book is a 
> comprehensive primer that many developers have used over the years, 
> especially to get started. It is now available for download, free, as David 
> tells us in his 2013 letter below.
> 
> _
> Date: Mon, 4 Nov 2013 18:38:55 +1100
> Subject: 4D Web Companion PDF available for download
> 
> I've been asked many times over the years for a PDF version of this book
> and have finally dug up a copy. You can find the link here:
> 
> http://www.island-data.com/
> ...
> Regarding the PDF:
> * I've embedded a full text index to make searches quicker in some readers.
> 
> * Some readers show a black background on some images instead of a
> transparent background. File under "I can't fix that now." Reader seems
> fine.
> 
> * The bookmark structure - now you all see how I think ;-)
> 
> Regarding the content:
> 4D has done an *amazing* job of keeping their Web server backwards
> compatible. Despite being an old title, most of the content in this book is
> still correct. It's not complete, of course, but it's fundamentally
> correct. Again, that's to 4D's credit, not mine.
> 
> Regarding the cost:
> Free. Thanks to everyone over the years for supporting my trainings and
> writings. Much appreciated! If anyone is overwhelmed by a need to share,
> there's an Amazon referral click-through on my site and I'm always in the
> market for iTunes gift cards to buy yet more birding apps. In any case, I'm
> happy if some of you find the PDF helpful.
> 
> -- David Adams
> 
> _
> To: 4d_tech@lists.4d.com
> Subject: Publishing a DB on the WWW. Howto.
> Date: Sun,  2 Dec 2018 18:56:35 -0700 (MST)
> From: Nolen via 4D_Tech <4d_tech@lists.4d.com>
> Reply-To: 4D iNug Technical <4d_tech@lists.4d.com>
> Cc: no...@internode.on.net
> 
> I have a small DB which does what it needs to do and now I would like to run 
> aspects of it on the WWW.
> I understand this is possible but I don't have any real knowledge of websites 
> and how to publish them.
> 
> Is there a public or demo database anyone can recommend which will help me 
> understand how to achieve this?
> 
> Thanks.
> 
> _
> Sent from http://4d.1045681.n5.nabble.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
> **

**
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: Publishing a DB on the WWW. Howto.

[webmaster namethatplant.net via 4D_Tech]

Nolen -

There are many, many more options today than there used to be (browse the iNug 
archives for some lively discussions), but David Adams book is a comprehensive 
primer that many developers have used over the years, especially to get 
started. It is now available for download, free, as David tells us in his 2013 
letter below.

_
Date: Mon, 4 Nov 2013 18:38:55 +1100
Subject: 4D Web Companion PDF available for download

I've been asked many times over the years for a PDF version of this book
and have finally dug up a copy. You can find the link here:

http://www.island-data.com/
...
Regarding the PDF:
* I've embedded a full text index to make searches quicker in some readers.

* Some readers show a black background on some images instead of a
transparent background. File under "I can't fix that now." Reader seems
fine.

* The bookmark structure - now you all see how I think ;-)

Regarding the content:
4D has done an *amazing* job of keeping their Web server backwards
compatible. Despite being an old title, most of the content in this book is
still correct. It's not complete, of course, but it's fundamentally
correct. Again, that's to 4D's credit, not mine.

Regarding the cost:
Free. Thanks to everyone over the years for supporting my trainings and
writings. Much appreciated! If anyone is overwhelmed by a need to share,
there's an Amazon referral click-through on my site and I'm always in the
market for iTunes gift cards to buy yet more birding apps. In any case, I'm
happy if some of you find the PDF helpful.

-- David Adams

_
To: 4d_tech@lists.4d.com
Subject: Publishing a DB on the WWW. Howto.
Date: Sun,  2 Dec 2018 18:56:35 -0700 (MST)
From: Nolen via 4D_Tech <4d_tech@lists.4d.com>
Reply-To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: no...@internode.on.net

I have a small DB which does what it needs to do and now I would like to run 
aspects of it on the WWW.
I understand this is possible but I don't have any real knowledge of websites 
and how to publish them.

Is there a public or demo database anyone can recommend which will help me 
understand how to achieve this?

Thanks.

_
Sent from http://4d.1045681.n5.nabble.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: Publishing a DB on the WWW. Howto.

[Chuck Miller via 4D_Tech]

Look at lightning 4 for 4D  you can find it 
http://www.foundationshell.com/store/

Regards

Chuck

 Chuck Miller Voice: (617) 739-0306
 Informed Solutions, Inc. Fax: (617) 232-1064   
 mailto:cjmillerinformed-solutions.com 
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D and Sybase connectivity
  http://www.informed-solutions.com  

This message and any attached documents contain information which may be 
confidential, subject to privilege or exempt from disclosure under applicable 
law.  These materials are intended only for the use of the intended recipient. 
If you are not the intended recipient of this transmission, you are hereby 
notified that any distribution, disclosure, printing, copying, storage, 
modification or the taking of any action in reliance upon this transmission is 
strictly prohibited.  Delivery of this message to any person other than the 
intended recipient shall not compromise or waive such confidentiality, 
privilege or exemption from disclosure as to this communication. 

> On Dec 2, 2018, at 8:56 PM, Nolen via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> I have a small DB which does what it needs to do and now I would like to run 
> aspects of it on the WWW. 
> I understand this is possible but I don't have any real knowledge of websites 
> and how to publish them.
> 
> Is there a public or demo database anyone can recommend which will help me 
> understand how to achieve this?
> 
> Thanks.

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

4D Mojave full disk access

[ADeeg via 4D_Tech]

Hi,

if your app needs full disk access an macOS 10.14.x Mojave and newer, then
the users have to grant the access for your 4D application.


I use this to check the access privileges:

C_TEXT($in;$out;$err;$path)
If ((<>SystemVersion="Mac 10.14") | (<>SystemVersion="Mac 10.15") |
(<>SystemVersion="Mac 10.16"))
ARRAY TEXT($art_Text;0)
$path:=Replace string(System folder(Documents
folder);"Documents";"Library")+"Safari:"
FOLDER LIST($path;$art_Text)
If (Size of array($art_Text)=0)
ALERT("Bla Bla Bla need full disk access bla bla!")
$in:=""
$out:=""
$err:=""
SET ENVIRONMENT 
VARIABLE("_4D_OPTION_BLOCKING_EXTERNAL_PROCESS";"false")
LAUNCH EXTERNAL PROCESS("open
x-apple.systempreferences:com.apple.preference.security?Privacy_AllFiles";$in;$out;$err)
End if 
End if 

The second LEP call opens system preferences with the needed pane

Armin



--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
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: Compact data file

[Koen Van Hooreweghe via 4D_Tech]

Hi Keith,

Considering this issue. Last week I had to repair a v16 datafile. In the MSC, 
right after the repair I ran a verification. The verification was done on the 
old datafile. The repaired datafile was still in the subfolder 
'...repairing...' instead of on the original location as I would expect.
I did not test yet, but I guess the files are switched when the MSC is closed 
and not when the repair (compact) is finished. And the extra verify disturbed 
this procedure.

Did you do something similar when compacting?

Kind regards,
Koen

> Op 1 dec. 2018, om 21:41 heeft Keith Goebel via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> Using v17HF3 I have found that, after compacting on Win7, the data files are 
> in the opposite place they are supposed to be (i.e. the compacted one is in 
> the “old” folder and the old one is now the current one).




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