Home > Archive > PowerBuilder > February 2005 > Can I change Data Type on DW automatically?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Can I change Data Type on DW automatically?
|
|
| IW0DJB 2005-02-15, 9:02 pm |
| 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.
| |
| Jim Douglas 2005-02-15, 9:02 pm |
| 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.
>
>
| |
| Thomas Humburg 2005-02-16, 9:02 pm |
| 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
| |
| IW0DJB 2005-02-19, 8:58 pm |
| 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
| |
| Thomas Humburg 2005-02-20, 8:57 am |
| 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
| |
| Jim Douglas 2005-02-21, 8:57 am |
| 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[color=darkred]
>
>
|
|
|
|
|