sqlite & sqlite 3

Talk about working with different database types

Moderator: alexandrleonenko

tagra123
Junior
Junior
Posts: 18
Joined: Apr 13th, '10, 11:49

sqlite & sqlite 3

Postby tagra123 » Jun 15th, '11, 18:57

Is there a way to connect to sqlite3 using the datagrid.

I have tried unsucessfully to do so. The error is that the database is encrypted -- I think this is because pear is expecting a sqlite2 database.

I can use PDO to get a connection and use the data manually without your datagrid but what I am asking is there a way to use the data with phpdatagrid.

If so then please show the proper connection example.

Is the only option to revert to sqlite2 if the datagrid is to be used?

tagra123
Junior
Junior
Posts: 18
Joined: Apr 13th, '10, 11:49

Re: sqlite & sqlite 3

Postby tagra123 » Jun 16th, '11, 04:40

sqlite = sqlite 2 database isnt working correctly either.

Receiving error --

Code: Select all

 Cannot use object of type DB_Error as array


happening on this line in the datagrid

Code: Select all

 return $fields[$field][$parameter];


in this section

Code: Select all

  //--------------------------------------------------------------------------
    // Get field info
    //--------------------------------------------------------------------------
    protected function GetFieldInfo($field, $parameter='', $type=0){       
        if(!$this->isError){
            $fields = $this->dataSet->tableInfo();           
            if($type == 0){
                if($this->GetFieldOffset($field) != -1)
                   return $fields[$this->GetFieldOffset($field)][$parameter];
                else
                   return '';
            }else{
           
                return $fields[$field][$parameter];
            }
        }
        return -1;
    }   
   


My code

Code: Select all

<?   

    ################################################################################   

    ## +---------------------------------------------------------------------------+

    ## | 1. Creating & Calling:                                                    |

    ## +---------------------------------------------------------------------------+

    ##  *** define a relative (virtual) path to datagrid.class.php file

    ##  *** (relatively to the current file)

    ##  *** RELATIVE PATH ONLY ***     

      define ("DATAGRID_DIR", "dgrd/");                     /* Ex.: "datagrid/" */

      define ("PEAR_DIR", "dgrd/pear/");                    /* Ex.: "datagrid/pear/" */

   

      require_once(DATAGRID_DIR.'datagrid.class.php');

      require_once(PEAR_DIR.'PEAR.php');

      require_once(PEAR_DIR.'DB.php');

   

    ##  *** creating variables that we need for database connection

      $DB_USER='username';           

      $DB_PASS='password';           

      $DB_HOST='localhost';       

      $DB_NAME='cev3updates.sqlite2';   

   

    ob_start();

      $db_conn = DB::factory('sqlite');  /* don't forget to change on appropriate db type */


      $result_conn = $db_conn->connect(DB::parseDSN('sqlite:////home/tgr/Documents/websites/myweb/public_html/v3/data/cev3updates.sqlite2'));
     

      if(DB::isError($result_conn)){ die($result_conn->getDebugInfo()); }

     
      echo "<br>Connected<br>";

    ##  *** put a primary key on the first place

      $sql=" SELECT * FROM versions ";

       

    ##  *** set needed options

      $debug_mode = true;

      $messaging = true;

      $unique_prefix = "f_"; 

      $dgrid = new DataGrid($debug_mode, $messaging, $unique_prefix, DATAGRID_DIR);

        echo "<br>new dgrid<br>";

    ##  *** set data source with needed options

      $default_order_field = "ce";

      $default_order_type = "ASC";

      $dgrid->DataSource($db_conn, $sql);   
     
        echo "<br>Datasource<br>";
         

      $dg_caption = '<b>Simplest PHP DataGrid</b>';

      $dgrid->SetCaption($dg_caption);

   

    ## +---------------------------------------------------------------------------+

    ## | 6. View Mode Settings:                                                    |

    ## +---------------------------------------------------------------------------+

    ##  *** set columns in view mode

       $dgrid->SetAutoColumnsInViewMode(true); 

   

 

     

    ## +---------------------------------------------------------------------------+

    ## | 8. Bind the DataGrid:                                                     |

    ## +---------------------------------------------------------------------------+

    ##  *** set debug mode & messaging options

        $dgrid->Bind();       

        ob_end_flush();

    ################################################################################   

?>
Last edited by tagra123 on Jun 16th, '11, 13:21, edited 1 time in total.

administrator
Site Admin
Site Admin
Posts: 6009
Joined: Jan 7th, '09, 23:18
Contact:

Re: sqlite & sqlite 3

Postby administrator » Jun 16th, '11, 09:47

Did you try to debug your application?
What $fields[$field][$parameter]; tries to return?
I mean try to print_r($fields);

tagra123
Junior
Junior
Posts: 18
Joined: Apr 13th, '10, 11:49

Re: sqlite & sqlite 3

Postby tagra123 » Jun 16th, '11, 13:19

I had tried to echo the field contents earlier but was only receiving 0 for the field.


The output you asked for is below.

