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

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

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