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

    Need Permission to Execute Stored Procedure?

    Thanks, SQL Sister. In comparing the remote and the local db's, I noticed that the admin of the remote db created a separate user account for the app's login user id, while the local db has only public and... I forget the other one. So, I'm guessing (I told you I was a newbie) that on the...
  2. seadriver

    Need Permission to Execute Stored Procedure?

    Sorry, you're right, of course. Still need an answer to the original problem...[ponder]
  3. seadriver

    Joining tables (or other methods)

    If you need all rows from the ItemTable, and there's a possibility that some items don't yet have a price history, then you have to do an outer join with the PriceTable, something like: select its.itemid, its.storeid, its.descr, its.onhandqty, pt.price, pt.EffectiveDate from ItemTable its...
  4. seadriver

    Need Permission to Execute Stored Procedure?

    The "set" line is in the actual code; I mistakenly deleted it when I abstracted the code to present my problem. Thanks anyway!
  5. seadriver

    Need Permission to Execute Stored Procedure?

    Hi guys and gals, Sorry for the newbie-type question, but I haven't found the answer elsewhere. A company I do some work for recently relocated one of their databases to a remote server, which we access through SQLOLEDB, with the IP address as the data source in the connection string. I...
  6. seadriver

    Rewrite an old app in FoxPro 3.0 or Newer

    Hi Mel, The learning curve was pretty steep going from 2.6 to 3.0, and will be even steeper going to 8.0. On the positive side, 8.0 is apparently stable, whereas 3.0 was pretty much unusable (I called it much worse things than that at the time! ;-)) Here are a few things I learned while...
  7. seadriver

    SQL works fine unless data is missing in one table

    I'm not ramani, but I'll try to help a bit. 1) Because you are using the SQL JOIN syntax, as opposed to, ummm... whatever they call the "from table1, table2, etc." syntax. In SQL JOIN syntax, the table names go to the left and right of the JOIN command, which can be INNER JOIN, LEFT...
  8. seadriver

    Deleting data from my table

    Hi Tom, In the old days, when file header corruption was more of a problem, we would typically create a new file, delete the old one, then rename the new one, rather than use ZAP or DELETE ALL, PACK: use temp copy stru to temp2 use delete file temp.dbf rename temp2.dbf to temp.dbf Of course...
  9. seadriver

    advice upgrading 2.6a to VP8

    As Dave says, your programs will probably run fine, although what you want to run are the .prg's, not the .fxp's. VFP 8 may automagically recompile them, but if not, just delete the .fxp's so that the .prg's get recompiled. Also, as Dave says, if your add-on programs have an interface of any...
  10. seadriver

    Corrupted index , MS sql , Foxpro or Access?

    If the information contained in the reports is not correct, then it sounds like the indexes are not being updated as you enter new information. If your indexes are really "corrupt", I believe you would trigger a FoxPro error when you opened them. So... do you get an error, like...
  11. seadriver

    Displaying Integers/real values as strings(VFP8)

    Jim, I don't have VFP 8, so I can't verify that the "As Integer" is supported, but this syntax works just fine in VFP 6 as well. I believe that the parser ignores everything after the variable name. You can prove this by compiling this: local lInt As whatchamacallit Compiles fine...
  12. seadriver

    Displaying Integers/real values as strings(VFP8)

    Wow, my first star! [smile] Thanks! Jim, my point is that 10.00 is a real number that happens to round to an integer value. They're not the same thing, and sometimes you want to treat/display them differently.
  13. seadriver

    Displaying Integers/real values as strings(VFP8)

    Transform() works fine here, automagically dropping the decimal points if a real number rounds to an integer. But there may be instances where you want to display a real number of value 8 as "8.00", rather than "8". Due to xBASE's loose typing, I don't believe it's possible...
  14. seadriver

    VFP Version You're Using

    Thanks for all the replies; I greatly appreciate it. I'm glad to hear VFP 8 is more stable than 6.0, although I didn't have many problems with 6.0 apps crashing or locking up. VFP 5.0 seemed a little less stable, and 3.0 was almost unusable. Thanks again. It's great to know there's a...
  15. seadriver

    VFP Version You're Using

    Hi guys and gals, I've been away from the VFP scene for several years. The most recent version of VFP I've used is 6.0. Did you all upgrade to VFP 7.0, then to 8.0? Is 8.0 greatly different than 6.0, in either ease/difficulty of use or in available power? TIA!

Part and Inventory Search

Back
Top