Answer Questions

• Ken Cooper Converting a DAT file into a BDF file

  Hello all I am trying to import a file into FoxPro, it has a DAT extension, is there any way I can convert this to a DBF file Thanks Hello My trouble is that I do not have a data layout of the file. It was a COBOL program that created the file. Thanks Try to open it with notepad. Maybe you can parse it as a text file Sammy. .dat may be a text file output from cobol. first try to open in excel and save it as dbf. else if u can findout the layout u can create a dbf and give the following command use <filename> appe from <filename.dat> type sdf Maybe. What is a DAT extension The name i ...Show All

• Lovericky Foxpro memo field in ado (or ado.net)

  I see that this question in various forms has been asked and answered here before, but none of them address my needs...:-( What I need to do is a simple vb6 or vb.net (or even c#) oleDB read from the foxpro database where the table contains memo fields. I get data in the field, but its garbage. I suppose I need to get the field contents in another way but have no idea how to.. I have the latest foxpro drives sfrom MS Any help out there example code VB6 sConnString = "Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;" & sSourceDB & ";Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO;" Set oConn = New Connection oConn.CommandTimeout = 300 oConn.ConnectionTimeout = 5 o ...Show All

• dakota367 Cannot update table on VFP9 connected in peer-to-peer network

  hi guys...im having a problem when it comes to updating a table on VFP9 connected in a peer-to-peer network..i have already created a drive map (Z:\) and then i tried to open the application on both computers and it worked..but when i tried to perform changes like append and replace which updates the data,it says "cannot update cursor <tablename> because it is read only"..how will i be able to update and made some changes to the data please help me guys..thanks :) MarciaAkins wrote: I am sure that you meant to say READWRITE clause, didn't you Funny! Alex Feldstein wrote: A cursor was created by a SQL command without the READ ...Show All

• kirank_gh Merge 2 text file

  Hi... I have to text file. Can anyone advise how to combine 2 text file into one file using Visual Foxpro 6.0. Thank you. if u know the layout of destination.txt, you can create a blank structrue and say use destination appe from desitnation.txt sdf or u can open destination.txt in excel and save it as dbf. then u can match product and destination to get a 3rd file i.e. sele a.productid,a.description,a.productgroup,b.destination from product a,destination b where a.productid = b.productid into dbf prddest.dbf your prddest.dbf will have all product codes with destination,description and group You're not really combining 2 txt files but 2 sets of data. If you were ...Show All

• AlfonsAberg Server 2000 v 2003

  Hi all, I'm working on a multi-user FoxPro product across a network. Up to recently we used a 2000 server and everything was fine. Since we've moved to a 2003 server we've ran into problems. We get 3 testers working on the same network tables and within a few minutes the application hangs and seems to lock the tables. The really frustrating thing is that it never hangs in the same area or on the one computer. Our error messages are very vague as well. Basically I was wondering if other people had problems going from Server 2000 to 2003. Is there maybe extra security or configuration in 2003 that 2000 doesn't have. Any help would be much appreciated, Don't know if this will help, but I had similar ...Show All

• langalaxy Command contains unrecognized phrase/keyword VB.Net

  Hi I am facing the above problem when I am trying to insert a MEMO data in to the VFP table. I am using a OLEDB connection string in VB.Net My data present in the file is //------------------------------ Pen Pencil Erasier Sharpener //---------------------------- Each an every line has a (Vbcrlf) that is a line feed in it I need the File as in the above format to be stored in the memo file without any change I get the data from the file by the following procedure ---------- Dim lstrData As New String (" ", 500) FileOpen(1, "C:\soc.txt", OpenMode.Binary) FileGet(1, lstrData) FileClose(1) -------- I get the data in the lstrdata Now I use sql statment to insert i ...Show All

• PerPixel how to make an installation disk in vfp 8

  hello, i appreciate very much all the response that i get from this forum. i have another question, how do i make an installer for the program that was developed in vfp8. my colleague told me that in vfp 6 there was a feature wherein you can create an installation disk. is this still supported in vfp8 how do we create an installation disk thank you jason Here is the Walkthrough paper: Creating a Visual FoxPro Application Setup Program Using InstallShield Express http://msdn.microsoft.com/library/default.asp url=/library/en-us/dv_foxhelp/html/fowlkWalkthroughCreatingVisualFoxProApplicationSetupProgramUsingInstallShieldExpress.asp VFP 8 ships with a free copy of InstallShield Express, bu ...Show All

• Selectis Will VFP6 work with Windows Vista

  My company operates a series of VFP6 runtime databases successfully in the Windows XP environment. We currenly have one PC loaded with Windows Vista. When the runtime setup is run it does not install the runtime files onto the Vista PC. Can VFP6 work in the Windows Vista environment How can this problem be overcome Many thanks in anticipation. Very hard to say. You may try to put runtime files in application path, be sure you don't have runtime files in other location and if is not running you should register dlls and try again. It worked for me but with version 7. >> We currenly have one PC loaded with Windows Vista. When the runtime setup is run it does not install the runtime ...Show All

• .net sukbir browser has no memory

  I cannot figure out how to find a switch to cause the browser to remember settings of the previous session like the position of the project manager on the screen, its dimensions, etc. It concerns only my new XP installation which I am beginning to like. Every time I bring the browser with the _screen up I have to start from scratch. It is not the case in other OS and I cannot figure out why. I looked in Tools-->Options everywhere and could not see anything related to the system memory. Thanks. What Browser do you mean If you mean the settings on the FoxPro IDE screen, then make sure SET RESOURCE is set to ON http://msdn.microsoft.com/library/default.asp url=/library/en-us/dv_foxhelp9/html/f72d6803-87f3-489e-bd9b-7761 ...Show All

• Tom Frey How to use user-defined DLL in VFP 9.0??

  I am trying to call a DLL writen by VC++ in VFP 9.0, but I have and error message: "Cannot find entry point "name" in the DLL" . I wonder that if that DLL file will accompany with VFP 9.0 and how could I check about that If I am trying it with VB6 by adding reference, it still work well. I also try with Define class... implement with Object Browser. But it don't work and the method return .T. when I call it in the pgrogram. Thanks in advance to anyone who can help me find out if I could use DLL that is not Win32API with VFP9.0, or I must use VB6 instead Best Regards Many thanks to Alex Feldstein 's reply. And I found what I need in http://fox.wikis.com/wc.dll Wi ...Show All

• bryanedds OLEDB and stored procedures

  I would like to return a cursor from a stored procedure into ASP.NET but seem to get nowhere. Reason why I want to do that is performance. I need to pull a customers open invoices from a table with about 250,000 records. I was unhappy with the performance of the following code. Dim cn_ageing As New OleDbConnection ( "Provider=VFPOLEDB.1;" & "Data Source=" & Chr(34) & "f:\asptest\Accounts Receivables\ACCOUNTS RECEIVABLES.DBC" & Chr(34)) Dim strsql2 As String = "select invno, invdte, invamt, paidamt, balance from Balance_due_detail where custno = '" & DropDownList1.SelectedValue & "' AND balance # 0" Dim cmd_ar As New OleDbDataAdapter ...Show All

• asfsdf Change default printer works only once

  This one is weird... I use the followin function to change my default printer: FUNCTION SetaImpDefa(imp,muda) Declare long WriteProfileString in "kernel32" ; string lpszSection, string lpszKeyName, string lpszString Declare long SendMessage in "user32" ; long hwnd, long wMSg, long wParam, String lParam if muda HWND_BROADCAST = -1 WM_WININICHANGE = 26 endif printer_name = imp printer_buffer = space(200) * len_ret = GetProfileString("PrinterPorts", printer_name, "", ; @printer_buffer, Len(printer_buffer)) printer_buffer = left(printer_buffer,len_ret) * printer_driver = left(printer_buffer,at(',',printer_buffer)-1) printer_buffer = substr(printer_buffer,at(',',printer_buffer)+1) * printer_port = left(printer_buffer,at(',',printer_ ...Show All

• Yodine Visual foxpro 9 watch hang

  I was testing a program with debug and watch window . I enter a function in the watch windw than a window like passward with no title apears and evry think is bloked. I have to end forcely by task manager. Since than evry time I start watch window I get the same window and bloking situation.I uninstald Visual fox pro and I reinstald it. The same think. I uninsald Visual FoxPro and I deleted all the directory from program file . I reinstald Visual FoxPro 9 and the same think happends. I posted a screen copy of the event to www.bluejeans.lx.ro if you want to see it. What can I do    In the watch window I tested this UPPER ( ALLTRIM ( INPUTBOX (DVDLOGIN_LOC,DVDLOGINCAP_LOC))) it permanently genereit an ...Show All

• arro239 Visual foxpro 9 watch hang

  I was testing a program with debug and watch window . I enter a function in the watch windw than a window like passward with no title apears and evry think is bloked. I have to end forcely by task manager. Since than evry time I start watch window I get the same window and bloking situation.I uninstald Visual fox pro and I reinstald it. The same think. I uninsald Visual FoxPro and I deleted all the directory from program file . I reinstald Visual FoxPro 9 and the same think happends. I posted a screen copy of the event to www.bluejeans.lx.ro if you want to see it. What can I do    In the watch window I tested this UPPER ( ALLTRIM ( INPUTBOX (DVDLOGIN_LOC,DVDLOGINCAP_LOC))) it permanently genereit an ...Show All

• c_shah Returning control from a modelless form.

  Hi; I have a form which displays a text file in an editbox. I call this form from a PRG which has a window defined. If the form's WindowType property is set to modal, the form works fine. If I change it to modeless, the form returns control to the calling prg but the active window stays the form itself. How would I keep a form modeless but return the active window to the window that called the form I hope I make sense... Thank you all. do form otherform thisform.Show() add the following statement after the Do (m.prg) Read Event please note on Exit add Clear Events A variety of Modeless ...Show All