Click here to Skip to main content
15,867,453 members

Comments by Mel Padden (Top 6 by date)

Mel Padden 21-Jun-17 10:07am View    
"If the .OCX file is not located in your windows/system32/ folder you must add the file path before the filename.ocx"

Does that apply even when you are running the command prompt in the same directory as the OCX? Seems wrong... The registry record written contains the full filepath.
Mel Padden 9-May-14 10:19am View    
Reason for my vote of 1 \n What the...? "Magic Tables"? And no you don't quote the word Trigger. Calling a trigger a "Trigger" is like calling yourself a "Developer" which is, I guess, about right, looking at this article.
Mel Padden 16-Nov-11 10:50am View    
I would have to see the options of your Internet Exporer instance, but I have run into problems before where some JavaScript options were disabled for one reason or another. Try comparing the security settings for one pc with those of the other as a starting point.
Mel Padden 16-Nov-11 7:12am View    
So you need to update the same column in several tables. With the same value?

Create a database transaction, and in the transaction you update each table with the required value. That way, if one fails, you can roll back all the changes.

Something like:

BEGIN TRANSACTION

UPDATE [TableName] Set Col = @Value WHERE <condition>
UPDATE [TableName2] Set Col = @Value WHERE <condition>
UPDATE [TableName3] Set Col = @Value WHERE <condition>

IF @@ERROR <> 0 BEGIN
ROLLBACK
END ELSE BEGIN
COMMIT
END
Mel Padden 1-Nov-11 12:48pm View    
Deleted
Reason for my vote of 4
Reason I'm using a temp table in the first place is because I need to in the context of the application I'm working on. A table variable would, of course, work perfectly. Just not in this instance, hence the tip/trick.