Grids on form with Private Datasession and 3 tier application

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
    - Conditional Counter field .. Want to add a Counter field to a Table which should be incremented only if certain field in the table is NOT EMPTY() ? How can I achieve this ? Urgent Response is urged. TIA Tag: Grids on form with Private Datasession and 3 tier application Tag: 197734
  - 2
    - VFP6 and Excel Hi I have a program in VFP6 that has OLE excel worksheet in a form I am able to print what I want by calling oXObj.PrintOut() but I can't get .PrintPreview to work. I would also like to be able to bring up the standard Print Dialog window can anyone help me with this. Any help greatly appreciated. Warren warrenjw@austarnet.com.au Tag: Grids on form with Private Datasession and 3 tier application Tag: 197729
  - 3
    - VFP6 & VFP8 on the same computer Hi, I have upgraded my computer from VFP6 to VFP8 for what i had to uninstall VFP6, however I have a framework (Visual Promatrix 6.0) that is sending error when I try to execute under VFP8.... is it possible to have both VFP versions installed concurrently on the same computer? how? thanks Oscar Taboada Tag: Grids on form with Private Datasession and 3 tier application Tag: 197728
  - 4
    - FPW2.6a changing browse title In FPW2.6, can I change the title of a browse window without releasing / redisplaying the browse? * something like this, but working ;) ***************************************** CREATE CURSOR test (test L) m.ltitle="text1" ON KEY LABEL f12 DO chgtitle BROWSE TITLE m.ltitle **************************** PROCEDURE chgtitle **************************** PRIVATE m.loldtitle m.loldtitle=m.ltitle m.ltitle="text2" SHOW WINDOW (m.loldtitle) REFRESH * also tried MODIFY WINDOW (m.loldtitle) TITLE (m.ltitle) *eof At the moment I'm doing this: ************************************* CREATE CURSOR test (test L) m.test="text1" m.looping=.T. ON KEY LABEL f12 DO chgtitle ON KEY LABEL esc DO killit DO WHILE m.looping BROWSE ; TITLE m.test ENDDO ON KEY LABEL esc ON KEY LABEL f12 ******************* PROCEDURE chgtitle ******************* PUSH KEY CLEAR RELEASE WINDOW (m.test) m.test=IIF(m.test="text1","text2","text1") POP KEY ******************* PROCEDURE killit ******************* PUSH KEY CLEAR m.looping=.F. RELEASE WINDOW (m.test) POP KEY *eof -- TIA Andrew Howell Tag: Grids on form with Private Datasession and 3 tier application Tag: 197721
  - 5
    - Create Label generates C0000005 error I have a VFP8 SP1 application (compiled EXE) that generates a C00000005 error whenever I run "MODIFY LABEL XXX" or "CREATE LABEL XXX" (xxx does or does not exist - makes no difference). I have another VFP8 SP1 application in the same directory (Command prompt emulator) that does not give C00000005 error. In both cases, no tables are open so it has nothing to do with data file corruption, indexes or a corrupt label file. Any ideas? Cheers David Younger Tag: Grids on form with Private Datasession and 3 tier application Tag: 197719
  - 6
    - Any real speed advantage with dual Xeon processors? Hi, I'm looking for the fastest performance I can get on a networked VFP app. The server which holds the data is currently dual Xeon, lots of RAM, Win 2003 Server, 15K SCSI drives, 10/100BaseTX LAN. My current idea is to upgrade the server to 1000BaseTX, and buy a dual Xeon workstation, plenty of RAM, 1000BaseTX, 15K SCSI drives and XP Pro. The app only needs to work on the one workstation, and the server is simultaneously handling data for 50+ other workstations with lower performance requirements. The data is all free table - I can't use DBCs/stored procedures because of FPD apps sharing the data. Do the dual processors make a difference to workstation speed with VFP? Does anyone have any better ideas? VFP7, but going VFP9 as soon as it's available. Regards, Neil Tag: Grids on form with Private Datasession and 3 tier application Tag: 197713
  - 7
    - How to get images to be added automatically to project I am trying to setup my app so that if I create a new project and add the startup routine, all necessary routines will be automatically added to the project. I do this by having a dummy routine that never gets called, that references all forms, classes, and reports. I also have a bunch of images I want added to the project that are not directly referenced. Any ideas how these could be referenced in a dummy routine so that the project will automatically add them on rebuild? Tag: Grids on form with Private Datasession and 3 tier application Tag: 197711
  - 8
    - PowerTCP UDP Control Does anyone have any experience using PowerTCP's UDP Control. Tag: Grids on form with Private Datasession and 3 tier application Tag: 197699
  - 9
    - DBI-Tech ctTree Activex -- anyone know how to get node information Does anyone Know how to get node information such as text value when user clicks on a node from DBI-Tech ctTree activex control? ALso how do you know if the node you clicked on is a parent or child node? thanks Nick Tag: Grids on form with Private Datasession and 3 tier application Tag: 197687
  - 10
    - DBI-Tech ctTree activex -- how do I get node information? Does anyone Know how to get node information such as text value when user clicks on a node from DBI-Tech ctTree activex control? ALso how do you know if the node you clicked on is a parent or child node? thanks Nick Tag: Grids on form with Private Datasession and 3 tier application Tag: 197686
  - 11
    - Not enough memory message when joining source control project File -> Join source control project. This is a large project with several thousand files. VFP apparently does a get latest on the PJM file, builds a new PJX., and then does a get latest on everything in the PJX. When it finishes, I get "There is not enough memory to complete this operation". At the time this occurs, VFP is consuming 20MB physical memory, 10MB swap file, 209 GDI objects, and 2911 USER objects. This last entry concerns me, as 2911 USER objects is quite high and is probably why the error occurs. VFP will normally have less then 100. Historically, excessive USER or GDI usage is a result of poor programming, bugs, or memory leaks. I also think that this should work, even if it is using a lot of USER resources. Win2000/XP doesn't have the terminal USER or GDI limits that Win9x had, so I'm thinking that the problem here is internal to VFP. Also, it works for some of us, and not for others. It's not just my workstation, as I'm not the only one having this problem. Any ideas? Tag: Grids on form with Private Datasession and 3 tier application Tag: 197681
  - 12
    - VFP 9.0 beta help file I have downloaded and installed the beta of VFP 9.0. The help file does not function, and I wonder if this is the way the beta was released. Should I try downloading and installing again, or is this feaure just not working in the beta? -- seeker Tag: Grids on form with Private Datasession and 3 tier application Tag: 197678
  - 13
    - Watch for a fake bill Hi FP community, Make sure to watch out for a fake bill from Stonefield ... I guess they are desperate enough for business that they have resorted to sending a fake bill to try to get return customers. Very, very unethical business strategy in my opinion. Tag: Grids on form with Private Datasession and 3 tier application Tag: 197672
  - 14
    - dbf and php there is an example to open with mysql and php a foxpro database? Tag: Grids on form with Private Datasession and 3 tier application Tag: 197663
  - 15
    - Tables with buffering VFP 80 Sp1 XP My form allows the user to add a record. (In this case to the zip code table). I control my "Save" and "Undo" according to certain rules. If the user enters a zip code that is already in the table, I want to prevent the "Save" from enabling. However, on the LostFocus of the textbox for the zip code, I will automatically save the record when I seek that code. How do I determine if that zip code codes not already exist? I could open the table twice, but that seems a waste. TIA Tag: Grids on form with Private Datasession and 3 tier application Tag: 197651
  - 16
    - _Screen.Image When an Image object is added to the _screen to show some picture or graphic and a user later runs a report in Preview mode, periodically the image object on the _screen, continues to show the report preview image even after the report preview has been released. It is as if the graphic image from the report preview window, overlays, changes or corrupts the PICTURE of the IMAGE object on the _screen. Has anyone else seen this behavior/bug, and if so, any ideas what causes it or how to fix it short of destroying the _screen.image object and re-adding it to _screen? Thx Alec Tag: Grids on form with Private Datasession and 3 tier application Tag: 197648
  - 17
    - Sql Server Question Assuming I have a table stored in SQL server. What is the best technique advised as to searching for a particular record since the Seek command can not be used. The two options that comes to my mind is the Locate and the set filter command. If the particular field I am searching for has been defined in SQL server as being an index key, how can one perform a search that would not be considered sequestial and move the record pointer to the record desired as in the seek command. Many thanks in advance. Shahriar Tag: Grids on form with Private Datasession and 3 tier application Tag: 197647
  - 18
    - displaying records through a preview window Hi, what and how would be the easiest way to display records in a pre-formatted preview window in vfp6.0? before with 2.6, i redirect the formatted report to a text file, viewing the result through 'modi comm (text output file)' and terminating the preview report throught the ESC button. With 6.0, i've heard of so many ways to implement it, i dont know now what to use as my standard program procedure? I'm thinking of using a 'Microsoft Word Document Viewer'. will this simplify my class creation and maintenance? Thank you very much and more power! Long live Foxpro! Tag: Grids on form with Private Datasession and 3 tier application Tag: 197646
  - 19
    - Cryptor IV fll file I can't seem to get a response from Xitech on the issue but they advertise the Cryptor IV is compatible with VFP 8 but there is not an fll for VFP8 included in my copy. Is there an fll for VFP8? And if so does anybody have it and can I get a copy. This should not be a problem as I can't use the fll without a legit copy of he rest and I have that and all. But it makes it a little hard to use the product in VFP8 without the fll since you have to have the proper version of the dll for each version of VFP that is supported. I have tried emailing Xitech on the issue several times and have not gotten any response from them at all. Tag: Grids on form with Private Datasession and 3 tier application Tag: 197644
  - 20
    - dbf encrypting data Is there an easy and efficient way of encrypting data in dbf's? Looking for something simple.. thanks Tag: Grids on form with Private Datasession and 3 tier application Tag: 197636
  - 21
    - Adding events VFP80 SP1 on XP I have a basegrid in MyClass. I have added it to a form. When I run the form, I programmatically want to add a column and a Click() event to that column. I do not understand the Help screens on this issue. Anyone have a simple example. TIA Tag: Grids on form with Private Datasession and 3 tier application Tag: 197629
  - 22
    - set confirm and end of input ContainerA .textbox ContainerB 1. With SET CONFIRM OFF, how could I make a particular textbox on a form NOT to fire its valid()/lostfocus() event unless the user hit <enter>? 2. and when the user did hit <ENTER>, containerB will be made visible while containerA would be made invisible via containerA.textbox.lostfocus(). Any neat way to prevent containerA.textbox.valid() from being fired again when containerB was made visible? -- .~. Might, Courage, Vision. In Linux We Trust. / v \ http://www.linux-sxs.org /( _ )\ Linux 2.4.26 ^ ^ 12:24am up 16:25 0 users 1.72 1.89 Tag: Grids on form with Private Datasession and 3 tier application Tag: 197628
  - 23
    - textbox focus (VFP6 unpatched) In one form, after going through a few events, a textbox.setfocus() was called, with textbox.format="K". Though the textbox got focus, the text inside was not selected (note the textbox.format) and sometimes, even the cursor is not inside the textbox, going somewhere. sometimes, the textbox, while in focus, didn't echo the text I inputted, though beneath the "surface", it's taking the input. The behaviour returned to normal after textbox.valid() fired once. -- .~. Might, Courage, Vision. In Linux We Trust. / v \ http://www.linux-sxs.org /( _ )\ Linux 2.4.26 ^ ^ 12:16am up 16:17 0 users 2.11 2.06 Tag: Grids on form with Private Datasession and 3 tier application Tag: 197627
  - 24
    - simulate PRINT-SCREEN I use VFP 8.0 I would like to simulate the print-screen (stamp) button Any ideas ???? thanks KEYBOARD '{ xxx }' Tag: Grids on form with Private Datasession and 3 tier application Tag: 197626
  - 25
    - Datagrid control for VFP 8? Does anyone have a recommendation on a grid control for foxpro outside of the Datagrid control that is shipped with VFP 8. Many thanks Shahriar Tag: Grids on form with Private Datasession and 3 tier application Tag: 197625
