Search results for query: *

By sheer chance you're generating the virus signature in your DLL when you have the uses clause in that order. It's nothing to worry about, and since you have found a trivial way to avoid it, I suggest doing thta and moving along. Count it as a very cool anecdote.

In later Delphi versions there are in-memory datasets to avoid this problem (TClientDataSet etc). See one article on how to do this: http://www.thedelphimagazine.com/samples/1540/1540.htm In older versions turn CachedUpdates on and test your database design (try to limit the number of linked...

Or dump the data to text and import it, assuming the DTP fails or looks too hard. But if you have to write the program (for school or something), it's not too hard. Put two TDatabase components on a form, link each to a TQuery, and go from there. You can speed things up by using direct data...

It depends very much on the volume of data. If it's only a few MB, it'll be quicker to write the simple Delphi code GeppoDarkson describes (total time taken will be lower). If it's several GB, one of the dump methods will probably be faster. If you can use VintageWine's solution that would be...

Start the helper app only when you need it, all it does is wait for the main prog to terminate, update the file and (re)start it, then exit. Mildly ugly, but quite robust.

OnSetEditText is one event you could use: procedure TForm1.StringGrid1SetEditText(Sender: TObject; ACol, ARow: Integer; const Value: String); var i : integer; Sum:single; begin Sum:=0; for i := 1 to StringGrid1.RowCount do try if StringGrid1.Cells[ACol,i] <> '' then Sum:= Sum...

Does the program have to work with both, or are you converting it? If it's a one-time conversion you could do a global replace on the field definition in the dfm files. Otherwise you'll need to iterate the components on the datamodule(s) and force the change at runtime. I'd do that in a pair of...

Simon, that just tells you what the min/max values used are, not the constraints. The SQL spec offers a set of system views that give you this stuff, and it should also be in the docs for your database (which are free, unlike the SQL spec). But I don't recall what they are, you'd need to look...

RTFM - specifically, that's available in every database but I'm not certain that its standard SQL - I'm using MySQL right now, and the query is &quot;show tables&quot;, or you can grab data direct from the internal DB tables but they're very brand-spcific. So get your big book of Oracle...

Check out the ApplyUpdates method on TQuery because you might not be saving your changes back to the dataset, and if you want editing everything from your TTable or TQuery on through has to have readonly set false. With D7 it helps to know if you're using traditional DB access or DBExpress, as...

At a guess, two choices will work: use TQuery.Locate to get dsDepartment pointing to the correct record, or (guessing) set the TCombo.ItemIndex directly.