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!

Register Log in
  • Congratulations derfloh 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. robmoors

    How do you save an attachment ?

    I am wanting to create a vb app that will save an attachment once the email arrives. Could you please provide a sample code Thank in advance
  2. robmoors

    Problem with create table

    Can someone tell me what's the code for creating a table using ADO? Thanx in advance
  3. robmoors

    How do I do a SELECT on an ODBC connection

    I am trying to use a SELECT statement against an Oracle ODBC connection and it's telling me that it can't find the object(table). How do I create that statement? Thank you in advance :>
  4. robmoors

    Emergency! How do I boot users out of my tables

    I am trying to update my tables, but there are a bunch of users using them. How do I boot them out with one command in Analyzer Thanx in advance
  5. robmoors

    IIF IN A VIEW QUESTION

    Can I put a IIF statement in a VIEW like I can in Access query? If I can, can you give me an example, if not what do I use to replace the IIF statement. Thank you in advance.
  6. robmoors

    DTS Designer Error

    That is the error: It comes up in a dialog box "DTS Designer Error" with the OK button in the middle.
  7. robmoors

    DTS Designer Error

    Why am I getting a DTS Designer Error when I am trying to start a new DTS package. I am running NT 4.0 sp6 PIII with 128mRAM, SQL2000 SP2. I've uninstalled and reinstalled. I get this message on 2 machines. Thanx in advance
  8. robmoors

    CASE statment syntax error

    Please tell me what's wrong with this code, I am getting a syntax error. SELECT CASE CCur(DTSSource(&quot;Bal Prin&quot;)) CASE < 5000 DTSDestination(&quot;BALANCE_IND&quot;) = &quot;<5K&quot; CASE >= 5000 AND < 15000 DTSDestination(&quot;BALANCE_IND&quot;) = &quot;>5K < 15K&quot; CASE...
  9. robmoors

    How do I create a mass update query?

    Thank you Dave, you've been alot of help. One more thing. My code reads like this: USE myView Do While .T. REPLACE myView.oldDays with 100 SKIP IF EOF() EXIT END IF END DO Now when I browse in the view after, I see that the changes were made, how do I make those changes update on the table. I...
  10. robmoors

    How do I create a mass update query?

    I am new to Foxpro and new to SQL. I don't have problems using SQL to update a single table, but what if I am trying to update data in table A from the data in table B. I am experienced in Access and do this all the time. Here is the code in Access: UPDATE tbl_inventory INNER JOIN...
  11. robmoors

    Problem with my ODBC Connection

    I've been connecting to my Foxpro tables from Access via ODBC connection. I am using the Visual Foxpro Driver 6.01.8629.01 to connect. It has been ok for a while until lately when I click on the a Foxpro table (via ODBC) in Access, it locks up. Can anyone tell me what's wrong?
  12. robmoors

    What's the equivalent of Access's Switch(,,) statement

    Thanx for the help
  13. robmoors

    getting a queries criteria to lookup a value in a form

    You need to set up a sub-form and place it inside your main form. Attach your backend query of course to your sub-form. If you are looking up values in your front-end database and you want you BE to lookup values based on a FE value, then in the criteria for your BE query, put in: [FORMS]![FE...
  14. robmoors

    query problem

    You're not very clear with your question, but let me take a stab at it. I believe your wanting to extract students from class x which is in one table, and class a,b, and c which are in seperate tables themselves. Many ways to skin a cat. Here's one one: Create a new make table query: Create a...
  15. robmoors

    What's the equivalent of Access's Switch(,,) statement

    Can someone please tell me what's the equivalent of Access's Switch(,,) statement in Foxpro. I know the IIF statement but not the Switch.
  16. robmoors

    Don't understand Query vs View

    Can someone please tell me the difference between a query and a view?
  17. robmoors

    Security - limit access to forms within db

    There are several things you can do. I don't know how much experience you have, but I will start from the easy (less secure) level and work my way up. 1. Click on tools and click on start-up. Set which form you want to start and disable some of the features like the full database window etc...
  18. robmoors

    Please help with cannot find linked table problem

    I have two tables linked via a ODBC connection. Both tables come out of the same Visual Foxpro DB. I create a new query in Access and try and link the two tables mentioned here, and I get a cannot find either table error. However, when I connect to my Access tables with one or the other table...
  19. robmoors

    Help! Unique key violation

    I am trying to append from one table using the APPEND FROM command. My destination table has an account number set to a primary key and I want to keep it that way. During appending, it stops I guess when it sees a duplicate value. My error code is 1884- account number key is violated. How do I...
  20. robmoors

    Cannot create instance of DTS Package

    I am new to sql7. I am trying to import Access table and I am getting a &quot;Cannot create instance of DTS Package&quot; error every time I get to the end of the import wizard. Please help

Part and Inventory Search

Back
Top