Re: My Binary Experience

[Quoted] Hi Werner,

Werner <werner.smit_at_baps.com> wrote in article <33973D8C.4194_at_baps.com>...

> A couple of days ago i needed to update an Oracle table
> on a Unix system, with data I had in a local clarion
> database on a Windows NT system. This would be my first
> experience in trying ODBC-Oracle from CW 2.0
 

> The fields in the clarion database was Name,Number and Minutia,
> where name is a string(20), number is a byte, and minutia is
> a string(512).
>
> I installed SQL*Net Client,SQL*Plus and ODBC from the Oracle CD,
> then I used the ODBC manager to create a label? to point to my
> Oracle system.
> I went to CW 2.0 data dictionary, and imported via ODBC the empty
> Oracle table that was created for me.
> Then I imported the Clarion file layout. Now I created a test app
> that would use the process template to read from the one and update
> the other.

[Quoted] Have you tried using CStrings instead of Strings? That way it might match the varchars better and it probably will get the length right too.

HTH

-- 
joe van niekerk
------------------------
Topspeed Corporation
Cape Town
South Africa
joe-vn_at_topspeed.com
joe-vn_at_topspeed.co.za
Home of the MAPI \ ezHelp and CWWinReg Templates