Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: MozNZ
  • Order by date
  1. MozNZ

    Uses order generates a virus in Delphi 5

    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.
  2. MozNZ

    Bound Controls and Calculations

    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...
  3. MozNZ

    do9wnload/upload using delphi

    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...
  4. MozNZ

    best way to fill 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...
  5. MozNZ

    Auto-Update my Program

    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.
  6. MozNZ

    linking with sum

    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...
  7. MozNZ

    Date fields incompatible on Paradox and Sql server

    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...
  8. MozNZ

    Getting the min and max value of a db field

    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...
  9. MozNZ

    Database table text

    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...
  10. MozNZ

    DBLookupComboBox Default &amp; blank values

    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...
  11. MozNZ

    DBLookupComboBox and prechosen values?

    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.

Part and Inventory Search

Back
Top