dim sql as string
sql = "select tablename.* from tablename limit 5"
' other things you'll need are defined elsewhere in your program
Now, you'll need to add the code that connects to mysql, then open the recordset and show the results to the user. There are About 2,070,000 results returned(0.12 seconds) for this question in Google.
You can also use 'rmdir' (rd) to delete a file or folder, and 'chdir' (cd) to change the current directory. Yes, these are DOS commands (dos is old! OMG!) but they are still supported in all versions of windows and Visual Basic. These same commands are built in to Linux and other operating systems and work very well.
windows explorer 'stalls' because of it's timeout duration. Windows Explorer is at the mercy of the devices it's trying to list. If any of those devices experience a delay in returning the information that Windows Explorer is asking for, you'll notice a delay.
Disconnecting network drives and perhaps unplugging other devices could at least give you a clue as to which device is contributing to the delay.
So .. no matter whos' File Manager is used, if it asks for information from a device that takes it's time answering (or doesn't answer at all) there will be a delay.
Another reason for a slow file manager might be that your PC has so much junk and spyware on it that explorer chokes. Do a cleanup.
Now, write a file manager with a timeout configuration value that's user adjustable.
