Visual FoxPro

Page 257




  • Topics
    Replies
    Last post
  • Exporting Data to a text file.
    by Dohko
    7 Replies
    Last post by Alex Feldstein
      • Hi I need write a program that looks at a table and returns how many times an entry appears on the table. I created a DBF file with one table that has some numbers 1 to 51. I would like to know how can I create a text file that tells me that 1 appears 30 times, 2 appears 32 times, 3 appears 6 times, and so on. Thanks
  • VFP 9.0 SP1 and SQL 2005 report error need help please!
    by Rob Miller2001
    2 Replies
    Last post by Vasim
      • Hi We have a application written in VFP 9.0 SP1 that tracks our service orders. Within the service order data we have 2 large text fields one is for the complaint notes and the other is for the technicians repair notes.These fields can get very large over 8000 bytes. When we try to print a service order with a large amount of data in either of these field it trys to render a print preview
  • LA Fox Boot Camp VIII -- VFP 9 Report Writer
    by Bill Anderson
    0 Replies
    Last post by Bill Anderson
      • Boot Camp VIII September 29, 2007 El Segundo, California http://www.lafox.org/html/bootcamp2007.htm The Los Angeles Visual FoxPro Developers group is excited to announce the next LA Fox Boot Camp. Lisa Slater Nicholls and Colin Nicholls will be presenting sessions with a focus on the VFP 9 Report Writer. The session list folllows: 1) VFP 9.0 Reporting Fundamentals (Colin Nicholls) 2) Extending VFP
  • Fox 6 to 9 screen conversion problem....
    by ibbm
    2 Replies
    Last post by ibbm
      • When I converted to Fox 9 I had a lot of screens that have the option object as well as user Parameters to fill in for reporting purposes such as dates. When converted the slight touch of the mouse makes the whole screen disappear so I can't see anything on the screen. If I use the keyboard it's okay. Has anyone had this problem Thanks in advance.
  • Include tables bug?
    by hangover
    7 Replies
    Last post by CetinBasoz
      • Having successfully included a database and its tables into the compiled .exe of my application (see separate thread), I have now encountered a problem which appears to be a bug. When I run an SQL query normally - e.g. SELECT COUNT (*) FROM table INTO ARRAY laTest - it works fine. But when I run the same query using the EXECSCRIPT function - e.g. = EXECSCRIPT ("SELECT COUNT (*)
  • CREATE TABLE, but where is it saved on the drive?!
    by Barts007
    11 Replies
    Last post by CetinBasoz
      • I¡¯m trying to create a new free table, which is a dbf file in FoxPro, but I do not understand where is it saved on the drive. Plus, I¡¯m getting a n error: ¡°Invalid path or file name.¡± I¡¯m using VB.NET,: SetConnectionString = "Provider=vfpoledb.1;Data Source=C:\VFP\myFile.dbf" ¡­. ExecuteNonQuery("CREATE TABLE 'C:\VFP\myFile.dbf' FREE (yr INT)") What'
  • Copying a numeric value with decimals from a cursor into excel without rounding up
    by mrfitness
    14 Replies
    Last post by Naomi Nosonovsky
      • I am having trouble with copying numeric values with decimal places into excel. I have a select statement (some being sums of numeric fields with 2 decimal places) with a group by function and I place these results in cursor c1. When it tries to enter this value into excel, it rounds all values up. (eg 309.66 becomes 310) I tried changing the format of the excel file to numeric with 2 decimal plac
  • One basic question, one not so basic
    by Geoffrey Callaghan
    4 Replies
    Last post by Geoffrey Callaghan
      • I am attempting to write some functionality using the winsock control with VFP 6.0. I have a pretty good understanding of winsock itself, but I'm having trouble accessing the object from my code. So here are my two options, neither of which I can figure out right now: 1) The object is defined on a form, but needs to be accessed from code in a .prg. I have never been able to figure out how t
  • ActiveX control with FoxPro
    by Khalid Jayoussi2
    11 Replies
    Last post by dni
      • I have an MFC ActiveX control with support for SimpleFrame. I added OLEMISC_SIMPLEFRAME for MiscStatus and call EnableSimpleFrame in the constructor. I used this control in MFC and Vb and it works fine. but when I used it in FOXPro, I get a problem with scroll bars. but if I comment out EnableSimpleFrame the scroll will work fine with Fox Pro.
  • gMinFilter
    by Squirrel70
    3 Replies
    Last post by AndyKr
      • Hello, I'm new here and with using FoxPro. I'm trying to modify an existing query from within my database. When I open the query it is asking me to locate the .dbc file. I located that with no problem but now it's asking me to "Enter the value for gMinFilter". Can anyone shed some light on what this means
  • how to learn variable memory adress ???
    by tarik yilgin
    6 Replies
    Last post by tarik yilgin
      • my project for usb hid comunication. i need my defined variable memory adress for "SetupDiGetDeviceInterfaceDetail" api on "setupapi.dll" in 3. parameter sample for vbasic, Result = SetupDiGetDeviceInterfaceDetail ( DeviceInfoSet, _ MyDeviceInterfaceData , _ VarPtr ( DetailDataBuffer(0) ) ,_
  • stupid (?!?) function
    by Annonnymus
    5 Replies
    Last post by Naomi Nosonovsky
      • i got this code: x= RECCOUNT () DO WHILE ( RECNO ()+1<x) IF stop=1 EXIT ENDIF nui= ATc (def,var1) &&the prob IF (nui>0) thisform .list2. additem (cuv) ENDIF SKIP enddo nui is >0 only for the first check ;after that it always returns 0,and several of my def (memo) values contain var1
  • FoxPro Views over VFP Oledb with VB?
    by Kanaida
    9 Replies
    Last post by Kanaida
      • Has anyone gotten this to work I wanted to make a view that pivots a table like this: From columns Size 1, Size 2, Size 3 12 12 24 To Rows: Size1 12 Size2 12 Size3 24 That way I can do matching from another table from row to row instead of using a complex program I did this in SQL very quickly but can't seem to do it in oledb for foxpro.
  • How to send email by using default email client installed on user's machine
    by surinder singh
    5 Replies
    Last post by surinder singh
      • Hi All, I want to know if there is any way to send email in foxpro through default email client installed on user's machine. I am using MAPI currently to send emails. Thanks
  • Command Window in Vista
    by AlexBB
    14 Replies
    Last post by Tamar E. Granor
      • I hope Tamar Granor will read it. It seems she may be familiar with Vista. I have touched on this problem in my previous post. In VFP 9 Management Studio under Vista, the Command WIndow behaves like the mouse cursor/pointer when you set it up in slow motion and with traces. In addition it frequently bounces back to the place it started. It is unbelievably weird. It is very very, and I mean
  • Get external IP adress
    by miltoncwb
    7 Replies
    Last post by Naomi Nosonovsky
      • Dear Experts, How can I get the external IP from a vfp program just like I visit www.checkip.org Thanks you in advance. Milton
  • How to check if a local printer is shared in VFP at runtime.
    by ControlNode
    11 Replies
    Last post by ControlNode
      • I'm looking for a way of determining if a local printer is shared. I've looked into APRINTERS(), ENUMPRINTERCONNECTIONS of WSCRIPT.NETWORK and a couple other places/things and not found a way of doing this. I know there has to be a way of checking, but again time limits are preventing me from looking for an extended period for a fix and again I turn to asking.
  • Validations on Textbox
    by Ahsan Amin
    14 Replies
    Last post by Phil Brammer
      • I am trying to implement validation on textboxes placed on a form using ISNull function. I placed the code in a procedure and calling it on the click event of a button but does not work. I want also want to check for numeric and character data. here is my code IF ISNULL(thisform.text2.Value) then MESSAGEBOX("Please enter customer name") ENDIF
  • 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
  • textbox length
    by Ahsan Amin
    10 Replies
    Last post by PB_UK
      • when i enter something in the text box the cursor automatically moves to next record ater entering 30 characters. I have not set it's lenth. so what's the reason
  • Variables
    by Indreek
    9 Replies
    Last post by CetinBasoz
      • hi this is my first VFP script, but now, im in trouble: this code tell me "subscript is out of defined range" on this line " tempfile = tempfiles(x,1) ", i think myself that i have to make this tempfiles also local. but how to make array local when i dont know length script has to convert a dbf-s in folder to dbase IV format, but the proble is that the folder kas sub
  • Get column name in SQL query
    by Victor BA
    14 Replies
    Last post by Naomi Nosonovsky
      • How can i obtain all the records in a specific column like: select field1 from table but instead of the name "field1" use a column number i'm guessing : select 2 from table // The number 2 being the third column (starting at 0)... is this the right way Thanks.
  • How to use the session object.
    by Aleniko
    9 Replies
    Last post by Naomi Nosonovsky
      • Hi; I'm calling an older foxpro prg from a VFP9 form. The prg has a bunch of use commands which will inhterfere with the form, so I'd like to make sure I'm restoring the form's environment when I return from the prg. - I'm not sure if I should use the session object for this purpose I've tried to test this but I'm doing something wrong. I'm opening a different table and then calling this, but aft
  • programmatically finding out if dbf is part of dbc??
    by drhoades32
    5 Replies
    Last post by drhoades32
      • I'm going through a directory that has free tables and a dbc. I can get all the dbf names and info, but I don't know how to identify if a dbf is in the dbc or is a free table. Is there a function that will give me that info or does someone have code that pulls this out of the dbf header file Thanks!!! ** Code snippet with problem in red below** ADIR(laArrayTables,".DBF","D",
  • Selecting Cancel on a SaveAs dialog causes VFP to QUIT
    by Derek Dowle
    6 Replies
    Last post by Naomi Nosonovsky
      • I have a routine that exports data from a .dbf table in a vfp9 application to an Excel 2003 Workbook. By using the line of code 'COPY TO ( filename ) XL5' a system dialog box appears on the screen to enable the user to change the name of the file or the directory into which it is to be saved and then save the file. The dialog box is the same as the one that appears if the user