Only Title

Answer Questions

• Peruri Srinivasulu 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

• EJ Moritz return from a form.

  Still struggling to communicate with some of my secondary forms. This problem, again, happens only in StartMode = 4. Everything is fine interactively. LOCAL cUserReturn AS String DO FORM <formName> WITH par1, par2 TO cUserReturn. I get an error message that there is operand/operator type mismatch. I tried to define cUserReturn as Variant - the same thing. The expected type of return is String . According to the Help FoxPro is s ...Show All

• hahahaha Help with FoxPro Application Sharing Setup

  Hello. I need help! I have recently started at a company that has is using an oldapplication written in FoxPro (unsure which version it is.. but some of the computers here run on Pentiums with Win98). Thankfully, we are upgrading all our systems and are re-writing the entire application in a programming language that I understand better. Currently the application sits on a server with client computers connecting to it and launching a copy ...Show All

• Matthew Yeh How to maintain Transaction manipulation for FoxPro 2.6 using ODBC

  Private Function ExecuteBatchQuery() Dim oTransaction As OdbcTransaction Try If m_oCommandCollection.Count > 0 Then If m_oDBConnection.State = ConnectionState.Closed Then m_oDBConnection.Open() oTransaction = m_oDBConnection.BeginTransaction Dim oCommand As OdbcCommand oCommand = m_oDBConnection.CreateCommand() oTransaction = m_oDBConnection.BeginTransaction oCommand.Transaction = oT ...Show All

• Alex Wied report labels

  hi all,im making new reports during run time according to users actions.for example he selectes some fields from comboboxes then he puts in a text box a value that is for the "where like.."and i save the results in a temporary table.from that table i create report and the i report form to print the new report..the problem is that the new report has as labels the names of the fields..for example if the field name is costomer_id it shows costomer_ ...Show All

• merawalaid report temp file not found

  I need to create a simple report, nothing fancy. Just to preview some memo fields. This is the code I use. lcFile = "C:\VFP_Projects\Reports\MyReport.FRX" SET DIRECTORY TO "C:\VFP_Projects\TEMPORARYFILES\" CREATE REPORT (lcFile) FROM (ALIAS()) FIELDS memo1 The second line (set directory to) should be explained. I get an error that a temp file c:\\VFP_Projects\Data\...\000035e10062.tmp no found. Options are "Loca ...Show All

• Renzo Ruiz multiple instance of a form

   i try this sample from "solution samples" titled RUN MULTIPLE INSTANCE OF A FORM.  There is that launcher form and a button for multiple instance of a form.   Now suppose at the launcher form i put a field for a computation result.  The result comes from one instance of a form which i put a field for computation of a certain calculation,  How could i send back the result to that launcher form, wh ...Show All

• MaFrederiksen Remote View SQL 2005 REQUERY Puzzle

  Hi, I have an interesting puzzle. I'm using Remote Views in VFP9 for the MS SQL Server database access. I'm trying not to store the connection string within DBC with remote views. When I'm opening remote views I'm supplying a nStatementHandle ("USE a!b CONNSTRING nStatementHandle") from the established shared SQLSTRING connection. Everything works OK till I'm doing REQUERY() for some parameterized views. Program gives me a ...Show All

• Attila Molnar can i use pack command to local view or remote view?if not,how can i do the same function?

  thank you i got it.thank you No you cannot pack a view. I issue a: =TABLEUPDATE(.T.,.T.) Then I close and reopen the view. Hey jet, if the reply above was the right answer you can click the "mark as correct answer" button! ...Show All

• roberto_sonnino DBclick

  the dbclick event can't be effect after i wrote program in mousedown event in grid control.how can i fix it thank you Hi Jet su, The only thing that I can think of is that the processing time in the MouseDown event is greater than the value of  the _dblclick system variable. This won't allow VFP to recognize the second click within the timeframe dictated by the _dblclick value. Can you show what you are doing in your code Maybe the ...Show All

• J Dunn VFP9 Multiple Detail Bands and Page Overflow

  I have a complex report that has one parent table and 5 child tables. All children have multiple records for each parent. In testing I found two problems for which I have found no reported bugs/work arounds: 1) If a detail band (say band 4) is at the end of the page, and there is not enough room for band 5, it will push band 5 to the next page, but only one record will print. Just one record. Records 2- never print. I ca ...Show All

• Justin J Smith Working with field General!

  Hi, all! Help me to update field type General: append object, edit, open,... in VFP from program control with bottom command. (use line command MODIFY GENERAL <field gen> don't open object) Thank! Backward compatibility. Putiing in is easier than dropping off. For example what would happen if they removed "public" or made default data session for forms 2 etc. ...Show All

• PureOrange empty field

  is there a better way of checking for empty fields than select *; from myTable; where field1 = " "; into cursor data1 i need to run a complete check on the database for empty records in every field. How would i check for a 'date' data field Mike This is what I found when I dumped dBase memo fields into .txt files: the lines do seem to get terminated with this pair: CHR(135)+CHR(137). They are ubiquitous. There is a chance the same thing ...Show All

• C&amp;#35; nb Report that won't maximize

  I put in my class form the code which will maximize the output of every report I generate. Just only this few days that I notice that some of my reports behave as expected but some report output just pops-up in minize at the above left of my screen. It seems that sometimes it ignore the ctrl+F10. Any other ways to permanently maximize all report output thank you for any help. Madix Thank you very much Mr. Higgin ...Show All

• BCras Downloading and uploading files

  Hi I want to ask if someone knows how to download and upload files via ftp without ocx need. Thanks in advice Yes i oso developed ftp program ... to call a batch file to do uploading and fetching files from ftp server... here just a sample code ... sele a use ftppath excl append blank repl field01 with "open ftp.address.com" username password binary hash cd \ftp path ...Show All