DBlookup function to final of register

HI Krileon:

I did not understand, I explain better:

I have a database table naming "CLIENTS" with flollowing structure:
CODE_RUC varchar(13)
NAME_RUC varchar(50)

In my CB Form, I input in one field any RUC value, as "0909207524001". With this value, and using the mySQL command SELECT, I want select the field "NAME_RUC" of the table CLIENTS and store this field value into any variable.

How do I perform this task?
Exist any plugin for do it?
If YES, what is and please, send me the steps for get it the above requirement.

I used some of the plugins that I bought and I also had to hack the code CB QUERYFIELD to achieve what I just explained, but I could only show the value of the field but I could not be stored in the table. I do not understand OOP programming. But I must assume that there is any other better solution.

Thank you so much for your cooperation.

JOSE ALVARADO
Multimedia Designer.

The storing is done by the field you're using. In your case just create a Text field then use Query Validation for it. When the user registers and the query validation passes then the value the user entered will store. It can't store NAME_RUC, but what you can do is have a field for the user to supply the CODE_RUC, which validates it using Query Validation. Next create a normal Query Field, which displays the results of the query as a normal field to query for NAME_RUC. Example usage as follows.


Field 1
Type: Text
Name: cb_code_ruc
Query Validation: Enabled
Query: Mode: Internal
Validate On: Successful Results
Validate Error: Invalid token provided!
Ajax Validation: Enabled

Field 2
Type: Query
Name: cb_name_ruc
Query:

Dear Krileon:

I did everything you suggested, but the Query field in step 2 only performs a query but that kind of field is not shown.

How do I display the result of SELECT during registration?

Thanks,

How do I display the result of SELECT during registration?

You can't, CB Query Field has no edit display so it can't display on registration or profile edit. Registration especially as it has no user information to use in the query.

Thanks for your collaboration. But I have a question.

In a above post, you mention this: "Next create a normal Query Field, which displays the results of the query as a normal field to query for NAME_RUC. Example usage as follows." and in the last post you say that don´t do it.

Question:
why should I apply what the Query field if I can not show?

This step already did. Please, give me one last suggestion to conclude this post.

thank you

and in the last post you say that don´t do it.

I apologize for the confusion. That step is meant for Profile View. It will allow you to display the name you've stored in the database instead of the code. It can not display on registration or profile edit, it's just for Profile View.