Search found 16 matches
- 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...
- 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...
- 22.05.2009, 01:36
- Forum: PostgreSQL
- Topic: Working with PostgreSQL in LAN
- Replies: 23
- Views: 7496
- 16.05.2009, 20:30
- Forum: PostgreSQL
- Topic: Working with PostgreSQL in LAN
- Replies: 23
- Views: 7496
- 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...
- 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...
- 24.04.2009, 01:19
- Forum: PostgreSQL
- Topic: Working with PostgreSQL in LAN
- Replies: 23
- Views: 7496
- 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...
- 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...
- 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...
- 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...
- 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...
- 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; ...
- 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...
- 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...