Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
| FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 7 of 7
Search took 0.02 seconds.
Search: Posts Made By: Old Pedant
Forum: BOOK: SQL Functions Programmer's Reference February 17th, 2009, 02:26 AM
Replies: 12
Views: 11,340
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,340
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,340
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,340
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,340
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,340
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,340
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

 


All times are GMT -4. The time now is 12:02 PM.


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