Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update decimal value into ORACLE
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00637650
Message ID:
00637983
Vues:
25
>With SQL PassTrhu

So you are walking through the cursor using GetNextModified() to determine which records have been inserted or edited. When you find a record, you generate a SQL command to send the INSERT or UPDATE command back to Oracle. Since this has to be a string, the numeric columns should be built something like:
lcSQL = "UPDATE ... " ;
      + "SET " ;
      + "NumberColumn = ";
      +    transform(ThisForm.txtBoxNumeric.Value) + ", ";
      + "CharacterColumn = '" ;
      +    alltrim(ThisForm.txtBoxCharacter.Value) + "' ";
      + "where PrimaryKeyColumn = " + PKValue
Is that what you are doing? Assuming the PKValue is also numeric, what I show above should work. You have to use the ' and " exactly as I have given as well.
Mark McCasland
Midlothian, TX USA
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform