下面表达式在sqlserver2000中运用是正常的,现在现在换用access就提示“标准表达式中数据类型不匹配”,请问要怎么修改才能在sqlserver2000与access中都能正常运行呀?string SqlStr;
SqlStr="SELECT users_mst.name, users_mst.nickname, users_mst.class, users_mst.SEnote, users_mst.REnote, users_mst.rgdate," ;SqlStr=SqlStr+"users_mst.uico, record_dtl.reid,record_dtl.datetime, record_dtl.message,record_dtl.ruid,record_dtl.rtid ";SqlStr=SqlStr+" FROM record_dtl INNER JOIN users_mst ON record_dtl.ruid = users_mst.name ";
SqlStr=SqlStr+"where record_dtl.rtid="+Tid+" ORDER BY record_dtl.datetime";// DESC
SqlStr="SELECT users_mst.name, users_mst.nickname, users_mst.class, users_mst.SEnote, users_mst.REnote, users_mst.rgdate," ;SqlStr=SqlStr+"users_mst.uico, record_dtl.reid,record_dtl.datetime, record_dtl.message,record_dtl.ruid,record_dtl.rtid ";SqlStr=SqlStr+" FROM record_dtl INNER JOIN users_mst ON record_dtl.ruid = users_mst.name ";
SqlStr=SqlStr+"where record_dtl.rtid="+Tid+" ORDER BY record_dtl.datetime";// DESC
解决方案 »
- 配置文件大师进~~~~~~~~~~~~~~~~~~~~~~~~~标题要长~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
- TreeView的问题
- 异常详细信息: System.IO.FileNotFoundException
- 一个性能的问题
- 一个好的搜索,欢迎大家进来讨论是怎样实现的~~
- 思归版主大侠,我对你的仰慕之情犹如滔滔江水,连绵不绝,又如东京大地震,一发不可收拾。拜托DX进来指点一下我。
- 错误 310 (net::ERR_TOO_MANY_REDIRECTS):重定向过多。
- 初学者的问题,Sql访问拒绝?
- 问:在ASP.NET下最好用C#还是VB?
- .NET 页面PostBack时,部分控件没获取到回放前的最新状态
- 如何在前台动态修改Label中的字体颜色?
- 求救:image服务器端控件,无法取出图像大小
SqlStr="SELECT [users_mst.name], [users_mst.nickname], [users_mst.class], [users_mst.SEnote], [users_mst.REnote], [users_mst.rgdate]," ;SqlStr=SqlStr+"[users_mst.uico], [record_dtl.reid],[record_dtl.datetime], [record_dtl.message],[record_dtl.ruid],[record_dtl.rtid] ";SqlStr=SqlStr+" FROM [record_dtl] INNER JOIN [users_mst] ON [record_dtl.ruid] = [users_mst.name] ";
SqlStr=SqlStr+"where [record_dtl.rtid]="+Tid+" ORDER BY [record_dtl.datetime]";// DESC
所以类型不对的SQL在SQL2000中有可能通过,在ACCESS中就不行了!
string SqlStr;
SqlStr="SELECT users_mst.[name], users_mst.[nickname], users_mst.[class], users_mst.[SEnote], users_mst.[REnote], users_mst.[rgdate]," ;SqlStr=SqlStr+"users_mst.[uico], record_dtl.[reid],record_dtl.[datetime], record_dtl.[message],record_dtl.[ruid],record_dtl.[rtid] ";SqlStr=SqlStr+" FROM [record_dtl] INNER JOIN [users_mst] ON record_dtl.[ruid] = users_mst.[name] ";
SqlStr=SqlStr+"where record_dtl.[rtid]="+Tid+" ORDER BY record_dtl.[datetime]";// DESC