General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only