I have used the datagrid in sql projects so I am familiar with the workings of the datagrid but this is baffling me.


    <br>Connected<br><br>new dgrid<br><br>0 fieldinfo<br>DB_Error Object
    (
    [error_message_prefix] =>
    [mode] => 1
    [level] => 1024
    [code] => -9
    [message] => DB Error: DB backend not capable
    [userinfo] => [nativecode=This DBMS can not obtain tableInfo from result sets]
    [backtrace] => Array
    (
    [0] => Array
    (
    [file] => /home/tgr/Documents/websites/myweb/public_html/v3/data/dgrd/pear/DB.php
    [line] => 751
    [function] => PEAR_Error
    [class] => PEAR_Error
    [object] => DB_Error Object
    *RECURSION*
    [type] => ->
    [args] => Array
    (
    [0] => DB Error: DB backend not capable
    [1] => -9
    [2] => 1
    [3] => 1024
    [4] => [nativecode=This DBMS can not obtain tableInfo from result sets]
    )

    )

    [1] => Array
    (
    [file] => /home/tgr/Documents/websites/myweb/public_html/v3/data/dgrd/pear/PEAR.php
    [line] => 536
    [function] => DB_Error
    [class] => DB_Error
    [object] => DB_Error Object
    *RECURSION*
    [type] => ->
    [args] => Array
    (
    [0] => -9
    [1] => 1
    [2] => 1024
    [3] => [nativecode=This DBMS can not obtain tableInfo from result sets]
    )

    )

    [2] => Array
    (
    [file] => /home/tgr/Documents/websites/myweb/public_html/v3/data/dgrd/pear/DB/common.php
    [line] => 1904
    [function] => raiseError
    [class] => PEAR
    [object] => DB_sqlite Object
    (
    [phptype] => sqlite
    [dbsyntax] => sqlite
    [features] => Array
    (
    [limit] => alter
    [new_link] =>
    [numrows] => 1
    [pconnect] => 1
    [prepare] =>
    [ssl] =>
    [transactions] =>
    )

    [errorcode_map] => Array
    (
    )

    [connection] => Resource id #8
    [dsn] => Array
    (
    [phptype] => sqlite
    [dbsyntax] => sqlite
    [username] =>
    [password] =>
    [protocol] => tcp
    [hostspec] =>
    [port] =>
    [socket] =>
    [database] => /home/tgr/Documents/websites/myweb/public_html/v3/data/cev3updates.sqlite2
    )

    [keywords] => Array
    (
    [BLOB] =>
    [BOOLEAN] =>
    [CHARACTER] =>
    [CLOB] =>
    [FLOAT] =>
    [INTEGER] =>
    [KEY] =>
    [NATIONAL] =>
    [NUMERIC] =>
    [NVARCHAR] =>
    [PRIMARY] =>
    [TEXT] =>
    [TIMESTAMP] =>
    [UNIQUE] =>
    [VARCHAR] =>
    [VARYING] =>
    )

    [_lasterror] =>
    [fetchmode] => 1
    [fetchmode_object_class] => stdClass
    [was_connected] =>
    [last_query] =>
    [options] => Array
    (
    [result_buffering] => 500
    [persistent] =>
    [ssl] =>
    [debug] => 0
    [seqname_format] => %s_seq
    [autofree] =>
    [portability] => 0
    [optimize] => performance
    )

    [last_parameters] => Array
    (
    )

    [prepare_tokens] => Array
    (
    )

    [prepare_types] => Array
    (
    )

    [prepared_queries] => Array
    (
    )

    [_last_query_manip] =>
    [_next_query_manip] =>
    [_debug] =>
    [_default_error_mode] =>
    [_default_error_options] =>
    [_default_error_handler] =>
    [_error_class] => DB_Error
    [_expected_errors] => Array
    (
    )

    [result] => Resource id #10
    )

    [type] => ->
    [args] => Array
    (
    [0] =>
    [1] => -9
    [2] =>
    [3] =>
    [4] => [nativecode=This DBMS can not obtain tableInfo from result sets]
    [5] => DB_Error
    [6] => 1
    )

    )

    [3] => Array
    (
    [file] => /home/tgr/Documents/websites/myweb/public_html/v3/data/dgrd/pear/DB/sqlite.php
    [line] => 792
    [function] => raiseError
    [class] => DB_common
    [object] => DB_sqlite Object
    (
    [phptype] => sqlite
    [dbsyntax] => sqlite
    [features] => Array
    (
    [limit] => alter
    [new_link] =>
    [numrows] => 1
    [pconnect] => 1
    [prepare] =>
    [ssl] =>
    [transactions] =>
    )

    [errorcode_map] => Array
    (
    )

    [connection] => Resource id #8
    [dsn] => Array
    (
    [phptype] => sqlite
    [dbsyntax] => sqlite
    [username] =>
    [password] =>
    [protocol] => tcp
    [hostspec] =>
    [port] =>
    [socket] =>
    [database] => /home/tgr/Documents/websites/myweb/public_html/v3/data/cev3updates.sqlite2
    )

    [keywords] => Array
    (
    [BLOB] =>
    [BOOLEAN] =>
    [CHARACTER] =>
    [CLOB] =>
    [FLOAT] =>
    [INTEGER] =>
    [KEY] =>
    [NATIONAL] =>
    [NUMERIC] =>
    [NVARCHAR] =>
    [PRIMARY] =>
    [TEXT] =>
    [TIMESTAMP] =>
    [UNIQUE] =>
    [VARCHAR] =>
    [VARYING] =>
    )

    [_lasterror] =>
    [fetchmode] => 1
    [fetchmode_object_class] => stdClass
    [was_connected] =>
    [last_query] =>
    [options] => Array
    (
    [result_buffering] => 500
    [persistent] =>
    [ssl] =>
    [debug] => 0
    [seqname_format] => %s_seq
    [autofree] =>
    [portability] => 0
    [optimize] => performance
    )

    [last_parameters] => Array
    (
    )

    [prepare_tokens] => Array
    (
    )

    [prepare_types] => Array
    (
    )

    [prepared_queries] => Array
    (
    )

    [_last_query_manip] =>
    [_next_query_manip] =>
    [_debug] =>
    [_default_error_mode] =>
    [_default_error_options] =>
    [_default_error_handler] =>
    [_error_class] => DB_Error
    [_expected_errors] => Array
    (
    )

    [result] => Resource id #10
    )

    [type] => ->
    [args] => Array
    (
    [0] => -9
    [1] =>
    [2] =>
    [3] =>
    [4] => This DBMS can not obtain tableInfo from result sets
    )

    )

    [4] => Array
    (
    [file] => /home/tgr/Documents/websites/myweb/public_html/v3/data/dgrd/pear/DB.php
    [line] => 1065
    [function] => tableInfo
    [class] => DB_sqlite
    [object] => DB_sqlite Object
    (
    [phptype] => sqlite
    [dbsyntax] => sqlite
    [features] => Array
    (
    [limit] => alter
    [new_link] =>
    [numrows] => 1
    [pconnect] => 1
    [prepare] =>
    [ssl] =>
    [transactions] =>
    )

    [errorcode_map] => Array
    (
    )

    [connection] => Resource id #8
    [dsn] => Array
    (
    [phptype] => sqlite
    [dbsyntax] => sqlite
    [username] =>
    [password] =>
    [protocol] => tcp
    [hostspec] =>
    [port] =>
    [socket] =>
    [database] => /home/tgr/Documents/websites/myweb/public_html/v3/data/cev3updates.sqlite2
    )

    [keywords] => Array
    (
    [BLOB] =>
    [BOOLEAN] =>
    [CHARACTER] =>
    [CLOB] =>
    [FLOAT] =>
    [INTEGER] =>
    [KEY] =>
    [NATIONAL] =>
    [NUMERIC] =>
    [NVARCHAR] =>
    [PRIMARY] =>
    [TEXT] =>
    [TIMESTAMP] =>
    [UNIQUE] =>
    [VARCHAR] =>
    [VARYING] =>
    )

    [_lasterror] =>
    [fetchmode] => 1
    [fetchmode_object_class] => stdClass
    [was_connected] =>
    [last_query] =>
    [options] => Array
    (
    [result_buffering] => 500
    [persistent] =>
    [ssl] =>
    [debug] => 0
    [seqname_format] => %s_seq
    [autofree] =>
    [portability] => 0
    [optimize] => performance
    )

    [last_parameters] => Array
    (
    )

    [prepare_tokens] => Array
    (
    )

    [prepare_types] => Array
    (
    )

    [prepared_queries] => Array
    (
    )

    [_last_query_manip] =>
    [_next_query_manip] =>
    [_debug] =>
    [_default_error_mode] =>
    [_default_error_options] =>
    [_default_error_handler] =>
    [_error_class] => DB_Error
    [_expected_errors] => Array
    (
    )

    [result] => Resource id #10
    )

    [type] => ->
    [args] => Array
    (
    [0] => DB_result Object
    (
    [dbh] => DB_sqlite Object
    (
    [phptype] => sqlite
    [dbsyntax] => sqlite
    [features] => Array
    (
    [limit] => alter
    [new_link] =>
    [numrows] => 1
    [pconnect] => 1
    [prepare] =>
    [ssl] =>
    [transactions] =>
    )

    [errorcode_map] => Array
    (
    )

    [connection] => Resource id #8
    [dsn] => Array
    (
    [phptype] => sqlite
    [dbsyntax] => sqlite
    [username] =>
    [password] =>
    [protocol] => tcp
    [hostspec] =>
    [port] =>
    [socket] =>
    [database] => /home/tgr/Documents/websites/myweb/public_html/v3/data/cev3updates.sqlite2
    )

    [keywords] => Array
    (
    [BLOB] =>
    [BOOLEAN] =>
    [CHARACTER] =>
    [CLOB] =>
    [FLOAT] =>
    [INTEGER] =>
    [KEY] =>
    [NATIONAL] =>
    [NUMERIC] =>
    [NVARCHAR] =>
    [PRIMARY] =>
    [TEXT] =>
    [TIMESTAMP] =>
    [UNIQUE] =>
    [VARCHAR] =>
    [VARYING] =>
    )

    [_lasterror] =>
    [fetchmode] => 1
    [fetchmode_object_class] => stdClass
    [was_connected] =>
    [last_query] =>
    [options] => Array
    (
    [result_buffering] => 500
    [persistent] =>
    [ssl] =>
    [debug] => 0
    [seqname_format] => %s_seq
    [autofree] =>
    [portability] => 0
    [optimize] => performance
    )

    [last_parameters] => Array
    (
    )

    [prepare_tokens] => Array
    (
    )

    [prepare_types] => Array
    (
    )

    [prepared_queries] => Array
    (
    )

    [_last_query_manip] =>
    [_next_query_manip] =>
    [_debug] =>
    [_default_error_mode] =>
    [_default_error_options] =>
    [_default_error_handler] =>
    [_error_class] => DB_Error
    [_expected_errors] => Array
    (
    )

    [result] => Resource id #10
    )

    [result] => Resource id #10
    [row_counter] =>
    [limit_from] =>
    [limit_count] =>
    [limit_type] => alter
    [autofree] =>
    [fetchmode] => 1
    [fetchmode_object_class] => stdClass
    )

    [1] =>
    )

    )

    [5] => Array
    (
    [file] => /home/tgr/Documents/websites/myweb/public_html/v3/data/dgrd/datagrid.class.php
    [line] => 4400
    [function] => tableInfo
    [class] => DB_result
    [object] => DB_result Object
    (
    [dbh] => DB_sqlite Object
    (
    [phptype] => sqlite
    [dbsyntax] => sqlite
    [features] => Array
    (
    [limit] => alter
    [new_link] =>
    [numrows] => 1
    [pconnect] => 1
    [prepare] =>
    [ssl] =>
    [transactions] =>
    )

    [errorcode_map] => Array
    (
    )

    [connection] => Resource id #8
    [dsn] => Array
    (
    [phptype] => sqlite
    [dbsyntax] => sqlite
    [username] =>
    [password] =>
    [protocol] => tcp
    [hostspec] =>
    [port] =>
    [socket] =>
    [database] => /home/tgr/Documents/websites/myweb/public_html/v3/data/cev3updates.sqlite2
    )

    [keywords] => Array
    (
    [BLOB] =>
    [BOOLEAN] =>
    [CHARACTER] =>
    [CLOB] =>
    [FLOAT] =>
    [INTEGER] =>
    [KEY] =>
    [NATIONAL] =>
    [NUMERIC] =>
    [NVARCHAR] =>
    [PRIMARY] =>
    [TEXT] =>
    [TIMESTAMP] =>
    [UNIQUE] =>
    [VARCHAR] =>
    [VARYING] =>
    )

    [_lasterror] =>
    [fetchmode] => 1
    [fetchmode_object_class] => stdClass
    [was_connected] =>
    [last_query] =>
    [options] => Array
    (
    [result_buffering] => 500
    [persistent] =>
    [ssl] =>
    [debug] => 0
    [seqname_format] => %s_seq
    [autofree] =>
    [portability] => 0
    [optimize] => performance
    )

    [last_parameters] => Array
    (
    )

    [prepare_tokens] => Array
    (
    )

    [prepare_types] => Array
    (
    )

    [prepared_queries] => Array
    (
    )

    [_last_query_manip] =>
    [_next_query_manip] =>
    [_debug] =>
    [_default_error_mode] =>
    [_default_error_options] =>
    [_default_error_handler] =>
    [_error_class] => DB_Error
    [_expected_errors] => Array
    (
    )

    [result] => Resource id #10
    )

    [result] => Resource id #10
    [row_counter] =>
    [limit_from] =>
    [limit_count] =>
    [limit_type] => alter
    [autofree] =>
    [fetchmode] => 1
    [fetchmode_object_class] => stdClass
    )

    [type] => ->
    [args] => Array
    (
    )

    )

    [6] => Array
    (
    [file] => /home/tgr/Documents/websites/myweb/public_html/v3/data/dgrd/datagrid.class.php
    [line] => 624
    [function] => GetFieldInfo
    [class] => DataGrid
    [object] => DataGrid Object
    (
    [dgVersion:DataGrid:private] => 5.0.8
    [uniquePrefix] => f_
    [uniqueRandomPrefix] => tdg9u
    [safeMode] =>
    [directory] => dgrd/
    [langName] => en
    [lang] => Array
    (
    [total] => Total
    [wrong_parameter_error] => Wrong parameter in [<b>_FIELD_</b>]: _VALUE_
    )

    [caption] =>
    [rows] => 4
    [rowLower] => 0
    [rowUpper] => 4
    [columns] => 13
    [colLower] => 0
    [colUpper] => 13
    [http] => http://
    [port] =>
    [serverName] => myserver.local
    [HTTP_URL] => http://myserver.local/v3/data/tedit.php
    [HTTP_HOST] => http://myserver.local/v3/data/data
    [httpGetVars] =>
    [anotherDatagrids] =>
    [ignoreBaseTag:DataGrid:private] =>
    [dbHandler] => DB_sqlite Object
    (
    [phptype] => sqlite
    [dbsyntax] => sqlite
    [features] => Array
    (
    [limit] => alter
    [new_link] =>
    [numrows] => 1
    [pconnect] => 1
    [prepare] =>
    [ssl] =>
    [transactions] =>
    )

    [errorcode_map] => Array
    (
    )

    [connection] => Resource id #8
    [dsn] => Array
    (
    [phptype] => sqlite
    [dbsyntax] => sqlite
    [username] =>
    [password] =>
    [protocol] => tcp
    [hostspec] =>
    [port] =>
    [socket] =>
    [database] => /home/tgr/Documents/websites/myweb/public_html/v3/data/cev3updates.sqlite2
    )

    [keywords] => Array
    (
    [BLOB] =>
    [BOOLEAN] =>
    [CHARACTER] =>
    [CLOB] =>
    [FLOAT] =>
    [INTEGER] =>
    [KEY] =>
    [NATIONAL] =>
    [NUMERIC] =>
    [NVARCHAR] =>
    [PRIMARY] =>
    [TEXT] =>
    [TIMESTAMP] =>
    [UNIQUE] =>
    [VARCHAR] =>
    [VARYING] =>
    )

    [_lasterror] =>
    [fetchmode] => 1
    [fetchmode_object_class] => stdClass
    [was_connected] =>
    [last_query] =>
    [options] => Array
    (
    [result_buffering] => 500
    [persistent] =>
    [ssl] =>
    [debug] => 0
    [seqname_format] => %s_seq
    [autofree] =>
    [portability] => 0
    [optimize] => performance
    )

    [last_parameters] => Array
    (
    )

    [prepare_tokens] => Array
    (
    )

    [prepare_types] => Array
    (
    )

    [prepared_queries] => Array
    (
    )

    [_last_query_manip] =>
    [_next_query_manip] =>
    [_debug] =>
    [_default_error_mode] =>
    [_default_error_options] =>
    [_default_error_handler] =>
    [_error_class] => DB_Error
    [_expected_errors] => Array
    (
    )

    [result] => Resource id #10
    )

    [sql] => SELECT * FROM versions WHERE 1=1
    [sqlView] => SELECT * FROM versions WHERE 1=1
    [sqlGroupBy] =>
    [dataSet:DataGrid:private] => DB_result Object
    (
    [dbh] => DB_sqlite Object
    (
    [phptype] => sqlite
    [dbsyntax] => sqlite
    [features] => Array
    (
    [limit] => alter
    [new_link] =>
    [numrows] => 1
    [pconnect] => 1
    [prepare] =>
    [ssl] =>
    [transactions] =>
    )

    [errorcode_map] => Array
    (
    )

    [connection] => Resource id #8
    [dsn] => Array
    (
    [phptype] => sqlite
    [dbsyntax] => sqlite
    [username] =>
    [password] =>
    [protocol] => tcp
    [hostspec] =>
    [port] =>
    [socket] =>
    [database] => /home/tgr/Documents/websites/myweb/public_html/v3/data/cev3updates.sqlite2
    )

    [keywords] => Array
    (
    [BLOB] =>
    [BOOLEAN] =>
    [CHARACTER] =>
    [CLOB] =>
    [FLOAT] =>
    [INTEGER] =>
    [KEY] =>
    [NATIONAL] =>
    [NUMERIC] =>
    [NVARCHAR] =>
    [PRIMARY] =>
    [TEXT] =>
    [TIMESTAMP] =>
    [UNIQUE] =>
    [VARCHAR] =>
    [VARYING] =>
    )

    [_lasterror] =>
    [fetchmode] => 1
    [fetchmode_object_class] => stdClass
    [was_connected] =>
    [last_query] =>
    [options] => Array
    (
    [result_buffering] => 500
    [persistent] =>
    [ssl] =>
    [debug] => 0
    [seqname_format] => %s_seq
    [autofree] =>
    [portability] => 0
    [optimize] => performance
    )

    [last_parameters] => Array
    (
    )

    [prepare_tokens] => Array
    (
    )

    [prepare_types] => Array
    (
    )

    [prepared_queries] => Array
    (
    )

    [_last_query_manip] =>
    [_next_query_manip] =>
    [_debug] =>
    [_default_error_mode] =>
    [_default_error_options] =>
    [_default_error_handler] =>
    [_error_class] => DB_Error
    [_expected_errors] => Array
    (
    )

    [result] => Resource id #10
    )

    [result] => Resource id #10
    [row_counter] =>
    [limit_from] =>
    [limit_count] =>
    [limit_type] => alter
    [autofree] =>
    [fetchmode] => 1
    [fetchmode_object_class] => stdClass
    )

    [sqlSort] => ORDER BY 1 ASC
    [amp] => &amp;
    [nbsp] =>
    [encoding] => utf8
    [collation] => utf8_unicode_ci
    [direction] => ltr
    [layouts] => Array
    (
    [view] => 0
    [edit] => 1
    [filter] => 1
    [show] => 1
    )

    [layoutType] => view
    [templates] => Array
    (
    [view] =>
    [edit] =>
    [show] =>
    )

    [pagesTotal] => 0
    [pageCurrent] => 1
    [defaultPageSize] => 10
    [dropdownPaging] =>
    [reqPageSize] => 10
    [pagingAllowed] => 1
    [rowsNumeration] =>
    [numerationSign] => N #
    [arrLowerPaging] => Array
    (
    [results] => 1
    [results_align] => left
    [pages] => 1
    [pages_align] => center
    [page_size] => 1
    [page_size_align] => right
    )

    [arrUpperPaging] => Array
    (
    [results] =>
    [results_align] => left
    [pages] =>
    [pages_align] => center
    [page_size] =>
    [page_size_align] => right
    )

    [arrPages] => Array
    (
    [10] => 10
    [25] => 25
    [50] => 50
    [100] => 100
    [250] => 250
    [500] => 500
    [1000] => 1000
    )



Last edited by tagra123 on Jun 16th, '11, 16:13, edited 1 time in total.

tagra123
Junior
Junior
Posts: 18
Joined: Apr 13th, '10, 11:49

Re: sqlite & sqlite 3

Postby tagra123 » Jun 16th, '11, 13:20

Continuation of the output array


    [firstArrow] => |&lt;&lt;
    [previousArrow] => &lt;&lt;
    [nextArrow] => &gt;&gt;
    [lastArrow] => &gt;&gt;|
    [limitStart] => 0
    [limitSize] => 10
    [rowsTotal] => 4
    [sortField] =>
    [sortType] =>
    [defaultSortField] => Array
    (
    [0] => 1
    )

    [defaultSortType] => Array
    (
    [0] => ASC
    )

    [defaultSortFieldHelp] =>
    [defaultSortTypeHelp] =>
    [sortingAllowed] => 1
    [filteringAllowed] =>
    [showSearchType] => 1
    [arrFilterFields] => Array
    (
    )

    [hideDisplay] =>
    [tabularColumns:DataGrid:private] =>
    [wrap] => wrap
    [isRowHighlightingAllowed] => 1
    [cssClass] => default
    [rowColor] => Array
    (
    )

    [isCssClassWritten:protected] =>
    [tblAlign] => Array
    (
    [view] => center
    [edit] => center
    [details] => center
    )

    [tblWidth] => Array
    (
    [view] => 90%
    [edit] => 70%
    [details] => 60%
    )

    [tblBorder] => Array
    (
    [view] => 1
    [edit] => 1
    [details] => 1
    )

    [tblBorderColor] => Array
    (
    [view] => #000000
    [edit] => #000000
    [details] => #000000
    )

    [tblCellSpacing] => Array
    (
    [view] => 0
    [edit] => 0
    [details] => 0
    )

    [tblCellPadding] => Array
    (
    [view] => 0
    [edit] => 0
    [details] => 0
    )

    [modes] => Array
    (
    [add] => Array
    (
    [view] => 1
    [edit] =>
    [type] => link
    [show_add_button] => inside
    )

    [edit] => Array
    (
    [view] => 1
    [edit] => 1
    [type] => link
    [byFieldValue] =>
    )

    [cancel] => Array
    (
    [view] => 1
    [edit] => 1
    [type] => link
    )

    [details] => Array
    (
    [view] => 1
    [edit] =>
    [type] => link
    )

    [delete] => Array
    (
    [view] => 1
    [edit] => 1
    [type] => image
    )

    )

    [modeAfterUpdate] =>
    [mode] => view
    [rid] =>
    [rids] =>
    [tblName] =>
    [primaryKey] =>
    [condition] =>
    [arrForeignKeys] => Array
    (
    )

    [columnsViewMode] => Array
    (
    )

    [columnsEditMode] => Array
    (
    )

    [sortedColumns] => Array
    (
    )

    [printingAllowed] => 1
    [exportingAllowed] =>
    [exportingDirectory] =>
    [exportAll] =>
    [arrExportingTypes:protected] => Array
    (
    [excel] => 1
    [pdf] => 1
    [xml] => 1
    )

    [navigationBar] =>
    [isPrinting:protected] =>
    [debug] => 1
    [startTime] => 1308229420.9703
    [endTime] => 0
    [isDemo] =>
    [actMsg] =>
    [messaging] => 1
    [isError] =>
    [errors] => Array
    (
    )

    [isWarning] =>
    [warnings] => Array
    (
    )

    [sqlStatements] => Array
    (
    [0] => <table width='90%'><tr><td align='left' class='default_dg_error_message no_print' style='COLOR: #333333;'><b>search sql (total: 4) </b> SELECT * FROM versions WHERE 1=1 ORDER BY 1 ASC LIMIT 0, 10 </td></tr></table>

    )

    [arrDgMessages] => Array
    (
    [add] =>
    [update] =>
    [delete] =>
    )

    [noDataFoundText] =>
    [isOperationCompleted:DataGrid:private] =>
    [platform] => Linux
    [browserName] => Firefox
    [browserVersion] => 3.6.17
    [scrollingOption] =>
    [scrollingWidth] => 90%
    [scrollingHeight] => 100%
    [fieldHeader] =>
    [fieldHeaderValue] =>
    [hideGridBeforeSearch] =>
    [arrSummarizeColumns] => Array
    (
    )

    [summarizeNumberFormat] => Array
    (
    [decimal_places] => 2
    [decimal_separator] => .
    [thousands_separator] => ,
    )

    [summarizeFunction] => SUM
    [isMultirowAllowed] =>
    [multiRows] => 0
    [arrMultirowOperations] => Array
    (
    [delete] => Array
    (
    [view] => 1
    )

    [details] => Array
    (
    [view] => 1
    )

    )

    [firstFieldFocusAllowed] =>
    [jsValidationErrors:protected] => true
    [existingFields] => Array
    (
    [resizable_field] =>
    [wysiwyg_field] =>
    [calendar_type_popup] =>
    [calendar_type_floating] =>
    [autosuggestion_field] =>
    [tooltip_type_floating] =>
    [magnify_field_view] =>
    [magnify_field_edit] =>
    [magnify_field_view_magnifier] =>
    [magnify_field_view_lightbox] =>
    [magnify_field_edit_magnifier] =>
    [magnify_field_edit_lightbox] =>
    )

    [isLoadingImageEnabled:DataGrid:private] => 1
    [controlsDisplayingType] =>
    [allowRealEscape] => 1
    [ajaxEnabled:DataGrid:private] =>
    [sort_field_by] =>
    [sort_field_type] =>
    )

    [type] => ->
    [args] => Array
    (
    [0] => 0
    [1] => type
    [2] => 1
    )

    )

    [7] => Array
    (
    [file] => /home/tgr/Documents/websites/myweb/public_html/v3/data/tedit.php
    [line] => 42
    [function] => DataSource
    [class] => DataGrid
    [object] => DataGrid Object
    (
    [dgVersion:DataGrid:private] => 5.0.8
    [uniquePrefix] => f_
    [uniqueRandomPrefix] => tdg9u
    [safeMode] =>
    [directory] => dgrd/
    [langName] => en
    [lang] => Array
    (
    [total] => Total
    [wrong_parameter_error] => Wrong parameter in [<b>_FIELD_</b>]: _VALUE_
    )

    [caption] =>
    [rows] => 4
    [rowLower] => 0
    [rowUpper] => 4
    [columns] => 13
    [colLower] => 0
    [colUpper] => 13
    [http] => http://
    [port] =>
    [serverName] => myserver.local
    [HTTP_URL] => http://myserver.local/v3/data/tedit.php
    [HTTP_HOST] => http://myserver.local/v3/data/data
    [httpGetVars] =>
    [anotherDatagrids] =>
    [ignoreBaseTag:DataGrid:private] =>
    [dbHandler] => DB_sqlite Object
    (
    [phptype] => sqlite
    [dbsyntax] => sqlite
    [features] => Array
    (
    [limit] => alter
    [new_link] =>
    [numrows] => 1
    [pconnect] => 1
    [prepare] =>
    [ssl] =>
    [transactions] =>
    )

    [errorcode_map] => Array
    (
    )

    [connection] => Resource id #8
    [dsn] => Array
    (
    [phptype] => sqlite
    [dbsyntax] => sqlite
    [username] =>
    [password] =>
    [protocol] => tcp
    [hostspec] =>
    [port] =>
    [socket] =>
    [database] => /home/tgr/Documents/websites/myweb/public_html/v3/data/cev3updates.sqlite2
    )

    [keywords] => Array
    (
    [BLOB] =>
    [BOOLEAN] =>
    [CHARACTER] =>
    [CLOB] =>
    [FLOAT] =>
    [INTEGER] =>
    [KEY] =>
    [NATIONAL] =>
    [NUMERIC] =>
    [NVARCHAR] =>
    [PRIMARY] =>
    [TEXT] =>
    [TIMESTAMP] =>
    [UNIQUE] =>
    [VARCHAR] =>
    [VARYING] =>
    )

    [_lasterror] =>
    [fetchmode] => 1
    [fetchmode_object_class] => stdClass
    [was_connected] =>
    [last_query] =>
    [options] => Array
    (
    [result_buffering] => 500
    [persistent] =>
    [ssl] =>
    [debug] => 0
    [seqname_format] => %s_seq
    [autofree] =>
    [portability] => 0
    [optimize] => performance
    )

    [last_parameters] => Array
    (
    )

    [prepare_tokens] => Array
    (
    )

    [prepare_types] => Array
    (
    )

    [prepared_queries] => Array
    (
    )

    [_last_query_manip] =>
    [_next_query_manip] =>
    [_debug] =>
    [_default_error_mode] =>
    [_default_error_options] =>
    [_default_error_handler] =>
    [_error_class] => DB_Error
    [_expected_errors] => Array
    (
    )

    [result] => Resource id #10
    )

    [sql] => SELECT * FROM versions WHERE 1=1
    [sqlView] => SELECT * FROM versions WHERE 1=1
    [sqlGroupBy] =>
    [dataSet:DataGrid:private] => DB_result Object
    (
    [dbh] => DB_sqlite Object
    (
    [phptype] => sqlite
    [dbsyntax] => sqlite
    [features] => Array
    (
    [limit] => alter
    [new_link] =>
    [numrows] => 1
    [pconnect] => 1
    [prepare] =>
    [ssl] =>
    [transactions] =>
    )

    [errorcode_map] => Array
    (
    )

    [connection] => Resource id #8
    [dsn] => Array
    (
    [phptype] => sqlite
    [dbsyntax] => sqlite
    [username] =>
    [password] =>
    [protocol] => tcp
    [hostspec] =>
    [port] =>
    [socket] =>
    [database] => /home/tgr/Documents/websites/myweb/public_html/v3/data/cev3updates.sqlite2
    )

    [keywords] => Array
    (
    [BLOB] =>
    [BOOLEAN] =>
    [CHARACTER] =>
    [CLOB] =>
    [FLOAT] =>
    [INTEGER] =>
    [KEY] =>
    [NATIONAL] =>
    [NUMERIC] =>
    [NVARCHAR] =>
    [PRIMARY] =>
    [TEXT] =>
    [TIMESTAMP] =>
    [UNIQUE] =>
    [VARCHAR] =>
    [VARYING] =>
    )

    [_lasterror] =>
    [fetchmode] => 1
    [fetchmode_object_class] => stdClass
    [was_connected] =>
    [last_query] =>
    [options] => Array
    (
    [result_buffering] => 500
    [persistent] =>
    [ssl] =>
    [debug] => 0
    [seqname_format] => %s_seq
    [autofree] =>
    [portability] => 0
    [optimize] => performance
    )

    [last_parameters] => Array
    (
    )

    [prepare_tokens] => Array
    (
    )

    [prepare_types] => Array
    (
    )

    [prepared_queries] => Array
    (
    )

    [_last_query_manip] =>
    [_next_query_manip] =>
    [_debug] =>
    [_default_error_mode] =>
    [_default_error_options] =>
    [_default_error_handler] =>
    [_error_class] => DB_Error
    [_expected_errors] => Array
    (
    )

    [result] => Resource id #10
    )

    [result] => Resource id #10
    [row_counter] =>
    [limit_from] =>
    [limit_count] =>
    [limit_type] => alter
    [autofree] =>
    [fetchmode] => 1
    [fetchmode_object_class] => stdClass
    )

    [sqlSort] => ORDER BY 1 ASC
    [amp] => &amp;
    [nbsp] =>
    [encoding] => utf8
    [collation] => utf8_unicode_ci
    [direction] => ltr
    [layouts] => Array
    (
    [view] => 0
    [edit] => 1
    [filter] => 1
    [show] => 1
    )

    [layoutType] => view
    [templates] => Array
    (
    [view] =>
    [edit] =>
    [show] =>
    )

    [pagesTotal] => 0
    [pageCurrent] => 1
    [defaultPageSize] => 10
    [dropdownPaging] =>
    [reqPageSize] => 10
    [pagingAllowed] => 1
    [rowsNumeration] =>
    [numerationSign] => N #
    [arrLowerPaging] => Array
    (
    [results] => 1
    [results_align] => left
    [pages] => 1
    [pages_align] => center
    [page_size] => 1
    [page_size_align] => right
    )

    [arrUpperPaging] => Array
    (
    [results] =>
    [results_align] => left
    [pages] =>
    [pages_align] => center
    [page_size] =>
    [page_size_align] => right
    )

    [arrPages] => Array
    (
    [10] => 10
    [25] => 25
    [50] => 50
    [100] => 100
    [250] => 250
    [500] => 500
    [1000] => 1000
    )

    [firstArrow] => |&lt;&lt;
    [previousArrow] => &lt;&lt;
    [nextArrow] => &gt;&gt;
    [lastArrow] => &gt;&gt;|
    [limitStart] => 0
    [limitSize] => 10
    [rowsTotal] => 4
    [sortField] =>
    [sortType] =>
    [defaultSortField] => Array
    (
    [0] => 1
    )

    [defaultSortType] => Array
    (
    [0] => ASC
    )

    [defaultSortFieldHelp] =>
    [defaultSortTypeHelp] =>
    [sortingAllowed] => 1
    [filteringAllowed] =>
    [showSearchType] => 1
    [arrFilterFields] => Array
    (
    )

    [hideDisplay] =>
    [tabularColumns:DataGrid:private] =>
    [wrap] => wrap
    [isRowHighlightingAllowed] => 1
    [cssClass] => default
    [rowColor] => Array
    (
    )

    [isCssClassWritten:protected] =>
    [tblAlign] => Array
    (
    [view] => center
    [edit] => center
    [details] => center
    )

    [tblWidth] => Array
    (
    [view] => 90%
    [edit] => 70%
    [details] => 60%
    )

    [tblBorder] => Array
    (
    [view] => 1
    [edit] => 1
    [details] => 1
    )

    [tblBorderColor] => Array
    (
    [view] => #000000
    [edit] => #000000
    [details] => #000000
    )

    [tblCellSpacing] => Array
    (
    [view] => 0
    [edit] => 0
    [details] => 0
    )

    [tblCellPadding] => Array
    (
    [view] => 0
    [edit] => 0
    [details] => 0
    )

    [modes] => Array
    (
    [add] => Array
    (
    [view] => 1
    [edit] =>
    [type] => link
    [show_add_button] => inside
    )

    [edit] => Array
    (
    [view] => 1
    [edit] => 1
    [type] => link
    [byFieldValue] =>
    )

    [cancel] => Array
    (
    [view] => 1
    [edit] => 1
    [type] => link
    )

    [details] => Array
    (
    [view] => 1
    [edit] =>
    [type] => link
    )

    [delete] => Array
    (
    [view] => 1
    [edit] => 1
    [type] => image
    )

    )

    [modeAfterUpdate] =>
    [mode] => view
    [rid] =>
    [rids] =>
    [tblName] =>
    [primaryKey] =>
    [condition] =>
    [arrForeignKeys] => Array
    (
    )

    [columnsViewMode] => Array
    (
    )

    [columnsEditMode] => Array
    (
    )

    [sortedColumns] => Array
    (
    )

    [printingAllowed] => 1
    [exportingAllowed] =>
    [exportingDirectory] =>
    [exportAll] =>
    [arrExportingTypes:protected] => Array
    (
    [excel] => 1
    [pdf] => 1
    [xml] => 1
    )

    [navigationBar] =>
    [isPrinting:protected] =>
    [debug] => 1
    [startTime] => 1308229420.9703
    [endTime] => 0
    [isDemo] =>
    [actMsg] =>
    [messaging] => 1
    [isError] =>
    [errors] => Array
    (
    )

    [isWarning] =>
    [warnings] => Array
    (
    )

    [sqlStatements] => Array
    (
    [0] => <table width='90%'><tr><td align='left' class='default_dg_error_message no_print' style='COLOR: #333333;'><b>search sql (total: 4) </b> SELECT * FROM versions WHERE 1=1 ORDER BY 1 ASC LIMIT 0, 10 </td></tr></table>

    )

    [arrDgMessages] => Array
    (
    [add] =>
    [update] =>
    [delete] =>
    )

    [noDataFoundText] =>
    [isOperationCompleted:DataGrid:private] =>
    [platform] => Linux
    [browserName] => Firefox
    [browserVersion] => 3.6.17
    [scrollingOption] =>
    [scrollingWidth] => 90%
    [scrollingHeight] => 100%
    [fieldHeader] =>
    [fieldHeaderValue] =>
    [hideGridBeforeSearch] =>
    [arrSummarizeColumns] => Array
    (
    )

    [summarizeNumberFormat] => Array
    (
    [decimal_places] => 2
    [decimal_separator] => .
    [thousands_separator] => ,
    )

    [summarizeFunction] => SUM
    [isMultirowAllowed] =>
    [multiRows] => 0
    [arrMultirowOperations] => Array
    (
    [delete] => Array
    (
    [view] => 1
    )

    [details] => Array
    (
    [view] => 1
    )

    )

    [firstFieldFocusAllowed] =>
    [jsValidationErrors:protected] => true
    [existingFields] => Array
    (
    [resizable_field] =>
    [wysiwyg_field] =>
    [calendar_type_popup] =>
    [calendar_type_floating] =>
    [autosuggestion_field] =>
    [tooltip_type_floating] =>
    [magnify_field_view] =>
    [magnify_field_edit] =>
    [magnify_field_view_magnifier] =>
    [magnify_field_view_lightbox] =>
    [magnify_field_edit_magnifier] =>
    [magnify_field_edit_lightbox] =>
    )

    [isLoadingImageEnabled:DataGrid:private] => 1
    [controlsDisplayingType] =>
    [allowRealEscape] => 1
    [ajaxEnabled:DataGrid:private] =>
    [sort_field_by] =>
    [sort_field_type] =>
    )

    [type] => ->
    [args] => Array
    (
    [0] => DB_sqlite Object
    (
    [phptype] => sqlite
    [dbsyntax] => sqlite
    [features] => Array
    (
    [limit] => alter
    [new_link] =>
    [numrows] => 1
    [pconnect] => 1
    [prepare] =>
    [ssl] =>
    [transactions] =>
    )

    [errorcode_map] => Array
    (
    )

    [connection] => Resource id #8
    [dsn] => Array
    (
    [phptype] => sqlite
    [dbsyntax] => sqlite
    [username] =>
    [password] =>
    [protocol] => tcp
    [hostspec] =>
    [port] =>
    [socket] =>
    [database] => /home/tgr/Documents/websites/myweb/public_html/v3/data/cev3updates.sqlite2
    )

    [keywords] => Array
    (
    [BLOB] =>
    [BOOLEAN] =>
    [CHARACTER] =>
    [CLOB] =>
    [FLOAT] =>
    [INTEGER] =>
    [KEY] =>
    [NATIONAL] =>
    [NUMERIC] =>
    [NVARCHAR] =>
    [PRIMARY] =>
    [TEXT] =>
    [TIMESTAMP] =>
    [UNIQUE] =>
    [VARCHAR] =>
    [VARYING] =>
    )

    [_lasterror] =>
    [fetchmode] => 1
    [fetchmode_object_class] => stdClass
    [was_connected] =>
    [last_query] =>
    [options] => Array
    (
    [result_buffering] => 500
    [persistent] =>
    [ssl] =>
    [debug] => 0
    [seqname_format] => %s_seq
    [autofree] =>
    [portability] => 0
    [optimize] => performance
    )

    [last_parameters] => Array
    (
    )

    [prepare_tokens] => Array
    (
    )

    [prepare_types] => Array
    (
    )

    [prepared_queries] => Array
    (
    )

    [_last_query_manip] =>
    [_next_query_manip] =>
    [_debug] =>
    [_default_error_mode] =>
    [_default_error_options] =>
    [_default_error_handler] =>
    [_error_class] => DB_Error
    [_expected_errors] => Array
    (
    )

    [result] => Resource id #10
    )

    [1] => SELECT * FROM versions
    )

    )

    )

    [callback] =>
    )

    Fatal error: Cannot use object of type DB_Error as array in /home/tgr/Documents/websites/myweb/public_html/v3/data/dgrd/datagrid.class.php on line 4410
