jacklcs Good day everyone.. I am exploring RazorSQL to create a View for the APP. I have create a very simple view_customer. In the RazorSQL is able to view the database of the table and the view. After that I go to the AwareIM configurate system. How do I call back the view in the AwareIM system? Anyone did this before? thanks...
tonyjamero I dont use RazorSQL but I have several database Views I created on several SQL databases that I then linked to my AwareIm App by making a BO with pesistence as Database:Existing External and then use the Views. Using this setup I can display and query my Views from external datasources.
jacklcs Assume I am using SQL Express.. I create the ViewCrossTab to pull out the InventoryLocation. So I go back to AwareIM to create a BO with pesistence as Database:ExistingExernal to link the ViewCrossTab? With this, I can display the BO on the query and filter it as well. Correct?
jacklcs Good day... I have create a very simple view_term on the SQL. I managed to create a new BO: view_term with pesistence as Database:ExistingExernal and able to connect the view_term (example). I have create the query on this BO called view_term and I publish it. But when I click the query.. show nothing. But my BO for Term have 5 rows of record. Any thing I did wrongly? Many Thanks.
jacklcs Good day... Assume the SQL Server connected sucessfully.. In the SQL Server, you need to call the ID on the View. In the AwareIM Discover Attribute, Primary Key, select the ID. After that the you will be able to view the query... thanks..
