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 Chris Miller 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. Tore Bleken

    a little confused about the transform() function problem

    In this case, instead of Select ... norekening ... from ..., you write Select ... cast(norekening as char(13)) as norekening ... from .... This will make sure that the field is returned as a string, and your problem is gone.
  2. Tore Bleken

    a little confused about the transform() function problem

    First of all, VFP can't handle such numbers, period. And it's no use to store it as a number anyway, you don't do any calculations with it. So just learn from our experience, and use a string, C(13), instead. If it's stored on a SQL server as a number, and you don't have any control of it, then...
  3. Tore Bleken

    a little confused about the transform() function problem

    The coding looks fine, but you must use the right data type. In this case 1312124120052 is NOT a number, it's a string. From VFP's help, https://www.vfphelp.com/vfp9/_5wn12pc8v.htm: Maximum value of an integer: 2,147,483,647
  4. Tore Bleken

    a little confused about the transform() function problem

    I think the problem is that the number is bigger than VFP can handle. Try this formula instead: Update: Store the value as a string instead, c(13), since that's what it really is. Then you can use
  5. Tore Bleken

    a little confused about the transform() function problem

    Make the fields in the report a little wider. Having said that, the expression "999.99.9999.9999" looks weird. What's the point of that expression?
  6. Tore Bleken

    wwIPstuff - Ionos not accepting Date: header value

    Rick usually don't answer such questions on email. He wants people to use his message board, so that others can read his answer, and search previous answers. That's why the tab on his website is called Support, should be easy to understand. I think that's the correct way to give support...
  7. Tore Bleken

    wwIPstuff - Ionos not accepting Date: header value

    I refuse to believe that the message was refused because of the two characters. Most likely it was something else. And you write that you wrote to West-Wind with no answer. Did you follow the normal procedure, which is to post the question on the message board? Rick is well known for giving...
  8. Tore Bleken

    wwIPstuff - Ionos not accepting Date: header value

    Why isn't this question posted on West-Wind's message board where it belongs?
  9. Tore Bleken

    Oplock when installed on local pc but data is on network server?

    "Why do you feel the need to insult me?" Because someone always knows best, and always want to have the last word. That's the main reason why I have stopped posting on this forum. That, and the huge number of trolls here. Forgive me, I mean people who hide behind a stupid alias instead of using...
  10. Tore Bleken

    GETWORDCOUNT () IN VFP 6.0 ?

    VFP6 comes with a utility called Foxtools.FLL. Set Libary to Foxtools.fll additive ?Words(lcText)
  11. Tore Bleken

    GETWORDCOUNT () IN VFP 6.0 ?

    VFP6 comes with foxtools.fll, and this FLL has a function called Words. Set library to foxtools.fll ?Words(lcText)
  12. Tore Bleken

    Help with ActiveVFP

    https://webconnection.west-wind.com/
  13. Tore Bleken

    COPY TO command results in all lower case

    https://www.berezniker.com/content/pages/visual-foxpro/copy-move-rename-file-preserving-destination-name-case
  14. Tore Bleken

    Is there anyway to contact/talk with someone with sharescreen?

    I don't need any third person's assistance. My email address can be decoded from firstname(at)lastname(dot)no. And note, I'm bold enough to use my real name. If that's not acceptable, and this message also gets deleted, I take the hint.
  15. Tore Bleken

    Is there anyway to contact/talk with someone with sharescreen?

    Yes, I and probably others as well, can assist you. But unless the administrators on this forum restores my earlier message, they show that they won't let us. And if that doesn't change, this will be my very last message on this forum. Luckily for you, there are other FoxPro forums with fewer...
  16. Tore Bleken

    Is there anyway to contact/talk with someone with sharescreen?

    The censorship on this forum is just as bad as it was before I left it for several years. Unless my deleted message is restored, I'm out of here for good. I guess this message will be deleted also....???
  17. Tore Bleken

    How to change caption color only for active page of a pageframe?

    Put it in the PF's Refresh() method.
  18. Tore Bleken

    Doug Henning's Project Manager for VFP

    I guess you mean his Project Explorer? https://github.com/DougHennig/ProjectExplorer
  19. Tore Bleken

    Not showing Form in design mode

    You must have the form open for editing when you run the command. If no success, can you upload the form?
  20. Tore Bleken

    Not showing Form in design mode

    Looks like you need to move the form to the right, since the left border is outside the IDE. Or run this command from the command window: Move Window "Form Designer - xxx.scx" center Replace xxx with the name of your form.

Part and Inventory Search

Back
Top