Last edited by tagra123 on Jun 16th, '11, 16:14, edited 1 time in total.

tagra123
Junior
Junior
Posts: 18
Joined: Apr 13th, '10, 11:49

Re: sqlite & sqlite 3

Postby tagra123 » Jun 16th, '11, 15:28

I wanted to make sure it wasn"t pear causing the problem so I tried the following code which works without incident on a version 2 sqlite database. So I'm thinking it's a problem in the datagrid class itself.

Code: Select all

<?php
define ("DATAGRID_DIR", "dgrd/");                     /* Ex.: "datagrid/" */
      define ("PEAR_DIR", "dgrd/pear/");                    /* Ex.: "datagrid/pear/" */
   
      require_once(DATAGRID_DIR.'datagrid.class.php');
      require_once(PEAR_DIR.'PEAR.php');
      require_once(PEAR_DIR.'DB.php');

@$DB = DB::connect('sqlite:////home/tgr/Documents/websites/v3/data/cev3updates.sqlite2?mode=0666');
if (DB::isError($DB))
{
 echo 'Cannot connect to database: ' . $DB->getMessage();
}
else
{
 $Query = 'SELECT * FROM Versions';
 $Result = $DB->query($Query);
 $NumResults = $Result->numRows();
 echo "<b>$NumResults Versions</b>
 <table border='1'>
 <tr>
  <th>ID</th>
  <th>CE</th>
 
 </tr>";

 while ($Row = $Result->fetchRow(DB_FETCHMODE_ASSOC))
 {
  echo '<tr>';
  echo '<td>' . $Row['id'] . '</td>';
  echo '<td>' . $Row['ce'] . '</td>';
 
  echo '</tr>';
 }
 
echo " </table>";


 $Result->free();
 $DB->disconnect();
}
?>
Last edited by tagra123 on Jun 16th, '11, 15:31, edited 1 time in total.

