PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WINDEV (précédentes versions) → Search in another Table
Search in another Table
Débuté par Marcelo Santos, 15 oct. 2010 09:07 - 1 réponse
Posté le 15 octobre 2010 - 09:07
Hello Guys,

In the past, I had developed a function in Clipper that search an information in another table, and get that information to validate an Edit Control.

For example: in an edit control that user must insert a product code, if the user press a button, the system shows the products table in a grid, and let the user pick one product, double clicking on them or clicking and selecting an OK button.

This function gets the product code in this window and populate this code in the control that the user had the focus.

The same principle is that user must input a valid product code, that exists in another table, and don't go to another edit control until this code in inserted or the operation is canceled by hit the Cancel button or ESC key.

Is hard to implement this in Windev?
Posté le 15 octobre 2010 - 17:46
Hi Marcello

no, it's very easy.. A button with 3 lines of code, a View type window
to do the selection (RAD can generate one), and a few lines of code in
the exit code of the field and youa re all set

Best regards

--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting

More information on http://www.fabriceharari.com


On 15/10/2010 02:07, Marcelo Santos wrote:
Hello Guys,

In the past, I had developed a function in Clipper that search an information in another table, and get that information to validate an Edit Control.

For example: in an edit control that user must insert a product code, if the user press a button, the system shows the products table in a grid, and let the user pick one product, double clicking on them or clicking and selecting an OK button.

This function gets the product code in this window and populate this code in the control that the user had the focus.

The same principle is that user must input a valid product code, that exists in another table, and don't go to another edit control until this code in inserted or the operation is canceled by hit the Cancel button or ESC key.

Is hard to implement this in Windev?