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. 205xld

    isnull() inconsistency in result

    Epilogue: My colleague reported the issue to HXTT and they seem to have successfully resolved it overnight. Nice to be able to report good support from a driver provider! Regards Graham
  2. 205xld

    isnull() inconsistency in result

    Thanks Olaf. Great explanation. Thanks to everyone else too for their help.
  3. 205xld

    isnull() inconsistency in result

    Hi Mike Not sure what 'those cases' are but this isn't one of them [smile] - no change. Do keep the suggestions coming though! Regards Graham
  4. 205xld

    isnull() inconsistency in result

    ...on CLOSE TABLES all SET DELETED ON SET SAFETY OFF cData = '\\Oxford9\system\test\sas\data\' USE cData + 'cmsmsg' IN 0 exclusive SELECT * FROM cmsmsg ; WHERE ISNULL(clsendid) ; INTO CURSOR curGoodNulls SELECT * FROM cmsmsg ; WHERE ISNULL(clsendid) = .T. ; INTO CURSOR curAllNulls...
  5. 205xld

    isnull() inconsistency in result

    ...OK when I browse the table, but some other code fails to read the data and I've resolved a test that identifies the 'broken' records: SELECT * FROM cmsmsg ; WHERE ISNULL(clsendid) ; INTO CURSOR curGoodNulls SELECT * FROM cmsmsg ; WHERE ISNULL(clsendid) == .T. ; INTO CURSOR curAllNulls...
  6. 205xld

    Foxpro Startup

    Greg I've only recently had this very same problem, since I changed to using dual screens. I don't know whether it's possible to get the problem with other applications, but just in case, there is a windows solution as well which doesn't rely on using a Foxpro command. If you select the...
  7. 205xld

    'record is in use by another user' preventing updating a table

    Thanks for the response Tamar - I've been away so I only just got it. Yes, I'm checking the return on TableUpdate() and it's fine. Have you come across similar behaviour before?
  8. 205xld

    'record is in use by another user' preventing updating a table

    Help! Got a very strange problem. I have form with a Optimistic Table Buffered table 'Purch' in the data environment. I am the sole user of this app - it's running against a test database. I add a record to the table using the form, and run tableupdate(.T.,.T.,'purch') in a transaction to...
  9. 205xld

    can't set focus on control - page click fires instead

    Hi Folks. Panic over - thanks for your help. The solution was straightforward (isn't that always the case?). There was a relation set between the controlsource table of the textbox (a child table) and another master table. I was creating a new record in the master table without a...
  10. 205xld

    can't set focus on control - page click fires instead

    Dave - there is code in the Page1.click() method, but not in the txtmanufact.click()
  11. 205xld

    can't set focus on control - page click fires instead

    No, I'm afraid not. I'm using VFP7 - I think bindevent() is on 8 or 9 isn't it?
  12. 205xld

    can't set focus on control - page click fires instead

    I'm up against a tight deadline and completely stuck. Can anyone help? I have a textbox (txtmanufact) on a page (page1) that I cannot seem to get focus on when running. The control is enabled and shows the tooltip when you mouse over it, but when you try to put the cursor in the textbox the...
  13. 205xld

    Buying a copy of VFP7

    Thank you all for your help. Luckily I managed to find someone in the firm who had a copy from a couple of years ago in the back of a drawer, so I'm OK now. Useful info about downloads from MSDN - I'll look into that. Regards Graham
  14. 205xld

    Buying a copy of VFP7

    I believe so. If it's an MSDN 'volume licence key' (i.e. not printed on and specific to just that one disk) I should be able to find it in with the rest of the MSDN disks. Why do you ask?
  15. 205xld

    Buying a copy of VFP7

    Does anyone know where I can buy a copy of VFP7? Our software bloke has managed to mislay our MSDN installation disk and I can't seem to find anyone still selling this version. I'm located in the UK, so either international distributors or UK distributors please. Please don't just tell me...
  16. 205xld

    Messagebox message truncated

    Just to avoid a reputation as a complete numbskull, I'd like to point out that VFP7 (which I'm using) Help only says: "eMessageText Specifies the text that appears in the dialog box. Use a carriage return (CHR(13)) in eMessageText to move a portion of the message to the next line in the dialog...
  17. 205xld

    Messagebox message truncated

    Hopefully an easy one for someone.... I'm reporting on some issues in a messagebox and the message is of variable length depending on circumstances. The sample I used was a 1700 char string. Unfortunately, the message is being truncated at around 1000 chars (haven't counted the exact number)...
  18. 205xld

    Weird behaviour - listbox 'burns' transparent hole in page in front

    OK folks - Thanks to both of you for your feedback. Shame such a small anolmaly will cause so much extra work..... c'est la vie I suppose. No more mode switching for me.
  19. 205xld

    Weird behaviour - listbox 'burns' transparent hole in page in front

    Oh dear, I don't like the sound of ("I'm surprised it's working at all")! I have a Desktop with buttons to open different forms. Each form allows view/add/edit of different system objects (e.g. 'consumer', 'job', etc). I want the user to be able to open several forms at once to view them...
  20. 205xld

    Weird behaviour - listbox 'burns' transparent hole in page in front

    The last few lines of code before the probelm are: thisform.setbuttons() thisform.LockScreen = .F. thisform.Refresh() thisform.xstdtools.setmodeless() (the setmodeless() methods being as described above). One more bit of info - if I move the 'refresh()' to BEFORE the 'lockscreen = .F.', the...

Part and Inventory Search

Back
Top