Tuesday, September 28, 2010

%Bind [NOQUOTES]


You might have used %Bind ([record name.]Fieldname [, NOQUOTES]) while you code. It might be a confusing part for some people, on why NOQUOTES is used with %bind.

If you are selecting the character field from the database, it will be enclosed in quotes. Use NOQUOTES to remove that quotes while selecting.

For example say you are selecting the record PS_TEST from a table to use it in the AE SQL action. While selecting it the record name will be enclosed in quotes, which will error out the SQL action. There you can use NOQUOTES for removing the quotes. This is a typical example for information.

Anoop Savio

2 comments:

  1. AnonymousJuly 13, 2011

    This comment has been removed by a blog administrator.

    ReplyDelete
  2. thank you.

    ReplyDelete

Total Pageviews

Copyright © Tech & Management Notes