I've created a view (using knowledgebase.progress.com/.../fileField ) on a table with a decimal extent field. The individual elements of the extent field get a point as decimal-point while other non extent decimal fields get a comma as decimal-point.
Is there a way to correct this?
Enviroment: Linux 11.5.1 database server, ODBC client Acces 2007 using 32-bit OE 11.5 driver
An example output of the sql script as created by that .p would help.
PDSOE auto-format is unable to make that .p automatically legible.
An example of one table/view:
DROP VIEW sql92."CADVPR";
CREATE VIEW sql92."CADVPR"
(
"CUNR",
"PRNR",
"CASPR_1",
"CASPR_2",
"CASPR_3",
"CASPR_4",
"CASPR_5",
"CASPR_6",
"CATYPE",
"CASDAT",
"CAEDAT",
"CRNR"
)
AS SELECT
"CUNR",
"PRNR",
convert ('decimal', nullif( pro_element ("CASPR" ,1 ,1),'?') ) ,
convert ('decimal', nullif( pro_element ("CASPR" ,2 ,2),'?') ) ,
convert ('decimal', nullif( pro_element ("CASPR" ,3 ,3),'?') ) ,
convert ('decimal', nullif( pro_element ("CASPR" ,4 ,4),'?') ) ,
convert ('decimal', nullif( pro_element ("CASPR" ,5 ,5),'?') ) ,
convert ('decimal', nullif( pro_element ("CASPR" ,6 ,6),'?') ) ,
"CATYPE",
"CASDAT",
"CAEDAT",
"CRNR"
FROM pub."CADVPR";
Hi Richard,
Clearly I'm a newby regarding ODBC, I'll give that a try!
I changed the views and they work fine, thanks Marian.
Unfortunately our customer still has the same problem in MS Acces. Apparently it seems to be an Acces issue because when I use SQL Squirrel or Libre Office I get consistent behavior. I don't have MS Acces.