autoitxp Posted November 29, 2007 Posted November 29, 2007 (edited) 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) EndFunc Edited November 29, 2007 by autoitxp
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now