Can I change Data Type on DW automatically?

Hello everybody,

I have to chang a table column data type from int to char. How can I change
automatically the data type used on the datawindow without re-opening and
redesign the DW's?

I still use PB 6.5

Many thanks, Luca.

First why? Next I guess you could programatically export, change, import the
datawindown back on the fly, but again Why? Is this just one or a global
change? Sounds like maybe someone has to change a datatype across a large
application. There used to be a ton of search&replace programs on the web.

"IW0DJB" <luca.dellagiovampaola@fastwebnet.it> wrote in message
news:OJtQd.48037$2h5.30500@tornado.fastwebnet.it...
> Hello everybody,
>
> I have to chang a table column data type from int to char. How can I
change
> automatically the data type used on the datawindow without re-opening and
> redesign the DW's?
>
> I still use PB 6.5
>
> Many thanks, Luca.
>
>

IW0DJB wrote:

> Hello everybody,
>
> I have to chang a table column data type from int to char. How can I
> change automatically the data type used on the datawindow without
> re-opening and redesign the DW's?

Export all your datawindows to textfiles, then open them with a good
texteditor (e.g. textpad), then you can do a search & replace with regular
expressions in all open files at once.

--
TH
mailto:sherlok@gmx.de
mailto:sherlok@timberbell.de
Registered Linux user #100649 at  http://counter.li.org

Thank Thomas,

I have tried exporting on srd files, make the changes and then re-import the
files on the same PBL but it seem not working.

Do I have to import the files on another PBL or what?

Thank you, Ciao.


"Thomas Humburg" <spamhole@gmx.de> ha scritto nel messaggio
news:0mbce2xl9i.ln2@ID-739.user.dfncis.de...
> IW0DJB wrote:
> 
>
> Export all your datawindows to textfiles, then open them with a good
> texteditor (e.g. textpad), then you can do a search & replace with regular
> expressions in all open files at once.
>
> --
> TH
> mailto:sherlok@gmx.de
> mailto:sherlok@timberbell.de
> Registered Linux user #100649 at  http://counter.li.org

IW0DJB wrote:

> Thank Thomas,
>
> I have tried exporting on srd files, make the changes and then re-import
> the files on the same PBL but it seem not working.
>
Hi,
the question is, what is not working. Do you get any error messages? For my
substitutions I use PowerGen. Since we use CVS all our objects already
exist as textfiles, so I simply open the necessary objects in textpad do
the search and replace and then make a sync run via powergen on the pbls.
With powrgen you can also export all your objects in an application to
textfiles at once and also generate a .pbg file which is needed for
synchronisation.

> Do I have to import the files on another PBL or what?
>
No, its a simple export, change and import chain. Since we use PB 8 its also
possible to edit the source of an object in powerbuilder itself. But this
is only possible for one object at a time, so we use powergen together with
textpad.

Be also sure to do the correct changes, simply do the change for one object
in Powerbuilder and make a diff on the textfile before and after the
change, so you can be sure what you have to change in the textfile.


--
TH
mailto:sherlok@gmx.de
mailto:sherlok@timberbell.de
Registered Linux user #100649 at  http://counter.li.org

Practice on a test object, make sure you have the steps perfectly before
trying on 100's of objects. I wrote a tool years ago to do this, in PB but
can't find it! Search the web for PB Search & Replace.

"IW0DJB" <luca.dellagiovampaola@fastwebnet.it> wrote in message
news:itLRd.55556$2h5.17773@tornado.fastwebnet.it...
> Thank Thomas,
>
> I have tried exporting on srd files, make the changes and then re-import
the
> files on the same PBL but it seem not working.
>
> Do I have to import the files on another PBL or what?
>
> Thank you, Ciao.
>
>
> "Thomas Humburg" <spamhole@gmx.de> ha scritto nel messaggio
> news:0mbce2xl9i.ln2@ID-739.user.dfncis.de... 
regular 
>
>