OpenEuphoria

data base keys

• Posted by George Walters <gwalters at sc.rr.com> Jul 31, 2001
• 440 views

I have written a program to import comma delimited ascii date from another
OS and added the keys and records to the EU database system. The data
appears to come back out fine, however the keys put in apparently have been
modified by a trim function which removes all but one interior blank. Is
this so? Or do I have a bug that I can't find?

here's where I get the key

     key = db_record_key(cur_row)

here's how I print it

    puts(html,"\""&key&"\"")

here's what comes out

    " 1 1"

it has had blanks trimm'ed out. this is what went into the data base. one
blank before the 1st one and 4 blanks betweenthe 2 one's.

  " 1    1"

does anyone have this problem, or know if I did something wrong? I check the
incomming key here and it is correct.

key = record[1..loc-1]
  puts(1,key&"\n") <------------ correct here comming in to the data base
from the ascii file.

and added to the database here

    a = insertRecord(key,outRecord)

..george