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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mirkado227

  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...
See more

Part and Inventory Search

Back
Top