Answer Questions

• David Yeo is this a bug in vfp9?

  Hi, i am using VFP9 on win98,XP & W2k. i use following code to obtained new prn_no. i.e. if all prn_no are in sqeuence, code will return last prn_no + 1, and if any record is missed, then that missed no. will be returened. select prn_no from sm_student_master where section_id = 1 order by prn_no into cursor cursor_temp locate for prn_no <> recno() if found() ln_prn_no = recno() else ln_prn_no = _tally + 1 endi ...Show All

• ajhuddy during compile got error

  Compiling c:\sddms\reports\r_bl.scx LOCAL DIMENSION LSayaddr[2] Error in line 520 of Form1.sayaddr (record 3): Syntax error. PUBLIC dimension Sayaddr[2] Error in line 9 of Form1.cmgReport.cmdPrinter.Click (record 4): Syntax error. Compiling c:\sddms\screen\q_master.scx PUBLIC DIMENSION GAMaster[GiRowcnt,GiColcnt] Error in line 5 of Form1.Load (record 3): Syntax error. Form c:\sddms\reports\r_bl.scx has the following errors: Unknown LSAY ...Show All

• Dan Violet Sagmiller A report where deleted record aperas diferent

  Can I do a report where the record that market Deleted (and Set deleted is OFF) to apears in diferent way (diferent color, italic text, etc) Thank you. oTestRL = NEWOBJECT ("myRL") REPORT FORM test PREVIEW OBJECT oTestRL     DEFINE CLASS myRL AS ReportListener    ListenerType = 1    isDetail = .F.      PROCEDURE BeforeBand (n ...Show All

• MarkCooper executable database

  I have constructed a project in VFP 9.0.   I want to make the project an executable database so that others that don’t have VFP installed on their machine can access the forms that display the information.   How do I do this   Also I’ll need to update the table periodically so does this mean I put the table on the server   I’m really lost in all of this.   Do you mean you want to c ...Show All

• Dion Brown foxpro exe and dbf's, fpt's, bak's, tbk's, but now prgs etc.

  foxpro exe and dbf's, fpt's, bak's, tbk's, but now prgs etc. I was given a foxpro program and i would like to see the code (the formulas)... i'm not sure how to do this... thank you...   You will need to start with the basics then.  Get a book like Fundamendals of Visual Foxpro.  The code is stored with the forms, or prg files and reading and understanding it will take some time. You can ask specific qu ...Show All

• caius Cursors...

  Hello again, I have a cursor that stores information, mostly which can be duplicates of one another. These items are presented through a list box. A user can add and remove specific items from the listbox and the cursor which displays them. My problem is that I am unable to remove a specific item if there are duplicates. What it does is it deletes all of them. Any ideas Don't worry, I've got it figured out: I essentially added a primary k ...Show All

• M Gabriel 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

• Aidin Error using SQL to populate grid

  I have a 9 column grid that I'm trying to populate using an SQL statement in the RecordSource property of the grid.  The statement works fine if I only use 8 fields, but when I try to add the ninth field, in any order, I get a "Command contains unrecognized phrase/keyword" error. This statement works -     thisform.grdmatching.RecordSource="select main.main_id, main.prepdate, ;     main.reqby, act.desc, main.e ...Show All

• el-chema stop “invalid input”

  I have a form with a text box on it that will be used to enter data via a scanner, After the scan I need to have the text box set focus back to itself for the next scan. The only way I seem to be able to accomplish this is to return false in the valid method (I have additional code in this method for actual validation). Is this the only way to accomplish this And if so how can stop the “invalid input” from popping up Tha ...Show All

• Khairul Zarir Call a store procedure in MS SQL

  Does any body have experiences to call a store procedure in MS. SQL Server with Foxpro V8 command Thanks guys for all of your replies. The answer is quite clear for calling a store procedure from SQL server, but normally the call function would bring few or a group of variables into the server to join with the stored procedure, hi guys, would you mind to show me the commands list. Thanks in advance. How about :- ...Show All

• Dwatney editbox control snaps.

  It is a fairly mild problem but still an inconvenience. I have an editbox and a text is assigned to it in the following manner: THISFORM.Pageframe1.Page4.Edit1.ControlSource = "(ThisForm.cData)" All other operations are done programmatically. I may force it to count the number of lines and go to a specific line and highlight it. It does. But then after a while, perhaps in about 2 minutes, it snaps to the first line (beginning of ...Show All

• Jayan visionpace website

  Anyone else having trouble reaching the visionpace website http://www.visionpace.com I can get to the home page, but some subpages seem to have a problem. I emailed them and got confirmation the web site was down and they were working on getting it back up. It seems to be back up now. :) Thanks Craig. ...Show All

• chicolax33 How to create a "GIF" file?

  I have a table with less than 256 records, each one describing a color (R G B values). I also have a 2 dimension array in wich each element has the color number (from my table) for each pixel of a picture. With my table and array, how could I generate/create a "GIF" file Thank you for any help. I don't know. I don't even know much about images. Since nobody answered this yet here are my thoughts abo ...Show All

• nerdz upgrading old foxpro apps

  we currently have foxpro version 5, and a handfull of apps which were developed on it.  the person who developed them has since left us and it has become my job to find a way to upgrade these apps.  the problem is that i don't know the first thing about foxpro - i am a coldfusion guy.  so the biggest thing we want to do is to get the data from the foxpro databases into a sql server database.  if we do this can we still run t ...Show All

• ed dolan Required help for foxpro after installation

  I'm getting a System Error "Divide by Zero or Overflow Error" when I try to run FoxProw.exe on Windows 2000 .  The program installs okay, but I can't get it running.  Thanks in advance for your help ... Hi Malla, Please see my answer to your other post. There's a patch for your problem at http://support.microsoft.com/ kbid=102893  . ...Show All