RE: can i do the following in v15

2017-03-30 Thread Timothy Penner via 4D_Tech
Hi Chuck,

> OK I get what you are saying. I can however, create tables in a compiled 
> application through SQL. If I do that and then open with older copy of 
> structure which does not have those tables what happens to table and data?

This:

> > In this situation, running a Recover By Record Headers in v1x will
> > show that there are tables with an 'unidentified destination' in the data 
> > file.

...snip...

> > See also:
> > http://livedoc.4d.com/4Dv16-R2/help/Command/en/page1125.html
> > http://livedoc.4d.com/4Dv16-R2/help/Command/en/page1126.html

-Tim



**
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: can i do the following in v15

2017-03-30 Thread Charles Miller via 4D_Tech
On Thu, Mar 30, 2017 at 12:55 PM, Timothy Penner via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Tech Tip: Avoid adding tables to multiple copies of a structure
> PRODUCT: 4D | VERSION: 12.5 | PLATFORM: Mac & Win
> Published On: August 27, 2013
> If using multiple copies of a structure and developing in both; make sure
> that if adding a table, field, or index, that it is only added to the
> master copy.
>
> Any table or field added to the structure will have a unique ID (UUID)
> associated with it. Any data created with that structure is placed in the
> data file with the same UUID reference as the structure file used for
> opening the database.
>
> If a table or field is added to the structure in multiple copies they will
> have different UUIDs. Since the data is stored with the UUID of the
> structure, the data will only be accessible to the structure used for
> adding that data.
>
> Lets say in Structure #A a table named Table_A is added and it is
> automatically assigned a uuid of ABC123.
> Then, in Structure #B a table named Table_A is also added and it is
> automatically assigned a uuid of XYZ987.
>
> Data added to Table_A from Structure #A will only be accessible to
> Strucutre #A as it will have a UUID of ABC123.
>
> If Structure #B attempts to load the data file from Structure #A the
> values associated with UUID ABC123 will not be visible as Structure #B is
> trying to use UUID XYZ987. In other words this data will be lost.
>
> In this situation, running a Recover By Record Headers in v12 will show
> that there are tables with an 'unidentified destination' in the data file.
>
>
OK I get what you are saying. I can however, create tables in a compiled
application through SQL. If I do that and then open with older copy of
structure which does not have those tables what happens to table and data?
This is in v15 and higher

Regards

Chuck


-- 
-
 Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064
 Informed Solutions, Inc.
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D, Sybase & SQL Sever 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.
**
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: Regex Find and Replace with Groups

2017-03-30 Thread Sannyasin Siddhanathaswami via 4D_Tech
Thank you so much! That was exactly what I needed!

Sannyasin Siddhanathaswami

On Mar 29, 2017, 11:44 PM -1000, Vincent de Lachaux via 4D_Tech 
<4d_tech@lists.4d.com>, wrote:
A component is available with source code here : 
http://forums.4d.fr/Post/EN/7161740/1/7161741#7161741

v i n c e n t d e l a c h a u x

Bee green - keep it on the screen



**
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: can i do the following in v15

2017-03-30 Thread Timothy Penner via 4D_Tech
> I have added fields to table_1 in source code version B. Can I go back to 
> Version A, add fields to a different table. and then add same fields to 
> version B without causing any issues. Source code B has other changes in it 
> that the customer is not ready to implement, but needs the change in source 
> code A

http://kb.4d.com/assetid=76862
=
Tech Tip: Avoid adding tables to multiple copies of a structure
PRODUCT: 4D | VERSION: 12.5 | PLATFORM: Mac & Win
Published On: August 27, 2013
If using multiple copies of a structure and developing in both; make sure that 
if adding a table, field, or index, that it is only added to the master copy.

Any table or field added to the structure will have a unique ID (UUID) 
associated with it. Any data created with that structure is placed in the data 
file with the same UUID reference as the structure file used for opening the 
database.

If a table or field is added to the structure in multiple copies they will have 
different UUIDs. Since the data is stored with the UUID of the structure, the 
data will only be accessible to the structure used for adding that data.

Lets say in Structure #A a table named Table_A is added and it is automatically 
assigned a uuid of ABC123.
Then, in Structure #B a table named Table_A is also added and it is 
automatically assigned a uuid of XYZ987.

Data added to Table_A from Structure #A will only be accessible to Strucutre #A 
as it will have a UUID of ABC123.

If Structure #B attempts to load the data file from Structure #A the values 
associated with UUID ABC123 will not be visible as Structure #B is trying to 
use UUID XYZ987. In other words this data will be lost.

In this situation, running a Recover By Record Headers in v12 will show that 
there are tables with an 'unidentified destination' in the data file.

This type of situation should be avoided.
=

See also:
http://livedoc.4d.com/4Dv16-R2/help/Command/en/page1125.html
http://livedoc.4d.com/4Dv16-R2/help/Command/en/page1126.html


-Tim



**
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: Creating a Word document from 4D

2017-03-30 Thread David Rose via 4D_Tech

I erroneously looked at the 4DWrite documentation when I intended to
read the 4DWrite Pro docs. So my post below should have asked whether one 
can

generate a Word doc from 4DWrite Pro.

-Original Message- 
From: David Rose

Sent: Thursday, March 30, 2017 9:25 AM
To: 4d_tech@lists.4d.com
Subject: Creating a Word document from 4D

In a Windows-only 4D v15 db I need to generate Word documents. I haven't
used 4DWrite in a while, but see in the documentation for WR SAVE DOCUMENT
one can save a 4DWrite document as an rtf file. there is also this note:

"Compatibility note: To retain compatibility with previous versions, the
DOC8 (Word 8 Document) type is also supported."

Is anyone saving 4DWrite docs as Word docs, and if so, are there any issues?
Is the formatting in 4DWrite docs faithfully reproduced in the resulting
Word docs? Does the above compatibility note suggest that support for Word
may not be found in future 4DWrite versions?

Are there other ways to generate a Word doc from 4D? The documents I need to
generate will be parallel to a 4D "Detail form for printing" containing
multiple records on each page, and flowing to multiple pages when there are
more records than can fit on one page.

Thanks,
David 



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

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