Forum > Databases
InsertSQL
Deepaak:
Cannot insert Record.
What Wrong am i doing.
--- Code: Pascal [+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i < x.length; i++) { x[i].style.maxHeight='none'; x[i].style.height = Math.min(x[i].clientHeight+15,306)+'px'; x[i].style.resize = "vertical";}};} --- Query.SQL.Add('Insert into Test(name) values(' + '''Rohit''' + ')'); Query.ExecSQL;
Deepaak:
This also not Working....
--- Code: Pascal [+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i < x.length; i++) { x[i].style.maxHeight='none'; x[i].style.height = Math.min(x[i].clientHeight+15,306)+'px'; x[i].style.resize = "vertical";}};} --- Query.InsertSQL.Add('Insert into Test(name) values(' + '''Rohit''' + ')'); Query.Open;
taazz:
ins't name a keyword in SQL? have you tried to enclose in double quotes or the escape character of your server?
Deepaak:
Tried. used other words in place of name. but not working.
using
--- Code: Pascal [+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i < x.length; i++) { x[i].style.maxHeight='none'; x[i].style.height = Math.min(x[i].clientHeight+15,306)+'px'; x[i].style.resize = "vertical";}};} ---MSSQL SERVER 2008R2 EXPRESS EDITION
fred:
What error do you get?
Navigation
[0] Message Index
[#] Next page