Visual FoxPro

Page 222




  • Topics
    Replies
    Last post
  • Arrange the "character string" numbers in order
    by MillBear
    6 Replies
    Last post by CetinBasoz
      • I use the character string for number input. What Syntax should I use to sort out the ˇ°character-stringˇ± numbers as below For example: To sort out according to the number 1 1 12A 3 3 4 4 5 443546
  • Visual FoxPro9 Report Designer BUG
    by MariusR@R
    10 Replies
    Last post by VSCG
      • This issue is somehow related to CTRL+V (Paste) action of an object in report designer and TAG Memo field in .frx file. This is actually terrible thing because you can loose all your code in INIT procedure in Report. Steps to Reproduce: Just try to do the following actions: 1. CREATE REPORT 2. Add a Field box with some text 3. Open INIT procedure in data environment 4. Add some text
  • Speeding up Foxpro - New Server - Multicore ? Xp V's Server
    by J Garland
    9 Replies
    Last post by dni
      • Good morning, I am looking at a new machine to speed up a db i have in foxpro. My quick question is for speed. Does Foxpro take advantage of Quad Cores over Duals and Is their a performance increase in Foxpro for Server OS instead of XP With Thanks Jason
  • 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
  • Side effects of leaving SET STEP ON in code
    by FoxCreek
    13 Replies
    Last post by Tamar E. Granor
      • If we forget to remove a SUSPEND command before deploying a VFP program, the program will throw an error saying ˇ°Feature not available.ˇ± However, if we forget to remove a ˇ°SET STEP ONˇ± command, the deployed program will not error, but will function as desired, acting as if the ˇ°SET STEP ONˇ± was not in the code. Are there any known ˇ°side effectsˇ± of leaving a ˇ°SET STEP ONˇ± command i
  • VFP9 with VB6
    by Doug Gerlach
    7 Replies
    Last post by Tamar E. Granor
      • i have an existing app written in vb6 that queries foxpro tables. it currently works in version lower than VFP 9 what i am running into is that when i am doing a database open and set the uses if i dont wait a second between uses calls, the first query i run give me an unknown alias. if i wait between the uses calls it works fine. my code is below is there anything i am missing Public
  • Determining if multiple EXCEL spreadsheet tabs exist before import
    by GR1206
    14 Replies
    Last post by Naomi Nosonovsky
      • Is there a way to determine if an EXCEL spreadsheet contains multiple tabs, and if so, bring back the name of each tab in order to select the one that you want to import data from I'm trying to import data into VFP from EXCEL, and normally use the IMPORT function and identify the spreadsheet tab by name. This time, I want to know 1) the total number of tabs in the spreadhsheet, and 2) the
  • title bar's font
    by RavindraPatil
    4 Replies
    Last post by dni
      • Hi friends, can we change font of form's title bar if yes, may i know how thank u
  • Child table
    by myfoxpro
    3 Replies
    Last post by CetinBasoz
      • I have a data entry with child tables. But if I click the add button the fields from child table is disable what I need to do for enable the fields from child tables. Thanks
  • Select Statement INTO table removes table INDEX
    by Kadrin
    4 Replies
    Last post by Kadrin
      • Hello, I am working on a project where I need to put parts of a table into another table using a SELECT statement. Later in my project I use that table and have to use the Index as well but when I insert the selected information into the new table my index is erased from the table. Is there a way to solve this
  • merge fields ... right justify
    by rwsgy
    12 Replies
    Last post by Naomi Nosonovsky
      • I want to merge two fields and somehow right justify the second field (dollar amount) so that the decimal places are aligned like this: Record #1 Location = The Palace House Amount = 125.56 Record #2 Location = Convention Center Amount = 1.10 Record #3 Location = USA Wharehouse Amount = 6457.54 then RESULT should be: The Palace House 125
  • Data Environment
    by Gemstones
    6 Replies
    Last post by Gemstones
      • In developing an application must I have the tables I am saving data to or accessing information from in the data environment of the form or can I access them by using the USE command. Also if I don't need to include the tables in the data environment what are the pros and cons of including them. My application is a multi-user one where most times more than one user is accessing the same form at t
  • receive value returned by an exe
    by RavindraPatil
    4 Replies
    Last post by dni
      • dear friends, I want to know how is it possible to recieve a value from a standard exe file and store it  in a variable e.g. if "returnvalue.exe" file returns a number that is to be stored in a variable "mvalue". how to do it
  • Compatability with old FoxPro and dbase
    by Randy Schafer
    2 Replies
    Last post by Randy Schafer
      • I have been a casual user of Foxpro to do data analysis as part of my job of business strategy. I know the old FoxPro/Dbase programming language - I'm going back to 15-20 years ago ... SET FILTER TO ... SET INDEX TO ... TOTAL ON ... and so on. Does Visual Foxpro 9.0 have those commands Can I type them into a program after opening a file with "MODI COMM xxxx" Or are these commands only
  • uSING AJAX IN ASP .NET
    by PARVAIZ
    1 Replies
    Last post by Craig Berntson
      • I WANT TO GET NAME OF STUDENTS IN A SECOND DROPDOWN WHEN I SELECT THE AGE FROM FIRST DROPDOWN THROUGH AJAX WITH OUT POST BACK JSUT TELL ME ALL THE STEPS FIRST TO END   THANK U SIR.
  • Locking VFP rows from C#
    by 5p1d3r
    11 Replies
    Last post by Naomi Nosonovsky
      • We are wanting to create new records in a FoxPro database from c#. The database in question does not have autoinc, but has a 'sequence' table instead. The 'sequence' table has two columns 'file' and 'next_val'. To get the next primary key for the CUST table, simply: SELECT next_val FROM sequence WHERE file = 'CUST'; UPDATE sequence SET next_val = next_val + 1 WHERE file =
  • VFP 9 on Vista
    by mgc1949
    6 Replies
    Last post by Dan Freeman
      • We sell and develop commerical applications in VFP. A customer recently purchased and installed our product on Vista Business. As soon as th program loads, it displays "No Information Available for selected application". Although this has no impact on the program, it is annoying. Have tried to find out more information about how to avoid having this message popup on Vista,
  • Guidance on designing data access classes
    by Darren Woodford
    12 Replies
    Last post by Darren Woodford
      • I am developing a COM server to access 3rd party VFP tables and present them to calling client applications, particularly MS Access 2000/2003. I would like some guidance please on designing the data access classes. At the moment I have a real mishmash of business and data routines. With the plethora of data access techniques available in VFP I am somewhat paralised by indecision. I realise
  • 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
  • settings lost
    by bgailer
    2 Replies
    Last post by AndyKr
      • VFP 9 (also happened with VFP 8). browse preference and browse last do not remember changes from one browse to the next. Command window settings are not rememberer from one VFP session to the next.
  • using msmapi32.ocx in vista
    by lukeclock
    2 Replies
    Last post by lukeclock
      • Hi, i have a vfp application that use mapi object to send email, and also use some microsoft common control (like calendar) . All works well in every os until Vista. I just started yesterday testing my application but .. mail doesn't works. When i try to register the ocx I got this message (in italian) : Il modulo msmapi32.ocx e stato caricato ma la chiamata a DLLRegisterServer non e r
  • 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 disable Foxpro screen?
    by Joe Au
    14 Replies
    Last post by AndyKr
      • I have a project with one screen form only. When I run the execute, the screen form is within the foxpro's screen. How do I make the screen form as the only window form shown on screen Thanks. Joe.
  • Median
    by cookieCutter
    3 Replies
    Last post by Tamar E. Granor
      • Hi all, I have a simple table with ages listed (called c_age). Does one know how to find the median of these ages Does VFP have a built in Median() function Mike
  • DCT FILE
    by dni
    14 Replies
    Last post by dni
      • I have a huge dbc data base. It is working perfect in vfp 7 sp1. When I am trying to use it in vfp 9 sp1, I receive a error in DCT file when I try to browse or use some tables (not at all, jus few tables).