|
-
Jun 23rd, 2005, 11:07 AM
#2
Addicted Member
Re: TSQL and Autogenerate
I don't know anything about the scripting deal, but I can tell you that the insert statement won't work.
You set your blahID as the primary key, not null. And you are trying to set your PK as a null value, or at least a non-integer from what you typed. So you can't do that.
The blahID has to have an integer value in it for the insert statement to work.
-Side note:
And I believe you would just need:
insert into blah(mytext)
values('some text value')
If you get your PK field to autoincrement, because the blahID would automatically insert a new value upon insert of the mytext field.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|