Search:

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;...

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...

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...

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...

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...

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...

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....

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,...

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

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...

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,...

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...

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...

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...

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...

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...

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...

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

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...

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...

Hi all.

M$SQL provides "money", a specific data type for monetary data values.
In my opinion it's the best choice.

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...

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...

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...

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,...