Have you tried something like SELECT CONCAT(item1'-'item2-'-'item3) FROM table ?
2009/7/28 Alfaking <[email protected]> > > Hi everybody, > first of all, I'm sorry for my english, but I'm Italian. > 2 questions > 1) After a select from a db table, I need to concatenate all the > fields into a text file. > this text file should > - contain a line for every single record. (n lines= n record) > - contain a stream of char/integer in fixed position (from the 1st > position to the 8th, the Id, and so on) > - contain blank chars (if the id is 12, it should show " 12" > > how can I do this ? > i know that fixed length string are not supported anymore in > vb.net...I can create a single string (a single line) but I can't > create a fixed lenght string (made up of 120 characters...) > > I've tried to use attributes > <VBFixedString(120)> dim string as string > > but it says that I can't use attributes in local variables... > > 2) after clicking a button, I would like to show a save dialog in > which the user can choose the path and the name of the file (which > should be ready to be saved). > how can I do this ? > > thank you very much >
