Search results for query: *

Can someone please tell me if I'm correct or incorrect with repect to Deleted=Yes/No in a Connection String: Deleted=Yes: Deleted records are ignored. Same effect as command SET DELETED ON Deleted=No: Can access all records. Same effect as command SET DELETED OFF Plus, a question: what's...

VB6 app using the VFPOLEDB Driver to work with free tables (.DBF files). Three such tables, each opened on its own Connection when the app is run and remain open. The following code works on one of the Connections: conn1.Execute ("USE IN SELECT([GHM_V70])") conn1.Execute ("PACK GHM_V70") In...

VB6 application named GHM using the VFPOLEDB Provider with a dBase database file named GHM_V70.DBF. conn1 is Connection String; rs1 is Recordset; PA() is an array of field values. There are 87 fields in each record. The following code for record updates (used versus rs1.Update) works...

As Windows is fully entrenched and DOS is on its way to history, I am curious about how many Clipper apps are in use today running as a DOS app under Windows. Does anyone have an estimate? Also, does anyone have an estimate of how many Clipper apps were in existence at the "peak" of Clipper...

Newbie here with perhaps a fundamental problem that I can't seem to resolve. In one part of my application I open a connection to a specific file (free table) and a recordset associated with that connection -- and leave the connection and recordset open. In another part of the application I...

I'm back - same Visual Basic application using ADO and a VFPOLEDB connection. The application does not have a database (.DBC), just free tables (.DBF). I'm trying to Pack one of the tables with the following code. rs1.Close 'Closes the recordset related to the table Set rs1 = Nothing...

In the thread "How To Create a Candidate Key?" the following problem was discussed: - Visual Basic application using ADO - VFPOLEDB Connection - Free Table (GHM_V70.DBF) with 87 Fields in Recordsets - Recordset updates via rs1.Update failed because the generated Update command is too...

I have a Visual Basic application that uses the Visual FoxPro Driver to manage .DBF files (tables) created by Clipper. These tables are "free tables" and thus cannot have a Primary Key assigned to them. Can someone provide the code to create a Candidate Key? Thanks.

It looks my inclusion of the "too-wide" FoxPro Trace data and my attempts to expannd the Window have screwed up the forum page preentation with the effect that the Reply section is unusable (what else is going to go badly with this thread?!) I'm starting the new thread to continue the...

I'm developing a Windows application (VB6) that will use a Clipper .DBF database. I've discovered that one of the field names conflicts with a reserved word in the database driver I'm using in the Windows application. How can I use my existing Clipper program to create a copy of the database...

With VB6 how can I get (see) the complete SQL statement generated when I update an ADO recordset? Thanks.

Our VB6 app uses the Visual FoxPro Driver (6.00.8167.00) to work with a .DBF database. A recordset is created via rs1.Open "SELECT * FROM......" We then fill an Array with the 87 recordset fields and do record processing in the Array, which results in some (not all) changes of the original...

It appears that some DOS apps and the Command Prompt cannnot be run full screen under Windows Vista. A Microsoft KB article (926657) describes the situation and attributes it to the fact that Vista device drivers do not support all of the DOS video modes. The recommended Workaround is to...

Somehow in the process of moving to a new computer I have lost my CT2.LIB file. Thanks

We have a Clipper application running under Windows that is set to run in full-screen mode via the Screen Tab in the Properties of the program's Desktop Icon. Thus, the program never runs in a window. Exit from the program is controlled by a password. Although we offer a special keypad...

We have a DOS application that is set to run in full-screen mode via the Screen Tab in the Properties of the program's Desktop Icon. Thus, the program never runs in a window. Is there any way with the program running that the Windows Desktop can become exposed with the running program's icon...

I have a folder with multiple .JPG files that were written to CD via XP's "Write Files to CD" feature. When I insert the CD I select the option to "View as Slideshow with Windows Picture and Fax Viewer." When I click the OK button nothing happens and nothing show in Task Manager. What's up???

Perhaps this is an elementary (or dumb) question, but is there a practical way to create more than one copy of a project and keep the copies independent? Specifically, I used "Save As" with a new name to create a second copy of a project. But, whenever I update forms or code in one copy the...

I've discovered the Microsoft KB article (84269) that says that the ForeColor property of the Printer object "was not fully implemented" (and still isn't) and that the Windows API function call SetTextColor() must be used. I've used the following code in a new project as instructed by the...

We have a Windows Screensaver (3D Text) working well in terms of timing and lack of hangups. When the screensaver kicks in with an active native-Windows app running, the return from the screensaver (as expected) is to the app's window on the Desktop. However, for a DOS app running full-screen...