system
1
Hello,
Is there any way to handle ‘/’ charater from the source field name ?
Below is the code I’m trying to use in the script and it returns with an error message
$v_date = sql(‘DS_BW’, ‘select MAX(/BIC/ZABCD) from TABLE1’);
Error Message :
06:26:24 AM driver][Microsoft SQL Server]Incorrect syntax near ‘/’.>.>.
Regards
Tarun
tarunforums (BOB member since 2014-06-13)
system
2
Hi,
Try to use the double quotes for the ‘/’ character.
ex:-$v_date = sql(‘DS_BW’, ‘select MAX("/BIC/ZABCD") from TABLE1’);
Regards,
Prasanna
prsnry (BOB member since 2016-12-13)
system
3
Thank you prasanna,
Let me try and come back to you.
Kind regards tarun
tarunforums (BOB member since 2014-06-13)