jjj Posted June 23, 2006 Share Posted June 23, 2006 I am trying to delete an entire row from a table in a sqlite database using this udf. I am not sure what all of the commands do, so the only thing i can think of is writing "" to each of the table's entries for the row that I want to delete, but that isn't quite what I want to do.Can anyone who knows this udf or sqlite suggest an approach for me to take?Thanks! Link to comment Share on other sites More sharing options...
randallc Posted June 24, 2006 Share Posted June 24, 2006 Hi, i have not had much interest in this, so documentation minimal; if you have version ";SqliteExe.au3 v 3_3_5_12" then _SQL_DeleteRow(byref $sDB1, $sDBTable1,$s_Prepare,$i_Execute=1) Best, Randall ExcelCOM... AccessCom.. Word2... FileListToArrayNew...SearchMiner... Regexps...SQL...Explorer...Array2D.. _GUIListView...array problem...APITailRW Link to comment Share on other sites More sharing options...
jjj Posted June 24, 2006 Author Share Posted June 24, 2006 perfect, thanks! Link to comment Share on other sites More sharing options...
jjj Posted June 24, 2006 Author Share Posted June 24, 2006 (edited) wait, one more question... how would I form the $s_prepare = ? I want to delete a row that has a unique number under the heading "oid". Would I do this: $s_prepare = "SELECT * from" & $sDbTable1 & "WHEERE oid=" & $oid & "';" EDIT: I just figured it out: $s_Prepare = " WHERE oid='"& $oid & "';" _SQL_DeleteRow($sDB, $sDBTable1,$s_Prepare,1) Thanks! Edited June 24, 2006 by jjj Link to comment Share on other sites More sharing options...
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