Creating Tables at runtime

abhinav

is it possible to create a table when a form is opened, used while the form is used n is destroyed with the termination of the form.

DenSter

No

Savatage

You're usually not so vague with your answers

kine

You cannot "create" table. You can use some temporary table as source for your form, but the structure must be known in design-time of the form.

kriki

[Topic moved from Navision Tips & Tricks forum to Navision forum]

kriki

What exactly is it you want to do.
If you give us more info, we can direct you into the best direction to solve your problem.

garak

creating an table during code it's not possible (ok using C/Front, but it's not that what you want). But when you need an table temporary to store some kind of datas, use an temp table. For this, create your own "buffer" table, with an PK and some fields with differnt datatypes (decima, integer, code, text ...). This table you can use as temporary store and than work on it.

Igor_Beeone

Hello,
if You still (don't know the reason) need to create Navision REAL table at runtime you may use C/FRONT and it's methods createtable/deletetable.
Take in mind that for deleting table you will need to delete all records from it first. Another thing take in mind that license must support table creation/deletion, user must be allowed to create/delete it and table numbers range must be licensed
For more information read CFRONT manual and sample.c C language sample program.

But I think in your case you might create table at designer and use it as temporary. Hope it helps:)
Br,
Igor Beeone