Oracle user table is not working

This public forum is for user-to-user discussions of ASP.NET Maker. Note that this is not support forum.
Post Reply
muttou
User
Posts: 124

Oracle user table is not working

Post by muttou »

Hi, just download the latest version of .asp.net maker and established the connection successfully with oracle 19-c. code generated successfully and deployed successfully. only issue is to map the user table for advance security setup where asp.net maker does not support. show the tables but data/columns are not appearing. I have tried with SAME fields types is in your demo project file but all in vane.

need your help in this case in order to go for the purchase and need successful implementation and rollout in organization. thank you for your cooperation and support in this regards.
moreover, i have been using phpmaker since 2010 and hands on in that tool. need your kind urgent attention . thank you


MichaelG
User
Posts: 1095

Post by MichaelG »

You can post the table schema (CREATE TABLE statement) so others can try to test.


muttou
User
Posts: 124

Post by muttou »

Please find below the schema for employee table .. its same table as in maker used for advance security purpose. thank you for your support and rectification of this issue that leads to further decision for the procurement of this product. Our oracle version is 19c.

CREATE TABLE "emp" (
"E_ID" NUMBER VISIBLE NOT NULL,
"Name" VARCHAR2(255 BYTE) VISIBLE,
"LastName" VARCHAR2(20 BYTE) VISIBLE,
"FirstName" VARCHAR2(10 BYTE) VISIBLE,
"Title" VARCHAR2(30 BYTE) VISIBLE,
"TitleOfCourtesy" VARCHAR2(25 BYTE) VISIBLE,
"BirthDate" DATE VISIBLE,
"HireDate" DATE VISIBLE,
"Address" VARCHAR2(60 BYTE) VISIBLE,
"City" VARCHAR2(15 BYTE) VISIBLE,
"Region" VARCHAR2(15 BYTE) VISIBLE,
"PostalCode" VARCHAR2(10 BYTE) VISIBLE,
"Country" VARCHAR2(15 BYTE) VISIBLE,
"HomePhone" VARCHAR2(24 BYTE) VISIBLE,
"Extension" VARCHAR2(4 BYTE) VISIBLE,
"Email" VARCHAR2(30 BYTE) VISIBLE,
"Photo" VARCHAR2(255 BYTE) VISIBLE,
"ReportsTo" NUMBER(11,0) VISIBLE,
"UserLevel" NUMBER(11,0) VISIBLE,
"Username" VARCHAR2(20 BYTE) VISIBLE NOT NULL,
"Activated" CHAR(1 BYTE) VISIBLE NOT NULL,
"Profile" VARCHAR2(1000 BYTE) VISIBLE,
"Notes" VARCHAR2(1000 BYTE) VISIBLE,
"Password" VARCHAR2(255 BYTE) VISIBLE
)


-- Primary Key structure for table emp


ALTER TABLE "emp" ADD CONSTRAINT "SYS_C00802052" PRIMARY KEY ("E_ID");


-- Checks structure for table emp


ALTER TABLE "emp" ADD CONSTRAINT "SYS_C00802051" CHECK ("E_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "emp" ADD CONSTRAINT "SYS_C00802054" CHECK ("Username" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "emp" ADD CONSTRAINT "SYS_C00802055" CHECK ("Activated" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;


muttou
User
Posts: 124

Post by muttou »

Found the solution. fields types was wrongly design. make it fix and then table appear in maker designer.

01 more thing that need to know that is paid version will be for the latest release and can upgrade to the new version without spending extra cost. thank you for the update.


Webmaster
User
Posts: 9425

Post by Webmaster »


Post Reply