Search results for query: *

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!

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

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

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

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

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

Hi, I have an existing GUI application and I want to be able to build existing code as a command line application using compiler directives. I think I know (untested) how to segregate main code as show below from a previous post on this list. However what code do I need to enter in the...

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

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

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

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

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

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

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

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

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

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

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

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 ;)

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