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

This will add multiple rows for msaccess:

;
; 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


  ; Establish Recordset
  t = BD_SQLQuery("Select * from table1 where 1=2 ")
  ;	BD_CloseQuery()
		
  ; add row
For i=1 To 10
	BD_AddRecord()
	BD_SetStringColumn("LNAME", "SPRINGSTEEN")
	BD_SetStringColumn("FNAME", "BRUCE")
	BD_SetIntegerColumn("AGE", i)
	BD_UpdateRecord()
Next
EndIf

Text 20,40,"Press space to close"
Flip
While Not GetKey():Wend

BD_CloseQuery()
BD_CloseDatabase()