Search found 12 matches

by jose fermin
06.02.2008, 21:24
Forum: PostgreSQL
Topic: pictures & postgresql
Replies: 6
Views: 1960

pictures & postgresql

How friends!! I have the follow problem: I created a table using postgresql CREATE TABLE prueba ( id serial NOT NULL, picture bytea, PRIMARY KEY (id) ) ; and I have a picture in c:\pictures\mypicture.jpg insert into prueba(picture) values('c/pictures/mypicture.jpg'); But, I can't show the pictures i...
by jose fermin
18.11.2007, 19:33
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Does ZeosDBO work with ClientDatasets
Replies: 16
Views: 4006

how are you doing mdaems??

Please can you explain how I can to make step by step the master/detail relationship using clientdatasets and zquerys??

Can I use aggregate fields and calculated fields??

I'm using Postgresql 8.2.4, Delphi 7 and windows xp.

thanks !!
by jose fermin
29.08.2007, 19:14
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: backup/restore in postgresql
Replies: 0
Views: 736

backup/restore in postgresql

somebody has been able to make a file of backup/restore of a data base postgresql with delphi 7 + zeos components??
by jose fermin
21.04.2007, 18:11
Forum: PostgreSQL
Topic: PostgreSQL 8.2.3 + ZStoredProc Error
Replies: 4
Views: 2487

Hola Diego!!

Soy dominicano y quisiera saber si resolviste el problema d los procedimientos almacenados hechos en postgresql y usados mediante un zstoreproc. A mi me da el mismo problema q a ti.

Ojala podamos resolver ese problema!!
by jose fermin
20.04.2007, 19:49
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: ZStroreProc
Replies: 1
Views: 744

ZStroreProc

Hello everybody!! I have a problem using zstoreproc and postgresql. I made the following store procedure in PostgreSQL 8.2.3 CREATE OR REPLACE FUNCTION facturacion.sp_existencias(IN codigo integer, OUT valor numeric) AS $BODY$ SELECT existencia_articulo FROM articulo WHERE codigo_articulo = $1; $BOD...
by jose fermin
29.03.2007, 22:29
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Troubles with datasetfield and Zeoslib
Replies: 12
Views: 6065

I hope in the future zeos components has its own datasetproviders and clientdatasets.

Go ahead guys!!
by jose fermin
29.03.2007, 13:37
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Trouble while installing ZEOSDBO 6.6.1 beta on Delphi 2007
Replies: 18
Views: 4692

I think is this order:

* ZCore.bpl
* ZParseSql.bpl
* ZPlain.bpl
* ZDbc.bpl
* ZComponent.bpl
ZComponentDesign and install this

and that's all !!
by jose fermin
28.03.2007, 20:58
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Troubles with datasetfield and Zeoslib
Replies: 12
Views: 6065

Troubles with datasetfield and Zeoslib

This is part of my project
by jose fermin
28.03.2007, 20:28
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Troubles with datasetfield and Zeoslib
Replies: 12
Views: 6065

I did the same to you, but show a error ClientDataSet1: cannot perform this operation on a closed dataset
by jose fermin
28.03.2007, 16:10
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Troubles with datasetfield and Zeoslib
Replies: 12
Views: 6065

Hi ogecrom, let me tell you that it not work. I'm using delphi 7, postgresql 8.2.1 and zeos 6.6.1. one question, what is the property poUseQuotechar?? When I opened your project it show a error "unknown property in datasetprovider options". These are my tables: CREATE TABLE facturacion.art...
by jose fermin
27.03.2007, 15:12
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Troubles with datasetfield and Zeoslib
Replies: 12
Views: 6065

Somebody solved the problem??

I am using the new zeos components (6.6.1) and I set the dataset provider poFetchDetailsOnDemand to true, but nothing happens.

Somebody help me please!!