convert vfp query to mysql

[ufone]

thanks

 

insert into dlyatten (code, date, type, category, scode, lCode, sec,syear ) ;

  select code, m.pDate, 1, "P", scode, lCode, Sec,ssyear ; 

  from Student st ;

  WHERE Admtd = 1 ;

AND NOT EXISTS (SELECT * FROM dlyatten dl ;

WHERE dl.code = st.code AND date=pdate )

i want to use with sqlexec command

[Barand]

remove the semi-colons

[ufone]

thanks this portion of codes is working well.

 

text to lcSQL noshow

insert into dlyatten (code, date, type, category, scode, lCode, sec,syear ) values

(?dcode,?ddate,1,'P',?dscode,?dlcode,?dsec,2012 )

             

endtext

 

pDate = date()

SQLExec(m.kpshandle, m.lcSQL)

 

but  this is not working 

 

AND NOT EXISTS (SELECT * FROM dlyatten dl

WHERE dlyatten.code = studentaten.code AND dlyatten.date=m.pdate )

thanks

[fenway]

What does 'not working' mean

[ufone]

receive  error here\

 

 

AND NOT EXISTS (SELECT * FROM dlyatten dl

            WHERE dlyatten.code = studentaten.code AND dlyatten.date=m.pdate )

 

 

[Barand]

Either remove the table alias or use it