E edgar_ortiz Active Member Licensed User Longtime User Feb 11, 2013 #1 Hi, I have a app that lose a DB object who was created en Code: Copy Sub Process_Globals 'These global variables will be declared once when the application starts. 'These variables can be accessed from all modules. ' Dim DBGps As SQL ' This occurs after a "inactivity" time. Any help is welcome Regards, Edgar Attachments Gps_Test.zip Gps_Test.zip 16.2 KB · Views: 283 Log.txt Log.txt 6.4 KB · Views: 278
Hi, I have a app that lose a DB object who was created en Code: Copy Sub Process_Globals 'These global variables will be declared once when the application starts. 'These variables can be accessed from all modules. ' Dim DBGps As SQL ' This occurs after a "inactivity" time. Any help is welcome Regards, Edgar
mangojack Expert Licensed User Longtime User Feb 11, 2013 #2 Code: Copy Sub Process_Globals 'These global variables will be declared once when the application starts. 'These variables can be accessed from all modules. ' Dim DBGps As SQL Code: Copy Sub Open_DataBase (Directorio As String, DBName As String) Dim lcResult As Boolean ' If File.Exists(Directorio, DBName) = True Then ' Se abre la Base de Datos Main.DBGPS.Initialize(Directorio, DBName, False) If Main.DBGPS.IsInitialized = True Then You have declared ' DBGps ' but then appear to Initialize ' DBGPS '. Also on last line you then initialize DBGPS and immediately test if it is initialized ? Cheers mj Attachments Capture.JPG 28.4 KB · Views: 409 Upvote 0
Code: Copy Sub Process_Globals 'These global variables will be declared once when the application starts. 'These variables can be accessed from all modules. ' Dim DBGps As SQL Code: Copy Sub Open_DataBase (Directorio As String, DBName As String) Dim lcResult As Boolean ' If File.Exists(Directorio, DBName) = True Then ' Se abre la Base de Datos Main.DBGPS.Initialize(Directorio, DBName, False) If Main.DBGPS.IsInitialized = True Then You have declared ' DBGps ' but then appear to Initialize ' DBGPS '. Also on last line you then initialize DBGPS and immediately test if it is initialized ? Cheers mj
E edgar_ortiz Active Member Licensed User Longtime User Feb 12, 2013 #3 Thanks for your time. Buyt B4A, is not case sensite in the name of variables. Also the problem is given after several writes on the database. Regards, Edgar Upvote 0
Thanks for your time. Buyt B4A, is not case sensite in the name of variables. Also the problem is given after several writes on the database. Regards, Edgar
mangojack Expert Licensed User Longtime User Feb 12, 2013 #4 Edgar . Yes correct Variables not case sensitive. I added a dbgps.db3 to assets and the app runs OK.. I do not get initialization error ?? Cheers mj Upvote 0
Edgar . Yes correct Variables not case sensitive. I added a dbgps.db3 to assets and the app runs OK.. I do not get initialization error ?? Cheers mj
E edgar_ortiz Active Member Licensed User Longtime User Feb 12, 2013 #5 I appreciate your time, I tested the app and the problem occurs when pass a good amount of time, apparently the "app" is killed and the "service" (gps) is alive. :BangHead: By example... run others programs, and after 10 minutes, the program crash. Again, thanks for your time. If you can test the app... I appreciate. Regards, Edgar Upvote 0
I appreciate your time, I tested the app and the problem occurs when pass a good amount of time, apparently the "app" is killed and the "service" (gps) is alive. :BangHead: By example... run others programs, and after 10 minutes, the program crash. Again, thanks for your time. If you can test the app... I appreciate. Regards, Edgar