Multiply Values Between Database Field And Query Prompt 追蹤

0
Avatar
Legacy Poster

I need to multiply the value from database field with the value given by user. I have tried following SQL command without success (Error S1000):

 

TABLE.FIELD * '?QueryPrompt' AS Nameforthefield

 

If I replace '?QueryPrompt' with number, I am able to run the SQL statement and print labels. What am I doing wrong? Is it even possible to use query prompt in SELECT statement?

1 意見

0
Avatar
Shotaro Ito
評論操作 永久連結

Would it help if you don't 'quote' that - like TABLE.FIELD * ?QueryPrompt .

登入寫評論。