Search found 10 matches

by konsul41
04.08.2017, 10:08
Forum: ZeosLib 7.2 Forum
Topic: Query Error
Replies: 6
Views: 702

Re: Query Error

The attachment is a project First, create a database from the specified SQL code. The CONTRIB (linux) plugin must be installed. and CREATE EXTENSION IF NOT EXISTS tablefunc Must be running from superuser level to.rar The problem lies probably in my SQL because this code already works Query.SQL.Clear...
by konsul41
03.08.2017, 11:58
Forum: ZeosLib 7.2 Forum
Topic: Query Error
Replies: 6
Views: 702

Re: Query Error

The whole base does not matter Underneath sql CREATE TABLE planamortyzacji ( id integer NOT NULL, id_srodektrwaly integer, lp integer, rok character varying(4), miesiac character varying(2), wartoscpoczatkowa numeric(11,2), wartoscumozenia numeric(11,2), podliczamor numeric(11,2), rocznyodpis numeri...
by konsul41
01.08.2017, 07:32
Forum: ZeosLib 7.2 Forum
Topic: Query Error
Replies: 6
Views: 702

Query Error

I have sql CREATE OR REPLACE FUNCTION dajmiesieczneodpisyzarok( IN rok character varying, IN id_srodektrwaly integer) RETURNS TABLE(id_srodektrwaly numeric, styczen numeric, luty numeric, marzec numeric, kwiecien numeric, maj numeric, czerwiec numeric, lipiec numeric, sierpien numeric, wrzesien nume...
by konsul41
13.12.2013, 13:46
Forum: ZeosLib 7.2 Forum
Topic: EXE -> dll
Replies: 8
Views: 1910

Re: EXE -> dll

It can enter the connection identifier IZPostgreSQLConnection = interface (IZConnection) ['{8E62EA93-5A49-4F20-928A-0EA44ABCE5DB}'] ... function GetConnectionHandle: PZPostgreSQLConnect; and it was possible to have a seperate from DB layer exe dll and operates on the same connection identifier. SetC...
by konsul41
13.12.2013, 13:12
Forum: ZeosLib 7.0 Stable Forum
Topic: simple way to share my EXE database connectio 2 DLL
Replies: 5
Views: 3643

Re: simple way to share my EXE database connectio 2 DLL

It can enter the connection identifier IZPostgreSQLConnection = interface (IZConnection) ['{8E62EA93-5A49-4F20-928A-0EA44ABCE5DB}'] ... function GetConnectionHandle: PZPostgreSQLConnect; and it was possible to have a seperate from DB layer exe dll and operates on the same connection identifier. SetC...
by konsul41
13.12.2013, 11:18
Forum: ZeosLib 7.2 Forum
Topic: EXE -> dll
Replies: 8
Views: 1910

Re: EXE -> dll

I added TZAbstractConnection = class(TComponent) ... property DbcConnection: IZConnection read FConnection write FConnection; code exe: function GetIZConnection():IZConnection;stdcall; begin result:=ksiegi.ZConnection1.DbcConnection; end; exports ...GetIZConnection; end. code dll: function ... Conn ...
by konsul41
13.12.2013, 08:35
Forum: ZeosLib 7.2 Forum
Topic: EXE -> dll
Replies: 8
Views: 1910

Re: EXE -> dll

Most simply had to go on a String -> WideString it is safe to use interfaces and TStream -> IStream. Wim that a lot of work, especially testing, but I think it would be worthwhile, and the normal user does not know the difference. Alternatively, you can make a method which would enter IZConnection t...
by konsul41
12.12.2013, 08:34
Forum: ZeosLib 7.2 Forum
Topic: EXE -> dll
Replies: 8
Views: 1910

Re: EXE -> dll

The problem is
property DbcConnection: IZConnection read FConnection;
the dll is not
write FConnection;
by konsul41
12.12.2013, 08:12
Forum: ZeosLib 7.2 Forum
Topic: EXE -> dll
Replies: 8
Views: 1910

Re: EXE -> dll

It's about crossing barriers Exe-dll (not BPL) for objects. Objects can not be moved from exe to dll and vice versa, only simple types. The idea is to get some exe interface that represents TZConnection (replacement) and dll and create TZQuery him to enter the call and continue to use TZQuery as if ...
by konsul41
11.12.2013, 09:19
Forum: ZeosLib 7.2 Forum
Topic: EXE -> dll
Replies: 8
Views: 1910

EXE -> dll

Sorry for my english - GoogleTranslator Do you plan to move the barrier EXE-DLL It's a case of: connect the EXE and DLLs provide the interface to the dll and then use that interface. In short, it was that of the substitution As for the exchange TZAbstractConnection = class(TComponent) on TZAbstractC...