Hello friends,
I came back after so many days with a question.
I had been working in VB.Net and C# for last one year. But from next month, I have to work in a new project that uses VC++ 2005 in .NET environment. But the problem is, it seems too complicated to me like: MFC, ATL and normal C++.cpp and again the VC++ CLR Windows Forms Application has different syntax ! My god ! I'm so scared ! Can anyone give me a guidline...
Zerin
Last Activity: May 16 '07, 04:48 AM
Joined: Dec 1 '06
Location: Japan
-
Start learning VC++ 2005
-
Image & Pixel
Guys,
Anyone has any idea about how to determine the start points and end points to draw a rectangle if I have two points for (x1,y1) thats the left top point's co-ordinate and (x2,y2) as the right-bottom point of a rectangle? I guess it has to be converted to pixel.
Actually,I have to draw rectangle from a garber data file and it has the above value of x1,x2,y1,y2 and I have to draw rectangles according to that file.... -
If you are working in HR,then
[PHP]SELECT * FROM emp
WHERE First_Name LIKE '%one%'
OR Last_Name LIKE '%one%'
OR Street_Address LIKE '%one%';[/PHP]
should work. As you are not familier with Oracle, I must say that the logic is right but actually the default table name (here, "emp" ) changes with the logged one. So,better check it out first and get the table name.
... -
Well,
- As I'm new in VB,when the result of the line with DataDiff didn't work properly, I tried INT and then it worked out.So, I don't know........... ......actually.
- And thanks for letting me know about the DATE() function.I don't want myself to be screwed up in future......... ...so,I think I'll change it.
- I just used the PHP tech today and it looks really nice.
Hey,can you prescribe me any tutorial that...Leave a comment:
- As I'm new in VB,when the result of the line with DataDiff didn't work properly, I tried INT and then it worked out.So, I don't know........... ......actually.
-
Dear iburyak ,
It worked with a few change and I could do it by VB 2005 also.Ah! Relax.......... ...........Leave a comment:
-
Killer42 my frnd !
I solved the problem on the front-end by VB 2005.I'm pasting the code sample here:
[PHP]Private Sub autoParge(ByVal oledbConn As OleDbConnection )
strSQL = " DELETE * FROM INSPECTION WHERE INT(Datediff('d ',DATE,now()))> 30 "
sqlCommand = New OleDbCommand(st rSQL, oledbConn)
Try
oledbConn.Open( )
sqlCommand.Exec uteNonQuery()...Leave a comment:
-
Oh !
What a foolish buddy am I ! I should'v noticed that. Thank u iburyak. Think it'll work now. Many many thanks frnd.
ZerinLeave a comment:
-
You can put a flag after reservation.... ..........which will change the value of the flag.And when a new customer is accessing the reservable list,check their flag value before they make a move.You can use a "INSTEAD OF" TRIGGER when the users tries to insert data in the view level.As I can guess is what you'll do.
As you didn't mention about what are you using to develop your software,so I gave a general idea........... ..actually....Leave a comment:
-
Dear iburyak ,
I tried the trigger and it gives the following error message:
Object 'machine' does not exist or is invalid for this operation.
Actually,I'm not expert in SQL Server.So,I can't understand what to do.MSDN search also don't have any fruitful reply.Please help !
Zerin...Leave a comment:
-
Dear iburyak ,
Thanks for the reply.Testing now.And 'll let u know.
Zerin...Leave a comment:
-
About deleting old files from a folder
Hi guys,
I started "autopurgin g" discussion many days ago.As I couldn't do it,so I decided to change my database into SQL Server.And so posted this problem here.
Plain and simple ------ I have a database named TANI and it has a table named "TANI" as well.
Table TANI has 3 fields only ------
1. CSV FILES that holds a link to some csv files from a folder
... -
Hello,
You can read this also: http://www.rondebruin.nl/zip.htm
May be you can get some interesting information.
Zerin...Leave a comment:
-
Dear Narayanan G V ,
I am suffering by the same problem also and decided to switch my database into SQL Server.If possible, you can do it too.
Or just learn socket programming and threading by VB.After you finish learning, I think you'll get the idea.Other than that........... ..............! ? I really don't know. May be exparts from the forum can help you.
Zerin...Leave a comment:
-
Dear members,
Got some information about Compact DB.You can go for:
http://support.microsoft.com/default...b;en-us;306287
Best regards,
Zerin...Leave a comment:
-
May GOD bless your holy souls !
This wish is for all who are trying to help me............. ...........
For the auto purging data topic.......... ...........
I think I should do it by Visual Basic.......... ......not in the database portion. I'm reading books and searching the web.In the meantime,you all also keep going.. ofcourse,if you have spare time for that.
I'll send my codes to this...Leave a comment:
-
Dear Neopa,
I tried the code in module with my Access database but it gives compilation error like: "Sub or Function not defined " for the following line of code:
the full code you sent me was:
Public Function CompactDb(ByVal strDB As String, _
Optional strPW As String = "") As Boolean
Dim strNewDB As String,...Leave a comment:
-
Dear NeoPa ,
Thanks for your reply.Actually, I don't have any idea where to set the options will be better. As far as I can understand,the delete method should find out the old data first and then delete them.Now, my software's requirement is that........... ...
1. The default value will be 1 month ( that means,identify first the old data and then delete every month's last day)
2. User choice should...Leave a comment:
-
Dear mmccarthy ,
Thanks for your reply.Actually, I don't have any idea where to set the options. As far as I can understand,the delete method should find out the old data first and then delete them.Now, my software's requirement is that........... ...
1. The default value will be 1 month ( that means,identify first the old data and then delete every month's last day)
2. User choice should be given to select...Leave a comment:
-
Thanks for your reply,
Actually,I developed a software using Visual Studio 2005 (by VB code).It uses Access database.Now,I want to delete data automatically after a month or two or any option given by the operator.
Can it be done? Please help me. Thanks in advance.
ZerinLeave a comment:
-
Auto Perging data
To all,
Best regards.I submitted this problem about auto purge a database many days ago but there's no reply till now.If anyone has any solution,please reply as soon as possible.
Is aouto purging possible in Visual Basic 2005 Express? How can I do it or get related codes?
Your help will be greatly honoured.
Zerin
No activity results to display
Leave a comment: