Is this a path problem or what?

Malky · Dec 25, 2012

Hi, I install the app initially and if I start it again and all images are downloaded and the database is populated, I expect to continue.

But.... I test for the existence of the DB and it appears not to be there although it does exist on the same path?

The SQL.Initialize function verifies it?

B4X:

Sub Activity_Create(FirstTime As Boolean)
   Start = False
   CreateDir
   ToastMessageShow(SD_PATH, True)
   Log("PATH = " & SD_PATH)
   SQL1.Initialize(SD_PATH, "homerbg.db", True)
   scvMain.Initialize(500)
   Activity.AddView(scvMain,0,0,100%x,100%y)
   ' Query db to see if the app has been activated
   'SQL1.ExecQuerySingleResult("SELECT appActivated FROM system")
   
   If (File.Exists(SD_PATH, "homberbg.db") = True) Then
      ToastMessageShow("Doesn't exist......" & SD_PATH & "homberbg.db", True)
      Log("DB exists......" & SD_PATH & "homberbg.db")
      FillLangScrollView
   
   Else
      ToastMessageShow("Creating............." & SD_PATH & "homberbg.db", True)
   
   CreateSystemTable
   InsertDefaults
   CreateDictionTable
   'FetchDictionList
   CreateMenuTable
   FetchMenuList
   CreateLangTable
   Log("Going for langs")
   FetchImages ' Download all required images at once
   'FetchLangList
   End If

      
End Sub

I have tried reversing the code to check if the file exists = false which didn't work and also true. It doesn't work?

Any ideas please?

Malky

NJDude · Dec 25, 2012

I haven't downloaded your code but look at this message:

B4X:

...
    If (File.Exists(SD_PATH, "homberbg.db") = True) Then
        ToastMessageShow("Doesn't exist......" & SD_PATH & "homberbg.db", True)
        Log("DB exists......" & SD_PATH & "homberbg.db")        FillLangScrollView
     Else

...

You are asking if EXISTS and if it does the ToastMessage shows "DOESN'T", I think you have those prompts wrong.

Malky · Dec 25, 2012

Hi, please ignore the toast message, I only changed the log message as the exists - false didn't work, (which should), so I swapped the code in the if/else statements and tested for true.

It is irrelevant.

Cheers,

Malky

Erel · Dec 26, 2012

1. You should only initialize SQL when FirstTime = True (as well as all the other non UI staff).

2.

B4X:

 SQL1.Initialize(SD_PATH, "homerbg.db", True) 'This call will create the file if it doesn't already exist.
...
 If (File.Exists(SD_PATH, "homberbg.db") = True) Then 'Will always be true

Mahares · Dec 26, 2012

The spelling is not correct: In the Initialize line you use: "homerbg.db" and in the File.Exists line you use: "homberbg.db"

Malky · Dec 26, 2012

Eh??? WHERE?

The app starts ok and the first two scrollviews work ok?

Malky

Mahares · Dec 26, 2012

Take a close look at the spelling of the name of the database. It is different in both lines: The below is your code you posted:

B4X:

SQL1.Initialize(SD_PATH, "homerbg.db", True)

B4X:

If (File.Exists(SD_PATH, "homberbg.db") = True) Then

Malky · Dec 26, 2012

I have searched my code for "homb" and it doesn't exist, can you kindly state the line it is on?

Malky

Malky · Dec 26, 2012

Apologies, I am now referring to a more recent post from tonight, saw the email and clicked on the forum link thinking it was connected to the new post.

Thought I was losing it there

Malky
:sign0013:

Is this a path problem or what?

Malky

Active Member

Attachments

NJDude

Expert

Malky

Active Member

Erel

B4X founder

Mahares

Expert

Malky

Active Member

Mahares

Expert

Malky

Active Member

Malky

Active Member

Similar Threads

Is this a path problem or what?

Active Member

Attachments

Expert

Active Member

B4X founder

Expert

Active Member

Expert

Active Member

Active Member

Similar Threads

Privacy & Transparency

Privacy & Transparency