I downloaded TimeLines.zip from
( http://www.mvps.org/access/reports/rpt0018.htm) and I think I found a
bug in it but I can't seem to fix it. When you open this go to the
table and enter a new event and put it's start date at like12/01/1999
and the end date at 12/31/1999. Then go to the report and find your new
entered event. If it does what it does on my computer you will notice
that for some reason the bar is in the wrong place. I'm guessing that
it has something to do with the math in the detail_Format section. The
report is perfect for what I need but if you put in an event in the
latter half of the timeline it doesn't seem to show correctly on the
chart. Any Ideas.
Thanks
Shawn Yates 11 3281
Oops I forgot to post the VBA code here is all of it:
Option Compare Database
Option Explicit
Private mdatEarliest As Date
Private mdatLatest As Date
Private mintDayDiff As Integer
------------------------------------------------------------------------------------------------------
Private Sub Detail_Format(C ancel As Integer, FormatCount As Integer)
Dim intStartDayDiff As Integer
Dim intDayDiff As Integer
Dim sngFactor As Single
On Error Resume Next
Me.ScaleMode = 1 'Twips
sngFactor = Me.boxMaxDays.W idth / mintDayDiff
If Not IsNull(Me.Start Date) And Not IsNull(Me.EndDa te) Then
Me.boxGrowForDa te.Visible = True
Me.lblTotalDays .Visible = True
intStartDayDiff = Abs(DateDiff("d ", Me.StartDate, mdatEarliest))
intDayDiff = Abs(DateDiff("d ", Me.EndDate, Me.StartDate))
If intStartDayDiff = 0 Then intStartDayDiff = 1
With Me.boxGrowForDa te
.Left = Me.boxMaxDays.L eft + (intStartDayDif f * sngFactor)
.Width = intDayDiff * sngFactor
End With
Me.lblTotalDays .Left = Me.boxGrowForDa te.Left
Me.lblTotalDays .Caption = intDayDiff & " Day(s)"
Else '
Me.boxGrowForDa te.Visible = False
Me.lblTotalDays .Visible = False
End If
End Sub
---------------------------------------------------------------------------------------------------------
Private Sub Report_Open(Can cel As Integer)
Dim db As Database
Dim rs As Recordset
Set db = CurrentDb
Set rs = db.OpenRecordse t("SELECT Min([Start Date]) AS MinOfStartDate
" _
& " FROM Projects", dbOpenSnapshot)
If rs.RecordCount 0 Then
mdatEarliest = rs!MinOfStartDa te
End If
Set rs = db.OpenRecordse t("SELECT Max(IIf(IsDate([End
Date]),CDate([End Date]),Null)) " _
& "AS MaxOfEndDate FROM Projects", dbOpenSnapshot)
If rs.RecordCount 0 Then
mdatLatest = rs!MaxOfEndDate
End If
mintDayDiff = DateDiff("d", mdatEarliest, mdatLatest)
Me.txtMinStartD ate.Caption = Format(mdatEarl iest, "mm/dd/yyyy")
Me.txtMaxEndDat e.Caption = Format(mdatLate st, "mm/dd/yyyy")
Set rs = Nothing
Set db = Nothing
End Sub
Classic bug, the left position is set before the width.
So
.Left = Me.boxMaxDays.L eft + (intStartDayDif f * sngFactor)
.Width = intDayDiff * sngFactor
Should be
.Width = intDayDiff * sngFactor
.Left = Me.boxMaxDays.L eft + (intStartDayDif f * sngFactor)
--
Terry Kreft
"Shawn Yates" <sy****@cc.usu. eduwrote in message
news:11******** *************@p 79g2000cwp.goog legroups.com...
I downloaded TimeLines.zip from
(http://www.mvps.org/access/reports/rpt0018.htm) and I think I found a
bug in it but I can't seem to fix it. When you open this go to the
table and enter a new event and put it's start date at like12/01/1999
and the end date at 12/31/1999. Then go to the report and find your new
entered event. If it does what it does on my computer you will notice
that for some reason the bar is in the wrong place. I'm guessing that
it has something to do with the math in the detail_Format section. The
report is perfect for what I need but if you put in an event in the
latter half of the timeline it doesn't seem to show correctly on the
chart. Any Ideas.
Thanks
Shawn Yates
Hi Shawn,
As a general rule you should avoid using 'On Error Resume Next'.
Anything could be happening in your code and you would not realise what
was going on (it also makes debugging easier as the code will stop
where the error occurs).
Good Luck
Nick
Shawn Yates wrote:
Oops I forgot to post the VBA code here is all of it:
Option Compare Database
Option Explicit
Private mdatEarliest As Date
Private mdatLatest As Date
Private mintDayDiff As Integer
------------------------------------------------------------------------------------------------------
Private Sub Detail_Format(C ancel As Integer, FormatCount As Integer)
Dim intStartDayDiff As Integer
Dim intDayDiff As Integer
Dim sngFactor As Single
On Error Resume Next
Me.ScaleMode = 1 'Twips
sngFactor = Me.boxMaxDays.W idth / mintDayDiff
If Not IsNull(Me.Start Date) And Not IsNull(Me.EndDa te) Then
Me.boxGrowForDa te.Visible = True
Me.lblTotalDays .Visible = True
intStartDayDiff = Abs(DateDiff("d ", Me.StartDate, mdatEarliest))
intDayDiff = Abs(DateDiff("d ", Me.EndDate, Me.StartDate))
If intStartDayDiff = 0 Then intStartDayDiff = 1
With Me.boxGrowForDa te
.Left = Me.boxMaxDays.L eft + (intStartDayDif f * sngFactor)
.Width = intDayDiff * sngFactor
End With
Me.lblTotalDays .Left = Me.boxGrowForDa te.Left
Me.lblTotalDays .Caption = intDayDiff & " Day(s)"
Else '
Me.boxGrowForDa te.Visible = False
Me.lblTotalDays .Visible = False
End If
End Sub
---------------------------------------------------------------------------------------------------------
Private Sub Report_Open(Can cel As Integer)
Dim db As Database
Dim rs As Recordset
Set db = CurrentDb
Set rs = db.OpenRecordse t("SELECT Min([Start Date]) AS MinOfStartDate
" _
& " FROM Projects", dbOpenSnapshot)
If rs.RecordCount 0 Then
mdatEarliest = rs!MinOfStartDa te
End If
Set rs = db.OpenRecordse t("SELECT Max(IIf(IsDate([End
Date]),CDate([End Date]),Null)) " _
& "AS MaxOfEndDate FROM Projects", dbOpenSnapshot)
If rs.RecordCount 0 Then
mdatLatest = rs!MaxOfEndDate
End If
mintDayDiff = DateDiff("d", mdatEarliest, mdatLatest)
Me.txtMinStartD ate.Caption = Format(mdatEarl iest, "mm/dd/yyyy")
Me.txtMaxEndDat e.Caption = Format(mdatLate st, "mm/dd/yyyy")
Set rs = Nothing
Set db = Nothing
End Sub
Thanks Terry, I did this and it fixed the problem.
Should be
.Width = intDayDiff * sngFactor
.Left = Me.boxMaxDays.L eft + (intStartDayDif f * sngFactor)
I also got rid of "On Error Resume Next" as Nick suggested but now I
have a new issue. When I put in an event that spans almost from the
beginnig to the end of my time line it displays error 2100 "The control
or subform control is too large for this location" so I debug and
..Width = intDayDiff * sngFactor is highlighted. I put my cursor over
intDayDiff and sure enough it is the event that spans most of the
timeline. I checked:
sngFactor = Me.boxMaxTime.W idth / mintTimeDiff
and I also checked
..Left = Me.boxMaxTime.L eft + (intStartTimeDi ff * sngFactor)
and this should easily fit without problem.
Next I went to the design view of my report and streache the page way
out to see if it would fix the problem. Oddly enough the error 2100
didn't show up and now with a huge amount of space the event is exactly
where it should be (it doesn't strech way outside the page like I
thought it might). Any ideas why this is happening or how to fix it?
I would write the procedure something like
Private Sub Detail_Format(C ancel As Integer, FormatCount As Integer)
Dim intStartDayDiff As Integer
Dim intDayDiff As Integer
Dim sngFactor As Single
Me.ScaleMode = 1 'Twips
sngFactor = Me.boxMaxDays.W idth / mintDayDiff
If Not IsNull(Me.Start Date) And Not IsNull(Me.EndDa te) Then
With Me
intStartDayDiff = Abs(DateDiff("d ", .StartDate, mdatEarliest))
intDayDiff = Abs(DateDiff("d ", .EndDate, .StartDate))
If intStartDayDiff = 0 Then
intStartDayDiff = 1
End If
.boxGrowForDate .Left = .boxMaxDays.Lef t
.boxGrowForDate .Width = intDayDiff * sngFactor
.boxGrowForDate .Left = .boxMaxDays.Lef t + (intStartDayDif f *
sngFactor)
If (.boxGrowForDat e.Left + .lblTotalDays.W idth) <= .boxMaxDays.Lef t +
..boxMaxDays.Wi dth Then
.lblTotalDays.L eft = .boxGrowForDate .Left
ElseIf (.boxGrowForDat e.Left + .lblTotalDays.W idth) .boxMaxDays.Lef t
+ .boxMaxDays.Wid th Then
.lblTotalDays.L eft = .boxMaxDays.Lef t + .boxMaxDays.Wid th -
..lblTotalDays. Width
Else
.lblTotalDays.L eft = .boxMaxDays.Lef t
End If
.lblTotalDays.C aption = intDayDiff & " Day(s)"
.boxGrowForDate .Visible = True
.lblTotalDays.V isible = True
End With
Else '
With Me
.boxGrowForDate .Visible = False
.lblTotalDays.V isible = False
End With
End If
End Sub
--
Terry Kreft
"Shawn Yates" <sy****@cc.usu. eduwrote in message
news:11******** *************@s 13g2000cwa.goog legroups.com...
>
Thanks Terry, I did this and it fixed the problem.
Should be
.Width = intDayDiff * sngFactor
.Left = Me.boxMaxDays.L eft + (intStartDayDif f * sngFactor)
I also got rid of "On Error Resume Next" as Nick suggested but now I
have a new issue. When I put in an event that spans almost from the
beginnig to the end of my time line it displays error 2100 "The control
or subform control is too large for this location" so I debug and
.Width = intDayDiff * sngFactor is highlighted. I put my cursor over
intDayDiff and sure enough it is the event that spans most of the
timeline. I checked:
sngFactor = Me.boxMaxTime.W idth / mintTimeDiff
and I also checked
.Left = Me.boxMaxTime.L eft + (intStartTimeDi ff * sngFactor)
and this should easily fit without problem.
Next I went to the design view of my report and streache the page way
out to see if it would fix the problem. Oddly enough the error 2100
didn't show up and now with a huge amount of space the event is exactly
where it should be (it doesn't strech way outside the page like I
thought it might). Any ideas why this is happening or how to fix it?
I should have added:-
Do you see now how much code that On Error Resume Next had to be replaced
by, and I'm not guaranteeing that I got it exactly right.
My personal opinion on the "On Error Resume Next" construct is that it is
just another tool, so long as you understand what it is doing for you and
what it is hiding from you then there is no reason to not use it, what
causes the problem is when people it without thinking about it.
--
Terry Kreft
"Terry Kreft" <te*********@mp s.co.ukwrote in message
news:ld******** ************@ka roo.co.uk...
I would write the procedure something like
Private Sub Detail_Format(C ancel As Integer, FormatCount As Integer)
Dim intStartDayDiff As Integer
Dim intDayDiff As Integer
Dim sngFactor As Single
Me.ScaleMode = 1 'Twips
sngFactor = Me.boxMaxDays.W idth / mintDayDiff
If Not IsNull(Me.Start Date) And Not IsNull(Me.EndDa te) Then
With Me
intStartDayDiff = Abs(DateDiff("d ", .StartDate, mdatEarliest))
intDayDiff = Abs(DateDiff("d ", .EndDate, .StartDate))
If intStartDayDiff = 0 Then
intStartDayDiff = 1
End If
.boxGrowForDate .Left = .boxMaxDays.Lef t
.boxGrowForDate .Width = intDayDiff * sngFactor
.boxGrowForDate .Left = .boxMaxDays.Lef t + (intStartDayDif f *
sngFactor)
If (.boxGrowForDat e.Left + .lblTotalDays.W idth) <= .boxMaxDays.Lef t
+
.boxMaxDays.Wid th Then
.lblTotalDays.L eft = .boxGrowForDate .Left
ElseIf (.boxGrowForDat e.Left + .lblTotalDays.W idth) >
..boxMaxDays.Le ft
+ .boxMaxDays.Wid th Then
.lblTotalDays.L eft = .boxMaxDays.Lef t + .boxMaxDays.Wid th -
.lblTotalDays.W idth
Else
.lblTotalDays.L eft = .boxMaxDays.Lef t
End If
.lblTotalDays.C aption = intDayDiff & " Day(s)"
.boxGrowForDate .Visible = True
.lblTotalDays.V isible = True
End With
Else '
With Me
.boxGrowForDate .Visible = False
.lblTotalDays.V isible = False
End With
End If
End Sub
--
Terry Kreft
"Shawn Yates" <sy****@cc.usu. eduwrote in message
news:11******** *************@s 13g2000cwa.goog legroups.com...
Thanks Terry, I did this and it fixed the problem.
Should be
.Width = intDayDiff * sngFactor
.Left = Me.boxMaxDays.L eft + (intStartDayDif f * sngFactor)
I also got rid of "On Error Resume Next" as Nick suggested but now I
have a new issue. When I put in an event that spans almost from the
beginnig to the end of my time line it displays error 2100 "The control
or subform control is too large for this location" so I debug and
.Width = intDayDiff * sngFactor is highlighted. I put my cursor over
intDayDiff and sure enough it is the event that spans most of the
timeline. I checked:
sngFactor = Me.boxMaxTime.W idth / mintTimeDiff
and I also checked
.Left = Me.boxMaxTime.L eft + (intStartTimeDi ff * sngFactor)
and this should easily fit without problem.
Next I went to the design view of my report and streache the page way
out to see if it would fix the problem. Oddly enough the error 2100
didn't show up and now with a huge amount of space the event is exactly
where it should be (it doesn't strech way outside the page like I
thought it might). Any ideas why this is happening or how to fix it?
I should have added:-
Do you see now how much code that On Error Resume Next had to be replaced
by, and I'm not guaranteeing that I got it exactly right.
My personal opinion on the "On Error Resume Next" construct is that it is
just another tool, so long as you understand what it is doing for you and
what it is hiding from you then there is no reason to not use it, what
causes the problem is when people it without thinking about it.
--
Terry Kreft
"Terry Kreft" <te*********@mp s.co.ukwrote in message
news:ld******** ************@ka roo.co.uk...
I would write the procedure something like
Private Sub Detail_Format(C ancel As Integer, FormatCount As Integer)
Dim intStartDayDiff As Integer
Dim intDayDiff As Integer
Dim sngFactor As Single
Me.ScaleMode = 1 'Twips
sngFactor = Me.boxMaxDays.W idth / mintDayDiff
If Not IsNull(Me.Start Date) And Not IsNull(Me.EndDa te) Then
With Me
intStartDayDiff = Abs(DateDiff("d ", .StartDate, mdatEarliest))
intDayDiff = Abs(DateDiff("d ", .EndDate, .StartDate))
If intStartDayDiff = 0 Then
intStartDayDiff = 1
End If
.boxGrowForDate .Left = .boxMaxDays.Lef t
.boxGrowForDate .Width = intDayDiff * sngFactor
.boxGrowForDate .Left = .boxMaxDays.Lef t + (intStartDayDif f *
sngFactor)
If (.boxGrowForDat e.Left + .lblTotalDays.W idth) <= .boxMaxDays.Lef t
+
.boxMaxDays.Wid th Then
.lblTotalDays.L eft = .boxGrowForDate .Left
ElseIf (.boxGrowForDat e.Left + .lblTotalDays.W idth) >
..boxMaxDays.Le ft
+ .boxMaxDays.Wid th Then
.lblTotalDays.L eft = .boxMaxDays.Lef t + .boxMaxDays.Wid th -
.lblTotalDays.W idth
Else
.lblTotalDays.L eft = .boxMaxDays.Lef t
End If
.lblTotalDays.C aption = intDayDiff & " Day(s)"
.boxGrowForDate .Visible = True
.lblTotalDays.V isible = True
End With
Else '
With Me
.boxGrowForDate .Visible = False
.lblTotalDays.V isible = False
End With
End If
End Sub
--
Terry Kreft
"Shawn Yates" <sy****@cc.usu. eduwrote in message
news:11******** *************@s 13g2000cwa.goog legroups.com...
Thanks Terry, I did this and it fixed the problem.
Should be
.Width = intDayDiff * sngFactor
.Left = Me.boxMaxDays.L eft + (intStartDayDif f * sngFactor)
I also got rid of "On Error Resume Next" as Nick suggested but now I
have a new issue. When I put in an event that spans almost from the
beginnig to the end of my time line it displays error 2100 "The control
or subform control is too large for this location" so I debug and
.Width = intDayDiff * sngFactor is highlighted. I put my cursor over
intDayDiff and sure enough it is the event that spans most of the
timeline. I checked:
sngFactor = Me.boxMaxTime.W idth / mintTimeDiff
and I also checked
.Left = Me.boxMaxTime.L eft + (intStartTimeDi ff * sngFactor)
and this should easily fit without problem.
Next I went to the design view of my report and streache the page way
out to see if it would fix the problem. Oddly enough the error 2100
didn't show up and now with a huge amount of space the event is exactly
where it should be (it doesn't strech way outside the page like I
thought it might). Any ideas why this is happening or how to fix it?
For a fully working database, if you have an issue then the On Error
Resume Next gets round with out having to write reams of code then yes
it is just another tool. However if you are developing a database it
is and I think that you will agree a big no no. I feel that if you do
use it you should use it only for the lines of code that need it, then
turn the error handling on again.
Good Luck
Nick
Terry Kreft wrote:
I should have added:-
Do you see now how much code that On Error Resume Next had to be replaced
by, and I'm not guaranteeing that I got it exactly right.
My personal opinion on the "On Error Resume Next" construct is that it is
just another tool, so long as you understand what it is doing for you and
what it is hiding from you then there is no reason to not use it, what
causes the problem is when people it without thinking about it.
--
Terry Kreft
"Terry Kreft" <te*********@mp s.co.ukwrote in message
news:ld******** ************@ka roo.co.uk...
I would write the procedure something like
Private Sub Detail_Format(C ancel As Integer, FormatCount As Integer)
Dim intStartDayDiff As Integer
Dim intDayDiff As Integer
Dim sngFactor As Single
Me.ScaleMode = 1 'Twips
sngFactor = Me.boxMaxDays.W idth / mintDayDiff
If Not IsNull(Me.Start Date) And Not IsNull(Me.EndDa te) Then
With Me
intStartDayDiff = Abs(DateDiff("d ", .StartDate, mdatEarliest))
intDayDiff = Abs(DateDiff("d ", .EndDate, .StartDate))
If intStartDayDiff = 0 Then
intStartDayDiff = 1
End If
.boxGrowForDate .Left = .boxMaxDays.Lef t
.boxGrowForDate .Width = intDayDiff * sngFactor
.boxGrowForDate .Left = .boxMaxDays.Lef t + (intStartDayDif f *
sngFactor)
If (.boxGrowForDat e.Left + .lblTotalDays.W idth) <= .boxMaxDays.Lef t
+
.boxMaxDays.Wid th Then
.lblTotalDays.L eft = .boxGrowForDate .Left
ElseIf (.boxGrowForDat e.Left + .lblTotalDays.W idth) >
.boxMaxDays.Lef t
+ .boxMaxDays.Wid th Then
.lblTotalDays.L eft = .boxMaxDays.Lef t + .boxMaxDays.Wid th -
.lblTotalDays.W idth
Else
.lblTotalDays.L eft = .boxMaxDays.Lef t
End If
.lblTotalDays.C aption = intDayDiff & " Day(s)"
.boxGrowForDate .Visible = True
.lblTotalDays.V isible = True
End With
Else '
With Me
.boxGrowForDate .Visible = False
.lblTotalDays.V isible = False
End With
End If
End Sub
--
Terry Kreft
"Shawn Yates" <sy****@cc.usu. eduwrote in message
news:11******** *************@s 13g2000cwa.goog legroups.com...
>
Thanks Terry, I did this and it fixed the problem.
Should be
.Width = intDayDiff * sngFactor
.Left = Me.boxMaxDays.L eft + (intStartDayDif f * sngFactor)
I also got rid of "On Error Resume Next" as Nick suggested but now I
have a new issue. When I put in an event that spans almost from the
beginnig to the end of my time line it displays error 2100 "The control
or subform control is too large for this location" so I debug and
.Width = intDayDiff * sngFactor is highlighted. I put my cursor over
intDayDiff and sure enough it is the event that spans most of the
timeline. I checked:
sngFactor = Me.boxMaxTime.W idth / mintTimeDiff
and I also checked
.Left = Me.boxMaxTime.L eft + (intStartTimeDi ff * sngFactor)
and this should easily fit without problem.
Next I went to the design view of my report and streache the page way
out to see if it would fix the problem. Oddly enough the error 2100
didn't show up and now with a huge amount of space the event is exactly
where it should be (it doesn't strech way outside the page like I
thought it might). Any ideas why this is happening or how to fix it?
>
Terry Kreft wrote:
I should have added:-
Do you see now how much code that On Error Resume Next had to be replaced
by, and I'm not guaranteeing that I got it exactly right.
My personal opinion on the "On Error Resume Next" construct is that it is
just another tool, so long as you understand what it is doing for you and
what it is hiding from you then there is no reason to not use it, what
causes the problem is when people it without thinking about it.
--
Terry Kreft
"Terry Kreft" <te*********@mp s.co.ukwrote in message
news:ld******** ************@ka roo.co.uk...
I would write the procedure something like
Private Sub Detail_Format(C ancel As Integer, FormatCount As Integer)
Dim intStartDayDiff As Integer
Dim intDayDiff As Integer
Dim sngFactor As Single
Me.ScaleMode = 1 'Twips
sngFactor = Me.boxMaxDays.W idth / mintDayDiff
If Not IsNull(Me.Start Date) And Not IsNull(Me.EndDa te) Then
With Me
intStartDayDiff = Abs(DateDiff("d ", .StartDate, mdatEarliest))
intDayDiff = Abs(DateDiff("d ", .EndDate, .StartDate))
If intStartDayDiff = 0 Then
intStartDayDiff = 1
End If
.boxGrowForDate .Left = .boxMaxDays.Lef t
.boxGrowForDate .Width = intDayDiff * sngFactor
.boxGrowForDate .Left = .boxMaxDays.Lef t + (intStartDayDif f *
sngFactor)
If (.boxGrowForDat e.Left + .lblTotalDays.W idth) <= .boxMaxDays.Lef t
+
.boxMaxDays.Wid th Then
.lblTotalDays.L eft = .boxGrowForDate .Left
ElseIf (.boxGrowForDat e.Left + .lblTotalDays.W idth) >
.boxMaxDays.Lef t
+ .boxMaxDays.Wid th Then
.lblTotalDays.L eft = .boxMaxDays.Lef t + .boxMaxDays.Wid th -
.lblTotalDays.W idth
Else
.lblTotalDays.L eft = .boxMaxDays.Lef t
End If
.lblTotalDays.C aption = intDayDiff & " Day(s)"
.boxGrowForDate .Visible = True
.lblTotalDays.V isible = True
End With
Else '
With Me
.boxGrowForDate .Visible = False
.lblTotalDays.V isible = False
End With
End If
End Sub
--
Terry Kreft
"Shawn Yates" <sy****@cc.usu. eduwrote in message
news:11******** *************@s 13g2000cwa.goog legroups.com...
>
Thanks Terry, I did this and it fixed the problem.
Should be
.Width = intDayDiff * sngFactor
.Left = Me.boxMaxDays.L eft + (intStartDayDif f * sngFactor)
I also got rid of "On Error Resume Next" as Nick suggested but now I
have a new issue. When I put in an event that spans almost from the
beginnig to the end of my time line it displays error 2100 "The control
or subform control is too large for this location" so I debug and
.Width = intDayDiff * sngFactor is highlighted. I put my cursor over
intDayDiff and sure enough it is the event that spans most of the
timeline. I checked:
sngFactor = Me.boxMaxTime.W idth / mintTimeDiff
and I also checked
.Left = Me.boxMaxTime.L eft + (intStartTimeDi ff * sngFactor)
and this should easily fit without problem.
Next I went to the design view of my report and streache the page way
out to see if it would fix the problem. Oddly enough the error 2100
didn't show up and now with a huge amount of space the event is exactly
where it should be (it doesn't strech way outside the page like I
thought it might). Any ideas why this is happening or how to fix it?
>
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Sarah Tanembaum |
last post by:
Beside its an opensource and supported by community, what's the fundamental
differences between PostgreSQL and those high-price commercial database (and
some are bloated such as Oracle) from software giant such as Microsoft SQL
Server, Oracle, and Sybase?
Is PostgreSQL reliable enough to be used for high-end commercial
application? Thanks
|
by: E. Robert Tisdale |
last post by:
What makes a good C/C++ programmer?
Would you be surprised if I told you that
it has almost nothing to do with your knowledge of C or C++?
There isn't much difference in productivity, for example,
between a C/C++ programmers with a few weeks of experience
and a C/C++ programmer with years of experience.
You don't really need to understand the subtle details
or use the obscure features of either language
|
by: typingcat |
last post by:
First of all, I'm an Asian and I need to input Japanese, Korean and so
on. I've tried many PHP IDEs today, but almost non of them supported
Unicode (UTF-8) file.
I've found that the only Unicode support IDEs are DreamWeaver 8 and
Zend PHP Studio.
DreamWeaver provides full support for Unicode. However, DreamWeaver is
a web editor rather than a PHP IDE. It only supports basic IntelliSense
(or code completion) and doesn't have anything...
|
by: WindAndWaves |
last post by:
Can anyone tell me what is wrong with the goto command. I noticed it is one
of those NEVER USE.
I can understand that it may lead to confusing code, but I often use it like
this:
is this wrong?????
Function x
select case z
|
by: Keith K |
last post by:
Having developed with VB since 1992, I am now VERY
interested in C#. I've written several applications with
C# and I do enjoy the language.
What C# Needs:
There are a few things that I do believe MSFT should do to
improve C#, however.
I know that in the "Whidbey" release of VS.NET currently
| |
by: Jason Huang |
last post by:
Hi,
Would someone explain the following coding more detail for me? What's the
( ) for?
CurrentText = (TextBox)e.Item.Cells.Controls;
Thanks.
Jason
|
by: GS |
last post by:
I got a combobox box that I load at load time. the Item and vales ended up
in reverse order of each other, what went wrong?
the database table has the following row
code value
ebay http://www.ebay.com
google http://www.google.com
yahoo http://www.yahoo.com
However in the drop down list
displayed value used
ebay http://www.yahoo.com
|
by: tjb |
last post by:
I often see code like this:
/// <summary>
/// Removes a node.
/// </summary>
/// <param name="node">The node to remove.</param>
public void RemoveNode(Node node) {
<...>
}
|
by: Pyenos |
last post by:
import cPickle, shelve
could someone tell me what things are wrong with my code?
class progress:
PROGRESS_TABLE_ACTIONS=
DEFAULT_PROGRESS_DATA_FILE="progress_data"
PROGRESS_OUTCOMES=
|
by: Daniel.C |
last post by:
Hello.
I just copied this code from my book with no modification :
#include <stdio.h>
/* count characters in input; 1st version */
main()
{
long nc;
nc = 0;
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |