General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Trimming Values from Fox to Oracle
Hello All,
Here is my problem. I have an updatable remote view which I created through SPT and CURSORSETPROP. When I change a value in the view and then issue a TABLEUPDATE the value that is placed in the Oracle Table is not trimmed. Infact it has the full number of spaces for the field. The Oracle field type is VARCHAR2 so I know I should be able to trim the values. How can I make the values trim when using a cursor?
Matt
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only