Hmm,

strange... next questions:

- Did You upgrade from VFP 8.0 to VFP 9.0
if yes, did you install SP 1 for VFP 9.0?
- What you need cusorscheme?
- If you open table and execute this SELECT SQL, what you get data?


MartinJ


>- What is DataSourceType? (Native, ODBC, ADO, XML)
>- What is SQL for DST IN (Native, ODBC, ADO)
>
>MartinJ
>
>Hi Martin
>thanks for answering
>
>1-Native
>
>2-
>
> cSelectCmd = "SELECT Periodos.fechapago, "+;
> "Conceptos.codigo, Conceptos.descrip, "+;
> "Items.item, Items.itemid, "+;
> "Formulas.formula, Formulas.conceptoid, "+;
> "Haberes.haberid, Haberes.periodoid, Haberes.formulaid, Haberes.paga, "+;
> "Haberes.dias, Haberes.horas, Haberes.cantidad, Haberes.orden "+;
> "FROM sueldos!legajos "+;
> "INNER JOIN sueldos!periodos "+;
> "ON Legajos.legajoid = Periodos.legajoid "+;
> "INNER JOIN sueldos!haberes "+;
> "ON Periodos.periodoid = Haberes.periodoid "+;
> "INNER JOIN sueldos!formulas "+;
> "ON Haberes.formulaid = Formulas.formulaid "+;
> "INNER JOIN sueldos!conceptos "+;
> "ON Formulas.conceptoid = Conceptos.conceptoid "+;
> "INNER JOIN sueldos!items "+;
> "ON Conceptos.itemid = Items.itemid "+;
> "WHERE Legajos.legajoid = " + ALLTRIM(STR(THISFORM.Legajoid, 9, 0)) + " " +;
> "AND Periodos.periodoid = " + ALLTRIM(STR(THISFORM.Periodoid, 9, 0)) + " " +;
> "ORDER BY Haberes.orden"
>