Search

04-25-2008, 8:12 franc14529 Joined on 12-27-2007 Posts 18 hi ralf(sql error) dear Ralf yes in fact you have right it is an sql error in fact: IF YOU LOOK AT THIS SQL QUERRY: UPDATE tbl_DefaultSMS SET SMS_StatusId=4 WHERE id in(CONVERT(UNIQUEIDENTIFIER,'2f19333f-2314-48d5-b032-9eb6155c3202')) THE CONVERT FUNCTION CONVERT FROM STRING TO UNIQUE IDENTIFIER BUT WHEN VENTUZ GENERATES THIS: UPDATE tbl_DefaultSMS SET SMS_StatusId=4 WHERE id in(CONVERT(UNIQUEIDENTIFIER,'')) THE SQL SERVER GIVES ERROR .THIS IS TRUE. BUT THERE IS SOMETHING IN VENTUZ RELATED TO THIS PROBLEM WHICH IS WHN THE SQL STATEMENT:UPDATE tbl_DefaultSMS SET SMS_StatusId=4 WHERE id in(CONVERT(UNIQUEIDENTIFIER,''))OCCURED I WROTE A C# CODE TO DENY THE EXECUTION OF THE QUERY.BUT THIS C# SEEMS NOT WORKOING AS I WANT. FOR EXAMPLE THIS IS THE C# CODE: if((str1 != "" &&str1 != string.Empty && str1!= null) ) { try { upd(); } catch(Exception ex) { } } WHERE STR1 IS THE ID THAT SHOUL DNOT BE EMPTY. THANKS RALF FOR YOURE INTEREST. BEST REGARDS FRANCOIS SAAB    Report