|
What's the exact query you're using?
Jeremy Falcon
|
|
|
|
|
The table is: Cars
The column I want to rename: Colour (of type CHARACTER VARYING(255))
ALTER TABLE Cars RENAME COLUMN Colour TO FormerColour CHARACTER VARYING(255)
Thanks
-- modified at 1:44 Sunday 12th March, 2006
|
|
|
|
|
You don't need the the type of the column to rename it. This should do the job...
ALTER TABLE Cars RENAME COLUMN Colour TO FormerColour;
Also, CHARACTER VARYING is just a synonym for TEXT if you'd rather use that to keep your queries smaller.
Jeremy Falcon
|
|
|
|
|
I've already done that. I still get an sql syntax error. It simply does not work with (my) access 2000. Other idea?
|
|
|
|
|
Did you try running it specifically as a DDL query (under the Query/SQL Specific menu)?
If that still doesn't work, then I'm so glad I don't have to use Access anymore. However, if you must use Access then you could always rename the column using ADOX rather than a SQL statement. Or if all else fails, you could still pull off the same thing by using separate queries like this...
ALTER TABLE Table1 ADD COLUMN New_Col TEXT(255);
UPDATE Table1 SET New_Col = Old_Col;
ALTER TABLE Table1 DROP COLUMN Old_Col;
Jeremy Falcon
|
|
|
|
|
HI,
I want my inputs to be BOLD TEXT.
JOHN,K
|
|
|
|
|
|
I am still laughing, at least I told him not to post that again.
INTP
Every thing is relative...
|
|
|
|
|
Create a bold font, and pass it to edit box's SetFont() method...
|
|
|
|
|
|
Why are you telling me this?
|
|
|
|
|
I whish you where kidding, do not asks questions like this agian.
INTP
Every thing is relative...
|
|
|
|
|
Is there any MFC class for path operation? for example, to replace the API
GetCurrentPath,FindFirstFile functions?
Thanks
|
|
|
|
|
|
|
Hi all,
I want to find out how to achive network address translation in visual C++;
|
|
|
|
|
for the below reasons u need to go for NAT?
Why NAT?
• With the explosion of the Internet and the increase in home networks and business networks, the number of available IP addresses is simply not enough. The obvious solution is to redesign the address format to allow for more possible addresses. This is being developed (called IPv6), but will take several years to implement because it requires modification of the entire infrastructure of the Internet.
• Shortage of IP addresses is only one reason to use NAT
• For Security and Administration
• This is where NAT comes to the rescue.
How NAT works?
Network Address Translation allows a single device, such as a router to act as an agent between the Internet (or "public network") and a local (or "private") network. This means that only a single, unique IP address is required to represent an entire group of computers.
JAYARAJ
|
|
|
|
|
Hi,
Can you help me with choosing what version of Microsoft IDE I need to use.
I am using this IDE for development of drivers and GUI wrappers for them, based on MFC library, I'm not planning to use .NET platform, only plain C++, no managed code.
Now when Microsoft announced that Express Edition is free for download I want to try it, but it is very lightweight version of IDE and I don't know is there is any reason to download this IDE? I know that it doesn't have resource editor, mfc library, but compiler is more compatible to ISO standarts. Please help me with choise
Currently I am using VS .NET 2003.
|
|
|
|
|
Unless you can find a way to remove the use of MFC (eg. go to pure native Win32 or C++/CLI), you have no choice But to go for Visual Studio Standard or higher.
VC Express does not include MFC. Therefore, your program won't work in the Express edition.
MFC... not exactly plain C++ now is it ?
|
|
|
|
|
oshah wrote: MFC... not exactly plain C++ now is it ?
yep
oshah wrote: VC Express does not include MFC. Therefore, your program won't work in the Express edition.
this is not a problem, mfc is easy to integrate, because I have betas,
but beta version is very buggy product, thats why I will not use it...
|
|
|
|
|
Are you trying to force MFC into Express edition. Every other attempt I've seen to add MFC to Express has either ended in failure or the programmer getting Visual Studio Standard in one way or the other.
Trying to shoehorn MFC into Express is not only dangerous, you risk infringing on your EULA for Visual Studio. Let's say you started to integrate MFC into Express now. How long will it take? 50 man-hours? 100 man-hours (there's a lot of code to alter)? Let's go for the lower number, for fairness. Now let's assume you're a low paid Junior developer that earns $15 an hour (you need to be an expert/experienced developer to know how to port MFC, but once again, let's assume for fairness), the time you lose by having to add MFC to express edition is 50 hours: 50 * 15 = $750. You've just cost you and your company $750.00.
To compare, Visual Studio Standard costs less than $270 at Amazon. For the time you lost shoehorning MFC into Express edition, you could have bought two copies of Visual Studio Standard!
To conclude, forcing MFC to work in Express edition is not only a waste of time, it's a waste of money!
|
|
|
|
|
Look, if you plan on centering your life around the Windows Operating System then go ahead and use the latest tools from Microsoft. All other tools probably require that you have a basic knowledge (and then some) of how every things actually works.
Do not ask me how every thing works, because I have forgotten, I run on autopilot now days.
There is one farley stable entity and that is the [programming] language.
Use whatever IDE you want to, just remember the basics.
INTP
Every thing is relative...
|
|
|
|
|
how can we count the length of file??? i,am using MFC...
HelpMe
|
|
|
|
|
Hi
What do you need? if you want to length of the file please refer to
CFile::GetLength I hope helpful for you
|
|
|
|
|
if you are not using CFile or CStdioFile
int GetFileLength(FILE* in)
{
int was;
int length;
was = ftell(in);
fseek(in, 0, 2);
length = ftell(in);
fseek(in, was, 0);
return length;
}
C makes it easy to shoot yourself in the foot; C++ makes it harder, but when you do, it blows away your whole leg
|
|
|
|