Quickly create a temporary table of the same structure according to the existing table structure in VF

xiaoxiao2021-03-06  77

Assume the table JXC_JYZ (NYEAR N (4), NMONTH N (2), CXSBM C (20), NQCZC_SL N (12, 3), NBQXS_SL N (12, 3), NQMKC_SL N (12 , 3), CJZZT N (2)) If we want to create a structure the same temporary table TJXC_JYZ, the common method is: Create Cursor TJXC_JYZ (Nyear N (4), NMONTH N (2), cxsbm c (20), NQCZC_SL N (12, 3), NBQJH_SL N (12, 3), NBQXS_SL N (12, 3), NQMKC_SL N (12, 3), CJZZT N (2)) and this method requires a lot of content, including the table name, Fields and field properties, etc. For a more trouble-time table, you need to enter more content, and the premise is to know the specific structure of the original table. Obviously we will feel very cumbersome, have there any better way? Have! We can quickly create a temporary table as the original table structure: use JXC_JYZSELE JXC_JYZ = AFIELD (TDBF) && puts the original table's structure in a predetermined array TDBF Create Cursor TJXC_JYZ from Array TDBF && pass array TDBF Create a temporary table tjxc_jyz ** Temporary table creation completion Sele Tjxc_jyz && chooses the temporary table we created to browse Brow

转载请注明原文地址:https://www.9cbs.com/read-107391.html

New Post(0)