Viewing 15 posts - 106 through 120 (of 120 total)
The first thing you should do is put your two database writes into a transaction. This will ensure that they will either both get committed or that both will be...
March 22, 2002 at 3:50 am
Check out ADO 2.6 there is a flag you can set on the recordset object(PersistXML from memory) which will return your recordset in XML. Neat huh?
March 22, 2002 at 3:36 am
Don't rightly know is the answer. It'll depend on how detailed SQLSERVER is when returning the error to ADO. To be honest with you I tend to avoid cascading deletes...
March 21, 2002 at 11:39 am
I'd go with Andy. The Text-File/DTS load method would be my preffered route. XML's great particularly with handling complex data-set structures, but yours is simple.
DTS gives you the oppurtunity to...
March 21, 2002 at 11:34 am
OK The trick is in capturing the error and doing something with it. To do this I use a small footprint object to handle all database access. This has two...
March 21, 2002 at 3:49 am
This is an intriguing question. Could you elaborate on the thinking behind passing the recordset INTO a stored procedure.
Where's the recordset coming from?
What is the stored procedure...
March 21, 2002 at 1:27 am
This might be a dumb question, but on your table defs I can't see any indexes, you do have some don't you?
Assuming you have indexes I notice you're using a...
March 20, 2002 at 12:44 pm
Steve is right VBSCRIPT and ASP will handle the database interaction OK
But you will still need some HTML to present your pages to your users. You als need to...
March 20, 2002 at 1:20 am
Try This. I did it with two tables (tbl_new_1 and tbl_new_2) both containing columns for stock_id VARCHAR(10), description VARCHAR(20). Primary key on stock_id
INSERT dbo.tbl_new_1(
stock_id,
description)
SELECT...
March 19, 2002 at 8:47 am
You find yourself padlocked to your PC and you have and intraveneous Coffee-Drip (or perhaps Herbal Tea) inserted in your arm
March 19, 2002 at 6:59 am
You may find some interesting little challenges if your SP's use good ORACLE standards like %ROWTYPE and %TYPE. For example I've not found any equivilant of %ROWTYPE for Cursor handling...
March 19, 2002 at 6:52 am
YUP I use DELPHI 5 accessing SQLSWERVER through ADO (direct ADO TLB not ADO Express)
Works uncommonly well! But I have to admit to being an MS person as well my...
March 19, 2002 at 6:42 am
Thank you Antares686. So Simple, So Elegant So.... SQL Server.
The more I work with this product the more I like it. Yes there are things to curse at, but then...
March 14, 2002 at 9:09 am
The inserts we're interested in hit the db singly (not part of a batch input). As to the code well I tried just adding FOR INSERT, UPDATE and leaving the...
March 14, 2002 at 8:49 am
Viewing 15 posts - 106 through 120 (of 120 total)