Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Incident Reports » Incident Reports Addressed for Version 4.05 » View Incident Report |
Serious |
Reported By: Robert Kaplan Reported On: 3/12/2004 For: Version 4.04 Build 1 |
This works: SELECT * INTO TEMP from Tbl1 ORDER BY Code; ALTER TABLE TEMP ADD C Autoinc; update temp set Code = C; alter table temp drop c; delete from Tbl1; insert into Tbl1 select * from temp; This doesn't: SELECT * INTO "\Memory\TEMP" from Tbl1 ORDER BY Code; ALTER TABLE "\Memory\TEMP" ADD C Autoinc; update "\Memory\TEMP" set Code = C; alter table "\Memory\TEMP" drop c; delete from Tbl1; insert into Tbl1 select * from "\Memory\TEMP";
This web page was last updated on Tuesday, April 23, 2024 at 08:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |