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
At 11:26 AM 01/14/2011, you wrote:
>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
>21:10:34},'_06L0TTTG4','2011CN140-001','/bvmpsA}:Âs','C','_34I18SAUQ')]
>
>*Code below fails with a syntax error
>EXECSCRIPT(tcSQL)
>
>*Code below succeeds and correctly inserts the record with all fields
>&tcSQL
>
>
>TIA-
>Steve
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
