Well the [ ] aren't a .NET thing, SQLite supports them, using [ ] are a
standard supported SQLite feature and they make you're life way, way,
easier, see: http://www.sqlite.org/lang_keywords.html
[keyword] A keyword enclosed in square brackets is always understood as
an identifier. This is not
Darn, I was going to have 500,000 columns in my table. The, each column
would be named like this: Record1, Record2, Record3, and so on up to
Record500. Each column type was going to be varchar and I was going to
store my first record in xml format in my Record1 column of the first row,
and so
I agree, it's like creating one object (C++, Java, C#) in an application
with 40,000 methods, you might be using an object oriented language but
you aren't using OO techniques. I would hone it down before SQLite
developers exploit this and you're stuck supporting it, it could come back
to haunt
> What's the proper way to ensure that ' characters are properly quoted but
> don't show up in the output?
Honestly, we use the SQLite .NET managed driver and pass all data in via
parameters, therefore we have no escape issues and more importantly no SQL
injection woes, if you're taking data
For what it's worth, if your in a hurry, try our product, it's Free.
Basically, you launch our product, connect to your database and we'll spit
out fully functional VB.NET or C# data/business entities using your
database meta-data as the input. These objects (classes) do mostly
everything that you
://www.mygenerationsoftware.com/dOOdads/VBNet_MasterSample.aspx
Mike Griffin
MyGeneration Software
http://www.mygenerationsoftware.com
I have a strange problem, I can do this:
UPDATE [Employees] SET
[EMAIL PROTECTED],
[EMAIL PROTECTED],
[EMAIL PROTECTED],
[EMAIL PROTECTED]
WHERE
[EMAIL PROTECTED]
But I can do this,
SELECT [LastName],[FirstName] FROM [Employees]
I have to remove the []
Is it possible to query the database to see if it's 2.x or 3.x, we need to
know if the rowid's are 32 or 64 bit and we don't know what version we
might be running on?
Okay, I posted there, but can you tell me if this is correct SQL for the
AUTOINCREMENT situation, SQLite3 didn't complain at all so I assumed it
was okay?
CREATE TABLE NewEmployees(EmployeeID INTEGER PRIMARY KEY
AUTOINCREMENT, LastName TEXT, FirstName TEXT);
> This question is probably better
I used this SQL:
CREATE TABLE NewEmployees(EmployeeID INTEGER PRIMARY KEY AUTOINCREMENT,
LastName TEXT, FirstName TEXT);
and using SQLite3.exe did this
SQLite3 employees.db
.read create.sql
.exit
which created my database but no tools nor the SQLite.NET provider can
read it, I get the error
yword, we're adding support for SQLite 3.x in
>> > MyGeneration, we'll also be releasing an instance of our
>> > dOOdads .NET architecture (C# and VB.NET) for SQLite in about a week.
>> >
>> > Anyway, can anybody help me ? Graphical Tool or db with
>> > AUTOI
hem)
http://msdn.microsoft.com/library/en-us/dnvs05/html/adonet2schemas.asp
Since SQLite has no OLEDB driver forget the schema rowset, you could
create pragma's that match the SQL-92 INFORMATION_SCHEMA Views.
Mike Griffin
MyGeneration Software
http://www.mygenerationsoftware.com
dOOdads .NET architecture (C# and VB.NET) for SQLite in
about a week.
Anyway, can anybody help me ? Graphical Tool or db with AUTOINCREMENT
column in it.
Mike Griffin
MyGeneration Software
http://www.mygenerationsoftware.com
Well, I can help here a little, having provided meta data for 11 different
databases via our product MyGeneration. We do support SQLite too,
including foreignkeys and all the good stuff. However, concerning columns
contained results sets from say a select statement that's another story,
you're
MyGeneration is a Code Generator / OR Mapper that supports SQLite (it's
free). We are creating a new .NET architecture that will also support
SQLite (among 10 other DBMS systems) if you are interested in becoming one
of our SQLite adivsors and contributors see this site:
15 matches
Mail list logo