Container and unbounded string (text) fields are not allowed in a WHERE expression in AX.

Hi,

The problem:
Axapta does not want you to use an unbounded string in a where clause.

cont

The solution:
You must use a ‘bounded’ string. To do this you must declare your string with a numerical limiter e.g. str 30.

Example:
PurchTable getFirstByCustomerPOId(str 30 customerPOId)
{
PurchTable purchTable;
;
purchTable.selectForUpdate(true);
select firstonly purchTable
where purchTable.My_CustomerPurchaseOrderId == customerPOId;
return purchTable;
}

Advertisements

4 thoughts on “Container and unbounded string (text) fields are not allowed in a WHERE expression in AX.

  1. You need targeted traffic to your website so why not try some for free? There is a VERY POWERFUL and POPULAR company out there who now lets you try their traffic for 7 days free of charge. I am so glad they opened their traffic system back up to the public! Sign up before it is too late: http://voxseo.com/traffic/

  2. I am not sure where you are getting your information, but great topic. I needs to spend some time learning more or understanding more. Thanks for fantastic information I was looking for this information for my mission. busy P³ock

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s