|
If you are determining the RecordNo on your end and not letting the database determine this then you will run into problems. I would let the database use an AutoNumber column for the RecordNo column OR in your Insert grab the highest RecordNo then add 1 to it and insert that, whatever you think would work best.
Cleako
|
|
|
|
|
Hi,
Recordno is auto.
thanks, Joseph
programmer
|
|
|
|
|
How are you inserting the new record then? If you are calling a SP or even using straight SQL it should create a new Recordno and should not violate the Primary Key constraint.
Cleako
|
|
|
|
|
Anyone got experience with ByteFX in Visual Basic 6?
I had it working once long time ago.
Don't remember how i did that though..
Could someone please help me with this?
Kind Regards
Sven (djnevs)
|
|
|
|
|
I’ve got a need to “add” an entire column of times (2 hrs, 30 min, etc.) and curious as to what the best starting point is. I want to calculate the total time of a column by means of a Button Click. I will need to do this per three different criteria for testing time.
I appreciate the advice.
|
|
|
|
|
You could just store the data in the column as an numeric value. For example, you can format the current time like this:
CInt(Now.ToString("hhmm"))
and now you have an integer value. There are also many other options for formating the time (You will want to research that, because I can't remember if hh or HH is military time and that will make a difference when you are converting the integer back into a DateTime object)
But I don't understand what you mean by calculating the total time of a column. You must mean that you want to get the time spans between the times right? Remember that there is a difference between a TimeSpan and a DateTime object.
Please provide more information if you need further help.
I hope this helps.
|
|
|
|
|
I knew what "I" was talking about and wanted; I didn't convey the actuals. Sorry.
I'm thinking time as in duration or test period. I apologize for the confusion on my part.
I have a column in an Access Db that states how long a test is running, 2 hours or 30 minutes and so on for 3 three different tests. Test A,B,C are in column 1 with the test duration in column 6.
Example:
Test 1
TestA 2.5 Hrs
TestA 30 Min
Test 2
TestB 20 Min
TestB 1.5 Hrs
Test 3
TestC 1 Hr
TestC 45 min
I need a way to calculate the entire testing times for Test 1, Test 2 and Test 3 individually. I am planning on having a ComboBox with these Tests 1,2,3 and a Button to Calculate the times associated with each test that is driven from the Access Db, per test.
Hope that makes better sense.
|
|
|
|
|
I'm still a bit confused. What is the data in your table going to look like?
I think I would suggest to store the testing durations as an integer value of minutes. So 2.5 hours would be stored as 150. Then you can convert them to display in whatever format you want later.
So, your initial question is still escaping me. If you are asking how to get the sum of the durations for each Test...it would be like this:
SELECT testField, SUM(duration) FROM table GROUP BY testField
If you are asking how to get the individual durations for a specific test it would be like this:
SELECT durationField FROM table WHERE testField='Test1'
If this is not what you are asking for, could you please explain the situation a little better. What is the difference between Test 1,2,3 and Test A,B,C?...what will your table look like with data in it?...what is it that your program is actually supposed to accomplish?
Hope this helps.
|
|
|
|
|
Sorry if I’m not explaining this very well.
I have under TestA, several test variations that each have a certain duration allotted to them. My need is to somehow calculate the entire time or duration for all tests in Test A and so on.
Example:
Test A - #1 takes 1 hr.
Test A - #2 takes 2 hrs.
Test A - #3 takes 3 hrs.
Button Click to add the entire Test A test times would equal 6 hrs.
The differences in Test A,B,C are all different tests. The 1,2,3 are tests performed for each Test A,B,C. Does that make sense?
This app is supposed to calculate the total duration of all testing to allocate personnel and resources effectively. Doesn’t seem logical to me, but evidently there’s a need for it.
|
|
|
|
|
That's okay...It's always hard to know what information is important when asking a question. But it seems to make more sense to me now. I think this is what you are looking for:
SELECT SUM(durationField) FROM table WHERE testField='TestA'
This will return the sum of durations for TestA.
Hope this works for you!
|
|
|
|
|
I'll give that a try and post a verdict. Thanks again for helping me and working through my information. I appreciate the help.
Thanks again.
|
|
|
|
|
Hi I am creating a listview dynamically.But the list view columns are not fixed .on runtime I can change the column by mouse like excel.I want to stop it.how can I do it.
Thanks in Advance
Sandy
|
|
|
|
|
Hello I am a visual basic starting developer for VWD. I was wondering how to make my website chat service "Live", I just need one page to be updated without a user having to press a button
Seanph
|
|
|
|
|
Hello I am a visual basic starting developer for VWD. I was wondering how to make my website chat service "Live", I just need one page to be updated without a user having to press a button
Seanph
|
|
|
|
|
Hi..
I am having a problem with understanding how to catch the selected index changed event of a drop down list when placed inside a datagrid..
I have two drop down lists inside a datagrid.. i.e. DDLA and DDLB.. I have set DDLA on Autopost back and I want DDLB to be populated from the
database once DDLA's selected index changes..
Can anybody give any ideas on how to get this done.. Thanks
Beneath the blue blue skies..........
|
|
|
|
|
I believe you will need to create a Protected Function for this purpose and in the column where you place the dropdownlist you will need to specify that function to be called when the index changes. The reason for this is that the objects inside the datagrid are created at runtime and therefore are not attached to any one function.
Cleako
|
|
|
|
|
Can anyone show me an example or two perhaps so that i could get a clearer idea of how to proceed..Thanks
|
|
|
|
|
<asp:DropDownList OnSelectedIndexChanged="TestFunction" runat="server" ID="ddlTesting"></asp:DropDownList>
After you have bound data to this then it should post back to the server after a drop down has occurred.
Cleako
|
|
|
|
|
hi,
how to convert an existing data in database to a string, in DataGrid
" i need something similar to : lstV.SubItems.Add(dt.Rows(i)("MTimeIN").ToString) which is used in list view" i need it in dataGrid
using vb2003
thank you
srour_costavo@hotmail.com
|
|
|
|
|
I hope I'm understanding the question correctly...
You want to replace the functionality of adding items to a ListView to an equivilent of adding items to a DataGrid, correct?
A DataGrid doesn't maintain collections of objects like a list view does. It's bound to datasources that maintain those collections. So, create a DataTable object with a DataColumn, add your items to that table and bind the DataGrid to that DataTable.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I know that in Java that "This." is required for accessing objects local to a form, etc. I also know that in VB.NET you CAN use "Me." for a similar purpose. I have never used it personally in my own code other than for Windows forms like "Me.Close()" but I have seen other people use it quite a bit and I noticed that in 1.1 the generated code always used "Me.". Is that just a programming style or is there more to it than that?
Thanks!
Cleako
|
|
|
|
|
cleako wrote: Is that just a programming style or is there more to it than that?
I think it is just a programming style. It is equivalent to this in C#, C++ and Java. Personally, I use this (or Me ) a lot because it shows intention more clearly, IMHO.
|
|
|
|
|
It's just a programming style. The compiler assumes Me. unless otherwise specified. Some people overuse it to death, putting Me. in front of everything, making the code painfully to read, even more so in the C# world with this. . It just makes your code easier to read in certain situations by taking away some abiguity, like in Property methods:
Public Class SomeClass
Private x As Integer
Public Property X() As Integer
Get
Return Me.x
End Get
Set(ByVal value As Integer)
Me.x = value
End Set
End Property
End Class
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Ahhhh, thanks, that's what I've seen and I've wondered.
Cleako
|
|
|
|
|
Dave Kreskowiak wrote: Some people overuse it to death, putting Me. in front of everything, making the code painfully to read, even more so in the C# world with this
Dave Kreskowiak wrote: It just makes your code easier to read in certain situations by taking away some abiguity, like in Property methods
I hope that I am sensible with where I use this and Me . However, I do use it a lot.
|
|
|
|