Search found 263 matches

by Fr0sT
28.11.2017, 14:44
Forum: ZeosLib 7.2 Forum
Topic: ParamByName in Master/Detail
Replies: 2
Views: 528

Re: ParamByName in Master/Detail

In short, M-D relationship in Zeos is achieved by this:

Code: Select all

  object qDetail: TZQuery
    DataSource = dsMaster
    MasterFields = 'ID'
    LinkedFields = 'RecordID'
  end
Where 'ID' is a key field in Master and 'RecordID' is FK field of Detail
by Fr0sT
28.11.2017, 08:17
Forum: ZeosLib 7.1 stable Forum
Topic: Access violation when reopening form Zeoslib 7.1.4
Replies: 4
Views: 2313

Re: Access violation when reopening form Zeoslib 7.1.4

Try to use FastMM4 with FullDebugMode and ReportMemoryLeaksOnShutdown := True; it looks like memory corruption because of interface disposed too early
by Fr0sT
27.11.2017, 08:44
Forum: ZeosLib 7.1 stable Forum
Topic: Access violation when reopening form Zeoslib 7.1.4
Replies: 4
Views: 2313

Re: Access violation when reopening form Zeoslib 7.1.4

7.4.1 is quite outdated, you could try 7.2 or 7.3...
If an issue persists, set "Stop on Delphi exceptions" option and track where the AV happens
by Fr0sT
15.11.2017, 07:52
Forum: ZeosLib 7.2 Forum
Topic: How to identify primary key field(s)
Replies: 4
Views: 689

Re: How to identify primary key field(s)

TZPostgreSQLDatabaseMetadata.UncachedGetPrimaryKeys ?
by Fr0sT
10.11.2017, 08:32
Forum: ZeosLib 7.2 Forum
Topic: PostgreSQL - cannot insert multiple commands into a prepared statement
Replies: 10
Views: 6061

Re: PostgreSQL - cannot insert multiple commands into a prepared statement

Hello Jan,
anyway the source sits there, right? Locating the issue is 50% of solving it :)
by Fr0sT
09.11.2017, 08:43
Forum: ZeosLib 7.2 Forum
Topic: PostgreSQL - cannot insert multiple commands into a prepared statement
Replies: 10
Views: 6061

Re: PostgreSQL - cannot insert multiple commands into a prepared statement

I did no tests but maybe the source of the issue is that '\' is considered an escape char in TZPostgreSQLQuoteState.GetQuotedString? Maybe doubling the '\' could fix the problem?
by Fr0sT
31.10.2017, 16:32
Forum: ZeosLib 7.2 Forum
Topic: [Solved] Connection timeout?
Replies: 6
Views: 1976

Re: Connection timeout?

Hello ertank, actually the parameter is used ZDbcPostgreSql.pas function TZPostgreSQLConnection.BuildConnectStr: AnsiString; ... { Sets a connection timeout. } ConnectTimeout := StrToIntDef(Info.Values['timeout'], -1); if ConnectTimeout >= 0 then AddParamToResult('connect_timeout', ZFastCode.IntToSt...
by Fr0sT
31.10.2017, 10:01
Forum: ZeosLib 7.2 Forum
Topic: [Solved] Connection timeout?
Replies: 6
Views: 1976

Re: Connection timeout?

What DB driver do you use? Zeos provides generic interface but implementation is specific to driver. Generally Zeos calls some api_connect_to_server function and has no control over its timeout. You should check docs for your driver for an appropriate option. In general case, controlling connection ...
by Fr0sT
24.10.2017, 08:30
Forum: ZeosLib 7.2 Forum
Topic: 7.2 testers-thread
Replies: 514
Views: 120269

Re: 7.2-Beta testers-thread

Thanks, should be fixed in 4047
by Fr0sT
23.10.2017, 09:27
Forum: ZeosLib 7.2 Forum
Topic: libmysql.dll - to many subsequent errors
Replies: 4
Views: 677

Re: libmysql.dll - to many subsequent errors

WinXD, D7, MySQL server 5.5.23, Zeos 7.3 - not reproducible
I'd suggest to try 7.2 or 7.3 at first.
by Fr0sT
20.10.2017, 09:10
Forum: ZeosLib 7.2 Forum
Topic: 7.2 testers-thread
Replies: 514
Views: 120269

Re: 7.2-Beta testers-thread

Hi Michal,
damn that SVN... It requires new files to be manually added. Fixed in r4046
by Fr0sT
19.10.2017, 16:06
Forum: ZeosLib 7.2 Forum
Topic: Zeoslib 7.2.1-rc. Internal error C1118 on Delphi 7
Replies: 12
Views: 2480

Re: Zeoslib 7.2.1-rc. Internal error C1118 on Delphi 7

I also had internal error caused by range checking in test suite with D7.
by Fr0sT
19.10.2017, 16:04
Forum: ZeosLib 7.2 Forum
Topic: [Suggestion] group and declare as constants all supported values of Parameters
Replies: 12
Views: 1076

Re: [Suggestion] group and declare as constants all supported values of Parameters

Finally I did it in r4044!
All available properties, with descriptions, are listed - very good reference, I say :bash: 8)