gmane.comp.lang.inug-4d.tech

Re: Transaction usage.. was backup script

Arnaud de Montard — 2012-05-18T10:00:37

Le 17 mai 2012 à 20:26, Chip Scheide a écrit :


Hi Chip, 
shortly, yes, but please don't be offended. 

I consider the example (1) here:
<http://doc.4d.com/4D-Langage-13/Transactions/Utiliser-des-transactions.300-738062.fr.html> 
 start transaction
 add record
 ...
is not a good one. Or, more precisely, not a good example when the number of users grows. In that context, each parent record in a transaction spreads the lock to all touched records. I see that like a forrest in which each logger would delimit zones much more time than needed to cut a few trees. The more they are, the more they interfere. 

I too have sometimes huge forms, involving many records, and I can't ignore transaction. The "transitional" data is stored in arrays (add/delete/modify), and transaction is done at end, when validating. The example above becomes:
 add record
 store changes done by user in arrays
 on validate, start transaction, store arrays, end transaction

I've seen some years ago this situation: a database with transact

4D v3 Non Profit needs help with modifying a report

SummerGATE — 2012-05-17T23:18:16

Hi All,

Our summer program for gifted students in San Francisco has been  
using a database built in version 3 for years, partly out of pride-it  
was designed by one of our students. The last person who knew the  
program well has left us however, and we are in need of a couple  
small changes to one of our reports. If you would like to discuss the  
issue and are familiar with this early version of 4D, please let me  
know. The computer is not networked and is running on an older Mac,  
so ideally we would be able to find someone willing to come by our  
office for an hour or two.

David

**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/products/new.html

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-Unsubscribe-d2/MUvgIt

Re: Version 3 reports-help!

David St Martin — 2012-05-17T00:03:00

I think you saved me. I now can select design under the Use menu! 

-----Original Message-----
From: John Bowen <jebowenag79< at >gmail.com>
Sender: 4d_tech-bounces< at >lists.4D.com
Date: Wed, 16 May 2012 16:42:46 
To: 4D iNug Technical<4d_tech< at >lists.4d.com>
Reply-To: 4D iNug Technical <4d_tech< at >lists.4D.com>
Subject: Re: Version 3 reports-help!

If this is this Macintosh, try pressing option-f.

If you only have Designer password, that's OK.

Do you know if it is compiled, or just interpreted?

On Wed, May 16, 2012 at 1:16 PM, SummerGATE <sgate2< at >earthlink.net> wrote:

RE: v12 Modal Print Dialog

Jeffrey Kain — 2012-05-17T20:58:47

Oops - sorry about that! Glad it worked though...

Jeff

-----Original Message-----
From: 4d_tech-bounces-d2/MUvgItPNWk0Htik3J/w< at >public.gmane.org [mailto:4d_tech-bounces-d2/MUvgItPNWk0Htik3J/w< at >public.gmane.org] On Behalf Of Kevin Abraham
Sent: Thursday, May 17, 2012 4:34 PM
To: 4D iNug Technical
Subject: Re: v12 Modal Print Dialog

Thanks for the point in the correct direction!!! That worked!

However just for people looking in the future the setting on v12.3 under Windows is not where you referenced. Instead try:

Design -> Database Settings. Then click the Interface icon and then Display Printing Progress check box is in the User box.

There a Compatibility section to the Database Settings but I could not find anything in that screen relating to printing.

**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/products/new.html

4D Internet Users Group (4D iNUG)
FAQ:  http

Re: v12 Modal Print Dialog

Kevin Abraham — 2012-05-17T20:33:31

Thanks for the point in the correct direction!!! That worked!

However just for people looking in the future the setting on v12.3 under Windows is not where you referenced. Instead try:

Design -> Database Settings. Then click the Interface icon and then Display Printing Progress check box is in the User box.

There a Compatibility section to the Database Settings but I could not find anything in that screen relating to printing.

Thanks again!!

Kevin Abraham
Digital Retirement Solutions
kabraham-kp4CdzbD+QFBDgjK7y7TUQ< at >public.gmane.org

On May 17, 2012, at 2:22 PM, Jeffrey Kain wrote:



**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/products/new.html

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-Unsubscribe-d2/MUvgItPNW

RE: v12 Modal Print Dialog

Jeffrey Kain — 2012-05-17T20:22:30

Kevin,

