Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #3069

Re: Storing pages of text file inside a DBF

From Sherlock <sherlock@sherlock.com.au>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Storing pages of text file inside a DBF
Date 2012-03-04 04:43 -0800
Organization http://groups.google.com
Message-ID <31922068.2560.1330864996232.JavaMail.geo-discussion-forums@pbjv6> (permalink)
References <41547047-e5c4-484c-b079-3867d7cf630d@o16g2000yqg.googlegroups.com>

Show all headers | View raw


snip[ stores pages delimited by any page delimiter(FormFeed,string) into a Memo
> field . Each page is identified by a unique key in certain page of a> file(eg : Account number) certain line ,certain position ,fixed length > of account number .
> Also Is the storage in DBF will allow Unicode ?]

You can store anything in a memo and you can put it directly into an FPT without a DBF or the DBF/FPT combination.

Read VO2.8 help.  You can stringify the data, or store as an array or use 

fuction ReadTest()	

   LOCAL aSettings := {}	AS ARRAY
 
   USE ( 'test' ) NEW SHARED VIA {'DBFBLOB'}
   IF BLOBRootLock()	
	aSettings := BLOBRootGet()	
	BLOBRootUnlock()
    ENDIF
    USE
    //
    RETURN aSettings

FUCNTION WriteTest( aSettings AS ARRAY)		

   LOCAL lSuccess := FALSE 	AS LOGIC
	
   // Open DBV to write our data.. with no DBF
   IF File( 'test.dbv')
      USE ( 'test' ) NEW SHARED VIA {'DBFBLOB'}
      IF BLOBRootLock()	
	BLOBRootPut(aSettings)	// Finally, store the settings
	BLOBRootUnlock()
      ENDIF	
      USE
   ELSE
     ErrorBox{,"The TEST.DBV file is missing.. This is not good!"}:show()
   ENDIF	                                         
   //
   RETURN lSuccess

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Find similar | Unroll thread


Thread

Storing pages of text file inside a DBF happytoday <ehabaziz2001@gmail.com> - 2012-03-03 07:24 -0800
  Re: Storing pages of text file inside a DBF Sherlock <sherlock@sherlock.com.au> - 2012-03-04 04:43 -0800

csiph-web