TIP: Click on subject to list as thread! ANSI
echo: clipper
to: STEVEN READ
from: JOOP BUKER
date: 1997-09-08 20:23:00
subject: Low ascii in database

Hello Steven Read and Bryan Smith
I thank you both for thinking with me in trials on the clipper road.
Your remarks
 SR> Wrong way to use a database.  Instead of attempting to split up a
 SR> field by using low ASCII markers, why not use seperate fields like
 SR> a database is designed too?
 SR> Use fields like
 SR>   LN            FN          MN           TITLE
 SR>   __________________________________________--
 SR>   Johnson       Jane                     Mrs.
 SR>   Johnson       John        Henry        Mr.
 SR> Am I reading you right?  What is wrong with this method?  Is disk file
 SR> space an issue? :-)
are certainly right. Space on the hard disk urges me to put different entries 
in one field. I gave you an example with names, but I also want to use this 
method with other data. In a table I am working with I have data that are 
split up in one to five strings of 1 to 35 characters, but the total length 
of the five strings together is never more than 35 characters. If I would 
make five different fields of 35 characters each that would make my table 
four times as big as necessary (with 80 - 90% empty space!!!). When you have 
not one but more of these kind of data, it makes a megabyte sized table into 
a gigabyte one. That is why I want to put entries that we usualy would put in 
different fields into one field. And I want to use low ascii's because they 
are not on the keyboard, so the person who is using my program cann't make 
mistakes.
But I don't know what I had done wrong when testing this method. When I 
repeated my testprogram this day with the line
                 replace Alias->Field with chr(001)
       or        Alias->Field := chr(001)
in it, it gave a beautiful smiley in my table. And so it went with almost all 
the low ascii's.
I thank you both for thinking with me in my problems on the clipper road.
Greetings
   Joop Buker  (Holland)
--- FMail 1.02
---------------
* Origin: daal +31-318-555956/ISDN 548095 (2:283/218.418)

SOURCE: echomail via exec-pc

Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.