Android Question Saving data and list it in a list view.

Izmirov.Yaminovich

Member

Licensed User

Longtime User

• Jun 28, 2016

• #2

Here is my SQL file. Anyone know how do I link to my data collection app?

 

Attachments

• SQL.zip

  6.5 KB · Views: 211

Upvote 0

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Jun 28, 2016

• #3

The database will not really help. I'm afraid that your question is to broad. Try to post more specific questions.

 

Upvote 0

Izmirov.Yaminovich

Member

Licensed User

Longtime User

• Jun 28, 2016

• #4

I'm sorry. What I am trying to do now is to create a database or something like an excel table or more if there's a choice for my data collection app. The First layout from the picture that I've show was supposed to be a key in entry to enable the numbers to be stored in the database and the Second layout is a list view that will show the list of recorded info/files from the database. Can you help me with that please? I am clueless on how to link it all together

 

Upvote 0

eurojam

Well-Known Member

Licensed User

Longtime User

• Jun 28, 2016

• #5

Your project will not work, because your sql statements are complete wrong:

B4X:

Sub CreateTables
    SQL1.ExecNonQuery( "col1 Integer, col2 Integer, col3 Integer, col4 Integer, col5 Integer, col6 Integer") 'no Create Table here
End Sub

Sub FillSimpleData
    SQL1.ExecNonQuery("INSERT INTO table1 VALUES('Date', 'Time', 'Frond', 'Bunch', 'Latitude', 'Longitude')") 'your colums are type integer, you can not insert strings like here...
End Sub

The first statement the key words like "Create Table" are missing, in the second you try to insert Strings into integer fields and so on. If you want to build solid apps you should read a bit about databases and something about SQL. Start with https://www.b4x.com/android/forum/threads/sql-tutorial.6736/

 

Upvote 0

Izmirov.Yaminovich

Member

Licensed User

Longtime User

• Jun 28, 2016

• #6

Is it better to save the files in the text form or in excel form? I've read about the saving root file space in the device in https://www.b4x.com/android/forum/threads/files-and-folders.46137/#content . Which one is easier in my case?

 

Upvote 0

Izmirov.Yaminovich

Member

Licensed User

Longtime User

• Jun 28, 2016

• #7

Okay I have tried another method instead of using SQL. Unfortunately when I press the save button in the first layout it just shuts off. Does anyone know what is wrong in the coding? I'll attach the file below.

 

Attachments

• test.zip

  11.1 KB · Views: 157

Upvote 0

eurojam

Well-Known Member

Licensed User

Longtime User

• Jun 28, 2016

• #8

yes, you are trying to load a non existing file. Use the debugger and logs and it will give you the information you'll need...
Error occurred on line: 74 (Main)
java.io.FileNotFoundException: /storage/emulated/0/data.txt: open failed: ENOENT (No such file or directory)

 

Upvote 0

Izmirov.Yaminovich

Member

Licensed User

Longtime User

• Jun 28, 2016

• #9

Okay, basically I'll need a txt file or something? what does file.exists do? How do I check if the file is there or how do I make one?

 

Upvote 0

eurojam

Well-Known Member

Licensed User

Longtime User

• Jun 28, 2016

• #10

look at your routine:

B4X:

Sub Save_click
    input=File.readstring(File.DirRootExternal,"data.txt") 'there is no need to open the file, because you don't make nothing with data
    data=Regex.split(input,",") 'so you can set this to comment or use if file.exists(File.DirRootExternal,"data.txt")) then...
    output=EditText1.text &","& EditText2.text &","& Lat.text &","& Lon.text
    File.writestring(File.DirRootExternal,"data.txt",output)
    ToastMessageShow("Saved",True)
End Sub

 

Upvote 0

Izmirov.Yaminovich

Member

Licensed User

Longtime User

• Jun 28, 2016

• #11

I have tried another method of writing. Is this okay?

 

Attachments

• test.zip

  11.1 KB · Views: 269

Upvote 0

ilan

Expert

Licensed User

Longtime User

• Jun 28, 2016

• #12

Izmirov.Yaminovich said:

I have tried another method of writing. Is this okay?

Click to expand...

yes

 

Upvote 0

ilan

Expert

Licensed User

Longtime User

• Jun 28, 2016

• #13

@mangojack i put the after "yes" because i gave @Izmirov.Yaminovich that solution (in the chat room)

 

Upvote 0

Izmirov.Yaminovich

Member

Licensed User

Longtime User

• Jun 29, 2016

• #14

Thanks @ilan

 

Upvote 0