Click here to Skip to main content
16,016,489 members

Comments by Shahvez Irfan (Top 10 by date)

Shahvez Irfan 14-Mar-12 7:56am View    
lad, this would obviously work since the condition never meets! the selected item will always be null, and hence the condition will be skipped through! what i want is to go inside the if condition
Shahvez Irfan 15-Oct-11 20:34pm View    
Got it! thanks, lad..that was helpful
i have a question though? can the UPDATE query work on all the entries of the tables? mine apparently replaces the all previously INSERTED rows with the same value. the code is as follows in the solution box:-
Shahvez Irfan 15-Oct-11 17:47pm View    
yeah, you're right, but what if my table is empty? the insert query appends the same data in rows when the code is run the second time..how do i use update to first populate the table with the values, and then when i run the code again with the updated values, it should replace the values initially inserted?
Shahvez Irfan 15-Oct-11 14:16pm View    
Thank you, lad! it works now..the only issue is that iam not getting any values in my table like i was with the Insert command...i open the table and i get null values..any idea there?
Shahvez Irfan 15-Oct-11 11:43am View    
that gives me an exception: Must declare the scalar variable "@NewDateWHERE".