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

    VFP Remote Views of MS SQL data - Can this be done?

    I have 2 MS SQL tables, that I access through VFP using remote views. Parent table ID - Unique ID Field (default value at SQL level is NEWID()) Name - Name Child Table ID - Unque ID Field Name - Name FKParentID - ID from Parent. In VFP, using my remote views, with buffering, I would like to...
  2. samoody

    TABLEUPDATE problem with remote view to SQL data

    I figured it out... I believe the problem was.... My SQL table had 114 records. My remote view only was pulling 100 records at a time. Therefore when I tried to do a tableupdate, I received a connection is busy error, because it was still in the process of retrieving records. When it was...
  3. samoody

    TABLEUPDATE problem with remote view to SQL data

    Thanks Mike... Hope this makes things a little clearer. The Data is stored in Microsoft SQL Server. The 'SQL Where' clause is set to key fields only. The TABLEUPDATE(0,.F.,'formsview') statement returns TRUE sometimes and FALSE other times. Would issuing a TABLEUPDATE twice help in this case?
  4. samoody

    TABLEUPDATE problem with remote view to SQL data

    We have a program that updates SQL data through a remote view. Inside a PRG, the remote view is opened and then buffered CURSORSETPROP("Buffering", 5, "formsview") The correct record is found and then a field in that record is changed and then updated using… TABLEUPDATE(0,.F.,'formsview')...
  5. samoody

    Index on Buffered table

    Thanks for all your posts... but I'm still not able to solve my problem. I have narrowed it down some.... Below is a paraphrase of my code. SCAN && table1 SELECT table2 LOCATE IF SEEK(table1.field1 + table1.field2) REPLACE field3 WITH table1.field3 + field3...
  6. samoody

    Index on Buffered table

    This is so, even if the buffered changes are not to any of the fields in the index expression?
  7. samoody

    Index on Buffered table

    I'm having a problem with a SEEK in a buffered table. (VFP 8.0) The SEEK is returning a .T., but the record that is found, isn't matching the expression being seeked. The SEEK command is being performed hundreds of times (it is in a loop), but this problem only occurs once. The table in...
  8. samoody

    MCP Exam for VFP Desktop Applications

    I am scheduled to take this exam at the end of this month. I have been developing in FoxPro and Visual FoxPro in a business environment for 5+ years. I have gone through the VFP Certification book published by Henztenwerke. But, I am still worried that I may not be fully prepared. I read...
  9. samoody

    Word - Losing Borders when printing from a macro

    Thanks for your response. We are using the generic Distiller driver that comes with Adobe. We have it configured the way we want and everything works properly when a file is manually 'printed', but not when the macro is run. I have tried printing it to another driver, then changing it back to...
  10. samoody

    Word - Losing Borders when printing from a macro

    I am a VFP programmer trying to debug a problem in a word macro... I have a Word Basic (Office 2000) macro that creates PDF files from Word. The way this is done is by using an 'Adobe Distiller' print driver, which instead of printing to a printer, creates a PDF file from the document. This...

Part and Inventory Search

Back
Top