relational fields and @rf

[Nancy Palmquist]

Christopher Yerry wrote:
[snip..]

>  
> If you want something fast filepro is a good solution. but The data has 
> no security !!!! the
> database structure can be hacked by a 5 year old. Its fast in its 
> LIMITED set of what it can do.

I agree about the security.  However, I understand the ability to 
encrypt data is high on the list of features for the next release.  I 
think that will no longer be an issue.  In the past, it has been a 
blessing to have easy access to the data, for repair purposes. Hardware 
would crash, OS systems were buggy, but since 1980 much has changed.  I 
think that is now overridden by the need for security.  Backups and 
reduncancy offer ways to protect the data files from hardware failures.

>  
> I have used filePro for 15 years. In fact I make a lot of money with it 
> because no one seems to know how to use it and for that I am thankful I 
> know it.
> but
> I would not trust my fortune 500 company to filepro on the web. I might 
> trust my dentists office but not a large application.
>  
> Besides
> - It requires record locks (I have not used them in any program in 14 
> years. Their are better ways to handle this)
> - It locks records and cannot run reports (yes I know you can shut it 
> off but it could cause a problem if it is supposed to be locked)
> - it was written in 1977 then it was great but no one has brought it 
> into the 21st century
> - Maybe I should write filePro .net  ... hm-mm

The record lock is never ignored.  It will ignore a file lock to allow 
report running.  It can offer options as to what to do if it encounters 
a locked record during a report execution.  Your choice as to what to do 
are as follows, (I believe) wait, ignore the record, log the record.  I 
prefer to require reports that will posting data to run in the wait mode 
if they must be run without a file lock but I have never found that to 
be necessary.


>  
> (a 25 user license of SQL2000 is only $1500)

Filepro license for 25 users is $2125 - not a significant difference.

Does that include tools for developing/generating reports?
I understand that you need Crystal reports or some other cevelopment 
tools to handle output.

You also realize that filePro could act as those tools very easily using 
the SQL data directly.  This is one of the best tricks I have seen.  It 
could provide data entry, outputs, build indexes, etc directly to your 
SQL data.

>  
> I am not a filepro basher. I do believe @rf is an improper solution and 
> should never be used. It encourages bad programming practices. Common 
> code for multiple tables would be a huge step up. Multiple copies of the 
> same code is suicide!!!! and their is no other way of doing it!!
>  

Library code has been possible for 2 versions since (4.8).  It certainly 
makes my life easier.  I have routines for security, printer selection, 
authorization controls, logging controls, etc. that are shared.  It sure 
saves a lot of time to manage programming that is central, as we all know.

Nancy
>  
> Christopher Yerry
> 
>  
> 
> ------------------------------------------------------------------------
> Do you Yahoo!?
> Yahoo! Mail - Find what you need with new enhanced search. Learn more. 
> <http://us.rd.yahoo.com/evt=29917/*http://info.mail.yahoo.com/mail_250>
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list


-- 
Nancy Palmquist 		MOS & filePro Training Available
Virtual Software Systems	Web Based Training and Consulting	
PHONE: (412) 835-9417		   Web site:  http://www.vss3.com