Hi all
i have a sql select like this :
Select Iif(Isnull(a.fpath),'',a.fpath) As afpath, a.qdate, a.qtime,a.fnum, Iif(Isnull(b.fpath),'',b.fpath) As bfpath,;
iif(Isnull(b.Status),0,1) As Status, c.family, c.Name, d.Name,a.userpass,d.ccode;
FROM ;
questions a ;
LEFT Outer Join answers b ;
ON a.fnum = b.fnum ;
LEFT Outer Join students c ;
ON a.userpass = c.userpass ;
LEFT Outer Join classes d ;
ON c.ccode = d.ccode Into Cursor temp
the problem is that b.fpath is a memo field and if the first record from answres table is empty the rest field in rescords converts to a character field but if it's not empty the rest is ok.
What's wrong?
Ali Mohammad Hossein Zadeh