Foxpro View -> Oracle char field padding problem

From: Edwin Robson <E.Robson_at_ftel.co.uk>
Date: 1997/08/22
Message-ID: <33FD8E4A.C44660E2@ftel.co.uk>#1/1

Can anybody help please ?

We are using views based on Oracle tables.

A problem occurs because Visual FoxPro pads character fields with spaces. Oracle varchar fields do not expect to have this padding after the data to the end of the field.

This causes problems when updating and querying.

Does anyone know of a solution. ?

Microsoft Knowledgebase (Article ID Q170129) says that Microsoft is still researching the problem.

--


+---------------------------------------------------------------------+

 Edwin Robson.  Information Services.
 Fujitsu Telecommunications Europe Ltd, Birmingham, B37 7YU. (UK).
 Tel:  +44 (0)121 717 6426  Fax:  +44 (0)121 717 6018
 E-mail: E.Robson_at_ftel.co.uk (Work)
         edwin_at_pandemonium.demon.co.uk (Home)
 WWW:    http://www.pandemonium.demon.co.uk/


+---------------------------------------------------------------------+

Received on Fri Aug 22 1997 - 00:00:00 CDT