高校问答京东内购群是真的吗:大家帮我看看这句SQL 语句错在哪里谢啦
来源：百度文库 编辑：高校问答 时间：2024/04/29 12:48:54
我是在VF调使用SQL 语句的.
我使用以下语句从MEMB表中选取记录,放入临时表中,并且作为表格的数据源泉是可以的.
thisform.pageframe1.page1.grdprize_q.recordsource="sele memid as memidt,carid as caridt,memname as memnamet,sj as sjt,phone as phonet,ttod(baoyang) as baoyangT,ttod(baoxian) as baoxiant,bxgs as bxgst,birthday as birthdayt,ttod(clns) as clnst,ttod(jzns) as jznst from memb into cursor temp1"
但是我加上WHERE语句之后却会出错请看下面.
thisform.pageframe1.page1.grdprize_q.recordsource="sele memid as memidt,carid as caridt,memname as memnamet,sj as sjt,phone as phonet,ttod(baoyang) as baoyangT,ttod(baoxian) as baoxiant,bxgs as bxgst,birthday as birthdayt,ttod(clns) as clnst,ttod(jzns) as jznst from memb where baoyang>baoyang_t into cursor temp1"
却会出错呢
野狼想知道，请你再帮帮说
你说的SQL语句前先加入相关引用是怎么加啊？
麻烦你给我说说谢啦
我使用以下语句从MEMB表中选取记录,放入临时表中,并且作为表格的数据源泉是可以的.
thisform.pageframe1.page1.grdprize_q.recordsource="sele memid as memidt,carid as caridt,memname as memnamet,sj as sjt,phone as phonet,ttod(baoyang) as baoyangT,ttod(baoxian) as baoxiant,bxgs as bxgst,birthday as birthdayt,ttod(clns) as clnst,ttod(jzns) as jznst from memb into cursor temp1"
但是我加上WHERE语句之后却会出错请看下面.
thisform.pageframe1.page1.grdprize_q.recordsource="sele memid as memidt,carid as caridt,memname as memnamet,sj as sjt,phone as phonet,ttod(baoyang) as baoyangT,ttod(baoxian) as baoxiant,bxgs as bxgst,birthday as birthdayt,ttod(clns) as clnst,ttod(jzns) as jznst from memb where baoyang>baoyang_t into cursor temp1"
却会出错呢
野狼想知道，请你再帮帮说
你说的SQL语句前先加入相关引用是怎么加啊？
麻烦你给我说说谢啦
VF中的SQL没有接触过，不过就SQL的语法来说，where 怎么能放在into前边呢？
最后from之后的部分应该改称
from memb into cursor temp1 where baoyang>baoyang_t
不过感觉这样也不太符合SQL的语法
我觉得应该是
into cursor temp1 from memb where baoyang>baoyang_t
当然我只是猜测，确实没有接触过VF中的SQL，如果不对，见笑了……
Sql 语句应该有完整的格式,如：
select … from … where…
并不是加个where就叫sql语句，
另：使用sql语句前应先加入相关的引用。