Hi all...

can anybody guide me on this prob?

I've created a new company xx.

then I've created tables for the company.

the system said 2955 tables created. But one error msg come out : "Cannot find table definition ttfgld038".

does anybody know how to solve this prob?

thanks!

Dear Friend...

What kind of DB you are using ??!!

Any way to confirm that the table exists..

==Sequel: Go to Query Analyzer and type

Select top 1 * from ttfgld038.xx

==Oracle: Go to sqlplus and type
desc baan.ttfgld038xx

Where xx is your company number

--------------------------
If it is not exists try to make a table with the following types
T$SEAR = NCHAR(9)
T$DESC = NCHAR(30)
TREFCNTD = NUMBER
T$REFCNTU = NUMBER

all types do not accept nullable values

Regards..:D

hi Hossni...

My company database is using MySQL....and I'm not very familiar with database environment.

tq for ur support. that prob solved already.

I've checked the table in General Table Maintenance and the table doesnt exist.

so I've go to Common>Common Parameters>Initialize Parameters.

Then Create Table for Company 915 (TEST Company)

after completed, then check back the table at GTM. now the table has exist...

tq..

hi Hossni...

My company database is using MySQL....and I'm not very familiar with database environment.

tq for ur support. that prob solved already.

I've checked the table in General Table Maintenance and the table doesnt exist.

so I've go to Common>Common Parameters>Initialize Parameters.

Then Create Table for Company 915 (TEST Company)

after completed, then check back the table at GTM. now the table has exist...

tq..

Hi,

Any body help me,I create one table like"tdavn121" it wil create i run the CRDD it wil sucessfully run but i create new tabe it will showing error 0 table created.

I check in GTM it will showing "data defination ttdavn121 not present" plz help me.


Thanks
Susil

Hi,

If nothing is working, follow these steps.

1. Clear tables ttadv501, ttadv502, ttadv503
2. Go to table definition's and open table definition for table tdavn121
3. Change any one label of any one field or change a name of any one field(unless this table is not old)
4. Now run Convert to Run Time with full range of package combination and for that particular table. Check all check boxes, except domains (if there is any new domain created for this table, you can check this as well)
5. Log out and log back in.

You are done.

Also follow similar threads(Solutions):-

Thread 1 (http://www.baanboard.com/baanboard/archive/index.php/t-25383.html)

Thread 2 (http://www.baanboard.com/baanboard/archive/index.php/t-64579.html)

Hope it helps.

Check DD on disk ($BSE/dict/...). Do you have DD file for this table? Maybe is there only .new file present.

In Baan IV (depending on PS version) you had to create DD for domain first, leave application and then create DD for tables.