Similar Threads
1. [Uniface-L] problem with sql proc command - problem solved
2. Help w/Report problem - SOLVED - ADP:Access
3. Re-Posting on SQL Query from C#-It's driving me crazy - PROBLEM SOLVED
Boy was it dumb. I was spelling the field Account with one c in the
select statement. Why it didn't blow up is beyond me since there is no
field called Acount.
Eric Kiernan wrote:
> 1. I used parameters originally in the first select and discarded them
> because i wasn't getting them to work properly. But I kept them since
> they worked in the insert statement.
> 2.Re-using the command object. I thought of the same thing and started
> disposing of them, and creating new ones. It didn't make any difference.
>
> Family Tree Mike wrote:
>> Eric Kiernan wrote:
>>> First, I don't know if this is the appropriate forum for asking SQL
>>> questions with C#. If someone knows a more appropriate SQL group,
>>> let me know ( they all seem geared to one vendor). I have a table (
>>> in an access mdb file )called Accounts, with one field, Account. I
>>> have an List AccountList filled with unique account names. Before I
>>> add them to the table, I want to make sure they are not already
>>> there. I did a select for the first account,executed the
>>> ExecuteReader, and it correctly said HasRows = false, did the
>>> INSERT. From every iteration after, when I do the ExecuteReader, the
>>> reader claims it has rows, and never does another insert. The
>>> ExecuteReader always returns the first record added, and i've
>>> verified the command string is correct on each iteration, changing
>>> the account name i'm searching for. The connection is already open
>>> prior to executing this code. Sorry for reposting but it really is
>>> driving me nuts.
>>>
>>> private void checkAccount()
>>> ---------------------------
>>> OleDbDataReader reader;
>>> int j;
>>> for (int i = 0; i < AccountList.Count; i++) {
>>> objCommand.Parameters.Clear();
>>> objCommand.Parameters.AddWithValue("@Account", AccountList[i]);
>>> objCommand.CommandText = "select * from Accounts where [Acount] =
>>> " + "'"+ AccountList[i] + "'";
>>>
>>> reader = objCommand.ExecuteReader();
>>> if (!reader.HasRows) {
>>> reader.Close();
>>> objCommand.CommandText = "INSERT INTO Accounts ( Account )
>>> VALUES (@Account )";
>>> j = objCommand.ExecuteNonQuery();
>>> }
>>> else {
>>> reader.Close();
>>> }
>>> sleep (20);
>>> }
>>
>> I don't do a lot of db coding, but these jump out at me:
>>
>> 1. Why do you add Parameters in the first command (Select * from
>> Accounts where [Acount] = 'some account'"), when there are no
>> parameters? The parameters are in your second call. I'm not sure if
>> that will affect the first call.
>>
>> 2. The indexes look fine in spite of David's response, but why use
>> them at all? Just use:
>>
>> foreach (string s in AccountList) // and use s as the value to
>> test/store, not AccountList[idx].
>>
>> 3. Use Using statements, or at least dispose of things that can be
>> disposed. Personally, I don't like reusing the objCommand object the
>> way you are here. You haven't really closed it properly, when you go
>> onto using it in the if (!reader.HasRows) section.
>>
4. Access97 with SQL Server back end - Problem Solved
5. count() problem -SOLVED-
Albe V?schrieb am 2003-06-26 11:53h:
>
> Select sum(
> case
> when prjstat=0
> 0
> when prjstat>0
> 1
> end case)
> from ....
Great! That's it:
SELECT c.cid AS cId,
c.cname AS cust_name,
SUM(
CASE
WHEN (p.prjstat = 0) OR (p.prjstat IS NULL) THEN 0
WHEN (p.prjstat > 0) THEN 1
END) AS active_projects
FROM tab_prj p RIGHT OUTER JOIN
tab_cust c ON (p.cid = k.cid)
GROUP BY c.cid, c.cname
> PS: check syntax of Case statement. I always mix other Sqls and programming
> languages syntaxes...
Me too! It's almost correct... However, the idea itself was decisive!
Thanks alot!
Bye,
Jn
6. XML leading spaces problem solved
7. NS SQL CATALOG Problem(solved)
Folks,
Its worked....I have deleted the entries from System Catalog table
using the licensed copy of SQLCI2 and now I able to create new catalog
on the same Vol. & Subvol.
Thank You for your help and advice.
Cheers,
Prithvi.
"DanDotDan" < XXXX@XXXXX.COM > wrote in message news:< XXXX@XXXXX.COM >...
> I haven't tried this situation, but you should be able to license a copy of
> SQLCI2 then use it to clean up the system catalog. I think the only table
> affected is CATALOGS. The procedure for licensing SQLCI2 is in TIM. Don't
> forget the define =SQL_CI2_<node>.
>
> "Prithvi" < XXXX@XXXXX.COM > wrote in message
> news: XXXX@XXXXX.COM ...
> > NSSQL Gurus... I need your help.
> > I have purged a SQL CATALOG from my Development system. As Drop Index",
> Drop
> > Table" and "Drop Catalog" was not possible due to some constraints. So I
> had to
> > delete all the Catalog files using GOAWAY command on the CATALOG
> sub-volume.
> > Later I tried deleting the catalog entries from SYSTEM CATALOGS using
> "drop
> > catalog" . But, it gives a message saying the catalog does not exists in
> the
> > location. But, I can see an entry in the SYSTEM CATALOG table for that vol
> &
> > subvol. This doesn't even allow me to recreate a new catalog in the same
> vol &
> > subvol.
> >
> > Cheers,
> >
> > Prithvi
8. PROBLEM SOLVED sqlserver.ce merge replication setup question - SQL Server CE