General information
Title:
Why does VFP fill Oracle 7 fields up with spaces?
In VFP 3.0, if I create an updateable view and add a record containing a character field, and the character data for that field is less than the maximum field width, the value added is padded right with spaces so it fills up the column. Why?
If I use SQLPassthough, this doesn't happen.
For Example: If I add "WO" to a batch_type field defined as varchar2(8), what gets added to the table is
WO ", NOT "WO".
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