Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ken Murphy
  Where is Ken Murphy?
 Springhill
 Canada
 Ken Murphy
 To: subhankar pandey
  Where is subhankar pandey?
 Kolkata/Delhi
 India
 subhankar pandey
 Tags
Subject: RE: How to prevent to modify record
Thread ID: 155246 Message ID: 155250 # Views: 1 # Ratings: 0
Version: Visual FoxPro 8 Category: Databases, Tables and SQL Server
Date: Friday, December 28, 2007 2:00:27 PM         
   


> Hi All,
>
> I've simple one question. How to prevent to modify the records once it is taken print-out thru report writer.
>
> Best Regards
> Subhankar

Not sure what you are asking here. If you print the record to an Excel file (using FRX2ANY or something like that) the user can then modify the value in the excel file and there isn't really anything that you can do about it.

If, after the report has been printed, you wish to make that record "read only," there really isn't a native function to help you out. On the other hand, you can "roll yer own" so to speak. Add a logical field to the table and call it "lPrinted." You can then add a business rule that prevents an update if the record has already been printed. Something like this:


IF MyTable.lPrinted
RETURN .f. && Record has been printed so do not modify
ELSE
RETURN .T. && Record has not been printed so go ahead.
ENDIF

Ken
You shall know the truth - and the truth shall set you free. (John 8:33)

ENTIRE THREAD

How to prevent to modify record Posted by subhankar pandey @ 12/28/2007 1:20:53 PM
RE: How to prevent to modify record Posted by Mike Gagnon @ 12/28/2007 1:59:13 PM
RE: How to prevent to modify record Posted by Ken Murphy @ 12/28/2007 2:00:27 PM
RE: How to prevent to modify record Posted by subhankar pandey @ 12/29/2007 8:43:59 AM
RE: How to prevent to modify record Posted by Olaf Doschke @ 12/29/2007 12:45:49 PM
RE: How to prevent to modify record Posted by subhankar pandey @ 12/31/2007 6:22:15 AM
RE: How to prevent to modify record Posted by Ken Murphy @ 12/29/2007 1:23:50 PM
RE: How to prevent to modify record Posted by subhankar pandey @ 12/31/2007 6:20:37 AM
RE: How to prevent to modify record Posted by Olaf Doschke @ 12/28/2007 10:55:48 PM
RE: How to prevent to modify record Posted by subhankar pandey @ 12/29/2007 8:57:01 AM
RE: How to prevent to modify record Posted by Olaf Doschke @ 12/29/2007 1:10:12 PM
RE: How to prevent to modify record Posted by subhankar pandey @ 12/31/2007 6:24:55 AM