lun. 20 juin 2011, 16h52
Jean à Grenoble
atoutfox.public.association
Re: Probleme de Requery
impossible de confirmer l'absence de résultat. Je me demande si je n'ai pas eu
la berlue !
J'ai créé un petit projet avec le programme suivant :
USE IN (SELECT("foxcodejm"))
USE IN (SELECT("ff1"))
USE IN (SELECT("ff2"))
USE IN (SELECT("ff3"))
USE IN (SELECT("ff4"))
USE IN (SELECT("ff5"))
USE IN (SELECT("ff6"))
SELECT 0
USE foxcodejm
SELECT type, abbrev FROM foxcodejm ;
WHERE type="U" AND abbrev LIKE "%" ;
INTO CURSOR ff1
BROWSE NOWAIT
lctype = "U"
lcabbrev = "%"
SELECT type, abbrev FROM foxcodejm ;
WHERE type=m.lctype AND abbrev LIKE m.lcabbrev ;
INTO CURSOR ff2
BROWSE NOWAIT
SELECT type, abbrev FROM foxcodejm ;
WHERE type=(m.lctype) AND abbrev LIKE (m.lcabbrev) ;
INTO CURSOR ff3
BROWSE NOWAIT
u = "Z"
SELECT type, abbrev FROM foxcodejm ;
WHERE type=(m.lctype) AND abbrev LIKE (m.lcabbrev) ;
INTO CURSOR ff4
BROWSE NOWAIT
SELECT type, abbrev FROM foxcodejm ;
WHERE type=?lctype AND abbrev LIKE ?lcabbrev ;
INTO CURSOR ff5
BROWSE NOWAIT
SELECT type, abbrev FROM foxcodejm ;
WHERE type=(?lctype) AND abbrev LIKE (?lcabbrev) ;
INTO CURSOR ff6
BROWSE && NOWAIT
Je l'ai compilé et executé en .app tout est bon
J'ai fait un .exe; j'ai quitté VFP et j'ai lancé le ;exe : tout va bien !!!
A+
Jean à Grenoble
Permalink : http://www.atoutfox.org/nntp.asp?ID=0000006208