Search:
Type: Posts; User: davide++
Search:
Search took 0.04 seconds.
-
August 3rd, 2010, 05:48 AM
Hi all.
You cannot use the IF-THEN-ELSE statement in SELECT command; unfortunately you cannot use CASE-WHEN statement in WHERE condition.
Try using an usual join, with outer of join operator;...
-
July 29th, 2010, 09:44 AM
Hi all
A part from the syntax error, I think there's a problem about fields' data type. In Customers table the primary key is char(5), while in Orders table the foreign key is integer; The two...
-
December 15th, 2009, 06:56 AM
Well, it depends on which kind of application you're going to develop.
If the application is a mono-user program with a little amount of data to manage, I agree with Krishnaa, Access is the best...
-
December 15th, 2009, 06:49 AM
Hi all.
The size was increased because you added the index; usually indexes are implemented as a special
table that holds the values and the link to the record. This table requires space, of...
-
September 23rd, 2009, 11:27 AM
Hi all.
If I have understod what you did, you added a table with one column that says what messages are taken from file, and you're trying to write a join on the two tables to select the message...
-
September 23rd, 2009, 03:20 AM
Hi all.
I found this explanation about the error you got.
ORA-01019 unable to allocate memory in the user side
Cause: The user side memory allocator returned an error.
Action: Increase the...
-
September 21st, 2009, 12:13 PM
Hi all.
The first problem I see is that *next isn't filled with NULL when you create a new node; so it contains a random value and probably you get a crash when scan the list using while loop....
-
September 18th, 2009, 10:52 AM
Hi all.
Only 30 pages????
It's a little introduction to the topic!!!!!
Well, I've developed in C++ for long time, and I used STL very rarely. But I think that it's a very important argument,...
-
September 18th, 2009, 09:30 AM
Hi all.
Maybe I'm wrong, but I remember that #define macro replaces the symbol in code at pre-compiled time.
So the preprocessor changes the statement
balance=balance+amnt_deposit;
in
-
September 17th, 2009, 10:03 AM
Well.
Indexing is one of the most important element of a good design, but when data is so big it cannot solve all problems. Yes, it's true, searches based on indexes are fast and their speed tend to...
-
September 17th, 2009, 06:50 AM
Hi all
Well, this post seems to be related the previous one I saw.
100 million of record is really "very large amount of data". I suggest Oracle (yes, I love it :) ), but beyond the db engine,...
-
September 17th, 2009, 02:48 AM
Hi all.
Ok, I agree with dglienna, SQLExpress is more appropriate than Access, and later you can easily change it with SQLServer. But you have to manage a large amount of data, over 4 millions of...
-
August 31st, 2009, 09:34 AM
Hi all.
You didn't say what db you're using. If it's Oracle, the fields VARCHAR(n) will be filled with blanks, so the table size will be 50000 bytes. Use instead VARCHAR2(n), the field won't be...
-
August 27th, 2009, 02:46 AM
Hi all.
Maybe I didn't understand exactly what your requirement is.
You're trying to open an existing file, "SampleTest.txt", whose short name is "sample~1.txt"; well, the file is one, there...
-
July 27th, 2009, 02:58 AM
Hi all.
Well, it depends on your requirements.
However I prefer to store links, for two reasons. First, you can save space on your database, and then you don't need to update the database when...
-
July 21st, 2009, 07:21 AM
Hi all.
You didn't say what is your environment, what OS you're using.
If it's Windows I suggest to use Microsoft Access as database.
Access database is basically a local file, you don't need Ms...
-
July 21st, 2009, 02:27 AM
Hi all.
I don't know MS-SQL, and I don't know what exactly maintenance plan is. But I image that it means to check integrity data between tables, and you shouldn't insert new records when the plan...
-
July 17th, 2009, 06:03 AM
Hi all.
I've tried in Oracle 8.1.7.4 instance, and the result was what I expected
SELECT N.* FROM (
SELECT 'AS' M FROM dual
UNION
SELECT '5' M FROM dual) N
-
July 10th, 2009, 05:40 AM
Well, you don't need execute permission if you execute the procedure within the user that holds it (the user that created the procedure). If you want execute the procedure from another user, this...
-
July 10th, 2009, 02:59 AM
Hi all.
Hard to say...
Surely some privileges are missing.
Do you get the error when yo're trying to create the stored procedure, or when you're trying to execute it?
If you cannot create the...
-
June 29th, 2009, 02:35 AM
Hi all.
M$SQL provides "money", a specific data type for monetary data values.
In my opinion it's the best choice.
-
June 23rd, 2009, 05:41 AM
Hi all.
Well, the statement "I have three type of clients completely different" sounds a bit strange for me; after all, a customer is a person, and for all db I've seen the table CUSTOMERS has...
-
June 23rd, 2009, 02:44 AM
Hi all.
You didn't say what db you're using, and what you can do depends on it.
Anyway, you should use the string functions. For example, if your db was Oracle you would write
UPDATE...
-
June 22nd, 2009, 02:45 AM
Hi all.
First, CVDate is a function, so you must assign a value
x = CVDate("19 June 2009");
Then, I know it's a VBA function. Are you sure that it's supplied by the tools and...
-
June 15th, 2009, 11:36 AM
You shouldn't use OR operator.
Never.
It slows down query execution; without brackets the db engine links all ANDs condition with the two OR choices so the query is very slow.
Instead of ORs,...
|
Click Here to Expand Forum to Full Width
|