- Next
  - 1
    - cannot using "GROUP BY" clause hi why i can't include GROUP BY clause in my SQL-string ? thank Tag: Grids on form with Private Datasession and 3 tier application Tag: 197616
  - 2
    - Menu Creation I have created menu using menu command Everthing works fine through command window i.e. do program name. But, when i generate the EXE it does not work, Programme exits directly. Tag: Grids on form with Private Datasession and 3 tier application Tag: 197610
  - 3
    - Complicated form with many search options Hello, I'm creating a form to manage serialized goods. The form shows data from 9 different tables. I also need to allow the user to search on a combination different parameters: Serial number Description GL Accounts Payment Due date Retail price Received Date AP Invoice # Categories They can search on as many or as few as they want. When faced with a form of this complexity, is it best to go with a CURSOR and update the records by hand, or is it best to use a view. The downside of the cursor is that it requires more work to commit the changes to the back end table. The advantage is that I have a lot more flexibility with my query statement. The downside of using a view is that I have to include all parameters in every search whether the user search on it or not. The advantage is that I can bind a view to the form itself and TABLEUPDATE() will handle the changes for me. Another problem is that a couple of my search fields are variable list matches that I make with a sub query against a temporary cursor and this might be difficult with a view (a variable table name parameter?) Does anybody have any tips on ways to go about this? Sincerely, Caleb Land Tag: Grids on form with Private Datasession and 3 tier application Tag: 197606
  - 4
    - NTFS system I need to know if our program is running on NTFS. I figure I could do this with OS(11). I am just checking if this is right. We only have NTFS stations so I can't see what a Win 98 will return with that function. I am guessing it will return a 0. Is this right? Tag: Grids on form with Private Datasession and 3 tier application Tag: 197592
  - 5
    - What am I missing in outer join query I am having problem with outer join in query. I am sure I am missing something and I am sure someone will point me the right direction. I have 2 tables AreaOffice Purchases I want all the records from Areaoffice and related purchases from Purchases table. AreaOffice: AOId AOName 1 AreaI 2 AreaII 3 AreaIII Purchases: AOId Date Amount 1 7/1/04 100 1 7/2/04 200 3 7/1/04 300 What I want is AOId AOName Date Amount 1 AreaI 7/1/04 100 1 AreaI 7/2/04 200 2 AreaII 3 AreaIII 7/1/04 300 But I dont get AreaII record on final result. Here is my query: SELECT AreaOffice.AoId, AreaOffice.AOName, Purchases.Date, Purchases.Amount ; from Areaoffice LEFT OUTER JOIN purchases on purchases.aoid = areaoffice.aoid ; order by ao_id Why am I not getting expected records? Thanks. Tag: Grids on form with Private Datasession and 3 tier application Tag: 197591
  - 6
    - FormHandler only allows 1 form I have taken the following code from "Advanced Object Oriented Programming with Visual FoxPro 6.0" and if I'm not mistaken it only allows 1 form to be open at a time. Is this a bug? It should be easy enough to correct but I am just a little surprised. Function LaunchForm(tcClassName) *-- Check if we have to redimension the array If Alen(This.ApplicationForms,1)=1 AND NOT ; Vartype(This.ApplicationForms(1))="O" Dimension This.ApplicationForms(Alen(This.ApplicationForms,1)+1) EndIf *-- Create the form and show it This.ApplicationForms(Alen(This.ApplicationForms,1))=CreateObject(tcClassNam e) *-- Check form has been created If Vartype(This.ApplicationForms(Alen(This.ApplicationForms,1)))="O" *-- Form has been created *-- Show it This.ApplicationForms(Alen(This.ApplicationForms,1)).Show() *-- Return a reference to the new form Return This.ApplicationForms(Alen(This.ApplicationForms,1)) Else *-- Form was not created *-- Delete the reference from the array If Alen(This.ApplicationForms,1) = 1 *-- The array only had the one item so we can't shrink it *-- We can however clear the object reference This.ApplicationForms(1) = .NULL. Else *-- Shrink the array Dimension This.ApplicationForms(Alen(This.ApplicationForms,1)-1) EndIf Return .NULL. EndIf EndFunc -- Regards Darren Woodford - MCP, MCSE Woodford Computer Systems Ltd http://www.woodfordcomputers.co.uk http://www.pegasus-opera-ii.co.uk Tag: Grids on form with Private Datasession and 3 tier application Tag: 197585
  - 7
    - callAll? I was wondering if anything like callAll for objects is being thought about for VFP 9. I havent found anything about it and after having setAll it seems to be the logical next step. CallAll should call the same method for all objects.. very similar to setAll just with methods.. I would like to get a suggestions about that to the developers of VFP.. I wonder if this is potentially the right place.. Tag: Grids on form with Private Datasession and 3 tier application Tag: 197576
  - 8
    - SetFocus to a form (class) VFP8 How do I set the focus to a form after I instantiate it and display using Visible = .T. ? Eg. loForm = CreateObject("TForm") loForm.Visible = .T. *-- Form does not have focus however loForm.Show() does give the form focus but I would like to know how to do this 'manually' -- Regards Darren Woodford - MCP, MCSE Woodford Computer Systems Ltd http://www.woodfordcomputers.co.uk http://www.pegasus-opera-ii.co.uk Tag: Grids on form with Private Datasession and 3 tier application Tag: 197575
  - 9
    - Local View modification on a remote database I have a local view stored in a database which needs to be modified. Unfortunately the database is in a remote location and I have no access to it. My first thought was to write some code and let it run on the remote location to modify the view. Unfortunately I cannot find anything how to change a view with code, I even do not know how to access it or where it is stored. Download the data, modify the view and upload againg is not possible. The database is quite big for such a task. Any suggestion would be appreciated Wolfgang Tag: Grids on form with Private Datasession and 3 tier application Tag: 197573
  - 10
    - Custom sized reports Hello; I have a situation where a client has started the process of upgrading workstations from Windows 98 to XP. Currently they are about 50% complete. The problem we are having is that custom sized report forms (ie cheques), do not print correctly from the XP stations (their alignment is off slightly, ie off millimeter for every page). The project is compiled under Windows 98. I see a few potential solutions. 1) recompile under XP - I am concerned that the 98 stations will have issues than, and currently, they are the critical stations. 2) do all special form printing from the 98 stations until the upgrade is complete and than recompile uner XP and adjust the forms as required. I do not like either of these options. I was wondering if anyone has seen this and knows of a work around. The version of Foxpro I am running is 5.0b. Any ideas are welcome. Tag: Grids on form with Private Datasession and 3 tier application Tag: 197572
  - 11
    - Filemaker Pro data to VFP I have been tasked to determine the feasability of importing data from a Filemaker Pro database to a VFP database. I will just require raw data as opposed to rules, etc. Is there anyone out there who has gone down that path? TIA --E. Myron -- To reply, change "invalid" to "net" Tag: Grids on form with Private Datasession and 3 tier application Tag: 197567
  - 12
    - VFP 9 threads??? I don't see very many threads on Fox9. Is there a special beta newsgroup somewhere???? Thanks Tag: Grids on form with Private Datasession and 3 tier application Tag: 197566
  - 13
    - Valid Event Message Hi Experts, Does anyone know how to change message "Invalid Input" to our own message, thanks in advance for all advices Hidayat Tag: Grids on form with Private Datasession and 3 tier application Tag: 197565
  - 14
    - Referncing a table not in the current datasession Using VFP 8 --- Is there anyway to reference (or view in the VFP debugger) a table or object in a specific data session - without changing the datasession? The same table can be open in multiple datasessions, so we are trying to find a way -in code- to view information about a table, or an object, that is specific to one datasession. It would make debugging much easier. Yes, you can use the DataSesson window (or the SET command) to flip back and forth between datasessions, but we are looking for a way -in code- to reference a table or object that is not in the current data session. Any ideas would be greatly appreciated. --Thanks Mike C. Tag: Grids on form with Private Datasession and 3 tier application Tag: 197562
  - 15
    - Foxpro to Excel cell formatting questions I am currently using Foxpro to write out an excel spreadsheet. I am using the following line to write a cell: for eline to 10 oExcel.Cells(eline, 2).Value = database.p_price endfor It is working but I want to have the following format on the cell: $###,###,###.## What do I need to add to do this? Also, what would I need to do if I wanted to format with the following: ###,###.##% One more question, if I wanted to spread a cell over 2 (or more cells), what would I need to do. Thanks. LVIII Tag: Grids on form with Private Datasession and 3 tier application Tag: 197557
  - 16
    - Visual Foxpro Scctext.prg I am attempting to re-create the .frt & .frx files of a Foxpro report using scctext.prg. (VFP 8.0) I have been successful in re-creating the binary files for forms and classes, but whenever a report is being processed, there is an error in the following method "HexStr2BinStr". I have been able to determine that when the ascii file (.fra) is written, any binary objects are stored using Sys(2007) (creating a Checksum), which is then passed to HexStr2BinStr prefixed with "CHECKSUM=". HexStr2BinStr uses Strtran() to convert some characters with a result of <H><KSUM=99999, etc, but the method fails before actually getting to the numeric portion of the string. Function HexStr2BinStr .*--where m.cHexStr = "CHECKSUM=55992"--* . . m.cHexStr = strtran(m.cHexStr, 'A', chr(asc('9') + 1)) m.cHexStr = strtran(m.cHexStr, 'B', chr(asc('9') + 2)) m.cHexStr = strtran(m.cHexStr, 'C', chr(asc('9') + 3)) m.cHexStr = strtran(m.cHexStr, 'D', chr(asc('9') + 4)) m.cHexStr = strtran(m.cHexStr, 'E', chr(asc('9') + 5)) m.cHexStr = strtran(m.cHexStr, 'F', chr(asc('9') + 6)) for m.i = 1 to len(m.cHexStr) step 2 m.cBinStr = m.cBinStr + ; chr((asc(substr(m.cHexStr, m.i, 1)) - 48) * 16 + ; asc(substr(m.cHexStr, m.i + 1, 1)) - 48) endfor . I have looked at the latest version included with VFP 9.0, but there are no changes that I can see. Has anyone found a work-around for this, or am I doing something totally incorrectly? Tag: Grids on form with Private Datasession and 3 tier application Tag: 197552
  - 17
    - Right click event of grid Hi experts.. Why does not grid's right click event work ? How to make it work ? any help are appreciated Tag: Grids on form with Private Datasession and 3 tier application Tag: 197550
  - 18
    - Inkey()??? Hello, I have inheritted some code. This program is written in Visual FoxPro 6.0. The function inkey() is used in several areas of the program and I still have not been able to figure out it's purpose. I would postpone to investigate this had it not been for one particular one causes errors every no and then. Got to love those inconsistent ones where debuggin takes 4 times as long and in my case still not solved. I checked FoxHelp and all it has is: Returns a number corresponding to the first mouse click or key press in the type-ahead buffer. It doesn't explain why anyone would want to use it. If there is anyone who can tell me what the inkey() function's purpose is, and what possibly could cause the following error message for the following code segment code: =inkey(1) error: Function argument, value, type or count is invalid. Please keep in mind that this error message does not pop up all the time. Thank you for your help in advance. Tag: Grids on form with Private Datasession and 3 tier application Tag: 197544
  - 19
    - Help distributing and app (VFP8) Hi, I'm having a difficult time sending a small vfp8 application (EXE) to a friend. See the thread: What files to distribute? for background info. I created a SETUP.EXE using InstallShield Express (ISE) and sent it to my friend. He ran it and got the same error as when I tried sending him the individual files. The message is: "A required DLL file, MSVCR70.DLL was not found." I had previously sent him this file outside of ISE. What I'm not sure of is if the necessary support files were actually included in the ISE Setup.exe file or not. I didn't see any place to explicitly include these files so I had to assume ISE took care of that for me. The only file I included was the EXE that VFP built for me. Anyway, since the setup didn't work, I'm back to square one. I'd just as soon send the individual files and skip ISE altogether as it seems more complicated and with more black magic when using it. Can someone help with this? At this point I'm totally confused. I don't know which way to turn. Why do I get the above message even when MSVCR70.DLL is present? Thanks for your help, Frank Tag: Grids on form with Private Datasession and 3 tier application Tag: 197541
  - 20
    - mapi mail xp-win2k domain - woes Hello All, I wasn't sure where to list this so please excuse if I picked the wrong category. I'm trying to get mapi mail inside my fox app to work at my customer's location. It works find on my development machine.....here's the details. I've tried several things and listed them all so please be patient....... The situation: xp pro client win2k server domain the client pc has two logon's possible. One is the administrator belonging to the local machine name and the other is the username belonging to the domain. My first attempt was to run fox.reg looged in as a domain user. This fails because no admin rights to local machine (or so it tells me - could it have meant domain rights here?). I'm hoping the registry modification(fox.reg) if made as administrator will work also for the user so I give this a try. I installed it (fox.reg) on local machine logging in as the adminstrator. I log back in as the user and mapaimail is not working - no messages it simply acts like either mapi is not talking from vfp or the mail program outlook express or eudora is not listening. So I dig deeper and try more. When I look at the control panel I see the user does in fact have admin rights on the local machine but when I look at the user on the win2k box (domain) they do not have admin rights. Still not working. I read somewhere that rights need to be the same on both the xp and win2k systems, So I change the domain to also give them admin rights by adding them to that group. I log back in as the user and the mapimail mods I've made still don't work. I'm suspecting it's the supervisor / user / domain security issues. I think I should try to install fox.reg again as the user now that I've changed the domain to recognize the user a an administrator. - nope it states something similar to "already in use". So I'm unsure of what to do here any ideas? I'm stuck. thanks for any help.... Tag: Grids on form with Private Datasession and 3 tier application Tag: 197540
  - 21
    - XMLAdapter - ApplyDiffGram Question 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 Tag: Grids on form with Private Datasession and 3 tier application Tag: 197516
  - 22
    - 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: Grids on form with Private Datasession and 3 tier application Tag: 197512
  - 23
    - 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: Grids on form with Private Datasession and 3 tier application Tag: 197509
  - 24
    - 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: Grids on form with Private Datasession and 3 tier application Tag: 197502
  - 25
    - 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: Grids on form with Private Datasession and 3 tier application Tag: 197500

