Click here to Skip to main content
15,438,202 members
Home / Discussions / Database
   

Database

 
AnswerRe: checking database Pin
Colin Angus Mackay15-Oct-05 2:07
MemberColin Angus Mackay15-Oct-05 2:07 
GeneralRe: checking database Pin
abhinish16-Oct-05 0:01
Memberabhinish16-Oct-05 0:01 
Questionado vc++ - datetime string or numbers to variant Pin
compoundeye14-Oct-05 20:55
Membercompoundeye14-Oct-05 20:55 
Questioncomplex query Pin
Joshua Lunsford14-Oct-05 12:02
MemberJoshua Lunsford14-Oct-05 12:02 
AnswerRe: complex query Pin
Colin Angus Mackay14-Oct-05 13:14
MemberColin Angus Mackay14-Oct-05 13:14 
GeneralRe: complex query Pin
Joshua Lunsford17-Oct-05 11:49
MemberJoshua Lunsford17-Oct-05 11:49 
AnswerRe: complex query Pin
miah alom17-Oct-05 4:46
Membermiah alom17-Oct-05 4:46 
QuestionADO.NET Update / delete without primary keys Pin
Jasonc22114-Oct-05 11:10
MemberJasonc22114-Oct-05 11:10 
I'm working on a program that needs to be able to update/delete rows in tables which do not (for whatever reason) have primary keys. I've done extensive searching on the subject and so far all I can turn up are suggestions to write my own custom update/delete SQL statements and attach them to the DataAdapter. The problem with this is that this program doesn't connect to one or two tables exclusively; rather, it allows the user to bring up -any- table.

The only thoughts my coworkers and I have had are to use Oracle's (we're using and Oracle database btw) rowid property, or to maintain a server-side cursor and somehow update/delete using that. The problem with these two solutions is:

1) Oracle's rowid is based off the row's location on the hard drive and is unreliable for uniquely referring to a row
2) I've been reading that ADO.NET has no server-side cursor

Does anyone have -any- ideas at all on how to solve this problem?
AnswerRe: ADO.NET Update / delete without primary keys Pin
miah alom17-Oct-05 5:52
Membermiah alom17-Oct-05 5:52 
GeneralRe: ADO.NET Update / delete without primary keys Pin
Jasonc22117-Oct-05 7:33
MemberJasonc22117-Oct-05 7:33 
GeneralRe: ADO.NET Update / delete without primary keys Pin
miah alom17-Oct-05 8:35
Membermiah alom17-Oct-05 8:35 
GeneralRe: ADO.NET Update / delete without primary keys Pin
Jasonc22118-Oct-05 9:22
MemberJasonc22118-Oct-05 9:22 
GeneralRe: ADO.NET Update / delete without primary keys Pin
l a u r e n21-Oct-05 15:04
Memberl a u r e n21-Oct-05 15:04 
AnswerRe: ADO.NET Update / delete without primary keys Pin
S Douglas20-Oct-05 1:45
professionalS Douglas20-Oct-05 1:45 
AnswerRe: ADO.NET Update / delete without primary keys Pin
l a u r e n21-Oct-05 15:06
Memberl a u r e n21-Oct-05 15:06 
GeneralRe: ADO.NET Update / delete without primary keys Pin
Jasonc22124-Oct-05 12:37
MemberJasonc22124-Oct-05 12:37 
QuestionSQL connection in servicedcomponents Pin
eliprand14-Oct-05 5:43
Membereliprand14-Oct-05 5:43 
AnswerRe: SQL connection in servicedcomponents Pin
eliprand14-Oct-05 6:08
Membereliprand14-Oct-05 6:08 
QuestionHow does Oracle support unicode text? Pin
Xiangyang Liu 刘向阳14-Oct-05 5:35
MemberXiangyang Liu 刘向阳14-Oct-05 5:35 
AnswerRe: How does Oracle support unicode text? Pin
DiWa14-Oct-05 19:30
MemberDiWa14-Oct-05 19:30 
GeneralRe: How does Oracle support unicode text? Pin
Xiangyang Liu 刘向阳14-Oct-05 19:50
MemberXiangyang Liu 刘向阳14-Oct-05 19:50 
QuestionConnection String Pin
kenexcelon13-Oct-05 14:27
Memberkenexcelon13-Oct-05 14:27 
AnswerRe: Connection String Pin
Mike Dimmick14-Oct-05 4:42
MemberMike Dimmick14-Oct-05 4:42 
GeneralRe: Connection String Pin
Anonymous14-Oct-05 15:32
MemberAnonymous14-Oct-05 15:32 
QuestionOPENXML and ntext problem Pin
Luke Murray13-Oct-05 13:44
MemberLuke Murray13-Oct-05 13:44 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.