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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. CartoonDog

    Help with an SQL statement.

    Ok, got it working, my editor does not like the 'AS' keyword.
  2. CartoonDog

    Help with an SQL statement.

    No probs on the typo, I caught it when Typing it in. I think you are on the right track, but my SQL+Worksheet is choking on something. It doesnt seem to like the left join immediatly followed by the select without some keyword in between. This is Oracle 9.2. Any idea?
  3. CartoonDog

    Help with an SQL statement.

    yes, sorry about the typo of the second where. It does not seem to work. Part 'X' in the parts table that does not show a Class 'I' transaction between today and 1/1/2007 should show in the results list, but does not. It may although have other Classes of transactions, as long as they are not...
  4. CartoonDog

    Help with an SQL statement.

    No, sorry, that was just a typo in the forum.
  5. CartoonDog

    Help with an SQL statement.

    Ive tried it both ways and it doesnt work correctly.
  6. CartoonDog

    Help with an SQL statement.

    I am have been trying to write a sql statement and could use some help. I am querying two tables. The first table holds the part numbers called PART. The second holds the transactions for the part table and is called TRANS. I need to find all the parts that have not had any transactions...
  7. CartoonDog

    Help with an SQL statement.

    I am have been trying to write a sql statement and could use some help. I am querying two tables. The first table holds the part numbers called PART. The second holds the transactions for the part table and is called TRANS. I need to find all the parts that have not had any transactions...
  8. CartoonDog

    EMERGENCY!! sigh... (ICS7750, 3.3CM) cant hear out/inbound voices.

    Hi all any help would be appriciated. Making inbound or outbound calls results in a ringing phone on both ends as it should. When connected, neither party can hear what the other is saying. Internal calling is fine. My calls go outbound though a TI/PRI. I am starting my search there. Any...
  9. CartoonDog

    7970G on a ICS7750 3.3(2)spC??

    Hello, I have a ICS7750 running callmanager 3.3(2)spC. All my phones are 7960's. This version of CM cameout prior to the 7970G. Is there a way to fool CM into thinking that the 7970G is a 7960? Or any other way without upgrading the entire CM to get this to work? I happen to have a 7970G...
  10. CartoonDog

    CDR working?

    Hi I am using 3.32 and looked into the SQL table for CDR information, and it was blank. The CDR Insert service is started under the control center. Is there a config utility for the CDR of some sort? THanks.
  11. CartoonDog

    Crystal Web Rpts 8 and Date Ranges

    Hi gang. I am not concerned with performance, just getting the accurate results. My original report has a range of values that uses this selection criteria: {CUST_ORDER_LINE.PROMISE_DATE} in {?Due Date} ?DueDate is a Date Range with no default values. The above report selection seems to...
  12. CartoonDog

    DOS app question

    Problem solved... helps when you spell the app name correctly!
  13. CartoonDog

    DOS app question

    The error message actually says, '"Time Clock" failed to start.' Time Clock is the name of the Application
  14. CartoonDog

    DOS app question

    Hi, I have XPe running on W2k server sp4. I am trying to publish a timeclock app for my MRP system (Visual). The icon looks like a plain window, akin to dos. When launched from a pc, it opens a dos window, and runs an app akin to telnet. When I try to run this app on the citrix server, it...
  15. CartoonDog

    Anyone using this in a hotel enviro?

    Hotel Valencia in SJ, Ca.
  16. CartoonDog

    Time of Day restrictions help

    Is there any way to deactivate a 7960 (CM 3.3) so it either stops working all togather or limited to incoming calls/internal calls after a certain time? Then will resume normal operations in the morning? Thanks.
  17. CartoonDog

    HTTP / FTP download timeout

    Hey Sames1, I am having the exact same problem with a Cisco 2611 router. Did you find a solution to the problem? Give me a hollar, I would like to compare configs. Cartoondog@lpmachine.com
  18. CartoonDog

    Trap the Minimize button.

    I found the answer if anyone is interested on VBtips.com. The api function will return just about any action to a form BEFORE it is executed... therefore you can insert your own code first and derail what windows had intended. Here is the link...
  19. CartoonDog

    Trap the Minimize button.

    I have written an app that uses the systray. I have disabled the ShowInTaskBar property of the form in question. When the user presses the Min button I want an animation of the form to shrink down to the systray. I have the animation working fine if I execute it with a command button, but I...
  20. CartoonDog

    Get winsock true status

    The issue that you experienced has been plaguing me for over a year, good work on the crlf concept. I have a question though: I am trying to receive information from CNC controls (Industrial Machines). These machines have serial ports, I convert the serial to Ethernet, which in turn...

Part and Inventory Search

Back
Top