XMLAdapter and multiple tables

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
    - Form Works in One App but Not Another Part II Thanks in advance for any help. I have a form that I'm trying to use in two different apps. It works in one but in the other I get this error (which I think that I incorrectly reported in an earlier post) Visual FoxPro Reference "field" phrase is not found (Error 1130) The field specified in PROMPT field was not found. a.. You are using a command with a PROMPT clause that references an unknown field. For more information, type PROMPT in the Index tab of the Help file and select the command you are using. To the best of my knowledge I am not using a PROMPT command or function. Following the instructions above to type PROMPT in the Index tab of the Help file did not help. Does anyone have any idea what this error means? It is an error which can be safely ignored (which I guess means that it can be trapped) but I don't think I should have to do that. Thanks again, Jeff Tag: XMLAdapter and multiple tables Tag: 200062
  - 2
    - Join VFP Project to SourceSafe I have a VFP 8.0 project that was, at one time, hooked into SourceSafe. I have since created a new project file and recompiled everything. Everything works great, except now, I cannot check in or check out files from within the Project Manager. I have to go directly to SourceSafe to do that. I've tried Join Source Control Project... but I am not able to join it back to the SourceSafe project. Any ideas? TIA. -Paul Tag: XMLAdapter and multiple tables Tag: 200057
  - 3
    - How can I run a FPD2.6 program in VFP8? Program only, not from screen generator or anything like that. I could run it in VFP6, but when I try to run it in VFP8, I get an error message that it can't create the .fxp file. I'm sure this is a stupid question, but since I don't know the answer, gotta ask! :) Thanks! Shawn Tag: XMLAdapter and multiple tables Tag: 200053
  - 4
    - Crystal reports We are trying to use crystal reports from fox. The problem we have is how to pass a parameter into the report so that only records are printed depending on the parameter. ie do report1.rpt with id =1 print only records with an id of 1 Is this possible. Thanks in advance Dave Tag: XMLAdapter and multiple tables Tag: 200049
  - 5
    - grid display problem Hi, In a column of a grid, the field is defined as c(1), I want to display the word 'Posted' in that column if the field content is 'P', if not then blank. I have tried the iif() in the control thisform.grid1.column1.text1.value It just display the word 'P', I though it is because the field length is c(1) please advise How can I do that whitout change the field length ? I would retrieve those records by 'SELECT ..... ' into a temp table Can I change the field length in doing 'SELECT' ? thanks Tag: XMLAdapter and multiple tables Tag: 200038
  - 6
    - TEXT/ENDTEXT limits I use "TEXT to lcXX TEXTMERGE NOSHOW" to build a SQL statement. I have a SQL insert failure due to a syntax error in the insert statement. When I save "lcXX" to a file I notice that a carriage return and line feed (CHR(13)+CHR(10)) have been placed into the string. The insert command being generated is about 2000 characters long. I have used this technique in many applications and have not seen this before, although this merge may be larger than others. Can someone explain why this occurs, how to prevent it or at least predict it. In reading the documentation I do not see any limits. TIA Mark VFP7 SP1 Tag: XMLAdapter and multiple tables Tag: 200033
  - 7
    - Record pointer moving on its own (it's possessed!!) I have a situation with a client's app that results in the record pointer not moving properly. On the forms I develop, I use a pageframe with a List tab at the far right. On the tab is a grid showing the form's main table and this grid is used for locating a record. You click in a column, start typing, it does an incremental search, and when you hit the record you want you just press Enter. The pageframe's main tab is activated and this is where the data entry/edit is done. This works great, but after installing VFP 8 a client noticed a problem. While on the main tab, the user may move to another record (this is basically a bill of materials form and the user can right-click on a line item and choose Inspect this part and the record pointer will be moved to that part and the form will display it). After doing this and clicking back on the List tab, instead of the grid being positioned on the record displayed in the main tab, the grid will be on some other record. It's not necessarily a record that was previously being viewed on the main tab. As I mentioned before, this has worked perfectly up until the install of VFP 8. In fact, when the client tests on a VFP 7 version of the app, it still works fine. I had noticed some similar behavior in another client's app, but attributed it to an error in my code (though I could find none) and didn't think it was VFP 8 related because it had been awhile since we moved to VFP 8, so that connection didn't jump out at me. However, that may be the same issue. If the code is traced, it works, if the code is not traced it will fail. Has anyone seen anything like this? Thanks, Russell Campbell Tag: XMLAdapter and multiple tables Tag: 200030
  - 8
    - Project Manager problem Hi, I am experiencing a weird problem with the program manager. On an existing project it does not add automatically the forms, programs, icons etc used. If I create a new project and just add the main program, everything is rebuilt correctly. But, if I reopen the project and remove a form (for test reasons) and rebuild the project, the form is not added. It reports that the form is Undefined ! I found and read another relative post but those guidelines do nothing for me. I have deleted all foxuser files, Rebuild, Cleanup the project. Recompile all files. The problem does not seem to appear on other projects, on other directories. Pleeeaaase Help, before I get crazy. Demetrios, Greece Tag: XMLAdapter and multiple tables Tag: 200024
  - 9
    - Create an Empty Dataset From XML... Version: Visual FoxPro 7.0 Pre-SP1 OS: WinXP SP1 I have an XML string that has an in-line schema. It just happens that there is not any data in the XML document, meaning the table has no records. When I issue the XMLTOCURSOR() command, it is placing a record in the cursor and inserting .NULL. as field values. Question: The XSD handles the field names, etc..., so no problem there. How do I create an empty recordset from and XML string and an in-line XSD? I am an XML newbie so be nice... Tag: XMLAdapter and multiple tables Tag: 200022
  - 10
    - Form works in one app but not in another Thanks in advance for the help... I have a form that I need to use in two different applications. It compiles in both applications just fine and it works properly in one of them. In the other I get a message Field "phrase" not found at the thisform.refresh line (according to the debugger). The error appears twice and can be ignored after which the form works correctly. Does anyone have any ideas about this problem? Thanks Jeff Tag: XMLAdapter and multiple tables Tag: 200019
  - 11
    - sys(3050) I've been having a problem with freeze-ups in FoxPro 8, where a compiled application will either freeze entirely or seem to be frozen for a long time but then eventually come back online. This seems to happen especially when a user is just stepping through a table. I'm wondering if possibly this has something to do with the sys(3050) setting. Microsoft has a KB article in which they say that FoxPro does not always work very well with large amounts of RAM. Of course, all computers these days have large amounts of RAM. The KB article says 256 megabytes or more might cause a problem, and all the computers my application is running on have at least 512 megabytes. My question is, in general, is it a good programming practice to always use SYS(3050) in a FoxPro application to reduce the amount of available RAM? If so, what is a good number at which to set the available RAM? Kevin Clark Seton Home Study School Tag: XMLAdapter and multiple tables Tag: 200018
  - 12
    - Chron job on server A client has asked us to write an app that will run as a timed job on a Windows 200 Server, using Windows ability to schedule the process to run at timed intervals. Is there anything special I need to know about 1. Installing a vfp app on a Windows server 2. Rights and other considerations for the job to run Thanks in advance. Josh Rubin Tag: XMLAdapter and multiple tables Tag: 200014
  - 13
    - Problem installing VFP 7.0 on XP Home Edition Service Pack 1 When trying to install VFP 7.0 on XP Home Edition Service Pack 1, once de CD insertend into CD-ROM, even before being able to choose the option "Install VisualFoxPro 7.0" an error message apear: "Windows Component Update. Setup has detected that some of the Windows components that are installed on your computer do not match the version required for Visual FoxPro. You must install a different version of these Windows component" Than I installed XP Service Pack 2. No results, the message is the same when I try to install VFP 7.0. What can I do ? -- Manuela Musat Tag: XMLAdapter and multiple tables Tag: 200000
  - 14
    - How to run SQL Script through VFP? Hi, Does anyone know how to run SQL script through VFP and load it into Oracle? Regards, Anand. Tag: XMLAdapter and multiple tables Tag: 199999
  - 15
    - select statement problem Hi, The following statement is placed in the init event of myform thisform.grid1.RowSource = "select pinvitem.invnum, pinvitem.partno, invoice.invdate ; from pinvitem, pinvoice into table invallo where pinvoice.invdate = date() ; and pinvoice.invnum = pinvitem.invnum and pinvitem.recstat = 'P' ; order by pinvitem.invnum, pinvitem.partno asc" thisform.grid1.RowSourceType = 4 I got an error message : 'commands contains unrecognized pharse/keyword' but I do the above 'select' statement alone , it has no error at all. please give me a hand thanks Tag: XMLAdapter and multiple tables Tag: 199997
  - 16
    - read only tables We are having problems where client machines cannot update tables. We are using vfp6 and the data is on a 2000server. The client machines are 2000 pro. When trying to write to a table we occasionally get error 111 'cannot update the cursor'. According to the help this is because the table is read only. This has happened with two different tables now and there seems to be no pattern to it. The error persists until the server is restarted. Until then the table cannot be written to. How can a table suddenly become read only? Has anyone else experienced this problem. Any help would be appreciated Dave Tag: XMLAdapter and multiple tables Tag: 199996
  - 17
    - Different cell color in a grid using a cursor Is it possible to store values in a cursor to format cells in a grid? For example, I've the cursor: Field1 Field2 Field3 -1 1 3 1 -1 2 and the table: Field1 Field2 Field3 aa bb cc dd ee ff I would like to display the table using a grid with blue background cells for positive values of the same field of the same record in the cursor and red for negative values, like this: The grid: Field1 Field2 Field3 aa (RED) bb (BLUE) cc (BLUE) dd (BLUE) ee (RED) ff (BLUE) Any suggestions? Thanks in advance! Lorenzo Tag: XMLAdapter and multiple tables Tag: 199993
  - 18
    - HP printer conflict I'm having trouble with HP printers. I'm running foxpro 2.6a.. REPORT FORM < > TO PRINTER PROMPT REPORT FORM < > PREVIEW The problem is occuring always running under terminal services, and intermittently on a conventional windows NT domain. Other printer ok.. only HP. Can somebody help me.. Thanks! wdennys Tag: XMLAdapter and multiple tables Tag: 199990
  - 19
    - How to make an application to be minimized in taskbar tray? (Further Question) I have asked this question before. Thanks Eric and other guys of you that provide the solution to achieve this. I have tried it and it really shows the icon in the systray. But I have a question: I compile my project with this systray icon tool to an execution file. But when I run it, the main Visual FoxPro is still appeared, although the systray icon has been shown. I have included a command _screen.Hide. But the result will be the application quits. I have found a DLL, systray.dll that can really hide Visual FoxPro window the systray icon is appeared. But there is something that does not meet my requirement: When I left or right click the systray icon, the Visual FoxPro screen is appeared. What my requirement is: the application should be always hidden and the systray icon appears. When I right-click the systray icon, a menu appears that can let user to choose. Does anyone have any ideas or suggestion? Tag: XMLAdapter and multiple tables Tag: 199985
  - 20
    - uncommitted changes and setfldstate I'm using a view with optimistic table buffering. I go to requery() an SQL view, but get the error: "Table buffer for alias ViewDocHeader contains uncommitted changes (Error 1545)". prior to this I use: 'setfldstate("DiscPCent", 1, "ViewDocHeader")' to manually set the field status of the view, because the control source has been changed for a control using the DiscPCent field, in debug I can see that this code: getfldstate(-1, tcAlias) returns "1111111111111111111111", why does it still think there are uncommitted changes, when in fact there isn't anything different and I've used 'setfldstate' Any help greatly appreciated. Grant Tag: XMLAdapter and multiple tables Tag: 199982
  - 21
    - Editing a memo field in a grid I have created a grid and one the columns in this grid is a memo field. I can't use the standard ways of adding data or editing this memo field (CTRL-PGDN or double-clicking do this in a browse window). What am I missing? There must be some way to view and edit data in a memo field in a grid, but I can't find anything about this in the help files. I'm using VFP 7 / SP1. -Everett Tag: XMLAdapter and multiple tables Tag: 199977
  - 22
    - How do I get match data from one table twice? I have a two tables. One is my product description table, the other is my Orders table. I have two fields in the Order Table that match one field in the Product table. I want to get the description for the new product and I want to get the description of the old product. How do I get this using a query. Below is my current query but this only brings back a null value for the old product description and the correct description for the new product. Select Orders.Product as NewProd, Productn.Desc as New_Desc,; Orders.Old_Prod, OLD.Desc as Old_Desc, Orders.inumber as Invoice; from Orders; inner join Productn on Orders.Productn = Productn.Productn; left join Productn as OLD on Orders.Old_Prod = Productn.Productn; where !empty(Orders.Old_Prod) Tag: XMLAdapter and multiple tables Tag: 199964
  - 23
    - How to disable listbox entry I have the need to disable listbox entries that start with '\\', such as a network path. Normally, you start the entry with '\', and it will be disabled. If you have a legitimate backslash, you would change it two backslashes so that it is enabled and displays a single backslash. BUT - if you have two or more backslashes, it will just display backslashes and not disable the entry. How would you get \\SomePath to appear as disabled? I can put a space between a backslash and the rest of the item, but then I have a disabled entry with a leading space. Tag: XMLAdapter and multiple tables Tag: 199963
  - 24
    - Excel automation Can somebody help me with this problem .. I need to add lines to an existing Excel file. To open the file and add the lines is no problem, but I need to check if the file is already open, so I don't open it again. So if the file is open in Excel, I need to add lines to the open file ofcourse. Thanks for the help Xavier Tag: XMLAdapter and multiple tables Tag: 199957
  - 25
    - Which Control? Which ActiveX Control do I use to have Calendar that looks like the Outlook Calendar for a Month at a time? I am looking for a control that I can see if anything is scheduled for a day and the ability to add and view entries from the same form too. Respectfully, j. Morningstar Tag: XMLAdapter and multiple tables Tag: 199949
- Next
  - 1
    - Getfile() Q. How do you get the Getfile() command to start in a specified directory? Respectfully, Jonathan M* Tag: XMLAdapter and multiple tables Tag: 199947
  - 2
    - Dynamic Shortcut Menu I have added the custom class menulib in ..\samples\class\utility.vcx to my form. I load data in the array and call the shortcut in my right click procedure in the form. It works fine in this scenerio. The problem occurs if I have a top level form which calls a second form which contains the dynamic shortcut menu. Basically when I right click on the form, the menu is not displayed as part of form. Thus... Form1 is defined as Toplevel form, Always on top, Modal and calls form2. Form2 is defined as in toplevel form, modal, always on top. Any suggestion would be appretiated. Thanks Shahriar Tag: XMLAdapter and multiple tables Tag: 199943
  - 3
    - 4up printed forms Am using vfp 5.0 and need to print a 4up 4x6 inch form that requires a page length of 12 inches. Unable to find a way to do this. Is it possible or what is the next version that will allow me to do this. Avery sells a packet of 4up - 4x6 inch forms which is not available on my version under labels. Tag: XMLAdapter and multiple tables Tag: 199942
  - 4
    - change sct to prg ? Hi, Is there a way to strip a scr/sct file into a prg. I have made some forms with the formdesigner and would like to get rid of them and have the code in my prg. regards christophe Tag: XMLAdapter and multiple tables Tag: 199935
  - 5
    - server time Hi All, How to get time value from another machine (server or another)? Client's OS could be Win98, NT, ME, W2K, or XP May be it need WinAPI, how is the easiest way to implement ? Thanks in advanced I'm using VFP 7.0 Tag: XMLAdapter and multiple tables Tag: 199929
  - 6
    - what's the command? the old foxpro 2.6a.. running a screen using this command (eg. DO customer.SPR )..what is the command for visual foxpro... i try write DO FORM customer (but i needed to included the CUSTOMER form to run the form), in foxpro 2.6.. i don't need to included the .SPR cause alredy compile and embedded in the .EXE pls help me.... thanks! Tag: XMLAdapter and multiple tables Tag: 199926
  - 7
    - MapPoint Looking for info on integrating MapPoint into a VFP app. Anybody aware of any papers that might be available? thanks Tag: XMLAdapter and multiple tables Tag: 199925
  - 8
    - grid row alignment I have a page with a grid based on one local view ("the list page") & a details page based on another couple of views ("the details page"). The problem I have is when you click the button to show the list page and set the record pointer on the correct record, set focus to the grid, even refresh etc it will be highlighted on the row it was before leaving the list page. How can this be set to be "showing" the correct record/row? I have a feeling I've forgotten something, I've never had this problem before?! Grant Tag: XMLAdapter and multiple tables Tag: 199918
  - 9
    - Help files not displaying on some machines I have an application in foxpro 6. Help files are all "*.chm". On machines that do not display help when F1 is pressed: Help is on Help file paths are correct Issuing a "Help" command has no effect. The application is the same on all machines so it appears to be related to the machine, not the program. These machines will display a help file when the file is double clicked in an open folder. Any ideas? With thanks Tony --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.749 / Virus Database: 501 - Release Date: 1/09/2004 Tag: XMLAdapter and multiple tables Tag: 199911
  - 10
    - SQL datatime Field Having upsized my data to SQL 2000, my date fields are stored as "datetime" in the sqlserver. This causes problems in my forms where users were to only enter dates. Now it shows time along with date in my data entry forms. There is no Date field in SQL 2000 without the time? Any suggestions? Thanks in advance Tag: XMLAdapter and multiple tables Tag: 199909
  - 11
    - Calendar Q. What is the best way to write a "Calendar" for VFP? I want a calendar that all users can see what people have scheduled for a day. I would like it to have the apperance of Outlooks Calendar. Tag: XMLAdapter and multiple tables Tag: 199901
  - 12
    - Re: COMPILE REPORT ReportFile Ok, compiling the report generated an FXP file with the same name as my report format. 1. Should I remove the Report Format from my project and add the FXP? 2. Should I still use the REPORT FORMAT command to call it? Gary Z Sietse Wijnker wrote: >Hi Gary, >Try >COMPILE REPORT ReportFile >after you've cleared out the Tag1, Tag2, and cleaned up the Expr field >Regards, >Sietse Wijnker Gary Z wrote: >> I checked the Expr, Tag1 and Tag2 fields. They're still empty. This has got me >> stumped. Where's it getting the incorrect printer from now? Tag: XMLAdapter and multiple tables Tag: 199878
  - 13
    - HowTo?: re-index LINKed FoxPro files (Access 2002/2003, Windows XP Professional) Scenario: The customer is developing in Access 2003 and installing the .mdb to systems running Access 2002. The customer is running legacy third party accounting software that uses FoxPro files. He has successfully used the ODBC driver for Visual FoxPro to update the legacy FoxPro .DBF tables. There are two other FoxPro files (.CDX, .FPT). After the customer updates the FoxPro .DBF, he unfortunately must open the third party accounting software's utility menu to re-index the files. If he does not do this manual task, the transactions that he added via Access are not visible in the third party accounting software. This manual step prevents the customer from fully automating the transfer of Access data into the legacy FoxPro database. That is the first part of this problem. The second part is the accounting system data is resident on a file server, and the customer is forced to LINK to the legacy tables. He has tried to update the legacy LINKed tables but Access will not re-index LINKed tables for him. I have been searching KB and MSDN and can not find any information about this problem. QUESTION: is it possible from within Access to programmatically re-index FoxPro files? ???? If yes, what is the Access command for re-indexing? If no, I assume (hope) it could be done with a few lines of MS Foxpro or C++ code ... or maybe there are some Foxpro utility programs that could do this via a simple shell to a command line (.cmd/.bat) file. ??? Thank you ................ gerry Tag: XMLAdapter and multiple tables Tag: 199868
  - 14
    - progress bar In VFP 6.0 how can a progress bar be shown ? Tag: XMLAdapter and multiple tables Tag: 199862
  - 15
    - How to execute Stored Procedures in Oracle from VFP? Hi, Does anyone know how to execute stored procedures in Oracle through Visual FoxPro? I tried SQLEXEC(gn_handle, "EXEC sp_sample(parm1, parm2, parm3)") but doesn't work. I tried SQLEXEC(gn_handle, "sp_sample(parm1, parm2, parm3)") but still doesn't work. Regards, Anand. Tag: XMLAdapter and multiple tables Tag: 199858
  - 16
    - Eval Fn.??? hi, i want to know how i specify that the evaluate function didn't return valid value as xx=yy ?evalutae(xx) this will rase system error but iwant to check whether it is valid return value 1st or not thx -- Ramez Ernest Tag: XMLAdapter and multiple tables Tag: 199856
  - 17
    - using datatoclip ? Hi, I'm just wondering how DataToClip can be used or better : why it can be used and in what cases if there is no ClipToData function or is there ? It's because I'm looking for a way to give my users the ability to copy a set of records from one table to another table with Ctrl+C and Ctrl+V. I've managed to do it for one record and while doing this I came across the DataToClip function and was wondering if there is one the other way so I can easely move around records. Of course there are other ways but well you know, at least just for the fun of using the clipboard.... regards christophe Tag: XMLAdapter and multiple tables Tag: 199848
  - 18
    - Change in SQL commands! In VFP7 this commend work: SELECT MAX(nJN2_1) as MaxTime, cJN2_2 from jn2 In this command I can see Max of nJN2_1 and cJN2_2 that have Max Value. In VFP8 and VF9 when I run this command see an error: SQL: GROUP BY Clause is missing or invalid. Why? and if this command is changed, how we can know what record have Max Value! My E-Mail: HeartRefine@Yahoo.com Tag: XMLAdapter and multiple tables Tag: 199840
  - 19
    - what file (extention) should be included for distribution setup what file needed (eg. foxpro 2.6 screen - .spr, the vsual foxpro ?), pls anyone.. help me..urgent! thank's.. Tag: XMLAdapter and multiple tables Tag: 199838
  - 20
    - How can I determine when a file has finished copying so I can grab I need to import and process text files as they are copied to a folder. Some files can be a few megs in size and I don't want to grab them until they are copied completely. A coworker uses LEN(FILETOSTR('filename')) in a loop with a 10 second WAIT and grabs the file when the size stays the same two times in a row. Anybody know of a better solution? Thanks, Gary Tucker Tag: XMLAdapter and multiple tables Tag: 199836
  - 21
    - VFP 6: Name Substitution If a is an object and b is the name of a property or column, what is the best way of accessing the property/column? I was using a.&b but tried to use name substitution, namely a.(b) The former works, but the latter does not. What is the correct way for using name substitution here? Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: XMLAdapter and multiple tables Tag: 199833
  - 22
    - FoxPro Scripting Question Hi, We a business application that allows us to write foxpro scripts for certain functions. This application has some API calls that we can call in our scripts. There is not alot of documentation on these so I am struggling trying to get this to work. This what I do know: 1) There is not a seperate dll to declare 2) The api functions are built into the main exe So, my question is how do I call these functions? Thanks Tag: XMLAdapter and multiple tables Tag: 199822
  - 23
    - Report Preview Questions 1) I have a client who would like to right click on the report preview and send output as an attachment in email. They have this functionality in an Access program. Ideas/suggestions?? 2) Also in the print preview is it possible to print just one page (current page)? Thank you much for your input Gar Tag: XMLAdapter and multiple tables Tag: 199810
  - 24
    - returning cursor form a com object I want to create a com object with a method which will return a cursor. Is it possible to return a cursor from a com object. Thanks in advance Dave Tag: XMLAdapter and multiple tables Tag: 199808
  - 25
    - _SCREEN.Caption and API SetWindowText Hello ! The following code does not work in VFP6 and Win98 After SetWindowText function call the _screen.Caption does not change Any suggestions please. Kuido PROCEDURE sedt LOCAL hwnd, pol,t1,t2 DECLARE INTEGER GetActiveWindow IN Win32API DECLARE INTEGER GetWindowText IN Win32API INTEGER hwnd, STRING @lpString, INTEGER cch DECLARE INTEGER SetWindowText IN Win32API INTEGER hWnd, STRING lpString DECLARE INTEGER GetLastError IN Win32API hwnd = GetActiveWindow() t1=SPACE(40) t2=LEN(t1) t2=GetWindowText(hwnd,@t1,t2) ? "Window Text:", LEFT(t1,t2) ? _screen.Caption pol="Uus tekst" t2=SetWindowText(hwnd,pol) IF t2 > 0 t1=SPACE(40) t2=LEN(t1) t2=GetWindowText(hwnd,@t1,t2) ? "Window Text after: ", LEFT(t1,t2) ? _screen.Caption ELSE ? "ERROR", GetLastError() ENDIF RETURN Tag: XMLAdapter and multiple tables Tag: 199806

I try to use, within VFP8, the XMLAdapter to open an XML file containing
multiple (4) tables.

oXMLAdapter = NEWOBJECT('XMLAdapter')
oXMLadapter.LoadXML('M:\Edipax\order.xml',.T.)
oXMLAdapter.Tables(1).ToCursor()

up to there it works fine.

but when i try

oXMLAdapter.Tables(2).ToCursor()

i got an error "no existing member in the collection".

Thanks in advance for help,

Kind regards,

Guy

Top

Re: XMLAdapter and multiple tables by Sietse

Sietse
Fri Sep 17 17:15:00 CDT 2004

Hi Guy

The XMLAdapter in VFP8 has capabilities for reading multiple table XML, I've
seen it in action.
Your XML probably contains hierarchical XML tables from a SQL server. This
gets retrieved into the XML adapter. The main table is the 1st table in the
tables collection. Child tables are accessable through the childtable
property of the XMLtable. Take a look at it in the VFP help

HTH,
Sietse Wijnker

BTW, if this help isn't sufficient, please post your XML.

"Guy Colsoul" <guy.colsoul@ineo.be> wrote in message
news:414b1343$0$8984$6c56d894@feed0.news.be.easynet.net...
>I try to use, within VFP8, the XMLAdapter to open an XML file containing
> multiple (4) tables.
>
> oXMLAdapter = NEWOBJECT('XMLAdapter')
> oXMLadapter.LoadXML('M:\Edipax\order.xml',.T.)
> oXMLAdapter.Tables(1).ToCursor()
>
> up to there it works fine.
>
> but when i try
>
> oXMLAdapter.Tables(2).ToCursor()
>
> i got an error "no existing member in the collection".
>
> Thanks in advance for help,
>
> Kind regards,
>
> Guy
>
>

Top