thanks, actualy you gaved me an idea to try. my problem was that i did not use quotes

grid1.recordsource = "MySql into cursor 'AnyCursorName'"

that did the trick.

thanks again for your help.

Gunnar


>Not quite clear how do you define Grid.RecordSource, but anyway, try this:
>In form.INIT
>with this.Grid1
>lccom="YOUR Select statement go here as a plain string without ; and with the clause into cursor tmpcurs or other appropriate cursor name"
>.RecordSourceType=4
>.RecordSource=lccom
>.Refresh
>endwith
>
>>hi everybody
>>
>>i am trying to have a grid with

.recordsourcetype = 4 && sql

. in the erference it states that the sql statment is to be entered in the .recordsource property. i have tryed and must be doing something wrong, because i am getting the error:"Syntax Error", however, in the command window this command is working. here is the sql statement i have entered:
>>

>>sele ;
>>   receipts.item, ;
>>   receipts.pono, ;
>>   receipts.qtyrcd, ;
>>   podet.qtyord ;
>>   from receipts, podet, pomast ;
>>   where ;
>>      receipts.pono = pomast.pono .and. ;
>>      receipts.pono = podet.pono .and. ;
>>      receipts.item = podet.item
>>

>>i have no clue what i am doing wrong, can anyone put me on the right path.
>>
>>thanks in advance (i work with Vfp 6.0 Sp 5)