Comments by Member 10267912

Member 10267912 16-Nov-13 19:01pm View

MySql

Member 10267912 16-Nov-13 19:01pm View

I am not using MS Access database.I was using MS SQL SERVER , but now, for some reasons, I am using MYSQL database through OLE DB Driver.
So what the solution now having a real Sql server ? thanks for your answer :)

Member 10267912 16-Nov-13 15:37pm View

Hi RedDK. I think it requires the use of SQL SERVER witch I am not going to use.

Member 10267912 19-Sep-13 20:24pm View

I will not have his email and password , there will be fields in witch he insert them , So none could control his account. My question was about the technical side of the problem, say I would make it for myself. Privacy would be managed later.
Thanks for you reply : )

Member 10267912 18-Sep-13 22:07pm View

Hi Maciej Los ,
The result you presented is exactly What I need . I just need some comments in your code if you will, especially in this part

//////////

SET @ft = 'INSERT INTO #tmp(OperationId, ProviderId, Date, Purchase, Payment) ' +
'SELECT ROW_NUMBER() OVER(PARTITION BY ProviderId ORDER BY Date) AS OperationID, ProviderId, Date, COALESCE(Purchase*-1,0) AS Purchase, COALESCE(Payment,0) AS Payment ' +
'FROM (' + @pt + ') AS T'
/////////////
I never used COALESCE and OVER let me know about it please.
Thanks for the answer and for your time :)

Member 10267912 18-Sep-13 17:37pm View

Thanks MCY for your comment.
I have a question; what do you mean by Customer's credentials. He has only Email address and Password. That's the only way he get into his account.
Anyways I will first check if it's about a POP3 Server or IMAP . If yes things would be easier.
Thanks again.

Member 10267912 18-Sep-13 14:13pm View

Is there in solution in this case? His bank sends him SMS to his phone number too. Could I get those SMSs ?

Member 10267912 18-Sep-13 12:04pm View

I made researches I found that I need :
1- A POP3 server address for example in Yahoo it's: "pop.mail.yahoo.com" or "plus.pop.mail.yahoo.com".
2- It requires SSL connection on X port. For yahoo : The port is 995
3- Email address as the user name for user authentication.

So Do I need the POP3 Server and the SSL connection Port nnumber of the Bank's website ?

Member 10267912 18-Sep-13 11:20am View

At this moment I just need to download these Emails. After this done, I will try to figure out how to update my Bank_Situation Table in my application problematically using these Emails. I am not asking for a complete code , I need just hints that could guide me to achieve What I am looking for . Thanks for your comment :)

Member 10267912 18-Sep-13 11:16am View

My Client has an Email Account and a Password. Could we use this Email and password to access his Inbox from my application ? For example there would be a text box in witch you type The Bank Website or IP, a text box for the Email and a Third one for the password. Then A list box or a grid filled by the emails downloaded after clicking on button for retrieving Emails.

Member 10267912 18-Sep-13 8:52am View

The table is now clear I guess after updating by Admins . Now I only need how to perferm this : Current BALANCE = (Previous BALANCE) - (Current PURCHASE AMOUNT) + (CURRENT PAYMENT AMOUNT) for each row .

Member 10267912 15-Sep-13 15:47pm View

I created an other table in witch I insert date , Payment and Purchase amount whenever I insert a payment or purchase transaction. But its not the solution I am looking for. I need just a view With a SELECT Clause So I wont care about the updates made in The Purchase or Payment Tables to get the right Balance in the right moment.

The Hard part for me is how Can I perform this : Current BALANCE = (Previous BALANCE) - (Current PURCHASE AMOUNT) + (CURRENT PAYMENT AMOUNT) . I hope you got me And sorry for Updating a lot My posts .

Comments by Member 10267912 (Top 12 by date)