Update query on an access database

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
    - 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: Update query on an access database Tag: 227541
  - 2
    - 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: Update query on an access database Tag: 227529
  - 3
    - 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: Update query on an access database Tag: 227528
  - 4
    - 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: Update query on an access database Tag: 227527
  - 5
    - 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: Update query on an access database Tag: 227525
  - 6
    - 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: Update query on an access database Tag: 227522
  - 7
    - 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: Update query on an access database Tag: 227512
  - 8
    - 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: Update query on an access database Tag: 227509
  - 9
    - 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: Update query on an access database Tag: 227506
  - 10
    - 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: Update query on an access database Tag: 227500
  - 11
    - 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: Update query on an access database Tag: 227499
  - 12
    - 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: Update query on an access database Tag: 227493
  - 13
    - 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: Update query on an access database Tag: 227491
  - 14
    - 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: Update query on an access database Tag: 227479
  - 15
    - 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: Update query on an access database Tag: 227469
  - 16
    - 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: Update query on an access database Tag: 227466
  - 17
    - 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: Update query on an access database Tag: 227463
  - 18
    - 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: Update query on an access database Tag: 227462
  - 19
    - 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: Update query on an access database Tag: 227459
  - 20
    - 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: Update query on an access database Tag: 227446
  - 21
    - 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: Update query on an access database Tag: 227444
  - 22
    - 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: Update query on an access database Tag: 227440
  - 23
    - 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: Update query on an access database Tag: 227427
  - 24
    - 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: Update query on an access database Tag: 227426
  - 25
    - Index database For vfp database, i can type'reindex table name' for SQL server, how can I do that?? thanks a lot Tag: Update query on an access database Tag: 227425
