Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » Elevate Web Builder Technical Support » Support Forums » Elevate Web Builder General » View Thread |
Messages 1 to 6 of 6 total |
column ID required |
Tue, Sep 27 2016 3:31 PM | Permanent 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 PM | Permanent 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 PM | Permanent 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 AM | Permanent 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 AM | Permanent Link |
Raul 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 AM | Permanent 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. |
This web page was last updated on Friday, March 29, 2024 at 03:30 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |