Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Showing results 1 to 7 of 7
Search took 0.00 seconds.
Search: Posts Made By: Old Pedant
Forum: BOOK: SQL Functions Programmer's Reference February 17th, 2009, 02:26 AM
Replies: 12
Views: 11,708
Posted By Old Pedant
N.B.: In place of step 12, there, you could...

N.B.: In place of step 12, there, you could instead RIGHT CLICK on the name of the SP, "AddFullComplaint" in the list of stored procedures and then click the "Execute" mini menu item.

You will...
Forum: BOOK: SQL Functions Programmer's Reference February 17th, 2009, 02:22 AM
Replies: 12
Views: 11,708
Posted By Old Pedant
TRY THIS !!!!

Here is *EXACTLY* how I got it all to work in VWD Express 2005.

(1) In the Database Explorer, I made sure I had a connection to the database I wanted to add the tables and SPs to. It just so...
Forum: BOOK: SQL Functions Programmer's Reference February 16th, 2009, 10:25 PM
Replies: 12
Views: 11,708
Posted By Old Pedant
Well, I *did* say that was all off the top of my...

Well, I *did* say that was all off the top of my head.

And when I actually tried to do it, SQL Server objected to the use of INSERT inside of a FUNCTION.

So I had to "inline" all those...
Forum: BOOK: SQL Functions Programmer's Reference February 13th, 2009, 06:16 PM
Replies: 12
Views: 11,708
Posted By Old Pedant
You don't have to set the foreign key...

You don't have to set the foreign key constraints. It's much better database practice, and it will catch any errors you make in linking records from one table to another, but if the contraints...
Forum: BOOK: SQL Functions Programmer's Reference February 12th, 2009, 06:29 PM
Replies: 12
Views: 11,708
Posted By Old Pedant
Okay...100% off top of my head..

Based on what you said:And assuming that the tables look something like this:

TABLE Complainant
complainantID IDENTITY PRIMARY KEY,
lastname NVARCHAR(50),
firstname NVARCHAR(50),
...
Forum: BOOK: SQL Functions Programmer's Reference February 12th, 2009, 01:29 AM
Replies: 12
Views: 11,708
Posted By Old Pedant
Just because you are trying to insert to so many...

Just because you are trying to insert to so many tables, I would probably opt for the "brute force" approach. Also known as the ASP.NET Version 1 approach.

Using conn As New SqlConnection(...your...
Forum: BOOK: SQL Functions Programmer's Reference February 10th, 2009, 05:47 PM
Replies: 12
Views: 11,708
Posted By Old Pedant
Why a dataset??? Are you selecting records...

Why a dataset???

Are you selecting records from some table and then allowing them to be edited? Is that why the dataset?

If your <FORM> contains "all new" data, I don't see any reason for a...
Showing results 1 to 7 of 7

 




Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.