Search results for query: *

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

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

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

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.

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

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

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

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.

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

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

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

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

That's sad... Thanks.

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.

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

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

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.

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

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

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