Search found 16 matches

by Khaoz
22.05.2009, 03:08
Forum: PostgreSQL
Topic: Working with PostgreSQL in LAN
Replies: 23
Views: 7496

And DONE!!!!! The problem IS with the Microsoft Visual C++ 2005 Redistributable Package (x86) but you the need the one with SP1. The correct package is: Microsoft Visual C++ 2005 SP1 Redistributable Package (x86) Downloaded at: http://www.microsoft.com/downloads/details.aspx?FamilyID=200b2fd9-ae1a-4...
by Khaoz
22.05.2009, 02:30
Forum: PostgreSQL
Topic: Working with PostgreSQL in LAN
Replies: 23
Views: 7496

Using postgresql one click installer, my app started to work. So, to test if was the installation or what, i removed the postgresql and... my app still does work. Seems to be something with Visual C++ 2005 Redistributable. After removed this, my app stoped. But i have tried to re-install vc 2005 man...
by Khaoz
22.05.2009, 01:36
Forum: PostgreSQL
Topic: Working with PostgreSQL in LAN
Replies: 23
Views: 7496

Errr... sry. LoadLibrary does not work. I was just calling LoadLibrary, but i need to assign the result to a handle and check if it is different of zero.

/me are owned by a windows xp.

Let's as to the client to use vista. :/
by Khaoz
16.05.2009, 20:30
Forum: PostgreSQL
Topic: Working with PostgreSQL in LAN
Replies: 23
Views: 7496

LoadLibrary works just fine.
I have created a simple application with a button with just loadlibrary and everything was a success.
So i have tried to use loadlibrary in my data module OnCreate but, after load libpq.dll connect does raise the same exception.
by Khaoz
30.04.2009, 01:03
Forum: PostgreSQL
Topic: Working with PostgreSQL in LAN
Replies: 23
Views: 7496

O... just to add 2 more complications: 1) My client has another pc with vista and my app works fine. If i plug my notebook (also with vista) my application works fine. 2) Here at home, i have a windows xp which my wife uses and she is working on my app with my notebook as server while i'm writing th...
by Khaoz
30.04.2009, 00:44
Forum: PostgreSQL
Topic: Working with PostgreSQL in LAN
Replies: 23
Views: 7496

Client dll dependencies have been slightly changed recently, not sure in what version (probably it was 8.3.1), but 8.3.6, I beleive, have same dll dependecies as 8.3.7. Here it is: comerr32.dll gssapi32.dll k5sprt32.dll krb5_32.dll libeay32.dll libiconv-2.dll libintl-8.dll libpq.dll msvcr71.dll ssl...
by Khaoz
24.04.2009, 01:19
Forum: PostgreSQL
Topic: Working with PostgreSQL in LAN
Replies: 23
Views: 7496

8.3.6

i will install sp3 because my wife use windows xp with sp3 and everything works fins.
by Khaoz
23.04.2009, 19:37
Forum: PostgreSQL
Topic: Working with PostgreSQL in LAN
Replies: 23
Views: 7496

Hey guys. I'm trying to deploy my application. I'm using a installer which i create with innosetup and every dll listed here is placed in c:\windows\system32 but my app does no work asking for libpq81.dll or libpq.dll (i'm using libpq.dll). I have tried to put in windows\system and in my app dir wit...
by Khaoz
21.04.2009, 23:31
Forum: 6.6 - stable
Topic: Problems with relations
Replies: 2
Views: 522

Seems a problem with how i setup my master/detail relation. How to do the right master/details relation setup with zeos ? 1) using the datasource property in detail query 2) using the mastersource and masterfields properties in detail query 3) using the mastersource, masterfields, linkedfields prope...
by Khaoz
21.04.2009, 22:02
Forum: 6.6 - stable
Topic: Problems with relations
Replies: 2
Views: 522

Here my contas, despesas and detalhamento_despesas schema: CREATE TABLE public.contas ( id INTEGER NOT NULL DEFAULT nextval('public.contas_id_seq'), funcionario_id INTEGER NOT NULL, veiculo_id INTEGER NOT NULL, centro_resultado_id INTEGER NOT NULL, tipo_conta VARCHAR(20) NOT NULL, data DATE NOT NULL...
by Khaoz
21.04.2009, 21:42
Forum: 6.6 - stable
Topic: Problems with relations
Replies: 2
Views: 522

Problems with relations

I have the following schema: contas id data tipo_conta despesas despesas_conta_id // unique filed in this table itens_despesas despesa_id custo valor My despesas dataset points to contas (one-to-one) with master field set to id My itens_despesas points to despesas (one-to-many) with master field set...
by Khaoz
21.04.2009, 19:55
Forum: 6.6 - stable
Topic: Input parameter count is less then expected
Replies: 8
Views: 1419

Khaoz , Is the code in your for loop effectively executed? And are the assignments effectively done? (checked by setting debug point) It's always my first shot, but everything seems to be ok. If you want me to check, please attach a 'ready to compile' test project with a table reation/data fill scr...
by Khaoz
20.04.2009, 22:59
Forum: 6.6 - stable
Topic: Input parameter count is less then expected
Replies: 8
Views: 1419

I will post the full code which is used in my application: Database.pas procedure TDatabase.ExecCommand(const Sql: string; Params: array of String; Values: array of Variant); var qry: TZQuery; i: integer; Param: TParam; begin qry := TZQuery.Create(nil); qry.Connection := fConnection; try qry.Close; ...
by Khaoz
20.04.2009, 16:23
Forum: 6.6 - stable
Topic: Input parameter count is less then expected
Replies: 8
Views: 1419

Seems a problem in ZDbcPostgresqlStatement.pas function: function TZPostgreSQLPreparedStatement.PrepareSQLParam(ParamIndex: Integer): string; line 339: if InParamCount <= ParamIndex then raise EZSQLException.Create(SInvalidInputParameterCount); InParamCount is equals to ParamIndex. I don't know if i...
by Khaoz
20.04.2009, 16:04
Forum: 6.6 - stable
Topic: Input parameter count is less then expected
Replies: 8
Views: 1419

Input parameter count is less then expected

I'm using the following code to inser some data using execSQL from a query: INSERT INTO avisos_troca_oleo(veiculos_id,proxima_troca) VALUES(:veiculos_id,:proxima_troca) My table structure (postgresql) is: id - not null - autoinc veiculos_id - not null proxima_troca - not null data_troca - allows nul...