Visual FoxPro

Page 73




  • Topics
    Replies
    Last post
  • table question
    by dvidal
    4 Replies
    Last post by SharathMum
      • Hi, I don't know how to check if a fox table has a list of atributes or fields in a specfied order. For example, I have a table employee and I want to know if it has the fields id_employee, employee_name and employee_hiredate in this order. This verification will be included in a fox program. Does someone know how to solve this Thanks,
  • Using DynamicBackcolor for indexed tables.
    by Aleniko
    6 Replies
    Last post by CetinBasoz
      • Hi; I'm trying to color a grid so I get a ledger format coloring where every other record is colored. But I would like to do this not utilizing recno() because I'm using it with an indexed table where recno() is not in order. Any ideas Thx.
  • Treeview and Terminal services
    by A.G.
    14 Replies
    Last post by A.G.
      • Hi, I have a problem with treeview and TS. I have a treeview build on table TmpRighe . When the user check a node the code replace the field Fl_select on table TmpRighe . the problem is that for all pc connected on the net , everything is all right but on pc connected with Terminal services, doesn't execute replace . please help me thank much ! Augusta specifically doesnĄ¯t execute Node Chec
  • Try ... Catch
    by Mayuresh554114
    2 Replies
    Last post by Mayuresh
      • Hello All , We are a software company having a product developed for Fincancial Systems in Visual Foxpro. The product is well settled and is running successfully for past 10-12 years. Now we are trying to trap our system errors by using Try... Catch ... and Finally instead of onerror .... But unfortunately we found that Try... and Catch can be used with in the method or procedure , it canno
  • SQL query too long doesnĄ¯t work with SQLEXEC()
    by Everton81
    12 Replies
    Last post by Everton81
      • Hi fellows! IĄ¯m doing a big sql query with 2 memory variables (cSQL and cWhere). Something like this: cSQL = "Select ....From.....Inner Join...." cWhere = "Where field1 like '%" + upper(textbox1.value) + "%'" + "Or field2 like '%" + lower(textbox2.value) + "%'" ...and so on until I can check out several possibilities of writing.
  • 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
  • VFP 8 Form Issue
    by TRJ48
    8 Replies
    Last post by TRJ48
      • I have developed a form in VFP 8 which has multiple grids on it. It runs fine from VFP but when I run it from the EXE it gives the following error when trying to load the form. Error Loading File - Record Number 66. ResoGrd <or one of its members>. Parent : Not a Table. I checked the parent field in the .SCX and it looked fine - it just had the form name. I tried deleteing all of the objcode
  • Delete File
    by ScottCamp
    4 Replies
    Last post by Naomi Nosonovsky
      • I am trying to copy files from one directory to another, then delete everything in the first diractory. I am using version 5 currently. everything works except I get this annoying confirmation box making sure I want to delete the files in the 1st directory. I know there's gotta be a way to supress that, but I don't know how. below is the code I'm using to do this. _______________________
  • DisplayCount
    by Hans L
    5 Replies
    Last post by Hans L
      • I know to set the Display Count to specify the number of items displayed in a combobox drop-down list. But how do you specify the number of items when the RowSource is a table and the number of records can vary I tried RECCOUNT("Alias"), but it did not seem to work. Should it work, or is there some other way Regards, Hans L
  • Visual Foxpro report writer
    by Lakshmi N
    14 Replies
    Last post by Lakshminarayana
      • I have a dbf with following fields bill no, bill date, cust name,item name,qty,rate,amount and i have 553 records. i want a simple report on 132 column stationary. i dont want totals also. (so no page footer or summary). i used visual foxpro report writer. but the report does not print with proper ejection i.e. second page starts printing from bottom of first page and third page prints from
  • descending order in grid
    by honey1016
    1 Replies
    Last post by Alex Feldstein
      • What can i do if my index is desceding order in Gid Column. It will automatically descending order in column 1 For example in grid column1 i have 02/02/06 but if i will add 02/02/07 it will automatically go to the top row. Please help. Thanks
  • Set bell off
    by Bit
    7 Replies
    Last post by dni
      • Hi, I am modifying VFP6 prog and add set bell off. However, the alert sound still exists when I type the field reach the end and when error occurs. What may the issue relevant to Regards, BIT
  • Multiple Dataset in the same table object
    by Zoop
    18 Replies
    Last post by Zoop
      • Hi, I'm pretty new in ReportViewer. I would like to show fields from two differents db tables in the same table object. Example : I have an object inside my object datasource. Let's say, an "Employee" object (which is my datasource), containing a "Company" Object, and I want to access a property of the Company object. Automatically the datasetname is set to "Employee"
  • DBF Table Level 7 format
    by S.G.K.Hari
    6 Replies
    Last post by CetinBasoz
      • Hi all, I want to know with which version of FoxPro or VFP i can create Level 7 format of DBF table. Also I need a ODBC or OLE DB driver to access the DBF table. The reason is with Level 7 format of DBF table we an create 1024 fields per record. Any help would be appreciated. Thanks in Advance to all. Hari
  • 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
  • msxml3.dll error when using XMLTOCUROSR()
    by TonyVFP
    5 Replies
    Last post by AndyKr
      • When using the XMLTOCURSOR() function in version 9, I receive the follow message [msxml3.dll : The system cannot locate the specified object ]. Steps taken include uninstalling VFP9 and reinstalling both 7 and 9 and installing the service pack and registering the dll separately. The code works fine in version 7 but not in 9; Test Code lcxmlalias = 'xmlalias' lcfilename = 'c:\indir\pfpcxm
  • FP Database structure via ODBC
    by &amp;#38;quot&amp;#59;
    6 Replies
    Last post by CetinBasoz
      • I'm new to using foxpro, and it is only being used as a database, my program is in VB.net. Using ODBC (or OLE DB if I have to) how can I query the database not for the data that is in it, but for the structure of the database so it could be replecated in MS SQL for example. Where does FP store this information and how do I get at it I would need to be able to get all of the table names in
  • SUBSTR() STRTRAN() with Large Text Files
    by Docpro777
    11 Replies
    Last post by Docpro777
      • Greetings Venerable Masters and Dear Friends, With a 'large' text file (HTML) edit requiring about 500 - 600 text-edits (deletions) (below) ... it takes 10 + seconds to execute and longer over LANs. My only question thus: Is there a faster way to make 500 text deletions to a large-text file Or, how might you consider doing multiple edits with large text files Thanks in advance for any co
  • how can i recover the file?
    by honey1016
    4 Replies
    Last post by CChalom
      • how can i recover the file (.bak) because the dbf file s corrupted and the only chance to recover the data is the bak ile. How can i export the file in dbf thank you very much.
  • Textbox value does not seem to change
    by Hans L
    13 Replies
    Last post by Naomi Nosonovsky
      • I am in a form which shows, i.a., an address and a billing address (in textboxes; record A). I skip down a few records (to record F), and the "skip" buttons (Previous, Next) have ThisForm.Refresh in them. So I figured that the textbox Value property would be updated. And the address textbox surely shows the correct address from record F. But, when I click on a checkbox that moves the add
  • delete button
    by myfoxpro
    1 Replies
    Last post by Naomi Nosonovsky
      • i want my delete button is automatically pack. I mean it will not recover o recall again.. What's wrong with my program because it will not pack. Thanks Code Snippet ****my program in delete button SET EXCLUSIVE OFF SET DELETED on if messagebox("Are you sure you want to delete this record ",36,"") = 7 return endif sele pds_data do case case vtop = vr
  • Convincing THE BOSS - FoxPro (VFP) vs. PL/SQL & Crystal Reports
    by BackDoor Fox
    7 Replies
    Last post by PB_UK
      • I implore your help. My job may be on the line. It is, though, not technical assistance that I need. Please allow me to explain. Of course, I love Visual FoxPro! I have been using it on and off for over 20 years. I am, by no means, an application programmer and have used little of VFP's OOP capabilities. I am, however, very good (I think) at seeing, analyzing and CRUSHING data to ultimately
  • Form's Show Method
    by Ahsan Amin
    3 Replies
    Last post by CetinBasoz
      • I am trying to display the form using formname.show() but it gives error "formname is not an object"
  • Installation Package...
    by Ferius
    4 Replies
    Last post by Ferius
      • When installing my VFP app with installshield I install it on the "c:\Program Files\myapp" directory, and that part works fine. The problem I am having is that when the user runs the application and the application tries to write to tables (*.dbf) on a directory that is under the one I installed my application, it triggers an error saying that the user does not have access. This gets fix
  • refresh form
    by NILKAMAL
    14 Replies
    Last post by Naomi Nosonovsky
      • hi! i create simple form with table field and i create another two textbox in sam form (which is not table field) when i go to next record the table field got refresh but other two textbox have same value of previous record so can anybody tell me how do i do to refresh all field including textbox( not table field) thanks