MS Access ODBC driver (VFP 9.0)

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
    - Handling apostrophes in strings? Hi, I'm using VFP 9.0 and have run into a little problem when storing names in strings. If I have a contact's address with a street name like, O'Keefe Ave, do I have to do anything with the apostrophe to keep it from premeturely terminating the string? What I'm doing is scaning a table and exporting records to an Access database using ODBC and SQLEXEC(). To do this I'm building a string for the values component of an INSERT statement. Like this... myString = myString + "', '" + myTable.addr_1 + "', '" + myTable.addr_2 + "', '" + myTable.city + "'" What would be the best way to handle this on the fly? Or, is there a better way to perform my task? Any help is greatly appreciated, Linn Tag: MS Access ODBC driver (VFP 9.0) Tag: 227633
  - 2
    - Launching Internet link from memo fields I find this works in VFP 7.0 and 9.0, but when running from runtime it doesn't work. Is it only available when run from the development environment? Thanks. Dan Tag: MS Access ODBC driver (VFP 9.0) Tag: 227625
  - 3
    - strange behaviour of form environment I have a form with three tables in the environment, standord, accounts, and utility. The INIT selects standord and creates an array which fills a listbox. This is OK and the form appears as it should, If I then SUSPEND and ? ALIAS() it tells me that utility has been selected. If I then SELECT STANDORD it tells me that standord does not exist. I have even made a temporary textbox which INIT fills with the alias in its last line, which show standord. But without any other action except suspending it, the table changes. There is nothing in the INIT which calls utility and there is no coding in ACTIVATE or anywhere else that I can find (for example in the class structure) which could select utility. Nowhere (until much later in the calling prg) do I remove standord from being used. Can anyone suggest what might be happening ? I need to select standord for the form to do some processing. -- Tim Hobson Tag: MS Access ODBC driver (VFP 9.0) Tag: 227624
  - 4
    - Meta-Data or Actual Data Hey All, I want to fetch the number of records in a given table via the ODBC driver. This is not related to any particular query... Just some "statistical" information. (IE, you have 10,000 contacts in your database) I know I can use the RECCOUNT() function in FoxPro "native"... Which I assume pulls from the metadata of the table. Is there an equivilant for the ODBC driver (other than a SELECT COUNT() FROM Table, which I assume reads every record in the table) Thanks! Matt Tag: MS Access ODBC driver (VFP 9.0) Tag: 227623
  - 5
    - setall() & .Nulldisplay I'd like to use thisform.SetAll to set all the nulldisplay properties to a value that makes control.values look blank, but I can't find the right combo of equal signs, quotation marks and square brackets to do it. =space(1) in the property sheet and similar just move the insertion point to the end of the invisible space when the control gets focus. I'd rather not use set nulldisplay since a global setting has effects elsewhere. -Lew Tag: MS Access ODBC driver (VFP 9.0) Tag: 227621
  - 6
    - Quicken or Money to VFP What's the shortest programmatic route from either of these to VFP? Are there free api's? Any good? -- -Lew The workers took the robot for Maria. Tag: MS Access ODBC driver (VFP 9.0) Tag: 227614
  - 7
    - updates? Anyone know the scheduled release date for the "official" SP2 for VFP9? I hear there are problems with the current beta SP2. What about Sedna? When? Are there good things in there that make it worth spending the time to look at the beta? Tag: MS Access ODBC driver (VFP 9.0) Tag: 227606
  - 8
    - Registration or Activation Code engine Does anyone know where I can get some kind of Registration or Activation Code generator and engine for my VFP 9.0 applications? Thanks. -Paul Tag: MS Access ODBC driver (VFP 9.0) Tag: 227604
  - 9
    - What else is there like VFP? The original dbase and to some extent all of the xbase descendants like VFP are interactive, adhoc, one-command-at-a time, data creation, data examination, and data manipulation languages. Starting with a few commands in the Command Window, you can feel your way into a problem and eventually build a program with reports, queries, screens, etc. xbase is like a giant calculator with a ton of functions. My question is, is there any product or environment out there that has the same simplicity and flexibility as xbase? Should one be learning or experimenting with some other programming environment? (esp. if VFP wanes). What would it be? Tag: MS Access ODBC driver (VFP 9.0) Tag: 227600
  - 10
    - Rotation tab How come I don't see a "Rotation" tab when I select a label on the report header and choose property? I use VFP9 SP1 thanks HME -- --------------------------------------------------------------------- "Are you still wasting your time with spam?... There is a solution!" Protected by GIANT Company's Spam Inspector The most powerful anti-spam software available. http://mail.spaminspector.com Tag: MS Access ODBC driver (VFP 9.0) Tag: 227599
  - 11
    - send CTRL and "+" to application VFP7 XPSP2 I have known lately that sending CTRL and "+"' to a grid or listview will automatically adjust column width in the grid (Windows Shortcut). how i can send CTRL and '+' using KEYBOARD in VFP? I found this code to for C SendKeys.Send ("^{+}"); http://www.codeproject.com/cs/miscctrl/AutoResize.asp Thanks in advance Tag: MS Access ODBC driver (VFP 9.0) Tag: 227589
  - 12
    - Updating Balance Field Hi, Just want some suggestions on the following issues. I currently have a Balance Field in my Invoice.DBF that gets updated with every payment. In a multi-user environment, I encountered a problem when the balance field was updated by two different user, with both user entering different payment amount. The balance was incorrect because the calculation was based on the user that last saved the data. eg. Invoice amount : $1,000 Invoice Balance : $1,000 User 1 - Entered $400 as Payment User 2 - Entered $500 as Payment Both user was entering their data at the same time, User 2 being the last to click the save button. Invoice Balance : $500 (which should be $100 only) I really need to maintain the Balance Field so I could trace which invoice is still unpaid. There are times that the clients pays only the latest invoice so I could not implement a running balance on the program. Thanks for any ideas or comments you can give. Tag: MS Access ODBC driver (VFP 9.0) Tag: 227588
  - 13
    - Table buffering issues VFP 7 SP1 Hi all, One of my forms is using table buffering and the records are filtered using SET KEY. If two users are adding records in a grid, users A data may show on users B screen. I remember hearing somewhere this may be a bug. If it is, is it fixed in VFP 8 or 9. I am thinking this is a bug since the data is being filtered and the key value for the filter is different on both machines, also table buffering is involved here so why would one user see another users. Though I am not sure if user A saved before user B saw the data or not. VFP 7 SP1 on WinXP Sp2 and Win2K workstations. And yes we are thinking of going to version 9 sometime. Thanks for any input Tom Tag: MS Access ODBC driver (VFP 9.0) Tag: 227582
  - 14
    - SAPI Memory Leak I am using SAPI V5.1 speech recognition in my VFP8 based application. I have noticed that this automation server (sapisvr.exe) keeps using more and more memory. Is this a memory leak or is this normal? The only way to release this memory is to re-start this process. Some of the details are as follows... 1. My OLE, implementing the SAPI events, is session based. I have also ensured that all 'CreateObject()' based objects are made NULL before the object references are released. 2. I have created one Public variable that references a 'container' class based object. All the objects that are required for this SAPI (and created thru createobject command) are referenced thru the custom 'properties' of this container object. 3. The application uses CFG only for short periods but is in dictation mode for most of the time. Thanks Sati Tag: MS Access ODBC driver (VFP 9.0) Tag: 227581
  - 15
    - DEFINE WINDOW This is a multi-part message in MIME format. ------=_NextPart_000_000E_01C6F9C9.60C9F9F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable When I used in FPW 2.6: DEFINE WINDOW bro at 12,2 SIZE WROW()-13,1.09*WCOL() noclose FLOAT = NOZOOM GROW I got a window with three pull-down options on the upper left corner: Move Ctrl+F4 Size Ctrl+F8 Next Window Ctrl+F6 but in VFP 9 the same command just gives Move (wihout CTRL)=20 Size (without CTRL) and there is no "Next Window" How come this different behaviour. How can I achieve my old FPW 2.6 = behaviour? ------=_NextPart_000_000E_01C6F9C9.60C9F9F0 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.2963" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2>When I used in FPW 2.6:</FONT></DIV> <DIV><FONT face=3DArial size=3D2>DEFINE WINDOW bro at 12,2 SIZE=20 WROW()-13,1.09*WCOL() noclose FLOAT NOZOOM GROW</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I got a window with three pull-down = options on the=20 upper left corner:</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Move Ctrl+F4</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Size Ctrl+F8</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Next Window Ctrl+F6</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>but in VFP 9 the same command just=20 gives</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Move (wihout CTRL) </FONT></DIV> <DIV><FONT face=3DArial size=3D2>Size (without CTRL)</FONT></DIV> <DIV><FONT face=3DArial size=3D2>and there is no "Next = Window"</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>How come this different behaviour. How = can I=20 achieve my old FPW 2.6 behaviour?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV> </DIV></BODY></HTML> ------=_NextPart_000_000E_01C6F9C9.60C9F9F0-- Tag: MS Access ODBC driver (VFP 9.0) Tag: 227579
  - 16
    - Varchar mapping, varchars & sql I'm having difficulty with the following concept. Does anyone have the patience to explain it? Situation: I have a table in which all of the char fields are type varchar and my app runs with varcharmapping on and set exact off . When it comes time to run a few simple queries I get rows with blank values when the where clause compares one of these fields to a character literal like where extension = "PJX" I have already determined that I can get the results I expect if I change this to: where extension == "PJX" but I can't understand how or why comparing an empty column value to a non-empty string can return .t. since the command line statements: ? "" = "PJX" && -> .f. and ? "PJX" = "" && -> .t. both make perfect sense to me, but the query suggests that "" = "PJX" is true. (VFP9/sp1, enginbehavior 90 if that makes a difference). -Lew Tag: MS Access ODBC driver (VFP 9.0) Tag: 227574
  - 17
    - Calling a form in a do while statement If I am calling a do while statement on a command button in the Click event and say I'm processing 6 records and I insert a case statement that calls a form based on a case statement does the do while stop at that point then continue after the form is executed or continue? I do make the form enabled=.f. before I call the new form. How can I control the program code if at all if it does not stop? Thanks -- Rusty Gallo OGES Systems Tag: MS Access ODBC driver (VFP 9.0) Tag: 227572
  - 18
    - [VFP 5] Enabling cut-and-paste without set sysmenu on Can it be done? -- iTech Consulting Co., Ltd. Website: http://www.itech.com.hk (IE only) Tel: (852) 2325 3883 Fax: (852)2325 8288 Tag: MS Access ODBC driver (VFP 9.0) Tag: 227561
  - 19
    - date format now the date format is 23-10-2006, my client want it to be 23-Oct-2006 Any simple method to do ?? Thanks a lot Tag: MS Access ODBC driver (VFP 9.0) Tag: 227558
  - 20
    - setup in genmenu.prg: grrr! I have a prg, setup.prg, which I run at the beginning of every application. Every now and then, however, the nasty, little setup function in genmenu.prg runs in it's place. I haven't a clue as to why this happens. Genmenu's location isn't in my path statement and I don't have any rogue set procedure statements. Any ideas? -Lew Tag: MS Access ODBC driver (VFP 9.0) Tag: 227552
  - 21
    - Porting FoxPro 2.6 Windows app to VFP 9 I can find references to porting to VFP 6 but not with VFP 9. I guess it is not very common. I wonder how much work is involved? Does anyone have any experience with this or can offer a suggestion on what to watch out for? Thx, Long Tag: MS Access ODBC driver (VFP 9.0) Tag: 227549
  - 22
    - Can I Intercept List.Click Before Pointer Moves VFP9 When the user clicks in my list (object), the record pointer changes and the new record is displayed just fine. Here's the setup code for the list: WITH .List1 .ControlSource = 'Jobs' .RowSourceType = 6 && 6=Fields .RowSource = 'Jobs.ModelName' ENDWITH Is there some event that occurs after the click but before the record pointer moves? Here's why I ask: I want to "intercept' the Click event and/or the Up/Dn arrow keys before the pointer moves so I can detect if any changes were made to the original record. I tried code in the InteractiveChange & Click events, but it seems these events occur only AFTER the record pointer moves to the new record. I also tried using the Valid event, but Valid doesn't seem to fire at all. I eventually kludged it to return to the original record to detect the changes, then back to the newly selected record, but I feel there must be a better way. Is there? Steve M. Tag: MS Access ODBC driver (VFP 9.0) Tag: 227548
  - 23
    - Update query on an access database I am trying to run an update query on an access database from FoxPro, and I keep getting the error: Too few parameters. Expected 1. I can connect to the table and run a select with no problem. The query I am running is: retval=SQLEXEC(ODBChandle,"update [addresses - MASTER LIST] set zip='&tmpVal' where idnumber=2879") I have tried just about every combination of brackets and quotes that I can think of. I have also tried hard coding a value instead of using a macro. Nothing works. Kevin Clark Seton Home Study School Tag: MS Access ODBC driver (VFP 9.0) Tag: 227545
  - 24
    - Grid and Combo Box weirdness i have a grid with a combo bow on a column the combo box recordsourcetype is set to values and the values are Full,View,Hide which is tied to a numeric column and sparse is false when the the form loads the data all appears correct and the Full,View, or Hide text shows up properly in the combo box however, when i change the selection in any of the combo box's, all the combo's switch to showing just the first letter of the text, like F,V or H.... any idea whats happening or how to fix this? Tag: MS Access ODBC driver (VFP 9.0) Tag: 227541
  - 25
    - How to make One 2 many relationship when use remote view. Dear all I 'm a newbies for use BackEnd Oracle. I was started develop accounting application by VFP9 for front end and Oracle 8i for BackEnd. Due to i no have exprerience about Oracle. Then i scare and no understatding how-to. My point is very clear : When you use foxpro table you can use SET RELATION to make an One 2 many relationship but How to do in Remote views? Please give me more detail suggestion and i hope to get answer as soon as possible. Best Regards, R. Prawit Bangkok/Thailand. Tag: MS Access ODBC driver (VFP 9.0) Tag: 227529
