MS SQL insertion via VB (Query question)

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 375,201 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,254 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MS SQL advertiser:

Thread Tools Display Modes

Views: 636 | Replies: 1 | Solved

•

Join Date: Jun 2007

Posts: 49

Reputation: Mr.Wobbles is an unknown quantity at this point

Rep Power: 2

Solved Threads: 2

Mr.Wobbles Mr.Wobbles is offline

Offline

Light Poster

MS SQL insertion via VB (Query question)

Apr 25th, 2008

I am trying to insert tables into a database that I created at runtime, I am using MS SQL Server Express, and I have tested this query and it works, in the sense that a table is created. However the small text field (stringText [char]) only has a length of 1, that is not very useful... When I try to specify a length i.e. varchar(MAX) or varchar(255) or any other value really it gives me an error that Column, parameter, or variable #2: Cannot find data type varchar(255).

I have set up a msg box to show the SQL that I generate whenever I run the program. It is as follows:

Help with Code Tags

(Toggle Plain Text)

---------------------------
Portfolio Generator 3.0
---------------------------
Inserting into Database: 
BEGIN TRANSACTION CREATE TABLE [dbo].[testTable] ( [testTableID] [int] NOT NULL PRIMARY KEY, stringText [char] NULL DEFAULT (''), largeText [text] NULL DEFAULT (''), integerVal [int] NULL DEFAULT ((0)), doubleVal [int] NULL DEFAULT ((0)), dateVal [datetime] NULL DEFAULT (04/25/2008), boolVal [tinyint] NULL DEFAULT ((0))) COMMIT

Any questions about something I may have left out will be happily answered, and any help that is given, thank you in advance.

Mr.Wobbles~

•

Join Date: Jul 2005

Location: Dallas, TX

Posts: 481

Reputation: campkev is an unknown quantity at this point

Rep Power: 4

Solved Threads: 19

campkev

Offline

Posting Pro in Training

Re: MS SQL insertion via VB (Query question)

May 9th, 2008

get rid of the square brackets around the varchar(255) and it will work fine.

For that matter, why are you putting them around the datatypes anyway? I've never seen anyone do that.