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 biv343 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: *

  • Users: mirkado227
  • Order by date
  1. mirkado227

    Week() does not return the correct value

    Hi Mike Yes, you are right. I interpreted the week-funktion with this parameteres wrong. But: there cannot be a 53th week of a year. Is this correct?
  2. mirkado227

    Week() does not return the correct value

    With 31.12.2005 I got another strange result: SET FDOW TO 2 && week starts with monday SET FWEEK TO 1 && The first week contains January 1st ? WEEK({31.12.2005}) && returns 53 (correct) ? WEEK({31.12.2005},1) && returns 53 (correct) ? WEEK({31.12.2005},1,2) && returns 1 (incorrect)
  3. mirkado227

    Week() does not return the correct value

    SET FDOW TO 2 && week starts with monday SET FWEEK TO 1 && The first week contains January 1st ? WEEK({31.12.2006}) && returns 1 but should return 53 ? WEEK({31.12.2006},1) && returns 1 but should return 53 ? WEEK({31.12.2006},1,2) && returns 53 It seems, that the set instructions...
  4. mirkado227

    MySQL and security problem

    Hallo everybody Since more than 10 years I am working with Vfp. Mostly with his native database, sometimes with a local MySQL server. In my current project the MySQL server is in a datacenter where users, who are running my program, are allowed to access the database from internet. - Because I...
  5. mirkado227

    SQL Select behaves not like Seek

    @Stella740pl Sorry for my delayed answer. I changed all my SQL queries to SELECT * FROM Cards Where STRCONV(KartNr,15) == STRCONV(cKartNr,15)
  6. mirkado227

    SQL Select behaves not like Seek

    @Stella740pl I changed all my code using now STRCONV( ..., 15) and everything works fine now. Thanks again.
  7. mirkado227

    SQL Select behaves not like Seek

    @Stella740pl With STRCONV() everythink runs fine. E.g. SELECT * FROM Cards Where STRCONV(KartNr,15) == STRCONV(cKartNr,15) returns only the specific record. Thanks for this hint! But I am still confused, why the orginal code SELECT * FROM Cards Where KartNr == cKartNr returns not the...
  8. mirkado227

    SQL Select behaves not like Seek

    @Stella740pl I understand your argument with the deleted problem. But there are no duplicate records. And the SELECT statement returns all records, not only a few: all! Thanks for the article. I also think, that there I am able to find the answer.
  9. mirkado227

    SQL Select behaves not like Seek

    @Stella740pl I will read the article. The answers of your questions are: - The status of SET DELETED is ON - Yes, only 1 record
  10. mirkado227

    SQL Select behaves not like Seek

    Yes, of course!
  11. mirkado227

    SQL Select behaves not like Seek

    An addendum: I'm using Vfp9 under W2k
  12. mirkado227

    SQL Select behaves not like Seek

    Say we have a table created like CREATE TABLE Cards (KartNr C(6) NOCPTRANS) The index is created with: SET COLLATE TO "machine" INDEX ON kartnr TAG kartnr_idx KartNr contains binary informations. With the browse command there are displayed as garbage characters. To display them, I have to...

Part and Inventory Search

Back
Top