General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>When I use VFP to insert a record into the view with a key of “123”, I get
>"123__________" ( 123 followed by 10 spaces. 13 characters total length) in
>the Oracle table. The client side application can’t deal with the trailing
>spaces and won’t find the records. So, any ideas on how to trim the data the
>VFP places into the Oracle table?
David,
If the Oracle field usually pads to the left, you could try padding the data before your update eg:
lcMyKey = PADL(lcMyKey, 13, ' ')
which would give you "__________123". Of course, you'd still need to ensure that your lookup value corresponded, either by PADL'ing it as well, or by using one of the TRIM funcs. If the Oracle field usually pads right, you could compare against VAL(lcKeyField).
-Bernie
Previous
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