General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
When working with Cursors does this affect memory?
When creating the Oracle tables I used all varchar2 field types rather than char types. The reason is that when you allocate that a char field is 200 characters the value stored in that field ALWAYS has a length of 200(trailing spaces are always present).
>Sorry, I should have been more clear. I replaced my vfp character fields with vfp memo fields when I want to write to an Oracle varchar2 field with no trailing spaces.
>
>Also, I like Mark's suggestion about using an insert/update trigger in Oracle.
>
>Paul
>
>
>
>>Paul,
>>
>>This is happening with every character field. Not just memos. Any Ideas?
>>
>>Matt
Previous
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