|
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
|
|
|
|
|
Thanks very much for your reply.It runs on a database.
|
|
|
|
|
Select distinct(cli) from Table1 where cli not in (select Cli from table2)
try this with small c in second cli
|
|
|
|
|
Still the same.I have tried that also.
|
|
|
|
|
Have you got nulls in your fields? That would cause it.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
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?
|
|
|
|
|
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
|
|
|
|
|
this can help
select table1.cli from table1 left join table2 on table1.cli=table2.cli
where table2.cli is null
|
|
|
|
|
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 )
|
|
|
|
|
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?
|
|
|
|
|
Hi Christian,
Can you help me with a script on how to check and remove any Null script from a table.
Many thanks
|
|
|
|
|
You should try IS NULL instead of LIKE NULL
|
|
|
|
|
What is C#'s equivalent to VFP's CursorAdapter?
|
|
|
|
|
Depends, what does it do ? You can set the cursor with Cursor = Cursors.xxx
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 )
|
|
|
|
|
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
|
|
|
|
|
|
How to connect to MS Access Database and display result to grid?
|
|
|
|
|
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.
|
|
|
|
|
Thanks. Your answer guided me to the right trajectory.
|
|
|
|
|
|
it's easy for you because you already know
But the link that you gave me is very helpful so I will vote 1 for you.
|
|
|
|
|
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?
|
|
|
|
|
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.”
|
|
|
|
|
al3xutzu00 wrote: I need to make an overload for the index operator[int x]
It isn't an operator. It is an indexer. You can read about how to create them here: Using Indexers (C# Programming Guide)[^]
|
|
|
|
|
Hello,
can somebody tell me how the SharpStunt Library works? I want to initiiate a P2P Connection between two clients behind different NAT-Routers. That should be possible with this Library, but i don't know how to use it. Has somebody experience with this Library?
Kind regards
|
|
|
|