Please could someone give me a pointer in the right direction on this
please.
I am developing a small application but I would like to stick with the 3
tier architecture if possible.
My forms are modeless with private datasessions. The problem is, I would
like to display a recordset in a grid on my form. The grid control will only
allow a table/cursor as a record source so I need some way to get that
recordset through the tiers. I have tried creating a cursoradapter but the
cursor gets created in the default datasession instead of the private one. I
am on the verge of just coding the data access straight into my grid control
but that would break the 3 tier design.
Is my best option ADO or another idea? If I use ADO is there a grid that
will accept ADO as a recordset or do I have to convert it back to a cursor?
Your thoughts please.

--
Regards
Darren Woodford - MCP, MCSE
Woodford Computer Systems Ltd
http://www.woodfordcomputers.co.uk
http://www.pegasus-opera-ii.co.uk

Top

Re: Grids on form with Private Datasession and 3 tier application by Holger

Holger
Tue Aug 03 09:15:43 CDT 2004

Hi,

> Is my best option ADO or another idea? If I use ADO is there a grid that
> will accept ADO as a recordset or do I have to convert it back to a
cursor?

you could create an ADO recordset in your middle tier.
Your user interface tier could pick up a reference to that ADO recordset and
use it as a datasource for a CursorAdapter.
The CursorAdapter automatically creates a Cursor for your Grid control.

--
Holger Vorberg
MS Visual FoxPro MVP, Germany

Top