Solved

To refina a function or give a new one if any of the expert has.

Posted on 2009-07-09
3
239 Views
Last Modified: 2013-12-26
PB7

I have a function which is meant to do the following.

It checks thoses columns of datawindow whoose required property is checked.

If data is note entered in that column then it throws message like this

'Value required for column +[column in question]'

It is working for one column.

For example, if the datawindow has more than one required columns and it would
throw message for the first column. ok.

But when I click the save button again , it does not do anything.

Calling method:
IF f_checkrequired (dw_master) = 0 THEN RETURN  



$PBExportHeader$f_checkrequired.srf

$PBExportComments$Checks that all required columns in a DataWindow control are filled in

global type f_checkrequired from function_object

end type
 

forward prototypes

global function integer f_checkrequired (datawindow adw_control)

end prototypes
 

global function integer f_checkrequired (datawindow adw_control);integer li_colnbr = 1

long ll_row = 1

string ls_colname, ls_textname 
 

IF adw_control.AcceptText() = -1 THEN

	adw_control.SetFocus()

	RETURN 0

END IF
 

IF adw_control.FindRequired( primary!, ll_row, li_colnbr, ls_colname, true ) < 1 THEN

	RETURN 0

END IF
 

IF ll_row <> 0 THEN

	// Get the text of that column's label.

	ls_textname = ls_colname + "_t.Text"

	ls_colname = adw_control.Describe(ls_textname)

	// Tell the user which column to fill in.

	MessageBox("Required Value Missing","Please enter a value for '" + ls_colname , exclamation!)

	// Make the problem column current.

	adw_control.SetColumn(li_colnbr)

	adw_control.ScrollToRow(ll_row)

	adw_control.SetFocus()

	RETURN 0

END IF

RETURN 1

end function

Open in new window

0
Comment
Question by:Mehram
3 Comments
 
LVL 14

Accepted Solution

by:
shru_0409 earned 250 total points
ID: 24813627
go to edit tab and select required field on.
0
 

Author Comment

by:Mehram
ID: 24820317
<<go to edit tab and select required field on.>>

I have already done that.

We probably have suppresed error message throwing by field required, I dont know how and where.


0
 
LVL 14

Assisted Solution

by:sandeep_patel
sandeep_patel earned 250 total points
ID: 24824173
did you check the 'empty string is null' check box for all columns? Because find required will report only if column value is NULL.

Actually you can debug your code and see from where it is retruning without message.

Regards,
Sandeep
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Here is a helpful source code for C++ Builder programmers that allows you to manage and manipulate HTML content from C++ code, while also handling HTML events like onclick, onmouseover, ... Some objects defined and used in this source include: …
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.
The viewer will learn how to use and create keystrokes in Netbeans IDE 8.0 for Windows.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now