Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update decimal value into ORACLE
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00637650
Message ID:
00637983
Views:
23
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform