Hi
I want to learn DBMS including the concepts of complex SQL writing and normalisation and other stuff.
Can anyone please help me to find some useful online resources.....
What are commit messages for? I've always been writing them as an explanation of what I did, but I've recently gotten into a discussion about it with a colleague who writes commit messages explaining why he did. Which one is right, or is there another answer entirely?
Hi,
I am writing a CMD file which runs a bunch of sql files, like this:
:: Running every sql file in the temp directory
For %%G IN (.\install\*.sql) DO (
:: run sql script
echo exit | sqlplus interacct/interacct @%%G
)
My question is how do I capture an error when one of the scripts didn't succeed?
Thankyou.
Sarah
I am using InstallShield 2008 premium edition. I created one basicMSI project only to target x64 platforms. I changed summary property to "x64".
But this installer is writing registry entries in "HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\CompanyName\ProductName" .
I am using both installshield script and vc++ DLL for custom actions.
Why x64 installer is using WOW64 registry ?
What are the usual problems / stumbling blocks / issues / drawbacks when using a legacy database with a new rails application?
We have to decide between using an old database or writing migration scripts to bring data from old database to new database following rails conventions. What would you suggest?
I have the following piece of code to write data to an XML file.
private void WriteResidentData()
{
int count = 1;
status = "Writing XML files";
foreach (Site site in sites)
{
try
{
//Create the XML file
StreamWriter writer = new StreamWriter(path + "\\sites\\" + site.title + ".xml");
writer.WriteLine("<?xml version=\"1.0\" encoding=\"ISO-8859-1\" ?>");
writer.WriteLine("<customer_list>");
foreach (Resident res in site.GetCustomers())
{
bw.ReportProgress((count / customers) * 100);
writer.WriteLine("\t<customer>");
writer.WriteLine("\t\t<customer_reference>" + res.reference + "</customer_reference>");
writer.WriteLine("\t\t<customer_name>" + res.name + "</customer_name>");
writer.WriteLine("\t\t<customer_address>" + res.address + "</customer_address>");
writer.WriteLine("\t\t<payment_method>" + res.method + "</payment_method>");
writer.WriteLine("\t\t<payment_cycle>" + res.cycle + "</payment_cycle>");
writer.WriteLine("\t\t<registered>" + CheckWebStatus(res.reference) + "</registered>");
writer.WriteLine("\t</customer>");
count++;
}
writer.WriteLine("</customer_list>");
writer.Close();
}
catch (Exception ex)
{
lastException = ex;
}
}
}
It's using the same BackgroundWorker that gets the data from the database. My progress bar properly displays the progress whilst it is reading from the database. However, after zeroing the progress bar for the XML writing it simply sits at 0 even though the process is completing correctly.
Can anyone suggest why?
Obfuscation is one way, but it can't protect from breaking the piracy protection security of the application. How to make sure that the application is not tampered with, and how to make sure that the registration mechanism can't be reverse engineered.
Also it is possible to make to convert C# app in native code, Xenocode is too costly.
C# provides lot of features, and is the ideal language for my code, so writing in C++ again the whole codebase is out of question.
Secure certificates can be easily removed from the signed assemblies in .NET
I'm having trouble installing Template module with Strawberry Perl.
cpan Template
yields the following:
Writing Makefile for AppConfig
C:strawberryperlbinperl.exe: not found
dmake.EXE: Error code 255, while making 'blib\lib\.exists'`
I haven't been able to understand either
how to affect the path so dmake will work correctly
why the path (which is correct) does not have any \ in it.
Hi,
I am writing a report, and I would like to know, in your opinion, which open source physical simulation methods (like Molecular Dynamics, Brownian Dynamics, etc) would be worth to port to GPU.
Thanks in advance
when writing a file using NSFileCoordinator i need to specify to correct NSFileCoordinatorWritingOptions. Although they are explained in detail, i am not sure when to use which one. The available options are:
NSFileCoordinatorWritingForDeleting
NSFileCoordinatorWritingForReplacing
NSFileCoordinatorWritingForMoving
NSFileCoordinatorWritingForMerging
For example, what option is the correct one if i want to create a file(a plist for example)?
Wich one when i modify a file?
Can someone explain the NSFileCoordinatorWritingOptions for a better understanding?
Greetings,
Johannes
I'm writing an Air application using only Actionscript, and Flex3 SDK as the compiler. Everything compiles and runs fine under adl, but when the final air file is built and installed, the main class is never initialized. For instance:
package {
import flash.display.Sprite;
public class main extends Sprite {
public function main() {
trace("Init");
}
}
}
When run under ADL, "Init" will be output to the console, but when installed and run, nothing happens (the constructor for class main is never called).
I am writing an application that gets its dimensions from the paper ratio of the default printer of the local computer. This all works well unless the default printer is over a VPN. When this is the case, calling GetDefaultPrinter() takes too long. I need to find a way to put a time constraint on GetDefaultPrinter() and if it exceeds that constraint, break out of the function.
Any possible solutions would be great.
Thanks,
Ian
I was looking over Martin Fowler's recent book contents - Domain Specific Languages and I noticed some ANTLR example - that got me thinking that writing compilers will become more and more popular since people needs in this matter will increase.
So, will the compiler theory still be as arid (being subjective here) as it was until now or are there any chances that we'll get more applied, programmer oriented materials ?
I'm a writing a program that will determine the number of lines, characters, and average word length for a text file. For the program, the specifications say that the file or files will be entered as a command line argument and that we should make a TestStatistic object for each file entered. I don't understand how to write the code for making the TestStatistic objects if the user enters more than one file.
Hi,
My question is related to the following question, and can be said almost same.
http://stackoverflow.com/questions/330542/setting-the-iphone-keyboard-language
But here are my requirement. I am writing dictionary app for IPhone, which support multiple languages. So my requirement is to display the English keyboard when user has selected English language and show Dutch keyboard when user has selected Dutch and so on.
So i was wondering if this is possible?
Thanks.
Is there to way write a T-SQL command to just make it sleep for a period of time? I am writing a web service asynchronously and I want to be able to run some tests to see if the asynchronous pattern is really going to make it more scalable. In order to "mock" an external service that is slow, I want to be able to call a SQL server with a script that runs slowly, but isn't actually processing a ton of stuff.
My Virtualbox guest OS (Ubuntu on ubuntu host) does not connect to the internet when I have wifi access through an internet cafe system. By this, I mean where your browser redirects to an internal web page where you can enter a code. On the guest, I can successfully connect to the virtual network adapter, but I do not get internet access, nor a redirect to the internal web page. I use OpenDNS for the host.
I have no problems when connecting through ethernet or regular wifi.
Can someone tell me any of:
1) How to fix the problem.
2) How such cafe systems work.
3) At least point me to a technical explanation of such a cafe system so I can begin to troubleshoot.
Thanks!
I am using wpf Custom Commands. While writing a custom Command, you need to define the owner type. Description says that it is the type that is registering the command. I was seeing some sample and there the Owner type was UIElement and in some others it was the class name itself. Whats the difference? What should be the owner type?
This might be a silly question, but...
I've been writing a number of classes that utilize non-copyable members. These classes are never initialized via the copy constructor in my source. When I try to compile without supplying my own copy-constructor, g++ throws out many errors about how it can't build a default copy constructor, due to the non-copyable member objects.
Is there a way to tell the compiler to just not give me a copy constructor?
I'm writing a new product, and I've noticed that a lot of the features I want already exist in blogging platforms like wordpress. For example, comments and comment moderation, content editing, etc.
Is there a good blogging system that is easy to use as a foundation for something else? Something with an API, extremely customizable, and hopefully something that works well with Java.
Hi there,
I'm new to abap and just writing my first application.
Now I got a date of the type SYDATUM and wondering how to format it in a format like m/d/y.
I've found some snippets on the web, but they were not really helpful.
-thanks yor your help.
I am writing an iPhone application to apply filters to audio input and output the result in real time.
I am new to audio processing but using audiounit, the correct approach?
I found out how to output data using audiounit but couldn’t figure out how to capture input audio.
Is there a sample application showing how to connect input and output using audiounit?
Hi
I am writing an application in java I need to fetch specific data from website.I do not know which one to use whether REGEX or Parser.Can anybody please advise me how to get this done? and which one is prefered.
Thanks
Any issue with that?
I recently setup ubunutu virtual machine on my external harddisk.
Once i accidentally removed the external harddisk usb connection then when i try to startup the ubuntu virtual machine again i get kernel panic.
I thinking of writing a cron script to backup everyday to another location to prevent this issue