Jump to content
Sign in to follow this  

sqlite records

Recommended Posts


hi i donno this qurey is nt geting data properly wat is worng in it ? any bette solution

func _displayrecords()

If Not  _SQlite_Query (-1, "SELECT * FROM " & " " & $mytable & " " & " limit 1  offset "&$idrecord&";", $hQuerys)  = $SQLITE_OK Then _
_GUICtrlStatusBarSetText($StatusBar ,_SQLite_ErrMsg (), 2)

If Not  _SQLite_FetchData ($hQuerys, $aNames) = $SQLITE_OK Then _
_GUICtrlStatusBarSetText($StatusBar ,_SQLite_ErrMsg (), 2)

GUICtrlSetData($id, $aNames[0])
GUICtrlSetData($date, $aNames[1])
GUICtrlSetData($amount, $aNames[2])
GUICtrlSetData($voucher, $aNames[3])
GUICtrlSetData($description, $aNames[4])
GUICtrlSetData($posted_by, $aNames[5])
GUICtrlSetData($autherized_by, $aNames[6])
GUICtrlSetData($company, $aNames[7])
GUICtrlSetData($prints, $aNames[8])

_GUICtrlStatusBarSetText($StatusBar, $idrecord , 1)

If Not  _SQLite_QueryFinalize ($hQuerys)  = $SQLITE_OK Then _
_GUICtrlStatusBarSetText($StatusBar ,_SQLite_ErrMsg (), 2)    

Edited by autoitxp

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this