Visual FoxPro

Page 158




  • Topics
    Replies
    Last post
  • 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
  • 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
  • keyboard {leftarrow}
    by miltoncwb
    5 Replies
    Last post by Naomi Nosonovsky
      • Dear Experts, The previous post was incompleted, sorry. I am working on a data entry grid with 20 columns, when the user reach the last record and press down arrow, then append blank and move the cursor to column1 of the new record, I put the following code in keypress event : If nKeycode = 24 select cr_1 appe blank thisform.grid1.SetFocus _col = thisform.grid1
  • 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
  • ComboBox Control
    by Ahsan Amin
    14 Replies
    Last post by Naomi Nosonovsky
      • I have to to fill a combo box control with a table fiels with 'Please Select' at top.
  • HDD Serial No.
    by RavindraPatil
    6 Replies
    Last post by CetinBasoz
      • hello generous persons, Does anybody know how to obtain HDD Serial No. through foxpro Or I have that code in VB. Can we store the value returned by that code to foxpro variable thuogh I do't know much about vb, the code is as follows ; Imports System Imports System.Collections Imports System.Management Public Class Form1 Dim WindowsApplication1 As System.STAThreadAttribute()
  • Activex in VFP
    by MPAZ
    7 Replies
    Last post by AndyKr
      • I am new programmer in VFP. I am using a VFP 6.0 I have a VB ActiveX, I insert this control in a form in VFP. It's OK.. but my problem is that one method of this control, recieve a parameter type VT_PRT.. And i don't know how means that and how this pass this parameters
  • Summary band in reports - VFP9
    by Aleniko
    5 Replies
    Last post by Aleniko
      • I am trying to add a 'disclaimer' at the bottom of invoices. The thing is that the disclaimer should always print at the bottom of the last page. If the last page has only one item, the disclaimer should still print all the way at the bottom. The disclaimer is not a single line but a bunch of lines, and it may change. I've added it to the summary band and I've tried to set the 'field position' to
  • How do I.... Insert multiple columns into the same cursor from multiple tables in VFP 9?
    by JLWtheNoob
    4 Replies
    Last post by CetinBasoz
      • If there is a question/answer already similar to this one, please point me there and forgive the noobie question, I've searched both here and the web and couldn't find an answer. Here's my situation, I have multiple tables, 8 total - 4 for each company, that I need to do counts on by year and return all the results into one cursor so that may then be exported into an MS Excel worksheet. The tables
  • Duplex Printing - A tough one...
    by Aleniko
    3 Replies
    Last post by Aleniko
      • OK... Here's a tough one: Anyone out there knows how to use duplex printing (Printing on both sides of the paper) controlled by VFP I need to print terms and condistions of invoices on the back of the LAST PAGE ONLY. Thanks.
  • impersonateloggedonuser and Getfil()
    by rknh_20
    7 Replies
    Last post by dni
      • Iam running VFP 9 with SP1 under windows 2k. In order to protect my database/table files on a network I have created a single user who has access to the folder where the files are contained. This is the only user with access to the folder. When an individual on the network runs the application the application logs on as that user and has access to the database files...the code goes like this....
  • 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.
  • Form release Help
    by Bit
    2 Replies
    Last post by MarciaAkins
      • Hi, I want to close a form (VFP) using " thisform.release()" However, the form does not disappear as expected. I try to type " test.release()", and put the release command in unload event, it still not work. It is inapproprite to use "hide window" command, what can be done to make that form disappearing Regards, BIT
  • 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
  • .
    by c y h
    4 Replies
    Last post by c y h
  • Feature Not Available - OleDb Provider Error
    by TechMate
    8 Replies
    Last post by AndyKr
      • I am getting "Feature Not Available" for the following stored procedure when called from Win App using OLEDB driver for FoxPro. I checked the Supported/Unsupported commands but I dont find anything that is not supported in my procedure Can someone tell me if you find any errors or alternatives PROCEDURE PROCESS_LOCATION_VIEW_TABLES PARAMETERS setpathdirectory DO PO
  • New Word breaks old DDE code
    by rhersom
    3 Replies
    Last post by rhersom
      • A user of our legacy VFP 7 app is finding that the program blows up on the following DDE command being sent to Word 2003 SP2. Older versions of Word 2003 handle the command with no problem. maxed= DDEExecute (ddehandle,"[If AppRestore()=0 Then AppRestore]") Any idea where the last few living DDE experts hang out
  • is it possible to implement LDAP using Visual Foxpro?
    by Chicks_in
    3 Replies
    Last post by Havokmon
      • Is it possible to implement LDAP using Visual Foxpro 8.0 How Can anyone provide sample Code to autheticate the user using LDAP in Visual Foxpro 8.0  
  • Grid modification within the Form Designer
    by rpp
    3 Replies
    Last post by surinder singh
      • Is there a way within the Form Designer to remove the column.textbox control from a GRID and replace it with an image control I am trying to show an image in each record within in a grid can this be done Thanks in advance to any help.
  • append from view
    by RavindraPatil
    5 Replies
    Last post by RavindraPatil
      • hello friends, can we use append from ........ command to append records from a view to a dbf if no, is there any other single command in sql to do this i can append records one by one from view to dbf. but i think it consumes time. I wanna do it at once. then i thought to copy all the records from view toan array using copy to array or SQL select ......... into array......., and then appen
  • 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 do i disable the windows logo key?
    by Madix_t
    14 Replies
    Last post by Madix_t
      • good day to all experts... my internet monitoring system runs fine in more than a year now, but recently i encounter a problem in a latest internet games. At first my form as a wall paper will be always at the top of all open programs at the desktop. When dis-abled at the server that's the time they can use the workstation. but one user yesterday found a hole in my system, that when
  • Foxpro memo field in ado (or ado.net)
    by kevyou
    6 Replies
    Last post by CetinBasoz
      • I see that this question in various forms has been asked and answered here before, but none of them address my needs...:-( What I need to do is a simple vb6 or vb.net (or even c#) oleDB read from the foxpro database where the table contains memo fields. I get data in the field, but its garbage. I suppose I need to get the field contents in another way but have no idea how to.. I have the
  • GETDIR() in Windows Vista only displays Local Drives
    by JDM0759
    4 Replies
    Last post by PB_UK
      • Hi all, I've created a small application (EXE) using VFP9, SP1 and copied it to Windows Vista Business edition and a Windows Vista Ultimate edition machine. This application has a few command buttons to have the user select a mapped network drive path. I have tried GETDIR(), GETFILE(), and even stepped out of the normal VFP function realm and used BrowseForFolder method of the oShell object. No
  • Drag and Drop with Listbox
    by hangover
    10 Replies
    Last post by nautic20
      • I have a control consisting of two listboxes which allow the user to drag and drop items from the left listbox to the right listbox to copy them across, or drag and drop items within the right listbox to change their order. I have got the mechanics of it working reasonably well using the OLEDragDrop methods of the listboxes, however it is not as slick as I would like. There are three improv