Search the Community
Showing results for tags 'variables'.
-
Trigger - On INSERT LOOP through another table
kgraham2121 posted a question in Tables, Views and Relationships
Assume following Table schema: Hi, My desired work flow Insert a date record into tbl_Inventory Count_Dates On INSERT, tigger the following: Loop through tbl_Inventory_Items - a list of each item to be counted - and insert a copy of each item into tbl_Inventory_Count_Detail, along with default value of 0 for Count of each record. This results in a record including new id, Count_Date(which triggered the event), Material_id, Material_Name, and Count (Set to 0). The purpose of this is to be able to filter tbl_Inventory_Count_Detail by Count_Date and use as a data source/view for a Tabular report datapage that allows user to enter a dated physical count for each item. @CraigSZ - I think this is similar to the direction you suggested in earlier post. Hoping I can do this all with a looping triggered action - Just not sure on Syntax. Any help would be greatly appreciated...Thx...- 1 reply
-
- trigger action
- loop
-
(and 3 more)
Tagged with:
-
I'm trying to pre-filter a datapage based on an external parameter I pass along in a URL query. It's worked for me with no problems before, but for one page, I'm having a problem that once I use one parameter, if I try any other URL with another parameter, the first one seems stuck in the system. For example, I'll have this link filter the results for Colorado: http://b4.caspio.com/dp.asp?AppKey=e2742000bfd7874f295c475987ea?State1=CO Then If I go to think link to filter for NJ, it still shows the Colorado results. http://b4.caspio.com/dp.asp?AppKey=e2742000bfd7874f295c475987ea?State1=NJ I can't seems to figure out what's causing the problem. I've changed the parameter's names, recreated the table and database, and nothing has helped. Any suggestions? Thank you, Randy