|
Since you have AND between the conditions both conditions must be true on the same row. So if you don't get any results with those two conditions but you do get results when using the conditions separately, you don't have a row in the table that satisfies both conditions at the same time.
Also when you use LIKE operator like that, you select all rows that start with letters P, D, F, R, T, F (again), D(again), O or C. For example if the field file contains a value 'test.abc', this will satisfy the condition since it start with the letter T. Is this what you really want?
|
|
|
|
|
Hello everybody,
I am developing an Application in which have a data base which i can share in different machines(more then 2).
So I wanna use any database which support sharing.
Because the application is download from web and it is small application.So i want to use the Fee and Small Size database.
My Application is like as billing.
So please suggest me what database to use for my application.
Thanks
If you can think then I Can.
|
|
|
|
|
SQL server Express[^] or SQL Compact Edition would probably fit the bill.
I must get a clever new signature for 2011.
|
|
|
|
|
It is free or not?
If you can think then I Can.
|
|
|
|
|
If you look at the page in the link it says: A free and feature-rich database for developing and deploying
desktop, web, and small server applications
So yeah, I think it is free...
Wout Louwers
|
|
|
|
|
eg_Anubhava wrote: It is free or not?
Go and look at the link; I cannot do everything for you!
I must get a clever new signature for 2011.
|
|
|
|
|
Thanks sir
If you can think then I Can.
|
|
|
|
|
Sql Compact isn't a database-server, it's a file-based system. It's not recommended in a multi-user environment.
I are Troll
|
|
|
|
|
Dear Sir,
Thanks for good suggestions.
Actually My Application is a Small Application which User can download from Web. In Which application i want to use the data which i can compact with my application. And I want to use it Application to For Multi User Support.
In this Case Access Database is the good and free database but it generate problems in Multiuser.
Please give me ur views.
Thanks
If you can think then I Can.
|
|
|
|
|
eg_Anubhava wrote: And I want to use it Application to For Multi User Support.
That sounds like they need to access a database simultaneously. That'd mean that they'd have an application at their own computer, and they would need to be able to access another computer that contains the database. That's your database-server. Usually, that's located somewhere in a LAN, a company-network.
If you're going to share data over the internet, then you might want to consider "the cloud" - using Amazons' API to store your data remotely. That way, you wouldn't need to worry about databases and how to access it.
Otherwise, you'll need to expose the database to the internet. That means providing a computer with Sql Server and hooking it up to the internet for 24hrs/day, or finding a webhost. Some providers disallow direct connections to their database, in which case you'd need a layer of webservices to communicate with the database.
I are Troll
|
|
|
|
|
Yes off Course,
I want to share my database in LAN network. My Application is same like ERP. So i want to select the database which multiple system can access at the same time without generating problem.
I think Microsoft Access generate the problem while sharing database.
So please suggest me which one is good in selected database.
MSaccess
SQL Server
Oracle
MySql
Microsoft SQL Server
Thanks
If you can think then I Can.
|
|
|
|
|
Sql Server, Oracle and MySql are the ones that would fit this job, and I'd recommend Sql Server because that's integrated the most into .NET.
Microsoft Access shouldn't be used.
I are Troll
|
|
|
|
|
thanks sir.
If you can think then I Can.
|
|
|
|
|
You're welcome
|
|
|
|
|
Oops; please ignore my previous message.
I must get a clever new signature for 2011.
|
|
|
|
|
eg_Anubhava wrote: So i want to use the Fee and Small Size database.
Free you can have, but database-servers aren't optimized at size - they're optimized on performance.
eg_Anubhava wrote: So please suggest me what database to use for my application.
One that's located on a PC that can be reached by all other computers (database shouldn't be blocked by a firewall)
You'll need Sql Express, MySql or something comparable.
I are Troll
|
|
|
|
|
How check cursor have the row data .
|
|
|
|
|
Hi,
you can use cursor%FOUND to see if the cursor has a row but better yet you can define a for loop for a SQL statement. For example:
for MyList in (SELECT Name FROM Emp) loop
...
end loop;
|
|
|
|
|
Our app gets info from a product database (MDB), and we have a database editor tool included in our package. Our thought there was to provide users with a way to maintain their DBs without having to have Office installed.
So far, so fine-by-us. However, some of our users want to be able to update their DBs from data in Excel (though if they have Excel, they should have access to Access no? And they could just do this directly? Anyway. Whatever.)
So, for the very small percentage of our users who are interested, I've added a Query window to our database editor app. It allows users to run SELECT, DELETE, UPDATE and INSERT queries (Yes I know the risks! Yes, some operations are transactionally protected!).
Behind my query window / data-bound grid is a CDaoRecordset (yes, I know it's old, and deprecated, but it works, and extricating DAO from the app is a lot more work than I have time for at the moment).
So the question is, can I write a query in my query window that can update / insert to my component table from an Excel source?
I'm thinking something along the lines of:
SELECT * INTO XLImport4 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\test\xltest.xls', [Customers$])
But executing something like that, the app complains about an unrecognised FROM clause.
Any thoughts / suggestions are much appreciated.
|
|
|
|
|
Hi,
It's been years since I last used DAO but few things come in mind:
- The statement executed using CDaoRecordSet is (if I recall correctly) parsed by the provider. This actually means that your DAO provider should be able to understand the SQL syntax you use, but that's not possible (since you're using T-SQL syntax)
- Unfortunately CDaoRecordSet doesn't have the capability to pass the statement to the server as-it-is
- You could try to use CDaoQueryDef instead and use the passthrough option so that the provider won't interfere. After all you're not trying to get any results back to the client but to populate a table in the database
Also keep in mind that in your statement you're referring to a file which resides on the database server. Meaning that the file xltest.xls must reside in directory C:\test at the database server.
|
|
|
|
|
I created dataset in Visual Studio 2008 using payroll_2007_08 database with payroll_2007_08connectionstring (sql server 2005), now recently we changed the database name to only payroll. If i remove the dataset all the fields which i created in report will automatically goes because of this connection string removed.
How to change the payroll_2007_08connectionstring to payrollconnectionstring (dataset) without removing the fields in reports.
If anybody knows, please reply me. Thanks in advance.
|
|
|
|
|
Hello Everybody,
Is it possible to Rollback Table in SQL Server 2005 if it is Truncated?
Thanks
If you can think then I Can.
|
|
|
|
|
No: see here: TRUNCATE TABLE (Transact-SQL)[^].
From the page:
"The DELETE statement removes rows one at a time and records an entry in the transaction log for each deleted row. TRUNCATE TABLE removes the data by deallocating the data pages used to store the table data and records only the page deallocations in the transaction log."
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum
me, me, me
|
|
|
|
|
Hi,
If you mean that can you rollback the truncation of a table if it's done in a tranaction: Yes.
You can test this with a small test case:
CREATE TABLE TruncTest (
Column1 int);
BEGIN
DECLARE @cnt INT;
SET @cnt = 0;
WHILE @cnt < 100 BEGIN
INSERT INTO TruncTest VALUES (@cnt);
SET @cnt = @cnt + 1;
END;
END;
SELECT COUNT(*) AS Rows FROM TruncTest;
BEGIN TRANSACTION;
TRUNCATE TABLE TruncTest;
SELECT COUNT(*) AS Rows FROM TruncTest;
ROLLBACK;
SELECT COUNT(*) AS Rows FROM TruncTest;
|
|
|
|
|
Dear All,
Usage: access 2007, VBA
I have 2 comboboxes, cbo1 and cbo2 , cbo1 is loaded with numbers from the database, and cbo2 is loaded with text from the database.
dim cb1 as double
dim cb2 as string
cb1 = CDbl(me.cbo1.value) ' i chossed: 800524
cb2 = CStr (me.cbo2.value) ' i choosed: Hello World
msgbox cb1
msgbox cb2
Result : 800524
Result : 4
where 4 represent the location of the "Hello world" , fourth element in the cb2, while i need to get the text
I can get wat i need from this result (using dataset , and query) but it cost code lines and memory resource, shouldent .Value returns the exact value that is selected ???
0 will always beats the 1.
|
|
|
|