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!

Search results for query: *

  • Users: sebes
  • Order by date
  1. sebes

    SQL syntax with EXISTS

    Well, I think I did turn it off, then tried again with same results. I did this: SET GLOBAL sql_mode = "" NOW, I ask questions here because I don't know many things and I want to learn. Someday, when I'll know more, maybe I'll also answer questions here, because this is the purpose of this...
  2. sebes

    SQL syntax with EXISTS

    Ok. How is it related ? How can I make it work ? Can you give a sample where I can see this working ?
  3. sebes

    SQL syntax with EXISTS

    This is a huge system and there are many situations where such a query is necessary. I don't think it would help here to go into any details. What I need at this point is to be able to run the queries like select 1 where exists(select * from tablename where condition). What should I configure...
  4. sebes

    SQL syntax with EXISTS

    What mode are you using ? I choose ANSI because it allows to use || as concatenation operator. This is very helpful since I have to convert a whole system where we already have thousands of SQL statements. Thanks.
  5. sebes

    SQL syntax with EXISTS

    This line: select 1 where exists (select * from pers) gives this message: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where exists (select * from pers)' at line 1 This line: select 1 from tbl...
  6. sebes

    SQL syntax with EXISTS

    I'm "translating" these from VFP, there are tons of similar statements and I was hoping I don't have to "insert" a "FROM" because in most cases the statement is just to determine if there are any records and there really is no "FROM" for the first part of the statement. Now, what's the trick...
  7. sebes

    SQL syntax with EXISTS

    Is this correct ? Select 1 where exists(select * from tablename2) Or does it have to be like this Select 1 FROM tablename1 where exists(select * from tablename2) The question is "is FROM mandatory ?" From my tests only the second one works but I would really like to have the first one work...
    • sebes
    • Thread
    • Replies: 12
    • Forum: MySQL
  8. sebes

    UDFs for beginners

    That rings a bell. Maybe there's a confusion here. I'll put things in order before I go any further. IF I go with stored procedures, what is the best place to start learning the available commands and the syntax ? Thanks for your help.
  9. sebes

    UDFs for beginners

    It's not my decision. I just try to do the work. It has to be UDF. Thanks again.
  10. sebes

    MySQL ODBC Driver needed - 3.51

    Did you find it ? I have 3.51.28. If that helps send me an email at george@moodysoft.com and I'll send you a link for this. -sebes
  11. sebes

    UDFs for beginners

    I have the UDFs for SQL Server and I'm trying to translate them. Example for testing if "something" is empty() by our own rules: drop function dbo.Empty go create function dbo.Empty (@pcSource varchar(4096)) returns bit as begin if @pcSource is null or @pcSource = ' ' return 1 return 0...
  12. sebes

    UDFs for beginners

    Hello, MySQL documentation on this page : http://dev.mysql.com/doc/refman/5.1/en/udf-compiling.html says: This process is described below for the example UDF file sql/udf_example.c that is included in MySQL source distributions Where can I find these examples and any beginner level...
    • sebes
    • Thread
    • Replies: 7
    • Forum: MySQL
  13. sebes

    Concat or +

    That's sad... Thanks.
  14. sebes

    Concat or +

    hello, Can I use something like this in MySQL ? Select string1 + string2 as field name ? OR do I have to use select concat(string1, string2) as fieldname ? Thanks.
    • sebes
    • Thread
    • Replies: 2
    • Forum: MySQL
  15. sebes

    CHR function in MySQL

    Right, I tested it already and it works. Now, can I use something like this ? Thanks
  16. sebes

    CHR function in MySQL

    Ca I use it in something like: SALECT .... WHERE field = CHAR(66,65,68 using ASCII) ? Thanks.
  17. sebes

    CHR function in MySQL

    Hola, From what I understand, there's no CHR() function in MySQL or something to correspond to CHR from VFP. (|Example: CHR(65) returns "A") If anybody has an idea how to "simulate" it, please advise. Thanks.
    • sebes
    • Thread
    • Replies: 4
    • Forum: MySQL
  18. sebes

    Project won't recompile all files

    Thanks all. I've found the solution: one file was included by mistake in another project. (It may be in any number of project BUT not included). Excluding the file from the other project solved the problem. -gl
  19. sebes

    Project won't recompile all files

    Hola, I'm using VFP 9 SP2. My project doesn't recompile all file as expected when I check that option. No error message but no work either. Usually, when Recompiling, it flashes the name of each file but not any more. Even if I make a change to a file or include/exclude from the project...
  20. sebes

    Running scripts batch

    How do I install MySQL Command Line tool on my locan computer ?

Part and Inventory Search

Back
Top