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 Rhinorhino 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. Dan Freeman

    equivalent of SPACE(2) in an SQL command needed

    Did you mean Cast()?
  2. Dan Freeman

    File access is denied

    Your problem here is that CLEAR EVENTS is being blocked from properly exiting your application. You've somehow created an object reference to a form or some other object (in a public variable, member of _Screen, whatever) that cannot be released when CLEAR EVENTS tells all programs to stop...
  3. Dan Freeman

    Writing Calender appointments to Exchange 2016

    It's been 20 years since I brushed up against Lotus Notes. At that time a consultant recommended to us by a VP at Lotus told me "you'll never be able to get data from Notes without a custom API I'll write for you". Phooey on that. The day they installed Notes on my computer I started...
  4. Dan Freeman

    Code text appears on a Form

    REINDEX But that's pretty much the only time I've used it in the last 25 years. [pipe]
  5. Dan Freeman

    JOIN without .NULL.

    NULL actually has meaning, depending on the circumstances. In a system logging results of medical tests, an empty numeric field will evaluate as numeric 0. What if the test was not administered that day? The 0 skews averages. A NULL in the field indicates no result for that day. This was...
  6. Dan Freeman

    Silly question

    Guys, the INDEX syntax listed above: index on sono+STR(lineno,4)to sono1 Syntax error aside, this will not create a CDX. It will create a standalone IDX. This shouldn't upset an existing application's CDX files. HOWEVER, if the existing application expects IDX files all bets are off. I'll...
  7. Dan Freeman

    JOIN without .NULL.

    Nulls are NOT empty. They have meaning in truly relational databases. SET NULLDISPLAY was introduced early in the FB implementation of NULL to help us "cheat" the use of actual nulls. It's better to change your query (as Tamar showed) to avoid null in the result than to alter your data or the...
  8. Dan Freeman

    pass data from foxpro to word document.

    Yeah, this is a very ambiguous question that MIGHT be answered by setting up a simple mailmerge in Word. More feedback is needed for anyone to be of any help at all.
  9. Dan Freeman

    Moving shortcuts on desktop with VFP9

    If the user has Windows set to its default (auto-arrange) you shouldn't mess with it. Desktop arrangement belongs to the user.
  10. Dan Freeman

    VFP Won't Start in Windows 10

    There may not be any visible place to type on screen, but that's only because it got moved off screen. It's still there as you've found. Glad to hear it helped!
  11. Dan Freeman

    VFP Won't Start in Windows 10

    After you start it, try MOVE WINDOW SCREEN CENTER MOVE WINDOW COMMAND CENTER (Type carefully)
  12. Dan Freeman

    Need help understanding a piece of code

    It started in dBase so of course it's valid. You can even use it for object references: WAIT WINDOW THISFORM->CAPTION It's just SO much harder to type than . [pipe]
  13. Dan Freeman

    Directory validation

    You *might* get better performance using fcreate() trying to create a file there, but failure wouldn't actually tell you whether the directory exists. You just might not have rights. The long hang isn't coming from Foxpro. It's just waiting for the operating system, and Windows has a long...
  14. Dan Freeman

    Editing a Memo field using a TextBox

    Use an edit box instead. If you want it to look like a textbox, size it appropriately and turn off the scrollbars.
  15. Dan Freeman

    Missing Cursor

    Terminology will slay us all. Technically, that blinky vertical line is called the insertion point, not the cursor. Likewise, that arrow thing-o you drag around with the mouse isn't a cursor either. It's a pointer. Remember what Henry Higgins said of English: In America they haven't spoken it...
  16. Dan Freeman

    While I Was Away...

    Same here. (With dbf corruption as well.) But I've had clients who can seemingly corrupt them at will. [glasses]
  17. Dan Freeman

    While I Was Away...

    You should be using Stonefield Database Toolkit. It maintains metadata about your structures and indexes and handles "pack & reindex" for you.
  18. Dan Freeman

    Unusual order behavior

    Olaf, it's true that only the scope will be optimized. But remember that every scoped command has a default scope. The default scope for REPLACE is NEXT 1. The default scope for REPORT FORM is ALL. The default scope for SCAN is ALL. So, really, the command is always scoped.
  19. Dan Freeman

    While I Was Away...

    When you want a permanent collection of index tags that may or may not be up to date. [shadeshappy] The whole mechanism came about when some people complained about being FORCED to use the structural CDX during early alpha/beta cycles when the feature was new. I've never used a second CDX. If...
  20. Dan Freeman

    Unusual order behavior

    SCAN/ENDSCAN has another advantage Mike didn't mention. It's subtle. The command is scoped. That is, it supports FOR, WHILE, REST and NEXT <N> as part of the command. That makes it "set-oriented" and it also makes it Rushmore optimized. It's so doggone useful I can't remember the last time I...

Part and Inventory Search

Back
Top