In the database Preferences, in the Compatibility section, mark the option to display printing progress.

-----Original Message-----
From: 4d_tech-bounces-d2/MUvgItPNWk0Htik3J/w< at >public.gmane.org [mailto:4d_tech-bounces-d2/MUvgItPNWk0Htik3J/w< at >public.gmane.org] On Behalf Of Kevin Abraham
Sent: Thursday, May 17, 2012 4:04 PM
To: 4D iNug Technical
Subject: v12 Modal Print Dialog

v2004 conversion to v12 printing long (thousands of pages to PDF and up to an hour to print) jobs using PRINT FORM  and PAGE BREAK (>) puts up a dialog that is modal (can't click on any other process in 4D) that reads "Sending Print File to print spooler" with a single "Cancel" button.

This is new and, might I dare say, more than just a little annoying. Anyone have any idea how to turn this functionality off????

Thanks in advance!

**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/product

v12 Modal Print Dialog

Kevin Abraham — 2012-05-17T20:04:11

v2004 conversion to v12 printing long (thousands of pages to PDF and up to an hour to print) jobs using PRINT FORM  and PAGE BREAK (>) puts up a dialog that is modal (can't click on any other process in 4D) that reads "Sending Print File to print spooler" with a single "Cancel" button.

This is new and, might I dare say, more than just a little annoying. Anyone have any idea how to turn this functionality off????

Thanks in advance!

Thanks,
Kevin Abraham
Digital Retirement Solutions
kabraham-kp4CdzbD+QFBDgjK7y7TUQ< at >public.gmane.org




**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/products/new.html

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-Unsubscribe-d2/MUvgItPNWk0Htik3J/w< at >public.gmane.org
**************************

Re: Transaction usage.. was backup script

Alan Chan — 2012-05-17T19:18:12

Hi Chip,

I don't think Arnaud was arguing importance of transaction which is a must
for all kind of mission critical application that care about data
integrity.

Transaction could be very short and only started and ended inside one
execution - Save/Delete Record. It means when it executes, it immediately
return success or failure.

You don't need to start a transaction when you're editing, having coffee
or ..... When you're editing a record, the record is locked regardless
it's in transaction or not. Other users can't modify it anyway.

We use transaction and trigger intensively. We never need to do editing in
an open transaction. Working in an open transaction is less efficient and
increase chances of locking up records from other users.

Alan Chan

4D iNug Technical <4d_tech-d2/MUvgItPNWk0Htik3J/w< at >public.gmane.org> writes:

**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.

[ANN] Technical Service Position Opening at 4D, Inc.

4DList Admin — 2012-05-17T19:02:03

Job Title:  4D Technical Support Team Member



4D, Inc., is seeking an experienced individual to join our Technical Support Team who is dynamic, motivated and multi-talented, with a great passion for development.



In this role, you will be responsible for ensuring our customers' success and satisfaction with our software products and contributing to their long-term loyalty. You will work closely with the rest of the Technical Team delivering overall superior service and support to our customers. You will also interface with our QA, R&D and marketing teams. You'll have lots of opportunities to make a big difference within the company by volunteering to participate in projects of your choice including developing applications, conducting Webinars, presenting at our conference or local meetups, and more.



Minimum Requirements:

 *   At least 3 years experience programming in 4D
 *   Must have experience with SQL
 *   Good understanding of relational database design
 *   Writing code that is

Transaction usage.. was backup script

Chip Scheide — 2012-05-17T18:26:24

Araud,
ok - so then, my 'way' of doing things you would disagree with.

Many of the entry/edit forms in my system are many layers deep.
So data entry of a new record, or editing of an existing record, may require the creation, or changing of many related records, some portion of which the user never sees, such as many-many relational links.

When a user starts a new record, or edits an existing one (from a listing form) I start a transaction. This transaction ends when the user accepts or cancels the primary (starting) record.

Without a transaction to manage this process, I am writing code to store the "before" state of ALL the records involved in the entry/edit and then when the user cancels the change(s) I have to go back through and insure that the database state, for those records touched by that user, is left in the same state in which they started. Including removing related records added by the user, replacing related records deleted by the user, as well as, if needed, updating relational linking rec

RE: web browser client authentication

Joshua Fletcher — 2012-05-17T17:22:23

Seems to be tons of info via Google.  Search for "how to become a certificate authority", for example.

Kind regards,

Josh

--
Josh Fletcher
Technical Account Manager
4D, Inc.





-----Original Message-----
**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/products/new.html

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-Unsubscribe-d2/MUvgItPNWk0Htik3J/w< at >public.gmane.org
**********************************************************************

web browser client authentication

David Ringsmuth — 2012-05-17T16:52:51

Using openssl we have designed a system with our own self generated
Certificate Authority ("CA"), and our own generated and self-signed
client.crt and client.key.

The IE9 process of following the Certificate Authority path breaks when it
encounters our self generated CA which has no signer recognized in the web
client's certificate trust. 

I do not know how to overcome this issue. If you know of a way around the
web-browser negotiation process for accepting CA's, please help!

Our goal is to give the web client what it needs so that it will accept our
CA, and use the client cert we automatically generate for client web
authentication (using nginx in front of 4D).

The answer is probably "We must get our CA signed by a CA known to and
trusted by the web clients CA trust path."

If you know the answer to this a "yes I agree" or "no that is not right...",
or you can do it this way... is greatly appreciated.

Thanks!
David Ringsmuth

**********************************************************************
4D v13

Re: Need a script to make backups

Arnaud de Montard — 2012-05-17T16:40:15

Le 17 mai 2012 à 16:20, Chip Scheide a écrit :


I've not a lot of sites still in 2003, but I never used anything else. 
Backup works ~100%. Log no. 



A transaction waiting for the guy gone to drink a coffee is a nonsense: transaction is a transitional state, and like in chemistry, it is unstable; so the shorter it is, the better it is. It can't be user dependent. 
See about the checkbox "Automatic Transactions during Data Entry":
<http://doc.4d.com/4D-Design-Reference-13/Database-settings/Compatibility-page.300-832732.en.html>
"this option is intended only for 4D First users. It should not be used for 4D applications, where it is preferable that the transactions be handled by the developer."
It's a souvenir of a toy.

Re: Need a script to make backups

Jörg Knebel — 2012-05-17T16:09:28

Chip,

On 18/05/2012, at 24:20 AEST, Chip Scheide wrote:


NO, guess why I implemented my own 'Copy-data' backup stuff. ;-)

And YES, I'm still using it with v12!!!



I cant say anything about running 'Transactions' since I haven't been forced to use them yet, but it sounds like something to take care of.

The rule of thumb for a 'nilly-vanilly-copy-data-backup' approach would be:

- Set a SEMAPHORE on the server to avoid new connections
- EXECUTE ON CLIENT: ShutDown with ALERT to user and take care of running things (last action: FLUSH BUFFERS) at the user side before 'QUIT 4D'
  (give the client machine / user x minutes to quit before force quitting)
- Continues checks on the server side 'Are all Clients gone?'
- Clean/Repair the data (NAN's, Gremlins - the works)
- FLUSH BUFFERS within your SP
- make YOUR backup and optional compress it...
- CLEAR SEMAPHORE



Welcome to the club!
Just ask me what of the current OS's is the greatest piece of sh**...




Thanks.

Cheers
Jörg

Regards
Jörg Knebe

Re: How to automatically log out user after period of inactivity?

Kirk Brooks — 2012-05-17T15:59:43

I thought I'd share what I've done with this for anyone following.

First the need is to log off inactive users. They use up resources and
lock up records. I have my own user/password system in place and only
allow a user to have one login at a time.

Tim Nevell's suggestion of the ON EVENT CALL method is the way to go.
At startup I install a method called _Activity_logger which does two
things: 1) is updates 2 IP variables (<>dts_time_out and
<>dts_time_warn). (I prefer to use string vars for date/time pairs so
these are YYYYMMDDhhmmss. One can use time & date vars too you simply
need 4 instead of 2.) "Time out" is when the shut down will happen and
"time warn" is a few minutes earlier. I use this one to pop open a
warning window a few minutes before the shutdown. So the second thing
it does is close that warning dialog it it's open. My code looks like
this:

C_STRING(14;<>DTS_time_out;<>DTS_time_warn)
C_TIME($time)
$time:=Current time(*)+?00:10:00?  ` 10 minutes of inactivity
<>DTS_time_out:=DTS_Make_From_

Re: Need a script to make backups

Chip Scheide — 2012-05-17T14:20:06

anyone using 4D backup in v2003 (or earlier?).

Since 4D backup will not complete if a transaction is open, it becomes a requirement to force connected clients to either exit (my choice), or to lock them from opening anything that starts a transaction, and forcing any open ones to complete.

On a Mac, we are are used to simply copying the data files, willy-nilly, as there are no restrictions from the OS, i've found issues when trying to do this on windows.

so..
add those 2 points up :)

On Thu, 17 May 2012 21:09:47 +1000, Jörg Knebel wrote:
-----------
We the people - 
stand within the the ruins of society,
a jail intended to out live us all.
**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/products/new.html

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/option

Re: Set file name when printing PDF?

Bill Weale — 2012-05-17T12:37:44

Thanks for the suggestions. This sound like a great "standard" to follow.

Bill

envoyé par ma Etch-a-Sketch

On May 16, 2012, at 4:19 PM, Kirk Brooks <lists.kirk-Re5JQEeQqe8AvxtiuMwx3w< at >public.gmane.org> wrote:

**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/products/new.html

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-Unsubscribe-d2/MUvgItPNWk0Htik3J/w< at >public.gmane.org
**********************************************************************

Re: Need a script to make backups

Jörg Knebel — 2012-05-17T11:09:47

On 17/05/2012, at 01:36 AEST, Arnaud de Montard wrote:




Who would have thought of this...

Regards
Jörg Knebel - 4D Developer since 1991
TTT Data Systems Pty Ltd
Phone: +61 (0)2 6334 4730
www.tttdatasystems.com.au



**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/products/new.html

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-Unsubscribe-d2/MUvgItPNWk0Htik3J/w< at >public.gmane.org
**********************************************************************

Re: Disabling Line Item In Popup

Koen Van Hooreweghe — 2012-05-17T07:29:09

Steve,

Below a list of the metacharacters for menus (from the language  
reference for the APPEBND MENU ITEM command), but I don't know if they  
still work. I remember having some trouble and I switched to Dynamic  
pop up menu.

• To disable an item: Place an opening parenthesis (() in the item  
text.
• To specify a separation line: Pass "-" or "(-" as item text.
• To specify a font style for a line: In the item text, place a less  
than sign (<) followed by one of these characters:
<B Bold
<I Italic
<U Underline
• To add a check mark to an item: In the item text, place an  
exclamation mark (!) followed by the character you want as a check  
mark. On Macintosh, the character is displayed; on Windows, a check  
mark is displayed no matter what character you passed.
• To add an icon to an item: In the item text, place a circumflex  
accent (^) followed by a character whose code plus 208 is the resource  
ID of a Mac OS-based icon resource.
• To add a shortcut to an item: In the item text

Re: e-Node License system

Justin Leavens — 2012-05-17T00:11:58

Tom Dillon-2 wrote
I second that request... And on that note, if anyone from e-node is in the
office this week, I could use an email returned in order to quell an anxious
client.

--
View this message in context: http://4d.1045681.n5.nabble.com/CalendarSet-v4-Call-for-feature-requests-tp5131534p5711191.html
Sent from the 4D Tech mailing list archive at Nabble.com.
**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/products/new.html

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-Unsubscribe-d2/MUvgItPNWk0Htik3J/w< at >public.gmane.org
**********************************************************************

RE: MD5 plug-in not working in V12

Randy Engle — 2012-05-16T23:17:27

I vote for Miyako's Crypto Plug-in.

Works Fab!

Randy Engle


-----Original Message-----
From: 4d_tech-bounces-d2/MUvgItPNWk0Htik3J/w< at >public.gmane.org [mailto:4d_tech-bounces-d2/MUvgItPNWk0Htik3J/w< at >public.gmane.org] On
Behalf Of Keisuke Miyako
Sent: Wednesday, May 16, 2012 3:10 PM
To: 4D iNug Technical
Subject: Re: MD5 plug-in not working in V12

Hello,

this one takes advantage of the OpenSSL installed on the system (OS X) or
included in 4D.

http://sources.4d.com/trac/4d_keisuke/wiki/Plugins/Common%20Crypto

miyako

On 2012/05/16, at 2:19, Terry Lee wrote:

due to the fact we use this on the server and we are running the 64 bit
server.
the old command and the new command.
using this successfully?


**********************************************************************
4D v13 is available now - with more than 200 new features to make
your applications richer and faster
http://www.4d.com/products/new.html

4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/