dbf to excell

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Exchange Fox
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Consuming a dataset in a web service I have successfully consumed an XML from a web service from VFP8. Now I need to consume a dataset in a web service. Can someone point me in the right direction? I've been searching Microsoft site but nothing pops up. Thanks, Tag: dbf to excell Tag: 211079
  - 2
    - accessing VFP data for ASP.net pages We had (gone now) a developer who wanted to have access to our VFP tables (several hundred mb worth) for "live" queries on a low-traffic web site. His solution, doing all his development in ASP.net, was to create duplicate tables on an SQL server and import the VFP data on a schedule which allowed as up-to-date data for the queries as was possible (perhaps every 15 minutes, but no less than once an hour). I objected to this scheme as being inefficient in that it moved many thousands of times the amount of needed data across our various links (a shared 10 mb pipe to the web server was the bottleneck), when he could have accessed the data directly from ASP.net using OLEDB. His only point was that this allowed him to use SQL stored procedures. Can anyone give opinions on the pros and cons of these 2 approaches? Thanks. Tag: dbf to excell Tag: 211077
  - 3
    - How to dial a phone number from VFP? Hi All, Does anybody have a sample code for using a telephiony API from VFP? Where can I find the examples on how to implement auto-dialing from VFP application? Thanks, Andy Tag: dbf to excell Tag: 211073
  - 4
    - using controls in grid causes problem i am using combo1 that contain faculty,student,staff as combo1 items.... according to i choose the item in combo1 the grid is displayed..... i have insert checkbox1 and combo2 in the grid also...... the combo1 and the grid is in the same form.......initials the grid is set as visible false.... now when i run the form it shows the controls (checkbox1 and combo2) in the grid for frist selection but when i switch the selection in combo1 it does not shows the controls in the grid.......... i have tried thisform.grid.refresh thisform.grid.column1.refresh thisfrom.grid.column2.refresh thisform.grid.column1.checkbox1.refresh thisform.grid.column2.combo2.refresh can anybody help me...... -- Message posted via http://www.dbmonster.com Tag: dbf to excell Tag: 211069
  - 5
    - more on DIBAPI32 and Window Printing Hello and thanks for the response. I copied both the DLL and the LIB file into my development folder. It is now starting to work but... When I execute the code provided earlier the following happens: I am prompted for a printer. I then get a window which says "Printing..." and the window title "to" and the printer name "Sending bitmap to printer..." And there it sits with nothing actually getting sent to the printer The printer works fine. I printed a test page and a document but the bitmap never prints. The code I used is: !/N REGSVR32 /S DibApi32.Dll #DEFINE PW_WINDOW 1 #DEFINE PW_CLIENT 2 #DEFINE PW_BESTFIT 1 #DEFINE PW_STRETCHTOPAGE 2 #DEFINE PW_SCALE 3 DECLARE INTEGER PrintWindow IN DibApi32 AS PrintWin ; INTEGER HWnd, ; INTEGER fPrintArea, ; INTEGER fPrintOpt, ; INTEGER wxScale, ; INTEGER wyScale, ; STRING @ szJobName PrintWin(thisform.hwnd,1,1,0,0,ALLTRIM(thisform.caption)) Does anyone know what the problem is? Thanks, Jeff Tag: dbf to excell Tag: 211068
  - 6
    - gendbc, views and rounding problems... My question is really two part: First why when running gendbc against SQL data are the views created with data type of B(2) when the data structure in SQL is Numeric 12.2? In VFP data this would have been N(12,2) - correct? What is the type of "B"? Then, the second equally as confusing part of this problem is that we have a field which in the debugger, the tables and the views shows a value of 37.63 and we subtract a payment of 37.63 yet the result is not 0.00 as you would expect it is -0.01 unless we include the round function on the first part of the equation [round(finalcost,2)]. We do not see the rounding problem so where is it or is this just an anomaly that has always been part of the views that we have been unaware of. Thank you! Tag: dbf to excell Tag: 211066
  - 7
    - Error reading file... This is a question that I'm sure has an answer of "no". If you have a table open, and the network connection is severed, you get "Error reading file....". OK and Help are your only options. Pressing OK brings back the message, and it's a never ending cycle. Even if the network connection is restored, you will probably not be able to escape. Alt-Ctl-Del is your only way out. Is there any other way to get out of this loop short of hard terminating the app? To duplicate this, I plugged in my USB drive, copied some tables to it, opened the table, and pulled the stick out of the USB slot. Wham, "Error reading file...". Bye bye VFP and any unsaved work. Fortunately, this doesn't happen much in production, and when it does it's usually a network glitch (or in our case Windows server 2003 flakiness that we have not yet resolved). I am tempted to classify this as a bug because it's been around for so long. I would think that Micorosoft would change this to allow you escape from this condition without having to hard terminate the app. Tag: dbf to excell Tag: 211054
  - 8
    - SET CLASSLIB when using SET CLASSLIB, if a library has already been added, will using this call create another instance of that class? Is it necessary to use the RELEASE CLASS statement? I know it is good practice to use it but is it necessary? Thank you Tag: dbf to excell Tag: 211049
  - 9
    - foxpro security question I have 1 FoxPro client that I service once a year for a few weeks. I'm not remotely a FoxPro expert. The app is still in VFP6 and that's fine for now. I may end up converting the whole thing to Access since it's pretty small and low usage. It'd be easier for me to maintain that way. Anyway, I'm trying to find out about the security available in Fox. Their company has come up with a new policy that's going to require that the database be secured to some degree. Right now it's not in a container. It was originally a Fox 2.6 for DOS app that we just grungily moved over to VFP a few year ago. So the tables are all free. Other than doing things like securing folders on the network and such, is there any way within VFP6 (or even later versions maybe) of securing the tables so they cannot be tampered with? Obviously right now anyone can get into them even if they just have odbc on their system and they have access to the folder the files are in. Anyone with MS Access can get at them. We'd like to tighten it up a bit if possible. Thanks in advance, Keith Tag: dbf to excell Tag: 211048
  - 10
    - trouble with converting a string. i know this is a real basic question, please bear with me, i am still learning. i am placing a Name from a file onto a Word Doc. in some cases its a normal name. Jane Doe, other times it could be Jane Doe-Deer. thats the one i am having trouble with. i am using proper(from) to make it look nice. but the Hypen is giving me fits. it will print like this Jane Doe-deer not very nice. any ideas? Please. thank you in advance. Tag: dbf to excell Tag: 211043
  - 11
    - Outlook is killing my Excel workbook Hello, i am using Excel and Outlook Automation to respectivley create a Workbook and email it. all that is going well. once the workbook is attached to the mail and sent, the user then will open the workbook up, add to or make changes and send it back to the sender. prior to sending it gets the workbook is printed out. and it fine. however after recieving the edited workbook back, it adds a column to the book with the same data in the previous column. EX Date Cost Total cost 2/1/05 5.00 2/2/05 5.44 10.44 this in the Send email attachment i get back date cost totalcost 2/1/05 5.00 5. 2/2/05 5.44 5.44 10.44 it adds a row of the same as Cost but removes the .oo's so 10.01 is fine but 10.10 looks like 10.1 and i dont even know why it adds that row in the first place. its wrong. Tag: dbf to excell Tag: 211036
  - 12
    - DIBAPI32.DLL Hello all and thanks for the help. There was an earlier thread that talked about how to write a "Print Screen" for a form and referred to DIBAPI32.DLL which is available here: DIBAPI32.dll comes with Palfade.exe which is on the September 1999 Technet Library Archive It's also available at http://download.microsoft.com/download/platformsdk/sample42/1/W97/EN-US/PALFADE.EXE The problem I'm having is that this DLL seems to be quite old and doesn't work with (my) Win XP. Does anyone know of a modern replacement? Thanks, Jeff Tag: dbf to excell Tag: 211034
  - 13
    - VFP8 getnextid using cursoradapter views We are having some multi-user issues having changed our system over to use cursoradapters (native and SQL). The file which controls the next id for each table is accessed via a cursoradapter. Unfortunately requery on this file fails if someone else has updated that file and hasn't yet committed their change i.e. they are in the middle of a BEGIN/END TRANSACTION. Other than avoiding getting the next id inside a transaction and requerying inside an endless loop until successful, I can't think of a way round this. I toyed with autoincrement fields but we have a lot of parent/child tables where we need to know the parent id for the child records, so I've abandoned that idea. We also access the data via ODBC in Crystal so again I think there is a problem with autoincrement fields. Has anyone got any other suggestions? Thanks, Bernie Tag: dbf to excell Tag: 211031
  - 14
    - [SingFox] VFP UserGroup Meeting Time : 6 - 9 PM Date: 4 May 2005 Place: MS Office @ Marina Bay . For More info and directions - please see http://groups.yahoo.com/group/SingFox . If You wish to attend please SMS your name to me at 9004 1089 - I have to put your name on the Roster List for MS Security Desk. warmest regards / xie xie [Bill] Tag: dbf to excell Tag: 211026
  - 15
    - How to prevent DBC trigger from firing I have to write a utility that will update production tables. The tables have triggers to update a datetime changed field when the record is updated. The nature of the change I'm making is such that this trigger absolutely cannnot fire. Is there any quick and easy way to prevent record validation rules from firing? This is a production system and I can't change the DBC just for this update. The update is an automatic process, no human intervention. Tag: dbf to excell Tag: 211020
  - 16
    - May letter on Visual FoxPro web site This month's letter contains a summary of some recent Visual FoxPro news as the Visual FoxPro team is busy working on future plans for Visual FoxPro to be announced next month. http://msdn.microsoft.com/vfoxpro/letters/ Ken Levy VS Data Product Manager Microsoft http://blogs.msdn.com/klevy http://msdn.microsoft.com/vfoxpro -- Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP cindy_winegarden@msn.com www.cindywinegarden.com Blog: http://spaces.msn.com/members/cindywinegarden Tag: dbf to excell Tag: 211019
  - 17
    - create a help file i will appreciate if can help me, i develop visualfox 7.0 application, but i need to create a help file i dont know how. Tanks Tag: dbf to excell Tag: 211018
  - 18
    - Method code swapping in VFP8 SP1 VFP8 SP1 on XP Pro SP1 I've seen this reported in other versions of VFP, but not in VFP8. After editing a form and running it, I got some odd errors. I went back into the form and found that several methods had their code swapped. The code from the Load and Init methods had been swapped, the code from the Show and Unload methods had been swapped. How's that for scary? This form has about 40 custom methods added to it and only the native methods that had code in them got swapped. The custom methods were all fine. In VFP's defense, at the time this happened, (but after the form had been saved, compiled, and run) VFP crashed due to another issue. I suspect these events are related since I've never seen this code swap problem before this. -- TRW _______________________________________ t r w 7 at i x dot n e t c o m dot c o m _______________________________________ Tag: dbf to excell Tag: 211014
  - 19
    - RDP, Memory and VFP Hello, At a customers place, I have to develop foxpro (8.0) in a Remote Desktop session on a heavy machine, lots of memory, 2 cpu's etc.. When I' m running large queries I frequently get an error: "Not enough memory for map file", or when I look at the rushmore optimization it says; "Not enough memory to rushmore optimize table x". I tried SYS(1104) or/and sys(3050,1,large) / SYS(3050,1,small). But nothing seems to help. Sometimes it helps to log off the rdp session and start a new session. Because off security reasons it's not easy to try the query on a local machine (without RDP)... Is there anyone who knows how to solve this? TIA Gerben Kessen Tag: dbf to excell Tag: 211012
  - 20
    - Multiple Detail bands in Report Writer? Not sure if that's what I need to do or not, but here's the gist... We do testing services here, using vehicles. The data is compiled at certain mileage intervals. The report goes like this... Header Detail lines showing data at each mileage interval More lines showing data another way at each mileage interval. Same as above, data another way. Same as above, data still another way. Same again, data still another way. Each of these "bands" show the mileage intervals and dates that the data was compiled. But each of these show the data in a different manner. Initially, raw data, next band a sort of summary type data, the next band a projection data, but still based at the individual mileage increments when the data was compiled, next band is a series of comments compiled at each measurement interval and finally a set of physical properties taken at each mileage interval. Right now this is done as a "manual" report in FPD2.6. I have no idea how to get this into the report writer. Can someone please help? Point me in the right direction? Thanks! Shawn Tag: dbf to excell Tag: 211002
  - 21
    - shellexecute I need to display .pdf' files from within a Foxpro program. I thought that a shellexecute command was the way to go, but I can't seem to get it to work. Any help and/or sample code will be great. -- Lost in Tampa Tag: dbf to excell Tag: 211000
  - 22
    - User-Defined string Functions Transact-SQL - built-in functions Fo Ladies and Gentlemen, I would like to offer you the following string functions Transact-SQL, the name and functionality of which correspond to the same built-in functions of Visual FoxPro GETWORDCOUNT() Counts the words in a string GETWORDNUM() Returns a specified word from a string AT() Returns the beginning numeric position of the first occurrence of a character expression within another character expression, counting from the leftmost character RAT() Returns the numeric position of the last (rightmost) occurrence of a character string within another character string OCCURS() Returns the number of times a character expression occurs within another character expression PADL() Returns a string from an expression, padded with spaces or characters to a specified length on the left side PADR() Returns a string from an expression, padded with spaces or characters to a specified length on the right side PADC() Returns a string from an expression, padded with spaces or characters to a specified length on the both sides PROPER() Returns from a character expression a string capitalized as appropriate for proper names RCHARINDEX() Is similar to a built-in function Transact-SQL charindex but the search of which is on the right ARABTOROMAN() Returns the character Roman number equivalent of a specified numeric expression ROMANTOARAB() Returns the number equivalent of a specified character Roman number expression ... For more information about string UDFs Transact-SQL please visit the http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,27115 Please, download the file http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,2,27115 With the best regards Tag: dbf to excell Tag: 210997
  - 23
    - VFP8 & Linux I am new in this subject... Is it possible to run a VFP8/application,exe/ on a workstation where the server's operating systeem is Linux? Could anyone help me? Many thanks. -- Sandor Tag: dbf to excell Tag: 210987
  - 24
    - VFP8 & Linux I am new in this subject... Is it possible to run a VFP8 /application, exe/ on a Win98 workstation, where the server's operating system is Linux? Could anyone help me? Many thanks. -- Sandor Tag: dbf to excell Tag: 210986
  - 25
    - Tableupdate fails - VFP8/SP1 Hi all! * Write from a local paramerized view to its basetable´s memofield IF CURVAL(lcFieldName,lcAlias) == OLDVAL(lcFieldName,lcAlias) llUpdated = tableupdate(1,.F.,lcAlias) * respons to user IF llUpdated = .T. wait 'Saved' nowait window ELSE TABLEREVERT(.F.,lcAlias) wait 'Not saved' nowait window ENDIF ENDIF Is the VFP-multiuser-stuff stable? User A saves to a memofield as above and receives the Saved-message. After that user B opens the same view and saves unother value to the same field and she receives the Not saved message. What can be wrong? The view is is opend shared of course. I have tried to reindex the table and recover the database as well. Best regards Christina Tag: dbf to excell Tag: 210984
- Next
  - 1
    - PrintScreen direct output to printer ? Hi I am using VFP6 SP4 I want to make a command button to dump the screen or active window and direct output to printer (not copy to clipboard). when the user clicks this command button, it is the same as press key PrtSc How can I do that ? pls give me a hand thanks all Tag: dbf to excell Tag: 210982
  - 2
    - Copying a Graphic to the Clipboard Anyone have a routine that will take a graphic (e.g. a .JPG file on disk) and copy it to the Windows clipboard so the user can then just paste it in a graphics program like Paint Shop or Photo Shop? Thanks. Charlie Parker Tag: dbf to excell Tag: 210977
  - 3
    - RUN will not work - requires working dir? I have an application on my machine that is basically an icon on the desktop with the following for the target P:\psw.exe. If I take properties on the icon, under "start in" it has p:\. If I double click the icon on the desktop, it works as expected. On one of my VFP forms, I have a command button with the following code and the program will not run (it generates an error specific to the program) RUN /N "P:\psw.exe" Any ideas how I can trouble shoot this, or modify the run command so it has a "start in" that emulates what it is expecting? Thanks, Dan Tag: dbf to excell Tag: 210968
  - 4
    - C0000005 upon vfp exe exit after responding to .net events I am getting a dreaded C000005 at address 79221bd8 after running a simple vfp exe that opens a simple .net form and responds to an simple event. The event is being handled fine by VFP, but upon exit the windows error is displayed. What is strange is that when this simple app runs in the VFP IDE it works just fine. No errors. Running it standalone produces the error. Does anyone here have some experience/sample code in responding to a vb.net dll's events in a VFP executable? I would sure appreciate some help here. Again the code is working just fine; .net dll is being created and .net form is running in new thread, I am implementing an eventhandler in VFP correctly since the event fired by the .net form is being responded to by VFP. It just blows when exiting back to Win XP. Thanks. SJT Tag: dbf to excell Tag: 210960
  - 5
    - Report. Page X Out of Y by Groups.VFP9.0 Hi, I want to be able to print "Page 1 out of 4" for every group on the report so that every group will start from page 1. Another word, I need page totals for every group. Note: VFP9.0 Thanks, Eugene. Tag: dbf to excell Tag: 210959
  - 6
    - Hiding the top level form Hello and thanks in advance for the help. If you have an app with a top level form where the other forms are "In top level form" and Desktop = .t., How do you hide the top level form when the user goes into a subform? Does the parent object of the lower level form point to the top level form? Thanks, Jeff Tag: dbf to excell Tag: 210956
  - 7
    - SQL: Group By error Hi, I'm new to FoxPro and am converting from version 5 to version 8. I'm getting this error: SQL: Group By clause is missing or invalid. The offending code is: SELECT statepmt.state_code, strecon.total ; FROM statepmt, strecon ; WHERE statepmt.yyyy_mm = w_yyyy_mm AND ; statepmt.state_code = strecon.name ; GROUP BY statepmt.state_code ; INTO CURSOR statots It works fine in version 5. I'd appreciate any comments. Thanks, Jim. Tag: dbf to excell Tag: 210948
  - 8
    - DOUBLE-BYTE PROBLEM HI ALL I TRY TO USE WEB SERVICE FOLLOW THE SAMPLE CODE IN VFP 9 HELP. BUT I WERE CONFUSED WTIH HOW TO TRANSFER CHINESE BIG5 FIELD AND CONTENTS PROPERLY. I FOLLOWED THE CODE BELOW Walkthrough: Creating XML Web Services with Visual FoxPro and made northwind!customer's filed into chinese include content but failed Can somebody help me ? Tag: dbf to excell Tag: 210939
  - 9
    - vb.net usercontrol used in a foxpro 9 app Hi, In VS6.0 it was simple to create an active-x control in VB and then use it as a ole object in Visual Foxpro. I'm trying to figure out how i can pass values from visual foxpro to a vb control and then return completed values. Can anyone shed some light on this, and/or provide examples. Thanks GG Tag: dbf to excell Tag: 210936
  - 10
    - data migration Hi friends am exporting vfp data to sql server and am using DTS to export. my question is is there any option to export all tables at once rather than doing one at a time? Thanks -- cheers Tag: dbf to excell Tag: 210931
  - 11
    - indexing problem How do you index a table which has a field which may be positive, negative or zero? The problem is a secondary field is also required which is a character field. Let's say field1 is the numeric field and field2 is the character field. Using the following command to create the index, does not produce the desired results: INDEX ON STR(field1,FSIZE("field1")+field2 TAG myindex For example, I would see the following numbers in a browse form when looking at the field1 column : 0 1 2 3 4 -1 -2 -3 -4 But, the desired response is: -4 -3 -2 -1 0 1 2 3 4 I'm sure other people must have come across this problem -- any ideas? Thanks, -- E. Myron I have a table containing two field called myvals which can contain numbers from -99 to +100. When I index the table using the following command, everything is fine: INDEX ON myvals TAG numindex If I index using the following command, the result is incorrect: INDEX ON STR(myvals) TAG strindex The problem is that I have to use a string because I am combining two fields in order to get a secondary -- To reply, change "invalid" to "net" Tag: dbf to excell Tag: 210928
  - 12
    - SQL Problem I have a problem (VFP6) in getting a summed amount which I need for a report. In simplified form, because there are other related tables, the code reads:- Select tenants.lastname,tenants.tenantref,more fields, tenacc.item,tenacc.debit,tenacc.credit,sum(tenacc.debit) as sumdebit,sum(tenacc.credit) as sumcredit; From tenants inner join tenacc; On tenants.tenantref=tenacc.tenantref; order by tenants.tenantref; Where (tenacc.item='Due' OR tenacc.item='Received'; INTO cursor rentsa The problem is that the summed fields include all debits and credits for tenantref, ignoring the Where line which is intended to restrict them. I would like to define the summed fields as sum(tenacc.debit) for (tenacc.item='Due' OR tenacc.item='Received') but SQL does not accept a FOR clause. I have also tried using the summing ability of a report format, but cannot seem to get it to work Help would be much appreciated. -- Tim Hobson Tag: dbf to excell Tag: 210917
  - 13
    - Timer events... when? ...in Fri pm duh mode. Timer events fire between lines of code or between procs? Also there are some issues with users setting focus on other non-VFP processes while timers are enabled, I seem to remember. Some refresher remarks about that'd be good, too. TIA. -Lew Tag: dbf to excell Tag: 210904
  - 14
    - - How to Save Target As.. ? I am trying to automate IE6 to downolad a bunch of documets (.tif, .fax files). Is there a way to execute "Save Target as" within IE object? For instance, I have a link that looks like this: https://www.whatever.com/viewfiles.jsp?fileid=999&name=FILE+NAME+.TIF and I need to download this file to a specific folder with a new file name: c:\TifFiles\_999FileName.tif If I use URLDownloadToFile, I get a blank page since viewfiles.jsp is preventing me from getting the file directly. However, if I use Navigate and then ExecWB(saveas), I am prompted with a dialog to Open/Save/Cancel from Navigate followed by Save As (filename)dialog from ExecWB. With this, I get the ability to download the file but how do I stop the prompts? Ideally, what I am looking for is something like URLDownloadToFile(with ability to provide source url and destination file name) that would work like Navigate->ExecWB(saveas) without the prompts... Is this the right group to post this on? Tag: dbf to excell Tag: 210902
  - 15
    - VFP 9: report not displaying 4-digit century This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C54CB6.42EE9CE0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable All, I've been pulling my hair out over this! I have one report that = displays 4-digit year while another only displays two. I've fiddled = with VFP default date settings and still won't display 4-digit century. Suggestions please. Thanks ------=_NextPart_000_0006_01C54CB6.42EE9CE0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.2604" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DVerdana size=3D2>All,</FONT></DIV> <DIV><FONT face=3DVerdana size=3D2></FONT> </DIV> <DIV><FONT face=3DVerdana size=3D2>I've been pulling my hair out over = this!  I=20 have one report that displays 4-digit year while another only displays=20 two.  I've fiddled with VFP default date settings and still won't = display=20 4-digit century.</FONT></DIV> <DIV><FONT face=3DVerdana size=3D2></FONT> </DIV> <DIV><FONT face=3DVerdana size=3D2>Suggestions please.</FONT></DIV> <DIV><FONT face=3DVerdana size=3D2></FONT> </DIV> <DIV><FONT face=3DVerdana size=3D2>Thanks</FONT></DIV></BODY></HTML> ------=_NextPart_000_0006_01C54CB6.42EE9CE0-- Tag: dbf to excell Tag: 210895
  - 16
    - Record does not unlock Hi I have an application made in FPW 26, using tables .DBFs. An application process locks a record and when finishes, unlocks it. Randomly, the record is not unlocked and other users performing the same process stay waiting indefinetly and they have to kill the application. Even though when the process who locks the record finishes and the user closes the application with all tables closed, the record remains locked and other user remain waiting. What could be the problem? How can I solve it? Thanks in advance Francisco Heker Tag: dbf to excell Tag: 210890
  - 17
    - Servoy & Firebird learning curve compared to FoxPro Goldmine 7.0 (CRM) is moving away from xBase, will ship with Open Source SQL DBMS called Firebird (similar to Interbase) as alternative to MS SQL Server version of their product. I'm not much of a programmer, and the only programming language I have ever come close to mastering is/was FoxPro (VFP 6). I have thought of learning Filemaker Pro but since Goldmine is probably going to be my CRM of choice and version 7 will nolonger use dBase I'm faced with learning more about Firebird and wondering what I would use to access the underlying data in addition to or outside of Goldmine. I lean towards FoxPro only because I'm familiar with it already. Interested in opinions / comparisons of FoxPro and Firebird, and also a FoxPro users perspective on Servoy as an RAD tool. John "J.J." Jackson Tag: dbf to excell Tag: 210881
  - 18
    - store procedure return result I got a SP to do the insert update, if the insert statment is completed, i would like to return a variable to indicated whether the insert is sucess or not. How can I do this ?? Thanks a lot . Tag: dbf to excell Tag: 210873
  - 19
    - Foxisapi won't launch COM application Here is my situation: VFP 6.0, XP PRO. http://localhost/common/Foxisapi.dll/RESET & STATUS work properly COM server is out-of-process exe COM server can be loaded directly from Fox with: o = create("bulkm.x2") ? o.testServer() && This works But when I try to launch it from within IE I get "page cannot be displayed" http://localhost/common/foxisapi.dll/bulkm.x2.testServer In the event log I get: The HTTP server encountered an unhandled exception while processing the ISAPI Application 'foxisapi + 0x1E96 + 0xD8CF25C5' It must be a permissions problem. So within the component services I have set: The COM permissions on "My computer" are set to Allow Access and Launch for the IUSR account Under DCOM config the COM server is set to use the defaults for security I am thinking that maybe it is the permissions on the common directory, because Foxisapi writes a file to that directory. I have set the directory to "web sharing" with read/write permissions. I don't know what else I can do. Can anyone help? Tag: dbf to excell Tag: 210867
  - 20
    - How to find the VFP version used to compile a prg and to build a com dll? Hi all, Is there a way I can find the VFP version used to compile a fxp and to build a COM+ dll? Thankx. Nadee. Tag: dbf to excell Tag: 210866
  - 21
    - Outlook Read Email Does Not Run The Form I tried posting this to the Outlook forum with no responses.... I have a custom Email form I have designed with a button on it. However, I notice that when I double click on a form in my inbox the custom form is loaded so that I can read the Email on the custom form. But, the button won't work unless I then click Form, Run this form. Isn't there a way that I can make the button work automatically when the user reads their Email so that they can just click the button rather than click Form, Run this form and then click the button. I'm guessing that maybe Microsoft did this so that scripts won't run but I'm wondering if there is an easy way to activate that button. Thanks Tag: dbf to excell Tag: 210863
  - 22
    - Showing Microsoft Outlook's Inbox Hello - I am trying to find a way to show Outlook's Inbox. I already know how to use FindWindow to flip over to Outlook but it just flips over to whatever window is present which could be the calendar, tasks, etc. I'm wondering if there is a way to make it show the Inbox. Thanks. Tag: dbf to excell Tag: 210862
  - 23
    - Images and VFP9 I am in the process of moving from VFP7 to VFP9. One problem I have encountered is graphic images on my forms look like crap in 9 when running on Windows 2000 Terminal Server. Granted W2K only supports up to 256 colors, but my VFP7 images looked OK. Any suggestions? I have already tried SET PALETTE OFF, but this does nothing. BMP's look the best, and GIF's look really horrible. All the images are 256. Tag: dbf to excell Tag: 210859
  - 24
    - HyperlinkButton opens hyperlink minimized I am creating a small form with Hyperlinks to sites our intranet uses. The difficulty I am having is finding out how to have the hyper link open and take focus. When the user clicks the link, I would like it to open IE full screen so they can see what they clicked on. right now it is minimized to the start bar. I looked at the code ont he sample hyperlink.scx, and theirs doe the same thing. Dan Tag: dbf to excell Tag: 210858
  - 25
    - VFP Linked Sql Server deleted records I created a linked server to vfp from SQL server. I have no problem querying records with one exception. I can't seem to filter out deleted records. I'm using the VFP 8 Oledb driver. Tag: dbf to excell Tag: 210854

Can I export a large dbf to excell to use multiple worksheets in excell.
The file is to large for only 1 worksheet.
thanks
sherry

Re: dbf to excel by aNOpengellySPAM

aNOpengellySPAM
Fri May 06 11:30:31 CDT 2005

sherry,

> Can I export a large dbf to excell to use multiple worksheets in
> excell.
> The file is to large for only 1 worksheet.

I have a routine buried (a couple of years ago) somewhere which dealt
with this by forming as many .csv files as required. If it helps I
will dig it out if requested.

There is an earlier thread starting 181473 ...

regards
Alan

RE: dbf to excell by Leemi

Leemi
Fri May 06 14:07:22 CDT 2005

Hi Sherry:

I don't have code that does this exact process, but I think you can modify
the code in this article and get what you need:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;142193

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP9 HAS ARRIVED!! --*
Read about all the new features of VFP9 here:
http://msdn.microsoft.com/vfoxpro/

*--Purchase VFP 9.0 here:
http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
69-4500-8bf2-3f06689f4ab3&type=ovr

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003

>Can I export a large dbf to excell to use multiple worksheets in excell.
>The file is to large for only 1 worksheet.
>thanks
>sherry

Re: dbf to excell by Dan

Dan
Tue May 10 11:56:03 CDT 2005

There's nothing that will do this automatically, but using
_VFP.DataToClip(Alias(),nNumberOfRecords) and Excel's Paste method you can
build the Worksheet yourself fairly easily.

Dan

sherry wrote:
> Can I export a large dbf to excell to use multiple worksheets in
> excell. The file is to large for only 1 worksheet.
> thanks
> sherry