Hello
Thanks for replying, apparently it was due to bad data in the refunds table which was messing up the results for the JOIN. After trying "NATURAL FULL JOIN" things seemed to start working and the results are looking fine aswell. I think it was rather a human error :) in trying to understand the formation of the JOIN.
Thanks
harvindersingh
Last Activity: Jun 24 '09, 08:30 PM
Joined: Sep 15 '08
Location: London, England
-
Help with query
Hello
I am trying to compile a query but getting inconsistent data from it. I need to make use of two tables namely:
transaction_pro ducts [contains products related to a transaction in transactions table]
refunds [contains refunded product details related to a transaction in transactions table]
Both of the above tables contain product_id and I would like to join the tables to gather some detailed information... -
I too am looking at doing backup and restore of PostgreSQL from C#. Is there any way that you could share your code for your C# solution. It sure would help me out a lot. Thank you for any help that you can give me on this. -
Hello
I have been thinking of finding a slightly different way of finding a way to send those KeyDown events to the parent Form rather than using that "global hooks" mecahnism from codeproject:
http://www.codeproject.com/KB/cs/globalhook.aspx
I tried to create a custom events using Delegate, and crated and listener for it in the parent Form, a method to invoke the event is created in the sub child Form or...Leave a comment:
-
Thanks a lot,
Sorry I posted before testing the application, the project on CodeProject does provide the solution to my problem.
ThanksLeave a comment:
-
Hello
I know this an old post, but rather than creating a new thread I think its better to extend this one as the question is relted to the above subject as well.
The above mentioned method to pipe through the KeyPress events to the Parent works like a charm, but it gets rather painful when there are a lot of Dialogue forms in the application. I was wondering if there is a way to capture events globally within the application,...Leave a comment:
-
Nice to hear that your problem was also solved with disabling firewall. You also need to allow the IP address of the remotely connecting PC in order to allow the access through the firewall. I have mine firewalls up all times just added IP addresses of the remote PCs. the PC with the server should have Port access and all the IP addresses in its firewall and the remotely connecting PCs should also have the IP address of the DB server's PC as well....Leave a comment:
-
Hello
Mine was a simple firewall issue, I thought allowing other PCs with their IP address is enough but it also required a rule behind the port number that should be accessible by the DB server. My problem was just because of this, and everything got sorted ofcourse you would need the above settings in the config file of the server to listen for clients on the port.Leave a comment:
-
Hello Mr Harvindersingh,
I feel happy after reading your post. beacuse i m also need to implement the feature "Remote access from a client on LAN". For this i have use search engine for a long time and followed the steps what you have mentioned above. But i did not get any solution. Hope you have succeded on this issue. Please let me know the steps that how can implement this feature. It will be helpful to me.
... -
Hello,
Thanks for reading the post, I have managed to find the cause of the problem. Actually it was due to the firewall, although I inserted a rule to allow the Client PC to connect to the PC with the DB Server, but it was missing the port access. Also Windows Firewall was running together with the COMODO Firewall, disabling Windows Firewall and applying the port details to the firewall worked for me.
To help others having...Leave a comment:
-
Remote access from a client on LAN
Hello
I am developing an application that requires PostgreSQL connection, I have installed PostgreSQL on my development machine and using NpgSQL to connect to the database. I am able to connect to the database while the application is running on the development PC, but whenever I am on any other PC on my network I cannot connect the application to the DB server running on another machine. I have been searching for a solution for quite... -
At last, I have to go for my own solution.
Although my implementation does not cover any fancy stuff, it does write to file with the updated characters and on the console as well. I have decided to keep the syntazx similar to SED i.e. if given -i as an option it updates the file otherwise writes on console and works like a charm.
I am attatching the code with this post, for others to use if they want.
...Leave a comment:
-
Hello, thanks for replying
I know this can work with moving around replace strings, but I ahve many replace strings and the the files I would like to update are also multiple. The above example was to simplify the behaviour I would like to achieve. I was wondering if there is anyway for sed to only replace the content once rather than replacing already replace matches, as I think it runs each match and replace case with the whole file...Leave a comment:
-
Linux SED (help on replacement)
Hello everyone,
I am trying to convert characters in a file using SED, I have already got the script working there is one very big problem. I would like to convert characters in the given file golobally i.e. all of its occurence, thus I am using /g tag at the end. Bu I have multiple combinations for replacement I would like to apply all the replaces one by one on the characters in the file rather than A replace command on the whole... -
This sounds okay to me, but how would I send the same event back tot he paren form? i.e. lets say I have this KeyDown event of F11 how would I send it back to parent form when the Dialog is open?
help appreciated.Leave a comment:
-
sorry guys I was meant to type:
ShowDialog();
in my above post. This is what I am using to show the form as a dialog.
thanksLeave a comment:
-
Sending events to parent form even when a dialogue is open
Hello guys
I have some custom events in my application i.e. KeyPress such as full screen for pressing F11 and so on. Currently this works fine but only when the main form which is listening tot he KayPress events. I would like this to work even when a Dialogue window is open from this form for example I am opening a child window with Show.Dialogue() . This is blocking the events from going to the parent form.
Can someone... -
Hello guys,
I have followed the same path as mentioned, just called cmd.exe and than psql.exe/pg_dump.exe with the necessary arguments for the backup and restore. Turns out that PostgreSQL is not using the simple input streams for the password, which gets asked after you give the command line all the arguments for the process. This way it is not very easy to just use inputStream to insert the password. Also I found that input streams...Leave a comment:
-
Great thanks
By using a Public bool was the solution of the problem. Yes apparently when the form is closed all of the drawing components gets false for their visibility. I was actually just trying the first approach because I want to keep the classes as small as possible by using the already created resources, this way it is less confusing.
The whole reason of making the code as little as possible is because the project...Leave a comment:
-
C# accessing components of an Object
Hello guys,
I am trying to access components of object created suring runtime. Basically the object is a new form and I call it like this:
The markedToEditLab el is a label and not visible by defualt, the QuickUpdate class uses ShowDialogue method to display the form....Code:QuickUpdate qu = new QuickUpdate(); MessageBox.Show(qu.markedToEditLabel.Visible.ToString());
No activity results to display
Leave a comment: