Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 5 of 5 total |
Importing tables |
Sat, Mar 10 2007 8:26 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
Prior to renaming a field I used your utility to export the data. Did the necessary messing around to drop and add the field. Then did a DELETE FROM table to the data with the now blank new field and used import facility. I was rewarded by error 601, the index page is empty. IMPORT TABLE "Transactions" FROM 'E:\MyM\New Folder\Transactions.csv' DELIMITER CHAR ',' QUOTE CHAR '"' DATE FORMAT 'yyyy-mm-dd' TIME FORMAT 'hh:mm:ss n' AM LITERAL 'AM' PM LITERAL 'PM' DECIMAL CHAR '.' BOOLEAN TRUE LITERAL 'True' FALSE LITERAL 'False' USE HEADERS MAX ROWS -1 ================================================================================ SQL Error (ElevateDB 1.01 Build 1) ================================================================================ ElevateDB Error #601 The table Transactions is corrupt (The index page is empty) Roy Lambert |
Mon, Mar 12 2007 4:56 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< Prior to renaming a field I used your utility to export the data. Did the necessary messing around to drop and add the field. Then did a DELETE FROM table to the data with the now blank new field and used import facility. I was rewarded by error 601, the index page is empty. >> Try it with 1.01: http://www.elevatesoft.com/scripts/incident.dll?action=viewaddr&category=edb&release=1.01&type=f&incident=2232 -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Mar 13 2007 3:55 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
>Try it with 1.01: I was - 1.01b1 Roy Lambert |
Tue, Mar 13 2007 6:22 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< I was - 1.01b1 >> I could have sworn that the error message said 1.00, but I was seeing things. Could you email me the catalog/table ? -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Mar 14 2007 4:25 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
It will be sent. But it might not do any good there's been a slew of changes. Roy Lambert |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |