Answer Questions

• rgreene62 Not a table message...

  Hi All, I have a Visual FoxPro table which I use as a backup table. I have a lot of records in it at the moment. When I was trying to open it yesterday I got the following error: Not a table. I can't seem to open the table at all. The table must have got corrupted etc. Is there any way I can retrieve the contents of this table without having to do a restore from a previous backup. Pablo. It is possible to have a corrupt table that can be repaired. You may try to re-create header or use a recover software like: http://fox.wikis.com/wc.dll Wiki~TableCorruptionRepairTools~VFP http://www.dbf-repair.com/faq.htm http://www.hallogram.com/datatool/ I know what my problem is now, the ...Show All

• pessi view

  Hi gurus I have the following and every time I run the second view It tells me that my first view created does not exist. first view create sql view RV_company_Find_Prefetch remote connection preauth as;select distinct fkCompany from security_User where fkUser= lcfkUserName and deleted=o order by 1 second view Cretae sql View RV_carrier_find remote connection Preauth as;select Name,address1,city,state,pkcarrier; from carier c;inner join preauth! RV_Company_find_prefetch pf; on c.pkcarrier=pf.fkComp The error says that it can not find the first view Can you gurus help me here. Thanks After you create the first view, what does AERROR() tell you It looks to me as though the v ...Show All

• A kid excel and foxpro

  Dear friends, when exporting datas to excel from foxpro using the copy to command, there after trying to do some calculations and formating the excel file using automatation macros how could I integrate this in foxpro, I don't know where to start. thanks for explaining me the functionality satish Satish, If your calculations do not really need macros then you might create a "template" excel file with calculations on it ready and name the region that data would go into (ie: myDataIsland). Then using automation you could create a new workbook based on that template and simply place the new data into "myDataIsland". Dear Cetin, T ...Show All

• Anil Narayanan listbox?

  How do i populate a listbox with some records (sql query used) from a table . thanx for the help in advance You need to set (in properties): RowSourceType=6 RowSource=<table name> for tables. You may also insert a sql query if you select RowSourceType=3 (SQL statement). RowsourceType: 3 RowSource: < your select SQL > ...Show All

• Deco _Genxtab Reporting (My mistake - Not Genxref)

  This is the corrected post... I have mistaken _Genxtab with _Genxref - Sorry. Hi all; I am planning some repoting on cursors generated with _genxtab. Obviously the generated cursor is dynamic and the number of fields is unknown during design time. I was wondering if there are any ideas out there to handle this. Right now all I can think of is to generate a single report where in the detail band I put a single field with "thisform.makeline()" which is a function generating a single line out of the multiple fields. There are some problems with that including problems with having report totals. I have a feeling that VFP9 offers better solutions to this problem, and I would love to know the secret if any. ...Show All

• Ray.B Problem selecting a font in Visual Foxpro 9.0

  When I select the FontName property in the Property window, my default font Arial has disappeared from the selection list above. Arial is corrected installed in my system and I can select it in any other application, even with getfont() in the command window. Any idea Thanks. P.D.: My english is not so good. Sorry. it is ok in other apps, ok in vfp8 and vfp6, just vfp9 is bad If you create a label and put: thisform.mylabel.FontName = "Arial" shows it correct Not really sure if this is purely a VFP issue, or a more general windows issue. Does the font show up in other application dialogs It sounds as if the font has somehow been ...Show All

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

• Wright2020 auto increment

  I have a table that I want to add a auto increment integer field. I go into the database designer, Right click on the table I want to add the field to then select modify. Then I insert a field and give it the name client_id set the type to Integer (autoinc) it defaults to a width of 4. Then I tell it to index it accending. This works but on all the existing records it sets the field to 0. If I add a new record it does increment. Thank You thanks for your reply but i am doing a new database in which i want the "idfield" whereby the number automatically increases thanks AutoInc fields are readonly and if you do add to an existing table then existing re ...Show All

• john_paul how to know which field i index

  hi all, i 1 idx but i dun have documentation to know which fields it index. so i just use set index to idx then set order to && it shown the field. hehe but is that the only way to know or got other method thanks in advance. Yanyee, IDX are out since years. Use structural compact indexes instead. In any case you can check an index's expression using key(). Hi, You can achieve the same with tagcount() and sys(14,<n>). for ii=1 to tagcount() tag(ii),sys(14,ii) next ii Regards, Markish No its my company that i working now still use idx. thanks all your info. sys(14) hm thanks and tag() and key() ... Hm as i tested key() also can know the ...Show All

• OldtimerMCSE VFP9 anchor bug

  I set anchor in my class cs. I have a program in vfp code to create a form. I created a control object using cs and give a position in init method of the my form. Running result: The control object position is always on the left top of my form when I run my form. If you have an object with an Anchor value other than 0 and you want to move it programmatically, you need to save the Anchor and reset it after moving: For example: nAnchor = This.Anchor This.Anchor = 0 This.Left = 57 This.Top = 36 This.Anchor = m.nAnchor Tamar I got it. I didn't reset it after moving. Thx. I am not sure I understand. What is the "bug" you are reporting The default behavior of controls is Anchor = 0 ( ...Show All

• lou_1 How to disable ODBC auto login display if made connection failed

  Thank in advance. I would like to disable the ODBC auto login when login failed. I have tied to set the menu->tools->options->remote Data show login to Never. It seems work but only in IDE but cannot work in executable file. Some experts give me advice please. Window xp, Visual foxpro 8 thank a lot, 多謝 Try this : =SQLSETPROP(0, "DispLogin", 3) && do not show odbc login when error ...Show All

• Ralph13 Caps lock ON when application activate

  Can I trap the 'activate' of my app I want to turn on caps lock every time the user selects the VFP application. I don't want to do this at the start of the app because the user may minimize the app and then get back to it. Thx. I am sure activate even would help me... But I am not sure where do I find the activate event of my entire application... I was thinking of puting this in the activate event of my base form class, but I thought maybe there is a better way to access the activate of my entire app. Is there Thanks. Hi Aleniko, I agree partially with Don's reply to that ( if you really need to store them uppercased then set format to "! ...Show All

• Ariston Darmayuda Excluisve access

  I have a VFP 6.0 application that is used simoultaniously on many computers over a network. Sometimes, when a certain form is opened, it returns a error that says that some component can't be loaded for it is used in exclusive mode by another user. Problem is, I can't figure out what it is that's beeing opened as exclusive. Anyone knows what I should be looking for >> says that some component can't be loaded Could you please post the exact error message That would be much more helpful than all of us trying to guess what you are seeing on your end. Thanks. It's already set off. And all my database access is made through ODBC. ...Show All

• Sicundercover reading a directory for a existing files

  hi there! im new to vfp and i want to make a programm that reads a certain directory and which gives me back the number of the files in that directory and the filenames. can someone tell me how it works in vfp it will really be great... thanks in advanced! novelle You can use filer that comes with VFP. ie: lcStartDir = HOME() *lnFiles = GetTree(lcStartDir,'*.dbf;*.cdx;*.fpt', 'myCursor', .t.) lnFiles = GetTree(lcStartDir,'*.*', 'myCursor', .t.) Local array arrSizeTot[1] Select sum(FileSize) from myCursor into array arrSizeTot trans(iif(_Tally>0,arrSizeTot,0))+' bytes in '+trans(m.lnFiles)+' files.' Select * ; from myCursor ; order by filepath, Isfolder desc, Filename Funct ...Show All

• lalook drop-down combobox problem

  Hi I'm still struck with the combo drop-down part problem for nearly 2 weeks and need help from you. When the values of these 2 textboxes match with each other, the list of employee is able to display on the combo drop-down. But I have one problem :- The list of employee on the combo drop-down repeat unnecessary (even a few blanks) when i changes the values of textboxes. How to refresh the combo drop-down once the values of textbox changes Thank you. I put same values like company codes in both txtboxes. For example, txtboxA = ABCD and txtboxB = ABCD and narrow down the list of employees who works in ABCD. But if I change the values from ABCD to POIU, the result is that the list of employees in ABCD and POIU are t ...Show All