Clarion/Oracle - Dealing with double quotations " - Clarion

On Oct 24, 4:54 pm, obrienji...@gmail.com wrote:
> Hello,
> I have a clarion 6 program running on an Oracle 9i database.
> Within my own program I am making use of the TList 3rd party tool.  I
> allow the user to import and export from this TList view to Excel.
>
> Here is my issue:
> When I import from Excel, via clipboard, and there is a carriage
> return within the cell, the text comes in like this:
> "This is a test to show
> a break in the cell"
>
> A normal cell comes in like this:
> This is a test to show no break in the cell
>
> i.e. Windows is adding in the double quotations around the text.
>
> It gets imported into the database fine, but the problem is the TList
> wont display this properly.  indeed, anything with a quotation within
> it will just not get loaded.
>
> Does anyone have any idea how to deal with this issue?
> If you need further information, or I'm not describing the problem
> sufficiently, please let me  know.
> Kind Regards,
> James

Dear James

i have application with oracle i am doing import from excel with
another way and it works fine , but i dont use any third part my idea
depend on that i create one table as ( basic ) and at any time to
upload i map excel file with my table and it works fine with oracle
and also i export from oracle with same way

On Oct 29, 6:38 am, ikrami2...@gmail.com wrote:
> On Oct 24, 4:54 pm, obrienji...@gmail.com wrote:
>
>
>
> > Hello,
> > I have a clarion 6 program running on an Oracle 9i database.
> > Within my own program I am making use of the TList 3rd party tool.  I
> > allow the user to import and export from this TList view to Excel.
>
> > Here is my issue:
> > When I import from Excel, via clipboard, and there is a carriage
> > return within the cell, the text comes in like this:
> > "This is a test to show
> > a break in the cell"
>
> > A normal cell comes in like this:
> > This is a test to show no break in the cell
>
> > i.e. Windows is adding in the double quotations around the text.
>
> > It gets imported into the database fine, but the problem is the TList
> > wont display this properly.  indeed, anything with a quotation within
> > it will just not get loaded.
>
> > Does anyone have any idea how to deal with this issue?
> > If you need further information, or I'm not describing the problem
> > sufficiently, please let me  know.
> > Kind Regards,
> > James
>
> Dear James
>
>   i have application with oracle i am doing import from excel with
> another way and it works fine , but i dont use any third part  my idea
> depend on that i create one table as ( basic ) and at any time to
> upload i map excel file with my table and it works fine with oracle
> and also i export from oracle with same way

I believe it is the third party software that is causing the
problems. It won't display any text if there is a " within it. I am
trying to contact them now.