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 Rhinorhino 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: hbez
  • Order by date
  1. hbez

    ADDING LOOKUP PROGRAMMATICALLY

    Many thkx for the reply, however, I use qry1 to populate a dbgrid from table1, I then need an extra (lookup) field to qry1 that will get its data from Table2 and display it as a dropdown box in a cell of the dbgrid. Hope my explanation makes sense? Hannes
  2. hbez

    ADDING LOOKUP PROGRAMMATICALLY

    I have an ADOQuery qry1 which gets its ConnectionString programmatically. I need to add a Lookup field but, when I double-click the query, Delphi (7) complains there is no ConnectionString. So I need to code in the new field. I get as far as - I hope that's correct - <code>...
  3. hbez

    REGISTRY KEYS

    Tried EraseValue, same problem. This is on Win7 64bit. Will check it out on XP today. Hannes
  4. hbez

    UNTYPED (.exe) FILE

    Thank you all, I'm not going to redesign the wheel. Will look out for an affordable commercial solution. Hannes
  5. hbez

    REGISTRY KEYS

    I successfully create a new key and write a value to it. I cannot get to delete the values or the key itself. My code is <code> with TRegistry.Create do try Val := TStringList.Create; RootKey := HKEY_LOCAL_MACHINE; if OpenKey('SOFTWARE\VotAfr\', True) then begin...
  6. hbez

    UNTYPED (.exe) FILE

    Many thanks for the replies. Steve, that's exactly what I'm playing with, something I did once way back with QuickBasic (so how old am I) where it was easy as pie, not that I'm capable of baking one. Haven't thought of cracking it by using compare, tho I suppose one could involve the registry or...
  7. hbez

    UNTYPED (.exe) FILE

    I'm playing around with copy-protection and want to try the following: Assuming I have an application MyApp.exe with a variable assigned the value of "ABCDE' somewhere inside the executable. How can I locate where this value is written in the file? Then, how can I write a new (same size) value...
  8. hbez

    REFRESHING A DBGRID

    Back onto my favourite nemesis -- displaying updated data in a DBGrid immediately after inserting data into an Access DB from an Edit box or other non-db aware object. I have an Access db with one table (City) andone text field (City). The form has a DBGrid, one Edit box, ADOCommand, ADOTable...
  9. hbez

    ADOQUERY HEADACHES

    I have in fact tried two different ADOConnections as well as two different ADOQuerys. Eventually I left the connection to the 'remote' (different directory, it may be on a server) db as is and moved the 'local' db to the folder where the executable resides. Using ExtractFilePath(Application.exe)...
  10. hbez

    strtoint problem

    Dunno if its of any help but, what I do if I have a problem seeing a variable value, I display the value in a temporary label or edt box on the form. Hannes
  11. hbez

    ADOQUERY HEADACHES

    ...'Data Source=OtherFolder\db1.mdb;' + 'Persist Security Info=False'; qryDB1.SQL.Text := 'SELECT * FROM City'; qryDB1.Active := True; end; procedure TForm1.btnDB2Click(Sender: TObject); begin qryDB1.Active := False; //DB2 is in the root or could be in...
  12. hbez

    ADOQUERY HEADACHES

    I am experiencing two frustrating problems with an ADOQuery: 1) QRY1 uses a ConnectionString to Access db1. QRY2 must use a ConnectionString to another Access db2 in a different folder. However, QRY2 keeps telling me it cannot find db2 in the folder where db1 is located. To at least make the...
  13. hbez

    ADOQUERY HEADACHES

    I am experiencing two frustrating problems with an ADOQuery: 1) QRY1 uses a ConnectionString to Access db1. QRY2 must use a ConnectionString to another Access db2 in a different folder. However, QRY2 keeps telling me it cannot find db2 in the folder where db1 is located. To at least make the...
  14. hbez

    DETECT INACTIVITY

    Thank you Steve, why does one always want to choose the complicated way of doing things! :)
  15. hbez

    DETECT INACTIVITY

    Could someone please show me how to close my application if there has been no user input for a specified period of time? I want my program to terminate if the user did not click a key for say 10 minutes. I'm guessing I will need to use a TTimer so I can specify the time, together with...
  16. hbez

    SORTING A DBGRID

    I'm using ehlib which has served me well over the past. It seems it must be populated from a query to enable sorting by clicking on a column heading. I'll hav a look at the grid from devexpress.
  17. hbez

    SORTING A DBGRID

    I populate a DBGrid using a ClientDataSet, Provider and DataSource. I cant seem to get the DBGrid to sort when I click on a heading. Must I use an ADOQuery to do this? Hannes
  18. hbez

    DISCONNECTING ACCESS DB

    Thanks for that, in truth, I never set the KeepConnection to False. Matter of fact, I completely missed that property! Tried it and it also works fine. :) I use Delphi 7 Enterprise. Hannes
  19. hbez

    DISCONNECTING ACCESS DB

    Just to wrap this one up: After reading the database, I did such things as qryData.Active := False, closed datasets, etc, all to no avail. What did work was to make the ConnectionString := ''; as well. This closed the .ldb file. Hannes
  20. hbez

    Win 64 processing

    I have been using Delphi7 in Vista 64-bit and now in Windows7 64-bit. I did find that I needed to set Security in the Borland/Delphi7 folder in the Program Files(x68) folder by giving Full Control to specified Users. I did this to the entire folder and sub-folders. I suspect your usrs will need...

Part and Inventory Search

Back
Top