Question concerning data type fixc?

P

psepesi

New Member
We created a new database and used an ODBC connection to create the
tables.
The char fields now have a "fixc" datatype. I'm trying to re-use some code that was orginally used when we the dataserver odbc to connect to the SQL database.
Now using the new Progress/SQL tables I'm getting lots of incompatible datatypes.
My first question is did we set the Progress/SQL table incorrectly?
(ie create table junk
(blah character 8,
stuff character 10)
Second question, I'm assigning char fields in Progress to some of these
values, and I'm now getting incompatible data types??
Thanks for any help...
Pat
 
I think you should define character fields as varchar(n..) in SQL to be able to query the tables with ABL.

Casper.
 
fixchar is another one of those SQL only datatypes. You can use it OK 100% from SQL, but you can't get at it from ABL.
 
Thanks for the info.

We're going to try the var char...
I've done okay with the data server..
I think it just might be better to leave access to the tables in the SQL database and keep using the data server.

Thanks again

Patti
 
You must log in or register to reply here.
Back
Top