Answer Questions

• NeedHelper Starting EXE fails, asks for missing FXP

  Hey, I have an app, usually works fine, and it works at many other client sites. But at one it will occasionally hose, and starting the EXE goes to the VFP window (even in my top level form app) and brings up a find file dialog, looking for an FXP. Anyone know why this happens First thought related .prg file was not included in project. If it is included then check if you are calling it within from an execscript() ca ...Show All

• quilty Day Time Picker little trouble.

  Back in Visual dBase days we used regular spinners for dates but here in Fox the spinners do not seem to like dealing with anything but numeric values. I placed three day/time picker controls on two different containers that are supposed to become visible or invisible depending on some buttons being pressed. I am certain the pickers' parents are the containers however when I make the containers invisible (setting .visible to .F.) the pickers sta ...Show All

• Jean-Denis Langelier how do i get a result in 4 tables in SELECT- SQL command?

  good day to the experts... My transaction has 4 tables, 1 for recording the amount of loan, 1 for check payment, & 1 for cash payment, and the vendor table. Below is the tables and its corresponding fields *// vendor table 1 (FIELDS=acct_no, acct_name,address, totalamount) * // loan table table 2 (FIELDS=or_number,acct_no, loanamount, or_date) *//cash payment table ltable 3 (FIELDS=child_numb, or_number,acct_no, amountpaid, ...Show All

• Med Bouchenafa Index on Deleted() VS .NOT. Deleted()

  Which is best for performance index on deleted() tag del or index on not deleted() tag notdel Thanks Probably neither of them. Check fox.wikis.com. Right wOOdy. I neglected to mention BINARY. It is always a good thing (tm) when we have a better solution in VFP! :)   As I understand it, even with binary, it's not always a good ide ...Show All

• dear_vvr VFP CLASS IN RELATION WITH SQL SERVER DATABASE

  Is there anyone who has developed a VFP Class which can work in relation with SQL Server....All Master & Detail Tables should be save accordingly and there wouldn't need to write codes on form to save or retrieve data from detail files on SQL Server as it should be written in a class That's included in most if not all OOP Frameworks out there. there are also smaller classes for this like Rick Strahl's wwSQL ( http://www.west-wind.c ...Show All

• k2msdn How to Group data by month?

  Hi, I have a table with 2 fields, order number and order_date. I want to show the following: Year        Month      Order Count 2005        7              10 2005        8              12 ... ... The following SQL statement works in MS-SQL, but n ...Show All

• HeavyMetalMan Unable to read .dbf file

  Folks, I'm trying to load FoxPro data into Oracle table's using Datastage ETL Tool.i got the zip file which contains the complete Foxpro Tables.I able to read one .dbf file out of 100 files.when i try to read other .dbf files through ODBC stage,its throwing this error: SQLSTATE=01000, DBMS.CODE=1295 [DataStage][SQL Client][ODBC][DataDirect][ODBC dBase driver]Table is read-only, it is part of a database: edutrans.dbc I try to change the file p ...Show All

• griojas Main Window Default Size/Location

  I would like to know what determines where the compiled EXE application window opens and what size it is. I would like to have the window: - remember if it was maximized or - remember last size and position Right now it is always starting in the top/left corner and I'm not sure what I did to get it that way. Thanks You can change the main form to AUTOCENTER = .T. if you want it to always be centered. Is that w ...Show All

• Roman Gil creating tables programmatically-some questions

  I have decided to create some tables programmatically since they most likely will be used temporarily. I do have a number of questions pertainint to CREATE TABLE paramaters. I could not find any explanations so far to figure out what they meant. First I assumed that CODEPAGE should be 1252 (Windows ANSI). Is it the right choice I want to create tables FROM ARRAY arrName I understand that arrName is a 2-dimensional array with the same numb ...Show All

• Mark_Hill Cannot retrieve records from FOX DBF through OLEDB

  Hi, I just want to retrieve some records from a DBF file to a recordset throgh VB6 and I get 0 records when I should get a set of them. This is the code: Set cnn1 = New ADODB.Connection strCnn = "Provider=VFPOLEDB.1;Data Source=C:\Lince\DBF\mer.dbf;Mode=ReadWrite|Share Deny None;Password='';Collating Sequence=MACHINE" cnn1.Open strCnn ' Open table Set rst1 = New ADODB.Recordset datFecha = "2004/12/30" datFecha1 = FormatDateTime(datFecha, vb ...Show All

• Developer 123 Cursor help

  Hi    I am new to foxpro and have a question reguarding cursors. I am using VFP 9.0. I am working with a local VFP data base. As I understand it a cursor is a recordset created by a SQL statement that is stored in memory (or also on the hard drive if it is to big to fit into memory) on the client computer that the application is running on. I also understand if it uses the hard drive for temporary files that they will be deleted when t ...Show All

• AdnanAs Excel Automation - Charts.

  Hello Guys The code below works fine (complete code). The problem is, how can one set the number of rows in the following lines. These two lines sets the chart data parameters. Although one can use "oSheet.UsedRange.Rows.Count" but how to encorporate it in the code. Please complete the following 2 lines. oExcel.ActiveChart.SetSourceData(oSheet.Range("A2:A16,E2:E16"), xlColumns) oExcel.ActiveChart.SeriesCollection(1).XValues = "=History!R2C1:R16C ...Show All

• Akwest Why this SQL select command is not optimized?

  Hello. I have turned on rushmore level messages using sus(3054,1). I run the following from the command window: select * from ruginv where status = "ST000" ruginv does have an index tag on status. The response I am getting is that rushmore optimization level is NONE. I have set optimize on. Why is this query not optimized Thanks, Aleniko Set enginebehavior ...Show All

• ePeter error with SET <classLib>

  It is a simple situation. I am playing with some code I downloaded (wwHTTPdemo). Credit goes to Randy Pearson , CYCLA Corporation, I think and West-Wind Technologies' Rick Strahl. I often get an error stating that an " ALIAS name is already in use ." This is a snippet: TYPE ("wwIPStuff") == "U" SET CLASSLIB TO wwIPStuff ADDIT ENDIF IF TYPE ("wwHTTP") == "U" SET PROCEDURE TO wwHTTP ADD ...Show All

• TavodelaCruz Copy to word

  Dear Experts There is a text1 and command1 on Form1. Thisform.Text1.value=alltrim("Visual Foxpro is great") I want to copy the value of text1 in word document as When I press command1, The word document should automatically open showing the value of text1 The page setup of word document should be 3x5, landscape Please help   http://www.universalthread.com/wconnect/wc.dll LevelExtreme~2,15,1068046 Link doesn't work:( but you al ...Show All