If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Corel Paradox > Need Help in Paradox

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-21-04, 10:56
kk_gin kk_gin is offline
Registered User
 
Join Date: Jun 2004
Posts: 1
Need Help in Paradox

Hi,

I am working in one Delhpi Application which is connecting to Paradox Db tables. I have to modify the Field data type of two tables from NUMBER to ALPHA . When I tried tomodify it in Database Explorer I am not able to do it. Can you guys help me how to do this.

Thanks
Kiran
Reply With Quote
  #2 (permalink)  
Old 06-21-04, 17:12
Maroonotmoron Maroonotmoron is offline
Registered User
 
Join Date: Sep 2003
Location: Dallas
Posts: 182
Using Wrong Tool

Go into tools from the menu and select database Destop. Then from the menu select tools and utilities. Select Restructure and open the data table you need to modify and change it there.
Reply With Quote
  #3 (permalink)  
Old 06-23-04, 12:49
Shores Shores is offline
Registered User
 
Join Date: Aug 2003
Location: Bologna - Italy
Posts: 209
Be VERY wary!

By modifying a field type you could both lose data already present in the field (yes, also in converting from number to alpha, suppose you have a number which is too long for the alpha field you've created...) and disrupt totally the app, if you don't have access to full source of the app and know exactly how to propagate the change in the whole source code...

Bye!
__________________
The only failure is not trying to do it.
Reply With Quote
  #4 (permalink)  
Old 06-24-04, 00:07
Maroonotmoron Maroonotmoron is offline
Registered User
 
Join Date: Sep 2003
Location: Dallas
Posts: 182
Yes indeedy!

Take Shore's comments to heart. I assumed you understood the ramifications of what you were about to do. Also unless the field was populated by integers this is a one way trip in that you will lose precision if you try to convert back. That said, it is a simple task and one which is done for various reasons all the time ( for instance the output of an insturment is generally a number unless it is out of range then it gives you an alphanumeric code which would be lost in a numeric field. Or you have data which has been entered as a number (social security or Phone for instance) but for which you would like to format as text and use string functions to parse. These things can be handled in Delphi via casting or conversion functions if they are temporary data handling needs but it is sometimes simpler to convert the fields and keeping it simple is a laudable goal.

Lonnie
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On