Creating fields and tables by code

karstenrobert

Hi,
I can use the fields table to create new fields and even new tables.
That works quiete well.
(I wouldn't want to create a few hundred fields manually for this migration)

But is it possible to set field properties by code as well?

Ideally I would export fields with their properties from database A and import them with these properties for migration purposes into database B.

As I found no way to set properties while creating fields via the fields table I have to manually created Option Fields as I can't set the Option Strings.

Hope someone knows an answer.

company

Hi,

I have tried to create the table by code (not manually) but i got an error message ' Tabledata **** doesnot exist'..

can you please tel me the process how to create the table by code.

thanks in advance.

tinoruijs

I guess you mean a temporary table?

Take a look at the following post: http://www.mibuso.com/forum/viewtopic.php?t=11782

Or http://www.mibuso.com/forum/viewtopic.php?t=24537 and read the reply of jlandeen.[/url]

kine

You can try to use C/Front (if you have a appropriate granule for that) and call it within NAV to be able to create new table with fields within NAV. C/Front has functions for that...

karstenrobert

Hi,

If I get that right. It is possible to create fields(with properties like "option string") and tables by using C/Front?

FranVLC

company wrote:

Hi,

I have tried to create the table by code (not manually) but i got an error message ' Tabledata **** doesnot exist'..

can you please tel me the process how to create the table by code.

thanks in advance.

I'm trying to do that, too! Any help? ](*,)

kine

just look into the C/Front demo application (file sample.c). There is function verifyCreateTable.

FranVLC

kine wrote:

just look into the C/Front demo application (file sample.c). There is function verifyCreateTable.

Thanks, i'll see that function.