#1  
Old 20th November 2020, 07:10 PM
johnnix johnnix is offline
Junior Member
 
Join Date: Nov 2020
Posts: 4
Default Update table structure

Hello,

I begun adding Nexus DB on my app, firstly I created the tables I need using the Enterprise Manager and then created the source code using the Code Generator. When my app starts it will check if the tables exist otherwise it will create them using the code.

In the near future I may need to add a new field on a table or create a new index etc what is the best practice to do so? I am totally new at this so need some guidance from more experienced users

Thank you all for your time!
  #2  
Old 20th November 2020, 11:42 PM
Eivind Bakkestuen
 
Posts: n/a
Default Re: Update table structure

> I begun adding Nexus DB on my app, firstly I created the tables I need
> using the Enterprise Manager and then created the source code using
> the Code Generator. When my app starts it will check if the tables
> exist otherwise it will create them using the code.
>
> In the near future I may need to add a new field on a table or create
> a new index etc what is the best practice to do so? I am totally new
> at this so need some guidance from more experienced users


In the Source Code Generator, tick the box for "Generate database
evolution code", make sure you generate the code for the latest
database version and compile that into your program, and call the
evolution method that's created for you in the source code unit.

Note that straight field additions or deletions should be handled
automatically, but field renaming is not handled automatically
currently.

--

Eivind [NX]
  #3  
Old 21st November 2020, 03:50 AM
johnnix johnnix is offline
Junior Member
 
Join Date: Nov 2020
Posts: 4
Default

Thank you so much for the prompt reply!


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Table structure & data update IK nexusdb.public.support 12 26th March 2009 10:14 AM
Print table structure Mervin Pearce [SACS] nexusdb.public.support 2 17th January 2006 05:26 AM
Get table structure in SQL Alexander Telegin nexusdb.public.support.sql 3 20th December 2005 01:39 PM
Print Table Structure Malcolm Cheyne nexusdb.public.discussions 17 1st April 2005 12:05 AM
NexsusDB Table Structure. M. Said nexusdb.public.support 3 18th December 2003 09:28 AM


All times are GMT +11. The time now is 05:40 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.