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 .

请先登录再写评论。