Visual FoxPro

Page 200




  • Topics
    Replies
    Last post
  • need help converting printing from foxpro 2.1 Unix to VFP 7.0
    by Syl007
    1 Replies
    Last post by Tamar E. Granor
      • Hi , I need to transfer a printing program from foxbase 2.1 for Unix to VFP 7.0.... The usage is the following, on the unix system, the employes are entering a 2 digit number on a client table so he can receive a specific letter i have a client table with name, address etc... i have a second table with the different letters each line of the letter is a field by itself all the outpu
  • Visual Foxpro Grid is hiding something from me :(
    by Jean Peter Paredes
    4 Replies
    Last post by Carl Warner
      • ok ! I have a form with a pageframe and two pages. i have a grid on page 1 for sales_items. i have two MySql tables 'sales' and 'sales_items'. i have set the allowaddnew property of the grid to .T. . try to add a new record to the grid and save it (it works fine) now on the grid press the down arrow more than 4 times so that it will look like ur adding more than 4 new records, and then run the up
  • How to show properties window to a file in foxpro
    by surinder singh
    14 Replies
    Last post by surinder singh
      • Hi I want to show the properties window to the file selected by user on right click -> properties option. (as this is shown with any file when we right click on that file and click on properties option in widows explorer) If anybody knows about it , please tell me how to do this If any one knows to do this in Visual Foxpro then it will be good for me.
  • 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.
  • Autoincrement and default values with Foxpro tables and ADO CursorAdapters approach ??
    by IvanVC
    3 Replies
    Last post by CChalom
      • Using VFP 9 SP1 is very easy and powerfull to connect to different Database providers (SQL Server, Oracle, etc.) using ADO Cursoradapters (CA). Using ADO CA we can retrieve from the database server the values for Autoincrement fields and the default values if there are defined and woks just fine. The question that I have is there is possible to do the same using Foxpro Tables: to get in the
  • Combo
    by Ahsan Amin
    4 Replies
    Last post by Ahsan Amin
      • LOCAL nCnt FOR nCnt = 1 TO thisform.cboCourse.ListCount IF thisform.cboCourse.List(nCnt) = ALLTRIM(a_Courses.CourseName) thisform.cboCourse.Selected(nCnt) = .t. ENDIF ENDFOR But selected item is not apearing on top of the combo's list.
  • is it possible to bold a section of a textbox in a report?
    by ibbm
    2 Replies
    Last post by Markish
      • I have a sentence that needs a portion of field bolded. ie. "I need this portion bolded." I've only managed to create three text boxes and put them all together. It's kind of a pain. I thought maybe there was an easier way. thanks in advance
  • datatype casting
    by dvidal
    2 Replies
    Last post by Tamar E. Granor
      • Hi, I want to know how to convert or cast a string to an int. Thanks
  • 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.
  • SQl Select question
    by Gemstones
    7 Replies
    Last post by Naomi Nosonovsky
      • I have a problem that I hope there is a solution. I am trying to search through several tables to find records that match the data the user enters. On finding the records, I want to be able to show that information in a list box on the form. For eg, the user will enter a customer number they are looking for and I then have to search through several tables to find the records that are tied to this
  • Forum Usage
    by Naomi Nosonovsky
    14 Replies
    Last post by AndyKr
      • Since this thread has gone off-topic, may I please ask few questions about this forum usage. 1) How can I see replies in the chronological order E.g. I only want to see the latest replies but I can not figure out how to do it. 2) Can I turn off Alerts for good I often forget to uncheck them when posting a message. 3) Why most of the messages appear in a very small unreadable f
  • field valid method
    by NILKAMAL
    7 Replies
    Last post by CetinBasoz
      • pl.help what i am doing wrong cos when i add new dl_no( my field name) it same message coming " already exists" i want to seek dl_no in checkcust table and if found get the message and focus on same field and if not the go to next field SELECT CHECKCUST SET ORDER TO DL_NO && DL_NO SEEK dl_no IF FOUND() =messagebox("ALREADY EXISTS") return .F. ELSE END
  • File In Use
    by AlexBB
    14 Replies
    Last post by AlexBB
      • Trying to execute a delete command from .NET with OleDb driver I get an error: File in Use. It seems strange that a similar command appeared to have executed once before. That command is downstream of this one and that worked while the code around this one was not yet debugged and this ExecuteNonQuery was simply bypassed cmdm . CommandText = "execscript('USE crossRefTable in 0 EXCLUSI
  • Refresh the whole column of 'Amount' on the grid
    by MillBear
    4 Replies
    Last post by nayef deeb
      • Hi all I have a textbox, namely p2_labhr and a grid, namely dqqrid that contains 3 columns (Product Code, No. of Hours, Amount). There is details displayed on the grid. I¡¯m citing an example as below. Labour Hour : {textbox - p2_labhr ~~ *input: 100*} Product Code No. of Hours Amount AA1 3 300 BB2 4
  • delete currant rec
    by NILKAMAL
    6 Replies
    Last post by NILKAMAL
      • hi! i am new in vfp here is my problem when i delete it delete first record in table not which i view (or currant record) here is code #DEFINE MSGBOX_YES 6 #DEFINE C_MSGBOX1 36 #DEFINE C_DELETE1_LOC "Are you sure you want to delete this customer - " #DEFINE C_DELETE2_LOC " " lcMessage = C_DELETE1_LOC + ALLTRIM(CHECKCUST.First_NAME) + C_DELETE2_LOC lcLAST_NAME = C
  • Select question
    by dvidal
    3 Replies
    Last post by CetinBasoz
      • Hi, I want to know how to put the result of a select statement into a single variable. For example, how will be the sql statement that puts the salary of an employee into a variable given employee_id. Thanks,
  • Using VFP6 to hide sheets and protect book in excel
    by mrfitness
    7 Replies
    Last post by Cindy Winegarden
      • I used a program to copy results of a query into an excel sheet. Now I would like to hide two sheets that I renamed in the program - 'High' and 'Med'. I would also like to protect the book. How can I do this Is this even possible Some sample coding below: esheet=1 loExcelTemplate.sheets[esheet].select oActiveSheet = loExcelTemplate.ActiveSheet oActiveSheet.name = "High" &&RENAME
  • adding a jpeg file address to a field
    by nebraskajanice
    8 Replies
    Last post by skipdcm
      • First, let me apologize as I am real old user of FoxPro 2.0 and have just gotten back to FoxPro via version 9.0 so I am extremely "dumb" but willing to educate myself. My application is: I have a table that contains a number of inventory items. I want to add a field that contain an address for a jpeg file of that item for serveral different reports. Can it be done Thank you in
  • search form
    by NILKAMAL
    14 Replies
    Last post by NILKAMAL
      • hi! can some one help me for this i want to creat search form as below 1) option button - fielda 2) option button- fieldb 3) option button - field c here is i place one textbox for user can put value and search button to search and if record found then go to my my form with this value thanks
  • Export DBF into Text file
    by polachan
    14 Replies
    Last post by hangover
      • Dear All I am new in FoxPro and dBase Please help me for writing a routine in dbase/foxpro that will export any dbf file to a text file that we can read in. Regards POL
  • HUGE problem with the Container Control (?)
    by graFFiti
    7 Replies
    Last post by AndyKr
      • In VFP9: I have a Form, that has a Container, that holds a Listbox The Listbox has some items in it. Now, if you try to click on an Item, hold the mouse clicked and drag it up and down, the selected item does not change, it just blocks there. When you release the mouse and click on another item, you now have TWO selected items in the Listbox. That is not normal. A Listbox outside a container works
  • Foxpro Windows 2.6 - How to replace a blank space with an underscore
    by Amanpartap
    3 Replies
    Last post by Amanpartap
      • Hi This is my first post in board. In a FoxPro database file, i have the following informaiton in one of fields: microsoft is great microsoft_is great In above two values, I want to replace every blank space with an underscore, irrespective of whereever they occur. like microsoft_is_great What would be the syntax Thanks in Advance. Aman
  • Visual Foxpro 8 Help
    by Irshad Wahab
    4 Replies
    Last post by Irshad Wahab
      • Hi Guys, I need help on Visual Foxpro 8. I used to be a master of Foxpro DOS Versions. I am trying to put myself back with Visual Foxpro. I created a project and was playing with properties. All of a sudden, I was able to see only the desktop through the Foxpro Screen with only the command window visible. I was able to activate the Properties window for the screen. Foxpro screen head
  • Adding the _msm_windo to my menu.
    by Aleniko
    9 Replies
    Last post by Naomi Nosonovsky
      • Hi all; I'm trying to add the functionality of the 'window' menu bar into my own menu. I need to let users switch between windows open. I've tried adding pad name "_msm_windo" to my menu using foxpro's menu generator. I've also tried sys(1500,"_msm_menu","_sysmenu") Both didn't work. I've used menu pads under Foxpro2.6 with no problems but this is the first time I'm t
  • Using a JOIN when communicating with SQL from VFP6
    by mrfitness
    4 Replies
    Last post by Alex Feldstein
      • I created two programs in which both connect to SQL database to execute a SELECT query. The first one is a straight forward one with one table and works fine when I display info SQLEXEC(m.lnConn, 'SELECT * FROM Cluster_info', 'cinfo') scan cinfo.cluster_name The second one is trying to JOIN a table and a view. I first went into SQL and used the query view to select and join my table/view to automa