求一个vfp问题急急急急！！！！！

[chenyonge]

在写一个vfp程序中，怎样联接字符串
如：
sql='select jfcj,jscj,jfsx from aaa'
如果我想一个where 条件应该怎么加呢？
如
sql='select jfcj,jscj,jfsx from aaa where jx="J15"' 是这样写吗？
我试了好象不行，请各位大侠指点一下，谢谢了

[WWWWA]

1、直接在字符串后面+ " WHERE jx='J15'"
2、注意字段类型

[chenyonge]

SQL='SELECT JIXING AS jx,'+;
'LINGJIANTUHAO AS ljth,'+;
'JIAOFUCHEJIAN AS jfcj,'+;
'JIESHOUCHEJIAN AS jscj,'+;
'JIAOFUSHUNXU AS jfsx,'+;
'GONGYILUXIAN AS gylx,'+;
'LEIJIPIJIACI AS LJPJC '+;
'FROM T_YIJIAOJINDU'+ " WHERE jx='J15' and jfcj='XL'"
是这样的吗？好象不对吧

[WWWWA]

[Quote=引用 7 楼 chenyonge 的回复:]
SQL='SELECT JIXING AS jx,'+;
'LINGJIANTUHAO AS ljth,'+;
'JIAOFUCHEJIAN AS jfcj,'+;
'JIESHOUCHEJIAN AS jscj,'+;
'JIAOFUSHUNXU AS jfsx,'+;
'GONGYILUXIAN AS gylx,'+;
'LEIJIPIJIACI AS LJPJC '+;
'FROM T_YIJIAOJINDU'+ " WHERE jx='J15' and jfcj='XL'"
是这样的吗？好象不对吧


[/Quote]
你将SQL语句显示出来看看，什么地方不对？说了那么久，你一直没有说明是什么问题

[chenyonge]

SQL='SELECT JIXING AS jx,'+;
'LINGJIANTUHAO AS ljth,'+;
'JIAOFUCHEJIAN AS jfcj,'+;
'JIESHOUCHEJIAN AS jscj,'+;
'JIAOFUSHUNXU AS jfsx,'+;
'GONGYILUXIAN AS gylx,'+;
'LEIJIPIJIACI AS LJPJC '+;
'FROM T_YIJIAOJINDU'+ " WHERE jx='J15' and jfcj='XL'"
我就是想问问where 条件这样加对吗？因为我vfp不是很明白，要用这个语句，前面加单引号后面是双引号我有点没看明白你要是
确认对，我回去试试

[WWWWA]

是这样的，SQL语句正确

[tszsc]

SQL="SELECT JIXING AS jx,"+;
"LINGJIANTUHAO AS ljth,"+;
"JIAOFUCHEJIAN AS jfcj,"+;
"JIESHOUCHEJIAN AS jscj,"+;
"JIAOFUSHUNXU AS jfsx,"+;
"GONGYILUXIAN AS gylx,"+;
"LEIJIPIJIACI AS LJPJC "+;
"FROM T_YIJIAOJINDU"+ ;
" WHERE jx='J15' and jfcj='XL'"

[tszsc]

你把这个字符串在vf中显示一下，看看有无错误；没有错误再到sql查询分析器输入一次，看有无错误。

[chenyonge]

先谢谢大家，我回去试试，我这边的电脑没有vf

[十豆三]

变量或字段前加个?号

[十豆三]

[Quote=引用 11 楼 tszsc 的回复:]
SQL="SELECT JIXING AS jx,"+;
"LINGJIANTUHAO AS ljth,"+;
"JIAOFUCHEJIAN AS jfcj,"+;
"JIESHOUCHEJIAN AS jscj,"+;
"JIAOFUSHUNXU AS jfsx,"+;
"GONGYILUXIAN AS gylx,"+;
"LEIJIPIJIACI AS LJPJC "+;
"FROM T_YIJIAOJINDU"+ ;
" WHERE jx='J15' and jfcj='XL'"
[/Quote]

这样就可以

[chenyonge]

谢谢大家问题已解决

[WWWWA]

是这样，表中是否有满足条件的记录？什么错误信息？

[chenyonge]

有记录的，就是联接字符串不对

[WWWWA]

[Quote=引用 2 楼 chenyonge 的回复:]
有记录的，就是联接字符串不对
[/Quote]
什么联接字符串？有什么提示？代码贴全

[missingmolly]

sql="select jfcj,jscj,jfsx from aaa where jx='J15'" 试试

[chenyonge]

SET ANSI ON
user0='aaaa'
paswd='bbbb'
sever='SCDB'
source='Oracle'
gnConnHandle=SQLSTRINGCONNECT('DSN=&source;uid=&user0;pwd=&paswd;server=&sever;')



SQL='SELECT JIXING AS jx,'+;
'LINGJIANTUHAO AS ljth,'+;
'JIAOFUCHEJIAN AS jfcj,'+;
'JIESHOUCHEJIAN AS jscj,'+;
'JIAOFUSHUNXU AS jfsx,'+;
'GONGYILUXIAN AS gylx,'+;
'LEIJIPIJIACI AS LJPJC '+;
'FROM T_YIJIAOJINDU'



nNum=SQLEXEC(gnConnHandle,SQL,'ZB')



SELECT ZB

COPY TO ZB

*UPDATE ZB SET LJPJC=STUFF(ALLTRIM(LJPJC),at('/',ALLTRIM(LJPJC)),1,'+') WHERE '/'$ LJPJC



MJX='J15'
JHB='jh'
MPCC='00'
PL=9

UPDATE &JHB SET jfjf=ALLTRIM(ljpjc) FROM ZB ;
where ALLTRIM(ZB.JX)==ALLTRIM(MJX) AND ALLTRIM(ZB.LJTH)==ALLTRIM(&JHB..LJTH) ;
AND ALLTRIM(ZB.JFCJ)==ALLTRIM(&JHB..JFCJ) AND ALLTRIM(ZB.JSCJ)==ALLTRIM(&JHB..JSCJ) ;
AND ALLTRIM(ZB.JFSX)==ALLTRIM(&JHB..JFSX)


UPDATE &JHB SET jfsl=Qjsl*VAL(SUBSTR(ALLTRIM(ljpjc),3,2))+VAL(RIGHT(ALLTRIM(ljpjc),LEN(ALLTRIM(ljpjc))-4)) FROM ZB ;
WHERE LEFT(ALLTRIM(ljpjc),2)=LEFT(ALLTRIM(mpcc),2) AND ljpjc>'0' ;
AND ALLTRIM(ZB.JX)==ALLTRIM(MJX) AND ALLTRIM(ZB.LJTH)==ALLTRIM(&JHB..LJTH) ;
AND ALLTRIM(ZB.JFCJ)==ALLTRIM(&JHB..JFCJ) AND ALLTRIM(ZB.JSCJ)==ALLTRIM(&JHB..JSCJ) ;
AND ALLTRIM(ZB.JFSX)==ALLTRIM(&JHB..JFSX)


这个代码运行起来是没有问题的，现在我就是想在'FROM T_YIJIAOJINDU' 后加上where 条件不会加

[cigarette_program]

也不给分啊。