|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Be the architects of evolution and help create the mobile internet future. It’s your move---enter to win here! |
|
#1
|
|||
|
|||
|
Change a table's field value
Hi, Please help me in solving this issue as soon as possible. I have a table with some columns, one of them is a flag that just can have Y or N values. Right now, this column has default value 'N' in all of the records. Now, I have a file where it has column1 and column2 values. I need to update my table's flag column to "Y" where ever record has the values from the file. Hope you got my problem. How can I do this? What is the best way of doing this? please suggest me.
Thanks, |
|
#2
|
|||
|
|||
|
I'm not even sure what problem you are trying to solve... need more specifics.
What database system are you using, and what do you mean by "file"? Is it a text file you need to read? What is its structure? What programming language are you working with. What computing platform? Please give more of a step-by-step description of the problem you are trying to solve.
__________________
The real n-tier system: FreeBSD -> PostgreSQL -> [any_language] -> Apache -> Mozilla/XUL Amazon wishlist -- rycamor (at) gmail.com |
|
#3
|
|||
|
|||
|
using which system?
If I got that right you want to compare the value(s) from a table with the value(s) from a file. In case they are equal, you want to update the Y/N flag to "Y".
How do you want to process your file? Inside MS Access using VBA? or do you have another prog. language env. around? SQL commands to read about would be SELECT and UPDATE. In general you get better help if you write more detailed about your problem. Philipp Last edited by philok : September 10th, 2003 at 03:51 AM. |
![]() |
| Viewing: Dev Shed Forums > Databases > Database Management > Change a table's field value |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|