- Next
  - 1
    - 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: Update query on an access database Tag: 227421
  - 2
    - 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: Update query on an access database Tag: 227402
  - 3
    - BeforeOpenTables "swap" in AfterCloseTables Hi to all, this is my first post to this NG. I'm using vfp6 sp5 and often source code in BeforeOpenTables is replaced with source code of AfterCloseTables and viceversa. Usually this happens when I'm saving forms. PC is winxp home ed. with SP2 and no virus or spyware was found. Anybody has experience about this trouble? TIA, paolo Tag: Update query on an access database Tag: 227400
  - 4
    - Access a vb.net DLL from VFP 8.0 I have a DLL written in vb.net that works great when it is called from another vb.net program. My problem is that I can't get it to work from VFP. The call that I use in vb.net looks like this: Dim pf As New PrintFile.PFile Private Sub Sub1() Dim rcpf As Integer rcpf = pf.PrintRawFile("HP LaserJet 8100 in Server Room", "c:\docs\ptest.prn") End Sub When I call it from Visual FoxPro with a method like the following: DECLARE integer PrintRawFile IN printfile string @ Pname, string @ Pfile tname = 'HP LaserJet 8100 in Server Room' + CHR(0) tfile = 'c:\docs\ptest.prn' + CHR(0) i = PrintRawFile(tname, tfile) I receive the message: "Cannot find entry point PrintRawFile in the DLL". From this we can determine that it is finding my DLL, it just can't find this entry point. Can anyone help me with how to access a non-COM DLL from VFP? Thanks in advance! Rex Tag: Update query on an access database Tag: 227392
  - 5
    - Copy To and memo fields? Hi, I'm writing an application to run on a Palm PDA using Satellite Forms and VFP 9.0. I have a problem in that SF doesn't support memo fields but it does support large character fields. I'm pulling my data from a SQL 2000 Server backend with remote views and then using the COPY TO... with the FOX2X file type. The reason here is that SF supports dbase file formats for it's tables. My question is, is there a way to convert a memo field to a large character field? I believe that the largest a character field can be in VFP is 256 characters which isn't enough for the data I'm trying to move around. Does this limit exist for dbase files too? In SF I can create a character field of over 4000 characters. I wonder if I can include a CAST() function in my COPY TO command, I'm guessing not. Any suggestions? Thanks in advance, Linn Tag: Update query on an access database Tag: 227390
  - 6
    - trigger on view Hi, We have a problem with a view that gets closed somewhere along the process of our program, but be have no clue where the error is. Is there some way to trigger code that is excecuted when a view is closed so we can trap the problem ? Something like a trigger for a table. thankx Xavier Tag: Update query on an access database Tag: 227381
  - 7
    - how to create a string of values that can be used to insert in SQL server I am trying to create a string depending on the cursor fields & its type to be used to pass it to insert command for SQL server. I am having 2 problems 1> How to include character fields with quotes, square brackets & other special characters. 2> How to send date fields. Rajesh Tag: Update query on an access database Tag: 227375
  - 8
    - top level form menu I have a menu on a top level form. When I select the menu pads with the mouse all works as expected. However, I'm having difficulty getting that top level form menu to activate on an ALT+ key sequence. Example: The \<File menu pad appears normally and appears that an ALT+F would activate it, but it does not. The menu is being called from the INIT() of the form as: SET SYSMENU OFF DO mymenu.mpr WITH this, 'mymenu' Are there any special considerations with top level form menus to get them to trigger when an ALT+ key sequences are typed? -- Alec Gagne Crimestar Corporation www.crimestar.com Tag: Update query on an access database Tag: 227367
  - 9
    - skype Hello and thanks in advance for the help. Has anyone developed apps using Skype? Do you have any sample code you'd be willing to share? I can't quite figure out what Skype wants me to do to use their control. Thanks for the help. Jeff Tag: Update query on an access database Tag: 227362
  - 10
    - VFP: Remembering maximized window position Hello, If I close a maximized form, I want the position maximized the next time the form is run. I suppose this is INI issue, but not sure how to implement. Please help. RS Tag: Update query on an access database Tag: 227354
  - 11
    - Editbox lost focus issue I can't reproduce the following 100% of the time, but it seems to me that if I exit an editbox in one of my forms by clicking on a listbox (and/or perhaps elsewhere) on the same form, the underlying tables are not always updated properly. The update is accomplished via sql statements in the lostfocus() event of the control. There is no controlsource and the fields in question are character memo fields. The lb does drive the table that stores the data, but I can verify that this is not a case of the data being written to the wrong record. One obvious question is: Is there any way to exit an eb control that won't fire the lostfocus() event? TIA. -Lew Tag: Update query on an access database Tag: 227351
  - 12
    - Monitor Network Activity Does anyone know of a way to monitor network activity to a specific IP Address programmatically? Hereâ??s the situation. We have an IP Phone system in the office (Itâ??s a Mitel system if that makes any difference). Our computers are all connected to our phone via network cables, which is then connected to our network. Each phone has its own IP (i.e. 10.10.2.x) Basically, Iâ??m looking for a simple way to check to see if someone is on their phone. We could become certified with Mitel to develop software for our phone system, but that requires training, time, money, etc... and it is probably overkill for what we currently need. So I figured if we could just pole the network activity to the phone, that would probably indicate to us that the phone is in use. Any ideas on how this can be accomplished? Is there any APIâ??s or something else that would work? Thanks in advance, Jerry Tag: Update query on an access database Tag: 227349
  - 13
    - Time limited demonstration program Where can I find instructions on the best way to create a time limited demonstration program? I'd like to create one of those that dies after so many days and they have to enter a registration code to get it going. Thank you Tag: Update query on an access database Tag: 227347
  - 14
    - converting from vb Hi there, need some help here. I'm developing a program to extract data from a smartcard. The sample program from the development kit that come with the smartcard reader was develop using VB. I'm having problem in getting the picture from the smartcard into my vfp form. In VB, the code is : Set Image1.Picture = MyKad1.Photo In my vfp form, I put Thisform.Image1.Picture=MyKad1.Photo but when the code is run, got error message, invalid data. Anyone knows how to do it in vfp. Mykad1 is actually an ocx for the smartcard reader. Tag: Update query on an access database Tag: 227340
  - 15
    - VFP 9 SP 2: How is It Running? I installed VFP 9 SP 2 not too long ago. Since then, I have observed a number of crashes. SP1 was stable. I write this as I just had to delete foxuser.* AGAIN. This time, it was because I could not modify a table that I needed to change for debugging. I would simply start VFP, do my normal setups, open the table, locate the row, browse, change the value in question, save, and BAM! C0000005 everytime! Deleting foxuser.* got rid of the problem. Rebooting did not. And how have your VFP 9 SP 2 experiences been? Is anyone using it? (Is it really my turn to be bleeding edge, or is everyone else doing fine with it?) Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: Update query on an access database Tag: 227334
  - 16
    - Street Type Validation Anyone have a street type validation process? I need something that when given a string will return true if the string is a valid street type (including abbreviations). For example, if given "Avenue" or "AVE", it will return .T., but if given "Fred", it will return .F. I'm writing an address parser and need to be able to identify street types. Thanks! Charlie Parker Tag: Update query on an access database Tag: 227329
  - 17
    - VFP 9 SP2: Command Window ?Bug Twice now, my command window has become messed up. Normally, there is space between the leftmost character in each line and the left frame of the window. This has disappeared. Commands still work fine, but the cursor is no longer visible when it is at the beginning of the line. Since I frequently repeat previous commands, this is bothersome. Deleting foxuser.* does get rid of the problem. It also gets rid of my useful settings. At least I have not had to lose a bunch of debugger settings. This has happened only since switching to VFP 9 SP 2. I have not changed the general way that I use VFP since switching to 9. Am I missing a setting? Is there a workaround? Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: Update query on an access database Tag: 227324
  - 18
    - VFP 9: Maximum String Length According to the VFP 9 docs under "Visual FoxPro System Capacities", the maximum string length is 16777184. What is the true maximum, and where is it documented? Adding characters ten at a time, I created a string of 40 million characters. If I start with one character and double, I get an error 1903 (String is too long to fit.) after 16777216 (2^24). (This is odd since twice that is less than 40 million.) If I start with one character and double up to 16777216, then add 1 MB at a time, I get an error 43 (There is not enough memory to complete this operation.) after 383778816 (over 1/3 GB). Since it is possible to create some very long strings and yet get errors on shorter strings, what are the rules for l-o--n---g strings? Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: Update query on an access database Tag: 227323
  - 19
    - Illegal regursion in triggers I know there's a way to do this, but I just don't remember. I have a table with a timestamp field which contains the datetime() of the last update and I want it to be updated whenever any change is made to a record and regardless of any table buffering. I'd like to use the update trigger but, of course, updating the timestamp in the trigger just creates the illegal recursion error (as it should). Suggestions? -Lew Tag: Update query on an access database Tag: 227310
  - 20
    - SuperClass Utility for VFP 5 The one I found needs VFP 6 or above. Anyone got a version for 5? Please kindly attach here... -- iTech Consulting Co., Ltd. Website: http://www.itech.com.hk (IE only) Tel: (852) 2325 3883 Fax: (852)2325 8288 Tag: Update query on an access database Tag: 227300
  - 21
    - Where are the codings? Hi everyone, I've downloaded a class (.vcx). This vcx is based on a custom class. When I open up the vcx file, there is no coding in the methods but it is working when the method was called. How can this possible? Where are the codes? By the way, I'm new to vfp. Hope someone can explain this to me. Thank you. Tag: Update query on an access database Tag: 227294
  - 22
    - vfp 9 app running in Vista Hi, Our application when running under Vista RC2 has some issues with displaying the forms. Some vfp forms show up fine, but a lot show the form but no title bar or form border, just the grey form area is showing. Is this a known problem, any fixes? Thanks Tristan Tag: Update query on an access database Tag: 227290
  - 23
    - VFP9: Keypress via command button? Hello, This stupid question has got me stumped! How do I press F2 key within command button? Way back when I thought INKEY() was the answer, but.... Thanks for the help. RS Tag: Update query on an access database Tag: 227280
  - 24
    - Update SQL problem I'm having some troubles with an update statement, using VFP 9, and it's driving me buggy, might someone see what I've incorrectly done? I have two tables: Master - has dozens of fields, approximately 10000 records Corrections - Has five fields (item, serial, firstrent, origcost, acquired), 500 or so records The last three fields in the Corrections table need to be changed in Master, based on the combination item+serial matching in Master, so I know there are about 500 records that will be updated. When I use the code below, I get 0 records updating. I suspect it has to do with my Where clause, and have tried many different derivations. Can someone help? UPDATE Master; SET acquired = b.acquired, firstrent = b.firstrent, origcost= b.origcost; from Corrections b; where b.item+b.serial = Master.item+Master.serial Thanks- Brian Tag: Update query on an access database Tag: 227274
  - 25
    - Writing to/Reading From USB Device Directly I have a device on a usb port which I can successfully write directly to. However, I am experiencing difficulties reading directly from the port. Everything below works (the commands go to the device) until it gets to the readfile portion. The device is sending data back but the readfile() is not capturing it. Any ideas? *--lc_DeviceName is returned from SetupDiGetDeviceInterfaceDetail lh_Device = CreateFile(lc_DeviceName, ; GENERIC_READ + GENERIC_WRITE ,; FILE_SHARE_READ + FILE_SHARE_WRITE, 0, OPEN_ALWAYS,; FILE_ATTRIBUTE_NORMAL + FILE_FLAG_SEQUENTIAL_SCAN, 0) IF (lh_Device != INVALID_HANDLE_VALUE) && Later test using DeviceIoControl From Lh_Device also lw_Buffer = SPACE( MAX_PATH ) lcSendValue = [! U1 MCR 80 T1 T2] + CHR(10) + CHR(13) && a command the USB device recognizes lnWritten = 0 IF WriteFile(lh_Device, lcSendValue, LEN(lcSendValue),@lnWritten,0) <> 0 && 0 is failure *!!!! Success - the device responds to the command sent *!!!! Now capture the data returning from the device (the response) lcReadBuffer = REPLICATE(" ",MAX_PATH) lnBytesReturned = 0 lnCounter2 = 0 *--Latest attempt is to loop through a read for awhile DO WHILE lnBytesReturned == 0 lncounter2 = lncounter2 + 1 IF ReadFile(lh_Device, @lcReadBuffer, LEN(lcReadBuffer), @lnBytesReturned, 0) <> 0 lncounter = 0 DO WHILE lncounter < 50 lncounter = lncounter + 1 DOEVENTS IF !EMPTY(MakeANSI(lcReadBuffer)) ? lcReadBuffer ? MakeANSI(lcReadBuffer) ENDIF ENDDO * ADD GetQueuedCompletionStatus() ENDIF IF lncounter2 = 100 EXIT ENDIF ENDDO ENDIF CloseHandle( lh_Device ) ENDIF Tag: Update query on an access database Tag: 227273

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

Top

Re: Update query on an access database by KevClark64

KevClark64
Thu Oct 26 13:49:21 CDT 2006

Never mind, I figured it out. Turned out I was trying to update a
field label name, rather than a field. IdNumber should have been ID.

Kevin Clark

Top

Re: Update query on an access database by Bernhard

Bernhard
Thu Oct 26 14:00:49 CDT 2006

Hi Kevin,

> 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.
You already found the bug.
But instead of macro, hard coding etc. use ODBC parameters: include a foxpro
variable (or even a complex foxpro expression) preceded by a question mark.

retval=SQLEXEC(ODBChandle,"update [addresses - MASTER LIST] set zip=?tmpVal
where idnumber=2879")

Regards
Bernhard Sander

Top