Hi Cetin

>Where is the SP ? On VFP database or backend ?

It is a VFP database. '.dbc' not free tables. At the moment we use the VFP ODBC to access the data. Backend??? If you mean SQL Server Or Oracle database. Not yet. But If I can't prove that SPs are a good idea. We will not use then when we convert.

>I assume from your post you don't currently have backend, SP is on VFP database and will simulate SQLExec()ing against another VFP table from another dbc (SP querying Testdata!customer as if it were a backend table) :

I opened the database "MODI DATABASE". Edit the SPs by adding a new one. Compiled the database. Then tried to SQLEXEC() the SP.

PROCEDURE get_proj_hrs
LPARAMETERS pnPersNo, pdWeekAct

SELECT PROJ_HRS.*, ;
SPACE(1) AS ExtSite, ;
.F. AS line_chng, ;
.F. AS match_found, ;
.F. AS new_line ;
FROM PROJ_HRS ;
WHERE INLIST(PROJ_HRS.proj_cat_no, 1, 6) ;
AND PROJ_HRS.wrk_week = pdWeekAct ;
AND PROJ_HRS.accepted = 0 ;
AND PROJ_HRS.refused = 0 ;
AND PROJ_HRS.atelier = 0 ;
AND PROJ_HRS.wrk_hrs <> 0 ;
AND PROJ_HRS.pers_no <> pnPersNo ;
ORDER BY PROJ_HRS.pers_no