ATTENTIONThis FlexSim Community Forum is read-only. Please post any new questions, ideas, or discussions to our new community (we call it Answers) at https://answers.flexsim.com/. Our new Question & Answer site brings a modern, mobile-friendly interface and more focus on getting answers quickly. There are a few differences between how our new Q&A community works vs. a classic, threaded-conversation-style forum like the one below, so be sure to read our Answers Best Practices. |
flexsim.com |
#1
|
||||
|
||||
SQL issues
Hi,
just am very new to SQL in FlexSim and facing a Problem I can´t find a solution. Maybe anybody has a hint for me. What I´m trying to do looks this way: Quote:
__________________
Hemmi |
#2
|
|||
|
|||
You should be able to just concat() the integer onto the end using numtostring()
so query(concat("SELECT * FROM ProdListe \ WHERE Art_Nr =",numtostring(i_Auftragsnr,0,0))); Last edited by Jason Lightfoot; 11-16-2015 at 04:06 PM. |
The Following User Says Thank You to Jason Lightfoot For This Useful Post: | ||
Sebastian Hemmann (11-16-2015) |
Tags |
sql |
Thread | Thread Starter | Forum | Replies | Last Post |
Cursor issues | David Chan | Q&A | 0 | 08-07-2015 08:33 PM |
Dashboard issues | Sebastian Hemmann | Tips and Tricks | 6 | 12-19-2013 03:12 AM |
Transport issues | FlorianK | Q&A | 3 | 05-24-2011 10:36 AM |
GUI Button Issues | shashanktrivedi | Q&A | 5 | 05-23-2011 10:34 PM |
PLC connection, positioning issues | Stephan Seidel | Q&A | 13 | 04-08-2010 01:02 AM |