Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How to modify coltype property of the column?

258 views
Skip to first unread message

gaofeng he

unread,
May 6, 2003, 12:23:07 AM5/6/03
to
I can get coltype property of the column by Describe(),but not Modify().

Anybody know the best way do this?

Thanks in advance!

gaofeng


Harry

unread,
May 6, 2003, 3:10:06 AM5/6/03
to
Oh ... I made a mistake from your subject. You cannot modify a coltype in PB
DW, the best way to do it that change the column type from your DBMS first,
then modify something of the SQL syntax in DW painter, after modified it, dw
will change the coltype automatically.

HTH


"Harry" <harr...@bigfoot.com> 在郵件 news:eTxHIV5EDHA.94@forums-2-dub 中撰
寫...
> You means that you want to check the column property in you code?
>
> e.g.:
> In itemchanged event
>
> choose case Left(Lower(dw_1.Describe(String(dwo.name)+".ColType")), 5)
> case "char("
> case "date"
> case "int"
> ......
> end choose
>
> e.g.2:
> In open event
> for i = 1 to Integer(dw_1.object.datawindow.column.count)
> if Left(Lower(dw_1.Describe("#"+String(i)+".Coltype")), 5) = "char("
> then
> ......
> end if
> next
>
>
>
> "gaofeng he" <f1_...@sina.com.cn> 在郵件 news:uSu9$e4EDHA.331@forums-1-dub
> 中撰寫...

Harry

unread,
May 6, 2003, 1:57:44 AM5/6/03
to
You means that you want to check the column property in you code?

e.g.:
In itemchanged event

choose case Left(Lower(dw_1.Describe(String(dwo.name)+".ColType")), 5)
case "char("
case "date"
case "int"
......
end choose

e.g.2:
In open event
for i = 1 to Integer(dw_1.object.datawindow.column.count)
if Left(Lower(dw_1.Describe("#"+String(i)+".Coltype")), 5) = "char("
then
......
end if
next

"gaofeng he" <f1_...@sina.com.cn> 在郵件 news:uSu9$e4EDHA.331@forums-1-dub
中撰寫...

Stelios Stylianou

unread,
May 6, 2003, 3:28:30 AM5/6/03
to
You Can Also Export the dw object, open it in the editor, make the
modification you like AND then import it back in your library.
S.O.S. Make a BACKUP First & Know Exactly what to change.

Stelios
"gaofeng he" <f1_...@sina.com.cn> wrote in message
news:uSu9$e4EDHA.331@forums-1-dub...

Johan Vandaele

unread,
May 6, 2003, 2:48:47 AM5/6/03
to
You can't change the coltype of a datawindow column.

Why do you want to do this?


"gaofeng he" <f1_...@sina.com.cn> wrote in message
news:uSu9$e4EDHA.331@forums-1-dub...

Jerry Siegel

unread,
May 6, 2003, 11:12:41 AM5/6/03
to
If you must do this at runtime, I believe you will have to replace the
entire DataWindow.Table attribute.

"gaofeng he" <f1_...@sina.com.cn> wrote in message
news:uSu9$e4EDHA.331@forums-1-dub...

0 new messages