Re: [sqlite] I Need database fot some test

[Stef Mientki]

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


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] I Need database fot some test

[Dennis Cote]

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


Dennis Cote

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

RE: [sqlite] I Need database fot some test

[Griggs, Donald]

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

Re: [sqlite] I Need database fot some test

[Stef Mientki]

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
http://pic.flappie.nl


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] I Need database fot some test

[Dennis Cote]

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

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] I Need database fot some test

[Marco Bambini]

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 known Microsoft  
Northwind

sample that can be found for MS Access and SQL Server.





--
cheers,
Stef Mientki
http://pic.flappie.nl


-- 
---

To unsubscribe, send email to [EMAIL PROTECTED]
-- 
---





-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] I Need database fot some test

[Stef Mientki]

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 known Microsoft Northwind
sample that can be found for MS Access and SQL Server.


  


--
cheers,
Stef Mientki
http://pic.flappie.nl


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] I Need database fot some test

[Mikey C]

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: 
http://www.nabble.com/I-Need-database-fot-some-test-tf3342105.html#a9340880
Sent from the SQLite mailing list archive at Nabble.com.


-
To unsubscribe, send email to [EMAIL PROTECTED]
-