Jump to content

convert vfp query to mysql


ufone

Recommended Posts

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

Link to comment
https://forums.phpfreaks.com/topic/267423-convert-vfp-query-to-mysql/
Share on other sites

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.