Click here to Skip to main content
15,796,738 members

Comments by GlennAshan (Top 8 by date)

GlennAshan 2-Aug-21 9:48am View    
Yes I know that's the easiest way but my client's requirement(end goal) is to have a windows-service. So I'm working on it, and yes I think I would have to convert the parts which are still VB6 code. Finally I was thinking the same about the line you mentioned has some issues, let's see I'll try to catch the errors using 'Try Catch'. Thank you! :)
GlennAshan 2-Aug-21 9:42am View    
Thank you Richard for your ideas, I think it will help me to debug much easier. :)
GlennAshan 29-Apr-21 13:34pm View    
Got it, thanks Richard!
GlennAshan 29-Apr-21 11:10am View    
Is it possible to combine 2 columns and make a row unique? Ex : Combine both "Cus_no & RangeName"
GlennAshan 16-Apr-21 14:12pm View    
Wow you're amazing Richard. Thank you very much! Can you help me with one more question if possible please and thank you.

I updated my current INSERT queries to

"INSERT INTO {destTableName} ({paramList}) SELECT * FROM NOR_LABOR t1 WHERE NOT EXISTS(SELECT ID FROM {destTableName} t2 WHERE t2.ID = t1.ID)"

"INSERT INTO {destTableName} ({paramList}) SELECT * FROM Setter_Labor t1 WHERE NOT EXISTS(SELECT ID FROM {destTableName} t2 WHERE t2.ID = t1.ID)"

"INSERT INTO {destTableName} ({paramList}) SELECT * FROM wrap_labor t1 WHERE NOT EXISTS(SELECT ID FROM {destTableName} t2 WHERE t2.ID = t1.ID)" so that it won't copy any duplicates from sources to destinations. But it's giving me some exceptions
Exception: Invalid object name 'Setter_Labor'
Exception: Invalid object name 'NOR_LABOR'
Exception: Invalid object name 'wrap_labor'

Any suggestions?