c++builder6.0 ADO 写sql server2008数据库
我用c++builder6.0的ADO去写sql server2008 数据库中的一个字段,字段类型是geography。当我用ADOQuery执行插入语句的时候出错。出错提示是 message ''geography:'附近有语法错误。‘。
不知道是什么问题,请高手指教!!!!!
表结构 如下:
OBJNUMBintUnchecked
OBJNamevarchar(50)Unchecked
EdgepointsgeographyChecked
EdgepointsXYgeometryChecked
REMARKvarchar(50)Checked
SgsjintChecked
sql语句如下:
insert into T2DWAL(OBJNUMB,OBJName,Edgepoints,EdgepointsXY,REMARK,Sgsj)
values('0','',geography::STGeomFromText('LINESTRING (122.287089 36.366494,122.288803 36.363414,122.290472 36.360314,122.292175 36.357228)',4326),
geometry::STGeomFromText ('LINESTRING (4024835.1 436045.1,4024492.4 436196.4,4024147.5 436343.5)',0)','','')
[解决办法]
那你把ParamCheck属性改一下看看?