SqLite in network

[Marco Turco]

Hello Ramesh,
Sqlite3 hasn't a user/psw authentication. If you want to limit the access you should crypt the database using:
1 - the SEE encryption module
2 - or the variour crypt add-ons available
3 - or crypting the data from yourself

The 1 and 2 methods are obviusly preferrable if you want provide odbc facilities.

[RAMESHBABU]

Mr.Marco,

Thank you very much for the valuable information.

Regards,

- Ramesh Babu

[Rimantas]

Hello Marco !

What browse you are using with tsqlite object ? If xBrowse , can you show a small sample how it can be done ?

Many thanks in advance ! With best regards !

[RAMESHBABU]

Mr.Rimantas,

May be this is useful to you.

Code: Select all  Expand view

oSQL := TSQLiteServer():New( "DataBase" )
oQry := oSQL:Query( "select * from clients" )
XBROWSER oQry:aData
 

Regards,

- Ramesh Babu P

[Rimantas]

May be this is useful to you.

Code: Select all  Expand view

oSQL := TSQLiteServer():New( "DataBase" )
oQry := oSQL:Query( "select * from clients" )
XBROWSER oQry:aData
 

Mr.Ramesh , thank you . It will be usefull , I think . But :aData it's array, as I can understand from tsqlite.prg . More usefull it can be sample with real data from query and possibilities to build and manage xbrowse columns . I'm interesting in 'lookup' subqueries , that is in the main xbrowse , editing cell call subquery ( from combobox or string edit ) . How I can to do something like that ?

With best regards !

[RAMESHBABU]

Mr.Rimantas,

I am also new to Sql. Just I started playing with it.

Regards,

- Ramesh Babu P

[Marco Turco]

Hi Rimantas,
due to the kind of products developed I load the sql data into an array for browsing
but I don't know if this solution is suitable for you. It depends essentially from the number of records to browse.

[Marc Vanzegbroeck]

Hi,

I also want to start using SQLite.
What do I need to use it (library,wrappers,...)?

Regards,
Marc

[Sheng]

May be this is useful to you.

Code: Select all  Expand view

oSQL := TSQLiteServer():New( "DataBase" )
oQry := oSQL:Query( "select * from clients" )
XBROWSER oQry:aData
 

Mr.Ramesh , thank you . It will be usefull , I think . But :aData it's array, as I can understand from tsqlite.prg . More usefull it can be sample with real data from query and possibilities to build and manage xbrowse columns . I'm interesting in 'lookup' subqueries , that is in the main xbrowse , editing cell call subquery ( from combobox or string edit ) . How I can to do something like that ?

With best regards !

oQry := oSQL:Query( "select * from clients" )
change to:
oQry := oSQL:Query( "select * from clients", .F. )

[ssbbs]

New version of TSQLIte is release and fix some bug and support 'DATE' and 'TIMESTAMP' of field type.