Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Flash and 3d Animation
I have a project that will need to show some apparel slowly spinning, similar to the Adidas Gigaride does with the 360 spin. I am wondering if they have a physical shoe and shoot it a certain way and then add those into Flash, or if they shoot the shoe and then put the frames into like RayDream...- iceman42
- Thread
- Replies: 0
- Forum: Adobe: Flash
-
-
Query Help
Okay this is where I am at. SELECT B.RDSTAT, COUNT(*) FROM ORPRDETL A, ORPRDETL B WHERE A.RDSTAT = 200 AND B.\"RDORD#\" = A.\"RDORD#\" AND B.RDENDX = '2006-02-27' AND B.RDENDX <> '1940-01-01' AND B.RDSTAT = (SELECT MAX( C.RDSTAT) FROM ORPRDETL C WHERE C.\"RDORD#\" = B.\"RDORD#\" AND C.RDENDX <>... -
Query Help
I've been looking at this, although not with an open mind, for about 2 days and I dont see anyway to get the current location of an item that left area 2 on x date, I might be wrong. This one got me counts. SELECT B.STAT, COUNT(*) FROM ORTL A ,ORTL B WHERE A.STAT = 3 AND B.INVOICE =... -
Query Help
Yeah thats sounds like a better idea, I'll post back what I find out. -
Query Help
The total for the last query is 131 out of a total number of 849 items that left area 2 on 3/1/2006. -
Query Help
I wish I could edit my posts :) sorry about the one line reply my mouse got ahead of my brain. I changed it a little bit to SELECT B.STAT, COUNT(*) FROM ORTL A ,ORTL B WHERE A.STAT = 3 AND B.INVOICE = A.INVOICE AND B.NDX >= 2006-01-31 AND B.STAT = (SELECT MAX(C.STAT) FROM... -
-
Query Help
SELECT B.STAT, COUNT(*) FROM ORTL A ,ORTL B WHERE A.STAT = 3 AND B.INVOICE = A.INVOICE AND B.NDX >= A.NDX AND B.STAT > A.STAT GROUP BY B.STAT This query seems to get me the counts for each area that the order has been too, however I need the query to not count the area if an order is... -
Query Help
This is the second time I'm going to attempt to post this, last time it didnt seem to take :( Anyway I'm using iSeries Access Driver for ODBC v9.blah.blah. Currently I am configuring a System DNS for each Library, I have tried to list multiple Libraries, on the 2nd tab, the driver for some... -
-
Query Help
The way I did my ODBC was through the Data Sources control panel, but I only saw where I could specify one Library, not very familiar with the window DSN setup. -
Query Help
There is one problem and that is I am doing this through and ODBC connection to an AS/400 and the two tables are in two seperate libraries, so I dont think the joins will work. -
Query Help
Okay thanks, just getting back to it after being out a few days. -
Query Help
There is no flag, however my report starts when the invoice leaves area 2 -
Query Help
I forgot to answer the other question about not needing certian ones, 0 I dont need 1 is something all together different -
Query Help
Here is one set of scans from one invoice. Red is the area, green is the invoice #. 655391 E 1 1 10 0 2005-12-22 15:59:00 32 2005-12-22 16:21:00 76 0 1.00 C 1940-01-01 655391 E 2 1 20 1 2006-01-19 16:44:00 5 2006-01-19 16:44:00 5 0 1.00 C 1940-01-01 655391 E 3 1 30 2 2005-12-22 16:21:00 76... -
Query Help
SELECT COUNT(*) FROM \"ORTL\" WHERE \"STAT\" = 3 AND \"STAT\" !> 3 AND \"NDX\" = '2006-01-31' is what I tried next. then I tried I also did SELECT COUNT(*) FROM \"ORTL\" WHERE \"STAT\" = 3 AND \"STAT\" !> 3 AND \"STAT\" !< 3 AND \"NDX\" = '2006-01-31' I got the same count as the previous query... -
Query Help
SELECT COUNT(*) FROM \"ORTL\" WHERE \"STAT\" = 3 AND \"NDX\" = '2006-01-31' which gets me all the ones that are =3, of course :), however the same record could be finished and out the door and I need to know that as well as those that are at area 4, 5, 6 and 7. I know I'm not thinking clearly... -
Query Help
I'm running a query and I need some help going through the logic. First off the data is organized by an invoice number, however the invoice number is not important in the query, the query is looking for the current location of an item in a certain route that started on x date. So lets say...
