|
DaoRecordsets don't work like that - presumably for the very reason you describe! 'Delete' simply marks a record as deleted and doesn't alter the record order. this also allows you to rollback changes if necessary.
It's all working now though, so thanks for your input!
|
|
|
|
|
The MessageBoard fairies strike again!
If I change the SQL to the much simpler:
"SELECT * FROM Components WHERE (Components.[Database Number])=15 AND Components.[Component Key] NOT IN (SELECT [Nozzle Key] FROM Nozzles)"
it all works.
|
|
|
|
|
Hi!
I've to read each name in a field from a table and do some string mangling and update each name into another field. I've to query the database from C++. I'm using SQLite. I used the following code to do this:
SQLManager SQLdb;
SQLdb.init("../../data/config/playerDatabase.db");
array<stringc> ctyLst = SQLdb.Query("Select DISTINCT Team from Test ORDER BY Team DESC");
array<stringc> playerLst;
core::stringc queryStr,updateTest;
for(u32 i = 0; i<ctyLst.size();i++)
{
queryStr = L"Select Name From Test WHERE Team ='";
queryStr += ctyLst[i].trim();
queryStr += L"'";
array<stringc> playerTmpLst;
playerTmpLst = SQLdb.Query(queryStr);
for(u32 j = 0; j < playerTmpLst.size(); j++)
{
playerLst.push_back(playerTmpLst[j].c_str());
}
}
I'm doing string mangiling an updating as follows:
for(int j = 0; j<playerLst.size(); j++)
{
updateTest = L"UPDATE Test SET MangledName ='";
unsigned int t = time(NULL);
srand(t);
playerLst[j] = playerLst[j].trim();
int index = playerLst[j].findLast(' ');
stringc subStr1 = playerLst[j].subString(0,index);
stringc subStr2 = playerLst[j].subString(index+1,15);
subStr1.append(" ",1);
subStr1.append(swapChars(subStr2).c_str(),subStr2.size());
updateTest += subStr1.trim();
updateTest += L"'";
SQLdb.Query(updateTest);
Sleep(10);
cout<<subStr1.c_str()<<endl;
t++;
}
While printing the result to a file, it prints correctly. But only the last name in the array is updated to all the records in the field. How to Select a single name at a time and do the string mangling and update the name to the database?
|
|
|
|
|
One normally uses a WHERE clause to specify which record(s) get updated.
Remarks:
- what is the purpose of Sleep(10)?
- what would happen if a player's name contained a quote?
- why don't you use SqlParameters instead of string concatenation?
|
|
|
|
|
plzz give me the code for inserting the data in the database through msAccess DataBase.
|
|
|
|
|
No problem[^].
You can skip all the CodeProject articles, since I trust you've read them before.
|
|
|
|
|
On a side note... I couldn't remember a particular .net class this week so I went on a Binge and found not only a CP article, but one of mine! 
|
|
|
|
|
and was it satisfactory?
|
|
|
|
|
Ohhh yeahhh. Most times I need to use the particular class I simply pull up that article anyway. This time I didn't because I was at work. (I try not to access CP from my new job.)
|
|
|
|
|
I hate when that happens.
|
|
|
|
|
Pay no attention to Luc. Try this link instead[^].
CQ de W5ALT
Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software
|
|
|
|
|
further reading is available here[^].
|
|
|
|
|
Hmmmm, cheap competitor in town, huh.  
|
|
|
|
|
what do you mean?
Is Google expensive and Bing cheap?
If yes send codez to proove it! 
I bug
|
|
|
|
|
Troll
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
You guys got it all wrong. 
Except maybe for Mycroft Holmes.
He wants codez for inserting the data in the database through the database
No codez needed for that. Just quick fingers
I bug
|
|
|
|
|
Hi,
I'm a freelance developer, I have a database application i developed for a client. I have deployed the database on my client server.
My client uses the builtin\administrator to login into the database server.
My Question is I will like to protect my database from the builtin\administrator from accessing it, because i don't want them to access it from the backend. am a novice to sql server security. Note: its on Sql Server 2000. How do i protect my Database?
|
|
|
|
|
saltcode wrote: client uses the builtin\administrator
Start by changing that (and its password). Give the client his own username, then apply whatever security you choose.
Ideally you'd be using integrated security.
|
|
|
|
|
|
i have a file_no field in my accounting_payment table and i want to run a query to see the frequency of every file, means how many times every file is listed in the table?
|
|
|
|
|
use the count() and group by operators
Select count(*),file_no from accounting_payment group by file_no
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
But I also want to assign the Top number#? For example
Select TOP 5 count(*), file_no from accounting_payment
But to show the TOP (frequency) not the Top (position)
Similarly I want to do it for the amount, for example:
Select TOP 5 max(amount_paid), file_no from accounting_payment
|
|
|
|
|
Do some research in BOL into rownumber() and partition. Using these and a sub select you can get the top N records grouped by yourcriteria and ranked according to your sort requirements.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
May be you can do like this,
SELECT TOP 5 FREQUENCY, FILE_NO
FROM
(SELECT COUNT(*) FREQUENCY, FILE_NO
FROM ACCOUNTING_PAYMENT
GROUP BY FILE_NO) A
ORDER BY FREQUENCY DESC
|
|
|
|
|
I'm doing a bit of searching about these ID's and came across this gem from an Oracle FAQ[^].
If you allow people to log in with OPS$ accounts from Windows Workstations, you cannot be
sure who they really are. With terminals, you can rely on operating system passwords, with
Windows, you cannot.
In the absense of an example, how does one intrepret this. Windows passwords are unreliable? What could someone possibly mean by that?
Chris Meech
I am Canadian. [heard in a local bar]
In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
