Kintara Member Licensed User Longtime User Sep 21, 2014 #1 I am using the FTP library to transfer a SQL database over WiFi to a PC server. When the file arrives I am able to open it on the PC in 'SQLite Database Browser' but I am unable to see any of the tables or records. I transfer with FTP.UploadFile(FIle.DirDefaultExternal,"OfficeRecords.db",False,"OfficeTransfer.db") The data base will only have a few records of 255 fields (one a blob) and is usually around 500Kb. Can anyone suggest why I cannot even see the Database structure in the transfered file? p.s. I have also tried to close the database file before copying Main.SQL.OfficeFile.close Last edited: Sep 21, 2014
I am using the FTP library to transfer a SQL database over WiFi to a PC server. When the file arrives I am able to open it on the PC in 'SQLite Database Browser' but I am unable to see any of the tables or records. I transfer with FTP.UploadFile(FIle.DirDefaultExternal,"OfficeRecords.db",False,"OfficeTransfer.db") The data base will only have a few records of 255 fields (one a blob) and is usually around 500Kb. Can anyone suggest why I cannot even see the Database structure in the transfered file? p.s. I have also tried to close the database file before copying Main.SQL.OfficeFile.close
Erel B4X founder Staff member Licensed User Longtime User Sep 21, 2014 #2 You need to close the file before you upload it. Compare the device file and the desktop file. Are they identical? Upvote 0
You need to close the file before you upload it. Compare the device file and the desktop file. Are they identical?
K keirS Well-Known Member Licensed User Longtime User Sep 21, 2014 #3 Have you tried manually transferring the file to your PC and checking it? Upvote 0
