Hi all,
I am scratching my head on how to store image that user upload to the MySQL database in vb6?
Please HELP me!!
Thank you very much..
berry
Last Activity: Jan 18 '08, 03:02 PM
Joined: May 15 '07
Location:
-
How to store image to Mysql database using vb?
-
berry started a topic error: Row cannot be located for updating. Some value may have been changes since...in Visual Basicerror: Row cannot be located for updating. Some value may have been changes since...
Hi all...
I want to delete the data that over 5years. But my code has such error:
"vb6 error: Row cannot be located for updating. Some value may have been changed since it was last read."
And my code is:
...Code:If IsNull(rs.Fields("dateVar")) Then GoTo nextStep Else rs.MoveFirst Do While (rs.EOF <> True) If (DateDiff("yyyy", -
Hi killer42,
I can't use this code because i need to compare to the date in the database, I don't know the cut-off-date.... -
Hi Dokoll,
Thank you for your reply.
Ya, it can read the data. It can calculate the date different within the date in database and today's date. So it means that the row can be read right??
But when reach to the rs.delete, the error will occur.
I wonder what's the problem over there..
Hope can get the answer..
Thanks......Leave a comment:
-
Print datagrid
Hi al..
How to print all data in the datagrid?? Including the row header?
Hope to help.
Thank you very much.. -
delete error
Hi all...
I want to delete the 5 years ago's databases and there is an error occur in the line "rs.delete" . Below is my code.
The error is:
"Row cannot be located for updating. Some values may have been changed since it was last read."
This error will occur when rs reach the row that it should be deleted. What should I do?? Thanks for help.
...Code:rs.MoveFirst
-
Hi dip_developer,
Do you have any example? Because i facing the same problem and i don't know how to set the datakey to primary key.
Thank you very much.....Leave a comment:
-
causesvalidation property
Hi..
What is causesvalidatio n property and how it's work? I had check for it but still can't get the meaning. Hope you guys can tell me.
Thank you.. -
get from notepad
Hi all..
I would like to know how to get the words from the notepad.
This is the case:
I have a lot of form with many ADODC. But all ADODC's connection string are connect to the same location, using the same password, same IP address... and now, to convenient the update job in the future (I mean when change the IP address), others can easily just edit in the notepad, not in the code. How do I do that?
... -
How to draw a line graph?
Hi all..
How to draw a line graph? My axis-x is the daily hour from 8am to 8pm. Can i use a XY mschart type to draw it? Or I must use a picture box to draw it? If with XY chart type, how to draw?
Thank you.. -
Hi.. Thanks for your help. But there are some problem..
...Code:Private Sub Calendar1_Click() Text1 = Calendar1.Value 'This will write the data in Calendar to the text box 'Is it so? Did you check this properly. There should be an error in this code 'how come you did not encounter it 'Ya, this is to place the date into textbox to let the user saw the date that he press. cause after click, i will invisible the calendar.
Leave a comment:
-
I write my code as:
...Code:Private Sub cmbMonth_Click() If cmbMonth.Text = "January" Then Text2 = 1 ElseIf cmbMonth.Text = "February" Then Text2 = 2 ElseIf cmbMonth.Text = "March" Then Text2 = 3 ElseIf cmbMonth.Text = "April" Then Text2 = 4 ElseIf cmbMonth.Text = "May" Then Text2 = 5 ElseIf cmbMonth.TextLeave a comment:
-
Hi..I still can't get it. The datagrid shows empty. I don't know why. Here I attach my code and hope you can take a look.
In the form, I have:
2 comand buttons - saveBtn, selectDateBtn
1 text box - Text1
1 adodc - Adodc1
1 datagrid - DataGrid1
1 calendar - Calendar1
Please help me. Thanks...
...Code:Private conn As ADODB.Connection Private rs As ADODB.Recordset
Leave a comment:
-
This is the uneitted code. Please have a look.
Is it neccessary to dim the text as date?...Code:Private Sub showDate() Adodc1.RecordSource = "select * from date where dateNow = '" & Text1 & "' " Adodc1.Refresh DataGrid1.Refresh ' where dateNow is field name and Text1 is the date key in by user End Sub
Leave a comment:
-
Hi..I had tried the code. But still can't get it. Any other idea to get a specific date from database and show in datagrid?
Thanks......Leave a comment:
-
Hi..I had tried the code u gave. But it still can't work. Any other idea to get a particular date from server and show in the datagrid?
Thanks.....Leave a comment:
-
get month
Hi all..
I wana to get the specific date which is in database and show in the datagrid.
For example, I want key in the 'january' in a text box and want to get all january data. How I call it out? I'd tried but can't get it. My code is:
where userData is the field name, txtMonth is the text box i key in the month.Code:Adodc1.RecordSource = "select * from date where userDate LIKE 'txtMonth %'"
Please help me.... -
Hi, I'd tried. I still can't get the answer. The datagrid shows nothing. I also tried to dim the text in txtdate as DATE. But it also can't work. Any other idea to get the specific date from the database and show in the datagrid?...Leave a comment:
-
delete a row
Hi..
In vb6, how to delete a row of data which the recordset is at that row?
For Example, the current data in the database is:
Num Name DOB
1 A 5/2/1990
2 B 5/5/1985
3 C 7/2/1989
All these data is presented in datagrid. Now, the user move the recordset to 2nd row and want to delete it. What is the code?
Thanks... -
Help! Weird scene..
I met a strange scene in my code. I succeed to call out the number i want from the database. But when I sum it up, the amount is incorrect. Even i had pop up messagebox before it do the calculation. And the number shown is correct. The only thing is when the hour add to the value in flexgrid, the answer is wrong. Please Help me. I think of it so long time but still can't get it.
Thanks a lot...
Data in the server is:
...
No activity results to display
Leave a comment: