Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 2 of 2 total |
multiple select into memory |
Tue, Jun 12 2007 6:22 AM | Permanent Link |
"Harry de Boer" | Ls
dbIsam 3.30 (D6) Several select into statements only add the records of the last statement. select * into memory VHtmp from VH; select * into memory VHtmp from VH; I want to do this in a loop for the VH tables in different db's and add all records to the memory table. First I thought that I could use for the second and later loops the INSERT INTO statement but there are more then 100 fields and I guess that then I must type all the fields. Or is there a better way to do this in in SQL? Regards, Harry |
Tue, Jun 12 2007 7:07 AM | Permanent Link |
"Harry de Boer" | Got it already. Sorry for asking
Regards, Harry "Harry de Boer" <harry@staaf.nl> schreef in bericht news:2D27D951-9A15-46B6-A0B0-9497E2F90977@news.elevatesoft.com... > Ls > > dbIsam 3.30 (D6) > > Several select into statements only add the records of the last statement. > select * into memory VHtmp from VH; > select * into memory VHtmp from VH; > > I want to do this in a loop for the VH tables in different db's and add all > records to the memory table. First I thought that I could use for the second > and later loops the INSERT INTO statement but there are more then 100 fields > and I guess that then I must type all the fields. Or is there a better way > to do this in in SQL? > > Regards, Harry > > |
This web page was last updated on Friday, April 19, 2024 at 07:09 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |