Guest Posted March 15, 2011 Share Posted March 15, 2011 Message from: "Andrew Tierney" Hi, If you are inserting a new record and enter a '.' in the time field. It raises and error and terminates the Insert operation. See attached screenshots. Pic1 - Before Time is entered Pic2 - When you enter 3.45 and hit TAB. (Also happens when you type any other invalid entry into the field) Error is display, and all fields are blanked as the databound/insert appears to be cancelled. It doesn't cancel an EDIT, only the INSERT. Regards Andrew Quote Link to comment Share on other sites More sharing options...
Guest Posted March 15, 2011 Author Share Posted March 15, 2011 Message from: "Farshad Mohajeri" "Andrew Tierney" wrote in message news:f4VQnWq4LHA.3560@anaxagvs227... > Hi, > > If you are inserting a new record and enter a '.' in the time field. > > It raises and error and terminates the Insert operation. > > See attached screenshots. > > Pic1 - Before Time is entered > Pic2 - When you enter 3.45 and hit TAB. (Also happens when you type any > other invalid entry into the field) > > Error is display, and all fields are blanked as the databound/insert > appears to be cancelled. > > It doesn't cancel an EDIT, only the INSERT. A DataSet can be either in Edit or Insert mode not both. When a DataSet is cancelled then Cursor is positioned on nearest Row and its values are displayed. Can you verify this? . Quote Link to comment Share on other sites More sharing options...
Guest Posted March 17, 2011 Author Share Posted March 17, 2011 Message from: "Andrew Tierney" > "Andrew Tierney" wrote in message > news:f4VQnWq4LHA.3560@anaxagvs227... >> Hi, >> >> If you are inserting a new record and enter a '.' in the time field. >> >> It raises and error and terminates the Insert operation. >> >> See attached screenshots. >> >> Pic1 - Before Time is entered >> Pic2 - When you enter 3.45 and hit TAB. (Also happens when you type any >> other invalid entry into the field) >> >> Error is display, and all fields are blanked as the databound/insert >> appears to be cancelled. >> >> It doesn't cancel an EDIT, only the INSERT. > > A DataSet can be either in Edit or Insert mode not both. > When a DataSet is cancelled then Cursor is positioned on nearest Row and its > values are displayed. Can you verify this? > > The problem only occurs when the DataSet is in Insert mode. It appears to cancel and move to the nearest row. (which for the first entry is empty, hence the clearing of the fields). The DataSet in Edit mode doesn't do a cancel when an error occurs in the DBDateTime control. It only seems to Cancel the DataSet in Insert mode. If I have lots of records and enter an invalid Date in INSERT mode it places the cursor on the last record in the dataset. If the dataset is empty it clears all fields. Either way.. Its cancelling the Insert.. Which doesn't happen in Edit mode. Note sure if I explained this well??? Andrew . Quote Link to comment Share on other sites More sharing options...
Guest Posted March 17, 2011 Author Share Posted March 17, 2011 Message from: "Farshad Mohajeri" "Andrew Tierney" wrote in message news:zDXxCoG5LHA.2164@anaxagvs227... >> "Andrew Tierney" wrote in message >> news:f4VQnWq4LHA.3560@anaxagvs227... >>> Hi, >>> >>> If you are inserting a new record and enter a '.' in the time field. >>> >>> It raises and error and terminates the Insert operation. >>> >>> See attached screenshots. >>> >>> Pic1 - Before Time is entered >>> Pic2 - When you enter 3.45 and hit TAB. (Also happens when you type any >>> other invalid entry into the field) >>> >>> Error is display, and all fields are blanked as the databound/insert >>> appears to be cancelled. >>> >>> It doesn't cancel an EDIT, only the INSERT. >> >> A DataSet can be either in Edit or Insert mode not both. >> When a DataSet is cancelled then Cursor is positioned on nearest Row and >> its >> values are displayed. Can you verify this? >> >> > > > The problem only occurs when the DataSet is in Insert mode. > > It appears to cancel and move to the nearest row. (which for the first > entry is empty, hence the clearing of the fields). > > The DataSet in Edit mode doesn't do a cancel when an error occurs in the > DBDateTime control. > As far as I see in the image you're using a standard DBEdit for Time edit. Is is correct? It is not a DBDateTimePicker. > It only seems to Cancel the DataSet in Insert mode. > > If I have lots of records and enter an invalid Date in INSERT mode it > places the cursor on the last record in the dataset. If the dataset is > empty it clears all fields. > > Either way.. Its cancelling the Insert.. Which doesn't happen in Edit > mode. I understand, but it should be the same for both. The only exception is when an Exception raises during "Post operation", for instance a blank field, duplicate index and etc. In this case DataSet will not cancel. That said, I made some modifications to execption handling logic in db controls. . Quote Link to comment Share on other sites More sharing options...
Guest Posted March 17, 2011 Author Share Posted March 17, 2011 Message from: "Andrew Tierney" On 17/03/2011 6:57 PM, Farshad Mohajeri wrote: > "Andrew Tierney" wrote in message > news:zDXxCoG5LHA.2164@anaxagvs227... >>> "Andrew Tierney" wrote in message >>> news:f4VQnWq4LHA.3560@anaxagvs227... >>>> Hi, >>>> >>>> If you are inserting a new record and enter a '.' in the time field. >>>> >>>> It raises and error and terminates the Insert operation. >>>> >>>> See attached screenshots. >>>> >>>> Pic1 - Before Time is entered >>>> Pic2 - When you enter 3.45 and hit TAB. (Also happens when you type any >>>> other invalid entry into the field) >>>> >>>> Error is display, and all fields are blanked as the databound/insert >>>> appears to be cancelled. >>>> >>>> It doesn't cancel an EDIT, only the INSERT. >>> >>> A DataSet can be either in Edit or Insert mode not both. >>> When a DataSet is cancelled then Cursor is positioned on nearest Row and >>> its >>> values are displayed. Can you verify this? >>> >>> >> >> >> The problem only occurs when the DataSet is in Insert mode. >> >> It appears to cancel and move to the nearest row. (which for the first >> entry is empty, hence the clearing of the fields). >> >> The DataSet in Edit mode doesn't do a cancel when an error occurs in the >> DBDateTime control. >> > > As far as I see in the image you're using a standard DBEdit for Time edit. > Is is correct? It is not a DBDateTimePicker. > >> It only seems to Cancel the DataSet in Insert mode. >> >> If I have lots of records and enter an invalid Date in INSERT mode it >> places the cursor on the last record in the dataset. If the dataset is >> empty it clears all fields. >> >> Either way.. Its cancelling the Insert.. Which doesn't happen in Edit >> mode. > > I understand, but it should be the same for both. The only exception is when > an Exception raises during "Post operation", for instance a blank field, > duplicate index and etc. In this case DataSet will not cancel. > > That said, I made some modifications to execption handling logic in db > controls. > > Yes you are correct the time is a DBEdit not datetime.. Thanks for the exception handling logic mods. Andrew . Quote Link to comment Share on other sites More sharing options...
Guest Posted March 19, 2011 Author Share Posted March 19, 2011 Message from: "Junior/RO" Farshad Mohajeri escreveu: > That said, I made some modifications to execption handling logic in db controls. Thank you very much. . Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.