Ticket Q558252

Visible to All Users

"Invalid value for field 'MY_EVENT_ID" problem during the migrating from VCL 13.1 to VCL 13.2

Francesco Faleschini

created 11 years ago

I use a form to insert and edit scheduler evnnts inherited by yours:
TfrmCustomEventEditor = class(TcxSchedulerCustomEventEditor)
After upgrading from VCL 13.1 to 13.2 i am able to build, anyway when using the application on the creation of a new scehduler event (=OK on the CustomEventEfitor form) i have the following error
"Invalid value for field 'MY_EVENT_ID"
where MY_EVENT_ID refers to TcxSchedulerDBStorage.FieldNames.ID
could you please suggest a solution?
Moreover it is not possible to open an old Event. i have Access Violation.
This occurs on

Delphi
function TcxSchedulerEvent.GetEventType: TcxEventType;  
begin  
  Result := GetValueDefault(FStorage.FEventTypeField, etNone);  
end;

Show previous comments (8)

DevExpress Support Team 11 years ago

Would you please provide us with a small sample project so we can precisely replicate your scenario on our side?
P.S.: Please check whether or not the breaking change from the [DCC Error] CustomSchedulerEditor.pas(129): E2137 Method 'ApplyChanges' not found in base class ticket is related to this problem.

Francesco Faleschini 11 years ago

Please find attached sample project, Try to create a new event, you will have error "Invalid value for field FIELD_NAME"

CalenderProblem.zip

DevExpress Support Team 11 years ago

Hello,
I am afraid that I was not able to run your demo because the TMSConnection and some other TMS~ classes do not present on my side. Would you please provide us with a sample project based on standard VCL database components? To provide necessary data, you can load it to ClientDataSets or TdxMemdata (use their "Assign Local Data…" option). This will allow us to review your sample on different machines without installing 3rd-party components.

Francesco Faleschini 11 years ago

Hello
Before attaching i made sure to use TdxMemdata, and still i see without any 3rd party components, just to reconfirm this time i uninstalled 3rd part components(Devart- tmsconnection etc) and rebuild without any problem. This time i am attaching with Dcu and EXE too.

CalenderProblem.zip

DevExpress Support Team 11 years ago

You attachment contains two projects - Memo and Project7. I assume that I should use Memo project to reproduce the problem, am I right? Would you please provide us with step-by-step instructions on how to reproduce the issue with your demo?

Francesco Faleschini 11 years ago

oh ok, Yes Memo is sample project.
Steps to reproduce as follows:

Run the application.
Right click select "Nuovo Memo"
Put Some detail and Press Ok button and you will get error 'Invalid value for field FIELD_NAME'

Francesco Faleschini 11 years ago

I modified the ticket to "urgent" since this is critical now.

Francesco Faleschini 11 years ago

I made a (almost useless) video that reproduces steps 1 - 2 - 3 described above: http://www.screencast.com/t/Yz8XMGnh (if it doesn't run hit F5 to refresh the browser and try again).

DevExpress Support Team 11 years ago

We are working on your request, but it can take us some time to examine it. We will get back to you once we have any results or need additional information. Thank you for your patience.

Francesco Faleschini 11 years ago

Thanks for informing me, I hope you can find a solution (either a fix or suggest a better impelmentation) in a short time.

Francesco Faleschini 11 years ago

I would appreciate a lot if you can give me a tentaive date for a solution. Thanks.

Answers approved by DevExpress Support

DevExpress Support Team

created 11 years ago (modified 11 years ago)

Hello,
I have examined your project and found the cause of the problem. The GUID_EVENTO field is of the integer type and cannot accept a GUID value. Thus, as a solution, you can either set the storTest.GenerateGUIDForID property to False or better set the storTest.FieldNames.ID property to RecID.

Show previous comments (12)

Francesco Faleschini 11 years ago

Thanks for the solution, I will try it. But why this is not ok ain 13.2 and was ok in 13.1?

DevExpress Support Team 11 years ago

This is the strangest thing. I have tried your demo with VCL 13.1.5 and it reports the same error. Anyway, setting the storTest.FieldNames.ID property to RecID is the most reliable approach to fix the problem.

Francesco Faleschini 11 years ago

Honestly I did not try my sample on 13.1.5, but my app works in 13.1.5 and not on 13.2.2, as i managed to repoduce the error on 13.2 i was satisfied. I decided that for now I will rollback to 13.1.5 and before upgrading to 13.2 or 14.1 I will make my own forms instead of inheriting from yours so i remove this dependancy. Thanks.

Francesco Faleschini 11 years ago

I am again attempting to solve this problem. It seems the problem is about generated GUID not being integer. This said i don't understand why GenerateGUIDForID was ok in 13.1 and gives datatype conflict in 13.2. Do you have any idea? If not I should go for " If the responsibility of generating the unique number should be implemented by the underlying DBMS or by the developer, then set the GenerateGUIDForID property " as you mention in GenerateGUIDForID help.

DevExpress Support Team 11 years ago

I am afraid that I have no idea why the GUID value worked correctly with integer field, but I am sure it was not correct. GUID values should be stored in TGuidField fields and integer values should be stored in TIntegerField fields. This is the most reliable approach.

Francesco Faleschini 11 years ago

Hi. I have 2 separate problems (after 13.1 ->13.2 upgrade): I cannot craete new events, I cannot open an event created with 13.1. I made a new sample to explore this second point, i attach a zip file containig 2 proejcts (one for 13.1 and one for 13.2). This video: http://www.screencast.com/t/AzEk4hNybr5g demonstrates the projects and shows how on 13.2 I get an access violation when trying to open (by double clicking on it) an event. I suspect a non documented breaking change has been introduced. i hope you can review my sample and my video and reply with useful information. Thanks.

DevExpress Support Team 11 years ago

Hello Francesco,
It seems that for some reason your sample archive was not attached (at least, I do not see it in your latest comment). Would you please provide us with the example you are referring to?

Francesco Faleschini 11 years ago

i am sorry. I made the tpyical mistake of forgetting the attachement. Now I attach it. Please refer to my previous comment.

Sample_13....d_13.2.zip

Francesco Faleschini 11 years ago

I hope you reply soon because I am stuck. Thank you.

DevExpress Support Team 11 years ago

Please pardon the delayed response. I have reproduced the problematic behavior, but have not found the cause of the problem yet. We may require additional time to examine the problem. We appreciate your patience.

Francesco Faleschini 11 years ago

Hello, very good you reproduced it, i will wait. Since 13.1 -> 13.2 is the first upgrade that does not work for me (even if the app compiles fine) i hope you can solve this. Moreover I have another problem with scheduler events that *could* be related to this same problem, if not i will post more sample, but before i wait for your comment or a fix if possible. Thanks.

DevExpress Support Team 11 years ago

I was able to reproduce the problem using a small sample project. So, I decided to create a separate report for this issue (AV when calling the scheduler's EditEventUsingDialog method for a non-recurring event if True is passed as the AForcePatternEditing method parameter) to avoid mixing multiple discussions here and forwarded it to our developers for research. I hope we will find a solution soon.

Francesco Faleschini 11 years ago

Thanks, you is it possible to know by when it will be fixed?

DevExpress Support Team 11 years ago

I am afraid that I do not have any ETA for now. Our developers will do their best to resolve the problem as soon as they can.

Francesco Faleschini 11 years ago

just to close this ticket i inform you that after a lot of attempts i managed to solve this problem (refer to my original post, non the latetest comments). by setting GenerateGUIDForID to False and then setting the ID using Event.SetCustomFieldValueByName. A long struggle but finally 13.1 -> 13.2 update completed. You can mark this as solved.

Created: December 20, 2013 3:47 PM

Modified: March 21, 2014 10:05 AM

Platform: VCL

Product: ExpressScheduler Suite

Build: 13.2.2

Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

"Invalid value for field 'MY_EVENT_ID" problem during the migrating from VCL 13.1 to VCL 13.2

Answers approved by DevExpress Support

Recently viewed tickets