List Info

Thread: Database App
Database App
country flaguser name
United States		 2007-10-23 13:56:56 

  


  

    




  



    

            




Hello 
All,



 



I am trying to 
assist our Quality department with an application that involves a lot of 
documents.  I mentioned that storing the data in the database would 
increase the size of the database too much. ; Instead, we should create 
links to the documents stored on the server.  Is their a particular format 
that the documents should be in?  HTML,PDF,DOC,RTF, other.  What 
should the document be read into to allow the user to scroll through it?  
This is a read and test application.  I am thinking split screen top half 
the document, bottom half the test. ; If anyone has any suggestions on this, 
please forward to me.  We are in the paper design stage of this 
application.  Gotta have a spec you know 


 



Thanks



 


Joseph 
Wasko


 ;



    
  

    
    __._,_.___
    
     
    
    
  
.


    


__,_._,___



  

  
  
   
     
    

  

    Re:  Database App
  


  

     country flaguser name
United States		
     2007-10-23 14:21:16
  


  

    

  


  

    




  



    

            
My preference would be to leave them on the server in their native format and have the app call the proper reader for the type of document.


 



This would be a good practices issue if the documents were mission critical. Leaving things in their native format removes any suspicions of something being lost in the translation process.



 


 


/tr




 


On 10/23/07, Joe Wasko < jpwpannier.com">jpwpannier.com> wrote:














Hello All,


 



I am trying to assist our Quality department with an application that involves a lot of documents.  I mentioned that storing the data in the database would increase the size of the database too much. ; Instead, we should create links to the documents stored on the server.&nbsp; Is their a particular format that the documents should be in?  HTML,PDF,DOC,RTF, other.&nbsp; What should the document be read into to allow the user to scroll through it?  This is a read and test application.  I am thinking split screen top half the document, bottom half the test. ; If anyone has any suggestions on this, please forward to me.  We are in the paper design stage of this application.  Gotta have a spec you know 



 



Thanks



 


Joseph Wasko



 


 





    
  

    
    __._,_.___
    
     
    
    
  
.


    


__,_._,___



  

  
  
   
     
    

  

    Re:  Database App
  


  

     country flaguser name
United States		
     2007-10-23 14:42:49
  


  

    

  


  

    




  



    

            




I agree with Tim, especially about loss in 
translation. But in addition you could set a policy to wherever the documents 
come from that you require them to be in a certain format for all future 
documents. That may help with future upgrades to your application.


Bob



  
----- Original Message ----- 

  
  
  
Sent: Tuesday, October 23, 2007 12:21 
  PM

  
Subject: Re: [helpwithvb] Database 
  App

  


  

  

  
My preference would be to leave them on the server in their native format 
  and have the app call the proper reader for the type of document.

  
 

  
This would be a good practices issue if the documents were mission 
  critical. Leaving things in their native format removes any suspicions of 
  something being lost in the translation process.


  
 

  
 

  
/tr

  


 

  
On 10/23/07, Joe 
  Wasko < jpwpannier.com">jpwpannier.com> 
  wrote: 
  

    

    

    

    

    

    
Hello All,

    
 


    
I am trying to assist our Quality 
    department with an application that involves a lot of documents.  I 
    mentioned that storing the data in the database would increase the size of 
    the database too much. ; Instead, we should create links to the 
    documents stored on the server.&nbsp; Is their a particular format that the 
    documents should be in?  HTML,PDF,DOC,RTF, other.&nbsp; What 
    should the document be read into to allow the user to scroll through 
    it?  This is a read and test application.  I am thinking split 
    screen top half the document, bottom half the test. ; If anyone has any 
    suggestions on this, please forward to me.  We are in the paper design 
    stage of this application.  Gotta have a spec you know  
    

    
 


    
Thanks


    
 

    
Joseph 
    Wasko


    
 

    

    


  



    
  

    
    __._,_.___
    
     
    
    
  
.


    


__,_._,___



  

  
  
   
     
    

  

    RE:  Database App
  


  

     country flaguser name
United States		
     2007-10-23 15:07:31
  


  

    

  


  

    




  



    

            
...and I'll agree with Bob.

 

I wrote an app that checked the extension of a document, and then made its best guess (usually quite good) as to what to open it with.

For the MS apps, it would use COM automation to open the app in its native format.

text files were opened with WordPad, 

pdf, with Acrobat reader, etc.....


 

the app "knew" what document was opened, and when it was closed (used the close events for the MS apps, and shellexecute return values for the others), so there was a "lifetime" to make notes on it.

-BDN



________________________________



From:  helpwithvb%40yahoogroups.com">helpwithvbyahoogroups.com on behalf of Bob

Sent: Tue 10/23/2007 2:42 PM

To:  helpwithvb%40yahoogroups.com">helpwithvbyahoogroups.com

Subject: Re: [helpwithvb] Database App



I agree with Tim, especially about loss in translation. But in addition you could set a policy to wherever the documents come from that you require them to be in a certain format for all future documents. That may help with future upgrades to your application.

Bob



	----- Original Message ----- 

	From: Tim Rupp <mailto: tim.rupp%40gmail.com">tim.ruppgmail.com>  

	To:  helpwithvb%40yahoogroups.com">helpwithvbyahoogroups.com <mailto: helpwithvb%40yahoogroups.com">helpwithvbyahoogroups.com>  

	Sent: Tuesday, October 23, 2007 12:21 PM

	Subject: Re: [helpwithvb] Database App



	

	My preference would be to leave them on the server in their native format and have the app call the proper reader for the type of document.

	 

	This would be a good practices issue if the documents were mission critical. Leaving things in their native format removes any suspicions of something being lost in the translation process.


	 

	 

	/tr



	 

	On 10/23/07, Joe Wasko < jpw%40pannier.com">jpwpannier.com <mailto: jpw%40pannier.com">jpwpannier.com> > wrote: 



		


		Hello All,

		 

		I am trying to assist our Quality department with an application that involves a lot of documents.  I mentioned that storing the data in the database would increase the size of the database too much.  Instead, we should create links to the documents stored on the server.  Is their a particular format that the documents should be in?  HTML,PDF,DOC,RTF, other.  What should the document be read into to allow the user to scroll through it?  This is a read and test application.  I am thinking split screen top half the document, bottom half the test.  If anyone has any suggestions on this, please forward to me.  We are in the paper design stage of this application.  Gotta have a spec you know  

		 

		Thanks

		 

		Joseph Wasko

		 



		




		




		



	





    
  

    
    __._,_.___
    
     
    
    
  
.


    


__,_._,___



  

  
  
   
     
    
 
        
    

    
    






 [1-4]











   
 





about | contact  Other archives ( Real Estate discussion Medical topics )