Databases
StackOverflow2013
Postsdbo
POIs there a way to go back and edit the information the user entered?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POIs there a way to go back and edit the information the user entered?
    primarykey
    data
    text
    <p>I have a simple code written in Python 2.7 that will ask users for certain information, and it exports the information to a .csv file. Once the user inputs the data, is there a way for them to go back and edit what they entered after pressing enter? Here is what i have so far:</p> <pre><code>def writer(): import csv with open('Work_Order_Log.csv', 'a') as f: w=csv. writer(f, quoting=csv.QUOTE_ALL) while (1): Correct=True Employee=True WorkOrder=True Item=True Qty=True Process=True Date=True Time=True while Correct: Correct=False Employee=False WorkOrder=False Item=False Qty=False Process=False Date=False Time=False Employee=raw_input("1. Enter Your Name:") WorkOrder=raw_input("2. Enter The Work Order Number:") PartNumber=raw_input("3. Enter The Item Number:") Qty=raw_input("4. Enter Quantity:") Process=raw_input("5. Enter Process:") Date=raw_input("6. Enter Date(mm/dd):") Time=raw_input("7. Total Time(hh:mm):") needToCorrect=raw_input("Is the last Entry Correct? (If so, type 'y') If not enter the Number of the Field that is incorrect:") if needToCorrect=="1": Employee=True elif needToCorrect=="2": WorkOrder=True elif needToCorrect=="3": Item=True elif needToCorrect=="4": Qty=True elif needToCorrect=="5": Process=True elif needToCorrect=="6": Date=True elif needToCorrect=="7": Time=True w.writerow([Employee,WorkOrder,Item,Process,Qty,Date,Time,Correct]) writer() </code></pre> <p>After testing the code, I have found that when I enter the number of the incorrect field for correction, it shows in the .csv file that it was incorrect, but still makes me go through the entire loop to fix the errors. Why is this?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USsaurusrexx
    1. USsaurusrexx
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COIn addition to what the Accepted Answer already says, I would highly recommend getting your data all squared away and _only then_ opening and writing out the file, rather than holding open a filehandle through the entire process.
      singulars
      1. POIs there a way to go back and edit the information the user entered?
      1. USEdward
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload