Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. vazagothic

    Incorrect results using exponentiation with the INT() function

    ...numbers and different values for SET DECIMALS, I've found something "funny". According to VFP (6.0, 7.0, 9.0) SET DECIMALS TO 7 ? 4981.1 * 100000 && 498110000.0000001 or SET DECIMALS TO 2 ? 4981.1 * 100000000000 && 498110000000000.10 Maybe someone made a mistake in a math library...
  2. vazagothic

    Incorrect results using exponentiation with the INT() function

    ...may be easier to understand here: SET DECIMALS TO 18 l_nNewValue = 4.9811 ? l_nNewValue && 4.981100000000000000 / CORRECT ? l_nNewValue * 10 && 49.810999999999990000 / INCORRECT The same with: SET DECIMAL TO 18 ? 4.9811 * 10*10 && 498.109999999999900000 ? 4.9811 * (10*10) &&...
  3. vazagothic

    Percent of total

    To extend my answer, if you show the data in lets say MyGrid in columns AccountColumn, AmountColumn and PercentColumn (this one is an additional one), simply do: In the Form.MyGrid.AmountColumn.Text1.Valid put: SUM ALL amount TO lnTotalSum THISFORM.MyGrid.PercentColumn.Refresh() Then in the...
  4. vazagothic

    Percent of total

    Question: Do you need to store the percentage in the table ? If it needs to be calculated on-the-fly, then a single change to one row will force you to replace percentage in ALL rows. If you really need to do it that way, then I believe the fastests way would be: SELECT mytable SUM ALL...
  5. vazagothic

    Char Field to VarChar Field in VFP9

    ...Numeric 3 No 22 SCOPE Numeric 3 No ** Total ** 342 I decided to convert the existing Character fields (marked with Red) into new VarChar fields, which hold...
  6. vazagothic

    Variables Equal .. but Different ?

    Ok, found it - and it even fixed my problem with VFP8. The function is called CREATEBINARY() :) Thanks for all your help and for pointing me into the right direction :)
  7. vazagothic

    Variables Equal .. but Different ?

    And to answer the question. It doesn't work when you add CHR(0) in front/back nor add "0h" to the string (that's the way VFP9 marks a BLOB/VarBinary type) I believe VFP8 doesn't fully support BLOBs - that's why there is a problem with processing them. Also - is there a way to FORCE variable to...
  8. vazagothic

    Variables Equal .. but Different ?

    I found that the string I was receiving was of VarBinary/BLOB type which is somewhat supported by VFP8 (the code doesn't even work in VFP6). I did test it with VFP9 Beta and the TYPE() function returned 'Q'.
  9. vazagothic

    Variables Equal .. but Different ?

    Well - I found a solution to my problem, but it is EXTREMLY weird! When I do this: lcDummyPart = LEFT(gcPublicKey,0) && Add 0 bytes from the Dummy Key lcGoodKeyPart = SUBSTR(vaPublicKey, 1) && Append it with the good key gcPublicKeyFinal = lcDummyPart + lcGoodKeyPart The gcPublicKeyFinal...
  10. vazagothic

    Variables Equal .. but Different ?

    Hello All, I've encountered a weird problem while trying to make a Xceed Encryption Library v1.1 work (an ActiveX dll). I know they say on the web site, that it doesn't support VFP, but I believe there is a way to make it work :) Anyway, my problem is as follow - in short (and making it...
  11. vazagothic

    Weird Behaviour of VFP 8.0

    I've tested in on two different computers, with three different tables - the same result. Using SEEK ... ORDER ... DESCENDING gives two different results in VFP6 and VFP8. In VFP6 the table has the index in a descending order (even without using the SET ORDER TO .. DESCENDING to start with)...
  12. vazagothic

    Weird Behaviour of VFP 8.0

    I did answer that :) (look on the screenshots :) In both situations the NEAR and EXACT are OFF
  13. vazagothic

    Weird Behaviour of VFP 8.0

    Nah, I did put the same ones :) The window in VFP8 was cut :) I copy&paste the code I've used in VFP8 into VFP6 and run it from the Command Window, so the code was identical.
  14. vazagothic

    Weird Behaviour of VFP 8.0

    Both ar OFF. Here are links to two screenshots of the BROWSE window taken in both VFP8 and VFP6. They show two different results after performing the same operation on them. VFP6: http://gothic.sitenet.pl/vfp6.jpg VFP8: http://gothic.sitenet.pl/vfp8.jpg Any ideas what could have been wrong ?
  15. vazagothic

    Weird Behaviour of VFP 8.0

    ...VFP6, the field county looks as follow: (I've marked the current record with asterisks) ... AURORA AURORA ARAPAHOE ALBANY ALAMEDA "empty county" ***** "empty county" "empty county" ... while VFP8 returned the same values in a different order: ... "empty county" "empty county" "empty...
  16. vazagothic

    Weird Behaviour of VFP 8.0

    My fault, I was upset about the not working code and I made a hastly mistake with the help :) But it doesn't change the fact, that the code didn't work with VFP8. Only the mentioned change had restored its proper behaviour. So, what was the cause for VFP8 to stop working ?
  17. vazagothic

    Weird Behaviour of VFP 8.0

    ...to the previous code made it work again .. scNameFile = "Names_MM" USE names_MM SET ORDER TO cty_owner DESCENDING SELECT (scNameFile) GO BOTTOM * Get the first value from table lcCountyValue = county * Scan the entire table using INDEX value DO WHILE .T. ? RECNO() * Scan in the...
  18. vazagothic

    Weird Behaviour of VFP 8.0

    ...value), next jumps to the first occurence of this value .. and so on Here's the code - I've modified it a bit, so it would work as a whole piece: *** CODE STARTS HERE *** scNameFile = "Names_MM" USE names_MM SET ORDER TO cty_owner SELECT (scNameFile) GO TOP * Get the first value from...
  19. vazagothic

    How to use part of Concatenated Index ?

    Brian, so why does the INDEX ON county TAG county works fine ? I know that the VFP has to perform more operations while using concatenated indexes, but I wouldn't suspect it takes that much time. According to Special Edition Using VFP 6...
  20. vazagothic

    How to use part of Concatenated Index ?

    Ramani, still slow :( it took 1.5 minutes to find a little bit over 50k records. Here's the real code I use: * First, close all open tables CLOSE TABLES ALL * Open the table we're using for testing USE c:\tmp\test001.dbf * Use the concatenated index (County + OwnerLName) SET ORDER TO...

Part and Inventory Search

Back
Top