[sqlite] How To concatenate two fields in one

Hello everyone, This is my first message. I have a table called Students: IDStudent char(10) PRIMARY KEY, NOT NULL Name char (30) NOT NULL Surname char(30) NOT NULL What I would like to achieve is the same as writing in SQL Server SELECT IDStudent, Name + " - " + Surname AS Nominative FROM

[sqlite] sqlite and referential integrity

Hello to everyone, I planning to start using sqlite but first I have a question, sqlite supporting the referential integrity as access? Excuse for my bad english Thanks a lot -- Alessio Forconi ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] How to create a Datatable [first steps of newbie]

Hello everyone, I am making the first steps with the programming and I want to help create a DataTable from a database sqlite with C #. Can you give me an example of how do I create it without using a dataset? Thank you very much for your help. ___

Re: [sqlite] How to create a Datatable [first steps of newbie]

> conn); > DataTable dt = new DataTable(); > apt.Fill(dt); > conn.Close(); > > > > > On Thu, Jan 8, 2009 at 11:28 AM, Alessio Forconi <forco...@gmail.com> wrote: > >> Hello everyone, >> >> I am making th

Re: [sqlite] How to create a Datatable [first steps of newbie]

eak in the email. This will > create a new, empty database named database.db in the directory where > your application is running. > > On Fri, Jan 9, 2009 at 7:32 AM, Alessio Forconi <forco...@gmail.com> wrote: > >> Thanks... >> >> I get this error >

Re: [sqlite] How to create a Datatable [first steps of newbie]

ike? > > On Fri, Jan 9, 2009 at 2:36 PM, Alessio Forconi <forco...@gmail.com> wrote: > >> Thanks for your suggestion, I do not think that is the problem because >> the connection is the one used with success in other parts of the >> program, you show the code tha

Re: [sqlite] How to create a Datatable [first steps of newbie]

.com/forums/p/532/532.aspx > > On Sun, Jan 11, 2009 at 12:18 PM, Alessio Forconi <forco...@gmail.com> wrote: > >> It means that the connection that I use in the code that I showed you is >> the same as that used in other parts of the program, only that we do not

[sqlite] Strange behavior with connection SQLite database

Hello everyone, I'm developing an application with C # and I am finding difficulties. To retrieve data from the database using this method: string sqlString = "SELECT * FROM Proclamatori"; conn = new SQLiteConnection(connString); try { conn.Open(); SQLiteDataAdapter adpt = new

[sqlite] SELECT that returns the name of the fields

Hi all, I am a novice with SQLite and I wonder if there is a select that returns the names of the fields in the table? Thanks and sorry for my bad English -- Alessio Forconi ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org

Re: [sqlite] SELECT that returns the name of the fields

Thank you, pragma is perfect! Alessio Forconi Il 12/03/12 22:47, Roger Binns ha scritto: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 12/03/12 14:42, Alessio Forconi wrote: I am a novice with SQLite and I wonder if there is a select that returns the names of the fields in the table

[sqlite] Query to remove duplicate values ​​in a field?

with a query? Thank you. -- Alessio Forconi ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Query to remove duplicate values ​​in a field?

nning of the string using || like this: 'Location: '||FieldToupdate Simon. Alessio Forconi Il 27/03/12 18:12, Alessio Forconi ha scritto: Hello everyone, is there a way to update a field in this way? Fieldtoupdate: 1) Location: Rome. Location: New York. 2) Location: Florence. Location: Tuscany