Aware IM User Forums

Database Allocation was setup as default". So, Database & Test Database = 'Default'.

I'm using SQL Server envirenment for AIM backend. How do you (best practice) distinguish between the TEST and PRODUCTION envirnement for calling the stored procedure? I can place the procedure in both databases, but the EXEC_SP requires the complete path.

That's what I finally ended up doing!

Is it possible to Select a distinct list from a BO? I have a BO that contains the attribute Vendor. Can I do a Find from thi Object of just Distinct Vendors? IN SQL it would be -

Select DISTINCT Vendor, VendorName from VendorItems.

Thanks. Evidently you cannot use Native functions on SQL data. Internal error. Element REPLACE_PATTERN in query condition REPLACE_PATTERN(Vendors.VENDOR,' ','')=VendorLog.Vendor of query FIND Vendors WHERE REPLACE_PATTERN(Vendors.VENDOR,' ','')=VendorLog.Vendor cannot be converted to the currently i...

So then using native query against BO external to MS SQL, The functions don't work. Trying to select (FIND) data with a date range within the last two months. FIND PAY_PERIODS WHERE PAY_PERIODS.PPED >= DATE_ADD(CURRENT_DATE, -60) Fails, stating it (DATE_ADD) can't be converted to current version of ...

I used an Alias as per the example. And even If I don't, it complains about the '*', when setting up the SQL Query on the Textual view tab.

Where is this SQL QUery Form tab? User Guide, Page 430. Desinging a Query on a BO connected to external database, (MS SQL 2012). Using Native "Find" statement - FIND PAY_PERIODS WHERE PAY_PERIODS.COMPANY=103 AND PAY_PERIODS.PPED >= DATE_ADD(CURRENT_DATE,-60) Reults in error - (DATE_ADD.....) cannot ...

Now I'm getting -
Internal error. The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server "LWS-DB-11" was unable to begin a distributed transaction.

DBA says "The linked server is setup for RPC". So I'm at a stand Still.

I have two attributes on a Form, Vendor_Number and Vendor_Name. I have a Vendor BO linked to an external SQL DB. Whats the best way to incorporate the External data? I thought a "Search Icon" next to the Vendor_Number text box, but can't seem to figure out how to make that work. The user May know th...

MAybe some - The query is going to be called many times from different users. It is a complex stored procedure with parameters. One user may call it with a specific set of params , while another maybe calling it with different params. The results are then going to be exported to excel. I setup a BO ...

Can someone describe the steps to call an external (MS SQL) stored procedure that returns a results set. This is to be used for users to export to csv/excel. Using the [EXEC SP ‘proc1’ OF SQLServer WITH ‘@param1’=1,’@param2’=2 RETURN SomeObject] syntax. Is the "SomeObject" , a table in SQL Server th...

I want one of my cells in a query grid to word wrap. I've tried without success, setting the CSS Style of the attribute as
"word-wrap: normal;". Can this be done on the standard grid, or only in custom layout?

Then again maybe not. More testing.....

This seems to be bringing back ALL the data.