OUCH!!! I just killed about 5-7 hours over the past 2 days troubleshooting a JOIN Select in a CA and without knowing the REQUIREMENT that the CursorSchema *MUST* match the Select statement *EXACTLY*!!!

In my research I found this helpful (confirming) post that Mark McCasland had with someone in 2005:

http://groups.google.com/group/microsoft.public.fox.programmer.exchange/browse_frm/thread/95046ced0745c297/f06f7f5dfcc29f55?lnk=st&q=vfp+cursorschema+match#f06f7f5dfcc29f55

Here is my Select clause. Notice the use of ISNULL to decide whether to pull from one table or the other.
(this is a custom “getSelectCmd” I added to my class to to be called from init() to set the cBaseSelectCmd)


LOCAL lcSelectCmd
lcSelectCmd = []
TEXT TO lcSelectCmd NOSHOW PRETEXT 10
Select qty,
job_item.part_no,
job_item.dwg_no,
isnull(parts.description, job_item.description) as Description,
job_item.price,
job_item.price*job_item.qty as total,
job_item.job_num,
job_item.ipkey,
job_item.item,
job_item.taxable,
job_item.qty_ship,
job_item.qty_billed
from job_item
Left Join parts On job_item.part_no=parts.part_no
ENDTEXT

RETURN lcSelectCmd


Anyway, I just had to be very careful to make the GetCurorSchema return the same exact structure, then it began to work.


During my internet search on the problems I was having, I founf this *MISLEADING* post:
http://www.vfpconversion.com/Article.aspx?quickid=0301112

where the author tries to show in Listing 1 that you can create a schema any way you want, even adding fields that are not even in the Select. Am I missing something, or is this just wrong?