Stored Procedures don't appear in Dataset Wizard

belidzs · Post by **belidzs** » Sat 04 Dec 2010 15:54

Hi,

I've made several stored procedures to avoid storing definitions of views inside my code, but I'm not able to use them with dataset wizard, as they don't appear in the list of tables, views and functions. There is no problem with the permission, it's for sure. I'm using registered version 4.95.170

Any help is appreciated!

DDL for procedure:

Code: Select all

CREATE OR REPLACE FUNCTION projekt.projekt(kotesszam character varying DEFAULT '%'::character varying)
  RETURNS SETOF projekt.projekt AS
$BODY$
SELECT * from projekt.projekt where kotesszam LIKE $1;
$BODY$
  LANGUAGE 'sql' VOLATILE
  COST 100
  ROWS 1000;

DDL for the underlying table:

Code: Select all

CREATE TABLE projekt.projekt
(
-- Inherited from table projekt.projekt:  kotesszam character varying(10) NOT NULL,
-- Inherited from table projekt.projekt:  megnevezes character varying NOT NULL,
-- Inherited from table projekt.projekt:  telephely_id integer,
-- Inherited from table projekt.projekt:  statusz_id integer NOT NULL DEFAULT 1,
-- Inherited from table projekt.projekt:  uzletag_id character varying(4) NOT NULL,
-- Inherited from table projekt.projekt:  rendszer_id character varying(10) NOT NULL,
-- Inherited from table projekt.projekt:  szuloprojekt character varying(10),
-- Inherited from table projekt.projekt:  vezeto_pm character varying,
-- Inherited from table projekt.projekt:  kontaktszemely character varying,
-- Inherited from table projekt.projekt:  kontakttel character varying,
-- Inherited from table projekt.projekt:  kontaktmail character varying,
-- Inherited from table projekt.projekt:  szallitasicim character varying,
-- Inherited from table projekt.projekt:  devizanem character(3) NOT NULL DEFAULT 'HUF'::bpchar,
-- Inherited from table projekt.projekt:  dok_adt_muszaki_atveteli boolean NOT NULL DEFAULT false,
-- Inherited from table projekt.projekt:  dok_adt_szallitolevel boolean NOT NULL DEFAULT false,
-- Inherited from table projekt.projekt:  dok_adt_oktatasi_jegyzokonyv boolean NOT NULL DEFAULT false,
-- Inherited from table projekt.projekt:  dok_adt_vegmeresi_tesztlap boolean NOT NULL DEFAULT false,
-- Inherited from table projekt.projekt:  dok_adt_megvalosulasi_dokumentacio boolean NOT NULL DEFAULT false,
-- Inherited from table projekt.projekt:  dok_adt_alvallalkozoi_szerzodes boolean NOT NULL DEFAULT false,
-- Inherited from table projekt.projekt:  dok_tfis_kiviteli_terv boolean NOT NULL DEFAULT false,
-- Inherited from table projekt.projekt:  dok_tfis_letesitesi_engedely boolean NOT NULL DEFAULT false,
-- Inherited from table projekt.projekt:  dok_tfis_nyomasproba boolean NOT NULL DEFAULT false,
-- Inherited from table projekt.projekt:  dok_tfis_szivattyu_beuzemeles boolean NOT NULL DEFAULT false,
-- Inherited from table projekt.projekt:  dok_tfis_rendszer_teszt boolean NOT NULL DEFAULT false,
-- Inherited from table projekt.projekt:  dok_tfis_oktatasi_jegyzokonyv boolean NOT NULL DEFAULT false,
-- Inherited from table projekt.projekt:  dok_tfis_beuzemelesi_jegyzokonyv boolean NOT NULL DEFAULT false,
-- Inherited from table projekt.projekt:  dok_tfis_atadasi_jegyzokonyv_hatosagi boolean NOT NULL DEFAULT false,
-- Inherited from table projekt.projekt:  dok_tfis_atadasi_jegyzokonyv_megrendelo boolean NOT NULL DEFAULT false,
-- Inherited from table projekt.projekt:  dok_tfis_hasznalatbaveteli_engedely boolean NOT NULL DEFAULT false,
-- Inherited from table projekt.projekt:  dok_tfis_karbantartasi_adatlap boolean NOT NULL DEFAULT false,
-- Inherited from table projekt.projekt:  dok_tfis_projektzaro_lap boolean NOT NULL DEFAULT false,
-- Inherited from table projekt.projekt:  egysoros_szamla boolean NOT NULL DEFAULT false,
-- Inherited from table projekt.projekt:  bankgarancia boolean NOT NULL DEFAULT false,
-- Inherited from table projekt.projekt:  garancialis_visszatartas numeric(4,4) DEFAULT 0,
-- Inherited from table projekt.projekt:  joteljesitesi_visszatartas numeric(4,4) DEFAULT 0,
-- Inherited from table projekt.projekt:  tovabbszamlazott_szolg_dij numeric(4,4) DEFAULT 0,
-- Inherited from table projekt.projekt:  sales_koltseg_eszkoz numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  sales_koltseg_alvallalkozoimunka numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  sales_koltseg_anyag numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  sales_koltseg_pm numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  sales_koltseg_tervezes numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  sales_koltseg_berlet numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  sales_koltseg_egyeb numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  sales_bevetel_eszkoz numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  sales_bevetel_alvallalkozoimunka numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  sales_bevetel_anyag numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  sales_bevetel_pm numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  sales_bevetel_tervezes numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  sales_bevetel_berlet numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  sales_bevetel_egyeb numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  megjegyzes text,
-- Inherited from table projekt.projekt:  utolso_apollo_frissites timestamp without time zone,
-- Inherited from table projekt.projekt:  felvivo character varying NOT NULL DEFAULT "current_user"(),
-- Inherited from table projekt.projekt:  felvitel_idopont timestamp without time zone NOT NULL DEFAULT now(),
-- Inherited from table projekt.projekt:  elso_felvitel_idopont timestamp without time zone NOT NULL DEFAULT now(),
-- Inherited from table projekt.projekt:  elso_felvivo character varying NOT NULL DEFAULT "current_user"(),
-- Inherited from table projekt.projekt:  modosito character varying,
-- Inherited from table projekt.projekt:  modositas_idopont timestamp without time zone,
-- Inherited from table projekt.projekt:  ugyfel_nev character varying,
-- Inherited from table projekt.projekt:  ugyfel_cim character varying,
-- Inherited from table projekt.projekt:  telephely_nev character varying,
-- Inherited from table projekt.projekt:  telephely_cim character varying,
-- Inherited from table projekt.projekt:  pm_eredeti_koltseg_eszkoz numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  pm_eredeti_koltseg_alvallalkozoimunka numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  pm_eredeti_koltseg_anyag numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  pm_eredeti_koltseg_pm numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  pm_eredeti_koltseg_tervezes numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  pm_eredeti_koltseg_berlet numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  pm_eredeti_koltseg_egyeb numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  pm_aktualis_koltseg_eszkoz numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  pm_aktualis_koltseg_alvallalkozoimunka numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  pm_aktualis_koltseg_anyag numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  pm_aktualis_koltseg_pm numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  pm_aktualis_koltseg_tervezes numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  pm_aktualis_koltseg_berlet numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  pm_aktualis_koltseg_egyeb numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  apollo_koltseg_eszkoz numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  apollo_koltseg_alvallalkozoimunka numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  apollo_koltseg_anyag numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  apollo_koltseg_pm numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  apollo_koltseg_tervezes numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  apollo_koltseg_berlet numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  apollo_koltseg_egyeb numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  apollo_bevetel_eszkoz numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  apollo_bevetel_alvallalkozoimunka numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  apollo_bevetel_anyag numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  apollo_bevetel_pm numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  apollo_bevetel_tervezes numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  apollo_bevetel_berlet numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  apollo_bevetel_egyeb numeric(12,2) DEFAULT 0,
-- Inherited from table projekt.projekt:  pm_eredeti_koltseg_lezarva boolean NOT NULL DEFAULT false,
-- Inherited from table projekt.projekt:  afas boolean NOT NULL DEFAULT true,
-- Inherited from table projekt.projekt:  kozbeszerzeses boolean DEFAULT false,
  CONSTRAINT projekt_pkey PRIMARY KEY (kotesszam),
  CONSTRAINT projekt_fk_felhasznalo FOREIGN KEY (vezeto_pm)
      REFERENCES felhasznalo.felhasznalo (felhasznalo_id) MATCH SIMPLE
      ON UPDATE RESTRICT ON DELETE RESTRICT,
  CONSTRAINT projekt_fk_rendszer FOREIGN KEY (rendszer_id)
      REFERENCES projekt.rendszer (rendszer_id) MATCH SIMPLE
      ON UPDATE RESTRICT ON DELETE RESTRICT,
  CONSTRAINT projekt_fk_statusz FOREIGN KEY (statusz_id)
      REFERENCES projekt.statusz (statusz_id) MATCH SIMPLE
      ON UPDATE RESTRICT ON DELETE RESTRICT,
  CONSTRAINT projekt_fk_telephely FOREIGN KEY (telephely_id)
      REFERENCES ugyfel.telephely (telephely_id) MATCH SIMPLE
      ON UPDATE RESTRICT ON DELETE RESTRICT,
  CONSTRAINT projekt_fk_uzletag FOREIGN KEY (uzletag_id)
      REFERENCES projekt.uzletag (uzletag_id) MATCH SIMPLE
      ON UPDATE RESTRICT ON DELETE RESTRICT
)
INHERITS (projekt.projekt_sablon)
WITH (
  OIDS=TRUE
);

