Actually we use templates to store the users value in database.
Now I have a template named Enquiry and i take the user input and
save it in database.
Now i want to retrieve some information
on a diffrent card from database that depend on a specific
value Enquiry No.

Explanation:-
Means if i select Enquiry1 then on other card its releted value
like generation time , generated by, endtime are automatically come
in read only text boxes

I'm completely not able figure out what you are trying to say
!!!!
I understand that you use some Template input form..... and you
need to get that information on to the other data card ?? or you
need to search this values by using a card....

I tried understanding the problem.... Correct me if am wrong..
mail me for more info bhagavan@beacon-india.com.

In fact I have the same problem, you can import data in a
list by using a query, but it will only contain a field, but I need
to do a query using a card variable as a parameter in order to
search the database to fill the other related fields.....

" I have two different lifecycles. 1. Enquiry & 2. NPD.
There are two different input and Folder cards for enquiry &
NPD.
I have generated new enquiry (enquiry No:EX001) and fill the fields
in Input Form.
As example fields in Inquiry input Form: {Customer Name, Enquiry
Date, Due Date, Enquiry Author, Comments, etc}.

Now in NPD input form fileds are {Ref. Enquiry No, + all fileds
mentioned in Enquiry input form. } Ref. Enquiry No filed is in
dropdown and available all the updated enquiriy no's are available.

Now Requirement is: While im generating the New NPD. in NPD input
Form when i select the Ref. enquiry no: EX001, then rest of the
fileds should come filled automatically like Customer Name, Enquiry
Date, Due Date, Enquiry Author, Comments, etc.)

I hope now you can understand the scnerio. if still there is
confusion, please let me know. i will try to create some images.

You don't make an .exe file from SQL. You will need to consult with
a programmer who is experienced with VB.NET to write an add-in. The
API is well documented and a skilled programmer will understand how
to write the add-in.