search

burkybang / SuiteAdvanced-Feedback

NetSuite Advanced Feedback
https://burkybang.com/SuiteAdvanced
3 stars 0 forks source link

about generated SuiteQL #198

Closed hminhduc closed 1 month ago

hminhduc commented 1 month ago

After copy generated from tool, it not directly for using. by adding space on each SQL keyword. For example var suiteQLQuery = SELECT itemVendor.purchaseprice FROM item,itemVendor WHERE item."ID" = itemVendor.item(+) AND ((item."ID" = ? AND itemVendor.vendor IN (?))) ; To run it no error, i have to add space after SELECT and FORM, WHERE manual.

So how can add this space on generated SuiteSQL?

burkybang commented 1 month ago

From where are you copying this? Please provide screenshots.

hminhduc commented 1 month ago

This is copy of that SQL . before From, Where dont have a space so that error in runtime.

image
burkybang commented 1 month ago

I don't understand. I see a line break and 2 spaces after SELECT.

hminhduc commented 1 month ago

OK, thank you! So copy that original command is error, then after add space before From and Where keyword (not after) it is run again.

burkybang commented 1 month ago

I'm so sorry. I don't understand.

Maybe you could create a screen recording of the issue?

hminhduc commented 1 month ago

I'm sorry, today i get run again and all is ok.

hminhduc commented 1 month ago

so please close this issue