DB structure for subform

 
1
0
-1

Dear Expert,

I have a form which contain sub form for read only. However when I save that form the field inside the subform will be created in the database. 

How can we attached the subform without creating any db fields ?

Best Regards

Tony Chu

    CommentAdd your comment...

    2 answers

    1.  
      2
      1
      0

      Dear Matthew,

      After more investigation, the unwanted field actually is created by JDBC Load Binder for a grid and not subform. 

      I have this SQL in JDBC Load binder:

      Select id, c_partCode, c_description from app_fd_testTable;

      and the form table will create the following extra fields

      c_c_partCode, c_c_description.

      Best Regards

      Tony Chu

      1. Eric

        very interesting - I have run into this problem myself before but I couldn't find out where it comes from or how to reproduce it. I assumed my SQL script was faulty....

      CommentAdd your comment...
    2.  
      1
      0
      -1

      Hi Tony Chu

      Is the field/table_column which you don't want created in DB table, already exist in another table? If yes, make that subform to point to your DB table with the existing table_column, then no new table_column will be created.

        CommentAdd your comment...