thanks Dennis,
Single quote delimit a string literal. Double quotes delimit a quoted
identifier (i.e a column or table name etc that contains special
characters such as a space).
I just checked Sybase Manual, and there it's exactly as you say.
--
cheers,
Stef Mientki
http://pic.flappie.nl
Stef Mientki wrote:
thanks Dennis, Marco,
And the standard SQL syntax should work from any standard compliant
database program.
SELECT * FROM "Order Details"
I'm just a novice,
and although both suggested solutions work,
I thought SINGLE QUOTES were thé standard ?
Single quote delimit
Regarding: "... I thought SINGLE QUOTES were thé standard ?"
I believe single quotes are the standard for literal strings, but double quotes
for table names.
-
To unsubscribe, send email to [EMAIL PROTECTED]
thanks Dennis, Marco,
And the standard SQL syntax should work from any standard compliant
database program.
SELECT * FROM "Order Details"
I'm just a novice,
and although both suggested solutions work,
I thought SINGLE QUOTES were thé standard ?
--
cheers,
Stef Mientki
Marco Bambini wrote:
The space between Order and Details is the problem.
This syntax:
SELECT * FROM [Order Details]
works fine with SQLiteManager.
And the standard SQL syntax should work from any standard compliant
database program.
SELECT * FROM "Order Details"
Dennis Cote
The space between Order and Details is the problem.
This syntax:
SELECT * FROM [Order Details]
works fine with SQLiteManager.
Regards,
---
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/blog/
http://www.sqlabs.net/realsqlserver/
On Mar 7, 2007, at 7:43 PM, Stef Mientki wrote:
Did anyone test this database ?
With 3 out of 4 programs I'm not able to read the table "Order Details",
does anyone what's the problem here ?
thanks,
Mikey C wrote:
Here is a database http://www.nabble.com/file/6997/Northwind.db Northwind.db
It is an exact SQLite implementation of the well
Here is a database http://www.nabble.com/file/6997/Northwind.db Northwind.db
It is an exact SQLite implementation of the well known Microsoft Northwind
sample that can be found for MS Access and SQL Server.
--
View this message in context:
8 matches
Mail list logo
