Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sql UPDATE() IMPOSSIBILITY
Message
De
09/12/2019 12:33:25
 
 
À
09/12/2019 12:00:19
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01672198
Message ID:
01672202
Vues:
63
>>Hi,
>>
>>I have following code in myForm.Updating method:
>>
>>Select curNAW
>>liID = Id
>>Update NAW ;
>>    SET  ;
>>    NAW.Voornaam = curNAW.Voornaam  , ;
>>    NAW.geslacht = curNAW.geslacht ;
>>    FROM  curNAW ;
>>    where NAW.Id  = m.liID
>>m.llSuccess = Tableupdate(.F.,.T., "naw")
>>
>>
>>curNAW.Voornaam value = "Koen"
>>m.liID =149
>>there exsists a NAW.ID = 149
>>nevertheless after this update, NAW.Voornaam = [ ]
>>
>>now when I copy this command to a testsql.prg and run that, it works as it should.
>>I am overasked where to look to correct my method, any idea's?
>
>Look at the tableupdate... try with the third parameter. Without it, it works on the current alias which, as I see the code, is not the alias to which you issued the update statement.
Dragan,

My update statement:
m.llSuccess = Tableupdate(.F.,.T., "naw")
it is naw.dbf which is the alias to which the update statement is issued.
again the exact code works fine in .prg file
When I issue the debugger and set a breakpoint right on the tableupdate( ) I can see naw.voornaam = [ ], so also after this tableupdate( ) it will remain empty not?
Have checked my Data Sessions, only 1 running.
Mystery.
Koen
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform