Hi,

Before creation of tables, I would like to validate some of the issues. Is there any way to create a virtual table and call this in the script.

Thanks

Kamesh,

Please fill your profile with BaaN/OS/Database Info.


Before creation of tables, I would like to validate some of the issues.

Please explain what do you like to validate?
Is there any way to create a virtual table and call this in the script.
You can use the tools function - db.create.table() (http://www.baanboard.com/programmers_manual_baanerp_help_functions_db_operations_db_create_table)

Hi Kamesh,

As NPRao says, there exist the db.create.table() and db.drop.table() functions - but there don't appear to be any corresponding functions for creating fields/indexes on those tables :mad:

I tend either to:
1. create permanent tables with numbers between 980 and 990;
2. use an array within my script, and use the qss.* functions for sorting / searching the array.

HTH

Would it work to use table boosters? I know you can do an "insert" on your booster table before doing the actual writing to the DB ....