老师好。分页加载的时候，下面的语句
Dim r1 As
Integer = (Page
- 1) * 50 +
1
Dim
r2 As
Integer = Page *
50
Dim
sql As
String
sql
= "Sele ct * From (Sele ct Row_Number() Over(Order by
[订单ID]) As RowNum, * from 订单) As a "
sql = sql
& " Where
RowNum >= " & r1 & " And RowNum <= " & r2
DataTables("订单").SQLLoad(sql)
我希望表、排序均为变量，
Dim tb_name As String = args(0)
Dim px As String = args(1)
Dim fy As Integer = args(2)
Dim r1 As Integer = (Page - 1) * fy + 1
Dim r2 As Integer = Page * fy
Dim sql As String
sql = "Sele ct * From (Sele ct Row_Number() Over(Order by [px]) As RowNum, * from tb_name) As a "
sql = sql & " Where RowNum >= " & r1 & " And RowNum <= " & r2
DataTables(tb_name).SQLLoad(sql)
执行时有错误
.NET Framework 版本：4.0.30319.42000
Foxtable 版本：2021.5.29.1
错误所在事件：加载[流水]失败!
详细错误信息：
对象名 'tb_name' 无效。
而实际上tb_name的值是 【流水】
请老师帮忙指点，谢谢！
[此贴子已经被作者于2021/9/27 5:29:36编辑过]
加好友 
发短信
Post By：2021/9/27 5:29:00 [显示全部帖子]
此主题相关图片如下：捕获.png