Click here to Skip to main content
15,911,646 members
Home / Discussions / Database
   

Database

 
QuestionAssign value of one column to other Pin
TrooperIronMan11-Feb-07 7:44
TrooperIronMan11-Feb-07 7:44 
AnswerRe: Assign value of one column to other Pin
Bassam Saoud11-Feb-07 19:51
Bassam Saoud11-Feb-07 19:51 
Questionsql query analyzer Pin
Member 381773811-Feb-07 4:47
Member 381773811-Feb-07 4:47 
AnswerRe: sql query analyzer Pin
tommyligo11-Feb-07 5:27
tommyligo11-Feb-07 5:27 
AnswerRe: sql query analyzer Pin
Rob Graham11-Feb-07 5:35
Rob Graham11-Feb-07 5:35 
QuestionFilling a dataset not working Pin
Blekk10-Feb-07 14:03
Blekk10-Feb-07 14:03 
AnswerRe: Filling a dataset not working Pin
Rocky#10-Feb-07 21:02
Rocky#10-Feb-07 21:02 
GeneralRe: Filling a dataset not working Pin
Blekk11-Feb-07 2:25
Blekk11-Feb-07 2:25 
GeneralRe: Filling a dataset not working Pin
Rocky#11-Feb-07 5:22
Rocky#11-Feb-07 5:22 
AnswerRe: Filling a dataset not working Pin
Sushant Duggal11-Feb-07 23:02
Sushant Duggal11-Feb-07 23:02 
Questiongrouping data in terms of time (weeks, months, year etc) Pin
Rocky#10-Feb-07 5:43
Rocky#10-Feb-07 5:43 
AnswerRe: grouping data in terms of time (weeks, months, year etc) Pin
Bassam Saoud10-Feb-07 5:49
Bassam Saoud10-Feb-07 5:49 
AnswerRe: grouping data in terms of time (weeks, months, year etc) Pin
M.H.1.2.310-Feb-07 6:24
M.H.1.2.310-Feb-07 6:24 
GeneralRe: grouping data in terms of time (weeks, months, year etc) Pin
Rocky#10-Feb-07 6:30
Rocky#10-Feb-07 6:30 
GeneralRe: grouping data in terms of time (weeks, months, year etc) Pin
Rocky#10-Feb-07 6:36
Rocky#10-Feb-07 6:36 
GeneralRe: grouping data in terms of time (weeks, months, year etc) Pin
M.H.1.2.310-Feb-07 11:50
M.H.1.2.310-Feb-07 11:50 
GeneralRe: grouping data in terms of time (weeks, months, year etc) Pin
Rocky#10-Feb-07 20:55
Rocky#10-Feb-07 20:55 
QuestionSQL Pattern Matching Pin
ug95rxp10-Feb-07 5:28
ug95rxp10-Feb-07 5:28 
AnswerRe: SQL Pattern Matching Pin
Krish - KP12-Feb-07 17:09
Krish - KP12-Feb-07 17:09 
Questionquery problem: specially for Colin [modified] Pin
Saira Tanwir10-Feb-07 2:55
Saira Tanwir10-Feb-07 2:55 
AnswerRe: query problem Pin
Colin Angus Mackay10-Feb-07 4:05
Colin Angus Mackay10-Feb-07 4:05 
GeneralRe: query problem Pin
Saira Tanwir10-Feb-07 4:15
Saira Tanwir10-Feb-07 4:15 
All the "Global.s"... have string values in them.

Global.Instance.Field_Name has the field name on which the trigger is to be applied.

Global.Instance.Table_name contains the name of the table

val contains an integer number.

Global.Instance.Trigeger_Query contains the mapped create trigger query.

what i'm trying to do is store the trigger query in a string type varible and then execute the mapped query through the ExecuteNonQuery() method.

i've used the same tehnique to map Create Table and Alter Table and Delete table queries and they worked fine.

GeneralRe: query problem Pin
Colin Angus Mackay10-Feb-07 4:37
Colin Angus Mackay10-Feb-07 4:37 
GeneralRe: query problem Pin
Saira Tanwir10-Feb-07 5:07
Saira Tanwir10-Feb-07 5:07 
GeneralRe: query problem Pin
Colin Angus Mackay10-Feb-07 5:58
Colin Angus Mackay10-Feb-07 5:58 

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.