Answer Questions

• ForgottenCoder Corrupted tables

  I have a word document, that every time I open, a table is corrupted. Wath is this How can I avoid it and repair thanks, sergio Hi Sergio, I'm confused. You mention a Word document. I assume the Word document has (Word) tables in it and you are having a problem with them. How is the FoxPro database and development tool (what this forum is about) involved in your problem ...Show All

• Michael McGaha Strategy for Foxbase/Foxpro prg files in VFP 9

  Hello all; I am redesigning an application written in Foxbase, and Foxpro to VFP9.0 There are lots of prg files that use Xbase commands. There are no screens, reports etc. Just prgs. Some of the functionality is going to be redesigned for VFP, but I am looking to run some of the PRGs in VFP with little modification. My questions is, what would you suggest as a strategy for doing this Since we are running also VFP forms, toolb ...Show All

• thiaygu feature not found

  This is the fourth inning. I am still struggling with an exec build. No luck so far. Now there is some help in the form of the error reporting authority of the error control. Unfortunately, for some strange reason only a small fraction of runtime errors are in the log file. I cannot understand why. But what I have seen so far is very revealing. The error message is "feature is not available" and the line in the source code is idenfi ...Show All

• arndawg How to insert images(pictures) into RTF control???

  I am not able to insert a picture in RTF control. I am using following code: thisform.rtfcontrol.oleobjects.add(,,"mypicture.gif","paint.picture") When I execute this command a picture viewer appears. When I close it a object with a title "mypicture.gif" appears in the RTF control. I want to see a picture not a name of the file without loading a picture viewer window. Thanks a lot. Hi You don't get ...Show All

• Whizman CRLF --chr(13)+chr(10)--> .Selstart Dilemmas in myEditBox

  MyEditBox.SELSTART CHANGES during keypress events, interactive change events and/or programmatic change events when line-feeds (LFs) aren’t paired with (CRs): E.g., ‘LineFeeds’ [chr(10)] …seem to… insert themselves after every ‘carriage return’ [chr(13)] during *certain* run-time keypress events. Likewise…COM imports (e.g., oWord values) don’t seem to have paired CRLFs in them, but CRs only. VFP-9 seems to *prefer* paired ...Show All

• Jani N Visual Foxpro free tables on remote server. Help.

  Hi, I get this error message; Exception Details: System.Data.OldDb.OleDbException: Invalid path or file name [OleDbException (0x80040e21): Invalid path or file name.] I have xp-pro with VS2003 installed. I save the application to a 2003 Server (that also has Sql Server with databases and IIS), and I have an older server, NT4, with a visual foxpro (free tables .dbf) accouning system on it. I created a form, WebForm_1 and co ...Show All

• mjt Writing our own code for the Print Button in the Report Preview toolbar VFP 9 using report listener.

  Hi, I want to call my own print dialog box in the print click of the report preview toolbar in VFP 9.0 using reportlisteners. i want to disable the base class functinality and write my own functionality in the button. -Venkat You may download complete sources for ReportPreview.App and modify it as you need : http://download.microsoft.com/download/f/c/c/fcc0a8ae-56d2-4950-a70b-0e77f4720b24/VFP9SP1_XSource.exe ...Show All

• OliSchwarz Assigning Data to a variable in a query

  I have a table that I want to query based on a Selected Record in a gridView.  I have the Record Number in GridView.SelectedValue but  I have no ide how to set up a query in here much less run it.  I need to know OldLine and oldItem from a table called items I mean I know "Select OldItem, OldLine from ITems where RecordNumber = " + GridValue.SelectedValue"   Sure hoped that worked but no...  As you can probably ...Show All

• Scott Ramuno i can't use movelast in ado

  Hi guys    i can use ado connect to local .dbf and sql server and get the data from it.but i found i can't use movepriveous,movelast function of ado object and also i can't get the recordcount ,any idea o=CREATEOBJECT("adodb.connection") o.ConnectionString="Provider=VFPOLEDB.1;Data Source=P:\test\data;Password='';Collating Sequence=MACHINE" o.Open() r=CREATEOBJECT("adodb.recordset") r.Open("select * from freetable1",o) r.recordcount& ...Show All

• Bassem Murad formset=>deployment=>etc.

  Hi there, As a part of an effort to deploy and application I have been trying to do a few tricks. They have been suggested previously by Cetin and Tamar especially. The code is placed in a .prg file. I tried a few things. oNewInstance = CREATEOBJECT('FormSet') oNewInstance.NewObject ("urls","form") <= secondary, child form oNewInstance.NewObject ("cPlusIntrnals","form") <= main form oNe ...Show All

• Mange Which one is faster, cursors, queries, local views, other?

  Hello, I'm using VFP 7 on a very old machine. I'm working with very large tables and I need to create a lot of queries, but my tables are so large it takes forever to load the results. I've been creating cursors on the run from SELECT statements but it's still very slow.... What can I do to optimize my queries/views so they are much faster... I'm new to this, so I don't know much... I just need to be able to run all this queries ...Show All

• Tyler Whitney VFP 9.0 SQL worthless under a non client server network?

  Hello everyone; I have posted this problem here and also on UT and no solution yet. I have a small network with a 2003 server, and XP pros. I am running vfp 9 select * from products where status = "S0000" takes apx 10 seconds when run over the network. When running this locally, it takes only a fraction of a second. The product table contains 100,000 records, and the result of the SQL command is just a few hundred rec ...Show All

• raja chilukuri Converted VFP 3.0 Project

  I have made a few changes to my 3.0 project and it seems to compile and run fine after compiling with 6.0 or 9.0. Is there any advantage to 9.0 like better compatibility with Windows XP SP2 or Windows Vista Thanks Yes. Alex is quit ...Show All

• bungalo101 Scan EndScan

  CLIENT table has a one to many relationship with the CHARGE table. Select CHARGE SCAN for CHARGE.client_fk = CLIENT.client_pk    **execute commands ENDSCAN How to prevent the commands inside scan..endscan from executing if no charges were found for a client There is nothing to add. You already do a filtered scan. ie: use employee scan for Title = "no title"   delete endscan No record would ...Show All

• wdcdba video control

  While waiting for answers to my other post I tried to play with a video control. It gives me an error I cannot understand: cFileName = JUSTSTEM ( JUSTFNAME ( cLine )) THISFORM . O_VIDEOPLAYER1 . cfilename = cLine THISFORM . O_VIDEOPLAYER1 . playvideo ( cFileName , 100 , 100 ) cLine is the complete path to an .AVI file. The error is that "no parameter statement is found" Is anybody familiar ...Show All