Click here to Skip to main content
15,884,298 members
Home / Discussions / C#
   

C#

 
AnswerRe: Windows media Control Pin
N a v a n e e t h23-Sep-09 20:55
N a v a n e e t h23-Sep-09 20:55 
GeneralRe: Windows media Control Pin
jpk42023-Sep-09 23:37
jpk42023-Sep-09 23:37 
GeneralRe: Windows media Control Pin
N a v a n e e t h24-Sep-09 0:11
N a v a n e e t h24-Sep-09 0:11 
Questionerror "Object reference not set to an instance of an object" pls see the code and help me Pin
amaankhan23-Sep-09 19:58
amaankhan23-Sep-09 19:58 
AnswerRe: error "Object reference not set to an instance of an object" pls see the code and help me Pin
PIEBALDconsult23-Sep-09 20:02
mvePIEBALDconsult23-Sep-09 20:02 
GeneralRe: error "Object reference not set to an instance of an object" pls see the code and help me Pin
amaankhan23-Sep-09 20:06
amaankhan23-Sep-09 20:06 
AnswerRe: error "Object reference not set to an instance of an object" pls see the code and help me Pin
N a v a n e e t h23-Sep-09 20:08
N a v a n e e t h23-Sep-09 20:08 
QuestionInsert values into a table only if they do not already exist in that table (MS Access) Pin
Ajithevn23-Sep-09 19:55
Ajithevn23-Sep-09 19:55 
hi all

i have a query written in MS access which check if variables exist in the table then dont inser but if not the variables are inserted twice this is my problem.below is the code


INSERT INTO IPAdress ( IP, Machine_Name)
    SELECT '3', 'sss' from IPAdress WHERE NOT EXISTS
     (SELECT null FROM IPAdress WHERE IP = '3' AND Machine_Name = 'sss' )


in oracle there is a dual table so the query can be modified a bit and it works fine.the query which works in oracle is

INSERT INTO IPAdress ( IP, Machine_Name)
    SELECT '3', 'sss' from dual WHERE NOT EXISTS
     (SELECT null FROM IPAdress WHERE IP = '3' AND Machine_Name = 'sss' )

AnswerRe: Insert values into a table only if they do not already exist in that table (MS Access) [modified] Pin
PIEBALDconsult23-Sep-09 20:13
mvePIEBALDconsult23-Sep-09 20:13 
GeneralRe: Insert values into a table only if they do not already exist in that table (MS Access) Pin
Ajithevn23-Sep-09 20:20
Ajithevn23-Sep-09 20:20 
GeneralRe: Insert values into a table only if they do not already exist in that table (MS Access) Pin
PIEBALDconsult23-Sep-09 20:32
mvePIEBALDconsult23-Sep-09 20:32 
QuestionInterface type or class type? Pin
shivapriyak23-Sep-09 19:30
shivapriyak23-Sep-09 19:30 
AnswerRe: Interface type or class type? Pin
PIEBALDconsult23-Sep-09 19:46
mvePIEBALDconsult23-Sep-09 19:46 
GeneralRe: Interface type or class type? Pin
shivapriyak23-Sep-09 19:48
shivapriyak23-Sep-09 19:48 
GeneralRe: Interface type or class type? Pin
PIEBALDconsult23-Sep-09 19:58
mvePIEBALDconsult23-Sep-09 19:58 
GeneralRe: Interface type or class type? Pin
shivapriyak23-Sep-09 20:54
shivapriyak23-Sep-09 20:54 
GeneralRe: Interface type or class type? Pin
N a v a n e e t h23-Sep-09 23:19
N a v a n e e t h23-Sep-09 23:19 
GeneralRe: Interface type or class type? Pin
shivapriyak24-Sep-09 0:35
shivapriyak24-Sep-09 0:35 
GeneralRe: Interface type or class type? Pin
N a v a n e e t h23-Sep-09 20:00
N a v a n e e t h23-Sep-09 20:00 
GeneralRe: Interface type or class type? Pin
shivapriyak23-Sep-09 21:08
shivapriyak23-Sep-09 21:08 
GeneralRe: Interface type or class type? Pin
N a v a n e e t h23-Sep-09 22:53
N a v a n e e t h23-Sep-09 22:53 
GeneralRe: Interface type or class type? Pin
shivapriyak24-Sep-09 0:36
shivapriyak24-Sep-09 0:36 
GeneralRe: Interface type or class type? Pin
PIEBALDconsult24-Sep-09 5:22
mvePIEBALDconsult24-Sep-09 5:22 
QuestionImport Excel to Database Pin
Member-495917623-Sep-09 18:53
Member-495917623-Sep-09 18:53 
AnswerRe: Import Excel to Database Pin
Richard MacCutchan23-Sep-09 22:39
mveRichard MacCutchan23-Sep-09 22:39 

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.