- Next
  - 1
    - Chado Spell-Edit Has anybody got any experience of mail-mailing in vfp using the Chado Spell-Edit activex control? The Merge event does not seem to be firing, and Chado, whilst being very courteous and helpful, are not able to solve the problem because they have no vfp expertise. Many thanks Stephen Tag: MS Access ODBC driver (VFP 9.0) Tag: 227528
  - 2
    - SQLSETPROP / DisconnectRollback in http://msdn2.microsoft.com/en-us/library/dtytxez4.aspx Microsoft describes the new property <DisconnectRollback> in VFP 9. When for example the system crashes open transactions are rolled back. The default setting does not do that and also the previous VFP Versions dont support that. Unfortunately I have to develope some projects with older versions of VFP than version 9. So my question is: Is it possible to achive the same effect by using for example ODBC-API functions like o SQLSetConnectOption oder o SQLSetConnectAttr o ... If it is possible how is it done exactly ? I tried to debug this by using an open source odbc-driver but none of the exported functions was called when executign the command: SQLSETPROP(oApp.hCon, 'DisconnectRollback', .T.) Many thanks in advance Lutz Tag: MS Access ODBC driver (VFP 9.0) Tag: 227527
  - 3
    - Killing a process I found some code on here a while ago ( i can't remember who posted it), which allowed you to kill a named process on a computer. As i was creating a new part of our package that lived in a seperate executable at that time, i decided to incorporate it. i recently found that the code had a slight flaw when used in a terminal server environment, where it will kill everyones process, not just the process for the user who was running it. So i did some research and came up with the following. PROCEDURE kill_it LPARAMETERS what_to_kill LOCAL user,domain,m.lcsystemstring oWMI = GETOBJECT('winmgmts:{impersonationLevel=impersonate}') cQuery = "select * from win32_process where name='" +ALLTRIM(what_to_kill) +"'" oResult = oWMI.ExecQuery(cQuery) FOR EACH oProcess IN oResult m.user = "" m.domain = "" If oProcess.GetOwner ( @User, @Domain ) = 0 m.lcsystemstring = SYS(0) IF TYPE('m.user') = 'C' AND ALLTRIM(SUBSTR(m.lcsystemstring,AT(' #',m.lcsystemstring))) = ALLTRIM(m.user) oProcess.Terminate(0) ENDIF endif NEXT endproc which sounded fine, and works a treat on my local machine. however under terminal server i get an error for some users. ERROR: (1440) OLE exception error: Exception code c0000005. OLE object may be corrupt The error occurs when trying to make the getOwner call, which occording to the documentation should return a number other than 0 if it fails. instead it occasionally errors. This behavoiur would appear to be a security issue, as so far it only happens to people with user rights on the terminal server environment. So in order to get over this, i will now have to trap this error, which should never have happened in the first place! unless someone knows a work around or another way of achieving this? anyway i hope this saves someone else some heartache. Mark Burgum Tag: MS Access ODBC driver (VFP 9.0) Tag: 227525
  - 4
    - VFP: Finding Name of Executable I am using Adobe Acrobat to print to PDF. To do this, I have to write to the Registry the name of the executable. How do I determine this? My thoughts so far: If the app is running as a collection of .fxp files under VFP, then VFP is the actual executable. How do I find out the name of the VFP executable? (I mean the name of the .exe that is VFP.) If the app is running as an .exe, then sys(16,1) does it. If the app is running as an .exe under VFP, then VFP is the actual executable (I think). I can distinguish between this case and the one before using version(2). I think there might be other possibilities such as .app. (I have never used a .app, nor do I even know how they are created.) There is also the possibility of one .exe calling another and on and on. If I have the first three above, that should do it for my case, and I need them anyway before experimenting with the rest. This is somewhat important as my app printing will not work properly under the full VFP. This means that I would not have access to the debugger and that I would have to build the .exe each time I want to test anything to do with PDF printing. Here is my code so far: ***** Start of Included Code ***** * tryname * Try to Get Name of Executable * Last Modification: 2006-10-25 ? "*** Execution begins." set talk off local sys16name, apptype, underruntime, vfpexe, appname sys16name=sys(16,1) apptype=upper(right(sys16name,4)) underruntime=version(2)=0 vfpexe="***insert name of VFP executable***" do case case apptype=".FXP" appname=vfpexe ? "running as .fxp under "+appname case apptype=".EXE" and !underruntime appname=vfpexe ? "running as .exe named "+appname case apptype=".EXE" and underruntime appname=sys16name ? "running as .exe under "+appname otherwise appname="???" ? "running in unknown state" endcase wait ? "*** Execution ends." return ***** End of Included Code ***** Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: MS Access ODBC driver (VFP 9.0) Tag: 227522
  - 5
    - Coming from FPW 2.6 (2nd part) 1) I am migrating my old FPW 2.6 application to VFP 9 just as it is, and when I use the BROWSE command I see on screen that the columns are not wide enough to comfortably accomodate the strings. However, if I double-click with the mouse on the square in the upper left corner just under the title bar of the browse window, all the columns become wider, and can be read easily. How can I achieve the same without intervention of the user by double-clicking? Is there a command that I can include in my program ? 2) when I issue REPORT FORM xxxx PREVIEW NOCONSOLE the report opens by default in a non-maximized window. How can I zoom to maximize without having to handle the mouse? How can I close the preview window by pressing Escape instead of clicking on the little window with the open door? TiA Walter Tag: MS Access ODBC driver (VFP 9.0) Tag: 227512
  - 6
    - Bug in VFP 7 SP1 to watch out for!!!! Am I the only one who didn't know this? I have some test code that creates text files that begin with the letters CO and have no extension. So these files would be "CO*." When I do a directory for these files using DIR CO*. I get a list of the text files that I created. When I then type ERASE CO*. it does the same as if I had typed ERASE CO*.* I don't know if VFP 9 is similarly affected but this could be potentially very bad. Of all commands in the world that should know the difference between xxx*. and xxx*.* erase would be the most important. Also, VFP's erase does not put things in the recycle bin. In my case, everything important was backed up so no real trouble was caused. This is, in my opinion, a very bad bug. Jeff Tag: MS Access ODBC driver (VFP 9.0) Tag: 227509
  - 7
    - Grid.ActiveRow problems Under VFP 9 I have a data grid linked to a table of line items for a sales order. Whenever I go to use the GRID.ActiveRow property it returns a number 1 greater than the number of order item records being displayed (filtered); no matter which row is highlighted or which row is active - e.g. 3 order item records ActiveRow returns 4 no matter which row is selected. ActiveColumn is returning the correct value. Any ideas as to what is causing this. What I am trying to do is automatically add a new record when the user is positioned on the last record and last column and presses Enter, instead of having them click a button to add the line. -- Regards Bob B. Tag: MS Access ODBC driver (VFP 9.0) Tag: 227506
  - 8
    - COM+ over the internet VFP7.0 XPSP2 I want to creatre a com+ server which fetch data from dbf file (exist on internet server) depending on a query , then the result is exported to xls file. then i will download this file to local pc, then import the data from xls to dbf at client pc and show him the result. 1- how i run the com+ server over the internet from client pc ? x = createobject("mydll.myclas") X.RUN_QUERY 2- in my local pc i use the following code in a procedure in the class: USE c:\mydir\mydbf.dbf in 0 shared what is the command i should use to open a table in internet server? USE \internetdir\mydbf.dbf in 0 shared <-- is this correct ? here is my code DEFINE CLASS EXPORT_TO_XLS AS Custom OLEPUBLIC PROCEDURE RUN_QUERY SET EXCLUSIVE OFF USE c:\mydir\mydbf.dbf IN 0 SHARED SELECT UNIQUE_ID, TITLE FROM mydbf WHERE PLATFORM = "PC" INTO CURSOR XXLIST SELECT XXLIST EXPORT TO c:\MYDIR\OUTPUT.XLS TYPE xls USE SELECT MYDBF USE ENDPROC ENDDEFINE Tag: MS Access ODBC driver (VFP 9.0) Tag: 227500
  - 9
    - oleServerBusyRaiseError Does anyone know if you can trap these errors in anyway. I have a .exe which I create within a Custom class object. I would like to trap any busy errors either within the error routine on the custom object or handle it within the .exe. As this is all new to me and the help isn't particularly helpful I am struggling a bit. currently with this property turned on a get an occasional RPC server error which is not very helpful. and if its off I occasionally get my .exe going completely non responsive causing a hang in the main application. I am currently using VFP 8, but even a fix for 9 might help, as we may well be moving to that soon. just for the record the main reason it is going none responsive is because the executable is a phone server using Tapi lines via remote Tapi and a third party activex. We occasionally get problems where this setup goes completely none responsive, and I am unable to do anything tapi related, even with other tapi utilities. I am unsure if the issue is with the TSP on the server, the remote tapi implementation or the actual phone switch. as everything else seems to be working at the time. however rebooting the domain server cures the problem. however I don't expect a resolution to that issue here, as its not a FoxPro issue. just wanted to fully explain the problems. thank you in advance for any help you can give me Mark Burgum Tag: MS Access ODBC driver (VFP 9.0) Tag: 227499
  - 10
    - VFP9 Sp2 Dear All, I installed VFP9 Sp2 and I had problem with BROWSE command, so I reinstalled VFP9 and Sp1. Now the BROWSE command is OK, but I cannot create a report. I have the following error when I want to insert a new field: Variable "VPOS" is not found. Before, I did not have any problem with my VFP9 Sp1. Could anyone help me? Many thanks. -- Sandor Tag: MS Access ODBC driver (VFP 9.0) Tag: 227493
  - 11
    - Directory Listing Is anyone able to advise how to obtain a detailed directory listing from within Foxpro 6 and save it into a text file? Tag: MS Access ODBC driver (VFP 9.0) Tag: 227491
  - 12
    - WSDL ... SOAP .. Fox 6 Windows XP FoxPro 6 sp5 Hi, I need to know if this is possible in Foxpro 6 (the code is Csharp) using System; using System.IO; using System.Net; using System.Xml; using System.Text; using System.Windows.Forms; using System.ComponentModel; using java.io; using java.util.zip; namespace MISI.Sapiens.Client { public partial class Main : Form { public Main() { InitializeComponent(); } private void _btSend_Click(object sender, EventArgs e) { // validate the xml XmlDocument xml = new XmlDocument(); try { xml.LoadXml(_tXml.Text); } catch(Exception) { MessageBox.Show("Invalid Xml."); return; } // get an array of bytes from this xml byte[] buffer = Encoding.UTF8.GetBytes(xml.OuterXml); // compress the xml into a memory stream MemoryBuffer memory = new MemoryBuffer(); ZipOutputStream zip = new ZipOutputStream(memory); // create the zip file entry ZipEntry entry = new ZipEntry("XPTO.xml"); entry.setMethod(ZipEntry.DEFLATED); zip.putNextEntry(entry); for(int i = 0; i < buffer.Length; i ++) { zip.write(buffer[i]); } zip.closeEntry(); zip.close(); // read the compressed bytes from the memory stream memory.Stream.Position = 0; buffer = new byte[memory.Stream.Length]; int bytes = memory.Stream.Read(buffer, 0, buffer.Length); Prototype.Prototype ws = new Prototype.Prototype(); ws.PreAuthenticate = true; ws.Url = String.Format("http://{0}/XPTO.sapiens.webservices/prototype.asmx", _tServer.Text); ws.Credentials = new NetworkCredential(_tUser.Text.Split('\\')[1], _tPwd.Text, _tUser.Text.Split('\\')[0]); MessageBox.Show(ws.Upload(buffer)); memory.Stream.Close(); } } } TIA, ATSP Tag: MS Access ODBC driver (VFP 9.0) Tag: 227479
  - 13
    - Private Data for a function Hello and thanks in advance for the help. If I design a form that uses a private data session, I open and close the tables within the form and everything in the default data session is left alone. Is there an easy way to do the same thing for a function? I know I can USE AGAIN with a new ALIAS and then remember to clean up but is there a simple way to tell VFP that a function uses its own data that is separate from anything that might happen to call it? Thanks, Jeff Tag: MS Access ODBC driver (VFP 9.0) Tag: 227469
  - 14
    - Comment macro or Intellisense script I'm writing a code documenting automation routine & I need a routine that will take a highlighted block of code or text and prefix each line with a short character string of my choosing ... like the Comment/Uncomment options on the Format context menu. I've tried a macro using ctrl-x, alines() & keyboarding the prefixed lines back into the code, but I can't get it to work reliably. Other suggestions? TIA -Lew Tag: MS Access ODBC driver (VFP 9.0) Tag: 227466
  - 15
    - editbox not saving all entries I've got an editbox(edtNotes) with the following parameters: .maxlength = 0 .addlinefeeds= .t. The entries here is stored in a field called notes with 250 char. For some reason when i try add something on the next line, the second line(and succeeding) doesn't save for some reason. Any help? Thanks. Tag: MS Access ODBC driver (VFP 9.0) Tag: 227463
  - 16
    - Add password protection to excel file Does anyone know if there is a way to use foxpro 9 to add password protection to an excel 2003 file? I would like to create a quick form to enter a password and a file name and then have the app password protect the file. Thanks! Tag: MS Access ODBC driver (VFP 9.0) Tag: 227462
  - 17
    - Coming from FPW 2.6 I have migrated an old FPW 2.6 application to VFP 9 just as it was, that means, without any change in code. So, the prg are full of @GET. I face now the problem that the command buttons do not appear in grey as it was in FPW 2.6, but they appear almost with white background, and since the main Fox screen also has white background, the buttons are hard to distinguish, since the contrast is too low between the two whites. What can I do in order to have a really grey background for the buttons? TiA Walter Paul Tag: MS Access ODBC driver (VFP 9.0) Tag: 227459
  - 18
    - Limit CPU Usage I have a VFP7 app that does some pretty major number crunching while generating particular reports. My client has asked that I limit CPU usage to a particular value (say 70%) at specific places within the app. How can I do that within VFP? Thanks, Brian Tag: MS Access ODBC driver (VFP 9.0) Tag: 227446
  - 19
    - VFP 9: Objects: Call by Reference / Call by Value SET UDFPARMS does not cover the case of a parameter being an object. I can not think of where else to check. (@ does not do it <G>.) I need to pass an object to another object. In the processing that the second object does, the first object's state will normally change. The object pointed to by the parameter will not. I realised that I am not sure how to do this. (The first object is a data collector. I can not instantiate the first object in the second object as the first object's lifetime may have to be more than one second object lifetime.) Illustrative snippets: firstobjectref=createobject("firstobject" ... ) secondobjectref=createobject("secondobject",firstobjectref) secondobjectref.somesecondmethod(...) define class secondobject as ... ... procedure init lparameters ... firstobj ... this.firstobj=firstobj ... endproc procedure somesecondmethod this.firstobj.somefirstmethod(...) but not this.firstobj=... Is the createobject() correct, or should it be ... @firstobjectref ... ? How does the answer change if the object pointed to by the parameter could change (and it is to be passed back to the caller)? Any other gotchas to watch for? Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: MS Access ODBC driver (VFP 9.0) Tag: 227444
  - 20
    - UPDATE-SQL problem with keyword (VFP7 SP1) Hi, Following UPDATE statement is giving "Syntax error": UPDATE DataFileTemp ; SET ; Value = ROUND(Value, 0), ; Shares = ROUND(Shares, 0) ; WHERE ALLTRIM(Fund) in (SELECT ALLTRIM(Code) FROM cFunds) I think reason is 'Value' field. 'Value' is keyword. If I remove 'Value' line, statement works fine. How can I update 'Value' field in this scenario? Kamran Tag: MS Access ODBC driver (VFP 9.0) Tag: 227440
  - 21
    - Error - cannot access the selected table. I get "cannot access the selected table." error when runnig exe with Win 2003 terminal services connection. Any idea? Tag: MS Access ODBC driver (VFP 9.0) Tag: 227427
  - 22
    - Declare cursor in init doesn't work? Hi, i use vfp9, with a mysql database. Mostly i use cursoradapters. In one form i want to build my cursor interactively with parameters provided from within the form. To declare the cursor on forehand i call the next line in the init of the form: SQLEXEC(m.lnConn, "select * from klanten where klant_id = 0", "curKlanten") apperently this is not correct as i keep getting an error that the cursor is not found. If i declare the cursor before calling the form everything works fine. What am i doing wrong? Rotsj Tag: MS Access ODBC driver (VFP 9.0) Tag: 227426
  - 23
    - Index database For vfp database, i can type'reindex table name' for SQL server, how can I do that?? thanks a lot Tag: MS Access ODBC driver (VFP 9.0) Tag: 227425
  - 24
    - VFP6.0 still displays the MSChart ActiveX control, when programmatically SETFOCUS() to another page of the pageframe Add to a form the pageframe1 with 3 pages (page1 page2 page3). Add the Button1 into page1 Add the Button3 into page3 Insert ACTIVEX MicrosoftChartControl 6.0 (SP4) into page2. Add the Button2 into page2 with the command THIS.parent.page1.setfocus() into button2.click event. Now run the form and you see button1. Click page2. You see the chart and button2 OK! Click Button2. You see now button1 AND the chart!!!! Click page3. You see now button3 AND the chart!!!! Only if you click page2 again and then page1 or page3 everything its OK again... _vfp.autoyield=.t./.f. does not matter. Is it a bug? Are there any work around? TIA Have a nice day (or night), Nick Pofiris, ErmisPliroforiki Athens-Greece www.ermis-pliroforiki.com.gr Tag: MS Access ODBC driver (VFP 9.0) Tag: 227421
  - 25
    - how to append value from textbox to foxpro table? Hello! I'm a beginner and I started to learn foxpro.... so can you help me with that? I just want type some text into text box and on buton press save that text into foxpro table. How to do that? I need simple source code, please... Can someone please help me with that? Thank's Tag: MS Access ODBC driver (VFP 9.0) Tag: 227402

When I use sqlconnect() and choose MS Access the driver prompts for the
location of the MDB. However, the file dialog does not include Application
data. How can this be avoided?

Re: MS Access ODBC driver (VFP 9.0) by AA

AA
Mon Oct 30 15:44:11 CST 2006

I get to the 'Application Data' folder. Are you adminstrator?
You could try the GetDir dialog which has more parameters, then build a
connection string like
SQLSTRINGCONNECT("DSN=MS Access Database;DBQ=C:\Program Files\Microsoft
Office\OFFICE11\1053\FPNWIND.MDB;DefaultDir=C:\Program Files\Microsoft
Office\OFFICE11\1053;DriverId=25;FIL=MS
Access;MaxBufferSize=2048;PageTimeout=5;
")
-Anders

"Krister" <spam@nospam.smp> skrev i meddelandet
news:Lat1h.21269$E02.8835@newsb.telia.net...
> When I use sqlconnect() and choose MS Access the driver prompts for the
> location of the MDB. However, the file dialog does not include Application
> data. How can this be avoided?
>

Re: MS Access ODBC driver (VFP 9.0) by Krister

Krister
Tue Oct 31 01:34:29 CST 2006

I can reach Appdata from All users, but not for the current user. No change
if I am admimistrator or not.

It is completely lacking in the dialog. And I don't want to use the
sqlstringconnect method, because the code shoulde be the same for different
databases.
/Krister

"AA" <A@A> wrote in message news:usxstLH$GHA.4268@TK2MSFTNGP02.phx.gbl...
>I get to the 'Application Data' folder. Are you adminstrator?
> You could try the GetDir dialog which has more parameters, then build a
> connection string like
> SQLSTRINGCONNECT("DSN=MS Access Database;DBQ=C:\Program Files\Microsoft
> Office\OFFICE11\1053\FPNWIND.MDB;DefaultDir=C:\Program Files\Microsoft
> Office\OFFICE11\1053;DriverId=25;FIL=MS
> Access;MaxBufferSize=2048;PageTimeout=5;
> ")
> -Anders
>
> "Krister" <spam@nospam.smp> skrev i meddelandet
> news:Lat1h.21269$E02.8835@newsb.telia.net...
>> When I use sqlconnect() and choose MS Access the driver prompts for the
>> location of the MDB. However, the file dialog does not include
>> Application data. How can this be avoided?
>>
>
>