Search found 5 matches

by Pyh
20.12.2011, 09:11
Forum: PostgreSQL
Topic: Processing requests in asynchronous mode
Replies: 5
Views: 2358

The main advantage of this solution - the ability to cancel your request on the client side without having administrator rights. I have the need to viewing the data returned FDriver.GetResult (FHandle): PZPostgreSQLResult; Please tell me what the easiest way to convert PZPostgreSQLResult in TDataset...
by Pyh
06.05.2011, 09:59
Forum: PostgreSQL
Topic: Processing requests in asynchronous mode
Replies: 5
Views: 2358

Processing requests in asynchronous mode

Since not found an example using queries asynchronously, the only solution was to import the missing functions PQgetCancel, PQfreeCancel, PQcancel and use them in a stream. Patch was written for version 6.6.4, but 6.6.6 and 7.0 do not differ much. ZPlainPostgreSql7.pas, ZPlainPostgreSql8.pas: after ...
by Pyh
19.11.2010, 13:43
Forum: PostgreSQL
Topic: OID postgresql
Replies: 1
Views: 1866

ZEOSDBO-6.6.4-stable Delphi 7 something like this: TBaseZeosConnection = class( TObject) private FConnection: TZConnection; ... public ... function File_Send( const aFileName: string): integer; override; procedure File_Recive( const aID: integer; aFileName: string); override; procedure File_Delete( ...
by Pyh
12.12.2009, 20:40
Forum: PostgreSQL
Topic: I can not create a field of type ENUM in Delphi7
Replies: 5
Views: 1902

Though the real problem is much more difficult than an example (((
While has solved a problem another by - has created two tables:
BaseEnumTypes and BaseEnumValues.

With impatience I wait for support of types ENUM - since this type very convenient in use.

Thanks!
by Pyh
10.12.2009, 11:18
Forum: PostgreSQL
Topic: I can not create a field of type ENUM in Delphi7
Replies: 5
Views: 1902

I can not create a field of type ENUM in Delphi7

Hi all! Delphi 7, Zeos 6.6.4-stable, PostgreeSQL 8.4 Thanks for your project, he has very much helped me! At transition with MySQL on PostgreSQL has faced such problem: CREATE TYPE TTestType AS ENUM ('z', 'x', 'c'); CREATE TABLE TestTable ( ID integer PRIMARY KEY, t TTestType ); INSERT INTO TestTabl...