Shalex · Post by **Shalex** » Wed 08 Dec 2010 15:24

We cannot create your table and function because there are no definitions for some your database objects (projekt.projekt_sablon, felhasznalo.felhasznalo, projekt.rendszer, projekt.statusz, ugyfel.telephely, projekt.uzletag). But we have reproduced the issue with the latest version (5.00.58) of dotConnect for PostgreSQL when some functions from the specified schema is not visible in Devart DataSet Wizard. We will investigate the issue and notify you about the results as soon as possible.

belidzs · Post by **belidzs** » Wed 08 Dec 2010 19:08

Ok Shalex, so do you want me to copy the DDLs for the other tables or not necessary?
I hope you'll provide a fix for my version as well, because currently I'm no longer entitled for the newer versions.

thank you for your understanding!

Shalex · Post by **Shalex** » Fri 10 Dec 2010 12:42

The issue can be associated with the result set of your projekt.projekt function. Please send us a complete DDL of your database objects which are related to the projekt.projekt function so that we can reproduce the issue in our environment.

belidzs · Post by **belidzs** » Fri 10 Dec 2010 13:26

Shalex wrote:The issue can be associated with the result set of your projekt.projekt function. Please send us a complete DDL of your database objects which are related to the projekt.projekt function so that we can reproduce the issue in our environment.

I've sent all the DDLs required to reproduce the issue. I hope you'll fix my version as well, cause sales guys were already bombing me with emails requesting my licence number. I think I deserve a fix cause I helped to make your product better.

Shalex · Post by **Shalex** » Mon 13 Dec 2010 16:46

We have answered you by e-mail (cannot reproduce the issue with your database objects).

belidzs · Post by **belidzs** » Fri 17 Dec 2010 13:55

Shalex wrote:We have answered you by e-mail (cannot reproduce the issue with your database objects).

We have found the root cause. I hope it gets fixed in the next release.

Shalex · Post by **Shalex** » Thu 10 Feb 2011 14:18

New build of dotConnect for PostgreSQL 5.10.103 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/postgr ... nload.html (trial version) or from Registered Users' Area (for users with valid subscription only): http://secure.devart.com/ .
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=20226 .