[Date Prev][Date Next][Subject Prev][Subject Next][ Date Index][ Subject Index]

Xy as database handler--a workable idea



This thread has strayed from my original question, and now I have an idea
for how to answer it.
My question pertained to strings used as comma delimited fields in a record.

suppose you have s/g 01 set to: aaa,bbbb,cc,dddddd,e
You can get the contents of any field neatly, say the third one, by:

«SV02,«VA@01,3»

But to use Xy as an *economical* database handler, you have to be able to
change the contents of any field. How? My new idea is by an inverse
operation--build a new string with all the unchanged contents plus the
changed one. E.g., to change "cc" above to "xxxx":

«SV02,«VA@01,1»+","+«VA@01,2»+",xxxx,"+«VA@01,4»+","+«VA@01,5»»

And the damn thing works!

XPLeNCODE v2.0 b-gin [UNTITLED] {<}SV01,aaa,bbbb,cc,dddddd,e{>};*;[cr|lf]{<}SX02,{<}VA@01,1{> }+","+{<}VA@01,2{>}+",XXXXX,"+{<}VA@01,4{>}+","+{<}VA@01,5{>} {>};*;[cr|lf][BC_]{<}PV02{>};*;[cr|lf]{<}ex{>}[cr|lf] -nd XPLeNCODE Harry Binswanger hb@xxxxxxxx