Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved How to fix datetime data type conversion while datawindow is in querymode?

  1. Issue
0
Votes
Undo
  1. David Merinos
    David Merinos
  2. PowerBuilder
  3. Wednesday, 15 March 2017 17:32 PM UTC

Our program has DataWindows with DateTime fields and we allow the user to Query for information with QueryMode; one button turns QM on and another button causes it to Retrieve with the information the user put in.

Our datetime fields have the following mask: "dd/mm/yyyy" because of our locale (Mexico). 

However, when the user puts in something like "01/01/0001" the following error displays:

The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

Which is an SQL error, I've been digging around but haven't found anything related to PB and how to fix this isssue, I was wondering perhaps there's a way to tell the object to fix the date format before making the retrieve. 

¡Thanks!

  1. Build
  2. DataWindow
  3. DATETIME
Office upgrade
Calling PB components within IIS
Responses (1)
FILI SOSA
FILI SOSA Accepted Answer Pending Moderation
  1. Thursday, 16 March 2017 01:46 AM UTC
  2. PowerBuilder
  3. # 1

Hello,  when you enter information in query mode on, also the ITEMCHANGED event is triggered, so you can add this code so the user does not get the error:

STRING     ls_date

if row > 0 and dwo.name = 'your_date_field'  then

....ls_date = data

....if not isdate(ls_date) then

.......dw_1.Modify("datawindow.queryclear=yes")
.......messagebox("Message","The date in not correct")
....end if
END IF
 
With this code you clear the query so the user does not get the error!
 
Hope this helps!
Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.