>A strange problem...
>
>I have a form with parent (header) and child (view) in a grid. Works just fine in VFP but not in .EXE...
>
>Error message:
>

SELECT * FROM crsdata!empldtl WHERE empldtl.repno = mrepno
>   ORDER BY empldtl.fiseff DESC, empldtl.sysdate DESC
>   into cursor Viewcalv89
>Error:   1732
>Data type is invalid for this property.
>Method: navrefresh
>Line:    0

>*note: mrepno was actually programmed as ?mrepno in the view designer; and in the form data environment NOLOAD was set to .T., mrepno gets the value from the parent
>
>Why would it work just fine in VFP as stand-alone but not in .EXE...? All other forms, including views, work just fine.
>
>TIA

Dodi,

I don't know, whould it help, but why are you referencing empldtl table in order by clause? You select only from one table, you don't need to reference it in the order by. I personally never use table prefix in Group/Order by expression.

Though it might be absolutely unrelevant observation...