Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 6 of 6 total
Thread column ID required
Tue, Sep 27 2016 3:31 PMPermanent Link

Ronald

Hi,

I always used a column with the name ID in my database tables, but today I sent some rowdata in JSON format that I "manually" constructed *without* the column ID. EWB responded with the error: column ID not found. When I added a column with the name ID the error disappeared.
Have I been missing something lately, is the column ID required now? I have read this in the manual though:

"Elevate Web Builder requires that any table that you wish to update, or any table containing
content stored in BLOB columns that you wish to load (such as images), must have a primary key
defined. Elevate Web Builder uses the primary key to uniquely identify each row."

Is it OK if I always add a column with the name ID?

Greetings,
Ronald
Tue, Sep 27 2016 3:36 PMPermanent Link

Walter Matte

Tactical Business Corporation

A column named ID is not a requirement.

I am guessing that if you look at your code you may be doing something with a column named ID and that generated the error.

Walter
Tue, Sep 27 2016 3:59 PMPermanent Link

Ronald

Walter Matte wrote:

<<A column named ID is not a requirement.

I am guessing that if you look at your code you may be doing something with a column named ID and that generated the error.>>

I looked everywhere but no column with the name ID, until I looked in the .wbf file.there still was a property with the name ID ( "DataColumn": "id"). Very strange the .wbf file does not seem to be updated correctly. I deleted my Grid completely and created a new one. Now it works fine.

Thanks,
Ronald
Wed, Sep 28 2016 4:24 AMPermanent Link

Ronald

Ronald wrote:

<<I looked everywhere but no column with the name ID, until I looked in the .wbf file.there still was a property with the name ID ( "DataColumn": "id"). Very strange the .wbf file does not seem to be updated correctly. I deleted my Grid completely and created a new one. Now it works fine.>>

This morning I noticed what seems te go wrong. I made the column ID in the TGrid invisible. In the ide this column is now invisible and only my .wbf file "knows about it" because in the ide I can not see any more which colums are not visible. Maybe an invisible columns in a TGrid should always be visible in the ide. However this is not very handy either.
Wed, Sep 28 2016 8:49 AMPermanent Link

Raul

Globestar Systems

Team Elevate Team Elevate

On 9/28/2016 4:24 AM, Ronald wrote:
> This morning I noticed what seems te go wrong. I made the column ID in the TGrid invisible. In the ide this column is now invisible and only my .wbf file "knows about it" because in the ide I can not see any more which colums are not visible. Maybe an invisible columns in a TGrid should always be visible in the ide. However this is not very handy either.

You will see all columns (hidden or not) in the Object Inspector still
in IDE

Raul

Wed, Sep 28 2016 10:00 AMPermanent Link

Ronald

Raul wrote:

<<You will see all columns (hidden or not) in the Object Inspector still in IDE>>

You are right, I think I am too much used to EWB1.
Image