Lookup window

Ouch!! Open Source ERP & Compiere beginners WILL have Teething Pains. This is where you rumbled thru like Rasputin, cry like a babe, and grin like a chimp! :D

Moderators: lofx, neilg, moyses, hema

Lookup window

Postby SergeyV » Tue Nov 15, 2005 5:47 am

Hi there,

I have a problems with new lookup window in 2.5.3a version... when i create new window, and try to implement it into Product window, with Reference - "Table Direct"... as result - new field in Product window is inactive. I try to "Sinchronize terminology" and "Update Role Access", but result it's not on.
Table was created directly in Oracle.
May be something changed in Table|Field|Window creating process?

Thanks in advance
------------------------------------------------
Sergey Vishniakov
Compiere.LV Team
SergeyV
 
Posts: 8
Joined: Tue Aug 31, 2004 6:26 pm
Location: Latvia

Postby SergeyV » Tue Nov 15, 2005 5:57 am

SQL was:

Code: Select all
CREATE TABLE UM_Jurisdiction(
UM_Jurisdiction_ID   NUMBER(10, 0)   NOT NULL,
AD_Client_ID      NUMBER(10, 0)   NOT NULL,
AD_Org_ID      NUMBER(10, 0)   NOT NULL,
IsActive      CHAR(1)      DEFAULT 'Y' NOT NULL      CHECK (IsActive in ('Y','N')),
Created         DATE      DEFAULT SYSDATE NOT NULL,
CreatedBy      NUMBER(10, 0)   NOT NULL,
Updated         DATE      DEFAULT SYSDATE NOT NULL,
UpdatedBy      NUMBER(10, 0)   NOT NULL,
Name         NVARCHAR2(50)   NOT NULL,
Description      NVARCHAR2(255),
Comments      NVARCHAR2(2000),
C_Country_ID      NUMBER(10, 0)   NOT NULL,
C_Region_ID      NUMBER(10, 0),
CONSTRAINT UM_Jurisdiction_Key PRIMARY KEY (UM_Jurisdiction_ID));

ALTER TABLE UM_Jurisdiction ADD (
CONSTRAINT ADClient_UMJurisdiction FOREIGN KEY (AD_Client_ID)
REFERENCES AD_Client (AD_Client_ID));

ALTER TABLE UM_Jurisdiction ADD (
CONSTRAINT ADOrg_UMJurisdiction FOREIGN KEY (AD_Org_ID)
REFERENCES AD_Org (AD_Org_ID));

ALTER TABLE UM_Jurisdiction ADD (
CONSTRAINT CCountry_UMJurisdiction FOREIGN KEY (C_Country_ID)
REFERENCES C_Country (C_Country_ID));

ALTER TABLE UM_Jurisdiction ADD (
CONSTRAINT CRegion_UMJurisdiction FOREIGN KEY (C_Region_ID)
REFERENCES C_Region (C_Region_ID));
   
CREATE INDEX UM_Jurisdiction_Name ON UM_Jurisdiction (Name);

ALTER TABLE COMPIERE.M_PRODUCT
   ADD UM_JURISDICTION_ID NUMBER(10);
ALTER TABLE COMPIERE.M_PRODUCT
   ADD (CONSTRAINT UMJURISDICTION_MPRODUCT FOREIGN KEY (UM_JURISDICTION_ID)
   REFERENCES UM_JURISDICTION (UM_JURISDICTION_ID));
Thanks in advance
------------------------------------------------
Sergey Vishniakov
Compiere.LV Team
SergeyV
 
Posts: 8
Joined: Tue Aug 31, 2004 6:26 pm
Location: Latvia

Postby SergeyV » Tue Nov 15, 2005 6:03 am

When I try to open Product Window, in console we have

Code: Select all
===========> MLookupFactory.getLookup_TableDir: No Identifier records found: UM_JURISDICTION_ID [12]
===========> MLookupFactory.getLookupInfo: No SQL - UM_JURISDICTION_ID [12]
===========> MField.loadLookup: (UM_JURISDICTION_ID) - No LookupInfo [12]


Please help me to escape from this problem :cry:
Thanks in advance
------------------------------------------------
Sergey Vishniakov
Compiere.LV Team
SergeyV
 
Posts: 8
Joined: Tue Aug 31, 2004 6:26 pm
Location: Latvia


Return to Growing Pains

Who is online

Users browsing this forum: No registered users and 2 guests

cron