ADO CursorAdapters - only first is loaded

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
    - Display preceding + on numeric data in browse I want to browse some data with quantity variances. I want to show + in front of positive numbers, I'd hoped there was a format code to do that but can't find one. Next I converted the data to character and added a leading + or - and tried browsing with a picture clause but unfortunately CREATE CURSOR test (test C(10)) INSERT INTO test (test) VALUES ('+123') INSERT INTO test (test) VALUES ('+99347') INSERT INTO test (test) VALUES ('-3 BROWSE FIELDS test :P='@J' does exactly what it says - right justifies (*not* right alignment.) Fixed pitch font is obviously better but still isn't correct, the data is not up against the right hand edge of the cell like numeric data would be. Is there any way to do this? -- TIA Andrew Howell Tag: ADO CursorAdapters - only first is loaded Tag: 220776
  - 2
    - Error running _reportoutput in VFP9 SP1 Hi, When I run the following in VFP9 SP1 LOCAL loListener loListener=.NULL. DO (_REPORTOUTPUT) WITH 5, loListener VFP generates the following error message:- HTML Listener File does not exist htmllistener Error: 1 Method: applyusertransformatoutput I'm sure this worked in SP0 - I encounter the error in development and also at a standalone site with the SP1 files installed. _reportoutput contains the path to reportoutput.app dated 4 Nov 05 and I get the same error if I run reportoutput.app Any ideas would be appreciated. John Pugh Adelaide, South Australia Tag: ADO CursorAdapters - only first is loaded Tag: 220767
  - 3
    - Round the time Hi Is there a way to round the time? Actually I want to trim the seconds rounding properly the time. Is there a function or should I make one? 10/2/2006 6:50:15 --> 10/2/2006 6:50:00 or 10/2/2006 6:50 10/2/2006 6:50:49 --> 10/2/2006 6:51:00 or 10/2/2006 6:51 Demetrios, Greece Tag: ADO CursorAdapters - only first is loaded Tag: 220764
  - 4
    - VFP9: Sending / receivig across the internet (transaction handling) This is a multi-part message in MIME format. ------=_NextPart_000_0022_01C62DB5.C58E84E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I'm looking for the simplest solution for sending and receiving data to = the "same" application, but in separate geographical locations. A record(s) is created and needs to be sent across the internet to the = same application running on another machine. What is simplest method = for sending the record, then appending to a master table at the = receiving end? =20 Next, an acknowledgement record is created and returned to the original = sender. It then needs to be appended to the activity table on the = originating machine. Suggestions please... John ------=_NextPart_000_0022_01C62DB5.C58E84E0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.2802" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2>Hello,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I'm looking for the=20 <STRONG><U>simplest</U></STRONG> solution for sending and receiving data = to the=20 "same" application, but in separate geographical locations.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>A record(s) is created and needs to be = sent across=20 the internet to the same application running on another machine.  = What is=20 simplest method for sending the record, then appending to a master = table at=20 the receiving end?  </FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Next, an acknowledgement record is = created and=20 returned to the original sender.  It then needs to be appended = to the=20 activity table on the originating machine.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Suggestions please...</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>John</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML> ------=_NextPart_000_0022_01C62DB5.C58E84E0-- Tag: ADO CursorAdapters - only first is loaded Tag: 220762
  - 5
    - multitheared dll and reports Is it possible to run the REPORT FORM comand in a multi threaded dll? I get Feature not Available. It runs fine in a single threaded dll or an exe. The help indicates only the CREATE REPORT command is not supported in dll's. I have tried with reportbehaviour=90 but doesn't help I have found i can initiate a exe with createobject from the dll and run reports from here - would this effect the call blocking in a multi threadedx dll? Any help appreciated thanks Greg Tag: ADO CursorAdapters - only first is loaded Tag: 220761
  - 6
    - Looking for VFP programmer in Upstate NY I am a relatively new VFP programmer, but despite this have managed to make a few dollars by developing an application for a client in the Albany, NY area. The client has undergone significant growth at their single location, and now has outgrown my ability to serve them. This is compounded by my pending recall to military service for a tour in the Middle East for several months. I am looking for a VFP programmer near the Capitol District of Upstate NY who would like to have this client. Per my agreement, the client owns the source code for this very customized VFP 7.0 application, so negotiations to provide service will be made directly with the client. A confidentiality agreement with the client should be expected. If you or someone you know could be interested, please contact me ASAP, as I leave for military service in a very short time. Bill deVries wdevries@nycap.rr.com Tag: ADO CursorAdapters - only first is loaded Tag: 220754
  - 7
    - VFP 9 to Specific Page in Adobe Acrobat File I can easily bring up an Adobe Acrobat file from my VFP 9 program by saying RUN /N3 &cAcrobat &cAdobeFileRec Where cAcrobat is the path and filename of the executable for Acrobat, and cAdobeFileRec is the file to open. Is it possible to open the file and go to a specific page number? Big Thanks. Tag: ADO CursorAdapters - only first is loaded Tag: 220750
  - 8
    - Problems installing VFP8 - SOAP toolkit won't install. Running Win2k, and I "think" all updates are loaded. I'm going to check that now just in case. However, I've installed this on one pc in the past, and am now trying to install on another and it needs the prerequisites loaded. I tell the installer to go ahead and load, and it errors on the SOAP Toolkit. I'm able to install by using the setup.exe /no_dhsl_check option(I think I have that typed right here) and VFP installs, but I'm unable to edit any .prg files. It says they're read only, which they shouldn't be. Is this because of the SOAP problem? What is the SOAP toolkit anyway? And, any ideas why it's not loading properly? Thanks!! Tag: ADO CursorAdapters - only first is loaded Tag: 220747
  - 9
    - CursorAdapter - cursorgetprop("KeyFieldList") ? Hello, Can anyone tell me why cursorgetprop("KeyFieldList") is not returning the primary key field of my cursoradapter? When referencing the cursoradapter object in code, the field name is there. E.g. thisform.dataenvironment.cursoradapter1.keyfieldlist Tag: ADO CursorAdapters - only first is loaded Tag: 220744
  - 10
    - Update any users Exchange (2003) Calendar from FoxPro 8 Hi Does anyone have any information or guidance on this issue ... I have a multi user FoxPro 8 system and want to use FoxPro 8 to put calendar entries into the Exchange (2003) Calendar, maybe through Outlook but that does not have to be the case (CDO?). I want to be able to do this for any user in the Exchange i.e. not just the current users calendar. I have a list of user names in FoxPro which can be cross matched to Exchange Server user/email names (with an extra field in the table). But I am unsure how to reference the calendar and thus put an entry into it. Note this is not a users local pst file. Any help or pointers to documents/code/help would be appreciated Thanks John R. Tag: ADO CursorAdapters - only first is loaded Tag: 220739
  - 11
    - Including report forms in exe I have a VFP (9.0) exe that contains a lot of report forms. Even when I include the report forms in the reports section of the project I get a message 'File not found' when you run the exe. I even included specific pathing for the call REPORT FORM (gcPath + "reportname") to print noconsole and I still get the error. If the report forms are placed in the directory with the exe they work ok. Is there something special that needs to be done to make this work correctly. I don't want all of these frx's sitting in the exe directory. Jim Czebiniak Tag: ADO CursorAdapters - only first is loaded Tag: 220735
  - 12
    - Visual Persistence with grid Is there a way to have the last selected cell have visual persistence when using the grid? You can have visual persistence for the last row that was selected, but I can't figure out a way to highlight the last cell that was selected. I have an application where I have a grid and a listbox. When someone clicks on certain cells in the grid, it fills the listbox. But if they click on an item in the listbox, I want the last grid cell to be highlighted to give a visual check on what the listbox data is. I thought maybe something in VALID, but nothing has worked. Kevin Clark Seton Home Study School Tag: ADO CursorAdapters - only first is loaded Tag: 220732
  - 13
    - How to do this: MyForm.sc* -> MyForm.vc* ? Hello! Is there any simple method to transform existing form into a reusable class embedded in the VC* file choosen by me? Greetings! -- --< pps >-- Tag: ADO CursorAdapters - only first is loaded Tag: 220728
  - 14
    - how to pass bulk array content to Excel cells ? In C# can pass this.xlApp.Cells[ nRow, nCol ] = array, how to pass array values in VFP ? Currently i loop through the array element and pass array value one by one into excel cell. Thanks Tag: ADO CursorAdapters - only first is loaded Tag: 220720
  - 15
    - String too long error Hello, There is a Editbox that contains a Memo field. In the Fox 6 version you could type a few lines of text and you can have it print on a report. In the Fox 9 version however I get the error message String is too long to fit when I try to print it. Is there a way to specify a character limit in a memo field? Or any other way to tackle this problem? Maybe at the report level? Tag: ADO CursorAdapters - only first is loaded Tag: 220712
  - 16
    - Resource file version mismatch Hi Group... My Executables of VFP show this error once I try to run them... a Messagebox with title "Error" "Resource file version mismatch " Then another messagebox title Microsoft Visual FoxPro "Visual Foxpro cannot start. Could not load resoures." I've already tried removing and renaming foxuser.dbf but the problem persisits. VFP Versions: 8SP5 and 9SP1 OS: Windows XP Professional Processor: Pentium 4 HT Extras: New LapTop Do you have an idea what is going on? Any Comment is greatly welcome. Thanks in advance =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= L.Ortega El Paso Texas =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Tag: ADO CursorAdapters - only first is loaded Tag: 220710
  - 17
    - MsChart Control 6.0 question Hi; would someone be able to tell me what I am doing wrong. I would like to use the MsChart control (not graph wizard) to create a few charts through either tables or arrays. Their is a sample in the help file which gives me a clue. Once I figure it out, I can go more complex. The following code works and gives a horizontal line at points 10, 20, 30: thisform.olecontrol1.ChartType = 3 thisform.olecontrol1.ColumnCount = 1 thisform.olecontrol1.RowCount = 3 thisform.olecontrol1.column = 1 thisform.olecontrol1.row = 1 thisform.olecontrol1.Data = 10 thisform.olecontrol1.column = 1 thisform.olecontrol1.row = 2 thisform.olecontrol1.Data = 20 thisform.olecontrol1.column = 1 thisform.olecontrol1.row = 3 thisform.olecontrol1.Data = 30 The following (using an array) gives 3 points at about 2, 72, & 52. Could someone please let me know what is wrong and where I could find some GOOD examples. Thanks. PUBLIC chartarray(3,1) chartarray(1) = 10 chartarray(2) = 20 chartarray(3) = 30 thisform.olecontrol1.ChartType = 3 thisform.olecontrol1.ColumnCount = 1 thisform.olecontrol1.RowCount = 3 thisform.olecontrol1.dataMember = chartarray TIA. Mike. Tag: ADO CursorAdapters - only first is loaded Tag: 220709
  - 18
    - APPEND FROM does not work as Import wizard I am trying to import a text file with the following sintax: APPEND FROM file.txt DELIMITED WITH CHARACTER | I have VFP with SYSFORMATS ON, witch is the same configuration of the txt file (point=',' and separator='.'). When I append the file with this command, he imports the numbers greater the 999 wrong, as they have a dot(.) as group digit. For example, the number 12.498 will be imported as 12 (small number like 653 is imported as 653). With this command it imports de decimal fields correctly, for example, 0,9 is imported as 0,9 correctly. When I use the import wizard for text files, it now imports the thousands correctly but loses the decimal numbers, for the example above, we would see something like this: filed 1:12.498; field 2:653; field 3:0,0. Can anyone help me? I would like to do it programatically, since i will have to import several files several times. Thanks, Guga -- gmendes ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------ Tag: ADO CursorAdapters - only first is loaded Tag: 220700
  - 19
    - Writting an application to learn chinese in VFP Hello: I use VFP7 SP1 and am writing an application which must read chinese traditional and simplified texts using TTS. I'd done this in english and spanish using Ms Agent. Now in chinese I dont know how to do it. I dont know TTS chinese engines as microsoft offers. Does some one can help me? With best regards. Alejandro Fernandez Tag: ADO CursorAdapters - only first is loaded Tag: 220693
  - 20
    - Consume SOAP Web Service Without SOAP Toolkit I understand that the soap toolkit 3.0 is depreciated and all future development should use the .net framework... How would I do something like the following from a fox pro consumer using the .net framework only and not the soap toolkit 3.0 or the psuedo soap 3 tool kit integrated into the current release of fox pro? objws=CREATEOBJECT('mssoap.soapclient30') objws.MSSoapInit('http://localhost/SomeWs/myWs.wsdl') objReturnVal=objws.WebMethod1('DummyOne','DummyTwo', 'Value',"'Value','Value'") ?objReturnVal Tag: ADO CursorAdapters - only first is loaded Tag: 220689
  - 21
    - ThumbCtl ActiveX Control I'd like to use the thunbnail viewer that comes with XP to view a group of images based on a certain criteria in my distibuted app. I've added the control to my form but need to know what parameters, methods/events and what syntax to use to get the results I want. Anyone have an example of it's use? Thanks so much for your time and help. Tag: ADO CursorAdapters - only first is loaded Tag: 220688
  - 22
    - Simple change to FFC resize object To use the FFC Resize class, you simply add the class to your form, and call the 'adjustcontrols' method of the Resize object in the form's "Resize" event. Seems to work well. How about the alternative: Add the following code to the Init of the Resize class: -------------------- DODEFAULT() BINDEVENT(thisform, "Resize", this, "adjustcontrols", 1) --------------------- Seems to work just fine. Any reason not to do it this way other than 'inverse coupling' the object to the form, instead of the form to the object. Tag: ADO CursorAdapters - only first is loaded Tag: 220685
  - 23
    - Centering label in a form In VFP6. I have a label in a form and I change the caption and font after an action. Is there any way to center the revised caption, similar to the autocenter property of a form ? There does not seem to be a similar property for a label. -- Tim Hobson Tag: ADO CursorAdapters - only first is loaded Tag: 220680
  - 24
    - Re: ERROR Creating OLE Object Ooooooooops! I forgot to specify that I'm working with FPW 2.6 Sorry. "shmiel" <shmiel@tiscali.co.uk> wrote in message news:... >I have the following line in my program which worked fine for many years >until recently. > > APPEND GENERAL PICTURE FROM <Name of Bitmap File eg "9999.BMP"> > > Now I get the the following message "Error creating OLE object" > > I have tried this interactively with a new table and get the same result. > > Please HELP!!! > > Thank you. > Tag: ADO CursorAdapters - only first is loaded Tag: 220679
  - 25
    - ERROR Creating OLE Object I have the following line in my program which worked fine for many years until recently. APPEND GENERAL PICTURE FROM <Name of Bitmap File eg "9999.BMP"> Now I get the the following message "Error creating OLE object" I have tried this interactively with a new table and get the same result. Please HELP!!! Thank you. Tag: ADO CursorAdapters - only first is loaded Tag: 220678
- Next
  - 1
    - Validating a Date in a Text box hi again, i am looking for a simple way to Validate the data entered into a textbox is a valid date. if they enter 010106 it should stop them and make them enter 01012006 if they enter 01010000 it should evaluate that to be wrong also. is this possible? well i know it is, currently i have set century on. My biggest problem is, this box is used for mostly char entry, so id like to keep it that way. i thought that using this.value = ctod(' / / ') would do it but no such luck. thanks agaiin. Tag: ADO CursorAdapters - only first is loaded Tag: 220676
  - 2
    - Doug Henning at Chicago FUDG on 14 Feb 06 The February Chicago FUDG Meeting will be a Webinar on Stonefield Query. Doug Hennig is the author of Stonefield Query and of the Stonefield Database Toolkit and a guru of gurus. Doug wrote the Cursor Adaptor builder that is in VFP 9. Check out his site at <http://www.stonefield.com> Or attend the February 14th Foxpro Users and Developers Group meeting. Doug says it's not cold enough in Chicago in February. He'd rather stay home in Winnepeg Saskatchewan. Instead he'll be available via streaming video and Skype phone at our meeting. Here is more on the new release of Doug's Stonefield Query which will be discussed in detail at our meeting: The Report Wizard has been replaced with a more powerful and user-friendly Reports Explorer. Role-based security is available for report folders, individual reports, fields, and tables. The Advanced Report Designer was overhauled and includes a new _Expression Builder. Creating a setup executable is now a snap with the built-in setup generation tool. http://www.stonefieldquery.com/devedfeatures.html This is our first meeting where we bring in a guy from another part of the globe without paying the air fare. Let's see if webinars are the shape of things to come. Same time and place. See you there? Tuesday Feb 14th, 5:30 pm. Room 826 in the Monadnock Building in the Chicago Loop. 53 W. Jackson Boulevard. http://www.ChicagoFUDG.com -- Message posted via http://www.dbmonster.com Tag: ADO CursorAdapters - only first is loaded Tag: 220672
  - 3
    - [OT] User-Defined string Functions Transact-SQL <-> VFP Ladies and Gentlemen, I am pleased to offer, free of charge, the following string functions Transact-SQL: AT(): Returns the beginning numeric position of the nth occurrence of a character expression within another character expression, counting from the leftmost character. RAT(): Returns the numeric position of the last (rightmost) occurrence of a character string within another character string. OCCURS(): Returns the number of times a character expression occurs within another character expression (including overlaps). OCCURS2(): Returns the number of times a character expression occurs within another character expression (excluding overlaps). PADL(): Returns a string from an expression, padded with spaces or characters to a specified length on the left side. PADR(): Returns a string from an expression, padded with spaces or characters to a specified length on the right side. PADC(): Returns a string from an expression, padded with spaces or characters to a specified length on the both sides. CHRTRAN(): Replaces each character in a character expression that matches a character in a second character expression with the corresponding character in a third character expression. STRTRAN(): Searches a character expression for occurrences of a second character expression, and then replaces each occurrence with a third character expression. Unlike a built-in function Replace, STRTRAN has three additional parameters. STRFILTER(): Removes all characters from a string except those specified. GETWORDCOUNT(): Counts the words in a string. GETWORDNUM(): Returns a specified word from a string. GETALLWORDS(): Inserts the words from a string into the table. PROPER(): Returns from a character expression a string capitalized as appropriate for proper names. RCHARINDEX(): Similar to the Transact-SQL function Charindex, with a Right search. ARABTOROMAN(): Returns the character Roman numeral equivalent of a specified numeric expression (from 1 to 3999). ROMANTOARAB(): Returns the number equivalent of a specified character Roman numeral expression (from I to MMMCMXCIX). AT, PADL, PADR, CHRTRAN, PROPER: Similar to the Oracle functions PL/SQL INSTR, LPAD, RPAD, TRANSLATE, INITCAP. Plus, there are CHM files in English, French, Spanish, German and Russian. Plus, there are versions for SYBASE ASA, DB2, Oracle, MS SQL SERVER 2005 SQLCLR. More than 8000 people have already downloaded my functions. I hope you will find them useful as well. For more information about string UDFs Transact-SQL please visit the http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,27115 Please, download the file http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,2,27115 With the best regards. Tag: ADO CursorAdapters - only first is loaded Tag: 220668
  - 4
    - Licensing Folks, A prime advantage of Fox has always been its licensing policy. Once you purchased the original development edition you could produce applications which would run free of any extra charges (royalty free). My impression is that this has changed in the more recent versions. I haven't been able to find the information on the official MS site. Is my summary of VFP licensing correct? Are there changes? If so, what are the new restrictions? There is a good chance this discussion has transpired more than once. If so it would be nice to have a pointer to where I can find those threads or web pages. Appreciatively, John Tag: ADO CursorAdapters - only first is loaded Tag: 220666
  - 5
    - Character translation In order to be able to send Japanese mails from my VFP application, I need to translate a Japenese string encoded as SHIFT-JIS to ISO-2022-JP. I found this library iconv.dll that should be able to do that but I can't get it do anything in VFP. Does anybody have experience with this? Robert Tag: ADO CursorAdapters - only first is loaded Tag: 220663
  - 6
    - timer and report with >1 page I have a timer working in the background, which is checking for new messages in table1 -every 30 minutes. If at the same time somebody preview a report with more than 1 page and is trying to change page - report preview is disappearing....:-( I know it's because timer is changing current cursor (reports are used public dataenvironment), so i try to disable timer before report shows and enable after - works OK , but in this case if user will open any report in <30 min will never get messages prepared by timer... Is there a way to store curent "time to fire" of timer so it could start not from 0 ? Or maybe somebody have better idea how to get rid of this report behavior ? (I don't want to change it to use private dataenvironment) Thanks, Adam Tag: ADO CursorAdapters - only first is loaded Tag: 220652
  - 7
    - How to determine if a DLL exists or is installed Hi, Is there a way to determine if a DLL exists or is installed? Most reside in Windows\System32 but some others are installed on WINDOWS\WinSxS subdirectories. Thanks. Demetrios, Greece Tag: ADO CursorAdapters - only first is loaded Tag: 220651
  - 8
    - February letter posted on the Fox website http://msdn.microsoft.com/vfoxpro/letters/ -- Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP cindy_winegarden@msn.com www.cindywinegarden.com Tag: ADO CursorAdapters - only first is loaded Tag: 220644
  - 9
    - Can't preview 2 reports at the same time? I know report previewing has always been flaky with VFP, especially in the IDE, but I just noticed that with VFP9 you still can't preview 2 reports at the same time if you try to use right mouse to preview them. After spending a bit of time with this, it appears to be a continuation of the mouse right click crash bug. Open table. Create 2 reports that run against table. Open both reports in report editor. Right click a report, select preview. Right click other report, Menu manager internal consistency error occurs. Faulting application vfp9.exe, version 9.0.0.3504, stamp 436c14ff, faulting module vfp9.exe, version 9.0.0.3504, stamp 436c14ff, debug? 0, fault address 0x0021ab95 Happens with VFP9, VFP8, VFP7. Tag: ADO CursorAdapters - only first is loaded Tag: 220642
  - 10
    - Field display on report question? Hi, Using VFP 9.0. I'm designing a simple report for one of my tables and I'm seeing something that seems odd to me. The field expression is: alltrim(lname) + ", " + alltrim(fname) So I should get 'lname, fname' on my report. It seems to be working except where fname is null, then I just get .NULL. on my report. I would have thought that if it were null then I'd just get 'lname, ' out on my report but instead I only get .NULL.. Can anyone shed some light here? Thanks, Linn Tag: ADO CursorAdapters - only first is loaded Tag: 220638
  - 11
    - Transforming a number if i wanted to show on a frinted for the last 4 digits of an account nuber or a ssno number or any number, what is the best way to do this. Transform does not seem to be the correct function. Tag: ADO CursorAdapters - only first is loaded Tag: 220633
  - 12
    - problems with installshield in 9.0 I am attempting to install build an install exe for vfp 9.0 runtime. When I run the exe on a machine that does not have 9.0 dev installed it chokes with the message "Visual Foxpro could not start. Could not load resources": I looked through postings here and found several suggestions and solutions that worked for others, such as 1. don't forget the vfp9r.dll 2. include the c## libraries 3. just copy the runtime dll into the exe directory and that is all you need. 4. be sure to register the dll 5. don't register the dll. At this point I am confused. I have tried all of the above and still it doesn't work. I have manually registered the dll and that didn't help. Is this an XP issue??? I have used the installshield with 7.0 distributions with no problems. Which c## libraries should I be including? Which boxes should be checked in the redistibutables section?? help??? Tag: ADO CursorAdapters - only first is loaded Tag: 220621
  - 13
    - Dialog error message What would cause the following message to appear when a user is running an application I've written? I've not had it with other users running it. The user has an AMD processor with 523,000 KB mem running Windows2000 Professional. Error message: "Unable to open dialog" They then click on OK and continue with the program and all appears to work fine. It seems to have no consistent time it does it. Rusty OGES Systems Tag: ADO CursorAdapters - only first is loaded Tag: 220618
  - 14
    - FPD and VFP 9 running on Vista - Proof of Concept. http://blog.jlcconsulting.com/PermaLink,guid,a4c0d684-e0bb-4338-b7c5-5409474 79f72.aspx Whew! I'm glad Juan's shown it to work - I had scheduled a pass/fail series of tests for later in the month. Mondo Cool! regards [Bill] -- =================== William Sanders / EFG VFP / mySql / MS-SQL www.efgroup.net/vfpwebhosting www.terrafox.net www.viasqlserver.net Tag: ADO CursorAdapters - only first is loaded Tag: 220615
  - 15
    - Read from text file I have a text file with e-mail addresses seperated by Return key (chr13). I need to import the e-mail addresses into a table. To do this, I created a table with one C(100) field and was able to execute: append from textfile.txt type SDF with VFP6.0. All data got imported ok. However, when I do the same command in VFP9.0, all e-mail address in the table displayed as a square box - unrecognized character. What did I do wrong? -jesk Tag: ADO CursorAdapters - only first is loaded Tag: 220612
  - 16
    - Attempting to Automate VSS 2005 w/ VFP9 I'm revisiting a problem that stumped me years ago. I'd like to automate the sharing of project files within the VFP IDE through VSS Automation, and everything's good to go except for the VSS "add file to source control" dialog - I'm hoping I might be able to use some of the new functionality VFP9 to get past this. Here are some options AFAIK: VSS's IVSSEventHandler interface - but would have to write a separate DLL. BindEvent() - to trap windows messages and perhaps get a reference to the dialog window. EventHandler() - but so far, I don't have a COM object to attach to. I think I need to get a reference to the dialog window's hWnd and do something like a SendKeys or a SendMessage, but the VSS automation doesn't seem to expose any objects I can grab a hold of.. Would appreciate all suggestions. Thanks. -- William Fields Code Contortionist MCSD - Microsoft Visual FoxPro US Bankruptcy Court Phoenix, AZ ".dll hell - .rpm hell - whatever. The grass is always greener" Tag: ADO CursorAdapters - only first is loaded Tag: 220611
  - 17
    - How to append a Word doc to a general field and display it as an icon I need to append a word document to a general field and display it as an icon and edit it in word when you double-click it. The default option when you use the command "Append General <generalfield> From <file>" is to display the file content and edit it inside the oleboundcontrol. The only way I found to do this, is to check the "Show as an icon" option of the "Insert Obeject..." menu in the Create from file tab. Is there a way to do the same but programatically with the "Append General" command ??? Thanks in Advance !!! Best Regards, Geo L. Tag: ADO CursorAdapters - only first is loaded Tag: 220606
  - 18
    - IDE annoyance In the Project Manager, Data tab, with Project Manager docked: Select a table in a db and double click on it. The Table Designer opens and operates normally. Close the Table designer, select a table again and press Enter. The Table Designer opens, but the window is not movable. </bitch> Tag: ADO CursorAdapters - only first is loaded Tag: 220596
  - 19
    - Even Trigger Library for Monitoring a Folder This is a multi-part message in MIME format. ------=_NextPart_000_0060_01C629D7.5910D2A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All, I have an application that will dump a whole bunch of file to a Folder, = I need to find an ActiveX or a library I can use from VFP9 that will = monitor this folder and trigger an event whenever a file is being = dropped in this Folder. =20 I know I can use a VFP timer to do just that but wanted to see if = somebody know of a better way of doing this with a library instead of a = VFP Timer. --=20 Edhy Rijo www.progytech.com Bronx NY ------=_NextPart_000_0060_01C629D7.5910D2A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.2802" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Hi All,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I have an application that will dump a = whole bunch=20 of file to a Folder, I need to find an ActiveX or a library I can use = from VFP9=20 that will monitor this folder and trigger an event whenever a file is = being=20 dropped in this Folder.  </FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I know I can use a VFP timer to do just = that but=20 wanted to see if somebody know of a better way of doing this with a = library=20 instead of a VFP Timer.</FONT></DIV><FONT face=3DArial size=3D2> <DIV><BR>-- <BR>Edhy Rijo<BR><A=20 href=3D"http://www.progytech.com">www.progytech.com</A><BR>Bronx = NY</DIV> <DIV> </DIV> <DIV></FONT> </DIV></BODY></HTML> ------=_NextPart_000_0060_01C629D7.5910D2A0-- Tag: ADO CursorAdapters - only first is loaded Tag: 220586
  - 20
    - How to read mainboard serial no in vfp ? How to read mainboard serial no in vfp ? Tag: ADO CursorAdapters - only first is loaded Tag: 220577
  - 21
    - Upgrade from FPW/DOS 2.6 to VFP6.0 I'm preparing to upgrade an application package that uses Foxpro 2.6 for Windows/DOS, to a newer package that uses Visual Foxpro Version 6. I have an opportunity to buy a used Upgrade version of VFP 6. Would that version consider the old Version 2.6 a qualifying version for upgrade purposes? Thanks for your help. Lakeside Tag: ADO CursorAdapters - only first is loaded Tag: 220575
  - 22
    - SHARE_INFO_2 Hi everyone, I am trying to add a share in my system automatically, does anyone have a sample of the structure or an example of NetShareAdd Thanks in advance Tanya Tag: ADO CursorAdapters - only first is loaded Tag: 220567
  - 23
    - Parent Child Data Entry w/ CursorAdapter & SQL Server 2005 Hello, Environment: VFP9.1 Using Cursor Adapters to access data on SQL Server 2005 using ADO Challenge: When adding a new 'parent' record, how can I get the primary key, so that I can set a foreign key when adding a new 'child'? Are we restricted to creating the parent, then attempting to save before adding child data? Tag: ADO CursorAdapters - only first is loaded Tag: 220566
  - 24
    - Simple Changes in VFP These are a couple of little things that really would simplify my life.... When you open the Class Browser...please open to the same folder as last time and NOT to the current folder. All my classes are in one folder. I hate having to scroll back to that folder each time. The class browser opens in full screen sometimes and to another window size sometimes. This is annoying. The report controls toolbar should remain on the screen each time you open the report designer. Same for the layout toolbar. Thanks for listening, John. p.s. I'm using VFP8, maybe Ver 9 fixes this stuff. Tag: ADO CursorAdapters - only first is loaded Tag: 220562
  - 25
    - split a string! Hi, I have a string which has the full address in it. It also has a comma (,) to seperate the address into line. I need to be able to read the string and then split it up at the comma, but ignore passing the comma over. i.e. I have: 34 Castle Road, Town, County I need to split it so that i have: 34 Castle Road Town County can someone please let me know the besh way to do this? Many thanks in advance Rob Tag: ADO CursorAdapters - only first is loaded Tag: 220559

Environment: ADO Cursor Adapters, connecting to an SQL 2005 DB.

I have found that only the cursoradapter specified as
'InitialSelectedAlias' in the form's data environment will be loaded.
All other ADO-connect-type cursoradapters do not load.

If I change the connection type from ADO, to ODBC all cursoradapters
are in the datasession and loaded correctly.

Can anyone steer me in the right direction?

Top

Re: ADO CursorAdapters - only first is loaded by drsystems

drsystems
Fri Feb 10 13:25:15 CST 2006

Problem solved (soon after I posted) :-)

Cause:
The cursoradapter's were using the data environment source
(UseDeDataSource = .T.). When I specify the connection string for each
cursoradapter, they load correctly.

Is this a bug?

Top