Answer Questions

• MrLucky Dbf Autoincrement with ADO

  Hello everybody, I created a table with an autoincrement field( CREATE TABLE `Synch_LogFile` ( `ID` I Autoinc NOT NULL, `TableName` C (100) NOT NULL, ...) ) when I try To open it by ADO with VB (Select * From Synch_LogFile) I get this error message: [Microsoft][ODBC Visual FoxPro Driver]Not a table. What's I'm doing wrong Thanks, nothing changed You are opening as adOpenForwardOnly client cursor, not server cursor which expects to work in disconnected mode at the client side. If you are a VFP developer and are a little unfamiliar with the old ADO, maybe this old article can help as it contains code samples and info on how to use it (at least from VFP). There are a probably many other sites that show you old VB 6 ...Show All

• mwindham Problems in connecting Visual foxpro 8 with a free table on a remote server

  Hello everyone I am having a problem when i m trying to connect to a remote server from a local machine. I have a visual foxpro free table named as items.dbf on a directory called foxpro on my remote server. I have a simple connection form which is checking the connection with the remote server. the coding on this form is as follow: lcDbfDir = [http://72.29.68.136/~mglobe/foxpro/] lcCon = [Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=] + lcDbfDir + [;Exclusive=No;NULL=NO;BACKGROUNDFETCH=NO;DELETED=NO] lh = SQLStringConnect ( lcCon ) if lh>0 then = MESSAGEBOX ('Connection made', 48, 'SQL Connect Message') else = MESSAGEBOX ('Cannot make connection', 16, 'SQ ...Show All

• ericzaj How to remove redundant phrase in field?

  Hi all........ I have a table field that contains things such as..... V DISCONTINUED W/O REPLACEMENT; V DISCONTINUED W/O REPLACEMENT -I&S MASTER; 7 SUB 2610-139-3704; I&S MASTER; 7 SUB FOR 2610-139-3704 What I need to do is remove the duplicate phrases, leaving only one instance of each phrase in the field. The amount of phrases in the field varies...could be 2 as shown above or there could be 6. I suspect that the 'common denominator' is the semi-colon, but everything I've tried has failed. Any help is greatly appreciated! Yes, but let me know first, if you know all redundant phrases. Thanks...that looks like what I need! But being the novice that I am with t ...Show All

• AlexBB How to convert Visual FoxPro 6 to visual foxpro 2005

  I know this is my first post here, but i need some help. I have a project in visual studio 6 and my installation cds are lost. I'm trying to make some changes to the tables of my program (eg i need to make a column1 in table a to accept 10chars instead of 5). I can change this in visual foxpro 2005 but when i'm trying to compile the project again i'm getting errors about the menus, it can't find this and that. The questions are.... 1) Do i have to convert the code or something else to the new version And if yes how i'm a going to lose data or anything Are any functions i have to pay attention if they work the same way 2) Is there any other way to change the code and the data structure of the tables Thanx in advance for a ...Show All

• JackStri How to change to memory variable to a row number

  oSheet("10:" + ltrim(str(m.mrow)) ).NumberFormatLocal = "#,##0.00_)" or: oSheet( textmerge("10:<<m.mrow>>") ).NumberFormatLocal = "#,##0.00_)" or one of other N ways... For 1st one what does "are not O-kay" mean What is the error message (I assume you already corrected my typo of not having .rows after oSheet ( oSheet.rows( "10:" + m.mrows)... ) ). For 2nd one, it's your fault not specifying VFP version you're using, not mine. ...Show All

• jaomello Combo in Grid with Incremental Searching

  Hi all I know we can put a combo into a grid and seen in a previous thread a link to Marcia's example on her web site ( http://www.tightlinecomputers.com/Downloads.htm ). However, whenever I put a combo into a grid, the incremental search (based on the interactive change) never works. I can post my code, but just need to know if I'm flogging a dead horse or not. Thanks Peter Dorotiak wrote: I know we can put a combo into a grid and seen in a previous thread a link to Marcia's example on her web site ( http://www.tightlinecomputers.com/Downloads.htm ). However, whenever I put a combo into a grid, the incremental search (based on the interactive change) never works. ...Show All

• Slovek Combo Quick fill while combo is expanded.

  Hi all; I have a class which uses code Marcia Akins posted here (Thanks Marcia). The code uses the InteractiveChange of the combo in order to produce a quick fill functionality. The problem: This won't work when the combo is expanded. I've tried to utilize the kepress method but it didn't work. Is there a place I can disable the inherent functionality of the combo when its expanded so it won't interfere with the quickfill functionality Thank you all. I've tried to utilize the kepress method but it didn't work. Well, that is the way to go if you want the incremental search functionality when the combo is open. You need to remove the code from the combo's InteractiveChange an ...Show All

