RE: select statement problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Eddy (Eddy_at_discussions.microsoft.com)
Date: 09/17/04 

Date: Thu, 16 Sep 2004 23:59:02 -0700

Thanks for all your help,
here some more details about my case.
I am using VFP6 SP4.
I put the statement
select pinvitem.invnum....... order by pinvitem.invnum , pinvitem.partno asc
in a test.prg, then
do test.prg. Result is
I can get a table 'invallo.dbf' and in the record order that I want.
but error occurs in the case as described below

Is this problem only appear in VFP6 ?

"Eddy" wrote:

> Hi,
> The following statement is placed in the init event of myform
>
> thisform.grid1.RowSource = "select pinvitem.invnum, pinvitem.partno,
> pinvoice.invdate ;
> from pinvitem, pinvoice into table invallo where pinvoice.invdate = date() ;
> and pinvoice.invnum = pinvitem.invnum and pinvitem.recstat = 'P' ;
> order by pinvitem.invnum, pinvitem.partno asc"
>
> thisform.grid1.RowSourceType = 4
>
> I got an error message : 'commands contains unrecognized pharse/keyword'
>
> but I do the above 'select' statement alone , it has no error at all.
> please give me a hand
> thanks