Ask SQL sintax in vb6

[yasir sensei]

I have code : SQL = "SELECT kd_soal,pertanyaan,kunci,kategori_soal,status from soal WHERE status='AKTIF' AND kd_pelajaran ='" & Text1 & "' and kategori_soal='A' order by RAND() limit 8"

How to change number 8 with fill textbox....

[IkkeEnGij]

if Text2=8 then:

SQL = "SELECT kd_soal,pertanyaan,kunci,kategori_soal,status from soal WHERE status='AKTIF' AND kd_pelajaran ='" & Text1 & "' and kategori_soal='A' order by RAND() limit " & Text2