www.hkvforums.com

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

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

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;

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.

Please read:
https://aspnetmaker.dev/upgrade.php