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

    Do I really need AD or a Domain?

    Not sure if i read the question correctly, but we have vpn setup on windows 2000 server and we only use a workgroup. Our only problem is that our gateway only allows 1 vpn pass though at a time. Hope this helps..
  2. yostyid

    XP Pro/Linux Machine

    If it is a current release of red hat (or fedora) there should be an option to install into free space on the xp drive. If not a tool like partition magic makes it easy to create new partitions for Linux. I think a lot of people do it differently, but I would try something like: 1.) a root...
  3. yostyid

    odd packet reports...

    I was hoping it was just a confused driver too. The only thing different about the kb is that the sent is so high while the received seems normal. I will see if there are new drivers out there. Thanks.
  4. yostyid

    odd packet reports...

    hey there, So I have a windowsXP Home machine that is showing some odd results for sent packets. When I view the connection status, it says huge numbers of packets are being sent, none are being received (in an idle state.) For instance, right now it is showing an uptime of 10 minutes and...
  5. yostyid

    ado connection wont execute vfp

    So I am trying to connect an excel 2000 spreadsheet to foxpro7. I can return a recordset ok, but writing to the db is odd. I can do.. dbconn.execute "create table test(testcol text) and it will be done. But if I try to exec ute a procedure or create a view, it fails. Here is my code...
  6. yostyid

    connect excel and vfp

    the problem is that this isnt exactly the recordset that I want. I have made a few changes. This view was only a test to try and see if I can write to the vfp container. Essentially I have created a procedure in vfp. the procedure will create 5 cursors (rather than views) 4 of the cursors...
  7. yostyid

    connect excel and vfp

    I am having trouble connecting to my odbc foxpro database to create cursors or views. here is (basically) the code: public cn as database public strBOM as string strBOM = "create view bomsql as SELECT * from inventor;" set cn = opendatabase("db", dbDriverNoPrompt, False...
  8. yostyid

    Limit User Email Options

    you can actually pull the postoffice files off of a winnt disk, maybe even 98. I fould it through google. If you cant let me know and I'll find the exact files for you..
  9. yostyid

    opening *exe's over a network.

    Whenever I try to open an app on our internal network, it asks if I want to open or save and reminds me that programs can contain malicious code. The checkbox for "always ask" is dimmed so it does this every time. As much as i appreciate the concern, I dont want to do this every time...
  10. yostyid

    vfp sql help

    i just got the same error. shoot. I was testing in MS SQL2000 on a test table. Didn't work as well on the real table in vfp7. I guess you cant do a sub in the select in vfp??
  11. yostyid

    vfp sql help

    Thanks for your input. The two views worked great, but I was shown another way that worked as well with a subquery: ********* SELECT a, b, (SELECT SUM(b) FROM Table1 t2 where t2.a =t1.a and t2.b=t2.b) SM FROM Table1 t1 Order by a,b ****** Thanks again. justin
  12. yostyid

    view, sum help

    Thanks for your help checkai. I think Sunila7 has just what I was thinking about. Thanks!
  13. yostyid

    view, sum help

    I believe group by will collapse this example from 4 tuples to 2. I need all 4 to show.
  14. yostyid

    view, sum help

    I am trying to create a view with 3 col's. I need to find a way to sum column "b", but only for rows that have the same value in column "a" ie: a b sum 1 3 5 1 2 5 2 1 3 2 2 3 I cant figure out how the query will work for that. I am figuring a subquery, but...
  15. yostyid

    vfp sql help

    I am trying to create a view. I need to find a way to sum column "b", but only for rows that have the same value in column "a" ie: a b sum 1 3 5 1 2 5 2 1 3 2 2 3 I cant figure out how the query will work for that. I am figuring a subquery, but any help or...

Part and Inventory Search

Back
Top