Source language: Translate to:

dbpDeleteAll

Questions about our Advanced Database plug-in

Moderator: Neosoft Support

dbpDeleteAll

Postby smartmedia » Sat Sep 29, 2007 1:12 pm

Hi...

I notice that when i use dbpDeleteAll with query, after, all the other records are show up in the grid... This is a bug...??? If not, how i will delete all records with query without to show anything on grid...???

Thanks
User avatar
smartmedia
 
Posts: 889
Joined: Fri Apr 01, 2005 6:50 am
Location: Hellas

Postby Neosoft Support » Mon Oct 01, 2007 10:55 am

No it's not a bug. When you delete all visible records, the query becomes invalid and DBPro shows all remaining records by design. If you want the table to appear empty, simply reissue the query after performing the deletion.

Alternatively, you can use SQL to do something similar and faster than the dbpDeleteAll action. For example:

dbpExecSQL "database" "DELETE * FROM Table WHERE <your query>"
dbpExecSQL "database" "SELECT * FROM table WHERE <your query>"
NeoSoft Support
Neosoft Support
NeoSoft Team
 
Posts: 5603
Joined: Thu Mar 31, 2005 10:48 pm
Location: Oregon, USA


Return to NeoBookDBPro

Who is online

Users browsing this forum: No registered users and 2 guests

cron