Question

vf表单中表格查询数据表

select 订货信息表
thisform.grid1.recordsource="select*from 订货信息表;
where 订单编号=allerim(thisform.text1.value);
into cursor temp"
thisform.refresh

Answer 1

这代码有很多错误,少空格,命令写错

select 订货信息表
thisform.grid1.recordsource="select * from 订货信息表 ;
where 订单编号=alltrim(thisform.text1.value) ;
into cursor temp"
thisform.refresh

Answer 2

这代码有很多错误,少空格,命令写错

select 订货信息表
thisform.grid1.recordsource="select * from 订货信息表 ;
where 订单编号=alltrim(thisform.text1.value) ;
into cursor temp"
thisform.refresh