Search results for query: *

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

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

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.

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.

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

One more for today: I use phpMyAdmin to administer my database. I have 60 scripts to create 60 tables and there will be other scripts. Is it possible to run the scripts all at once in a batch ? If this is not possible with phpMyAdmin, what's the alternative ? Thanks.

Hello, I created my database with MySQL connection collation : utf8_general_ci. However, in the tables I create, without specifying any collation, all char/varchar/... fields have Collation: latin1_general_ci . Why isn't the main utf8_general_ci collation automatically passed on to the fields...

Hello ! I have the scripts for creating all the tables in a SQL Server database and would like to "translate" them so that I can create the same tables in a MySQL database. Any help is appreciated. Thanks.

Hello , I'm looking at a program written by someone else... In the program, a specific function is called like this: ... showdata(this) ... Down the road... procedure showdata(pParm1, pParm2) ... ... return In this procedure I can see the values of pParm1(an object), pParm2(a logical value)...

Trying co create a cursor from a memo field that contains a xml structure. (The memo field is in fact on a remote view of a Access table). I tryed to validate the contents with the free validator from http://www.w3schools.com/xml/xml_validator.asp and it gives no errors. However, VFP gives...

Hi all, I use RESOURCE=OFF in my config.fpw to avoid creating FOXUSER.* files. This is good for that purpose BUT I think it also stops updating _command.prg with the new commands I type or are echoed in command windows. Is this possible ? Is there a way to avoid the creatin of FOXUSER.* and in...

Hello all, I need to change the name of a table in a Access 2007 database. The code below(VBA) does what I need BUT I need it in VBScript. Can someone help me "translate" it ? Sub changetablename() Set db = CurrentDb() For Each n In db.tabledefs tablename = n.Name If tablename = "_help...