Recent content by robmoors

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

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

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 :>

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

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.

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

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

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...

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...

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...

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?

Thanx for the help

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...

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...

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.