Search results for query: *

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

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

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?

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')...

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

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

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

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

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

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