CursorFill() as a workaround to Requery() when inside a transaction.

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
    - using view to delete records I have defined two views. create sql view t_theorder remote connect myconn ; as select * from orders ; where orderid=?m.orderid =dbsetprop("t_theorder","view","sendupdates",.t.) =dbsetprop("t_theorder","view","tables","orders") =dbsetprop("t_theorder.orderid","field","keyfield",.t.) create sql view t_theodetail remote connect myconn ; as select * from "order details" ; where orderid=?m.orderid =dbsetprop("t_theodetail","view","sendupdates",.t.) =dbsetprop("t_theodetail","view","tables","order details") =dbsetprop("t_theodetail.orderid","field","keyfield",.t.) =dbsetprop("t_theodetail.productid","field","keyfield",.t.) I then use the following commands to delete the records: m.orderid=t_orders.orderid select 0 use t_theodetail shared =cursorsetprop("buffering",5,"t_theodetail") delete all if tableupdate(.t.) select 0 use t_theorder shared =cursorsetprop("buffering",5,"t_theorder") delete if !tableupdate(.t.) a_error[1]=.f. =aerror(a_error) =tablerevert(.t.) =messagebox("Error deleting header. "+a_error[2],48) endif else a_error[1]=.f. =aerror(a_error) =tablerevert(.t.) =messagebox("Error deleting detail. "+a_error[2],48) endif if used("t_theorder") use in t_theorder endif if used("t_theodetail") use in t_theodetail endif Then I hit an eror "No Update Tables specified. Use the Tables property of the cursor". I had no idea what I did wrong. -- .~. Might, Courage, Vision. In Linux We Trust. / v \ http://www.linux-sxs.org /( _ )\ Linux 2.4.22-xfs ^ ^ 11:08pm up 12 days, 23:40, 0 users, load average: 1.15, 1.07, 1.03 Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189311
  - 2
    - keeping precision of number when converting to string If i have a number in a number field (nsalary) say 100.54 and want to convert it to a string to be exported to a text file that is being manually created, and i use str(nsalary) it returns "101" as the string... how do you get the number back as a unrounded number in a string with the same 2 digit precision? thanks! Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189302
  - 3
    - EXE file behaves different than in Design Evnironment I am just starting with Visual Foxpro. I have been a long time CLIPPER developer and trying to switch to VFP to convert my applications from DOS environment to Windows plateform. I started off with a very simple application with one single form containing 4 variables, 4 labels, 4 text boxes and 2 buttons. I set ShowWindow property of the Form to "2 - AS TOP LEVEL FORM". I put the following code in Init and Activate methods of the form Init thisform.addproperty('ReadEventsFlg',.F. cInfile='KKKKKKKK cOutfile='LLLLLLLL dStart=ctod('01/01/2000' dEnd=date( Activate IF !THISFORM.READEVENTSFL READ EVENT THISFORM.READEVENTSFLG=.T ENDI In CONFIG.FPW, I put only one line SCREEN=OFF. The button named GO displays a messagebox showing values of the variables as entered by the user and CANCEL button has following code in CLICK_EVENT clear event thisform.releas When I run the form in Design environment, everything works fine i.e. the initial values of the variables are displayed as initialized in the Init method. However, when I compile an EXE and run it under runtime, it shows all blank values. I tried moving the initialization code of the variables from Init to Activate method. Then it shows the correct value for the first text box and as I click on other boxes, those values also show up correctly. I want the form to show all four values correctly as the form is first displayed. I have playing with it for 3 days now but with no success I would really appreciate help from the experts and make my entry into FOXPRO world a little easier Thanks in advance..... Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189301
  - 4
    - thousands separator in numeric fields via ODBC Hello, when I select data>=1000 from foxpro numeric fields with decimal places I start receiving a comma as a thousands separator. I've looked through the ODBC help but I'm still not sure why this is happening, any ideas? I'd like to have no separator. -- TIA Andrew Howell Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189300
  - 5
    - Check for numerical values How do I verify a string is a numerical value? Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189298
  - 6
    - Beauty OOP report tool for VFP Dowload: English version: www.oopreport.com/ORT5_1033.rar Chinese(Traditional) version: www.oopreport.com/ORT5_1028.rar Chinese(Simplified) version: www.oopreport.com/ORT5_2052.rar More versions... For more pictures,please goto: http://myf1.net/bbs/dispbbs.asp?boardID=1&ID=238989 Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189294
  - 7
    - VFP Toolbar - beyond a joke Whenever the VFP IDE reappears (ie starting VFP, finishing running an app, etc)("etc"?) the normal toolbar puts my docked project onto a separate line from the standard toolbar, and therefore doubles the height of the bar. I spoke about this before (a long time ago) and y'all said no-one else was seeing this. However I've now got the same effect on a different computer, still a laptop but that's about the only similarity, different operating system (XPH) and different hardware. This has to be a bug shirley? I have (only) the standard toolbar showing. There *is* space for the project to be docked onto the same line. What's going wrong? Grrrrr 8-( Mark Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189292
  - 8
    - remote view and identity column of sql server orders ------------- orderid int, identity, primary key I used a view to open orders on sql server as t_orders. I then append blank a record in t_orders and tableupdate(.t.). How could I know the new value of orderid from sql server? If I issue requery("t_orders"), the record pointer would no longer on the newly appended record. I need the new value of orderid to build a new view with order_details. -- .~. Might, Courage, Vision. In Linux We Trust. / v \ http://www.linux-sxs.org /( _ )\ Linux 2.4.22-xfs ^ ^ 5:38pm up 12 days, 18:10, 0 users, load average: 0.99, 0.96, 0.91 Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189288
  - 9
    - quick question on sql Dear All, I have forgot how to do this, counting the number of record for each customer appear in table sales. I make this, select customer, count() as total from sales group by alltrim(customer) The message keep popping up that the statement has missing expression. Please kindly help me out. Many thanks. Regards, Wandy Tang Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189275
  - 10
    - odbc-configure connection dialog box always prompt, why ? Now, I can create my remote view programically (save as create_view.prg) However, everytime I run the create_view.prg, there is a dialog box prompt out , i need to press "OK" , otherwise, the remote cannot be created. It is very troublsome for the user . Can anyone how to solve it ?? Thanks in advance From agnes My code is shown as below. OPEN DATABASE u:\cgl\vfpseafreight\data\transport.dbc IF INDBC("t_data","connection") = .F. CREATE CONNECTION t_data; connstring ; 'Driver={Microsoft Visual Foxpro Driver};DBQ=u:\cgl\vfpseafreight\data\transport.dbc;BackgroundFetch=Yes' ENDIF IF INDBC("tview","VIEW") = .F. CREATE sql VIEW tview remote CONNECTION t_data AS SELECT number,jobno,closesw FROM billLadingHeader order by number ENDIF Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189274
  - 11
    - curdir fullpath When I use curdir() it does not give the full path, is there any way to do this??? Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189262
  - 12
    - Return value I'm using createobject to reference a class object that consists of a form with a text box. If in the unload event of the class, I'm returning a value, how do I grab the value in the parent form? Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189260
  - 13
    - Is ProFox there? Does anyone know if the ProFox list is running? I haven't heard from it for a while. -Lew Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189257
  - 14
    - UNABLE TO ERASE A FILE I have the following situation. I create a text file from a table that meet a certain condition. I'm using the following command. COPY TO ( cOutput ) FOR STORE <> "CA" TYPE SDF IF no records meet the condition then FoxPro creates a file with zero bytes. The problem that I'm having is that I cannot delete this file until I'm completing out of FoxPro. Here's the error that I'm getting. There has been a sharing violation - The source or destination file may be in use. Does anyone know how I go about closing the file so that I can erase it in the program? Thanks Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189256
  - 15
    - Interface of visual foxpro to C++ routines How can I call a C++ routine from vfoxpro? And How is to complie and linkedit the two modules: a main foxpro with a C++ sub I cannot visualize how join the two softwares. Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189254
  - 16
    - Help!!! how do I get an Icon file. I need ico for imagelist. I neet to get 3 icons (word,excel,pdf) as imagefiles so that I can load them in the imagelist for my tree. How can I get to these Icons. I went to word for example and I couldn't fine the icon file. thanks Nick Patel Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189244
  - 17
    - combobox and bounding the view: t_jobs job_desc job_id ------------- ------ manager 4 clerk 5 n/a 3 I want the value of job_id (column 2) while the form will show job_desc (column 1). The combobox is set up as follows: controlsource=thisform.var rowsource=t_jobs rowsourcetype=1. alias boundto = .t. boundcolumn = 2 whenever I click the combobox to select a value, it always become blank. what step did I miss? -- .~. Might, Courage, Vision. In Linux We Trust. / v \ http://www.linux-sxs.org /( _ )\ Linux 2.4.22-xfs ^ ^ 12:26am up 12 days, 58 min, 0 users, load average: 1.00, 1.01, 1.00 Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189242
  - 18
    - HOW TO CREATE ODBC CONNECTION PROGRAMMICALLY ?? create the connection and view programmically. However, there is an error. Please give me a hand OPEN DATABASE d:\data\account.dbc SET DATABASE TO "account" IF INDBC("acct1","CONNECTION") = .F. Create connection acct1 ; connstring; 'Driver={Microsoft Visual Foxpro Driver};DBQ=d:\data\account.dbc'; CREATE sql VIEW arinvtest REMOTE CONNECTION acct1 AS SELECT * FROM arinvheader endif Thanks in advance from agnes Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189239
  - 19
    - calling button.click() from form.release()? I am using Visual Foxpro 6.0. When a user clicks the "X" button on a form, the form.release() method would be called. Is it possible to make it run the code in cancel_button.click() event first? I think it's a bad idea to call another event from within another event. Right now I disabled the "X" button. -- .~. Might, Courage, Vision. In Linux We Trust. / v \ http://www.linux-sxs.org /( _ )\ Linux 2.4.22-xfs ^ ^ 11:30pm up 12 days, 2 min, 0 users, load average: 1.00, 1.00, 1.00 Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189236
  - 20
    - Populate combobox at runtime How do I populate a combobox at runtime with data from cursor? Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189235
  - 21
    - russian, cyrilliic character font ?? with FoxPro 2.6 Hello, i am using FoxPro 2.6. i want to create a multi language table including different languages. Has somebody an idea, how i can store into a table the cyrillic charater font. And i also want to make a print out of the cyrillic text. is this possible in this old version of foxpro ??? thanks in advance for answers Wolfgang wolfgang@wolfgang-munich.de Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189234
  - 22
    - Page printing selection in VFP report preview. How to select only some pages for printing in VFP report preview. Is is possible to print only current page while viewing the preview Thanks Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189227
  - 23
    - wich field was updated ? I'm writing a trigger in a dbc (VFP6 SP5 + WXP). the same trigger is for update over 250 files, with each around 200 fields. On update, this trigger inserts a record in an other table. All works ok, but I need to store the names of the fields from where this trigger is run. I have alias, dbf, working areas ; if I have field name, I can use oldval and curval.. How can I retrieve field names ? Thank you in advance for help Michel (in France) Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189223
  - 24
    - Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc I create the connection and view programmically. However, there is an error. Please give me a hand OPEN DATABASE d:\data\account.dbc SET DATABASE TO "account" IF INDBC("acct1","CONNECTION") = .F. Create connection acct1 ; connstring; 'Driver={Microsoft Visual Foxpro Driver};DBQ=d:\data\account.dbc'; CREATE sql VIEW arinvtest REMOTE CONNECTION acct1 AS SELECT * FROM arinvheader endif -- Thanks For Your kind Attention. Best Regards, Miss. Agnes Cheng Dynamic Tech Consultants Ltd. T:2264-5583 F:2264-5584 mail : agnes@dynamictech.com.hk Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189222
  - 25
    - [ALT] key cannot open menu while running in EXE I have designed a menu 'MAINMENU' and define the ALT key in [keypress] in menu designer. This menu will be called from a form 'MAIN', The ALT key works while in the design time, after that, I compile it to build an exe file, the ALT key doesn't work. Inside the initial main.prg, I have several environment settings and at last, there is as do form MAIN read events and in the INIT event of form MAIN, the content is do mainmenu.mpr with thisform, .t. Below are some setting of the form MAIN ShowWindow - 2-As Top-Level Form WindowType - 0-Modeless MDI Form - .f. Please, can anyone give me a hand on this issue. thanks lot Edward Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189215
- Next
  - 1
    - How : Create remote view programmically? I try the folllowing code to create the odbc connection and remote view. However, those code didn't work . Canyone give me a hand ? OPEN DATABASE u:\sample\data\tradelink SET DATABASE TO "tradelink" IF INDBC("itts_connection","CONNECTION") = .F. Create connection itts_connection ; connstring; 'Driver={Microsoft Visual FoxPro Driver};'+; 'DBQ="u:\sample\data\tradelink" ;' CREATE VIEW itts_chl CONNECTION itts_connection AS SELECT * FROM CHL -- Thanks For Your kind Attention. From Agnes Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189208
  - 2
    - Promatrix Spam! Just for those of you who don't take kindly to spam (I've never made any approach to Promatrix): Return-Path: <promatrixnews@promatrix.com> Delivered-To: astechsystems@iinet.net.au Received: from unknown (HELO ms-smtp-03.tampabay.rr.com) (65.32.5.133) by mail.iinet.net.au with SMTP; 2 Feb 2004 23:29:03 -0000 Received: from EMACH1 (653220hfc53.tampabay.rr.com [65.32.20.53]) by ms-smtp-03.tampabay.rr.com (8.12.10/8.12.7) with ESMTP id i12NSD1H027087 for <astechsystems@iinet.net.au>; Mon, 2 Feb 2004 18:28:58 -0500 (EST) Message-ID: <4149-22004212232748359@EMACH1> Organization: ProMatrix Corp. From: "ProMatrix" <promatrixnews@promatrix.com> To: astechsystems@iinet.net.au Subject: Professional Visual FoxPro Framework Only $49.95! Date: Mon, 2 Feb 2004 18:27:48 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_84815C5ABAF209EF376268C8" X-Virus-Scanned: Symantec AntiVirus Scan Engine X-Spam-Status: No, hits=3.6 required=5.0 tests=EXCUSE_3,FOR_JUST_SOME_AMT,HTML_40_50,HTML_FONT_BIG, HTML_FONT_COLOR_BLUE,HTML_SHOUTING3, HTML_TABLE_THICK_BORDER,MAILTO_TO_REMOVE, MIME_BOUND_NEXTPART,RCVD_IN_RFCI version=2.55 X-Spam-Level: *** X-Spam-Checker-Version: SpamAssassin 2.55 (1.174.2.19-2003-05-19-exp) ------=_NextPart_84815C5ABAF209EF376268C8 Content-type: text/plain; charset=US-ASCII VPM Standard Only $49.95. Go to: http://www.promatrix.com/mall/vpms01.asp VPM Enterprise 8.1 Now With Multilingual Toolkit and Source Control. Go to: http://www.promatrix.com/vpme/vpme01.htm ------=_NextPart_84815C5ABAF209EF376268C8 Content-Type: text/html; charset=US-ASCII <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <title>Spotlight on  VPM 7</title> </head> <body topmargin="0" leftmargin="0" bgcolor="#FFFFFF"> <div align="center"> <center> <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%"> <tr> <td width="100%" align="center"> <table border="1" width="615" style="border-collapse: collapse" bordercolor="#000080" cellpadding="0" cellspacing="0" bgcolor="#000080"> <tr> <td width="26%" bgcolor="#000080"> <img border="0" src="http://promatrix.com/email/pweb_banner_navy.gif" width="195" height="60"></td> <td width="74%" bgcolor="#000080"> <p align="center"><b><i><font face="Arial" size="7" color="#FFFFFF"> Breaking News</font></i></b></td> </tr> </table> <table border="0" width="615" bgcolor="#000080" cellspacing="0" cellpadding="0" style="border-collapse: collapse" bordercolor="#111111"> <tr> <td width="100%" bgcolor="#000080"> <hr> </td> </tr> </table> <table border="3" width="615" bgcolor="#FFFFFF" cellpadding="3" cellspacing="0" style="border-collapse: collapse" bordercolor="#000080"> <tr> <td> <table border="0" width="100%" cellspacing="3" cellpadding="2" style="border-collapse: collapse" bordercolor="#111111"> <tr> <td width="83%" align="center"> <b><font face="Arial" size="4" color="#000080">News Topics</font></b></td> </tr> <tr> <td width="83%" align="center"> <ul> <li> <b><font face="Arial" size="4" color="#0000FF"> <a href="#Get VPM Standard For Only $49.95">VPM Standard Only $49.95</a></font></b></li> <li> <b><font face="Arial" size="4" color="#0000FF"> <a href="#VPM Standard Multilingual Toolkit Now Only $49.95">VPM Standard Multilingual Toolkit Only $49.95</a></font></b></li> <li><b><font face="Arial" size="4" color="#0000FF"> <a href="#VPM Enterprise 8.1 - Multilingual & Source Control">Introducing VPM Enterprise 8.1</a></font></b></li> <li><b><font face="Arial" size="4" color="#0000FF"> <a href="#VPM Enterprise 8.1 Demo Now Available">VPM Enterprise 8.1 Demo Now Available</a></font></b></li> </ul> </td> </tr> </table> </td> </tr> <tr> <td height="29" bgcolor="#000080" bordercolor="#000080"> <p align="center"> <b> <font face="Arial" size="5" color="#FFFFFF"> <a name="Get VPM Standard For Only $49.95">Get VPM Standard For Only $49.95</a>!</font></b></td> </tr> <tr> <td height="29"> <table border="0" cellpadding="2" cellspacing="3" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber2"> <tr> <td width="100%"> <p align="center"><b><font face="Arial" color="#0000FF">A regards - anthony shipley look, ma - no .sig Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189206
  - 3
    - My grid´s rightclick event is lost Hi all! I have to close and reopen a view to populate a grid (designed in VFP7) in VFP8. This probably because of lack of backcompatibility VFP8 to VFP7. I do this with the code below. SELECT vwRelscomp USE USE vwRelscomp IN 0 SELECT vwRelscomp Requery('vwRelsComp') This.Grid1.RecordSource = 'vwRelscomp' This.Grid1.Column1.Text1.ControlSource = 'vwRelsComp.relname' This.Grid1.Column1.Width = lnCol1Width && saved before closing the view Now the grid is populated again even in VFP8 but the Grid1.Column1's capacity to fire it's rightclick event becomes lost. How can I get the rightclick event (a shorcutmenu designed i the menubuilder) back to work? Regards Christina Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189205
  - 4
    - VFP running Access Query/Macro Hi Do you know of a way to run an Access query/macro from within VFP. No ODBC Similar to usin loXL = getobject('','Excel.Application' loWB2 = loXL.Workbooks.open('c:\earnedvalue\module\earned_value_data_shell.xls' loWB2.Application.Run('earned_value_data_shell.xls!import_data' to run an Excel macro Thanks Ga Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189203
  - 5
    - micration tool What is the best migration tool for VFP 6.0 ? -- George Malekkos ________ --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.572 / Virus Database: 362 - Release Date: 27/1/2004 -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 100,000 Newsgroups - 19 Different Servers! =----- Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189191
  - 6
    - Printing statements to Adobe files I would like to print statements to individual adobe print files for emailing. I have developed a process that runs the statement report for each customer. When I change the printer to Adode it asks the name of the file. I would like to send the name of the file for Adobe to use so I don't have to type it in for each customer. I am not finding an approach to send the name to Adobde. Any ideas? Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189189
  - 7
    - How Add a CommandButton on 1 Activex Dear All, I wants to add a CommandButton (Setup impression) on 1 Activex (CRviewer of CrystalREport). This AcTivex is on a Form. There is not method "Addobject" for this Activex. I use the addobject of Form but as you suspect it the button comes to be placed below the activex and is thus not visible. The method Zorder(X) does not arrange anything . It would be necessary to be able to say to the button "Always One Top"...... thank you in advance for the assistance brought. Bernhart Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189183
  - 8
    - Hardware Control via Printer-port ? Hi All, I've bought an "On-Off" relay control board with source code written by "VB" and "C++", actually I don't know the above 2 languages, can someone tell me VFP can do the same thing ? Thanks ! Regards Sammy Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189182
  - 9
    - Sending faxes using foxpro and windows 2003 sbs Dear All I am having problems with mapi sending faxes with Outlook 2000 sp3, xp and 2003. Early version are ok. I am getting to a point where I think it may be a security issue. Sending a normal fax is ok, but if I attach a *.tif file it comes up undeliverable with the message The Microsoft Fax transport failed to deliver the message to the recipient. Not all attachments can be rendered. Here is my code, I have changed the fax number. objSession = CreateObject("Mapi.Session") objSession.Logon () MESSAGEBOX("CDO version installed is "+trans(objSession.Version)) objMessage = objSession.Outbox.Messages.Add objMessage.Subject = "Test" objMessage.Text = "This is a test with an attachment" objRecipient = objMessage.Recipients.Add objRecipient.Name = "[FAX:5555555555]" objRecipient.Type = 1 objRecipient.Resolve () objAttachment = objMessage.Attachments.Add() objAttachment.Position = 0 objAttachment.Type = 1 objAttachment.ReadFromFile("C:\B.TIF") objAttachment.Source = "C:\B.TIF" objAttachment.Name = "B.TIF" objMessage.Send () objSession.Logoff Thank you for any help David Anagram Systems Limited work email: david@anagram-sys.co.uk Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189181
  - 10
    - System Clock Hi Is it possible for VFP to hide the system clock so that no one ca change the time of the computer Thanks Abe Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189179
  - 11
    - Incorrect page footer information problem env: O/S 2000 sp4 vfp7 sp1 on report designer, 1.data grouping is set, new page when group change 2.fields on group footer band is set "Stretch with overflow" If fields stretch with overflow on group footer and it overflow to next page, it affect the result of field on page footer on current group and next group. Steps to Reproduce: Create table by following code: create table table1 (f1 c(10),f2 m) insert into table1 (f1,f2) value ('A','') insert into table1 (f1,f2) value ('B',repl('X'+ chr (13),200)) && overflow to next page insert into table1 (f1,f2) value ('C','') create report testbug add data grouping expression "f1" : set "Reset page number to 1 for each group" add report variables "vf1" with Expression : f1 on page header band : add a field Expression : f1 on detail band : add a field Expression : f1 on "group footer : f1" band : add a field Expression : f2, set "Stretch with overflow". on page footer band : add a field Expression : f1 Save report do a command : report form testbug preview Or report form testbug to print result : Assume Group A is printed on page1, Group B is printed on page2 and 3 because for group footer overflow to next page, Group C is printed on page4 on page footer band when f1 group B : field "f1" display C && incorrent field "vf1" display B && corrent on page footer band when f1 group C : field "f1" display C && correct field "vf1" display B && incorrent Is it a bug? thanks. Ray Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189178
  - 12
    - Foxpro 6 Tutorial Hi All, I am the very beginner of Foxpro. Currently, I have Foxpro 6.0 installed in my computer(windows ME 2000). I would be very appreciated if some one can tell me the websites which contain the Foxpro 6 Tutorial. Have a nice weekend! Best Regards Richard Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189175
  - 13
    - Graphical editing of a class Hi all, If I define a class in a program (not is the class designer), how could I edit it in the class designer? Thanks Hutch Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189173
  - 14
    - not insert to table Dear All, I have 2 tables, sales and salesdetail here is my source: sales set to buffering-3 salesdetail set to buffering-5 begin transaction insert into sales(...blah blah blah) insert into salesdetail(...blah blah blah) if (tableupdate(0, .f., "sales") and tableupdate(1, .f., "salesdetail")) end transaction strange thing is, I got salesdetail updated but sales always got nothing. no error message pop out. Can't figure what's wrong. Many thanks. Regards, Wandy Tang Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189170
  - 15
    - change page per group on report vfp.6 start each group on a new page reprint group headers are on design mode of a report can i have it on a variable with a choice of a user on the same report ? -- Thanks George Malekkos --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.572 / Virus Database: 362 - Release Date: 27/1/2004 -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 100,000 Newsgroups - 19 Different Servers! =----- Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189159
  - 16
    - Ask for method for copying file from one folder to another Dear all, I would like to ask is there any method for Foxpro 6.0 to copy file from one folder to another? Thanks a lot, Ray Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189150
  - 17
    - Mailmerge Wolfgang, Thanks for your kind response. I changed DFC() and got past the error but I got a message from WORD: Error in mailmergeword8(69): OLE IDispatch exception code 0 from Microsoft Word: Word was unable to open the data source. I am wondering if the message prior (Unable to find FoxPro File ODBCDriver) is the cause? I have tried putting the ODBC drivers I could find in the Windows and Windows32 folders but it didn't help. Do you know the proper name of the driver and where it should be located? I found this code in mailmergeword8 and it seems to be wanting the driver. Why would it be needing the ODBC driver and connection string when the data source is a local view? *- attach data file oDoc.MailMerge.OpenDataSource(THIS.cDataSrc,0,0,0,0,0,"","",0,"","",m.cODBCSource,; THIS.csqlstmt, THIS.csqlstmt2) Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189146
  - 18
    - SEEKING LIST OF COMMON WORDS I'm seeking a list of words one would find in an english dictionary (ie 'bank', 'cat', 'symphony', etc.) All I need is a comprehensive list of these common words. If anyone can send to me or direct me to a such a list I WOULD BE VERY GREATFULL !!! Thx Mike Farnesi San Diego Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189141
  - 19
    - simple procedure question Hi, I'm new to Foxpro, and I'm trying to create a stored procedure that returns a set of records. The following does not return records: procedure GetRecords select * from customer endproc Do I need to create a cursor or something? If so, what does that look like? tia, John Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189138
  - 20
    - CHECKBOX QUESTION I have a form that has three buttons 1. File Check 2. Run Program 3. Exit File check does what it says, looks to see if files are present. If they are present, it updates the chkbox/label with a CHECK. I then want to run the program in accordance with which boxes are checked. I tried you thisform.check.value but it doesn't work. Is there an easy to do this. I am getting I need to pass a value at some point? Thanks in advance. Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189133
  - 21
    - Trying to force Outlook msg window to foreground I have an e-mail address field on a form whose right-click event will open up a new Outlook message to that recipient. The automation part of it works like a charm. However, there are times when the new Untitled message window will flash in the taskbar and not be the foreground window and other times when the new message will indeed get the foreground (which is the desired result). Using both the mail item's Display() and Activate() methods produces the same results. Is there a way to make sure that the new message window always hits the foreground and has focus? I'm assuming that the WinAPI has to come into play for this.. Jon Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189125
  - 22
    - XML in Visual FoxPro 6.0, is it possible Is it possible to read and write from XML files from Visual FoxPro 6.0? Thanks Peace in Christ Marco Napoli http://www.ourlovingmother.org Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189121
  - 23
    - .memo I need some help. I am a programer but not FoxPro Pro. I can't handle .mem file, can't change. Do I have to create a new one and how? I read about this file in the Book but .. Thanks, Maria Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189120
  - 24
    - 1a and eof?? So accordingly to what was mentioned in this forum I could found a lot of 1a marks in the header of the dbf. What I would like to know is how to repair a dbf if it is broken using an hexadecimal editor? Which is the 1a mark I have to take into account??? Does anybody experience a broken table and has to repair??? Thanks in advance, Mariano Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189110
  - 25
    - OLE-Drag'nDrop in COM-Object Hello In my application I use OLE-Drag&Drop. It's working ok. But one part of my app ist a COM-Object, also written in VFP8, using the same classes as the rest of the app. This COM-Object shows controls in a top-level-form. In this form OLE-Drag&Drop doesn't work. It's not starting, no matter, if I let VFP do the work (OLDEDragMode = 1 (Automatic)) or if I start it myself with OLEDrag (.t.) in MouseDown-Event. As soon, as I press the left mouse button, the control is in editing mode, means if I move the mouse with left button pressed, I mark text under the mouse. It's not entering the OLEDrag&Drop-mode. Some ideas? I've written a litte test application, which shows my problem. You can download it from www.ksoft.ch/download/oletest.zip. It's only 17k. Unzip it and build an exe in order to register the COM-Class. If you start the exe, you will see 2 Forms. Both are the same top-level-form, but one is opened from within the exe using do form, the other is shown from a COM-Object. In the form opened with do from OLEDrag&Drop is working, in the other form it is not. Funny, isn't it? Thank's a lot for every help I can get. Kurt ------------------------------------------- K-Soft Informatik Kurt Kleindienst Rietwisstr. 32 CH-9100 Herisau Telefon: +41 (0)71 / 351 78 80 Fax: +41 (0)71 / 351 78 81 Mobil: +41 (0)79 / 377 31 40 E-Mail: info@ksoft.ch Internet: http://www.ksoft.ch ------------------------------------------- Tag: CursorFill() as a workaround to Requery() when inside a transaction. Tag: 189109

This is cool.

I have validation code in a stored procedure that wants to REQUERY() a view
when I issue a TABLEUPDATE() on a particular table. This is a problem
because all of our generic "save changes" code includes wrapping
TABLEUPDATE()s in a transaction when more than one table is going to be
updated (and Requery() either error's out during a transaction or does
nothing at all (depending on what's being requery'd).

Changing the view into a cursoradapter allows "requerying" the cursor via
the cursoradapter CursorFill() method.

--
William Fields
MCSD - Microsoft Visual FoxPro
MCP - Win2k Pro
US Bankruptcy Court
Phoenix, AZ

"Reality is merely an illusion,
albeit a very persistent one."

- Albert Einstein

Top