What can i do to change it on the database Erel?
You will need to make an UPDATE query (with the right values) after each table update.
I will only write in English as all the persons envolved understand it. If any Portuguese does´t understand just write "Traduz" - Se algum Português precisar de tradução por favor apenas pedir que traduzo.
Paulo i will have a long way to became good. There is a sub on Erel routine very usefull:
'This sub will be called before setting any value in table1.
'The value will only be set if Validate returns true.
Sub Validate(column, value)
If column = "Amount" AND Not(IsNumber(value)) Then
Msgbox("Value must be a number!")
Return False
Else
Return True
End If
End Sub
By this way i will always known where to update. The VACUUM part (is the first time i ear about it) is not my priority righ now, because i will not delete anything, just insert stock counting. I will look for it later. Right now i must understand how everything works. Next fase i must populate a combobox and learn how to make a SQL command based on the choice from the combo. I will get back to you soon i guess.
Thanks to you all, your help is fantastic. Regards.
cmd.CommandText="Select 'ubic' From 'inventario' Group By 'ubic' Order By 'ubic' Asc"
[COLOR="Blue"]Reader.Value=Cmd.ExecuteReader[/COLOR][COLOR="SeaGreen"] 'You forgot this part[/COLOR]
Do While reader.ReadNextRow=True
ComboBox1.add(reader.GetValue(0))
Loop
UPDATE table SET col1='value1', col2=... WHERE primaryfield = 'rowid'
We use cookies and similar technologies for the following purposes:
Do you accept cookies and these technologies?
We use cookies and similar technologies for the following purposes:
Do you accept cookies and these technologies?