Visual FoxPro

Page 217




  • Topics
    Replies
    Last post
  • tables read only in relation to READ EVENTS
    by jdlim
    8 Replies
    Last post by jdlim
      • Hello! I added the read events on my main prg. but the problem now is that all my tables are read only but if I take out the read events on my main prg my tables works fine any ideas thanks jevan
  • when should we use SQL command??
    by johan2000
    2 Replies
    Last post by MarciaAkins
      • VFOX9 included most of the SQL command..... So when writing a program, should we use the VFOX command or use as much as the SQL command and Why should we choose between the two thanks!
  • REPLACE command help wanted
    by AlexBB
    14 Replies
    Last post by AlexBB
      • If not mastering counter intuitive VFP object manipulation was not hard enough in the past until I finally got a handle of it, now trying to do it from OleDb .NET code is like moving through heavy water--it is 10 times more difficult. I thought I reached the promised land when I finally made PACK work but my joy was premature. Now INSERT gives me the same trouble. I really prefer to
  • How can i stop rounding in a grid?
    by gbyt
    3 Replies
    Last post by Rick Borup
      • I have a grid in a form in visual foxpro and when I try to type a quantity like 1233.92 press enter and when the text box lost focus it displays 1234.00 without any decimals. Please someone who give a clue!  
  • Printing Query Results
    by Dohko
    9 Replies
    Last post by Naomi Nosonovsky
      • Hi I have a table that has one column with numbers 1 to 51. I would like to know how can I write a statement that will let me Count the frequencies of each number and store it in another column in the table. I would also like to access this data with a variable for example n=1 for n=1 to 51 numbers frequencies endfor Thanks
  • Microsoft: No Visual FoxPro 10
    by CDFAUX
    14 Replies
    Last post by dni
      • An official announcement of MICROSOFT: http://redmondmag.com/news/article.asp editorialsID=8320 Although all the signals pointed in this sense, obviously the official confirmation is a bad news. I believe that still lack clarity in the communication of Microsoft. I understand that SEDNA tries to leave liberated to the community the future development of VFP, but if the intention of Microsoft
  • Funny behavior of alignments in report designer.
    by Aleniko29139
    3 Replies
    Last post by Aleniko
      • Hi; Not sure if I'm missing something here but here's the situation: I have a report with some numeric values in the detail band. For some reason, although in the report the headings and the numeric values are both nicely aligned to the right, once I run the report all headings are 1 char too much to the right. The format of the numeric values are all 'numeric' and no more options s
  • An Excel Automation question, how to close Excel?
    by mathmo
    3 Replies
    Last post by mathmo
      • I currently have an application which I'm modifying, various forms have an option for saving. Which gets saved to their excel files. Previously the code looked like this: SELECT * FROM require_slit m_file = 'c:\VisualWIP\Slit Requirements' COPY TO (m_file) XL5 = MESSAGEBOX('Data saved to' + CHR(13) + CHR(13) + m_file + '.XLS', 64, '') Because I wanted to save a few more bits of information
  • Online VFP's Ariticles
    by Ahsan Amin
    5 Replies
    Last post by Craig Berntson
      • Hello, Is there any good web site for VisualFox Pro articles. Ahsan
  • Programatically set report to print in landscape
    by Aleniko29139
    6 Replies
    Last post by Aleniko
      • I have a report which has a dynamic number of columns. I need to print it in landscape or portrait depending on the number of columns. Anyone can suggest how I would programatically set the report to print in landscape Thanks.
  • Slow Report Peviews and Printing
    by Ptaveras
    3 Replies
    Last post by Carl Warner
      • I have an application on VFP 8.0 After previewing the report (35 pages), when I send it to printing in takes 10-15 second pause between each page. It also takes a lot of time (about 8 seconds) to skip each page during preview mode. Had anybody experienced this problem I am running win XP Pro, VFP 8.0 and a P4 + HP Laserjet 1020 Thanks.
  • how to gather m. variables from a form into table where it's updated in a procedure outside the form
    by ibbm
    14 Replies
    Last post by dni
      • Hi, I have created a form to update/add info into a table depending on the actions. I use a prg file for the actual update as this routine is used in several other procedures outside this form. in the INIT() of the screen I either do a blank screen if an add or display the record if it exists. I do this with a scatter memvar command. The objects on the forms have controlsources of m
  • Error : Not a table
    by RavindraPatil
    5 Replies
    Last post by Tamar E. Granor
      • my dear friends, I use vfp 6. I have a form with data environment containing some tables. The form worked perfctly for more than 2 months. Now tables have upto 500 records. When the program was started today, user unexpectedly got an error message like "not a table". I tried to open that table from command window with USE Command. the same error is displayed. Can I save those 50
  • My exe does not running other PC
    by mezofi
    14 Replies
    Last post by mezofi
      • Hi! I built a project and I have a big problem. It is run only my PC, and if I put it on a pendrive (exe). But if I put it on an other PC , this program show only main page. Then when I click someone button, the program show an error message: Command contains unrecognized phrase/keyword (Error 36) It is very strange, because if it is on my pendrive the program good have not got any error. Mez fi f
  • Code page
    by Bit
    2 Replies
    Last post by dni
      • Hi, I run a program in win2k environment, "Code is not configured for current code-page." What does it mean Regards, BIT
  • Printing Barcodes in with ReportBehavior set to 90
    by Nat
    0 Replies
    Last post by Nat
      • All, I have an application that has been evolved over the years and has come up through pretty much all versions of VFP. When printing barcodes (bc 128, leveraging an algorithm and barcode font) things have worked great for years. In VFP 9, things get a bit ugly. If ReportBehavior is set to 8, things are fine. It appears that the font is being "stretched" ever so slightly. I have
  • Retrieving varchar(max) and varbinary(max) fields
    by Ilmar1
    2 Replies
    Last post by Ilmar1
      • I have a test database that contains a varbinary(max) field and a varchar(max) field. when I do a Select * from test where id = xx I get the expected results if my connection string uses 'driver= SQL Server' but these two fields return no data if I use 'driver= SQL Native Client' the other fields in the record come back with no problems. Is there anything special I need
  • feebility of the brainorama
    by SKEETER HEAD
    5 Replies
    Last post by Carl Warner
      • does anyone know how to kill the command window and/or the fox screen in an application i've tried the SCREEN = OFF command in a CONFIG.FPW in the program directory of Foxpro 8. i've also messed with the _STATUS property to no avail. i'm running fox 8 under XP . any advice will be appreciated greatly.
  • Field validation rule.
    by AlexBB
    13 Replies
    Last post by CetinBasoz
      • With my new approach to VFP DBs trying to retrieve data into .NET via OleDb I am facing a few issues I previously ignored. I need to set validation rules for some character fields. The only reqirement is that there should be no blank fields. I used the VFP Management studio Table Designer. I tried a few clauses I thought would make sense but they all failed. MSDN does not give any examples
  • Focus in toolbar
    by Miguel572351
    3 Replies
    Last post by AndyKr
      • Hello: It wanted help with this situation, I have looked for and proven throughout and what encounter is the same solution and it does not work to me. I use a Grid class to which entrance the values to update the table and I keep the data from a button in the toolbar which calls a method in the form where instacio grid, but it does not work to me, the value that entrance is not updated, however if
  • CursorAdapters and UDF in FoxPro 9
    by IvanVC
    9 Replies
    Last post by IvanVC
      • Hi, I like to know if is possible to create a Cursoradapter (ADO) with a select CMD using a function. For example if I have a function concat(par1,par2) that returns par1+par2. I like to use as select command something like select concat(lastname,firstname) as name from personal Thanks Ivan
  • How to select a record from a Grid and open a form
    by msw
    14 Replies
    Last post by msw
      • Hello, I'm new to VFP 9, but I'm working at it.. I have a simple form that displays a Grid with my customer records. I would like to double click and or press the enter key on a given record on the grid and open a form to make editing earier and then return to the grid when I'm done. Can anyone give me some help with this... Thanks...Scott
  • How to remove redundant phrase in field?
    by Littletommy
    14 Replies
    Last post by Littletommy
      • Hi all........ I have a table field that contains things such as..... V DISCONTINUED W/O REPLACEMENT; V DISCONTINUED W/O REPLACEMENT -I&S MASTER; 7 SUB 2610-139-3704; I&S MASTER; 7 SUB FOR 2610-139-3704 What I need to do is remove the duplicate phrases, leaving only one instance of each phrase in the field. The amount of phrases in the field varies...could be 2 as shown abo
  • Column totals for report
    by Kadrin
    6 Replies
    Last post by Kadrin
      • Hey everyone, I'm creating a report and need the totals of a column in a table but I can't figure the code to get the total of the column. I'm sure its very simple, I'm just having a heck of a time with it. Thanks in advance, Kadrin
  • Problem indexing views
    by Hans L
    14 Replies
    Last post by Hans L
      • I am trying to index a view. After having created the view in a prg file, created with Gendbc, I add (in the prg file): USE vwMysoft INDEX ON cname TAG Namn OF vwMysoft USE In other words, I use the same commands I would use for a table. Okay Then, when I open a form where I need the indexed view open, I do: USE vwMysoft SET ORDER TO Namn Error message: Variable Namn is not found. Either I am m