Skip to Content
0
Aug 04, 2016 at 09:17 AM

"Date" data type of Table.Column Converted to Char(10) in Datawindow.column

385 Views

I'm using PB12.6 Classic and MS SQL2008R2 database

When create new datawindow (Quick or SQL Select) select columns from Tables, the table.column data type "Date" will be converted to Char(10) in according dw.column

Is that normal or Abnormal?

that kind of convertsion will bring difficulty in writing script

dw_1.SetItem() - cannot set "Date" variable dirrectly to dw.column(Char10)

dw_1.GetItem..() - cannot get and place to "Date" variable

Please the experts advises

(Table.Column data type is "Date")

(PB12.6 converted to Char(10) in Datawindow.Column)

Attachments

DATE_DTY.JPG (22.6 kB)
CHAR_DTY.JPG (33.6 kB)