this is about "runtime error -2147024773(8007007b) the filename, directory name, or volume label syntax is incorrect" in vb6

[adam...@gmail.com]

I always got this error when i update or save the data from database after searching it from table.

There is no problem when i save or update the data after simply select it from datagrid with adodc.

am using vb6.0.

here are my sample code

Private Sub Form_Load()
Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\deo stock\datafile\deo6.mdb"
End Sub



Private Sub Cmdsearch_Click()
Adodc1.RecordSource = "select * from products where productname like ('%" & Text1.Text & "%')"
Adodc1.Refresh
End Sub


Private Sub Cmdcalculation_Click() 'normal calculation in one of table field
Dim result As Integer
result = Val(text3.Text) - Val(text2.Text)
text3.Text = result
End Sub


Private Sub cmdupdate_Click()
With Adodc1
.Recordset.Save
End With
End Sub




database file: deo6.mdb
table name: products
record source= select * from products
text1.text= textbox for giving the product name to search from [productname] field


i need help.
thanx

[Evertjan.]

adamnjam wrote on 13 nov 2012 in microsoft.public.scripting.vbscript:
> Dim result As Integer

VB6 is not VB-script.

Wrong NG.

--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

[Dave "Crash" Dummy]

Evertjan. wrote:
> adamnjam wrote on 13 nov 2012 in microsoft.public.scripting.vbscript:
>> Dim result As Integer
>
> VB6 is not VB-script.
>
> Wrong NG.

I expect no less from Google Gropes! (No, that is not a spelling error.)
--
Crash

"Facts are stubborn things, but statistics are more pliable."
~ Laurence J. Peter ~

[Evertjan.]

Dave "Crash" Dummy wrote on 13 nov 2012 in

microsoft.public.scripting.vbscript:

> Evertjan. wrote:
>> adamnjam wrote on 13 nov 2012 in microsoft.public.scripting.vbscript:
>>> Dim result As Integer
>>
>> VB6 is not VB-script.
>>
>> Wrong NG.
>
> I expect no less

Your error,
the name of this group ends in .vbscript,
not in .vb of .vba.

> from Google Gropes! (No, that is not a spelling error.)

This is not a Google group, not even the w.w.web, this is Usenet.