on 07-14-2009 3:30 AM
在对供应商名称LFA1~NAME1字段用中文进行模糊查询,比如输入:欣,但是供应商名称中不含u201C欣u201D字的也会出来,这是为什么呢?
我测了下,没有问题啊,把你的源代码贴出来吧
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
我真觉得跟程序没有关系,但贴就贴吧:
1、选择屏幕:SELECT-OPTIONS:S_NAME1 FOR LFA1-NAME1 .
2、SQL语句:
SELECT ANAME1 ASORTL AORT01 APSTLZ ASTRAS ATELF1 ATELFX ATELF2 A~KTOKK
ALAND1 AADRNR ALOEVM ASPERR ASPERM ASPERQ ANODEL BZUAWA AERNAM AERDAT
BSPERR AS SPERR_B BLOEVM AS LOEVM_B BNODEL AS NODEL_B BAKONT B~ZTERM AS ZTERM_B
CEKORG CEKGRP CLIFNR CWAERS CZTERM AS ZTERM_M CINCO1 CSPERM AS SPERM_M CLOEVM
CINCO2 CWEBRE C~BSTAE
INTO CORRESPONDING FIELDS OF TABLE IT_PRINT_001
FROM LFA1 AS A JOIN LFM1 AS C
ON ALIFNR = CLIFNR
JOIN LFB1 AS B ON CLIFNR = BLIFNR AND CEKORG = BBUKRS
WHERE A~NAME1 IN S_NAME1
......
我没有在程序里面去写模糊查询 LIKE '%欣%',就是很平常的多值的情况下的模糊查询,由用户自己输入欣的查询而已
Edited by: MingZhi Xie on Jul 15, 2009 4:27 AM
在OPEN SQL中, 模糊查询采用%欣%的形式查询,
如果使用range table的话,可以用欣 来作查询条件
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.