U++ forum: Welcome to the forum

Two tables sharing same field name? [message #26836]

Tue, 01 June 2010 19:28

jeremy_c
Messages: 175
Registered: August 2007
Location: Ohio, USA

Experienced Member

I have this simple schema:

TABLE_(MODES)
	STRING_ (NAME, 40) UNIQUE
END_TABLE

TABLE_(BANDS)
	STRING  (NAME, 8) UNIQUE
	DOUBLE_ (FREQ_BEGIN)
	DOUBLE_ (FREQ_END)
END_TABLE

This works fine. However, when I go to insert a name into the mode table that is 8 characters or more, I get an exception. i.e.

SQL & ::Insert(MODES) (NAME, "AMTORFEC");

If I change the above schema to define BANDS/NAME as 40, then the above statement works fine. Put the BANDS/NAME back to 8 and I get the exception. Never fails.

Am I doing something wrong or is this a bug?

Thanks,

Jeremy

[Updated on: Tue, 01 June 2010 19:30]

Report message to a moderator