StrSql = "select max(process_id) from ciqusr_xc_processes where leave_time is null " strsql1 = "select top 1 * from ciqusr_xc_proc_idx where x_cert_style_code is not null and process_id in '" & StrSql & "'" 系统提示:strsql1有错误!是语法错!!错在那里??
不好意思刚才有事离开了 "select top 1 * from ciqusr_xc_proc_idx where x_cert_style_code is not null and process_id in '" & StrSql & "'" 应该是 "select top 1 * from ciqusr_xc_proc_idx where x_cert_style_code is not null and process_id in ('" & StrSql & "')"就是按照大小排序后。排在第二位的?按什么排序?以后描述要严格一点
第二大?不懂
strsql1 = "select top 1 * from ciqusr_xc_proc_idx where x_cert_style_code is not null and process_id in '" & StrSql & "'"
系统提示:strsql1有错误!是语法错!!错在那里??
"select top 1 * from ciqusr_xc_proc_idx where x_cert_style_code is not null and process_id in '" & StrSql & "'"
应该是
"select top 1 * from ciqusr_xc_proc_idx where x_cert_style_code is not null and process_id in ('" & StrSql & "')"就是按照大小排序后。排在第二位的?按什么排序?以后描述要严格一点
in (" & StrSQL & ")
http://www.csdn.net/expert/topic/268/268769.shtm