Search results for query: *

Try using a varchar type instead of a char(6), this may be good for your DB as well. You have to keep in mind that the types have to match between paramater and DB. Also, the char type is exactly size 6, any string that is less, it pads the char parameter with "white space", any thing more, it...

Glad I can help...

No problem, I will include a small example of what I am talking about. I did not use sql parameters assuming you may be getting the data from text boxes or some control. You can always adapt but this should give the idea. Also, I made a couple of assumptions about the DB you may be using...

Hello all, I am trying to figure out a simple way to retrieve data from a .DBF (FoxPro) file and it's matching .CDX file. I need to bind the returned data to a DataGrid so that a user can update the data and the files accordingly. i have tried a couiple of things: 1. An RDO.ResultSet was used...

One quick idea is to use a second dataset and search for the selected vehicle in the DB. Obviously if the dataset returns a row, you found it and the vehicle is already reserved... I hope this quickie answer helps.