AnsweredAssumed Answered

Want to show value on Card from Database

Question asked by IDSPL Support on Sep 23, 2008
Latest reply on Sep 30, 2008 by Joy Garon

Like • Show 0 Likes0
Comment • 12

Hi
I hav a template named Enquiry. this template have many fields like Enquiry No, CompName,Info,Place etc. I use this template and save values in database.

Again i have a card with many field including Enquiry no,Compname, Info, Place.

here i face the problem because i want that when i click on a Certain Enquiry No from the combobox, the related field Compname,Info and Place will display automatically in Their readonly text boxes.

how can i do this?

No one else has this question

Outcomes

12 Replies

Raghavendra Bhagavan.S.M Sep 23, 2008 5:14 AM
Mark Correct
Correct Answer
Hi Sushil / Ajay

Could you kindly clearly explain the problem ??? Attach some pics if you have...

Regards,
Bhagavan
Like • Show 0 Likes0
Actions
- IDSPL Support @ Raghavendra Bhagavan.S.M on Sep 23, 2008 8:14 AM
  Mark Correct
  Correct Answer
  Hi Raghavendra
  
  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
  Like • Show 0 Likes0
  Actions
  - IDSPL Support @ IDSPL Support on Sep 25, 2008 5:37 AM
    Mark Correct
    Correct Answer
    No one use this??????
    Like • Show 0 Likes0
    Actions
Raghavendra Bhagavan.S.M Sep 25, 2008 8:07 AM
Mark Correct
Correct Answer
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.
Like • Show 0 Likes0
Actions
Jeff Sweeney Sep 25, 2008 11:27 AM
Mark Correct
Correct Answer
Tell us more about this template named Enquiry. Is it a PDMWE template? Is it an Excel template?
Like • Show 0 Likes0
Actions
- Eduardo Hincapié @ Jeff Sweeney on Sep 26, 2008 4:14 PM
  Mark Correct
  Correct Answer
  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.....
  Like • Show 0 Likes0
  Actions
- IDSPL Support @ Jeff Sweeney on Sep 27, 2008 3:10 AM
  Mark Correct
  Correct Answer
  Dear,
  
  Im explaining th eproblem ,
  
  " 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.
  
  thanks,
  
  Sushil Sareen
  Like • Show 0 Likes0
  Actions
  - Joy Garon @ IDSPL Support on Sep 29, 2008 12:19 PM
    Mark Correct
    Correct Answer
    Sushil -
    
    You will need to write an add-in to accomplish this.
    I suggest tying it to a button on the data card.
    
    Regards,
    Joy
    Like • Show 0 Likes0
    Actions
    - Eduardo Hincapié @ Joy Garon on Sep 29, 2008 1:35 PM
      Mark Correct
      Correct Answer
      Joy:
      
      Where can I find documentation to do this?
      
      Best Regards
      
      Eduardo
      Like • Show 0 Likes0
      Actions
      - Joy Garon @ Eduardo Hincapié on Sep 29, 2008 2:21 PM
        Mark Correct
        Correct Answer
        Eduardo -
        
        First you need programming skills :-)
        You can find the API help on the CD in the Support\API directory.
        
        Cheers,
        Joy
        Like • Show 0 Likes0
        Actions
        IDSPL Support @ Joy Garon on Sep 30, 2008 3:57 AM
        Mark Correct
        Correct Answer
        Joy Garon
        
        I allready made a button on the card but by the API Help i not got anything that is used to access the information from database.
        How i make .exe file of sql?
        Like • Show 0 Likes0
        Actions
        Joy Garon @ IDSPL Support on Sep 30, 2008 1:11 PM
        Mark Correct
        Correct Answer
        Hi Sushil -
        
        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.
        
        Regards,
        Joy
        Like • Show 0 Likes0
        Actions

Want to show value on Card from Database

Outcomes

Related Content

Recommended Content