Add where 1=0 in your SelectCmd command. In addition, specify there all columns instead (and if you don't need some, remove them)

>>Can you post your CAs definitions? Are you trying to select everything from these tables?
>
>Here it is. No I am not selecting everything. Right now, it won't work even if Nodata = .T. =(
>
>

>**************************************************
>*-- Class:        caparcel (d:\vfp9dev\pelican\classes\pelican.vcx)
>*-- ParentClass:  mysqlcursoradapter (d:\vfp9dev\classes\ntier.vcx)
>*-- BaseClass:    cursoradapter
>*-- Time Stamp:   07/09/10 08:55:10 AM
>*
>#INCLUDE "d:\vfp9dev\includes\system.h"
>*
>DEFINE CLASS caparcel AS mysqlcursoradapter
>
>
>	UseDeDataSource = .T.
>	SelectCmd = "select * from parcel"
>	>	Alias = "parcel"
>	Flags = 0
>	KeyFieldList = "ID"
>	Tables = "parcel"
>	>	parentalias = "joborder"
>	parentkeyfields = "id"
>	keyfields = "joborderid"
>	hasautoincfield = .T.
>	autoincfield = "pid"
>	Name = "caparcel"
>
>ENDDEFINE
>*
>*-- EndDefine: caparcel
>**************************************************
>
>