SQLImport with result 'undefined'

1

I successfully exported my sqlDB to a JSON string in a text field. I want to import the database from the same text field, but it results in ‘result = undefined’.

2

You’ll need to dig into this some more. Are you referring to the contents of the text field properly?

3

I think so, this is my code:

Function ExportDB()
  NSB.ShowProgress("Exporting database...")
  DBjson=SQLExport(DB, DBBil, exportComplete)    'DBBil = "DBBil.db"
End Function
 
Function exportComplete()
  NSB.ShowProgress(False)
  txtaImEx.value = JSON.stringify(DBjson)    'txtaImEx is jQuery Mobile text are
  msgbil("exportComplete")   'Message Funcion of my own
End Function

Function ImportDB()
  debugger
  result = SQLImport(JSON.parse(txtaImEx.value), DB, ImportCallback, ImpErr)
  'DB = SqlOpenDatabase(DBBil,"1.0",DBBil)
  msgbil("ImportDB result: " & result)
End Function

Function ImportCallback(event)
  msgbil("Import complete, Callback")   'reached
End Function

Function ImpErr(event)
  msgbil("Import with ERR: " & event)    ' never reached
End Function
4

Tip : If you’re pasting code, html or config files, surround the code with triple back ticks (```), before the first line and after the last one. It will be formatted properly. (We fixed it for you this time)

5

Does the JSON show up in txtaImEx?

What line gets the message? What is the exact error message?

6

Thank for the formatting hint, I will do this in the future.

The JSON string is shown after the Export in txtaImEx.
After the line
result = SQLImport(JSON.parse(txtaImEx.value), DB, ImportCallback, ImpErr)
result = undefined
is shown, no other error code.

Now I changed the following 2 lines:
DBjson=SQLExport(DB, "customer.db", exportComplete)
result = SQLImport(JSON.parse(txtaImEx.value), "customer.db", ImportCallback, ImpErr)
Now the text Importing database ... is shown, but never ends!

7

I dropped all tables after the export and got success hopefully with the import, but not shure. I will test furthermore. Is there a command to delete a database?

8

If you are running in the browser, you can see the databases in the Chrome Debugger, in the Application tab. Check out Local Storage.

9

It’s working for me now (after dropping tables), but there’s some strange behavior:
On the first attempt to export, the textarea is empty (undefined); on the second attempt, it’s filled as expected. Timing problem? Do I have to create DJason as an object? Dim…
This behavior is similar to the behavior in the SQLExpImp example. I have to press the Export button twice

10

How can I create an object ? DBJason = new Object() doesn’t work.

11

Not sure why you’re asking this question, so I’m not sure how to best answer it.

DBJason = new Object()

works fine, but I gather it does not solve the problem for you.

Can you explain more?

12

After this definition I call DBjson=SQLExport(DB, "DBBil.db", exportComplete) and after that statement DBJason is undefined !? in remote debugger and then txtaImEx.value = JSON.stringify(DBjson) gives an empty result. After a second attempt immediately afterwards I get a good, expected result.
the following code passage is successful, but unsatisfactory:

ExportDB()
If Len(txtaImEx.value) < 20 Then '1.Versuch fehlgeschlagen  
   ExportDB()
End If

Function ExportDB()
  NSB.ShowProgress("Exporting database...")
  DBjson=SQLExport(DB, "DBBil.db", exportComplete)
End Function
13

DBjson or DBJason?

14

I think I have a naming problem, I’ll check that

15

I have fixed the name problem, but it still takes the second attempt to succeed

16

Does exportComplete get called both times?

17

Yes, but first DBjson is undefined.

18

I think it would be could if I could try it here. Could you send me a minimal project which easily reproduces this?

I’m at support@appstudio.dev.

Thanks!

19

I will send it soon!

20

I sent it 1 minute ago

SQLExport2.appstudio.zip (762.9 KB)