Blitz - MySQL?

The forum is locked. These are the original blitzbasic.com forums, kept so they can still be read. No new topics, replies or edits can be made here. To join in, head over to the Blitz3D+ forums.

Wayne

I could not get multiple inserts to work as in the following:
ONLY WORKED FOR FIRST INSERT, don't know why.

;
; ADDING ROWS
; 
Graphics 800,600,32,2
SetBuffer BackBuffer()

t% = BD_OpenDatabase("c:\TEST.mdb","","","",3)

If t = -1 Then

  Text 20,20,"Could not open database."
  Flip
  key = WaitKey()
  End

Else

  Text 20,20,"Opened TEST database Successfully, press any key to add records"
  Flip
  While Not GetKey():Wend

	  ; add row
	For i=1 To 10
			t = BD_SQLQuery("insert into table1 (LNAME,FNAME,AGE) values('Doe','John',25);")
	Next
 
End If
While Not GetKey():Wend

Text 40,40,"Press space to close"
Flip

While Not GetKey():Wend
BD_CloseQuery()
BD_CloseDatabase()