ADO.recordset to table

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
    - OT: IE and HTML header source Sorry, a bit OT. I can get the HTML from a web page between the <BODY>...</BODY> tags using oie.Document.Body.InnerHTML in VFP (where oie is an internet explorer application object).. So how do I get the <HEADER>...</HEADER> source, or even better the whole HTML source? ? oie.Document.Header.InnerHTML sounds like a good guess, but no luck there, and I can't find anything else which looks promising. Thanks --- Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.507 / Virus Database: 304 - Release Date: 04/08/2003 Tag: ADO.recordset to table Tag: 178677
  - 2
    - Scrolling container? Hey all, I rolled my own a couple years back but was wondering if I had dreamed that VFP 8 was going to have scrollable containers? I don't see any so am thinking it was a thought one morning, pre-coffee. TIA, John Tag: ADO.recordset to table Tag: 178670
  - 3
    - formset sucks i have a class based on form named "ReportServer" with some parameters for printing * i write in my form : thisform.repSvr= createObject( "ReportServer") * its all right, but I CAN'T SHOW thisform.repSvr because my form is not a " Form Set " * i don't want to convert each form of my project to a FormSet with just one Form * i want to do nothing just instancing the object and show it there is no problem with other base classes of course, but with the Form Base Class i don't want to DO FORM "ReportServer" i want to deal with the Form class like any class walking on the planet is it possible? please, any suggestion? ( VFP6 ) -- atte, Hernán Castelo UTN - Buenos Aires . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Tag: ADO.recordset to table Tag: 178669
  - 4
    - Moving VFP 3.0 to 5.0 I develope in VFP 5.0, but all my files were in VFP3.0, so=20 when i want to save a record in a form, VFP5.0 send me the=20 following error message: IF !m.lSuccess &failed to lock record Error: 36 Command contains unrecognized phrese/keyword. Method: updaterows Line: 53 I checked my form Add valid list with the Help Buffering=20 topic and both were correct. When i'm back to VFP 3.0 i=20 didn=B4t have any error. What can i do to lost this error in VFP 5.0? Thanks Tag: ADO.recordset to table Tag: 178665
  - 5
    - www.turkusokagi.com http://www.turkusokagi.com Tag: ADO.recordset to table Tag: 178662
  - 6
    - giving word document the print command from within foxpro Hi, from within my foxpro program i open a word doc, i put my data in it, and then i want to print it, but without the print dialog. Because the word app stays invisible all the time. I don't want the user to have to choose the printer etc... because there are about 300 documents that need to be printed, so they won't be happy if they have to click that OK button 300 times allso, how can i make that every doc is printed more than one time? Regards & thx in advance, Thomas Tag: ADO.recordset to table Tag: 178650
  - 7
    - adding row to a table in word from within foxpro Hi, i'm automating a word-document, so i'm filling up the values from within a foxpro-program. I have a table in the Word-document, and i want to add a row at the bottom to that table. (How) Is that possible? Regards, Thomas Tag: ADO.recordset to table Tag: 178649
  - 8
    - Hooray IDE Changes! They say it's the little things that matter most... I can't imagine how many dozens of times I've been beeped at or had my browse window close for trying to Ctrl+Home/End-ing to the top/bottom of the table. These finally (VFP8) navigate the browse as they do in most other apps, yeah! Tag: ADO.recordset to table Tag: 178646
  - 9
    - Launching a PDF from a VFP7.0 form I am trying to launch a scanned reference document from a Foxpro form button....? can that be done? Tag: ADO.recordset to table Tag: 178642
  - 10
    - Data Corruption Hi There, I hope someone can shed some light on this for me or at least point me in thr right direction. Out of about 100 clients, 10 of them are regurlary having problems with their tables getting corrupted. They are all using our system over a network and in most cases the server machine is being used as a workstation. The strange thing about the corruption is that the dbf is still ok to be opened through fox and can be browsed, but it is as though a section of memory has been slotted into the middle of the table. No data is actually being lost, just this bad data being added in; usually somewhere near the middle. Sometimes we can read what the bad data is; one time it looked like registry entries, the other it actually looked like some of our code! Would incorrect shutdowns cause this, or scandisk. If anyone has seen similar or has any ideas, please let me know. Thanks in advance. David Gouge Tag: ADO.recordset to table Tag: 178627
  - 11
    - Moving from VFP 5 to 6 Any things to watch out for if we take a project written in VFP 5.0 and build and compile it in 6 instead? We've standardized on 6 for most things but have a few projects that were never rolled out that were written in 5. Thanks in advance. -S- Tag: ADO.recordset to table Tag: 178618
  - 12
    - Open dbf in Excel Hi, I sometimes open VFP6 files in Excel. However I've run into a problem. I have one particular dbf that won't open. The message is that the file is not in the format expected (that's not the exact wording). I see nothing wrong with this dbf when I open and browse in VFP. To further confuse the issue, I tried opening files using three copies of Excel on three different computers. In all cases, it was Excel 2002. One the second computer, I could not open ANY dbf files. On the third, I had no problem opening any dbf's (but I did not have the one problem dbf to try because I was at another location.) All three pc's were running Win XP and, as previously mentioned, Excel 2002. 1. What could cause the problem with that one file and how can I fix it? 2. Is there some "addin" needed so that PC number two can open dbf's? Thanks, Frank Tag: ADO.recordset to table Tag: 178617
  - 13
    - Windows 2003 issues Is anyone aware of any compatibility issues between VFP6 and Windows 2003? Does anyone know if they fixed the: http://support.microsoft.com/default.aspx?scid=kb;en-us;299603 problem they said was "too big to fix" before they edited their "Q" -- Thank you, Louis Sorbera Tag: ADO.recordset to table Tag: 178615
  - 14
    - General field Can someone tell me how to copy a general field from a local fox table to a sqlserver table field Tag: ADO.recordset to table Tag: 178610
  - 15
    - R.I., but only for values > 0? Hi everyone, We'd like to restrict record inserts/updates in a child table when the foreign key field value is greater than zero, but only if the FK value doesn't exist in the corresponding "parent" table. In other words, this particular field value can be blank (or zero) in the child table, but if it isn't it needs to be a value that exists in the "parent" table. We don't want to have to ship the parent table with a zero PK record to satisfy the R.I. We have other R.I rules for this table and we're trying to make this type of logic work. So far we haven't come up with anything that doesn't create holes in the other defined R.I. rules. Any suggestions? Thanks. -- William Fields MCSD - Microsoft Visual FoxPro MCP - Win2k Pro US Bankruptcy Court Phoenix, AZ The secret to creativity is knowing how to hide your sources. - Albert Einstein Tag: ADO.recordset to table Tag: 178606
  - 16
    - printing from web service Hi, I'm trying to print a report from my web service I can't do it !?! why ?? do you know another way to print something from web service ?? thanks in advance Pat Tag: ADO.recordset to table Tag: 178603
  - 17
    - VFP 8 Grid Q. Is there a way in VFP 8 to tile an image as the background of a grid? Thanks, Jonathan Morningstar ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Tag: ADO.recordset to table Tag: 178601
  - 18
    - Problems with code page I have problems with the creates an SDF file. Fields aren't delimited and have a lot of quotation marks in, when creating SDF files with COPY TO. Tag: ADO.recordset to table Tag: 178594
  - 19
    - Fonts Hello I use VFP 5.0 and when I click Format, Font -> I have next scripts: Western, Hebrew ... Vietnames. What should I do , if I need to read Korean data ? Thanks Tag: ADO.recordset to table Tag: 178590
  - 20
    - foxpro free tables Is there a way to connect and join data from multiple foxpro free tables with the same connection/command object in ado.net Tag: ADO.recordset to table Tag: 178586
  - 21
    - popup menus Is there a way to pass parameters to a menu in VFP 7? -- Kendall R. Dixon Information Systems Tusculum College Phone: 423/636-7300 ext.5750 Tag: ADO.recordset to table Tag: 178579
  - 22
    - Foxuser.dbf file cause application crash I have this this problem on Win2000 only systems: my application crashes very early at startup, I found it doesn't crash if I: - flag foxuser.* files as read-only - delete foxuser.* files (but in this way it crashes next startup) This never happened in the past and I can't find a reason. At startup I SET RESOURCE OFF. I changed nothing in my startup procedure. -- Andrea Mariottini Tag: ADO.recordset to table Tag: 178578
  - 23
    - modify contents within a memo field I have to change some contents within a memo field programmatically. For example , the contents of a memo field are Name = "lblV_partybuzlist_cAbbr" Caption = "Abbr" Left = 9 Top = 14 cfield = V_PARTYBUZLIST.CABBR lgetcaption = .T. Name = "lblV_partybuzlist_cAbbr" I want to change the lgetcaption = .T. to .F. I have written some codes to do it but I feel it is a bit clumsy. Does everyone has any better ideas ? the code I have written is as follows: REPLACE apresent.properties WITH ; SUBSTR(apresent.properties, 1, ATCC("lgetcaption = "), apresent.properties) + 13) ; + ".F." + ; SUBSTR(apresent.properties, ATCC("lgetcaption = "), apresent.properties) + 17) Any comments are welcome. Matthew Tag: ADO.recordset to table Tag: 178572
  - 24
    - Why VFP not popular in academic? Is there any of you have heard VFP is uses for academic purpose? Recently I plan to continue my studies but as far as I seen all the academic test don’t use VFP as their test or even worse I never heard VFP is one of common language uses in academic purpose. Frankly I try to apply at academic with the student get their financial aid, but it don't use VFP as their evaluation process test, I am very disappointed. Does any of you know where VFP is uses for academic evaluation process test, I would very happy to heard that. no VFP in evaluation process test, ie: http://www.mum.edu/compro/index.html Tag: ADO.recordset to table Tag: 178570
  - 25
    - MSDN download of Visual Foxpro 6.0 Sorry if I missed this one in the faqs. I just received my MSDN subscription and it includes VFP 8.0. Most of my development is in 6.0 How can I download the install CD-ROM's for 6.0? ...JS Tag: ADO.recordset to table Tag: 178553
- Next
  - 1
    - Index corruption Hello Group, I wonder if there is a way to detect index corruption at run time. I want to detect corruption when my app is lunched so I can fix it and avoid subsequent troubles and error messages presented to the user. I appreciate any help in the subject. TIA Carlos Jones Tag: ADO.recordset to table Tag: 178544
  - 2
    - GETFILE() position I use getfile() in a small app. When running directly in VFP8, it works fine. I compile the EXE and the open dialog box from getfile() is shown off screen. I have to right-click the task icon and select move to get it to show. I have SCEEN=OFF in my config.fpw. Does that matter? Tag: ADO.recordset to table Tag: 178542
  - 3
    - ODBC REPORD LOCKING EXAMPLE *!* This program is example of using ODBC to update tables and uses timestamp to take care of record lock when updating and *!* inserting. It uses set prop to make sure tables can be reverted in case of error. It is very important to have .001 time *!* delay in inserting and updating records because FoxPro does not give time in thousand of a second. In putting .001 it *!* makes sure that you get all unique records. ***************************************************************************************************************************** *!* Make table with four fields Date --- date() * *!* Sec --- 10,5 numeric use SECOUND() function * *!* Name --- Character 10 * *!* Lname--- Character 10 * ********************************************************************************************* clear ERROR1 =.f. UPDATELOCK = 0 set safety off sqldis(0) connection = sqlconnect('VfpTables'," "," ") ?connection nprop= SqlSetpro(connection,"transactions",2) if nprop = 1 for i= 1 to 100 wait window('wait..') timeout .001 && important delay for time stamp wait window("Updating Tabel " + str(i)) nowait Query1 ="Select * from datetime " NRESULT = SQLEXEC(connection,Query1,'temp') if NRESULT !=1 =aerror(x) =messagebox(x(2)+ chr(13)+Query1) =SQLDISCONNECT(connection) ERROR1 = .t. endif select * from temp into table counter use in counter do while UPDATELOCK = 0 && to make sure record is not changed Query1 = "Select *,"+str(second(),10,4)+" AS NEW_TIME,"+; && update current time to timestamp in temp table str(i)+" AS CREATSTAMP"+; && this line is not needed " From counter "+; " WHERE counter.lastname = 'KHAN'" NRESULT = SQLEXEC(connection,Query1,'temp') if NRESULT !=1 =aerror(x) =messagebox(x(2)+ chr(13)+Query1) =SQLDISCONNECT(connection) ERROR1 = .t. endif Query1= "update datetime set name ='AAA',Sec ="+str(temp.New_Time,10,4)+" where LastName ='KHAN'"&& update real table with temp timestamp NRESULT= SQLEXEC(connection,Query1) if NRESULT != 1 =aerror(x) ERROR1 = .t. =messagebox(x(2)+ chr(13)+Query1) wait window " Insert failed." ERROR1= .t. endif Query1 = " select * from datetime "+; " WHERE Lastname= '"+alltrim(temp.Lastname)+"' AND Sec ="+str(temp.New_Time,10,4)&& if time in real table =time in temp table you can update NRESULT = SQLEXEC(connection,Query1,'Temp1') if NRESULT != 1 =aerror(x) ERROR1 = .t. =messagebox(x(2)+ chr(13)+Query1) wait window " Query failed." ERROR1= .t. else if reccount()> 0 && as long as record is zero you keep trying to update. UPDATELOCK =1&& as soon as u get record which means you have unique timestamp and u get out of the loop endif endif enddo if ERROR1 = .t. =sqlrollback(connection) ERROR1 = .f. messagebox ('Some Error Happened Nothing Saved',32,'Error') exit else =sqlcommit(connection) endif endfor wait clear else messagebox('Set ProP Error ',32,'Error') endif Tag: ADO.recordset to table Tag: 178528
  - 4
    - Problems with MP3 file played by MCI object Hi, I have a sound problem using MCI object to play a MP3 file... The problem is the sound is not clean... I hear some "plock" in the background of the sound. Anyone know this problem ? Thank for ur help !!! Mike Tag: ADO.recordset to table Tag: 178521
  - 5
    - Changing the class of an object If I want to change the class of objects in a .vcx, do I open the .vcx as a table and just replace the class type as long as the base classes match and recomplie the code? What other steps are needed, if any? Thanks. Tag: ADO.recordset to table Tag: 178504
  - 6
    - RUN Function misbehavior in VFP8 DIR Function behaves differently in VFoxPro 8: instead of simply returning a list of the files in a directory (each on a line) it returns the names of the files disposed in a two-column format, except for those files with long names, which occupy a whole line. Since each line may contain the name of more than one file, the function became useless as a way to verify contents of a directory. I have not found a way to make DIR behave as it used to behave (a single file name on each line), is there a way? Tag: ADO.recordset to table Tag: 178492
  - 7
    - SQL server developers' edition This is a multi-part message in MIME format. ------=_NextPart_000_0016_01C35907.40E61710 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Looks like the price of the SQL server developer edition has been = slashed to $49 from $499 Does anyone know this version has got any limit on the evaluation period = ? EULA does not say anything about it. sp ------=_NextPart_000_0016_01C35907.40E61710 Content-Type: text/html; charset="Windows-1252" 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=3Dwindows-1252"> <META content=3D"MSHTML 6.00.2800.1170" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Looks like the price of the SQL server = developer=20 edition has been slashed to $49 from $499</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Does anyone know this version has got = any limit on=20 the evaluation period ? EULA does not say anything about = it.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>sp</FONT></DIV></BODY></HTML> ------=_NextPart_000_0016_01C35907.40E61710-- Tag: ADO.recordset to table Tag: 178487
  - 8
    - VFP 8 ( SETALL AND BindEvents) Hi all, I would like bind all the events keypress() of several textbox of a page (pageframe) to thisform.mymethode. How can i do it ? Thanks in advance bernhart Tag: ADO.recordset to table Tag: 178483
  - 9
    - Scrollbars don't show on my Form. Why doesn't my scrollbars show on my form (VFP 8)? Below is an example of code where I have a grid larger than the width and height of my form, but the scrollbars do not show on my form! What am I missing here? THX - Mike Farnesi MYFORM=CREATEOBJECT('FORM') WITH MYFORM .SCROLLBARS=2 .ADDOBJECT('MYGRID','GRID') WITH .MYGRID .TOP=0 .LEFT=0 .WIDTH=2000 .HEIGHT=2000 .VISIBLE=.T. ENDWITH .SHOW ENDWITH Tag: ADO.recordset to table Tag: 178467
  - 10
    - indexseek() and buffering does buffering mode (buffering mode 5, optimistic table buffering) affect indexseek()? I am adding many records to a table and then at end do a tableupdate() to update all the added records. During the process I am using indexseek to make sure I am not adding duplicate records? Another programmer keeps saying that indexseek() will not be able to find the newly added records with buffering on. I did a small test and it seems to work for me. Anybody with experience with this? Tag: ADO.recordset to table Tag: 178466
  - 11
    - How to detect that window has changed I use FPW2.6a, and I have a screen with 2 browse windows A and B. Then I issue a READ CYCLE with A,B DEACTIVATE .T. VALID .F. I would like to trap when the user clicks with the mouse from one browse window to the other. I have tried to put code into the deactivate routine, but no result. Any good idea what to do? Tag: ADO.recordset to table Tag: 178465
  - 12
    - browse window with different fonts I still use FPW 2.6a, and I would like to create a browse window that contains different fonts or styles in certain columns or rows. Is that possible? Tag: ADO.recordset to table Tag: 178445
  - 13
    - still get fatal errors any news about this problem ? -- George Malekkos --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.504 / Virus Database: 302 - Release Date: 24/7/2003 -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Tag: ADO.recordset to table Tag: 178444
  - 14
    - memory leak in vfp6.0? Chect the following source code - is this a memory leak? ***************************************************************** close tables all For i = 1 to 10 Begin transaction use items sele items use End trans Messagebox(sys(1011) + ' ' + sys(1016)) Next i *************************** items is a table belonging to a database - you can use any table the values of sys(1011) and sys(1016) (number of memory handles in use and amount of memory being used by objects) both increase throughout the loop. The same behavior is observed if End Transactions is replaced with a Rollback. Note that the rate of increase is proportional to the number of index tags the table has in its corresponding cdx file. The number of fields and the number of records of the table are irrelevant. Issuing comands like close all, clear all, clear memory, etc does NOT reduce the values returned by the two system functions mentioned above. If the begin / end transactions are removed from the source this behavior dissappears. I am using VFP6 / SP5. This behavior appears in both Win 2000 and Win 98 -- George Malekkos http://www.powersoft.com.cy eXPerience the POWER of real SOFTware ------------------------------------------------------------------- Powersoft Computer Solutions Ltd PO Box 27075 1641 Nicosia Cyprus Tel 357-22.67.00.67 Fax 357-22.67.77.22 ------------------------------------------------------------------- --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.504 / Virus Database: 302 - Release Date: 24/7/2003 -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Tag: ADO.recordset to table Tag: 178443
  - 15
    - Prompt for code page = NO programmatically In my development environment (VFP 6), I can Tools Options Prompt for code page && and uncheck it How to do I do this under program control? TIA. -S- Tag: ADO.recordset to table Tag: 178441
  - 16
    - To add a column in the grid window! Hi All, I've been trying to add a column in the grid window. I right click the grid window and choose "Help Design Tools", then an error message jumped out: "Error #1742 at Resetcolumns(0): The source of object must be a reference of variable." What does it mean? Or any different ways to do that? Many thanks. Sam. Tag: ADO.recordset to table Tag: 178434
  - 17
    - Error in accessing VFP webservice I have created a webservice in VFP 7 (DLL Created in VFP 7 and WSDL generated using SOAP Tool kit 3). When I try to access it from a VB client using SOAP 3, some times I get the following error. -2147221504 - WSDLOperation:Instantiating the dispatch object for method <MyMethodName> failed As this error does not occur always I do not have a clue on how to fix it. Any ideas? Best Regards, Y. SIvaram Tag: ADO.recordset to table Tag: 178426
  - 18
    - date question Hi all, I need a date string containing the 1st day of the current month. IE: ? lcDate 07/01/03 or the a date string containing the last day of the previous month. ? lcDate 06/30/03 Your input is appreciated. Thanks. Tag: ADO.recordset to table Tag: 178413
  - 19
    - Listbox Not displaying Util it is Clicked Hope this is something simple. In VFP 8 I have two identical listboxes on a form. Both using their own seperate view data, both bound the same way to different views: BoundTo = T BoundColumn = 2 ColumnCount = 1 Row Source = v_view.field1, field2 Row Source Type = Alias Both views has data in them. One of the list boxes diplays the value and one does not until you click on it at run time - then it refreshes with the correct data. I have tried refreshing no no avail. What would cause such an odd behavior. Rick Tag: ADO.recordset to table Tag: 178405
  - 20
    - DBC Connection to SQL data?? I have already created an connection object with my DBC that I use with remote views into SQL. If I want to query a table in the SQL server, can I use the connection object I have already created? I tried: sqlconnect('mydsn','myusername','mydbcconnectionobject') but it doesn't work. I'm trying to limit the number of times I have to put the username and password in code. TIA -Bruce Tag: ADO.recordset to table Tag: 178404
  - 21
    - Creating web-based apps with VFP8 vs Starting with .NET solution Hi all, I talked to a prospect yesterday. He has a plastic bag manufacturer and he wanted to create apps to maintain the data in his manufacturing company. He said that there were already three software companies that gave a proposal to him. I will be the forth. All three companies are offering a web-based applications, thus he insist that mine should be web-based also. Problem is, although I've been using VFP for almost four years by now, I have never touched a web-based application. For more information: two companies (out of three) offered a Linux based solution (I think they'll use php), and the other offered a .net based solution (vb.net for sure!). Question: 1. Anybody got any idea what my selling point should be when I meet him on next the Tuesday? 2. How steep is the learning curve to create a web-based applications with VFP? I'm willing to invest in 3rd party product like WWC if I have to. Any other alternatives? 3. I was planning to buy VS.NET --- not in a near future actually, but if I can get this project, I might decide to buy it sooner. Will it do any help if I develop the apps with VFP ( I have VFP8 )? 4. Considering that I am used to code in VFP, I assumed that it would be much easier for me to create the apps in VFP rather than starting from scratch with VS.NET. What makes me doubt is I read several pages of VB.NET book in our local bookstore this afternoon, and it looks like that VB.NET is designed to create a web-based application from the beginning. The book started with creating a hello world web-based apps. Anybody here ever learn VB.NET with VFP background? Do you have any suggestion? TIA, Willianto Tag: ADO.recordset to table Tag: 178390
  - 22
    - New msdn.microsoft.com/vfoxpro website layout Surf on over to http://msdn.microsoft.com/vfoxpro/ and have a look at the new Visual FoxPro website. -- Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP cindy.winegarden@mvps.org, www.cindywinegarden.com Tag: ADO.recordset to table Tag: 178387
  - 23
    - Mixed colors in grid Hi! I have a grid with 24 columns. The value in each column can be ether -1, 0 or a number greater then 0. In any given row I want the background color to be white for -1, green for 0 and red for the everthing greater than 0. Everthing I've tried so far will ether make the entire row or the entire column one of the colors depending on which row I'm in. I need to have mixed colors in the same row and they need to be retained in that row when I go to the next row. Can anyone help me with this? Thanks Terry Tag: ADO.recordset to table Tag: 178382
  - 24
    - Refreshing tables in the DE vfp 6.0 Form with private data session and tables in the DE Hello After user click save button the files are updated and fields in window are cleared. How do I refresh the tables in the data environment so that they are up to date? The only way I can think of ensuring the tables are current is by closing the form and opening it again. How do I refresh all the tables in the data environment of a form with the current disk values? Do I have close and reload all the tables? I hope not. Thanks for your advice Al Tag: ADO.recordset to table Tag: 178380
  - 25
    - Old menus I think I've just discovered that VFP 8 has real trouble when dealing with "old" menus, to the point of C0000005'ing. After I went through and opened all the old menus, allowing VFP to "Convert to new menu format," things were ok. Likely a causal relationship. Anybody else notice this? Eric Tag: ADO.recordset to table Tag: 178375

Hi All,

I want to copy an established ADO recordset (I am not using cursor adapter)
to a table. Is there a quick way to accomplish this?

TIA,
Tom Clark

Top

ADO.recordset to table by Mike

Mike
Wed Aug 06 20:46:17 CDT 2003

Download the VFPCOM utility from the Foxpro Home page in
the downloads section.
It has the utilities in it to do what you are asking for.

>-----Original Message-----
>Hi All,
>
>I want to copy an established ADO recordset (I am not
using cursor adapter)
>to a table. Is there a quick way to accomplish this?
>
>TIA,
>Tom Clark
>
>
>.
>

Top