ODBC vs. OLEDB

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
    - Is it possible that Norton Antivirus can cause data corruption in VFP tables? I have a client running NAV and my VFP6 app data keeps getting screwed. I tried disabling NAV & the problem went away - is this a known problem? Thanks John Tag: ODBC vs. OLEDB Tag: 186115
  - 2
    - Unable to release form.. Hi I use VFP7. I have a top level form and top level menu. A form is displayed for each meu item. I run a programme to release the displayed form when another menu item is chosen. When a "grid" in the form has the "focus", I am unable to release the form. I have tried all the commands like release window, object.release etc.. None works. But there is no problem with other controls like combo,text boxes etc.. Please help me .. Thanks in advance. Bala . Tag: ODBC vs. OLEDB Tag: 186114
  - 3
    - old annoying bug or a feature? Hi, In order to validate user's imput, I place in Valid Event of Textbox some code, wich calls a form for data lookup or entering new data in related tables. Depending on lookup results, the focus stays in the Texbox or jumps to other controls with a help of RETURN n command. This seems to be very clear and convenient, but... If in some other form, launched from Valid Event, there is a SetFocus Method - the error comes: SetFocus method can not be called within Valid Event. But SetFocus is called in other form! And what more, in a way can be several more form calls that has nothind to do with the first one, but the error comes nevertheless :( I wonder, if MS will ever fix this annoyance or it is treated like a feature? Vitas Tag: ODBC vs. OLEDB Tag: 186113
  - 4
    - VFP8 Command window - Expression builder I have recently upgraded from VFP6 to VFP8 (although at the moment I feel as if I have stepped backwards)and am not a programmer or developer in any way. XP/SP1 is the OS. Keyboard macros are much used in my hobby. Could anyone spare the time and trouble to tell me how to get rid of the expression builder that pops up as soon as the macro issues the Locate or Seek command etc. This slows up things tremendously, especially where the Locate command is used in Memo fields, by comparison with VFP6. Searson Tag: ODBC vs. OLEDB Tag: 186112
  - 5
    - Bug? The InteractiveChange Event in a combobox in a grid cannot be trigged? I found the InteractiveChange Event in a combobox in a grid cannot be trigged properly if 1) RowSourceType is 6 and you hold the left button of a mouse and move to the row you want and release the mouse. 2) RowSourceType is 1 and you click the down arrow and release the mouse and then move to the row you want and release the mouse. RecordSourceType in the grid is the default value 1. It works if you use method 1) when RowSourceType is 1 or you use method 2) when RowSourceType is 6. Any ideas? TIA Tag: ODBC vs. OLEDB Tag: 186111
  - 6
    - InstallShield and MSDE Hya Folks, I've tried to create a setup via installshield (the free 3.5 Express with VFP8). Right now, i've got a big problem with my MSDE2000 merge module. Everything runs fine with the build of the disk image, but when installing, the setup stops either with either "not enough free space on drive MSSQL" or "cannot find drive MSSQL". Anyone knowing this problem and able to help? Pierre Tag: ODBC vs. OLEDB Tag: 186103
  - 7
    - VFP to VC++ I'm wondering if creating interfaces in VC++,populating list boxes and grids is similar and as easy and as flexable as VFP. I'm thinking of developing the same app I developed with VFP in VC++ so I can say I did it in VC++ as well. Are the VC++ controls similar to VFP controls with methods and properties etc. Are classes just as easy to work with? Thanks in advance Tag: ODBC vs. OLEDB Tag: 186095
  - 8
    - Controler Print hi, everybody. Please, i need controler the number is send to print in XP?. for example, in the morning i send to one print but this print is with two paper. I need registration in my database the number of impresion and the number of pages. But this impresion no is only the vfp, is also send word, excel, or other program. Thanks my friend. Tag: ODBC vs. OLEDB Tag: 186087
  - 9
    - Can't print from memo field in VFP 5.0a I have a little application I created for someone which is simplicity itself. One screen, one table with two fields - a character field and a memo field. The screen has 3 buttons: Search New Exit Problem is, although Print is enabled on the File menu when viewing the memo field, executing the Print function does not activate the printer! Is there a way I can fix this? The application was originally created in FPW 2.6a and converted in VFP 5.0a and otherwise seems to run OK. Thanks for any help! Dan Tag: ODBC vs. OLEDB Tag: 186083
  - 10
    - FPW 2.6a, closing DOS window after RUN command Hello, I'm running a batch file from FPW with the RUN command. I have the "Close program on exit" option enabled in foxrun.pif but the DOS window stays on the screen if I use RUN /N. It disappears with just RUN - I actually want to use just RUN but for some unknown reason that produces "RUN / ! command failed". RUN /N works fine except for this window being left behind.. Any ideas? Maybe shellexecute API call would fix this but I've no idea [not entirely true but for the purposes of explaining I have no idea..] how to call this function from FPW2.6 -- TIA Andrew Howell Tag: ODBC vs. OLEDB Tag: 186069
  - 11
    - foxprow2.6a exe Hello Could anyone please send me or give a link to where I could download patched files of foxprow 2.6a so than could run in XP. I downloaded patches themselves but they state the file is not the right size, internation patch does not work either. After playing with them, I do not have 'divide by zero' message anymore, but fox crashes after 'invalid path or filename' message. I do not have any installation disk anymore so I cannot follow the official patching procedure. Maybe I could download installation kit form somewhere? Best regards and thanks for any help, Piotr Tag: ODBC vs. OLEDB Tag: 186065
  - 12
    - cursoradaptor and updategrams when using XML Hullo, I'm trying to get a cursoradaptor, which has retrieved its data via xml, to generate an xml updategram from updates made to its attached cursor. I've followed all the instructions that VFP's help lists (I think) but cursoradaptor.updategram remains empty. Does anyone know of sample code or other documentation relating to cursoradaptors using xml and producing updategrams? Thanks. Yours faithfully Paul S. Elliott (Senior Developer) 4technology Ltd P.O. Box 1681 Christchurch New Zealand ph : +64 3 3771170 fax : +64 3 3771172 Tag: ODBC vs. OLEDB Tag: 186062
  - 13
    - Error when trying to open class This one is driving me nutty. The problem cropped up when I tried to MODI CLASS on one of the classes in a VCX. VFP says "Error loading file - record number 73. lblReplaces <or one of its members>. Parent: Not a table". I tried deleting record 73. Same error. I packed the VCX. Same error on record 73, but now it reported the object as a grid object (the one that used to be record 74 before the pack). I use Cryptor for encryption of the data in this app and I get a "Not a table" error if I forget to load Cryptor and register the data files, so I thought it was something related to the encryption (though I had the library loaded and set up properly). So I decrypted all the data even though VFP shouldn't be attempting to open the tables when it opens this class. Unfortunately, that did not do the trick. I've checked out the label base class that record 73 is based on and it seems fine as do all of my other base classes. I'm checking the VCX for corruption, but so far I haven't turned up anything. Anybody seen this before. This happens under VFP 7 SP 1 and VFP 8 SP 1. Thanks, Russell Campbell Tag: ODBC vs. OLEDB Tag: 186055
  - 14
    - 'System.InvalidOperationException When using OleDbDataAdapter.Fill method to transfer the table from the fox .dbf file to the DataSet, I get the following error, I don't have a clue what could cause this error. An unhandled exception of type 'System.InvalidOperationException' occurred in system.data.dll Additional information: The provider could not determine the Decimal value. For example, the row was just created, the default for the Decimal column was not available, and the consumer had not yet set a new Decimal value. Tag: ODBC vs. OLEDB Tag: 186054
  - 15
    - Must be an easy way to do this... Given that Adobe Acrobat 5 is installed on the PC running my VFP 6 SP5 application, and given that there is a specific PDF file sitting somewhere on the PC's hard drive, I want to gracefully print a hard copy of that PDF to the current Windows printer. I have looked through the Acrobat SDK and see the DDE calls such as FilePrintSilent but have only been able to use this by first starting up Acrobat *Reader*, establishing the DDE connection to it, then printing the desired PDF. This is very clunky and visually ugly with Reader popping up. I am extensively using Acrobat itself through OLE automation which is completely invisible to the user, but I see no way to use an Acrobat OLE object to print a hard copy of a specific PDF file. You can print a PDF file within the Acrobat application itself, but not via OLE? Seems odd. Has anyone had success with printing a hard copy of a PDF file invisibly from within VFP? Perhaps a third-party tool? -- TRW _______________________________________ My e-mail: t r w 7 @ i x . n e t c o m . c o m _______________________________________ Tag: ODBC vs. OLEDB Tag: 186050
  - 16
    - Finding the last record in a table How would you go about locating the last of one or many records for an account in a table. The table can have just one or many and the account identifier is in a memo field. The format of the account number is easy enough to find in that it will have the syntax, for example: account = 12345.00 I'm assuming I should create a logical field called last that I can then populate with .t. for last. I can open the table twice, scan (for not reviewed-explained later) , flag as last upon finding a perform a loca for the field in the second, with a continue. I can also create a reviewed field that will be set to .t. after either being hit in the scan, or located. That's as far as I get with it. -- Thank you, Louis Tag: ODBC vs. OLEDB Tag: 186046
  - 17
    - Exchange 2000 public folders access problem Hi all, I write this, **-------------------------------------------------------------------- oOutlook = CreateObject("Outlook.Application") oNameSpace = oOutlook.GetNameSpace("MAPI") oCNoDeseado = oNameSpace.Folders("Carpetas públicas").Folders("Todas las carpetas públicas").Folders("Correo no deseado") _ClipText = '' FOR lnumX = 1 TO oCNoDeseado.Items.Count oItem = oCNoDeseado.Items(lnumX) FOR lnumY = 1 TO oItem.ReplyRecipients.Count oItemP = oItem.ReplyRecipients.Item(lnumY) IF lnumY = 1 THEN _ClipText = _ClipText + TEXTMERGE("<<lnumY>>, ") ELSE _ClipText = _ClipText + ', ' ENDIF _ClipText = _ClipText + OItemp.Address + CHR(13) ENDFOR ENDFOR KEYBOARD '{CTRL+V}' MODIFY COMMAND **-------------------------------------------------------------------- The result for this commands is like this: 1 Charlene Cope, l98kuewp@hotmail.com 4 Holiday Gifts, opuvavmnogtvp@pgqexeikn.dealofalifetime.net 8 Breast Booster, Info11ljtnodjb@breastbooster.com 10 Franquicia Internacional, catterine@international.com 11 Franquicia Internacional, catterine@international.com 13 Tapia, zixwqusgmxkro@hongkong.com 15 Adeline Bryson, j74qatmcdh@yahoo.com Wath I need: I need the list of address of email sender, stored in a public folder. Questions: - Why the items (2,3,5,6,7,9,12,14) report oItem.ReplyRecipients.Count = 0 - There is another way to access the field from (This don't appear in the properties list) - How Outlook show this field and I don't access? Thank's a lot. Mauricio Mesa G. Tag: ODBC vs. OLEDB Tag: 186042
  - 18
    - COM information in DLL Installshield is complaining a little when creating setup files. How do I place COM information in the files to avoid this? ** Warning: -4354: The build was unable to extract COM information from the file N:\foxn\rmlbiz.dll in component rmlbiz.dll. Please ensure that the file is self-registering and verify that the self-registration process does not fail. ** Warning: -4354: The build was unable to extract COM information from the file N:\foxn\rmldata.dll in component rmldata.dll. Please ensure that the file is self-registering and verify that the self-registration process does not fail. ** Warning: -4354: The build was unable to extract COM information from the file N:\foxn\rmlexe.exe in component rmlexe.exe. Please ensure that the file is self-registering and verify that the self-registration process does not fail. Tag: ODBC vs. OLEDB Tag: 186036
  - 19
    - dimension array as object In Visual Basic, you can do something like this: type MyType var1 as string var2 as integer end type dim MyVar(20) as MyType I'm trying to do something similar in FoxPro. It seems like you should be able to use CreateObject('Empty'), then add the properties to it you want, then dimension an array of the object like. Something like this: MyType = CREATEOBJECT("EMPTY") ADDPROPERTY(MyType,"Var1","") ADDPROPERTY(MyType,"Var2","") DIMENSION MyVar(20) as MyType However, this doesn't dimension MyVar as MyType. It dimensions it the same as if you didn't use "as MyType". Is there any way to dimension an array as an object like I want to do? Kevin Clark Seton Home Study School Tag: ODBC vs. OLEDB Tag: 186029
  - 20
    - Capture data from printer port I have a dedicated PC running in MSDOS 6.22 with a customised software (I think it was written in C laugauge) that control a machine through interface cards. While the machine is operating, the software will print report of data to the printer port attached with a Epson Dot matrix printer. Is there a way that I can tap the output data from the printer port (parallel port) to another PC as a ASCII text file? My purpose is to make use of the output text file to import into foxpro so that I can manipulate the data using foxpro. Anyone has any idea? Please help. Thanks Tag: ODBC vs. OLEDB Tag: 186015
  - 21
    - How can operate such low-level file in vfp? Hi,everyone, The attachment file was not created by vfp, I want to create and operate such file in vfp. I can't create it in vfp by fcreate & fwrite function, also I can't read the right information from the attached file by fread. The attached file includes two continuous digits: 0000000001 and 0005183372, you can see it by debug. Anyone can give me ideas? thks in advance? chuen begin 666 m.t +J@`````!``48,W(` ` end Tag: ODBC vs. OLEDB Tag: 186010
  - 22
    - Cannot Locate VFP Support Library in Windows XP Hi, I created a VFP application along with the run time file and distributed to a client who is running Win XP. After they install the application, when they login as Administrator to that computer, they can run the app without a problem. But when they login as a restricted user they are getting an error saying "Cannot locate Microsoft Visual Foxpro Support Library" Any ideas? Best Regards, Y. Sivaram Tag: ODBC vs. OLEDB Tag: 186003
  - 23
    - Foxpro freezes up I developed a vfp 6.0 application that previews a report to the screen and that works fine. However, when I close the report and open a new form, the tool bar across the bottom, seems to work fine until I press the 'FIND' button. The system locks up without any recovery except to restart the computer. I am have a windows 98 OS with 128 meg Ram. Question: How do I clear the report form from memory? I have read all the help articles, including release, close all, etc. I am relatively new to vfp programming, so I am hopeful someone will give me the information I need. Any suggestions would be most appreciated.. Thanks Tag: ODBC vs. OLEDB Tag: 186002
  - 24
    - Automatic adaptation to different screenresolutions Hi all! I´m struggling with my code for automatic adaptation to different screenresolutions. Can someone give me a hint about what is wrong. An editbox does not keep its proportional placing when changing the screenresolution. I have made it simple for you, just copy and paste as below. Any help would be very appreciated. Regards Christina Give an empty form - two propertys (pyHeightratio and pyWidthratio) - a methode (mdResizecontrols) * COPY THE CODE BELOW INTO THE FORMS INIT: * the form itself this.Width = 400 this.height = 200 * the bottompageframe WITH This .addobject('bottomPgFr','pageframe') .bottomPgFr.top = 0 .bottomPgFr.height = this.height .bottomPgFr.width = this.width .bottomPgFr.pagecount = 2 ENDWITH * the toppageframe inside the bottompageframe´s page 1 WITH This.bottomPgFr.page1 .addobject('topPgFr','pageframe') .topPgFr.top = 0 .topPgFr.height = This.bottomPgFr.pageheight .topPgFr.width = This.bottomPgFr.width .topPgFr.pagecount = 2 ENDWITH * an editbox inside the toppageframe´s page 1 WITH This.bottomPgFr.page1.topPgFr .page1.addobject('edtNote','Editbox') .page1.edtNote.height = 70 .page1.edtNote.width = .Width/2 .page1.edtNote.left = .Width/2 .page1.edtNote.top = .pageheight - .page1.edtNote.height ENDWITH * make all added objects visible WITH This.bottomPgFr .visible = .T. .page1.topPgFr.visible = .T. .page1.topPgFr.page1.edtNote.visible = .T. ENDWITH * code for different screenresolutions (form designed in 800x600) this.pyHeightRatio = SYSMETRIC( 2 ) / 600 this.pyWidthRatio = SYSMETRIC( 1 ) / 800 this.height = this.height * this.pyHeightRatio this.width = this.width * this.pywidthRatio LOCAL loControl FOR EACH loControl IN Thisform.Controls Thisform.mdResizeControls(loControl) ENDFOR * COPY THE CODE BELOW INTO THE FORMS METHODE MDRESIZECONTROLS: LPARAMETERS toControl LOCAL loPage, loControl IF PEMSTATUS( toControl, 'Width', 5 ) toControl.Width = toControl.Width * Thisform.pyWidthRatio ENDIF IF PEMSTATUS( toControl, 'Height', 5 ) toControl.Height = toControl.Height * Thisform.pyHeightRatio ENDIF IF PEMSTATUS( toControl, 'Top', 5 ) toControl.Top = toControl.Top * Thisform.pyHeightRatio ENDIF IF PEMSTATUS( toControl, 'Left', 5 ) toControl.Left = toControl.Left * Thisform.pyHeightRatio ENDIF IF PEMSTATUS( toControl, 'Fontsize', 5 ) toControl.Fontsize = INT( toControl.FontSize * Thisform.pyWidthRatio ) ENDIF DO CASE CASE ALLTRIM(UPPER( toControl.BaseClass )) == 'PAGEFRAME' FOR EACH loPage IN toControl.Pages Thisform.mdResizeControls( loPage ) ENDFOR CASE ALLTRIM(UPPER( toControl.BaseClass )) == 'PAGE' FOR EACH loControl IN toControl.Controls Thisform.mdResizeControls( loControl ) ENDFOR ENDCASE ** PS ** Gregory I know you have solved this before but the solution is gone - a disccrash ** DS Tag: ODBC vs. OLEDB Tag: 186000
  - 25
    - pccharge VS icverify question Hi Everyone; I hope this question is OK for this newsgroup. Does anyone have any experience/comments about either pccharge or icverify SDK for credit card integration. We have a test client since March using PCCharge payment server integrated with their SDK. Integration was quite easy with their activeX control but every day the client gets one to two communication errors (not captured - connect failure). There old POS system was flawless for 10 years. We have tried everything under the sun but this seems to be a random error. Has anyone else experienced this with either PCCharge or ICVerify. I am thinking of switching to ICVerify but am hesitant to try another product. Any input would be appreciated TIA Mike Tag: ODBC vs. OLEDB Tag: 185998
- Next
  - 1
    - Kill the program Hi fellow coders: I want the program to quit completely if there is an error when the user clicks on save button at the time of the error. I have an on error routine that intercepts the error with error info. I know I can code error handling, however I want to program to be killed in the error rountine - no questions asked for now until I get the time to do the error handling for buffered table conflicts. I do issue a 'QUIT' in the error routine. When there is an error it does call the error routine, then it returns to the saves button on click method and continues with the program code and then quits. I want the program to be killed immediately in the error routine. How is this done or wher hav I gone wrong? Thanks in advance. I have an on error routine that is called etc... Tag: ODBC vs. OLEDB Tag: 185994
  - 2
    - Finding Memory Problems Hi all, I'm trying to clean up memory problems in a somewhat involved app and looking for ways of measuring the problems. Can anyone point to maybe a white paper on finding and addressing such things? So far I've just put statements in various areas of the code that write a record to a table indicating the current memory usage (as told by SYS(1016)) at that point. This seems to be a pretty ineffective--at least at diagnosing a technique that might cause the problem. For example, I found one interval that consistently increased in memory usage by around 2600 bytes most times it executed (a few thousand). Trying to recreate the problem in an isolated setting, I put together a small prg that just did those same steps in a loop. In this case, though, the memory change was 0. I've tried adding SYS(1104) in varying locations/timings in the program, but no change to speak of occurs in any case. I had some suspicion that printing was causing it but have found little to back this (at least not with SYS(1016)) and I am somewhat restricted in my driver options. Next up is tweaking memory w/ SYS(3050), but that still will only extend the time before running out of memory. Are there better ways of pinpointing where memory leaks occur w/in an app or are these pretty much all we have? Even like shell commands? TIA, John Tag: ODBC vs. OLEDB Tag: 185986
  - 3
    - Foxpro running under Windows 2000 Server Sp4 Users are not happy with the slow response they are getting from a new server install of Windows 2000 running FoxPro 2.5, 2.6 and FoxPro for windows. The system was running on a Windows 3.51 server that was upgraded to 4.0 and now, the server need to be retired and the application needs to run under windows 2000 any help on performance increase would be great. Tag: ODBC vs. OLEDB Tag: 185982
  - 4
    - VFP80 - Header Backcolor Can anybody tell me why these commands are not working? All I am trying to do is change the backcolor of the grid headers. Thank you in advance. THISFORM.grdAccounts.Column1.Header1.BackColor = 255 THISFORM.grdAccounts.Column2.Header1.BackColor = 65535 THISFORM.grdAccounts.Column3.Header1.BackColor = 32768 Tag: ODBC vs. OLEDB Tag: 185971
  - 5
    - vfp 8.0 menu error i have a Visual FoxPro 8.0 app that works perfectly on computer 1. i copied the source code to a second pc and now I am getting errors like this "procedure _2b231j80 not found" when clicking on menu choices. searching for this procedure i found it in the menu files. so i copied over new versions of the menu files - mnx, mpr, etc - recompiled everything and it worked fine for a bit. but now the errors have started again. help! nancy Tag: ODBC vs. OLEDB Tag: 185968
  - 6
    - Authentication Hi, i would like to know if it is possible to implement ,with a foxpro application, a authentication against: windows nt/2000 or openldap server or novell nds if im on the wrong list please excuse me and do point me to the correct list, thanks in advance sake. Tag: ODBC vs. OLEDB Tag: 185965
  - 7
    - CLOSE DATABASE I HAD USE THE DATABASE, AND THEN USE 'CLOSE DATABASE " TO CLOSE IT. HOWEVER, THERE IS STILL AN ERROR SAID 'FILE IN USE' I NEED TO QUIT THE EXE FILE, AND THEN RUN IT AGAIN . PLESASE HELP. -- Thanks For Your kind Attention. Best Regards, Miss. Agnes Cheng Dynamic Tech Consultants Ltd. Tag: ODBC vs. OLEDB Tag: 185952
  - 8
    - class icon not appearing I have specified a toolbar icon and a container icon on my class but it is not showing in the project manager. Any ideas ? Tag: ODBC vs. OLEDB Tag: 185949
  - 9
    - cursortoxml() and chr(13) in memos Hullo, I have a table with a memo field that contains, amongst other things, occurances of chr(10) and chr(13) . If I convert this to an XML string using CursorToXML() and then convert it back to a table using XMLToCursor() then all occurances of chr(13) are stripped from the memo. I've used the various flag settings for the two functions but the chr(13)'s are always stripped. How can I keep the carriage returns? Thanks in advance. Yours faithfully Paul S. Elliott (Senior Developer) 4technology Ltd P.O. Box 1681 Christchurch New Zealand ph : +64 3 3771170 fax : +64 3 3771172 Tag: ODBC vs. OLEDB Tag: 185948
  - 10
    - Suppressing PDF Writer screen output VFP 6 SP5 on WinXP Pro I do some PDF production in one of my VFP apps. I have no problems getting the app to use the PDF Writer printer without involving the user (using the registry setting trick). One of my routines customizes a Word file via OLE automation, then prints the result to a PDF. I'd like to suppress the little dialog that pops up while it is printing this Word doc. The one that says "Printing" at the top and shows a count of the pages being printed. I use the Windows LockWindowUpdate API call at other times to hide UI changes, but this does not work in this case. I assume this is because Word is the application originating the PDF Writer activity. Does anyone know of another way to suppress this little dialog in a situation like this? -- TRW _______________________________________ My e-mail: t r w 7 @ i x . n e t c o m . c o m _______________________________________ Tag: ODBC vs. OLEDB Tag: 185940
  - 11
    - OT: Creating a .lnk file Hi all, Sorry, this is tangentally VFP related at best. I'm trying to figure out how to programatically drop a shortcut to a vfp executable into the startup programs. The format of such a file seems to escape me, but looks more like a table header than a text file. Has anyone done this? TIA, John Tag: ODBC vs. OLEDB Tag: 185937
  - 12
    - INSERT during transaction - trigger failed This used to work, so I'm not sure what I did to screw it up (might have something to do with my SET EXCLUSIVE setting), but here's what's happening: I have two tables: USERS and USERPROMOS. The primary key of USERS, userid, is also a foreign key in USERPROMOS. The relational integrity procedures are set to stop inserts into UP without a corresponding userid in U. When I get a batch of records to import in, I get the record from my input file using a SCATTER NAME, INSERT the record into U, then go to UP and insert a record there, too, referencing Users->Userid as the userid for the new record in UP. Like so: SELECT _INCOMING BEGIN TRANSACTION ON ERROR DO "Err_CannotAddRec" DO WHILE !EOF() SCATTER NAME oRec WITH oRec * Add record to USERS INSERT INTO Users (...a bunch of fields...); VALUES (...a bunch of values...) * Add record to UserPromos INSERT INTO UserPromos (userid, initcontact) ; VALUES (Users->UserID, DATE()) ENDWITH oRec = NULL SKIP ENDDO END TRANSACTION The problem I'm having right now is that the second INSERT is failing in the INSERT trigger. It goes and opens up the USERS table in a new workarea and SEEKs the userid to verify it's there. For some reason, though, it's NOT there. If I go over and look at the USERS workarea, it IS there, but it doesn't come into the area where the RI procedure opened it up using USE USERS AGAIN. I'm thinking it's my transaction. If I go and do an END TRANSACTION when the program stops at the second insert, then retry that insert, it works because the new instance of USERS actually does find the new userid. Problem is, I'm not willing to dispense with the transaction in my code. I can't risk something screwing up during the import because a partial import would be real problematic. Could I solve this with some kind of buffering change, or anything like that? Another idea I had was to separate the two inserts into two separate loops, with a TRANS surrounding each of the loops. That's a pain, though, thanks to having to locate the new userid's. TIA for any help. -- Michael Kellogg CC3 West DP Programming Running VFP 6-SP4 Tag: ODBC vs. OLEDB Tag: 185934
  - 13
    - FORMS FREEZE UP When I run my applicatioon and preview a report, which works fine (and I shut it down), when I open another form in my application, the toolbar features all work except the 'FIND' button. When I press this button, my system freezes up.. I am running vfp 6.0 on a windows 98 OS with 128 meg of ram. I am relatively new to vfp, but any assistance would be greatly appreciated. I have read all the help screeens that I believe will solve my challenge, but I still need help. Suggestions ? Thanks Tag: ODBC vs. OLEDB Tag: 185931
  - 14
    - Migrating from FoxPro 2.6 to FoxPro 8.0 We have an old FoxPro 2.6 app which runs on Win 95/98/ME printing to a CITOH 5000 impact printer using a TTY driver. These machines are to be replaced with WinXP which seems to have dropped support for TTY. When we use the native Windows driver some rows are shifted to the right by a few characters. Is doing a migration to VFP 8 the best solution to this issue? I have access to the source and my first attempt ended with an error: Fatal Error in Converter: Error: Alias name is already in use. Error Number: 24 Method: openfile Offending Code: USE ... File being processed: basw110.scx I'm quite familiar with other IDE's (VB, PowerBuilder, .NET) and databases (SQL Server, Oracle, Access) but haven't used FoxPro before. Program functionality hasn't changed in years so we're not looking to do any coding changes. -- Neil Negandhi negandhi@vex.net Tag: ODBC vs. OLEDB Tag: 185929
  - 15
    - Pull down menu question How do I change disabled menu items in the pull down menus. Thanks in advance Tag: ODBC vs. OLEDB Tag: 185928
  - 16
    - How to refresh a remote view I've setup a remote view to a MySQL database. It refreshes fine if I reopen the database, but how do I force a refresh when the database is open? Using VFP7. Thanks for any help, Neil Tag: ODBC vs. OLEDB Tag: 185927
  - 17
    - A fox in the bookstore !!! Nop, couldn't find one :-( Last night I went to the bookstore and there was not a single copy of a = fox related book I remember the times when there were two or three at the most, good ol' = times. Plenty of python, ruby, php and other not-so-known languages are now = filling the shelves. The fox is dead, long live the fox! Tag: ODBC vs. OLEDB Tag: 185912
  - 18
    - Suppress Fatal Error dialog box in Visual Foxpro 8 In a compiled VFP8 program I have experienced a fatal error. I'm less concerned about the error than in the user prompt. I want the application to close without throwing up a prompt. I believe this behaviour started in VFP version 7 or 8. Is there an environment setting that can be set to modify this. The exact error message is Fatal error: Exception code=C0000005 @ 11/21/2003 02:19:40 PM. Error log file: E:\Omreport\VFP8Rerr.log Called from - companionsproc line 871 {E:\Omreport\omreport.prg e:\omreport\omreport.exe} Called from - omreport line 30 {E:\Omreport\omreport.prg e:\omreport\omreport.exe} The offending line is: if sqlexec(cadhandle, m.cirssql, "compcirs") < 1 A connection was made and then a network outage occurred which caused the error during the SQLEXEC. ----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse@newsone.net Tag: ODBC vs. OLEDB Tag: 185911
  - 19
    - header file I have several forms that I invoke using programs similar to this: #include "c:\business\mess.h" helpeditor = SYS(2015) PUBLIC &helpeditor &helpeditor = CREATEOBJECT("helpform") tmp = &helpeditor tmp.SHOW return DEFINE CLASS helpform AS helpfrm All class definitions have their include file set to "c:business\mess.h". There are a few constants in mess.h that define paths to tables. Unfortunately, if I change these pats to point to dummy tables and recompile, the program ignores the changes and still uses the real tables. If I instead, 'touch' the program file and recompile, it works. Despite that it appears to be recompiling all files, the compiler seems to be ignoring changes in mess.h. Any suggestions? Tag: ODBC vs. OLEDB Tag: 185910
  - 20
    - retrieve file compiled in exe ? Hi, I have some default_ini_files (.ini) that I include in myproject. but the user can override these default values with his own one so first on startup I want to copy those default_ini_file to there local drive if that file doesn't exist and then collect the values. So how can I copy those files that are included in the exe to the same place as the exe. christophe ¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º Tag: ODBC vs. OLEDB Tag: 185906
  - 21
    - App - SQL Server and Native Hello. We have the app written entirely or SQL Svr using Cursor Adapters. Now some clients require also the version running on native DBFs. What's the best possible scenario - should we try to go to native DBF commands and rewrite the app or just stick to ADO and use also DBFs through ADO. M.Kujawa Tag: ODBC vs. OLEDB Tag: 185897
  - 22
    - How : [select tables name from database ] Does anyone know to do that ?? -- Thanks For Your kind Attention. Best Regards, Miss. Agnes Cheng Tag: ODBC vs. OLEDB Tag: 185860
  - 23
    - Index tag not found error VFP 7 I have a form with several databases being loaded and I am getting the following error... Index Tag Not Found Error 1683 form.dataenviornment.opentables Line 0 How can I determine what table is causing this error? Your help is much appreciated. Tag: ODBC vs. OLEDB Tag: 185845
  - 24
    - Images in reports Hi I'm having a problem with a report that has an image field (VFP6) On my system (xp pro) the report will show both jpg's and bmp's On a number of my clients pc's, some can print the bmp's and some can print the jpg's Where it does not print, the image control simply shows a standard icon and the name of the image I cannot see anything in help or ms kb that deals with this Any help appreciated John Davy Tag: ODBC vs. OLEDB Tag: 185844
  - 25
    - Adding system menu window to custom menu I have an application that enables a user to open the same form or different forms simultaneously. It would be nice to allow the user to see the open windows that are available. How do I add the system 'Window" menu function "_MSM_WINDO" ? or "_MSM_WINDO" ? to my custom menu. Tag: ODBC vs. OLEDB Tag: 185842

I have posted a comment before stating a problem I was having with VB and
updatebatch method and getting the error "Row Cannot Be Located for
Updating...." I have found that if I use an Update SQL statement instead
though it works fine (to do this though would be a hell of alot of extra
programming). It also used to work before and I think it was the change
from VFP 6 to VFP 7 that brought the error. Anyway, what I'm wondering is,
the VB code uses a DSN ODBC connection to VFP. I'm wondering if I use the
OLEDB connection, would this make any difference? I am also wondering what
the difference between ODBC and OLEDB is. Also I'm wondering if maybe
moving to VFP 8 would fix this problem.

Top

Re: ODBC vs. OLEDB by Carsten

Carsten
Mon Dec 01 02:18:18 CST 2003

Altman,

OLE DB is supposed to replace ODBC, so sometime you will have to switch to
OLE DB.
VFP8 has CursorAdaptors, which handles all the "complicated" stuff like
updating records. They are a huge improvement, and absolutely worth taking a
look at.

Cheers
Carsten

"Altman" <NotGiven@SickOfSpam.com> schrieb im Newsbeitrag
news:uxWMZCctDHA.2440@TK2MSFTNGP12.phx.gbl...
> I have posted a comment before stating a problem I was having with VB and
> updatebatch method and getting the error "Row Cannot Be Located for
> Updating...." I have found that if I use an Update SQL statement instead
> though it works fine (to do this though would be a hell of alot of extra
> programming). It also used to work before and I think it was the change
> from VFP 6 to VFP 7 that brought the error. Anyway, what I'm wondering
is,
> the VB code uses a DSN ODBC connection to VFP. I'm wondering if I use the
> OLEDB connection, would this make any difference? I am also wondering
what
> the difference between ODBC and OLEDB is. Also I'm wondering if maybe
> moving to VFP 8 would fix this problem.
>
>

Top