Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
BUG2: SQL SELECT does not see open alias
Message
De
02/04/2005 02:12:41
Walter Meester
HoogkarspelPays-Bas
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9
Divers
Thread ID:
01000541
Message ID:
01000953
Vues:
43
Sergey,

Very strange, In my application it is reproducable very clearly: A certain piece of code runs without a problem in VFP8SP1 and does not in VFP9.

I could replicate the problem in the applications command window every time, though your example indicates somthing else must play a role here. Maybe a SETting or a SYS(). Anyways did you look at fabios version in Thread #1000615? There definately is somthing different in VFP9, whether it is a bug of changed default setting, I don't know.

Walter,


>>It runs fine under VFP8SP1
>
>Walter,
>
>I tested on 2 PC's and got the same error under VFP8SP1 and VFP9. Please run test code below and see for yourself.
>CLOSE TABLES ALL
>ccBUILDACTION_BUILDEXE = 3
>lcProject = "testxx"
>CREATE TABLE MyInternalTable (dummy c(10))
>USE
>
>TEXT TO lcMemoText NOSHOW
>USE MyInternalTable
>SELECT * FROM MyInternalTable
>EXECSCRIPT("SELECT * FROM MyInternalTable")
>ENDTEXT
>STRTOFILE(lcMemoText,  "testxx.prg")
>
>CREATE PROJECT (lcProject) NOWAIT NOSHOW
>loProj = _VFP.ActiveProject
>
>
>loProj.Files.Add("testxx.prg")
>loProj.SetMain("testxx.prg")
>loProj.Files.Add("MyInternalTable.dbf")
>loProj.Files.Item(loProj.Files.Count).Exclude = .F.
>loProj.Build(lcProject, ccBUILDACTION_BUILDEXE)
>loProj.Close()
>
>ERASE ("MyInternalTable.dbf")
>RUN /N testxx.exe
>RETURN
>
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform