Bug of the Day (2)
-
I can beat that - I discovered a bug where new records were failing to be added. After a number of false trails, I homed in on the following SQL user function:
ALTER function [dbo].[ufn_GetNextID](@IDTable as varchar(100), @IDColumn as varchar(100))
returns integer
as
begin
declare @NewID as integer
set @NewID=0return @NewIDend
"If you don't fail at least 90 percent of the time, you're not aiming high enough." Alan Kay.
-
I can beat that - I discovered a bug where new records were failing to be added. After a number of false trails, I homed in on the following SQL user function:
ALTER function [dbo].[ufn_GetNextID](@IDTable as varchar(100), @IDColumn as varchar(100))
returns integer
as
begin
declare @NewID as integer
set @NewID=0return @NewIDend
"If you don't fail at least 90 percent of the time, you're not aiming high enough." Alan Kay.
:doh:
Gryphons Are Awesome! Gryphons Are Awesome!
-
I can beat that - I discovered a bug where new records were failing to be added. After a number of false trails, I homed in on the following SQL user function:
ALTER function [dbo].[ufn_GetNextID](@IDTable as varchar(100), @IDColumn as varchar(100))
returns integer
as
begin
declare @NewID as integer
set @NewID=0return @NewIDend
"If you don't fail at least 90 percent of the time, you're not aiming high enough." Alan Kay.
I don't see anything wrong there, what does "0" mean anyway?
-
I don't see anything wrong there, what does "0" mean anyway?
richcb wrote:
what does "0" mean anyway?
I believe its the shape of my mouth every time I come across examples like this!
"If you don't fail at least 90 percent of the time, you're not aiming high enough." Alan Kay.
-
richcb wrote:
what does "0" mean anyway?
I believe its the shape of my mouth every time I come across examples like this!
"If you don't fail at least 90 percent of the time, you're not aiming high enough." Alan Kay.
Nice, that had me rollin for a minute! :laugh: