Paradox Community

Items in pnews.paradox-3rdparty

Subject:Re: ProView and Oracle - Missing Column Names
Date:Mon, 07 May 2012 22:08:21 +1000
From:Robert Molyneux <ibisnestremovespampart@iinet.net.au>
Newsgroups:pnews.paradox-3rdparty
On 6/05/2012 8:29 AM, Robert Molyneux wrote:
> On 6/05/2012 3:17 AM, Liz McGuire wrote:
>> Not all SQL data types have a corresponding data type in Paradox...
>>
>> There's nothing to fix, it just won't work.
>>
>> FWIW,
>>
>> Liz
>>
>>
>> On 04 May 2012 20:59, Robert Molyneux wrote:
>>>
>>> Some tables not readable - when I view structure, the data types not
>>> recognised.
>
> Liz, thanks for attention.
>
> Looks like VCHAR more than 255 chars is main problem with MYSQL.
>
> For ORACLE, I sometimes get "Unable to open table - key violation"
>
> I have attached a little table of the data types in Paradox and various
> other RDBMS.
>

I made sure that I set the character set to be Paradox ascii for the 
oracle and mysql aliases.

This seems to have solved the "Unable to open table - key violation" 
problem, and got rid of garbage names.


Copyright © 2004 thedbcommunity.com