RequestLive=TRUE vs RequestLive=FALSE

Anyone,
     Does anyone know why SQL.Add('where AField='JIM''S') returns a row when
RequestLive = TRUE but errors out when RequestLive = TRUE? Note the Double
quote!