Databases
StackOverflow2013
Postsdbo
POHow to flush retrieved database values from form
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to flush retrieved database values from form
    primarykey
    data
    text
    <p>I have been able to retrieve values into my form.The values are inserted into a table on save button click and are at the same time retrieved onto the same form too(on the same save click).But the problem now is that on each click the values are getting displayed in a continuous flow.I want to clear the screen(flush the values from form) after the previous click and display only the latest table state values. Heres the code i am working on:</p> <pre><code> public void fieldChanged(Field field, int context) //respond to button events { if (field == showInputButton) //if first button selected { Dialog.alert(TextField1.getText()); //show text from first input field try { //Open or create the database Database db = DatabaseFactory.openOrCreate("database1.db"); //Insert Data from db Statement statement1 = db.createStatement("INSERT INTO DirectoryItems(category_id,name,phone,email) VALUES ('1','"+TextField1.getText()+"','"+TextField2.getText()+"','"+TextField3.getText()+"')"); statement1.prepare(); statement1.execute(); statement1.close(); //Retrieve data try { add(new RichTextField("Attempting to retrieve data from " + "database1.db on the SDCard.")); Statement st = db.createStatement("SELECT name FROM DirectoryItems"); st.prepare(); Cursor c = st.getCursor(); Row r; int i = 0; while(c.next()) { r = c.getRow(); i++; add(new RichTextField(i + "Name = " + r.getString(0))); } if (i==0) { add(new RichTextField("No data in the DirectoryItems table.")); } st.close(); db.close(); } catch( Exception e ) { System.out.println( e.getMessage() ); e.printStackTrace(); } } </code></pre> <p>Does anyone know this.Please advise guys.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. UStechie
    1. UStechie
    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. VO
      singulars
      1. POHow to flush retrieved database values from form
      1. This table or related slice is empty.
      1. VTUpMod
    1. COIt sounds for me that you need to read more about BB development, UI fields, UI cycle. Also looking to the code example I would suggest you to read more about "clean code" technique
      singulars
      1. POHow to flush retrieved database values from form
      1. USEugen Martynov
    2. COI sure am a newbie in bb development.Would much appreciate if u cud provide suitable links to aid ur suggestions.
      singulars
      1. POHow to flush retrieved database values from form
      1. UStechie
    3. CODoes anyone know to solve the above doubt.PLz help guys
      singulars
      1. POHow to flush retrieved database values from form
      1. UStechie
 

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