SELECT with two (or one) of the three fields - probably with loads of OR's
after the intial search returns 0 rows.
Messy maybe but I don't see any other way.
You can't use a SELECT like you are currently using with fields of the same
name in different tables - I'm surprised you are not throwing
Alec
Exact matches on float values are notoriously unreliable - the problem with
the math is that it can often turn out the value at something like :-
123.539
which won't produce an equality match.
For this you would probably better use a DECIMAL field.
And
Robb
Exact error messages would be good at this point and it may be possible that
their version of MySQL may not fully support the command you are trying to
perform although with an UPDATE TABLE I would hope this unlikely.
I think you probably need to provide:-
SQL statement you are trying to e
Broadly speaking, I would agree with Cal becasue MySQL is, by its very
nature, a server application..
However, you can easily emulate it being an application by adding net
start(s) and net stop(s) to the beginning and end of your application - you
may have timing issues, however, with the start a
John
ALTER TABLE ADD [column] col_declaration
is what you are after I think - no need to go making another table
For example:-
ALTER TABLE example_table ADD example_column INT UNSIGNED NOT NULL
AUTO_INCREMENT
With the greatest regards to Paul DuBois whose marvellous book MySQL this is
unashem
Micke
Can't really speak for Professional but I have it running fine on Server and
Advanced Server.
If my memory is right then 1067 is normally that the service cannot respond
to the control function effectively. Together with the fact that you cannot
remove the service after uninstall, this sug
