初学!请问读取数据窗口中的某一行数据,在窗体控件单行编辑框里编辑,如何弄?

[blueflag]

我在一个窗口中,放了数据窗口对象! 想双击某行将该行数据读出赋值给窗口内其他单行编辑框,进行修改,我知道在doubleclicked()下面写代码,我写了,但是不行!! 大鸟们指点一下!!!
this.selectrow(0,false)
this.selectrow(currentrow,true)
ls_name = this.getitemstring(getrow(),"fitname") //ls_name 是变量


SELECT "t_fit"."fitcord",
"t_fit"."fitname",
"t_fit"."fitspec",
"t_fit"."drawfrem",
"t_fit"."drawin",
"t_fit"."unit",
"t_fit"."price",
"t_fit"."class",
"t_fit"."intaksign",
"t_fit"."ascription",
"t_fit"."safetystock",
"t_fit"."limitstock",
"t_fit"."speclass",
"t_fit"."fitsit",
"t_fit"."fitoffer"
INTO :sle_cord.text,
:sle_name.text,
:ls_speclass,
:sle_drfrem.text,
:sle_drin.text,
:sle_unit.text,
:sle_price.text,
:ls_usclass,
:ls_sign,
:sle_ascription.text,
:sle_safetystock.text,
:sle_limitstock.text,
:sle_spec.text,
:sle_fitsit.text,
:sle_fitoffer.text
FROM "t_fit" WHERE "t_fit"."fitname" = 'ls_name' ;

[blueflag]

UP

[AFIC]

SELECT "t_fit"."fitcord",
"t_fit"."fitname",
"t_fit"."fitspec",
"t_fit"."drawfrem",
"t_fit"."drawin",
"t_fit"."unit",
"t_fit"."price",
"t_fit"."class",
"t_fit"."intaksign",
"t_fit"."ascription",
"t_fit"."safetystock",
"t_fit"."limitstock",
"t_fit"."speclass",
"t_fit"."fitsit",
"t_fit"."fitoffer"
INTO :sle_cord.text,
:sle_name.text,
:ls_speclass,
:sle_drfrem.text,
:sle_drin.text,
:sle_unit.text,
:sle_price.text,
:ls_usclass,
:ls_sign,
:sle_ascription.text,
:sle_safetystock.text,
:sle_limitstock.text,
:sle_spec.text,
:sle_fitsit.text,
:sle_fitoffer.text
FROM "t_fit" WHERE "t_fit"."fitname" = :ls_name ;

[blueflag]

谢谢了,我刚想到,楼上大哥就给解决了,谢谢!!!

[魔鬼代言人5800]

即然是直接的SQL语句，为什么要加引号呢
把此号去掉，引用变量时应该这么写:
where t_fit.fitname=:lsname;

[zhlovers]

留个脚印