Sqlite

[Erel]

Did the SQLCompiled example (from the above post) work on your device?

[dennishea]

Erel the sqlexample.exe works fine on device and on desktop. When you asked me that question I didn't even to try that. I copied the whole folder to my device and all ran well, that answers the question about net on the device also on my desktop so now am I doing wrong in my program. It works in the ide's on both but not after I compile it. Well back to searching.

dennishea

edit:
I have the desktop compiled version working on the desktop. I had some of the device files on the desktop and they don't work to well. Now that I understand the file system I believe that I have the device files right and now it gives error loading program nullreferenceexception. Now I'm lost again.

edit again:
Ok I recompiled my program after verifying that all the files were in place and wala it works. The program isn't finish by any means and the only thing at this point that got me baffled is this command,

Sub btnSort_Click
text = "Select Internal FROM WorkData ORDER BY Internal"
cmd.CommandText=text
' Msgbox(cmd.CommandText)
cmd.ExecuteNonQuery
cmd.CommandText = " select * from WorkData "
cmd.ExecuteTable("table2",500)
frmRecord.Close
frmTable.Show
End Sub

When I push the button it does everything in the sub without popping up a error except sorting the data base. Thanks ahead of time for any help pointing out what I'm doing wrong.

dennishea

[Erel]

Is Table2 empty before cmd.ExecuteTable?
If not then try adding Table2.Clear before this line.

[dennishea]

I tried table2.clear before cmd.ExecuteTable("table2",500) and it still respondes the same. I am trying to sort the database mydata1.sl3 table WorkData so when I close it it will be sorted ascending on col Internal. Sqlite is suppose to be able to do this I think. I can get the table to sort but thats not what I want, when I close the program for this session I want the database to be sorted. I hope this explains what I am trying to do and hope it can be done.

dennishea

p.s. Please forgive me if I misinterpute what you are trying to tell me.

[agraham]

Originally Posted by dennishea

I want the database to be sorted.

I think you have an incorrect picture of how a SQL database works. The database is just a collection of data but it is not like a spreadsheet that you can sort and save sorted. The native order of data in a SQL database is not visible or relevant or alterable by users - the internal database engine may order it in some fashion for efficiency but you don't see this. If you want to see data from a SQL database then you need to SELECT it into a table and if you want it sorted then you must specify ORDER BY in that selection.

[dennishea]

Thanks agraham. I didn't realize that you couldn't rearrange the database itself. Again thanks for your help.

dennishea