Differences between EXECSRIPT and Macro Expansion

2011-01-14 Thread Steve Ellenoff
Can someone explain why the following code fails to work using EXECSCRIPT but works in macro-expansion? tcSQL = [INSERT INTO webaccess (AENABLED,FKID,LASTMOD,LASTUSER,LOGIN,PASSWORD,PERSTYPE,UNIQUEID) VALUES (1,'_34I18SAUJ',{^2011-01-13

Re: Differences between EXECSRIPT and Macro Expansion

2011-01-14 Thread Steve Ellenoff
I forgot to mention that the problem is related to the funky characters of the password field. The password field is being encrypted, and that value is causing the EXECSCRIPT to fail. If you blank out that value in the INSERT string, EXECSCRIPT works fine.. I am wondering why? TIA- -Steve

RE: Differences between EXECSRIPT and Macro Expansion

2011-01-14 Thread Grigore Dolghin
To: profoxt...@leafe.com Subject: Re: Differences between EXECSRIPT and Macro Expansion I forgot to mention that the problem is related to the funky characters of the password field. The password field is being encrypted, and that value is causing the EXECSCRIPT to fail. If you blank out

Re: Differences between EXECSRIPT and Macro Expansion

2011-01-14 Thread Gianni Turri
- boun...@leafe.com] On Behalf Of Steve Ellenoff Sent: Friday, January 14, 2011 6:30 PM To: profoxt...@leafe.com Subject: Re: Differences between EXECSRIPT and Macro Expansion I forgot to mention that the problem is related to the funky characters of the password field. The password field

RE: Differences between EXECSRIPT and Macro Expansion

2011-01-14 Thread Steve Ellenoff
between EXECSRIPT and Macro Expansion I forgot to mention that the problem is related to the funky characters of the password field. The password field is being encrypted, and that value is causing the EXECSCRIPT to fail. If you blank out that value in the INSERT string, EXECSCRIPT

RE: Differences between EXECSRIPT and Macro Expansion

2011-01-14 Thread Grigore Dolghin
...@leafe.com Subject: RE: Differences between EXECSRIPT and Macro Expansion You're assumption was right, creating a manual PRG of that line of code will not compile. Interestingly, the error msg is different; it gives Command contains unrecognized phrase/keyword. when trying to compile, rather