topic Re: SQL error in the database when accessing a table in Application Development and Automation Discussions

SQL error in the database when accessing a table

Former Member — Fri, 18 Mar 2011 10:38:46 GMT

Hi All,

I have seen that there are threads already for this error. But my case seems different . So I am posting again. Please do provide your valuable inputs.

In my object, I have written a Modify statement on a <custom table> FROM TABLE <ITAB>.

But this results in a dump saying 'SQL error in the database when accessing a table'.

If I remove a value 11700500000.00 from a field of type CURR(Length 13 - Decimals 2) in the internal table used in the MODIFY Statement, we dont have the dump.

Why is this happening ? Please help!!

Thanks a lot!

Edited by: Dagny on Mar 18, 2011 11:39 AM

Re: SQL error in the database when accessing a table

Former Member — Fri, 18 Mar 2011 10:43:44 GMT

Check the data type of Quantity field in db table and internal table

Re: SQL error in the database when accessing a table

Former Member — Fri, 18 Mar 2011 11:07:05 GMT

HI Dagny,

This may be because you would have missed out the currency key field for the currency field. Try to modify the table along with the currency key.

Thanks and regards,

Sri Hari Anand Kumar

Re: SQL error in the database when accessing a table

Former Member — Fri, 18 Mar 2011 11:22:20 GMT

Hi Dagny,

The value is over flowing into the filed of data base, the length 13 includes the 2 decimal values aswell, if you need a bigger length for field u need to declare a 15, 2 decimals data type.

Srini

Re: SQL error in the database when accessing a table

Former Member — Fri, 18 Mar 2011 11:27:44 GMT

Hi Dagny,

Please change your data type as BKK_BAL. This data element is of type CURR 23. THis will not dump now.

Thanks,

Guru

Re: SQL error in the database when accessing a table

Former Member — Fri, 18 Mar 2011 11:34:07 GMT

Hi Folks,

I have already tried changing the data type to a bigger length. But still the DUMP continues to occur.

Also, please note that the question of the data-types not matching between the internal table and Database table does not occur as the internal table is declared as TYPE STANDARD TABLE OF <Database table>.

Please help!

Re: SQL error in the database when accessing a table

Former Member — Wed, 11 May 2011 17:28:32 GMT

closed

Re: SQL error in the database when accessing a table

Former Member — Wed, 11 May 2011 17:38:34 GMT

Per forum rules, would you please share the solution?

Rob