tagra123
Junior
Junior
Posts: 18
Joined: Apr 13th, '10, 11:49

Re: sqlite & sqlite 3

Postby tagra123 » Jun 16th, '11, 15:31

I wanted to make sure it wasn"t pear causing the problem so I tried the following code which works without incident on a version 2 sqlite database. So I'm thinking it's a problem in the datagrid class itself.

Code: Select all

<?php
define ("DATAGRID_DIR", "dgrd/");                     /* Ex.: "datagrid/" */
      define ("PEAR_DIR", "dgrd/pear/");                    /* Ex.: "datagrid/pear/" */
   
      require_once(DATAGRID_DIR.'datagrid.class.php');
      require_once(PEAR_DIR.'PEAR.php');
      require_once(PEAR_DIR.'DB.php');

@$DB = DB::connect('sqlite:////home/tgr/Documents/websites/v3/data/cev3updates.sqlite2?mode=0666');
if (DB::isError($DB))
{
 echo 'Cannot connect to database: ' . $DB->getMessage();
}
else
{
 $Query = 'SELECT * FROM Versions';
 $Result = $DB->query($Query);
 $NumResults = $Result->numRows();
 echo "<b>$NumResults Versions</b>
 <table border='1'>
 <tr>
  <th>ID</th>
  <th>CE</th>
 
 </tr>";

 while ($Row = $Result->fetchRow(DB_FETCHMODE_ASSOC))
 {
  echo '<tr>';
  echo '<td>' . $Row['id'] . '</td>';
  echo '<td>' . $Row['ce'] . '</td>';
 
  echo '</tr>';
 }
 
echo " </table>";


 $Result->free();
 $DB->disconnect();
}
?>

administrator
Site Admin
Site Admin
Posts: 6009
Joined: Jan 7th, '09, 23:18
Contact:

Re: sqlite & sqlite 3

Postby administrator » Jun 19th, '11, 08:31

Thank you, we'll check this issue for the next version.
Generally we're planning to move to PDO instead of PEAR.

natalop
Newbie
Newbie
Posts: 4
Joined: Aug 10th, '16, 17:55

Re: sqlite & sqlite 3

Postby natalop » Aug 10th, '16, 18:07

Sorry for my English.
I bought it ApPHP DataGrid script ver. 8.1.8
I can not use it with sqlite.
Can someone help me?
There is a simple example that works?
Thank you in advance!
 (I read in the forum signs for a sqlite connection with PDO, but does not work, maybe something wrong?)

administrator
Site Admin
Site Admin
Posts: 6009
Joined: Jan 7th, '09, 23:18
Contact:

Re: sqlite & sqlite 3

Postby administrator » Aug 11th, '16, 13:24



Return to “Databases: different types implementation”