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: *

  1. topcat01

    Inserting multiple records into sqlite and ignore duplicates

    Thanks for the reply, I need to look at the autonumbering and see how that can help or look at another way completely. Thanks very much for the suggestions!
  2. topcat01

    Inserting multiple records into sqlite and ignore duplicates

    Thanks that seems like common sense! I have revised the code as follows: CREATE TABLE email ( hashid INTEGER PRIMARY KEY, emailaddresshash TEXT NOT NULL UNIQUE, hash_date_added DATETIME NOT NULL DEFAULT (DATETIME('NOW')) ); CREATE TABLE emailprops ( propsid INTEGER...
  3. topcat01

    Inserting multiple records into sqlite and ignore duplicates

    Hi, I wrote the following code to create two tables, add a couple of triggers, the problem I am having is with the add_props_date trigger... when an existing record is already present in the table email i still want a record creating in the email props table, which works however the compid...
  4. topcat01

    NetworkX Graph from CSV

    I have two working scripts, but neither of them as I would like. The sample data file I have is in a file called 'file2.txt' Email,IP,weight,att1 jim.bob@junk.com,192.168.0.1,2,4 steve.bob@mc.com,192.168.0.1,3,4 mary.bob@video.com,192.168.0.25,4,4 The first script I have works and produces...
  5. topcat01

    Using If Statement to check field before database update

    Thank you George, I will give your suggestion a try!
  6. topcat01

    Using If Statement to check field before database update

    Hi, I have a SQL script for MS SQLServer that creates a series of tables, one table is named 'META' and contains the field 'dbver' (database version). I would like to update my script so that updates to the database can be applied by checking the database version and would like to know if this...
  7. topcat01

    Build Project as GUI or Console

    ...it is the code which determines the type of program if that makes sense, depending on the build will determine if to create a GUI or console exe. * taken from procedure TQbExport2MySqlForm.UpdateStatus(Pan: integer; s: string); begin {$IfDef CONSOLE} if pan = 0 then write(s + #32) else...
  8. topcat01

    Multiple DBLookupComboBox tied to the same ListSource in XE4

    Thanks for the suggestion, I traced the problem, the dropdown was using an incorrect datasource during runtime (using different conditional during compile) Thanks
  9. topcat01

    Multiple DBLookupComboBox tied to the same ListSource in XE4

    Hi List, I have a single form with several DBLookupComboBox components tied to the same dataset same ListSource/ListField/KeyField. When I select a different value from any of the lists, all lists clear! In Delphi 7, it was possible to select a different record of the dataset in each...
  10. topcat01

    Inifile ReadString in XE4

    Just to add when I do showmessage the dialog box in Win7 shows for example: c:\projects\software example logo code\logo.jpg When run in Vista I get: c:\projects\software example logo code\logo.jpg It looks like a line break appears from nowhere, I checked the ini file and no line breaks...
  11. topcat01

    Inifile ReadString in XE4

    Hi, I am moving a project from Delphi 7 to XE4 and compilation appeared fine. I have XE4 installed on Windows 7 and building as a Win32 application, the program appears to work fine on that machine and no issues (I have Delphi 7 on a Vista machine.) When I copy the program to Vista I get...
  12. topcat01

    I have all Delphi versions, which should I use?

    In the end I bought XE4, so far I like it and no major problems (yet) installing 3 party components!
  13. topcat01

    I have all Delphi versions, which should I use?

    I am working with D6 Pro and D7 at the moment but have renewed my maintenance for the second time and finally going to download the software I paid for. What is everyone else using, XE2? Any pros/cons or are you staying with D6/7? Thanks
  14. topcat01

    How to display AsString to Unicode instead of question ????? marks

    I'm not sure AsWideString is in D7, I have a lot of work ahead of me! Thanks for replying
  15. topcat01

    How to display AsString to Unicode instead of question ????? marks

    Hi, I am using Delphi 7 with TNT labels accessing a SQLite database via TClientDataSet, the sqlite database contains Arabic and I need to display a field 'mylabel' on to a TNT Label. I used FieldAsString('mylabel').AsString which displays the text on the label as ?????? when it is Arabic...
  16. topcat01

    How do I format Display Text in a DBGrid (using multiple formats)?

    Hi imex, That makes perfect sense, thank you for the quick reply.
  17. topcat01

    How do I format Display Text in a DBGrid (using multiple formats)?

    I have a DBGrid which displays the following example columns: Assignment,Department,Teacher Which displays in the grid for example: 1,Science,J Jones 2,Science,A Bones 3,Technology,N Harvey However I want it to display in the DBGrid as depending on the Department in use as...
  18. topcat01

    Advice needed: program to add comments on top of picture

    Hi I am looking for suggestions for a program that I need to write.... I have to write a program to load a map of a local neighbourhood (jpg picture). A user can then right click anywhere on the picture and add a comment (which appears as a label). The comment and comment position of the user...
  19. topcat01

    Advice Needed: 32 bit exe and dll on a 64 bit operating system

    You were correct, inno setup sends the 32bit dll to C:\windows\SysWOW64 I had to add some additional code to the inno setup script to install some microsoft dll files from a .msi during installation, everything runs as normal now. ...until the next Window release ;)
  20. topcat01

    Advice Needed: 32 bit exe and dll on a 64 bit operating system

    Hi, Thanks for the suggestion, I will try and let you know. Thanks

Part and Inventory Search

Back
Top