Jun 9, 2004 #1 dbomrrsm Programmer Joined Feb 20, 2004 Messages 1,709 Location GB Hi All I need to set a field to NULL in a table before I do an update - any ideas on a quick method as the below takes ages. Update MyTable Set MyField = NULL Cheers DBomrrsm
Hi All I need to set a field to NULL in a table before I do an update - any ideas on a quick method as the below takes ages. Update MyTable Set MyField = NULL Cheers DBomrrsm
Jun 9, 2004 #2 hymn Technical User Joined Feb 27, 2003 Messages 1,036 Location GB What do you mean by null? 0 or "" Is it text or numeric Hope this helps Hymn Upvote 0 Downvote
Jun 9, 2004 Thread starter #3 dbomrrsm Programmer Joined Feb 20, 2004 Messages 1,709 Location GB NULL as in if I did a Count (*) FROM MyTable WHERE MyField IS NOT NULL I would get zero Upvote 0 Downvote
Jun 9, 2004 #4 hymn Technical User Joined Feb 27, 2003 Messages 1,036 Location GB try an update query Hope this helps Hymn Upvote 0 Downvote
Jun 9, 2004 Thread starter #5 dbomrrsm Programmer Joined Feb 20, 2004 Messages 1,709 Location GB Thats what I did try - but thanks for your help anyway Upvote 0 Downvote
Jun 9, 2004 #6 hymn Technical User Joined Feb 27, 2003 Messages 1,036 Location GB Yes! I will have to looking at what forum I'm connecting to, it looks as though something has wobbled on my machine Hope this helps Hymn Upvote 0 Downvote
Yes! I will have to looking at what forum I'm connecting to, it looks as though something has wobbled on my machine Hope this helps Hymn
Jun 9, 2004 #7 dcpking Programmer Joined May 16, 2003 Messages 21 Location US It sounds like you have the field indexed, which may be the cause of the slow response (multiple things happening per row updated). A standard procedure is to remove indices, apply update, and re-impose indices. hth Mike Upvote 0 Downvote
It sounds like you have the field indexed, which may be the cause of the slow response (multiple things happening per row updated). A standard procedure is to remove indices, apply update, and re-impose indices. hth Mike
Jun 9, 2004 Thread starter #8 dbomrrsm Programmer Joined Feb 20, 2004 Messages 1,709 Location GB Mike Your right - thanks for the tip which I should have known. Cheers DBomrrsm Upvote 0 Downvote