topic Re: buffer table select warning in Application Development and Automation Discussions

buffer table select warning

Former Member — Mon, 10 Aug 2009 12:25:40 GMT

HI ,

i have table with single line buffer and when i do select with not all the key fields i get

warning in the code inspector .

i build index for the table with the field that i use for the selection but the warning remain .

there is something that i can do to ignore this warning ,in case i cant change the table

buffering settings ?

Regards

Joy

Re: buffer table select warning

Former Member — Mon, 10 Aug 2009 12:48:31 GMT

Hi Joy,

Can you summarize the warning?

Regards,

Aditya

Re: buffer table select warning

Former Member — Mon, 10 Aug 2009 12:51:37 GMT

the index that you have created may not be unique, ie, multiple entries may exist for that index, hence the warning remains.

If your functionality requires u not to use primary keys, i dont think u should worry abt the warning message...

Regards,

Bikash

Re: buffer table select warning

HermannGahm — Mon, 10 Aug 2009 13:08:22 GMT

Hi,

if your goal is to get rid of the warning, check the documentaion (blue information icon), there you will find how to surpress the warning with pseudo comments.

However, you should only surpress the warning if you are sure that there is no other chance of using the buffered table in the buffer.

Kind regards,

Hermann

Re: buffer table select warning

Former Member — Tue, 11 Aug 2009 09:31:12 GMT

what do youz want ???

The table is buffered (single record), and to use the buffer you must know all key fields.

You access bypassed the buffer, that is the message of the code inspector.

If your access is important, then you should not build a new index, but use the buffer, maybe a generic

buffering is an option.

Siegfried