Answer Questions

• neetu_fzr i use ado access MS Access mdb,i need some help

  hello all I use mdb as my app's DB file, when my app(exe) run, a ".ldb" file the name as same as my DB file appears in my app current folder,when i exit the app the ldb file still stay there ,so I wrote the code  to del the .ldb file when my app exit. but i open the app(exe)  it appears again . below is what i want : Now i just want this ".ldb" stay in windows temp folder not in my app(exe) current folder. Is there any wa ...Show All

• aaks use the reccount

  hello all  I use "set filter to" and want to know how much record is match the filter condition. I use the "reccount()"  but it return the result is not I want. it is all the record count What do you expect cLocAlias to display cLocAlias is an alias for a table, not a variable that contains something you can print. Try BROWSE after the query to see your results. Tamar ...Show All

• michealdm report preview form problem

  I posted a post related to some problem with memo fields in reports. What I've done so far was to create an intermediate table, a workbench with a single field of a character string length 95. When I need to preview or print a memo field I first format it and place every word sequentially in records of that table. It required a bit of coding but now it seems to work. In any event, the problem I am about to inquire is not related to it at all. ...Show All

• IrimiaBC Programatically Placing Controls on a Form

  A table's fields are: Text, XformCoordinate, YformCoordinate. What would be an efficient way to  process the  records , placing a label for each record at the form coordinates specified in the record with the label's caption equal to the text field in the record. Thanks, Joe Laden (an old Clipper programmer) This worked great! Thank you very much.   Apparently FoxPro can't handle con ...Show All

• dotnetfrage A list where, the first element already apears

  I have a list in a formular. Cand I do, that when the form is Init, the first element of a list, already apears, in that list before I select any element from list. Thank you.   If you want to select first item in the listbox, add something like this to Init() method of your form : this.myListBox.Selected(1) = .T. Put This.ListIndex = 1 in the list's Init method. Tamar ...Show All

• Anderson Farias Carneiro creating tables

  Hi all, When i try to create a table such as ==> CREATE TABLE c:\tab2.dbf ; ( year c(20),; enter_md i(20),; enter_do i(20),; enter_tot i(20),; exit_md i(20),; exit_do i(20),; exit_total i(20),; net_md_delta i(20),; net_do_delta i(20),; tot_net_del i(20) ) I get error message 'Field name is duplicate or invalid'... does any1 know why I realize they are similiar, but what is the problem Is there an easy fix Mike ...Show All

• Ryo44453 BUILD PROBLEM

  Hi all,Im a new programmer in VFOX PRO 9 and im currently having a rather noobish problem. I want to make my application as a .exe file so i can distribute it to someone that doesnt has the vfp installed.i have included the dll files that are specified in help and have put the application as a top level in the application builder.i have disabled quick start and have selected a form as main so that program starts with that one.the problem is that ...Show All

• -Sachin making irregular shaped forms in VFP 9.0

  hi guys...i want to create an irregularly shaped form...what is the easiest and simplest way for me to create one thanks guys :) http://craigbailey.blogspot.com/2006/06/vfp-another-visual-foxpro-blogger.html Dave M. See the provided sample in Task Pane Manager / Solution Samples / New in VFP8.0 / Creating Irregularly Shaped Windows. The sample form is contained in irregular.scx HTH &n ...Show All

• hanisaad 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

• jvshore How do I create a random table or cursor name?

  Hi all, I know that should be simple. How do i create a random table or cursor name and then use it I remember there is a function for this but i cannot find it! Could you please give me an example as well Thanks!!! Athan On the same computer and even on the same application it doesn't matter as long as the sessions are different. ComputerA-Instance1 select * from customer where cust_id = "A" into cursor myCust ...Show All

• Bob Surtees Reports VFP 90 Output to Excel

  Hi: VFP 90 is able to generate output to XML format. Great !! Excel is able to import file from XML format. Great !! So, we are trying to combine both tools. The problem is that VFP XML file contain the FRX table. The results in XLS format aren't the expected. But, in Data section of XML are stored our values with captions and so on. How could we obtain Excel table from XML file generate by VFP 90 Is it possible Thank you. -- Regards, Ana Madr ...Show All

• T Gray _screen.ContinuousScroll problem

  I noticed this problem just this morning after spending many hundred hours debugging my app for the past few months when everything worked just fine. This is the setup which is hardly unusual. There is a function in a prg file and a Click method that calls it. There are a couple of print statements like: "coimng out of the function: "+numeric_id and such in the function(s) and one in the Click method. All output is character s ...Show All

• Christopher Diggins - MSFT connection packet size cannot be set

  Good day to all, I am using VFP as my UI and using SQL2000 as my back-end database, I don't have any problem regarding my connection to my database through ODBC using cursoradapter. But when I try experimenting this different approach of accessing the data of my SQLDatabase i got a packet size problem. What is the correct SQL packet size i must set in my VFP connection Below is my code in VFP that got and error "the connection packet size ...Show All

• dlevy1 Determining opened files

  I would like to ask if anybody knows how to determine how many files are there in a form during run time. If you mean "how many tables", you can generate a list of open cursors via the AUSED() function (scoped to the current data session, so perfect for private data session forms).  You can then iterate through the resulting array and, using CURSORGETPROP("SourceType") and DBF(...), determine which a ...Show All

• andhowdy Memo File Corruption on VFP9 ONLY

  I am just beginning work for a new client.  This client wanted a VFP5 app upgraded to VFP9..they're using Novell (lastest version).  After the conversion (very little changes needed to be made), they started getting file and memo corruption errors as well as indexing errors.  I took a copy of the data and tried a recopy using SCATTER MEMO MEMVAR to a new fresh data file (using GATHER MEMO MEMVAR) in VFP90.  I got the same er ...Show All