Hi All.
can we relation db on SPT in VFP command like this :
SQLEXEC(_skon, "select * from leave_dtl_mst", "leave_dtl_mst")
SELECT leave_dtl_mst
INDEX ON EMP_ID+YEAR TAG DTL_ID
SELECT LEAVE_DTL_MST
SET ORDER TO DTL_ID
SQLEXEC(_skon, "select * from leave_mst", "leave_mst")
SELECT leave_mst
INDEX ON EMP_ID+LVPERIOD TAG MST_ID
SELECT LEAVE_MST
SET ORDER TO MST_ID
SET RELATION TO MST_ID INTO LEAVE_DTL_MST
SELECT LEAVE_MST
THISFORM.REFRESH
I got an error saya "Variable MST_ID is not found" ? i am using db MYSQL. any suggestion ?
can we relation db on SPT in VFP command like this :
SQLEXEC(_skon, "select * from leave_dtl_mst", "leave_dtl_mst")
SELECT leave_dtl_mst
INDEX ON EMP_ID+YEAR TAG DTL_ID
SELECT LEAVE_DTL_MST
SET ORDER TO DTL_ID
SQLEXEC(_skon, "select * from leave_mst", "leave_mst")
SELECT leave_mst
INDEX ON EMP_ID+LVPERIOD TAG MST_ID
SELECT LEAVE_MST
SET ORDER TO MST_ID
SET RELATION TO MST_ID INTO LEAVE_DTL_MST
SELECT LEAVE_MST
THISFORM.REFRESH
I got an error saya "Variable MST_ID is not found" ? i am using db MYSQL. any suggestion ?