Page 1 of 1 1
Topic Options
#213608 - 2018-11-09 04:16 AM Ho to use sqlite?
AndreLuiz Offline
Getting the hang of it

Registered: 2015-10-07
Posts: 74
Loc: Brasil, João pessoa
[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.

Top
#213609 - 2018-11-09 04:04 PM Re: Ho to use sqlite? [Re: AndreLuiz]
Glenn Barnas Administrator Online   content
KiX Supporter
*****

Registered: 2003-01-28
Posts: 4295
Loc: New Jersey
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
_________________________
Actually I am a Rocket Scientist! \:D

Top
#213610 - 2018-11-09 04:10 PM Re: Ho to use sqlite? [Re: Glenn Barnas]
Allen Administrator Online   shocked
KiX Supporter
*****

Registered: 2003-04-19
Posts: 4464
Loc: USA
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/

Top
#213611 - 2018-11-12 02:09 PM Re: Ho to use sqlite? [Re: Allen]
AndreLuiz Offline
Getting the hang of it

Registered: 2015-10-07
Posts: 74
Loc: Brasil, João pessoa
[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!

Top
#213612 - 2018-11-14 09:19 PM Re: Ho to use sqlite? [Re: AndreLuiz]
Lonkero Administrator Offline
KiX Master Guru
*****

Registered: 2001-06-05
Posts: 22337
Loc: OK
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
_________________________
!

download KiXnet

Top
#213624 - 2018-11-22 06:22 PM Re: Ho to use sqlite? [Re: Lonkero]
AndreLuiz Offline
Getting the hang of it

Registered: 2015-10-07
Posts: 74
Loc: Brasil, João pessoa
[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$

Top
#213625 - 2018-11-25 05:44 AM Re: Ho to use sqlite? [Re: AndreLuiz]
Allen Administrator Online   shocked
KiX Supporter
*****

Registered: 2003-04-19
Posts: 4464
Loc: USA
Please add
? @serror
right after the dbconnopen(...) and tell us the error.

Top
#213629 - 2018-11-28 06:11 PM Re: Ho to use sqlite? [Re: Allen]
Lonkero Administrator Offline
KiX Master Guru
*****

Registered: 2001-06-05
Posts: 22337
Loc: OK
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
_________________________
!

download KiXnet

Top
Page 1 of 1 1


Moderator:  Arend_, Allen, Jochen, Radimus, Glenn Barnas, ShaneEP, Mart 
Hop to:
Shout Box

Who's Online
1 registered (Allen) and 161 anonymous users online.
Newest Members
diefnet, Arogya, gkustra, emnipetro, Hirze
17644 Registered Users

Generated in 0.032 seconds in which 0.011 seconds were spent on a total of 13 queries. Zlib compression enabled.

Search the board with:
superb Board Search
or try with google:
Google
Web kixtart.org