| AndreLuiz |
| (Getting the hang of it) |
| 2018-11-09 04:16 AM |
Ho to use sqlite?
|
[PT-br]
Olá a todos, queria saber com vocês como faço para usar o sqlite no KiXtart.
Se caso não seja possível, qual a outra alternativa de db para kixtart?
Fico no aguardo da resposta, obrigado desde já.
[ENG]
Hi all, I wanted to know with you how I use sqlite in KiXtart.
If it is not possible, what is the other alternative from db to kixtart?
I'm waiting for the answer, thank you in advance.
Glenn Barnas
|
| (KiX Supporter) |
| 2018-11-09 04:04 PM |
|
Re: Ho to use sqlite?
|
Have you looked at the SQL library in the UDFs forum? There are several individual UDFs related to DB/SQL access that - even if not right for SqlLite, might be a good starting point for customizing.
Glenn
|
Allen
|
| (KiX Supporter) |
| 2018-11-09 04:10 PM |
|
Re: Ho to use sqlite?
|
No experience with this, but the first thing I think of is ODBC. If you have a proper OBDC driver installed, pretty much every database UDF here should work with it.
I've never used this, but here is one:
http://www.ch-werner.de/sqliteodbc/
| AndreLuiz |
| (Getting the hang of it) |
| 2018-11-12 02:09 PM |
|
Re: Ho to use sqlite?
|
[PT-br]
Glen, eu não queria lhe incomodar, mas é que eu não sei exatamente como fazer um script para testar.
Você poderia criar um script de exemplo para mim, por favor!
[ENG]
Glen, I did not identify you, but I do not know exactly how to do a script to test.
You could create a sample script for me, please!
|
Lonkero
|
| (KiX Master Guru) |
| 2018-11-14 09:19 PM |
|
Re: Ho to use sqlite?
|
http://www.kixtart.org/forums/ubbthreads.php?ubb=showflat&Number=83073
http://www.kixtart.org/forums/ubbthreads.php?ubb=showflat&Number=83094
http://www.kixtart.org/forums/ubbthreads.php?ubb=showflat&Number=83093
| AndreLuiz |
| (Getting the hang of it) |
| 2018-11-22 06:22 PM |
|
Re: Ho to use sqlite?
|
[ptbr]
Olá gente, resolvi trabalhar com o firebird 2.5.
Mas não consegui nem fazer a conexão com o banco, você podem me ajudar?
[eng]
Hello everyone, I have decided to work with firebird 2.5.
But I could not make the connection to the bank, can you help me?
Code:
Break on
$objConn = DBConnOpen('
User=SYSDBA;Password=xxxxxx;Database=C:\Users\MSOFT-03\Desktop\TESTE.FDB;DataSource=localhost;
Port=3050;Dialect=3;Charset=WINPT_BR;Role=;Connection lifetime=15;Pooling=true;
MinPoolSize=0;MaxPoolSize=100;Packet Size=8192;ServerType=0;
')
VARTYPE($objConn)?
get$
|
Allen
|
| (KiX Supporter) |
| 2018-11-25 05:44 AM |
|
Re: Ho to use sqlite?
|
Please add
? @serror
right after the dbconnopen(...) and tell us the error.
|
Lonkero
|
| (KiX Master Guru) |
| 2018-11-28 06:11 PM |
|
Re: Ho to use sqlite?
|
it seems that some of your arguments for the connection string are not quite firebird compatible.
check out their documentation at:
https://www.firebirdsql.org/file/documen...ples-connection