On Sun, 24 Feb 2008 04:52:58 -0500 Drew Jensen <[EMAIL PROTECTED]> dijo:
> John Jason Jordan wrote: > > 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." > WTF - I also continue to get that error with 2.3.1, 2.4 Rc1 and the > Linux Dirto version of OO.o...when an ODBC data source is used. > > The only thing that works as far as I can tell is if you create the > table first and then just do an append data. I already tried that. I created a new database with a new, empty table that has the same structure. Then I discovered that you can't do a query that connects one database to another. I can query within the database connected to the Kexi database, or I can query within the new Base database, but neither sees the tables in the other. I can't figure out any way to export the data from the Base-Kexi database. However, I can use Kexi to open it, then export as CSV. I did so, then tried to open the CSV into the new Base database. Unfortunately, Base cannot import CSV data either. I can, however, open the CSV file, although OOo opens it in Calc, not Base. I saved it from Calc as an ODS file, but Base won't touch that either. Dragging and dropping from Calc also does not work. Finally, I tried copying and pasting from Calc. Recall that copying and pasting from the Base-Kexi database pukes on the questioncode field. Well, copying and pasting from Calc throws up any of several different error messages depending on how I specify the structure of the new table. The copy and paste wizard also offers the Append option. I created a new table in the new Base database with the appropriate structures, then tried the Append option. After many attempts I finally got the data into a new table in the new Base database. There are still a couple problems: 1) When i created the table in Base into which I appended the data from Calc I set the fields to memo, except for QuestionCode (fixed, 12, required) and AnswerKey (fixed, 1, required). I need to set QuestionCode to unique as well, but I can't find any way to do that. 2) I recreated the query that was giving me trouble in the Base-Kexi database, i.e., the sort was not working. Well, it's still not working. I need to sort the records on the last three characters of the selection string, not on the entire value of the field. The SQL of the query is: SELECT * FROM "MainBank" WHERE ( ( "Selections" LIKE '%LFc-___' ) ) ORDER BY "Selections" ASC I can't do it in design view - that is, in design view I can specify sort as ascending or descending, but it sorts on the entire contents of the field, not just the portion in the select string (see SQL above). I don't understand HSQL syntax well enough to change the ORDER BY manually. Maybe I could insert the selection string into another field and sort on that field? (I have an unused field that I could use.) But if so, the insertion would have to be temporary, otherwise the unused field would quickly fill up from successive queries. Any suggestions for the remaining problems? --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
