Re: SQL Script - C# Discussion Boards

Re: SQL Script

kibromg15-Apr-09 1:16

kibromg

15-Apr-09 1:16

Any Luck?

Re: SQL Script

Skymir15-Apr-09 2:35

Skymir

15-Apr-09 2:35

<blockquote class="FQ"><div class="FQA">kibromg wrote:</div>Select distinct(cli) from Table1 where Cli not in (select Cli from table2)</blockquote>

Select distinct(cli) from Table1 where Cli not in (select Cli from table2 where Cli is not null)

FTFY, SQL server has some floopy processing when it does 'not in' queries.

The true man wants two things: danger and play. For that reason he wants woman, as the most dangerous plaything.

Re: SQL Script

Dino Mulahusic15-Apr-09 1:05

Dino Mulahusic

15-Apr-09 1:05

and where does this happens: in code or in database
if it is in code try running it in some plsql developer and see what you get

Re: SQL Script

kibromg15-Apr-09 1:07

kibromg

15-Apr-09 1:07

Thanks very much for your reply.It runs on a database.

Re: SQL Script

Dino Mulahusic15-Apr-09 1:09

Dino Mulahusic

15-Apr-09 1:09

Select distinct(cli) from Table1 where cli not in (select Cli from table2)

try this with small c in second cli Smile | :)

Re: SQL Script

kibromg15-Apr-09 1:13

kibromg

15-Apr-09 1:13

Still the same.I have tried that also.

Re: SQL Script

Ashfield15-Apr-09 1:24

Ashfield

15-Apr-09 1:24

Have you got nulls in your fields? That would cause it.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Re: SQL Script

kibromg15-Apr-09 1:57

kibromg

15-Apr-09 1:57

Yes Please.when i select distinct(cli) there is one record NULL.

When i try to remove it delete from Table1 where cli like NULL it does nothing.

Can you please advice how can i remove it?

Re: SQL Script

Ashfield15-Apr-09 9:44

Ashfield

15-Apr-09 9:44

You cannot do like null (or = null either), you have to do

where cli is not null (or cli is null depending on whic you want)

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Re: SQL Script

a.hamidy15-Apr-09 1:26

a.hamidy

15-Apr-09 1:26

this can help
select table1.cli from table1 left join table2 on table1.cli=table2.cli
where table2.cli is null

Re: SQL Script

Christian Graus15-Apr-09 1:27

Christian Graus

15-Apr-09 1:27

This is a SQL question. I would suggest you break it down to try to work out why it doesn't work.

Christian Graus

Driven to the arms of OSX by Vista.

"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )

Re: SQL Script

kibromg15-Apr-09 1:58

kibromg

15-Apr-09 1:58

Yes Please.when i select distinct(cli) there is one record NULL together with other records

When i try to remove it delete from Table1 where cli like NULL it does nothing.

Can you please advice how can i remove it?

Re: SQL Script

kibromg15-Apr-09 2:22

kibromg

15-Apr-09 2:22

Hi Christian,

Can you help me with a script on how to check and remove any Null script from a table.

Many thanks

Re: SQL Script

tom57200715-Apr-09 2:30

tom572007

15-Apr-09 2:30

You should try IS NULL instead of LIKE NULL

CursorAdapter Equivalent

BabyCSharp15-Apr-09 0:45

BabyCSharp

15-Apr-09 0:45

What is C#'s equivalent to VFP's CursorAdapter?

Re: CursorAdapter Equivalent

Christian Graus15-Apr-09 0:54

Christian Graus

15-Apr-09 0:54

Depends, what does it do ? You can set the cursor with Cursor = Cursors.xxx

Re: CursorAdapter Equivalent

monstale15-Apr-09 1:34

monstale

15-Apr-09 1:34

Hi,

I think you want to open a database cursor, aren't you? Then you're search for class:

System.Data.Common.DbDataReader

or if you're searching e.g. for MS SQL Server:

System.Data.SqlClient.SqlDataReader

or OleDb:

System.Data.OleDb.OleDbDataReader

or Odbc:

System.Data.Odbc.OdbcDataReader

king regards

Re: CursorAdapter Equivalent

BabyCSharp15-Apr-09 1:44

BabyCSharp

15-Apr-09 1:44

Thanks.

Connection

BabyCSharp15-Apr-09 0:43

BabyCSharp

15-Apr-09 0:43

How to connect to MS Access Database and display result to grid?

Re: Connection

musefan15-Apr-09 0:47

musefan

15-Apr-09 0:47

do a google search and ill bet you will get loads of examples.

try looking at the System.Data.OleDb classes, its very straight forward from a programmers perspective

Life goes very fast. Tomorrow, today is already yesterday.

Re: Connection

BabyCSharp15-Apr-09 0:50

BabyCSharp

15-Apr-09 0:50

Thanks. Your answer guided me to the right trajectory.

Re: Connection

Dino Mulahusic15-Apr-09 0:50

Dino Mulahusic

15-Apr-09 0:50

It's very easy, maybe you should try it before you ask

or ask Mr. Google
or search here at CP Simple Movie Database in C# using Microsoft Access[^]

Re: Connection

BabyCSharp15-Apr-09 1:16

BabyCSharp

15-Apr-09 1:16

it's easy for you because you already know Poke tongue | ;-P

But the link that you gave me is very helpful so I will vote 1 for you. Smile | :)

Upload Data using c#

a.hamidy15-Apr-09 0:40

a.hamidy

15-Apr-09 0:40

I have asked this question several times in Code Project.
I am looking to upload my data with resume feature.
Is there any .Net Class or namespace or any algorithm to provide me a feature where i can upload my data in different segments and with resume feature?

Operator[] index overload in C#

al3xutzu0015-Apr-09 0:24

al3xutzu00

15-Apr-09 0:24

Hi Guys,
I need to make an overload for the index operator[int x] for an System.Collection.ArrayList, to use the get/set methods on it to return/set the specific item in that list.
How do i declare it ?
i tried :

public static explictit operator[int x]<br />
{<br />
}

It doesn't work. Help.

Kind regards,
Alex

“Be the change you want to see in the world.”

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