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

    SELECT SQL and free tables

    In summary, your problem is not a question of whether your SQL SELECT is failing because you are using free tables vs a database container. Your problem is understanding the syntax of the JOIN condition. ...JOIN ON TableName1.FieldName1 = TableName2.FieldName2. As mentioned earlier, you...
  2. Joe Crescenzi

    SELECT SQL and free tables

    When a SQL command is run against 2 or more tables, you have to ensure each field / column is unique so the parser knows which one you are referring to. So, if a field exists in both tables, you need to specify the table or alias every time you use it, not just in the column list as you showed...
  3. Joe Crescenzi

    SELECT SQL and free tables

    If your SELECT commands are not working, it's because VFP can't find your tables, so you can either configure a path or open the tables before calling the SELECT. Technically, you can also include the path in the SELECT (SELECT * from MyFolder\MyTable), but that's bad code.
  4. Joe Crescenzi

    Is there an equivalent of "AfterRowColChange" in Listbox control?

    100% correct. ProgramaticChange is another important variation on potential triggers. I just wanted to let the Rajesh know the primary reason they are not exactly interchangeable and why there is no AfterRowColChange event in a ListBox because there are no rows or columns. As you said, a grid...
  5. Joe Crescenzi

    Is there an equivalent of "AfterRowColChange" in Listbox control?

    The interesting point about AfterRowColChange is what "Change" means. It's not necessarily the value of a row or column that changed, but that your physical navigation position changed. When you scroll through a Grid, your focus moves from row to row (record to record in a table or cursor), or...
  6. Joe Crescenzi

    Is there an equivalent of "AfterRowColChange" in Listbox control?

    For the record, InteractiveChange isn't the same as AfterRowColChange because it's only triggered when the control is changed, not when a row changes, but in your case, you said you wanted it to trigger when the user scrolled the values in the control. The nice benefit of this is that those...
  7. Joe Crescenzi

    Is there an equivalent of "AfterRowColChange" in Listbox control?

    Try InteractiveChange.
  8. Joe Crescenzi

    Combobox not populated with array

    I was referring to adding the REFRESH() directly after the code you use to add the items to the control.
  9. Joe Crescenzi

    Combobox not populated with array

    Just a thought. I didn't read the whole thread, but if the control is completely empty, perhaps you also need to add a REFRESH(). Even with the wrong parameters for the array elements, it wouldn't be empty. You'd see numbers or even a bunch of blank lines.
  10. Joe Crescenzi

    Window displaying differently outside VFP environment

    Since every user can have different screen dimensions and resolutions, it's best to design user interfaces with forms and avoid absolute screen coordinates entirely. Forms can make things quite a bit easier, but we still need to be mindful of whether they will fit on a user's screen and what...
  11. Joe Crescenzi

    Window displaying differently outside VFP environment

    I agree, if it's a new project, so I assume he is trying to just maintain something written before Windows, so there are a bunch of @ SAY/GET or ? lines. As for me, I still define Windows from time to time when I want a BROWSE window or a REPORT FORM to take up a specific space.
  12. Joe Crescenzi

    Window displaying differently outside VFP environment

    As a rule of thumb, I don't define windows using absolute coordinates for both dimensions, especially when they're on the screen because the FROM and TO coordinates are dependent on the font size of the screen itself. So, to ensure the window is large enough for whatever you are putting into it...
  13. Joe Crescenzi

    website URL validation in a text box

    We're used to finding ways to work with depreciated products, after all, VFP was discontinued ages ago. The funny thing is Microsoft has a lot of products that use VBScript, including Excel, so it will probably take a while before they pull the plug entirely. Microsoft suggests a few...
  14. Joe Crescenzi

    website URL validation in a text box

    The Swiss Army Knife is definitely the better tool, by a wide margin. That said, since the original request was for a potential RegEx solution, it's potentially more than the OP needed. I've used similar approaches to validate just email addresses, where I need not know if the mailbox exists...
  15. Joe Crescenzi

    website URL validation in a text box

    Valid points. I'd be more inclined to use your suggestion of IsValidURL to just confirm the formatting, but the bored developer inside of us finds it fun to build something that does more than it needs to. It's like asking an engineer to make a flathead screwdriver and they build you a Swiss...
  16. Joe Crescenzi

    website URL validation in a text box

    That's probably all that's needed. If Ravi's goal was just knowing a URL is formatted correctly, the function should return true even if the domain doesn't even exist.
  17. Joe Crescenzi

    website URL validation in a text box

    It's not up to me, it's up to the OP. Remember, all Ravi asked for is validating that it's a valid URL format. If that's the only criteria, even a redirected, unavailable, or Bad Gateway means the URL was formatted correctly.
  18. Joe Crescenzi

    website URL validation in a text box

    Good idea. By reading just the HEAD, you have the potential to speed it up if the URL returns a lot of data. My only suggestion is that if the main objective is knowing if the URL is good, I wouldn't return loException.Message, I'd make it a consistent value such as "* INVALID *", or simply...
  19. Joe Crescenzi

    website URL validation in a text box

    The basic structure of a URL is pretty basic, so I'd start by using what Chriss said, checking to see if http://, https:// are at the start (you can add ftp:// if you want to support it). Beyond that you can check to see if there is at least one period before the presence of either a slash or...
  20. Joe Crescenzi

    How to supply filename when doing SET PRINTER TO NAME "Microsoft Print to PDF"

    As I mentioned, I use XFRX these days, but as far as I know it will just follow whatever dimensions are in the report file. They have a free version, so give it a try and you may not need to explore other options. That said, I've been using XFRX for decades and it's never let me down. What...

Part and Inventory Search

Back
Top