Calculated Fields

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
    - Transparent Forms I was experimenting with making a form transparent. I seem to be able to do that if I create a prg file and define a form class, etc... however, if I manually create a form and place the following code in a command button my form does not become transparent. The code is as follow: DECLARE integer GetWindowLong IN WIN32API integer hwnd,integer nIndex DECLARE Integer SetWindowLong IN WIN32API integer hwnd,integer nindex, integer dwNewLong DECLARE integer SetLayeredWindowAttributes IN WIN32API integer hwnd, integer crKey, ; short bAlpha, integer dwflags LOCAL xStyle xStyle = GetWindowLong(thisform.HWnd,-20) xStyle = BITOR(xStyle,0x8000) =SetWindowLong(thisform.HWnd,-20,xstyle) =SetLayeredWindowAttributes(thisform.HWnd, 0,128,2) Many thanks in advance. Shahriar Tag: Calculated Fields Tag: 203602
  - 2
    - Creating Excel Sheets I am using some recycled code from the MSDN for creating Excel sheets (I cannot find the original msdn page). basically this code creates an object named oExcelSheet with this object (yes I am aware there is more to it) I can insert data into the sheet by doing oExcelSheet.cells(5,2).value = "Ref Month". So I understand how it basically works, where it says .value I can change it to .font to do different things to the sheet. Does anyone know where I can find all the different commands? IE. .cells, .value and all the good ra ra? Tag: Calculated Fields Tag: 203599
  - 3
    - VFP 6 on Windows Server 2003 Just to make sure, does VFP 6 run on Windows Server 2003? Thanks, Gar Tag: Calculated Fields Tag: 203595
  - 4
    - Set different printer. I am trying to change printers so the user can select a button on a frame and send a report to a black and white printer or select a different button to send the report to a color printer. Now when I use the command SET PRINTER TO NAME GETPRINTER() which comes back and allow the user to select which printer to use. That works fine. But when I try and change the printer using the command set printer to \\server\hp750 and then send a print command the printer spools the report but just sets there. Now if I type the command SET PRINTER TO it tries to send data to the printer but then the printer just locks up. Can anyone help me out and show me how to just switch printers and send a report to a different printer than the default one and then return the printer to the default one?? TonySper Tag: Calculated Fields Tag: 203592
  - 5
    - Copy File - Is it necessarily lower case? I've set up a program that names files from metadata - file names I make up and place in character fields in a table. I'm finding that the VFP 7.0 COPY FILE command is creating all lower case file names. Is there any way I can proper the file names other than doing it manually? Thanks! Tag: Calculated Fields Tag: 203591
  - 6
    - createobjectEX hi i need to retrieve data from the server's registry it is possible to do with createobjectEX from the client computers ? thanks -- atte, Hernán Castelo SGA - UTN - FRBA Tag: Calculated Fields Tag: 203581
  - 7
    - PARENT is not an object (Vfp bug?) Hi, I got this error on the last line ?! anybody an idea. procedure selectme Lparameters loselectme If TYPE("loselectme") <> "O" .or. isnull(loselectme) Return .F. Endif lSelectLongName = loselectme.Parent.Name + loselectme.Name ... I can say a lot about this on how it works and at the same moment I don't have any clue ! This seems to bug a Vfp bug ?! Because the code is quite clear I think. So anyway I will try to explain the whole picture. This procedure is from a "multiselectme"class I created. I place this class on a form and call it when I want to visually highlight an object. (I visually highlight one or more objects by adding on each corner a highlighter =small rectangular shape in a bright color) the procedure is called something like this : procedure myobject.rightclick thisform.multiselect.selectme(this) *dosomethingelse thisform.multiselect.deselectme(this) I only get this error when the user Rclicks on the object when the form is not active ! So when the user first clicks on the form to activate it and then Rclick on the object I don't get an error. But of course I can't teach my user to do it this way. So I tried to activate the form in the Rclick prior to thisform.mulitselect.selectme but whether I use This or Thisform I get the same error. So has anybody an idea ? thanks in advance regards christophe Tag: Calculated Fields Tag: 203572
  - 8
    - Trip to Disney GET YOUR TRIP TRIPS TO DESNEY TRIPS TO HAWAII http://travelexpert2004.us http://travelexpert2004.biz http://gotraveling85.us Tag: Calculated Fields Tag: 203562
  - 9
    - _CRYPT problem between Win2000 and XP I've got the same problem as other users have found when trying to use the _crypt.vcx class and getting different encrypted strings between the 2OS's. On the Win2K machine , I had 2 references. One to the rsabase.dll in the Microsoft Base Cryptographic Provider v1.0 key and the other to the rsaenh.dll file in the Microsoft Enhanced Cryptographic Provider v1.0 key So I changed the Base one to also point to the rsaenh.dll file I also changed the line in the wincrypt.h file to... #DEFINE dsMS_DEF_PROV_A "Microsoft Enhanced Cryptographic Provider v1.0" After compiling with these changes it still did not work. I noticed the dll on the Win2K machine (SP4), was older than the one on the XP Home machine (SP1), so I tried to install the newer one on the 2000 machine, but Windows would not let this file get updated. Does anyone have any ideas on why they don't encrypt to the same result? With Thanks, Chris Tag: Calculated Fields Tag: 203554
  - 10
    - Disabled Images in Menus When disabling items in menus, how do I get a disabled image to be displayed? All I get is a grey box. PICTRES seems to do the job for UNDO, REDO etc, but what about my own menu items and images? Is there a Picture Resource file that I need to create? With Thanks, Chris Tag: Calculated Fields Tag: 203548
  - 11
    - TABLEUPDATE returns .T. but fails to change data in base table I am using the line ... lSuccess = TABLEUPDATE( .T., .T. ) and it is returning True. However when I check the base table the data has not changed. Here is some of the SQL code generated for the view... SELECT User_register.*; FROM ; user_register User_register; WHERE User_register.user_id = ( ?nUserID ) DBSetProp(ThisView,"View","SendUpdates",.T.) DBSetProp(ThisView,"View","BatchUpdateCount",1) DBSetProp(ThisView,"View","CompareMemo",.F.) DBSetProp(ThisView,"View","FetchAsNeeded",.F.) DBSetProp(ThisView,"View","FetchMemo",.F.) DBSetProp(ThisView,"View","FetchSize",100) DBSetProp(ThisView,"View","MaxRecords",1) DBSetProp(ThisView,"View","Prepared",.F.) DBSetProp(ThisView,"View","ShareConnection",.T.) DBSetProp(ThisView,"View","AllowSimultaneousFetch",.F.) DBSetProp(ThisView,"View","UpdateType",1) DBSetProp(ThisView,"View","UseMemoSize",255) DBSetProp(ThisView,"View","WhereType",3) DBSetProp(ThisView+".user_id","Field","DataType","I") DBSetProp(ThisView+".user_id","Field","UpdateName","user_register.user_id") DBSetProp(ThisView+".user_id","Field","KeyField",.T.) DBSetProp(ThisView+".user_id","Field","Updatable",.T.) DBSetProp(ThisView+".available_status","Field","DataType","L" DBSetProp(ThisView+".available_status","Field","UpdateName","user_register.available_status") DBSetProp(ThisView+".available_status","Field","KeyField",.F.) DBSetProp(ThisView+".available_status","Field","Updatable",.T.) ..... the rest of the fields are set as... DBSetProp(ThisView+".available_status","Field","KeyField",.F.) DBSetProp(ThisView+".available_status","Field","Updatable",.T.) I have MULTILOCKS set to ON Buffering is set to 3 : Optimistic Row Buffering (The view will only contain one record to update) The weird thing is that if I open the view from the Command window, change some of the data and type the TABLEUPDATE line in, then it successfully updates the base table, so the view properties seem to be OK. I just can't think why it's failing in my app. Any help will be greatly appreciated. Chris Tag: Calculated Fields Tag: 203547
  - 12
    - VFP 9 & 6 compatibility question I finally decided to download VFP 9. Looks great. A couple of questions. Are the compiled programs (FXP) compatible between VFP 6 and 9 or should I make copies of my common PRGs in ordrer to protect them, while making tests. Menu files differ, though it seems that if I do not modify the menu with 9.0 will not have any problems. I didn't like GetDir(). Still old fashioned. I hope that they will change it. Demetrios, Greece Tag: Calculated Fields Tag: 203546
  - 13
    - Basics about opening a database VFP8/SP1 Hi all! I have problems with opening a database shared. An example; I open my project (file, open and select esdab.pjx) with databases, tables, forms, menus and so on. Nothing else than open the project and the projectmanager pops up. In VFP´s combo in the upper edge I can see that the database 'pu' becomes open. In the datasessionwindow I can see that no table is open. In the comandwindow ? ISEXCLUSIVE('pu',2) returns .T. Q1 Why is the database opend? Q2 Why is it opend exclusive? This brings me the problem I can´t open the database again shared. Any help in this would be very appreciated. Regards Christina Tag: Calculated Fields Tag: 203543
  - 14
    - Using FoxPlus with Win XP Professional How can I get FoxPlus to operate in Win XP professional. I have it loaded in a directory "fox" using the CMD.com window but when entering the "foxplus" command the program goes into a loop and displays "position off the screen" . FoxPlus works well in Windows 2000 without any modifications. Any help you can give me would be greatly appreciated. Thanks. krausetv@comcast.net -- Steve www.televendtrionics.com Tag: Calculated Fields Tag: 203541
  - 15
    - 0x80070005 after installed SP2 of WinXP on server. Client-Server aplication VFP 6.0sp5 with remote automation on server with WinXP and clients with WinMe returns 0x80070005 into the client's screen, after upgrading server to XPsp2. Tag: Calculated Fields Tag: 203535
  - 16
    - Report Dear sirs Is there any way that I can create a full report at run time where in my project, the user can choose the table he wants then clicks on a button create Report How can I do such a thing??? thanks Mohammed Tag: Calculated Fields Tag: 203533
  - 17
    - Graph controls We are currently using MSGRAPH to present some simple graphs within our application. There have been some new requirements requested that are not available within MSGRAPH and hence we are looking for an alternative graph method. What graph controls are people using instead of MSGRAPH? the facilities we require are "mouse-awareness" so we can display the current value on a plot or some additional application data. We also would like to be able to provide 'graph templates' that define things like graph formats etc. We need to be able to support multiple axes. thanks pete Tag: Calculated Fields Tag: 203531
  - 18
    - Error Creatin FORM I have created a form in one system. Later on the same form was modified on other system. After the complete modification. I form.sct & form.sct file on the previous system. When i am running the command do form uccmast i am getting the error message as 'error loading file - record no.174 < one of its members>.parent;class name is invalid' what could be the error. I have renstalled the VFP on previous system after completely deleting the vfp programme folder. After this only the error is occuring. I have done copying procedure earlier also, but have not got such type of errors. Tag: Calculated Fields Tag: 203528
  - 19
    - DE bug? In the de of a form, I open a remote view with alias teacher1, and again with alias teacher2. In form.load is this code: SELECT teacher1 INDEX ON personid TAG personid SELECT teacher2 INDEX ON personid TAG personid The second INDEX statement gives the message "personid already exists, overwrite it?" This is a different cursor. I shouldn't get such a message. If I respond Yes, teacher2 is indexed and the index on teacher1 is removed! Is it me? This is VFP9 public beta. Tag: Calculated Fields Tag: 203518
  - 20
    - How many indexes is too many? Reading some postings, they mention not to use to many indexes (gets buggy). One of our VFP6 tables has 85 fields and ~ 120,000 records and growing. We do a variety of queries on many fields. Currently we have 8 indexes and would like to add a few more. I was wondering what a safe # of indexes is without compromising anything.? Any input/experiences is appreciated. TIA Mike Tag: Calculated Fields Tag: 203516
  - 21
    - list box bug ? Hi all vfp8, sp1 I have just run across what appears to be a bug and would like others to confirm it (maybe everybody already knows about this <g>) List box this.rowsourcetype = 5 this.rowsource = array (this.alist) 3 columns in array source this.columncount = 0 or 1 (only want 1 to show) this.boundto = .t. (only because it is our framework default) this.controlsource = [none] Result: the value of This.List[This.ListIndex,2] or [...,3] = the same value as [..., 1] !!! if I change the columncount to 3, all is OK (after finding this, I realized that in all the years I have been doing this since 3.0, I have never had more colunns than I have displayed or set width to 0) al Tag: Calculated Fields Tag: 203510
  - 22
    - how does VFP9 use web services? How does VFP9 use web services? With the no longer supported Soap ToolKit or with something else, maybe from .NET? I can't find an answer from Ken Levi's letter, and from googling around. -- The answer to the ethernal question is: put a read events after the launch of the form Tag: Calculated Fields Tag: 203509
  - 23
    - Mohamed Nour hi sir. how can i copy all these Discussions to my private inbox in microsoft outlook2003 Tag: Calculated Fields Tag: 203504
  - 24
    - Current Record is modified I have looked in the help but can't seem to find if a function exists for this. I need to know if any fields in the current record has been modified. The closest I found is getfieldstate. This would mean I would have to loop through each field to see if it has been modified? Is this the only way to do it or is there another function that I can't find? Tag: Calculated Fields Tag: 203502
  - 25
    - Update a table with values from a different table without SQL Apparently I make a basic mistake, but it isn't working the way I want. Why not and how to get it right? There are two (free) tables: Table ORIGIN with column: Key C(10) and Desc c(20) Table Destination with column: Destkey C(10) and Destdesc c(20) I want to scan through table ORIGIN get the value from column Desc and update column Destdesc in Destination. I thought this ought to do the trick, but it doesn't: **** Start PRG***** USE 'c:\temp\destination.dbf' ALIAS destination IN 0 SHARED USE 'c:\temp\origin.dbf' ALIAS origin IN 0 SHARED SCAN lcKey = origin.key lcDesc = origin.desc upd(lcKey,lcDesc) ENDSCAN Procedure upd PARAMETERS cKey, cWaarde LOCATE FOR destination.destkey = cKey IF FOUND() replace destination.destdesc WITH cWaarde ENDIF Endproc ****End PRG ******************************* Create script: Create table DESTINATION (destkey c(10), destdesc c(20)) create table ORIGIN (key c(10), desc c(20)) Insert into DESTINATION (destkey) values ('Een' ) Insert into DESTINATION (destkey) values ('Twee' ) Insert into ORIGIN (key, desc) values ('Een', 'Test1') Insert into ORIGIN (key, desc) values ('Twee', 'Test2') Tag: Calculated Fields Tag: 203501
- Next
  - 1
    - anybody out there who uses Visual Foxpro on Progress (V9) data?? Hi, I hope there is someone that reads this and knows how to update data interactively using Visual Foxpro on data in a Progress (V9) database. I can read / report on the data, but updates fail. How did you set up the connection properties and the properties of the remote view? In the view designer, update criteria tab, I selected the key field and selected update all fields, selected "send SQL Updates" and left other options at their default values. It is a remote view on a single table. The connection's user id has enough authority to read, write and execute. But if I try to update a field in a record it does not change the record, any changes are lost and the original values remain. I am using the Progress SQL92 driver (03.60.0006) (MERANT 3.60 32-BIT). Perhaps it has something to do with the setup of the driver on the server, if so can anybody point me to documentation about how to set it up so updates are allowed?. Tag: Calculated Fields Tag: 203497
  - 2
    - anybody out there who uses Visual Foxpro on Progress (V9) data?? Hi, I hope there is someone that reads this and knows how to update data interactively using Visual Foxpro on data in a Progress (V9) database. I can read / report on the data, but updates fail. How did you set up the connection properties and the properties of the remote view? In the view designer, update criteria tab, I selected the key field and selected update all fields, selected "send SQL Updates" and left other options at their default values. It is a remote view on a single table. The connection's user id has enough authority to read, write and execute. But if I try to update a field in a record it does not change the record, any changes are lost and the original values remain. I am using the Progress SQL92 driver (03.60.0006) (MERANT 3.60 32-BIT). Perhaps it has something to do with the setup of the driver on the server, if so can anybody point me to documentation about how to set it up so updates are allowed?. Tag: Calculated Fields Tag: 203496
  - 3
    - Microsoft Listview SP6 Slow Hi I am using a microsoft listview to display 1 million items. What is the quickest way in foxpro? I need to use listview sp6 because it supports icons. ie file list is what im trying to create...... Thanks Glenn Tag: Calculated Fields Tag: 203484
  - 4
    - VFP9 release date Anyone know yet (for MSDN subscribers)? Tag: Calculated Fields Tag: 203480
  - 5
    - VFP developer needed for Cyprus if you need a JOB in a lovely sunny Island and you have a Visual Foxpro experience of at least 2 years pls apply We offer good salary for a contract of 18months email to info@powersoft.com.cy George Malekkos Managing Director __________________________________ www.powersoft.com.cy eXPerience the POWER of real SOFTware ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= East/West-Coast Server Farms - Total Privacy via Encryption =--- Tag: Calculated Fields Tag: 203473
  - 6
    - Adding a sum of column on previous page in the first row of current page Hello guys: Now, this should be easy: I created an apps that already run for years in my client site. This morning he just called and asked me to add a sum of previous page in the top of each report. What he mean is something like this: suppose that the total_sales column for page 1 is US$ 540.50, then this amount must show up in the first line of page 2. The same goes in page 3 in which the first line is fill with the sum value of page1 and page2. Question: Is there any way that I could accomplish this in the report writer alone (by adding variable or whatever) without 'touching' the code that create the cursor (the cursor is used as a data source for the report). I want the upgrade to be as easy as possible. TIA, Willianto Tag: Calculated Fields Tag: 203457
  - 7
    - textbox and numbers Hi, I have an annoying default-textbox-behaviour when entering numbers in combination with clicking on the textbox before starting entering numbers. When "tabbing" into the textbox there are no problems because I set the textbox.format = "K" (=select whole) So the whole text is selected and when entering one or more number the selection gets "replaced" with the new values so far so good with the default behaviour. But when I enter into the textbox with a mouseclick then "problems" occurs. For example when the default value = 0 and the users clicks in the left side of the textbox. the textbox doesn't get selected and the 0 stays in the textbox ! when typing only one number (eg 2) the value becomes 20 ! when typing two number (eg 21) the value becomes ok = 21. when the default value is 123 and the user enter 21 the result becomes 211 ! (so while typing the default values moves to the right) when the users clicks in the right side of the textbox it is even worse ! Then the user can't even enter values in the textbox. it jumps right away to the next control. I've placed this (as a trial) in the textbox.click to be sure the textbox get selected : this.Selstart = 0 this.SelLength = LEN(TRANSFORM(this.Value)) but this start selecting from left to right ! so this is not a solution. and textbox.alignment = 2 (left) is also not a solution. So my question is how can I safely enter numbers into a textbox combined with first clicking on the textbox. (because it's a touchscreen) or without fooling around the cursor with the controlkeys. kind regards and thanks in advance christophe Tag: Calculated Fields Tag: 203455
  - 8
    - SQL, which items have certain refs and don't have certain other refs? Hello, I have a table storing bills of materials. I want to select all the products that contain certain items and don't contain certain other items. What is the best way? I tentatively guessed at using a HAVING clause but I was wrong. I think this leaves me with a nasty set of self joins or a less nasty set of sequential queries: CREATE CURSOR bom (item C(10), comp C(10)) INSERT INTO bom VALUES ("item1", "comp1") INSERT INTO bom VALUES ("item1", "comp2") INSERT INTO bom VALUES ("item1", "comp3") INSERT INTO bom VALUES ("item1", "comp4") INSERT INTO bom VALUES ("item1", "comp5") INSERT INTO bom VALUES ("item2", "comp1") INSERT INTO bom VALUES ("item2", "comp3") INSERT INTO bom VALUES ("item2", "comp4") INSERT INTO bom VALUES ("item2", "comp5") INSERT INTO bom VALUES ("item3", "comp1") INSERT INTO bom VALUES ("item3", "comp7") INSERT INTO bom VALUES ("item3", "comp8") INSERT INTO bom VALUES ("item3", "comp9") INSERT INTO bom VALUES ("item3", "comp10") INSERT INTO bom VALUES ("item3", "comp11") INSERT INTO bom VALUES ("item3", "comp15") I want all the items that contain, say, a ("comp1" or a "comp3") not a ("comp6" or a "comp7") and a "comp2" Any ideas? [it should just be "item1" in the above data] * this is the kind of thing I'd hoped would work but wasn't too surprised when it didn't: SELECT item FROM bom ; HAVING (comp="comp1" OR comp="comp3") ; AND !(comp="comp6" OR comp="comp7") ; AND comp="comp2" ; GROUP BY item In my actual data I have to test many more components present / not present than that example. I'm thinking a series of EXISTS and NOT EXISTS queries is going to be easiest at the moment. -- TIA Andrew Howell Tag: Calculated Fields Tag: 203446
  - 9
    - Pageframe Memory Variable I have designed a pageframe which has 3 pages. I am using the memvar for textbox,combox grid data on all the pages. I scatter the memvar & getting the pages refreshed as follows. thisform.pageframe1.page1.refresh thisform.pageframe1.page2.refresh thisform.pageframe1.page3.refresh. Upto this everthing is fine. But, I have written the routine in the cmdbutton 'SAVE' for saving the record in click procedure. Here i am checking some validations for the memvar which are checked. Only for page1 the check procedure are ok. But when trying to check the memvar of the second page it gives the error as 'Variable not foun'. I checked that field name exist & value is also shown, but m.filedname values are not found for complete 2nd page. If pageorder is 2 then memvar vvalues of the 1st pages are not found. I can not understand what is wrong. Thank u. Tag: Calculated Fields Tag: 203438
  - 10
    - vfp8 xml interface Where do we start with the VFP to XML and vice-versa issue. When I do an "xmltocursor" of a client Purchase Order it gives me some of the fields seperately and some grouped all together, requiring further parsing. Does anyone have a good reference site for this ? -- george markhauser Tag: Calculated Fields Tag: 203433
  - 11
    - Determining what causes a c5? C0000005 Does anyone know how to pinpoint what is causing a c5 (C0000005) error? We connect via ODBC to a Microsoft SQL Server database and approximately once out of a 300 queries produces a C0000005 The SQL Server is on a Windows 2003 Server, and the requesting application is running under a user account with Administrator rights in a Terminal Services setting. -- Thank You, Tag: Calculated Fields Tag: 203429
  - 12
    - =tableupdate(.F.) error I'm getting the following error on the =tableupdate(.F.) statement "Function requires row or table buffering mode" I checked in Help and it says that Version 8 will accomadate previous versions using (.F.) and (.T.). I'm converting from version 5 to version 8. Can anyone help? Thanks, Jim. Tag: Calculated Fields Tag: 203405
  - 13
    - FPW2.6, source not available I keep getting "source not available" in the trace window on a new project I'm working on. It is driving me nuts, I can't quite understand it but it seems to be affected by my default directory...... I have a directory: U:\foxpro\devlog This is where my tables are. I have another directory: U:\foxpro\projects\devlog This is where my source is. If I do this: SET DEFAULT TO u:\foxpro\devlog [open trace window, open program "u:\foxpro\projects\devlog\devlog.exe"] then any program I pick from the list of programs in the project tells me "source not available"] If I do this: SET DEFAULT TO u:\foxpro\projects\devlog then I can see the source in the trace window OK but of course it won't run because the tables aren't there. I've used this method in other directories for years. All of a sudden it's not working, any ideas why? -- TIA Andrew Howell Tag: Calculated Fields Tag: 203404
  - 14
    - Varchars rephrased I have more than 200 remote views that have varchar fields and have always dealt with the pain of padding the fields in order to get the right queries. Now, VFP9 supports varchars but unfortunately the view designer does not do the right conversion, it converts the varchars to char type not helping at all. If I use the SQL editor I can change the type from C to V but that would be a pain. DBSETPROP or coding some hack would help but that is not the question here. Is this a beta issue and will it be fixed in the final release? Tag: Calculated Fields Tag: 203389
  - 15
    - VFP7 weird error after ROLLBACK We have been getting error 1884 Uniqueness of index primarykey is violated in a very strange situation which we can't explain. Basically on saving a record we have code similar to this: ************************************************* BEGIN TRANSACTION IF thisform.beforesave() m.lSuccess = TableUpdate(.F.,.F.) &&successful update IF m.lSuccess m.lAfterSaveSuccess = thisform.aftersave() ENDIF ELSE m.lBeforeSaveSuccess = .f. ENDIF IF !m.lSuccess * Handle errors here endif IF !(m.lSuccess AND m.lAfterSaveSuccess AND m.lBeforeSaveSuccess) ROLLBACK ELSE END TRANSACTION ENDIF ***************************************************** Our beforesave method sometimes includes code that defaults some fields, asks the user some pre-save questions if necessary etc. Occasionally what happens is, if you answer No to a question in the beforesave method and then resave the record, we get this really odd Index violation error. I have discovered that removing the ROLLBACK if beforesave fails seems to stop this error happening. There is nothing to rollback after all, as the tableupdate has not yet been issued. But what I can't explain is why the error 1885 appears in this situation?????? I would have thought issuing a ROLLBACK when there is nothing to rollback would have just been ignored by VFP but it seems to be causing problems. Any ideas anyone? Thanks, Bernie Tag: Calculated Fields Tag: 203387
  - 16
    - Reference to table ALIAS gives error Hi All, Here is a piece of code that gives error: STORE path1 to srcpath STORE path2 to destpath USE (destpath) ALIAS destpathalias USE (srcpath) ALIAS srcpathalias GOTO top SCAN SELECT destpathalias INSERT INTO destpathalias (fld1,fld2,fld3) VALUES(1,345, srcpathalias.fld1) ENDSCAN The error occurs when the following statement is executed SELECT destpathalias The error description says that 'alias destpathalias is not found' Help is appreciated. Thanks. Tag: Calculated Fields Tag: 203386
  - 17
    - VFP8-SQL Baltic-Cyrillic Hi all, need advice how to put into one table two columns with Baltic and Cyrillic charset and print them in one report. MS SQL2000, VFP8, WinXP, Region-Lithuania I found how to enter russian text into VFP forms textbox. Changed textbox fontcharset property to 204-Cyrillic. But when browsing or printing i can't see correct characters. (Report font script properties are diabled) On SQL backend i see only abrakadabra text, but can manually enter right cyrillic text. Then on VFP backend i see only ??????????. Tag: Calculated Fields Tag: 203385
  - 18
    - Saving a file to a users desktop. Hi Guys, How do I export a file to a user's desktop, given I don't want to hardcode the path into my program. I can do this on Win98 easily: EXPORT TO c:\windows\desktop\aodbal.xls TYPE xls But I have a mixed network of unix, 98, XP and 2003 server machines, so how do I do this on a variety of platforms? (ignore unix <g>) I think I spent to long working on Unix and have definitely got left behind a bit!! Steve Tag: Calculated Fields Tag: 203383
  - 19
    - Problem with ImageList Hi everyone, I have a visual class with an ImageList on it. This class is further subclassed. When I use the subclass on a form and place images in the imagelist, the images do not get saved. The next time I MODI FORM..., the images are not set. Abhay Tag: Calculated Fields Tag: 203382
  - 20
    - VFP9 and docking forms Hi All, There is a nice feature in VFP9 that allows dock user-defined forms in main FoxPro window. The question is: is it possible to dock forms in user-defined top-level form? Janusz Czudek WORD Software www.wordsoft.com.pl Tag: Calculated Fields Tag: 203380
  - 21
    - view record no's can i see the record numbers of records which are currently in use. pls help me out i need the solution plslssssssssssssssssss rajesh Tag: Calculated Fields Tag: 203374
  - 22
    - mmc class I've got this far (which isn't very far at all) ox = createobject("MMC20.Application") ox.Document.SnapIns.Add("Computer Management") This unsurprisingly loads up the "Computer Management" MMC snap-in, but it's as far as I've got. What I want to do is check for certain open files at a set time before a backup (no problem), but also shut down any session which is holding the files open, which is where I can see some mileage in the MMC class. I only just found this, but was wondering if anyone else uses it, and where the docs are? Thanks, Neil Tag: Calculated Fields Tag: 203366
  - 23
    - Windows API Function Needed I am in need of a way to create several user accounts on a windows 2000 server using VFP and attach them to pre existing usergroups. This is for a terminal server where we have been doing the bad thing of having multiple users using the same logon to the server and have been having printing problems because of it. Ideal would be able to scan through our user table and create a logon for each one, attach it to a pre-determined group and set the password to blank and require that it be changed on first logon. Is it possible to do this from VFP on a server that we completely control (we have the admin password in other words and we own the server). Any help anyone can give us would be appreciated. -- Cy Welch Senior Programmer MetSYS Inc http://www.metsysinc.com Tag: Calculated Fields Tag: 203359
  - 24
    - any ideas on shell object Hi friends I am using shell object to run an application (which accepts 3 parameters).my code is ***** lc_runcmd = "vipeasyclaim.exe " + lc_runtype + " " + lc_key + " " + lc_woption lo_Shell = createobject("wscript.shell") if type("lo_Shell") = "O" * ---Object was created - Run the command--- QQwState = 4 &&7 && Run the Dos Command in a Minimised Window QQwait = 0 && 0 = NoWait, 1 = Wait lo_Shell.Run(lc_runCmd,QQwState,QQwait) wait clear else * Problem creating the object =messagebox("ERROR: Could not create an object to run the executable ") ENDIF ***** its works fine.sometimes one of these parameters can be empty.in this example say lckey is empty and when i run above code its taking only 1st parameters ignoring 2nd(which is empty) and 3rd param which has value. Any ideas on this please. Thanks -- cheers Tag: Calculated Fields Tag: 203355
  - 25
    - variable changes Hi Friends We've a public variable being used & updated different parts of the our app. i am wondering is there any comman place where wait window displaying varible whnever the value changes ?? I know i can insert watch (in Debug) on this variable which will open debug whenever value changes but wondering abv is possible. Thanks -- cheers Tag: Calculated Fields Tag: 203351

Hi

Is it possible to have a calculated field in VFP. I would like a field to
sum two fields in the same record is this possible?. I am useing V6 but will
soon be changing to V8 or 9.

Kind regard,
--

warrenjw
warrenjw@internode.on.net

Re: Calculated Fields by Paul

Paul
Mon Nov 29 20:54:33 CST 2004

Not directly. You can create them in a select statement though:

SELECT qty, price, qty * price AS amount FROM sales

You can do something similar with BROWSE, too.

"warrenjw" <warrenjw@discussions.microsoft.com> wrote in message
news:2CB3CDB5-A460-432E-BFA3-2F1E9A3220C3@microsoft.com...
> Hi
>
> Is it possible to have a calculated field in VFP. I would like a field to
> sum two fields in the same record is this possible?. I am useing V6 but
> will
> soon be changing to V8 or 9.
>
> Kind regard,
> --
>
> warrenjw
> warrenjw@internode.on.net

Re: Calculated Fields by Zeke

Zeke
Tue Nov 30 04:00:26 CST 2004

You can store the formula in a field, and then use the eval() function (or
macro substitution) to retrieve the value.
Ecample:

create cursor CalcTest (formula c(80))
insert into calctest values('"I can " + "use calculated fields"')
select evaluate(formula) from calctest

Zeke

"warrenjw" <warrenjw@discussions.microsoft.com> wrote in message
news:2CB3CDB5-A460-432E-BFA3-2F1E9A3220C3@microsoft.com...
> Hi
>
> Is it possible to have a calculated field in VFP. I would like a field to
> sum two fields in the same record is this possible?. I am useing V6 but
will
> soon be changing to V8 or 9.
>
> Kind regard,
> --
>
> warrenjw
> warrenjw@internode.on.net

Re: Calculated Fields by Anders

Anders
Tue Nov 30 06:04:45 CST 2004

You can have calculated fields for display or reporting purposes in queries,
reports, grids and browse windows. It's not easy to store automatically
calculated fields in tables, and besides it's redundant, error-prone and
totally against the rules and principles of relational data management.
-Anders

"warrenjw" <warrenjw@discussions.microsoft.com> wrote in message
news:2CB3CDB5-A460-432E-BFA3-2F1E9A3220C3@microsoft.com...
> Hi
>
> Is it possible to have a calculated field in VFP. I would like a field to
> sum two fields in the same record is this possible?. I am useing V6 but
will
> soon be changing to V8 or 9.
>
> Kind regard,
> --
>
> warrenjw
> warrenjw@internode.on.net