I want to insert into Oracle table values from Visual Basic. I created the like using ADODB and everything working fine.
but in my insert statment i'm recieving error
Below is the insert statment where limit is defined as integer and in the oracle table it is number.
SSQL = "Insert into ramzi_RECORD values(limit,1520)"
If i replace limit by any actual integer like 1,2,3...., it insert it in the database table.It seems i have to do a sort of concatination or add &.