strSQL:='SELECT Dest_Terminal_Id as ''群发号码'',dt as ''群发时间'',Real_Service_id as ''业务类型''';
strSQL:=strSQL+' FROM Cmpp_to_ismg_200803_bak ';
strSQL:=strSQL+' WHERE (Sp_code = ''921233'') and Msg_Content like ''%'+strSendText+'%''';
strSQL:=strSQL+' Order by Report_stat';
----如上所示,程序报错:Cmpp_to_ismg_200803_bak为无效说明:Cmpp_to_ismg_200803_bak是数据表,每月生成一个,单独在SQL Server2000里,运行此SQL语句能成功,不知是何原因,求教于大虾们,谢谢!
strSQL:=strSQL+' FROM Cmpp_to_ismg_200803_bak ';
strSQL:=strSQL+' WHERE (Sp_code = ''921233'') and Msg_Content like ''%'+strSendText+'%''';
strSQL:=strSQL+' Order by Report_stat';
----如上所示,程序报错:Cmpp_to_ismg_200803_bak为无效说明:Cmpp_to_ismg_200803_bak是数据表,每月生成一个,单独在SQL Server2000里,运行此SQL语句能成功,不知是何原因,求教于大虾们,谢谢!
再看你程序中联接的是哪个数据库。
再看你程序中联接的是哪个数据库,如果不一致,那肯定要出错的。