J
jiangxidna
Unregistered / Unconfirmed
GUEST, unregistred user!
function RtnSQlvalue(sSQL : string;
sFieldname : string) : string;
begin
with Epdm.PowerDM.Query3do
begin
close;
SQL.clear;
SQL.Add(sSQL);
try
Open;
except
Result:='-1';
end;
first;
IF eof then
Result:=''
else
Result:=FieldByname(sFieldName).asstring;
close;
SQL.clear;
end;
end;
sql语句为:select z_m84 from map.xlxd where z_label='1100000835'
查询结果为:‘43129983,75283934’
result的返回结果为;result的结果为:‘43129983,75283934’#¥A
请问怎么样把后面#¥A去掉
sFieldname : string) : string;
begin
with Epdm.PowerDM.Query3do
begin
close;
SQL.clear;
SQL.Add(sSQL);
try
Open;
except
Result:='-1';
end;
first;
IF eof then
Result:=''
else
Result:=FieldByname(sFieldName).asstring;
close;
SQL.clear;
end;
end;
sql语句为:select z_m84 from map.xlxd where z_label='1100000835'
查询结果为:‘43129983,75283934’
result的返回结果为;result的结果为:‘43129983,75283934’#¥A
请问怎么样把后面#¥A去掉