注册 登录
编程论坛 VFP论坛

关于表所在列的判断

fanjinyu9108 发布于 2023-03-01 16:17, 822 次点击
-个表与表格控件绑定,当我点击表格件某一个单元格,如何返回单元格所在列对应表所在列的字段名
4 回复
#2
fanjinyu91082023-03-01 16:20
或者返回笫几列
#3
吹水佬2023-03-01 17:25
参考示例
程序代码:

* Grid表格中移动鼠标获取指向单元格数据
of = CREATEOBJECT("form1")
of.show(1)

DEFINE CLASS form1 As Form
    Height = 300
    Width  = 420
    AutoCenter = .T.

    Add Object Grid1 As Grid WITH AllowCellSelection=.F.
        
    PROCEDURE Load
        CREATE CURSOR TEMP (F1 C(10), F2 C(10), F3 I)
        INSERT INTO TEMP VALUES ("ABC", "123456", 101)
        INSERT INTO TEMP VALUES ("DEF", "654321", 202)
        INSERT INTO TEMP VALUES ("GHI", "456123", 303)
        INSERT INTO TEMP VALUES ("JKL", "789456", 404)
        INSERT INTO TEMP VALUES ("NMO", "123789", 505)
        INSERT INTO TEMP VALUES ("ABC", "123456", 101)
        INSERT INTO TEMP VALUES ("DEF", "654321", 202)
        INSERT INTO TEMP VALUES ("GHI", "456123", 303)
        GO TOP
    ENDPROC

    PROCEDURE _MouseMove
        LPARAMETERS nButton, nShift, nXCoord, nYCoord
        LOCAL nWhere, nRelRow, nRelCol
        nWhere  = 0
        nRelRow = 0
        nRelCol = 0

        IF thisform.Grid1.GridHitTest(nXCoord, nYCoord, @nWhere, @nRelRow, @nRelCol)
            IF nWhere == 3    && 单元格
                thisform.Grid1.ActivateCell(nRelRow, nRelCol)
                    * 显示单元格数据
                thisform.Caption = "("+TRANSFORM(nRelRow)+":"+TRANSFORM(nRelCol)+")";
                                 +TRANSFORM(thisform.Grid1.Columns[nRelCol].Text1.Value)
            ENDIF
        ENDIF
    ENDPROC

    PROCEDURE Grid1.Init
        this.setall("alignment", 2, "column")
        this.HighlightBackColor = this.BackColor
        this.HighlightForeColor = this.ForeColor
        BINDEVENT(this, "MouseMove",  thisform, "_MouseMove")
    ENDPROC
ENDDEFINE
#4
sdta2023-03-01 17:55
只有本站会员才能查看附件,请 登录

参数:nColIndex 表示单元格所在的列
#5
fanjinyu91082023-03-01 21:28
问题解决了,非常感谢
1