Exclusive won't change things. Have you tried reindexing?
>
>Thanks for your attention. The problem is focused on a method which performs the following clause:
>
>
>SELECT MAX(V.fecierre) AS pivote, ;
> H.numpoliz, H.codmodal,M.codrease, C.nombre, ;
> C.apellid1, C.apellid2,C.tipdocid, C.numident, ;
> C.fecnacim,(H.edactuin + H.anualida)-1 AS edactuin, ;
> C.sexo,H.fecinpol AS fecinief,H.durseg, ;
> H.fecfinef, ;
> IIF(H.codfpago = '9','PU',ALLTRIM(STR(H.durpri))) AS durpri, ;
> H.codfpago,H.fecefsit,H.anualida,H.moneda, ;
> H.sitpoliz, ;
> IIF (H.sitpoliz = '10','NO','SI') AS vigreduc, ;
> H.motsitua,H.fecanula,H.fecbaja AS fecconan, ;
> E.codclien ;
>FROM ppolizas P, phpoliza H, pmodalid M, phpolper E, pcligrls C, pprovpol V ;
>WHERE P.numpoliz = V.numpoliz and ;
> (P.sitpoliz = "00") and ;
> (H.numpoliz = V.numpoliz) and ;
> (H.numsuple = V.numsuple) and;
> (M.codmodal = H.codmodal) and (!EMPTY(M.codrease)) and ;
> ((E.numpoliz = V.numpoliz) and (E.tiporela = 'A')) and;
> (E.codclien = C.codclien);
>GROUP BY H.numpoliz ;
>ORDER BY H.numpoliz, H.codmodal, H.numsuple DESC ;
>INTO CURSOR cur_cartera_vig
>
>
>The difference is that I get incorrect values for the
H.fecefsit and
H.anualida cursor fields. Both values (correct and wrong) are saved on the
phpoliza table, so it's like my original WHERE clause was distorted in some way.
>
>
>>Hi!
>>
>>What is that difference? Can you describe more how results are different?
>>
>>>Hi,
>>>
>>>I have an application (EXE file) written in VFP which is supposed to extract data from our database (using SQL-SELECT clauses) and put it in a set of DBFs (which are re-created by the app each and every time it runs). The fact is that when I run it over a local database in stand-alone mode it gets the expected results, but when I run it against the production database the app produces a different result.
>>>Has anyone had the same problem? I do not understand why is this happening, maybe I need to open the database in exclusive mode?
>>>
>>>TIA,
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer