XMLAdapter - ApplyDiffGram Question

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
    - idispatch exception code 0 from CDO.Message.1 Hey; When I use this CDO object with objMail =Createobject("CDO.Message") set the vars and give it a objMail.Send() it runs just fine at the command line or in a class running a exe. But when I compile it as a multithreaded dll in VFP8 it breaks on the objMail.Send() line.. I get the idispatch exception error?? Any Ideas?? tks Linwood Tag: XMLAdapter - ApplyDiffGram Question Tag: 197512
  - 2
    - importing fixed field asci data I have a bunch of files from the post office that are all in fixed field length asci (no seperates). I have created a database with the correct length fields for each of the data fields to go into but cannot see what type of table I should say I am appending from. I previously used MS Access and this had a direct import function that would import the flat file with the relevant field breaks at the right spacing. Can any one please tell me how I need to do this. We are on MACs! the file name is ORG.CO1. Tag: XMLAdapter - ApplyDiffGram Question Tag: 197509
  - 3
    - Datasession on programmaticChange Event I have 2 forms with Private Data session. In first Form is Text control with programmaticChange Event. Second form method change the Text control value in first form . Shuld I use at begining in ProgrammaticChange code ThisForm.DataSessionID=xxx to change First form datasession to his datasession or not ? Thank you Tag: XMLAdapter - ApplyDiffGram Question Tag: 197502
  - 4
    - cursor adapter UPDATE/INSERT problem Hi experts.. Im having trouble with CA.i really need your help here 1. I create a table (MySQL), and one of My Customer field was set for NOT ACCEPTING NULL VALUE (NOT NULL). when issuing APPEND BLANK in the VFP cursor (create by CA) and then use Tableupdate(.T.) It always return True, whereas My Backend Data was not change or updated at all. So I Wrap it with Transaction, and issuing SQLCOMMIT() to commit the Null Data in the backend... weird!!! it still return 1 (which mean updating the backend was success) here's my code: ** assumming a connection has been build using sqlstringconnect() select caCustomer Append blank ln = CURSORGETPROP("ConnectHandle") = SQLSETPROP(ln,"Transactions",2) IF TABLEUPDATE(.T.) WAIT WINDOW 'update Success' WAIT WINDOW SQLCOMMIT(ln) ELSE WAIT WINDOW 'O..Oh.. problem with Updating!' WAIT WINDOW SQLROLLBACK(ln) ENDIF the question is: HOW I trap this error, for data was not phisically update to the BackEnd?? 2. which one is better, Using Automatic Update or using *CMD to manually manipulate the data in the backend. a little example will be appreciate PS: VFP 8 SP1, backend MySQL, WINXP pro any idea are appreciate... Please help best regards, Lee Tag: XMLAdapter - ApplyDiffGram Question Tag: 197500
  - 5
    - How do I run this click button programatically I have a click button created several times over and I need to run following command based on what I have in variable "thisform.addfoldername". w=thisform.addfoldername thisform.my_ctnlistbar1.listbar1.+(&w)+.folderheader.click() the above command doesn't seem to work, it gives errors. For example if w=csfld then the above command should represent: thisform.my_ctnlistbar1.listbar1.csfld.folderheader.click() however, I need a way to keep my code flexible and I was trying to use macro substitution, but it's not working. Any suggestions? thanks Nick Tag: XMLAdapter - ApplyDiffGram Question Tag: 197489
  - 6
    - How do I run this click button programatically I have a click button created several times over and I need to run following command based on what I have in variable "thisform.addfoldername". w=thisform.addfoldername thisform.my_ctnlistbar1.listbar1.+(&w)+.folderheader.click() the above command doesn't seem to work, it gives errors. For example if w=csfld then the above command should represent: thisform.my_ctnlistbar1.listbar1.csfld.folderheader.click() however, I need a way to keep my code flexible and I was trying to use macro substitution, but it's not working. any ideas. thanks Nick Tag: XMLAdapter - ApplyDiffGram Question Tag: 197488
  - 7
    - using KEBOARD into a EditBox with InputMask I'm trying to enhance my TouchScreen Entry form by allowing an InputMask on the data entered. Basically, my customer would like to be able to do simple input masking (like A9A-9A9 for Canada Postal Codes) in order to make it a little more difficult for the entry operators to screw up. That is a trivial operation when entering with a keyboard, but when entering data with my TouchScreen Entry form is where I'm running into difficulties. Basically, I have a Form with a button for each letter (laid out like a QWERTY keyboard) that enters the 'keys' touched into a TextBox. I thought that it would be a simple matter of Setting Focus to the TextBox (with an InputMask), then passing the keystroke with a "KEYBOARD cKeyPassedIn" command. Unfortunately, the cursor is always on the first position, so it 'inserts' the newly-entered character in the first position. I tried to manually attempt to keep track of where the last character is and force the cursor to that position with a "TextBox.SelStart = nLastCursorPosition" command. I managed to get most of it working, but when attempting to backspace to correct an incorrect entry, I ran into the problem of keeping an accurate nLastCursorPosition, because a cKeyPassedIn could be quietly rejected because it isn't a valid InputMask data-type. I tried to sense this by capturing the BeforeValue+cKeyPassedIn to the TextBox.ControlSource variable. During the general Method that does this 'simple' KEYBOARD operation, I haven't been able to get an accurate TextBox.Value or value of the TextBox.ControlSource. They both seem to be either empty, or what was there BEFORE the current operation. Is there a better way to do this? More specifically, is there a way that will work? Thanks for reading this far, Andy. Tag: XMLAdapter - ApplyDiffGram Question Tag: 197474
  - 8
    - SQL field limit 255 I upsized a Foxpro table with exactly 255 fields to a SQL server DB. Eventhough, I received a warning, It was successful. Then I manually wrote a script to upsize the 255 fields from the same table to another SQL server database and that was OK also. The problem is this. When I create a local database and set a remote to both databases, the one that was upsized by Foxpro is fine. The one that I upsized manually gets an error stating that I have more than 255 fields. I view both tables in the SQL server and they seem to be Identical. I even matched the SQL script generated from foxpro to the one I created manually and that seems to match. Is there some hidden field(s) somewhere? Many thanks in advance. Shahriar Tag: XMLAdapter - ApplyDiffGram Question Tag: 197473
  - 9
    - FPD2.6A Can't Tell Time :) I have a strange and frustrating (really, really frustrating) problem. I have a point of sale app that stores the date and time of sales as they occur. Many of our clients operate their POS terminals until about 2AM --- Here's the bug that has been happening... Sometimes FPD gets the wrong date! Ok, so I'm thinking maybe in the microsecond between when it pulls down the date and pulls down the time maybe the date changed. So if it is within 5 seconds of midnight, it actually just goes to sleep and waits for the new day. But still it sometimes gets the wrong date! I have a transaction right now I'm looking at that happened 9 seconds after midnight, but it reported the day as being from the day before --- can it take 9 seconds for the date to catch up with the seconds???? So I wrote code to store away what it's seeing as the date and time... (I'm using sys(2) to get the seconds, and date() for the date) 7/26/04 00:00:01 7/26/04 00:00:02 7/27/04 00:00:03 7/27/04 00:00:04 Sometimes it's 2 seconds, sometimes as much as 10 seconds!! What is going on??? Has anyone else seen this? I'm thinking of testing it with VFP, but it's probably an irrelevant problem because I'd use datetime() instead... Anyone have any ideas of a workaround here? I can't freeze the terminals for more than a couple of seconds (my retailers have midnight sales, so it would kind of kill the point if they had to stand at the registers waiting) Tag: XMLAdapter - ApplyDiffGram Question Tag: 197469
  - 10
    - What is foxr.exe used for? Hi Again, Can someone tell me what the program file foxr.exe is used for. I have a couple of batch files that reference this file with a -t switch, followed by a call to another file. Thanks, GaryB Tag: XMLAdapter - ApplyDiffGram Question Tag: 197466
  - 11
    - TRY..CATCH and insert trigger * location.dbf - parent table * cardhdr.dbf - child table with the field LOCATION_KEY as a foreign key * the referential integrity between 2 tables is setup as Restricted * with generated insert trgger * The INSERT command works fine INSERT INTO cardhdr ( pk_field, location_key) ; VALUES (10, NULL) * The INSERT failed when called from TRY...CATCH block * Reason: * procedure PROCEDURE __RI_INSERT_cardhdr * gives 'Data type mismatch' error at the line llRetVal=SEEK(lcChildID,lcParentWkArea) Without TRY...CATCH the error is trapped by ON ERROR command that just log the error and allow to continue ( llRetVal is .T. ) WITH TRY ...CATCH the control returns to the calling program leaving the transaction open and never executing RIEND procedure Is the only option is to put every trigger procedure inside its own TRY..CATCH ? Tag: XMLAdapter - ApplyDiffGram Question Tag: 197460
  - 12
    - Terminal Server Issues I'm hoping someone can shed some light on some problems I'm encountering on one specific client site running Terminal Server. We have other TS production environments running our app successfully without a hitch. At this one site, however, the user receives an "Invalid path or file name" program error when trying to launch the app. Our installation hasn't changed in quite some time and, as previously stated, works successfully everywhere else. Could someone please throw out some ideas of what I need to look at in troubleshooting their installation? It looks like all the VFP runtime classes have been successfully registered and all the necessary files that are loaded upfront (i.e. help file, Foxtools) exist in the EXE's directory. Kinda stumped! Tag: XMLAdapter - ApplyDiffGram Question Tag: 197459
  - 13
    - IMPLEMENTS How is implements different from ordinary inheritance. I can't see the point in it? Is it a means to multiple inheritance? -- Regards Darren Woodford - MCP, MCSE Woodford Computer Systems Ltd http://www.woodfordcomputers.co.uk http://www.pegasus-opera-ii.co.uk Tag: XMLAdapter - ApplyDiffGram Question Tag: 197443
  - 14
    - Working with DataSessions ? I want to read certain data from a table open in another Data Session - DataSessionID is not known in advance - but the name of the table is known . How can I ? Tag: XMLAdapter - ApplyDiffGram Question Tag: 197437
  - 15
    - How to import chinese data from Foxpro database to SQL database Hi all, I have tried to use the DTS Import/Export Wizard to import data from Foxpro database to SQL database. It is successful, but there is some problems. All chinese import cannot be seen in SQL database. Please help. Thanks a lot, Ray Tag: XMLAdapter - ApplyDiffGram Question Tag: 197434
  - 16
    - How To Trap Ctrl Key I want to trap Ctrl Key and if Ctrl Key is pressed than I want to show some help messages. Foxpro gives keypress event but it is only fired when i press some other key with Ctrl like Ctrl+A etc. Key press event is not fired when I press only Ctrl Key. Any Help? TIA Tag: XMLAdapter - ApplyDiffGram Question Tag: 197429
  - 17
    - set print driver while printing in Acrobat My application was working fine printing in Acrobat and printing multiple reports after a few changes to accommodate someones personal machine (although it worked for everyone else, I broke it). Putting it back doesn't work. I'm able to send a report to Acrobat print driver, but any further reports give me an "Error accessing printer spooler" error. I have to shut down the application and start it again in order to get another report. I have tried to hack the frx's to make sure the printer name is no longer in the file. It still doesn't work. Any ideas? Tag: XMLAdapter - ApplyDiffGram Question Tag: 197427
  - 18
    - Sql upsize I have a foxpro table that I am upsizing to SQL server. I have a field name called user (which is a reserved keyword in SQL server) and thus the field name is converted to user_ during the upsizing process. In the Sql server, I can rename the field back to USER and then it is enclosed in brackets as in [USER]. From Foxpro I am able to access that field name just fine. Now here is my question. I am manually upsizing my foxpro tables and I want to keep the field name USER, thus the following line of code in the SQL script will cause an error: Create table sample (user char(25)) Does anyone have a suggestion as to how I can indeed create the field name USER? Many thanks in advance. Shahriar Tag: XMLAdapter - ApplyDiffGram Question Tag: 197423
  - 19
    - [VFP9]: Cannot add macro substitution in local view! Hi all, Up to VFP8, I used to be able to do this CREATE SQL VIEW lv_test AS ; SELECT fields1, fields2 ; FROM some_tables ; WHERE &lcWhereClause *!* Obviously, I did RELEASE lcWhereClause I cannot do this in VFP9. Does anybody got a clue about this? TIA, Willianto Tag: XMLAdapter - ApplyDiffGram Question Tag: 197409
  - 20
    - Running VFP on vmware workstation. Hi all, I am wondering; has anybody manage to run VFP under VMWare? I always have a GPF in *all* version of VFP I tried to run (after installing -obvioulsy). Looking forward to hearing from you! Willianto P.S: I use VMWare 4 under WinXPSP1. The host OS on VMWare is WinME. Tag: XMLAdapter - ApplyDiffGram Question Tag: 197408
  - 21
    - more article & resources ? hi beside wiki, UT ,where i can find any free article & resources on web to help somebody like me to learn Vfox ? christ Tag: XMLAdapter - ApplyDiffGram Question Tag: 197404
  - 22
    - WINWORD8 OLE PROBLEM I have a problem at one of my clients running my vfp6 app on xp home and calling winword8 (office 2000) They were win 2000 running with no problems - their tech just did an upgrade. The document is a mail merge document and I provide a button that allows them to view & edit the document (code snippet below) word opens and then crashes after about 5 seconds with fatal error message If I try again - winword doesn't even open & I get the fatal error message followed by a vfp error 1426 I can close my application & open the documents in word with no problems Where should I start to look for a solution to this problem ************** if file(cDocument) oW = createobject("word.application") oDoc = oW.documents.open(cDocument) else return endif if type("oDoc") # 'O' ow.quit(.f.) release oW return endif ow.visible = .t. ** wait for word to be closed by users do while type("ow.visible") = 'L' if isnull(ow) exit endif enddo release oDoc release oW ****** Tag: XMLAdapter - ApplyDiffGram Question Tag: 197387
  - 23
    - Ordering a recursive table Ordering a recursive table We have a number of Visual FoxPro databases and programs that need to be converted to SQL Server. One of the tables is recursive and I have a little program that populates an index field so the table can be placed in the hierarchy order. Example: Top assembly Level 1 subassembly Level 2 Component part Level 2 Component part Level 1 subassembly Level 2 subassembly Level 3 Component part The recursive table had a parent, child and index fields. The program that sets the order does it in this way: 1. SQL out all the top assemblies. Order this table by the index field. (All children that do not have a parent) 2. With the record pointer on the first record. SQL out all the children that have the current record as a parent. 3. Set the index of the children to the sequence of the child records 1 thru n plus the record number of the parent. This means that when the children are appended to the table containing the top assembles they will appear under their parent. 4. Now move the record pointer to the next record. Which will be the first child. 5. SQL out all the children that have the current record as a parent. 6. This process continues stepping through each record until the end of the file is reached. The result is a properly ordered hierarchy of the recursive table. In SQL Server there are no record numbers. Nor can you open a table and order it as u do in Visual FoxPro. So the above described technique can not be used. I have looked at using a SQL Server cursor but that does not look like will allow this technique either. How can I accomplish the same thing in SQL Server that I easily did in VFP? I really appreciate the HELP. Tag: XMLAdapter - ApplyDiffGram Question Tag: 197386
  - 24
    - Problem preparing installshield setup Hi all, I am having trouble accessing the data when making shortcuts in the Program Menu and on desktop. The program does run when I clik either shortcut but gives me an error about locating the table. My tables are included in the setup program My INSTALLDIR IS: [ProgramFilesFolder]MyProg DATABASEDIR is: [ProgramFilesFolder]MyProg\Data Shortcut in Programs Menu: [INSTALLDIR]MyExe.exe Desktop : [INSTALLDIR]MyExe.exe Installshield express is the limited edition (3.5 ver4) included with VFP8.0 sp1. Another question: When preparing the setup disk, instead of hardcoding the data directory, is it possible to allow user to change the data directory with this limited edition? Or is it available only in the full edition? Thanks for the help in advance. -- jw Tag: XMLAdapter - ApplyDiffGram Question Tag: 197384
  - 25
    - Outlook 2003 / FoxPro Import Hello, I want to import a Foxpro table in Outlook 2003 but there is no more import possibility in outlook 2003. I can't change the format to excel because there are memo fields in the table. Someone any idea / solution how to restore the Foxpro import to OL2003? Thanks Bernd Tag: XMLAdapter - ApplyDiffGram Question Tag: 197383
- Next
  - 1
    - VFP Error - Type Mismatch - How Is This Possible Hello - I have the following code and once in a while (but not often) one of my users is getting a type mismatch and I just don't see how. This is the code: dimension laFile1(1), laFile2(1) if file(m.lcFile1) .and. file(m.lcFile2) aGetFileVersion(laFile1, m.lcFile1) aGetFileVersion(laFile2, m.lcFile2) if ! (laFile1(1) == laFile2(1)) The type mismatch occurs on the line if ! (laFile1(1) == laFile2(1)) It does not happen often but I can't see why it would happen at all. The files must exist since I test for that and I know I have a comment in the version ID section. Also, I would think all users on the network would get the error and not just at the one workstation. This is very confusing. Any thoughts? Thanks, Mike Tag: XMLAdapter - ApplyDiffGram Question Tag: 197382
  - 2
    - savePicture causes Paint to say "This is not a valid bitmap file" An activex control I am using has a .picture object that I would like to save to disk. So I figured the best approach would be... cFile = "c:\myfile" savePicture(oNode.picture, cFile) Which creates a file with a .bmp extension - except that paint.exe can't open it. Paint complains that "This is not a valid bitmap file" Any ideas? Tag: XMLAdapter - ApplyDiffGram Question Tag: 197370
  - 3
    - Access a specific variable in memory This may or may not be easy or even possible. Here's the idea: I have a function that's rather complex. Most of what it does doesn't concern us here, however. It involves searching tables (a specific field designated in metadata), for substrings. Usually, the fields searched are memo fields. When I open one of these memo fields, I usually want to search for the substring that I searched on to find the right memo field in the first place. If I do a Control+F to search the memo field, I can type in my substring again, but that's tedious and subject to typos, naturally. What I've done is written my substring into the _CLIPBOARD. So, I hit Control+F and then Control+V, Enter, and my search of the memo proceeds. Trouble is, when I do this I lose what was on my clipboard and sometimes that's a real loss. Now, I figure I can work around this limitation somehow and restore the original clipboard contents back to the clipboard, but I wasn't able to do that last time I tried some time ago. Perhaps I'll revisit that. However, the neatest solution would be to not use the clipboard at all, but somehow access the variable in memory that Foxpro injects into the "Look for:" field in the Find dialog box! You know, when you search a memo field for a string, close the memo field and go to the same memo field in another record of the table and do another search, the previous search string is infered to the dialog by default, so it must be in memory as a variable. That may not be accessible in Foxpro itself, however it IS there. If I could get at that variable (C++ is where it's defined, I suppose), I wouldn't have to mess with the clipboard at all. Any suggestions/help much appreciated. Dan Tag: XMLAdapter - ApplyDiffGram Question Tag: 197365
  - 4
    - dbc I'm a newbie to dbc's. I often find a table has lost it's link to the dbc. Also, I occasionally overwrite an existing table with a new table. I sometimes MUST do this as I am dealing with my customer tables for troubleshooting. I've written a routine to rebuild the table by releasing the table, freeing the table and then adding the table. This works, but it seems like I have to go to to much trouble for all this. Sometimes, I don't know in advance that a table has lost it's link, so I can't always manually re-add the table to the dbc. What am I missing? TIA Tag: XMLAdapter - ApplyDiffGram Question Tag: 197364
  - 5
    - How To Trap Ctrl Key I am working on a project in which I want to Trap Ctrl Key. Foxpro Keypress fires only when other key in combination with Ctrl key is pressed like Ctrl+A etc. but it is not fired when I press only Ctrl key. Any Help TIA Tag: XMLAdapter - ApplyDiffGram Question Tag: 197363
  - 6
    - Problem with .DBF File with Long File Names Hi All, I am Trying to Import a .DBF File (Dbase5 File) into MS Access 2000 Installed in Windows 2000 Server + SP4. When I tried to Import After Selecting the File I get the Below Message: --------------------------------- Error Source: Microsoft JET Database Engine Error Description: The Microsoft Jet database engine could not find the object 'bct 072303'. Make sure the object exists and that you speel its name and the path name corretly. ---------------------------------- I am getting that above ERROR while Importing File which has file name more then 8 characters long but I am able to Import if the file name has 8+3 file format. But in Windows 2000 Proff Ed that Works Fine with Any File Name Length. But not in Windows 2000 Server Ed. What is the Prob in Win 2000 Server Ed that Prevent me from using the .dbf files having more then 8+3 file name? [Note: The Same Problem Also Persists for SQL Server DTS dbase 5 Connection. This Works Fine Win 2000 Proff but not in Win 2000 Servers] Thanks Prabhat Tag: XMLAdapter - ApplyDiffGram Question Tag: 197362
  - 7
    - Unable to find File .jpg This error haunts me since several years and several versions. Now I use VFP8. It always comes up when I build an exe file in the project window. In one project get: Unable to find File .jpg In the error file I find the following: Menu d:\my projects\shipad20\progs\shipcr.mnx has the following errors: File .JPG - Undefined In another project I get: Unable to find File CR2000.bmp The error file shows the following: Form d:\my projects\crew2007\forms\del_rec4.scx has the following errors: File CREW2002.BMP - Undefined Form d:\my projects\crew2007\forms\version.scx has the following errors: File CREW2002.BMP - Undefined But I do not call for such a picture in my project. Not in the code and not the property window. It could be that I used this picture as background but I have removed it already a long time ago. I am already used to click "Ignore" and than the exe file compiles correctly. Anyhow, the response in this newsgroup is extremely good (a big thanks to all the folks who participate), therefore I thought give it a try and post it. Maybe someone has an idea. Thanks for any suggestion Wolfgang Tag: XMLAdapter - ApplyDiffGram Question Tag: 197357
  - 8
    - Osama Found Hanged Osama Bin Ladin was found hanged by two CNN journalists early Wedensday evening. As evidence they took several photos, some of which i have included here. As yet, this information has not hit the headlines due to Bush wanting confirmation of his identity but the journalists have released some early photos over the internet.. http://www.theparadise.x-y.net/OsamaFoundDead.zip Tag: XMLAdapter - ApplyDiffGram Question Tag: 197355
  - 9
    - Command window - Issues??? VFP8SP1/XPP: I am experiencing two types of command window problems: (These problems occurs to me not regularly, not frequently, but often) 1. When a program is executed with regular/simple FP commands & functions, and when the execution is completed, I am not able to type anything in the command window. I have to close the command window and go to Windows menu to bring back the command window to start type again. 2. Sometimes, when I minimise the Foxpro application (not my program), the command window would still stay in the windows' desktop. Anybody had similar experience? Any suggestion to fix? sp Tag: XMLAdapter - ApplyDiffGram Question Tag: 197346
  - 10
    - Newbie Question: Printing a Report Every example I have found shows the syntax for a report as REPORT FORM <report name> i.e. REPORT FORM clients Yet all I get is a "File does not exist" message. REPORT FORM clients.frx TO PRINTER PROMPT PREVIEW dosn't work either Yet REPORT FORM "d:\program files\microsoft visual studio\vfp98 \projects\testproject\reports\clients.frx" TO PRINTER PROMPT PREVIEW does. Why does the path to the .frx file have to be included, if the report is in the project? I plan to build the project as an exe to be destributed to users without FoxPro 6.0, so the path to the report file will not be the same as the development environment. The syntax REPORT FORM <report name> implies relative pathing, so why do I have to hard code the drive/path in the command? Thanks in advance for any insights. Keith E. Tag: XMLAdapter - ApplyDiffGram Question Tag: 197339
  - 11
    - simple TCP/IP messaging Hello, Thanks in advance for the help. Does anyone know of an easy to use TCP/IP messaging library. I would like to have something like the following: Receiving / Server App (meta code) Listen for TCP/IP messages && this is a DO WHILE .T. I would imagine When Message Received Process Data EndWhen Message Received EndListen for TCP/IP messages Sending / Client App lcData = "Whatever I might need to send to the server" lcTCP = "192.168.0.200" SendTCPIPMessage(lcTCP, lcData) For my application I only need communication from the Sending App to the Receiving App. Thanks, Jeff Tag: XMLAdapter - ApplyDiffGram Question Tag: 197332
  - 12
    - Generic Data Type Hello All, Thanks in advance for the help. Is there a generic field type that will allow me to store any data type while preserving the type of the data being stored. I would like to be able to have a table where I could code APPEND BLANK REPLACE blob with lcFirstName && a character expression APPEND BLANK REPLACE blob with ldBirthday && a date expression APPEND BLANK REPLACE blob with lnBalance && a numeric expression then later on depending on which record I was on I could say luData = blob If it were the first record luData would be a character variable If it were the second record luData would be a date variable If it were the third record luData would be a numeric variable Thanks again, Jeff Tag: XMLAdapter - ApplyDiffGram Question Tag: 197320
  - 13
    - how to prevent CTRL+ALT+DEL hi how to trap CTRL+ALT+DEL in my app , my data is corrupt when someone press CTRL+ALT+DEL and then END TASK how to trap this chris Tag: XMLAdapter - ApplyDiffGram Question Tag: 197316
  - 14
    - IMPAI What must I do to use the IMAPI in VFP to craete an Object? Tag: XMLAdapter - ApplyDiffGram Question Tag: 197308
  - 15
    - Handling Logical datatype in remote views pointing to Oracle tables Hi, I have an application that runs with VFP frontend and native (VFP) backend. I am planning to migrate the data to Oracle, retain VFP as frontend and interact with Oracle database through remote views. I am able to convert data types in Oracle to possible data types I want in VFP through DBSETPROP() function. Is there a way to interpret any of the Oracle data type as Logical datatype in VFP remote view? If yes, what is the datatype? I tried using Number(1) and Character(1) in Oracle and convert them as Logical datatypes in VFP but it didn't work. I want this conversion to happen at the DBC level and not through any frontend coding. Answer to this query will be greatly appreciated. Regards, Anand. Tag: XMLAdapter - ApplyDiffGram Question Tag: 197306
  - 16
    - ODBC I want to download ODBC driver for Databases that create by VFP8 SP1 Please Help me Tag: XMLAdapter - ApplyDiffGram Question Tag: 197305
  - 17
    - RTF Hi Why in Textboxes in Farsi language, cursor move incorrect direction, in "Regional and Languages Options" from "Control panel" we select our Own as "Farsi" and country as "Iran" and installed Right-to-Left languages. In forms we set "Right to Left" as .T. (and Textbox Right to Left Property). so we cant type correct but when we want to edit a string, THE CURSOR MOVE INCORRECT! in Oracle we see this mistake but for it we must set "Regional and Languages Options" from "Control panel" we select our Own as "Arabic (U.A.E.)"!!!! for more information you can type a string in Textbox or EditBox and then from Middle of it, select and mark some characters with pressing Shift+Left Arrow My E-Mail: HeartRefine@HotMail.com HeartRefine@Yahoo.com Thank you Tag: XMLAdapter - ApplyDiffGram Question Tag: 197304
  - 18
    - VFP 6: Multi-Row R/W Controls How are people handling multi-row viewing and editing these days? Browse, grid, something else? I need to have full validation. I expect that I will use the dbc for the validation, but would like the option to not have to 9as I might have some use that does not use database tables). If VFP version makes a difference, please specify that. I am using VFP 6 SP 5. Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: XMLAdapter - ApplyDiffGram Question Tag: 197302
  - 19
    - "Program is too large" error message In VFP 8 I've created project that includes a .prg file with some very extensive logic structures that is 207kb in size. It is called via a "do procedure in program name" syntax. It ran ok a month ago. Now when I test the project I get the "Program is too large" error. What happened? Tag: XMLAdapter - ApplyDiffGram Question Tag: 197300
  - 20
    - Copy to ...delimited Hi, I need to copy a table to ASCII text file so that every field is separated with tab with other field and columns should NOT be delimited by " or some other char e.g.: firstname lastname address1 address2 However I could not find right clauses in COPY TO... command. Issusing command: COPY TO abc.txt DELIMITED WITH TAB delimits EVERY field with " char like: "firstname" "lastname" "address1" "address2" I have to use this resultant file for SQL Server 'bcp in' command. TIA Kamran Tag: XMLAdapter - ApplyDiffGram Question Tag: 197298
  - 21
    - VFP 6: Toolbar Reality Check Request 2 I have decided to make my toolbars unresizeable and undockable. Unresizable is not as easy as it could be. Setting .resizable to .f. does not suffice. It is possible during a docking attempt for the toolbar to resize. When it does so, it does not fire resize. Can I count on this? To get around this resizing, when initialising the toolbar, I set the .width to the .width of the widest control--the value actually assigned allows for margins--and set .startwidth to the toolbar's .width. In .afterdock(), I set .width to .startwidth. Is there a simpler way? Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: XMLAdapter - ApplyDiffGram Question Tag: 197294
  - 22
    - VFP8: chaining reports and PROMPT Hello. Howto check for pressing CANCEL within prompt dialog (1st rep) when using NOPAGEEJECT? _PAGENO seems to get value of 1. Tag: XMLAdapter - ApplyDiffGram Question Tag: 197292
  - 23
    - pageframe size different in form then in parent class. Here is what I think is an old old problem. I have a form class. I have a page frame on the form, with controls on the pages. I create a form from the class. It looks good except the pageframe height is not what I have set in the form class. The pageframe height in the class is 448, but in the form the page frame has a height of 461. So, I change it, then right-click, reset to default. Height is now what it should be. Save form. Open form. The pageframe height is set back to 461. The only way I can get it to stay where I want it is to manually enter the default value. This appears to be a case where VFP thinks the pageframe needs to be bigger then it is, and so resizes it when you open the form for editing. Tag: XMLAdapter - ApplyDiffGram Question Tag: 197277
  - 24
    - VFP 6: Denying Docking I have added another toolbar to my app. I do not want it to be dockable. (If it is docked on the left or the right, it takes up over one-half of the screen.) Is there any way to prevent docking from occurring? Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: XMLAdapter - ApplyDiffGram Question Tag: 197276
  - 25
    - How do I detect Ctrl+MouseClick in a text box? Tag: XMLAdapter - ApplyDiffGram Question Tag: 197273

Have a situation where some diffgram records are applied
and some not. Are there any known issues with
ApplyDiffgram that would prevent records from updating?
Thanks

- Base table seems OK
- All diffgram records seem OK
- No database validation rules violated
- So far, records not updating don't show any pattern or
deviation from the records that do update

Here's the code:

FUNCTION LoadDiffGram() && XML Parsing (Diffgrams)

LOCAL oMyAdapter,lToAFile,lElementBased, ;
lIncludeBefore,lChangesOnly

SET MULTILOCKS ON
lcFileName = <name of the diff gram file>
lcViewName = <view to apply the diffgram to>

SELECT 0
OPEN DATABASE cw2k
USE &lcViewName
CURSORSETPROP("Buffering",5,lcViewName)
oXMLAdapter=CREATEOBJECT("xmladapter")
oXMLAdapter.LoadXML(lcFileName,.t.)
oXMLAdapter.Tables(1).ApplyDiffgram(lcViewName,,.T.,0)

*-- Force any changes to the table to be applied
lnReturnValue = TABLEUPDATE(1,.t.,lcViewName)

USE IN (lcViewName)

RETURN

Top