4 Replies Latest reply on Mar 8, 2011 8:45 PM by Joy Garon

Using a Card Variable in a Card list Query

Ross McEllhiney Mar 4, 2011 5:31 PM

Hello

Is it possible to pass a card variable value to a card list Query

I would like to use a combox pull down list to select a subset of a database list using the value in the Combobox

I know that I can use the

Dynamically-controlled Card Lists

But this does not let me query a seperate database.

I also know how to write API code to do this but it would be simpler to Pass a varaible to the Query

Thanks

Ross

Re: Using a Card Variable in a Card list Query

Jeff Walters Mar 7, 2011 10:17 AM (in response to Ross McEllhiney)

Have you looked in to creating a list from a SQL query? Page 171 in the Administration guide.
Like Show 0 Likes(0)

Actions
- Re: Using a Card Variable in a Card list Query
  
  Jeff Sweeney Mar 8, 2011 8:52 AM (in response to Jeff Walters)
  
  The query Jeff mentions cannot contain/reference a variable value from the card.
  
  Wouldn't that be sweet though? Think how much more intelligent our cards could be.
  
  Like Show 0 Likes(0)
  
  Actions
  - Re: Using a Card Variable in a Card list Query
    
    Ross McEllhiney Mar 8, 2011 6:30 PM (in response to Jeff Sweeney)
    
    I need to do exactly what Jeff is saying, Does anyone know how to do That??????
    
    I want to transfer a varaible from the card to a Query and then run the query to get a list
    
    Thanks
    
    Like Show 0 Likes(0)
    
    Actions
    - Re: Using a Card Variable in a Card list Query
      
      Joy Garon Mar 8, 2011 8:45 PM (in response to Ross McEllhiney)
      
      Ross -
      
      You can use an add-in -
      
      Look at the AVI included in this thread:
      https://forum.solidworks.com/message/145368#145368
      
      Joy
      
      Like Show 0 Likes(0)
      
      Actions