Re: [sqlite] create table command from listview in vb.net

2006-07-11 Thread John Newby
Hi Dennis, Yeah I know, I have posted several VB forums regarding this matter, I was just hoping there might have been an SQLite user that may have came accross this in the past. Sorry to have bothered you all. Thanks again John. On 11/07/06, Dennis Cote <[EMAIL PROTECTED]> wrote: John

Re: [sqlite] create table command from listview in vb.net

2006-07-11 Thread Dennis Cote
John Newby wrote: Do you know of a way I could get the details from the listview? John, This question is far more likely to be answered on a Visual Basic mailing list rather than this one. HTH Dennis Cote

Re: [sqlite] create table command from listview in vb.net

2006-07-11 Thread C.Peachment
Sorry, but I don't use proprietary programming languages and can not provide assistance with Visual Basic. On Tue, 11 Jul 2006 12:00:34 +0100, John Newby wrote: >Hi, thanks for your speedy reply, >Yes, you have understood my code correctly, this is the create table >statement, and at the time

Re: [sqlite] create table command from listview in vb.net

2006-07-11 Thread John Newby
Hi, thanks for your speedy reply, Yes, you have understood my code correctly, this is the create table statement, and at the time of execution all column names are known to the form, I am just unsure as how to get them from the listview to place into a create table statement, I think I will need

Re: [sqlite] create table command from listview in vb.net

2006-07-11 Thread C.Peachment
If understand your code correctly, this line creates a table with a single column. dbConn.createTable("CREATE TABLE " & tblName & "(" & fldName & " " & fldAttribute & ")") You describe a user interface to be used to create tables with multiple columns. You must do one of two

[sqlite] create table command from listview in vb.net

2006-07-11 Thread John Newby
Hi, I am creating a front-end to the sqlite DBMS using VB.Net 2002. I have managed to get the name of the table, field names and types from user input displayed into a listview but I can only get the Create table command to accept the last input values, so if the table has more than one