• YorickPeterse Foxhelp index and search pane is empty and not working

  Hello, I have VFP6 and VFP8 in my notebook under Windows XP SP2. There was an error opening any html help: "Cannot Open the File: Mk:@MSITStore:<any>.chm" I found in one of the forum the next commands to do in the CMD window: regsvr32 %systemroot%\system32\hhctrl.ocx <press enter> regsvr32 %systemroot%\system32\itss.dll <press enter> After them the foxhelp and any other html help is working, but the index pane and search pane is not working or empty in foxhelp, but in Windows and in any other (Office) help working and not empty. I cannot found how to resolve this problem to foxhelp. Can anybody help me Thx. for Your advices. Sandor Ths thread helped me wi ...Show All

• mukilan91 Files open under windows 2003 server

  Hi; I have an installation of WinXp and Win98 machines on a win2003 server. I have noticed that some VFP files (like dbf,cdx,mem) remain open after the user has quit the application. I see these file in the 'open files' section of the file server management. It may take a few minutes before the files get closed. Any one knows what is the reson for this, and also would an open file on the server bee seen as an open file in VFP Thx. Probably they're doing a set default to server directory. Change their default to a local folder before they quit. Cetin; Just wondering: Why would a set default to server dir affect files staying open ...Show All

• Winson Web page scrapping form Visual FoxPro

  I am not sure if this is even possible so i will just say what i am hoping to accomplish and let you all tell me how crazy it is. i want to have a foxpro application on my computer that opens a set of webpages i want to knoe if it is possable to look for a set of numbers on the page once it is opened. the numbers will probly never be the same. is this possible in FoxPro 8.0 VFP can manipulate text rather well, once it's in its environment. Maybe this is a good start to getting your web page in the VFP environment: How to use Visual FoxPro to download a Web page from the Internet http://support.microsoft.com/default.aspx scid=kb;en-us;311306 Thanks Carl that do ...Show All

• Patrick D Tables Relation

  Dear reader, I hope you can help me. I dont know how to relate two dbf free tables files. Table Sub (submenus Items belongs to) ID OWNERID USERNUMBER SHORTNAME LONGNAME EXCEPTIONS ITEM01 ITEM02 ITEM03 ITEM04 1000 0 1000 Entradas Entradas 0 1001 1002 1003 1004 1100 0 1100 Ensaladas Ensaladas 0 1101 1102 1103 1104 1200 0 1200 Sopas Sopas 0 1201 1202 1203 0 1300 0 1300 Cremas Cremas 0 1301 1302 1303 0 1400 0 1400 Ex tico Ex tico 0 1401 1402 1403 1404 1500 0 1500 Aviant\nCuisine Aviant Cuis ...Show All

• SpeedNut Make data auto for field ID when work munti user on LAN network?

  When working on LAN network has multi user update h-ow make data auto for field ID Now, I use express reccount()+1 insert to field ID, but when multi user simultaneous update on LAN network at times double data! On newer VFP versions you can use AutoInc fields. Or you can use a counter system as in the example here: http://www.feldstein.net/newid.asp ...Show All

• Enolan Error reading FoxUser.DBF

  At a couple of sites recently, a compiled EXE has produced an error (1104) when trying to read FoxUser.dbf when closing down. When I checked, this file did exist in the directory it mentionned - but it's nothing to do with this application. The specified directory containing the file is on the computer's path statement, however. I'd like to understand more about when an EXE (as opposed to VFP itself) tries to read this file, and where it tries to look for it. Can anyone enlighten me please If you're not using it on purpose delete it. It'd be created automatically. Putting: resource=off in config.fpw turns foxuser.* usage off. Generally it's not needed and VFP seraches for it in exe working f ...Show All

• swathi_challa Why the datas from the .dbf file (table) on the form are not displayed?

  Hi all Need help very badly.. I purely have no idea where i go wrong. I'm trying to get the datas (such as CHEVSINSMZ 100,CHEVSINSMZ 100, CHEVSINSMZ 101, CHEVSINSMZ 102, etc) from the table (.dbf) display and then trim into "CHEVSINSMZ 100 & 101 & 102 itself. What i get the result on {.xdf_bl.value= OutPutSTring} of the form is (1)_________ when testing this form. Why cannot the datas be shown on the text field when searching for the value in the .dbf _-_-_-__-_-_-__-_-_-__-_-_-__-_-_-__-_-_-__-_-_-__-_-_-__-_-_-__-_-_-__-_-_-__-_-_-__-_-_-__-_-_-_ tnfjob is the name of the table. Jt_hblno is an attribute of the table (.dbf)in the form. It is like something that originally contains CHEVSINSMZ 100,CHEVSINSMZ 100, ...Show All

• Simulacrum COntroling objects

  I have 2 forms, Form1 and Form2. In Form1 I have a grid and a button, when I click the button I call Form2. What I want to do is to control the properties and methods of the grid inside Form1 from Form2. How can I do this One way is to pass to form2 a reference to the calling form. Like this: do form2 with thisform this way you can control anything you want in the calling form from form2 because now you have an object in form 2 which is the calling form. Aleniko A form receives parameters in its INIT() method. Create a property of the form to keep the parameter received, therefore it will be in scope for the life of the form. Form1.Button1 ...Show All