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

On 1997-09-03 (23:13) JOOP BUKER wrote about
JB> I am working with Clipper 5.2.
JB> .... want to use these low ASCII symbols is that I want to
JB> put entries of different length, one after another in a field.
JB> The symbols must work as markers that separate the strings
JB> while keeping the index in order and don't make it a ruin, what
JB> high ASCII symbols would do.
JB> To give an example of some records with names (but it can be
JB> every other entry):
JB> record 1:     Johnston John Mr.
JB>                       ^    ^
JB> record 2:     Johnstons Jane Mrs.
JB>                        ^    ^
JB>    ^ indicates where marker must come
JB> Greetings Joop Buker (Holland).
Wrong way to use a database.  Instead of attempting to split up a
field by using low ASCII markers, why not use seperate fields like
a database is designed too?
Use fields like
  LN            FN          MN           TITLE
  --------------------------------------------
  Johnson       Jane                     Mrs.
  Johnson       John        Henry        Mr.
Am I reading you right?  What is wrong with this method?  Is disk file
space an issue? :-)
Later,
Steve, in western New York state (USA)
---
 * QMPro 1.53 * steven.read@pcohio.com
--- InterEcho 1.19
---------------
* Origin: PC-Ohio PCBoard * Cleveland, OH * 216-381-3320 (1:157/200)

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™.