anyone can help me?
----- Original Message ---- From: Igor Tandetnik <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Thursday, November 27, 2008 12:07:31 PM Subject: Re: [sqlite] how do this stuff in sqlite "Rachmat Febfauza" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > i have query that don't work in sqlite but in mysql work and make > good result. Define "don't work". Do you get an error? What's the error text? > CREATE TABLE hasil1 (Code char(5), Level vachar(8), Category varchar > (50), Product varchar(60), Location varchar(50), Begin datetime, End > datetime, Difference integer, PRIMARY KEY > (Code,Level,Category,Product,Location,Begin,End)); Begin and End are keywords in SQLite (SQL is case insensitive). If you insist on naming your columns this way, you have to enclose the names in double quotes, just as you did when creating awal1 and akhir1. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
