Click here to Skip to main content
14,669,422 members
Rate this:
Please Sign up or sign in to vote.
See more:

i am developing a s/w for a blood bank
and i want when i make delivery of blood the blood got decrement in stock as well
i am using vb6 with oracle 8i.
Off-topic! This is a forum for software developers or students.
rajinder raviya 27-Oct-11 2:57am
for studemts

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

thnx "SAKryukov"
i got my solution.
it was this=========

Set cn = New ADODB.Connection
Set rec = New ADODB.Recordset
cn.Open "provider=MSDAORA.1; user id = scott; password=tiger;"
'cn.Open "Provider=MSDAORA.1;Password=mca2862;User ID=mca2862;Data Source=aim;Persist Security Info=True;"
Set rec = New ADODB.Recordset
rec.ActiveConnection = cn
rec.LockType = adLockOptimistic
rec.CursorLocation = adUseClient
rec.Source = "blood_stock"
rec.Open "select * from blood_stock"
rec.Fields(1) = rec.Fields(1) + Combo1.Text

""fields(1) which i want to update and combo1 from where i fetch the value.""

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100