Jarosław Staniek wrote:
Drew Sanford said the following, On 2007-05-14 20:42:
Jarosław Staniek wrote:
Drew said the following, On 2007-05-14 14:52:
As promised, I'm attaching a database I just threw together. It
only has
four entries, and one query, but clearly the query should list
everything in
table1.
SELECT * FROM table1 ORDER BY "key"
^^^^
A quick note: "key" is reservered word in sql and kexi cannot deal
with it yet properly by adding "" or by displayng appropriate warning.
Could you change the column name to something neutral and try again
and let me know?
Sorry. There's a new table called table11 in there with basically the
same data.
There is _still_ a column called "key" in table11 you have sent me.
Remove the column and our query should work.
Also queries that do not use the column work with table11, e.g.:
SELECT vacation, users, date, vacation, id FROM table11 ORDER BY id;
I see where this is going. Actually, in the original db that I created,
there is no conflict with "key" rather it appears to be start. However,
I can specify that and get (correct) output from the queries. It looks
like the problem is related specifically to using * in the select
statement. Kexi keeps dropping the *.
_______________________________________________
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "[EMAIL PROTECTED]"
