SQL translation

Hi Ben

I can read the words but it’s the intended meaning  that needs translating – I don’t SQL and have no idea what a sql

profiler is -  I was testing a rollover. does appeal_no  relate to the Appeal field in rollover manager? In which case I

would expect it to be null because “leave blank” is one of the options in the Appeal field and in the Source field, and

that’s what I intended.

I am not familiar with t_promotion I thought it might be a system table I could add to my user group  so that I could

at least see it but that doesn’t seem to be an option.

Darrell Jones

Assistant Box Office Coordinator

Tasmanian Symphony Orchestra

GPO Box 1450

HOBART

Tasmania 7001

(03) 6232 4404

Hi Darrell,

Good day.

it means you tried to insert a null value into t_promotion table. because in t_promotion table, field appeal_no is a  (int not null) field, then you got this error message.

if you open a sql profiler try to catch the sql statement, then you can see what had happened.

have fun

Ben

Hello all,

I'm attempting to TEST a rollover and get this error message.  Can some translated it for me please?

Select Error: SQLSTATE = 2300

Microsoft OLE DB Provider for SQL Server

Cannot insert the value NULL into column 'appeal_no',table 'impresario.dbo.T_PROMOTION';column does not allow nulls.INSERT fails.

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Hi Ben

I can read the words but it’s the intended meaning  that needs translating – I don’t SQL and have no idea what a sql

profiler is -  I was testing a rollover. does appeal_no  relate to the Appeal field in rollover manager? In which case I

would expect it to be null because “leave blank” is one of the options in the Appeal field and in the Source field, and

that’s what I intended.

I am not familiar with t_promotion I thought it might be a system table I could add to my user group  so that I could

at least see it but that doesn’t seem to be an option.

Darrell Jones

Assistant Box Office Coordinator

Tasmanian Symphony Orchestra

GPO Box 1450

HOBART

Tasmania 7001

(03) 6232 4404

Hi Darrell,

Good day.

it means you tried to insert a null value into t_promotion table. because in t_promotion table, field appeal_no is a  (int not null) field, then you got this error message.

if you open a sql profiler try to catch the sql statement, then you can see what had happened.

have fun

Ben

Hello all,

I'm attempting to TEST a rollover and get this error message.  Can some translated it for me please?

Select Error: SQLSTATE = 2300

Microsoft OLE DB Provider for SQL Server

Cannot insert the value NULL into column 'appeal_no',table 'impresario.dbo.T_PROMOTION';column does not allow nulls.INSERT fails.

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!