On Sat, 23 Feb 2008 14:54:15 -0500
Drew Jensen <[EMAIL PROTECTED]> dijo:
> > questioncode required, 12 uppercase chars + three digits,
> > must be unique, keyed field
> > stem must be unlimited amount of text (some stems
> > are very long)
> > romannumeral1-4 four fields for Roman numeral answers, must be
> > unlimited text
> > answera-d four fields for answers, must be unlimited text
> > answer the letter answer (A-D), required, must be one
> > uppercase letter of A-B-C or D
> > explanation must be unlimited text (some explanations are half a
> > page long)
> > miscellaneous there are half a dozen miscellaneous short text
> > fields that have been used in the past for selecting. I need to preserve
> > these because they contain the record of where the questions been used
> > previously.
> >
> > The unlimited text fields above are the ones I can't figure out. Apparently
> > there is a "memo" field type, but it appears to want to save the text for
> > each field in each record as a separate text file. If that is correct I'd
> > end up with about 70,000 files on my hard disk. That is unworkable, but I
> > can't figure out any other field type to use where the contents can be any
> > kind of text in any quantity. I could specify a very large number of
> > characters, but I wouldn't want the database to use that size unless
> > necessary.
> Memo fields are correct for this and no they do not save into separate
> files, they also allocate space only for the amount of data stored in
> them ( plus a couple of bytes ). Not sure what you mean by "any kind of
> text" exactly. Do you mean you actually want to store text and formatting?
>
> One thing, don't involve the clipboard here - just open the two Base
> files ( the one that connects via ODBC to Kexi and the new native file )
> drag the table from the one to the other, be sure to drop it into the
> table section of the Base window, or on the Table icon.
The first thing I tried before posting the above was to drag the table from
the database that is connected to Kexi into the table area in the new database.
No go. I tried dropping it into the Tables window area and onto the Tables
icon, but no matter where I tried to drop it nothing happens. The cursor does
not change shape either.
After discovering that drag and drop didn't work I tried the paste method and
that seemed to work, except that I didn't know enough about the different field
types so I had to stop. But now that I know that memo is what I want I tried to
finish the paste. Unfortunately, that does not work either. I get all the way
to the end of the wizard and then it says "Unexpected token in statement
[CREATE TABLE 'mainbank" ("questioncode" VARCHAR(100,]."
The end of the above error code changes according to the various ways I tried
to specify the data type on questioncode, but it always fails. There is
something about questioncode in the Kexi database that Base is puking up. All I
know is that in the original Access table it is required, 12 characters, keyed,
and must be unique. I wonder if there is a bug in Base such that it is
creating incorrect SQL. For example, I wonder if there should be a close
parenthesis at the end of "100."
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
