Deleting all rows from a database table.

M

Malky

Active Member

Licensed User

Longtime User

• Feb 28, 2013

• #21

It uses httpUtils2Service & httpjob.

May also need the images files, (attached)? I thought it would add stuff like this when I zipped it?

Cheers,

Malky

 

Attachments

• back.png

  12.1 KB · Views: 292
• home.png

  13.7 KB · Views: 279

Last edited: Feb 28, 2013

Upvote 0

S

sorex

Expert

Licensed User

Longtime User

• Feb 28, 2013

• #22

no, it's AHPopupMenu or something

 

Upvote 0

M

Malky

Active Member

Licensed User

Longtime User

• Feb 28, 2013

• #23

Sorry, jut changed tabs and it's AHQuickaction.

Thanks,

Malky

 

Upvote 0

S

sorex

Expert

Licensed User

Longtime User

• Feb 28, 2013

• #24

ok, now it runs but when I press english it nags that it can't find menu_phone.png and that's not one of the above 2

maybe it's better to join irc instead of flooding this thread?

http://jonsap.com/b4achat/

 

Last edited: Feb 28, 2013

Upvote 0

M

Malky

Active Member

Licensed User

Longtime User

• Feb 28, 2013

• #25

Ok, attached, jeez.

I've added any possible others I think?

As I said, I though it zipped everything I needed.

Many thanks for your patience

Malky

 

Attachments

• menu_phone.png

  8.7 KB · Views: 303
• menu_eraser.png

  1.8 KB · Views: 301
• menu_cancel.png

  7.4 KB · Views: 291
• menu_email.png

  7 KB · Views: 269
• menu_sms.png

  5.7 KB · Views: 308
• menu_up_arrow.png

  1.6 KB · Views: 279

Upvote 0

S

StephanH

Member

Licensed User

Longtime User

• Feb 28, 2013

• #26

Have you tryed

delete from table_name;
delete from sqlite_sequence where name='table_name';​

?

Ref.: File Format For SQLite Databases

Stephan

 

Upvote 0

M

Malky

Active Member

Licensed User

Longtime User

• Feb 28, 2013

• #27

Found and tried that.

No table 'file_sequence.

Malky

 

Upvote 0

S

sorex

Expert

Licensed User

Longtime User

• Feb 28, 2013

• #28

I'm missing a menu_globe.png file here

also when I ran the app one time, the second time I just get an empty screen?

 

Upvote 0

M

Malky

Active Member

Licensed User

Longtime User

• Feb 28, 2013

• #29

Sorry, hope this is the last one. Also having probs with a new phone here, so not a good night.

Malky

 

Attachments

• menu_globe.png

  7.8 KB · Views: 322

Upvote 0

S

sorex

Expert

Licensed User

Longtime User

• Feb 28, 2013

• #30

I copied one of the other to menu_globe.png and now I get a menu after clicking english as language.

Do I just need to press update to see the issue?

 

Upvote 0

M

Malky

Active Member

Licensed User

Longtime User

• Feb 28, 2013

• #31

Yes, update does the damage.

 

Upvote 0

S

sorex

Expert

Licensed User

Longtime User

• Feb 28, 2013

• #32

ok, solved it.

use it like this...

B4X:

Sub CreateMenuTable
   Log("menu table created")
   If Started = 0 AND LanguageSelected = 0 Then
      SQL1.ExecNonQuery("CREATE TABLE menus (id INTEGER, en TEXT, ru TEXT, bg TEXT, gr TEXT, icon TEXT)")
    End If
   If Started = 0 AND LanguageSelected = 1 Then
      SQL1.ExecNonQuery("DELETE FROM menus")
      SQL1.TransactionSuccessful  ' <- !!!!!!!!!!
   End If
End Sub

 

Upvote 0

M

Malky

Active Member

Licensed User

Longtime User

• Feb 28, 2013

• #33

Cheers, Sorex, although I am getting a problem which I think is due to the fact that I update all the tables at once and the TransactionSuccessful call should only be called once they are done I believe?

Will report back, getting late for me here as well.

Many thanks so far,

Malky

 

Upvote 0

M

Malky

Active Member

Licensed User

Longtime User

• Feb 28, 2013

• #34

Well, I'm back and it appears to work at damn last!!!!!!

I changed the text on the live server and it updates, so it is working and I owe it all to Sorex.

If you don't do anything else in your life, just smile and remember you've made me very happy ))))

On with the rest of the stuff, but work tomorrow, so the timing was even perfect.

A very Happy Malky

 

Upvote 0

S

sorex

Expert

Licensed User

Longtime User

• Feb 28, 2013

• #35

Malky said:

I update all the tables at once and the TransactionSuccessful call should only be called once they are done I believe?

Click to expand...

for the updating that's right, or you could acknowledge it after every query.

but in this case the delete had to be executed first before you start inserting stuff again.

have fun with the rest of the code.

 

Upvote 0