Search results for query: *

Thanks again.

...so we only need to specify the aliases to match the column name for the first subselect and as long as each subsequent subselect has the same number of columns it will use the same alias?

How does this work: "select t.ProjectID , t.RevisionDescription , t.RevisionDate" when untion contains fields named something else in some tables? ex: from ( select ProjectID , RevisionDescription , RevisionDate from Table1 union...

Thank you... I'll give it a go and apply credit later!

What if the column names are slightly different in the tables? Table1 (ProjectID, RevisionName, RevDate) Table2 (ProjectID, RevisionName, RevDate) Table3 (ProjectID, RevisionDesc, RevisionDate) Table4 (ProjectID, RevisionDesc, RevisionDate) Table5 (ProjectID, RevisionDesc, RevisionDate)...

I only want to return the last revision across all tables...

EX: 6 tables (Table1, Table2 ... Table6) All tables have the following columns: ProjectID [String] RevisionDescription [String] RevisionDate [DateTime] I want to use the RevisionDate column to determine the last revision and the ProjectID column to determine the project relationship. Need...

Hello... Has anyone had any luck automating drawings in Solidworks? --- NOTE: I'm using VB6 & Solidworks 2005 --- I've automated some dwgs but had to go back to template drawings because most of the parts we use have such a huge range in size - the dimensions get really out of place...

Hi, I have a system with a RAIDCORE controller & (4) Hitachi 400GB sata drives setup in a RAID5 array with (1) hot spare. I can see the array in the BIOS but when when booted the operating system - WINDOWS 2000 SP4 does not recognize the array. I've looked in disk management but nothing is...

I have two questions: 1) How can I edit custom properties in SW2004 through a VB APP? 2) How can I open a new part, create a sketch & then extrude a sheet metal flange through VB? Just a small example... say one 5 inch line starting at origin 0,0,0 & ending at 0,0,5 & then a flange extruded...

CajunCenturion & LazyMe, Thank you for your helpful replies. If I need to create a batch file to open a process, how can I get the handle for the new window opened by the batch? Should this be a new thread? Thanks, Josh

Hi, I need to shell a program & then keep that program as the active program until it is terminated by the user. Any help appreciated. Thanks, Josh

I WOULD LIKE TO LEARN MORE ABOUT THE WINDOWS API. COULD I GET SOME SUGGESTIONS FOR A GOOD BOOK/LEARNING TOOL. THANKS, JOSH

petermeachem What is the third part control you use to accomplish this?

Hi everyone, I have a question regarding the MAPI control in VB. Can you edit the text style - color, height, etc. in the emails you send? Any input or examples will be greatly appreciated. Thanks in advance, Josh