Search results for query: *

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

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

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

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

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

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

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

Hi List, I have Delphi 6 & 7 Pro and have developed software which is of course 32-bit. Some of the exe files I developed use MS dll files which I have included as part of my installation (i'm guessing the dll are 32 bit also but have not checked), during the installation these dll files are...

Hi Group, I am using D7 and connecting to a SQL DB via ADO, one of the fields I am dealing with is stored as VARBYTES, it shows in the DBgrid as '(VARBYTES)' - I have tried to display this as a string using Tfields.gettext but I do not know enough about this data type and there isn't anything...

I have looked in the list archives and searched the internet for a solution and keep coming to this code: DataSet.Recordset.Properties['Update Criteria'].Value := AdCriteriaKey; When I enter the code I get 'AdCriteriaKey' as unidentified... How can this be called sucessfully in D7? Thanks.

Evening, I am working with D7 with SQL Server 2005, a form with DBNavigator and some DBEdit boxes. I would like one of the DBedit boxes to display the new reference number when the insert button is pressed on the dbnavigator (increments after each new record 000124, 000125 and so on). I have...

Hi, I am in need of some additional DB aware components, for example calendar, lookup editbox and dbgrid with advanced features... Does anybody have any recommendations for example an all in one package or bundle which includes all of the above? (and more if possible) I'm running on D6 and...

Hi, I have searched the forum but cannot find an answer. I have D7, D6pro and SQL Server 2005. What method would you recommend overall for database connection & access? I have done db software dev many years ago and remembered spending a great deal of time learning the methods not to use...

Hi, I would like to know if it is possible to access a SQL CE database via delphi, i suspect it is but have struggled to find a solution. I have delphi versions D6 Pro and D7. I did find one example but was unable to identify how to use the units 'ADODB_TLB' and 'ssce35_tlb' - I think I need...

Hi, Does anybody know if it is possible to disable the Windows Desktop Search service programmatically using Delphi? This is a service on a Vista machine. If fact is it possible to disable any service? Thanks

Hi there, I have the following String 'E082DAC410CAC601' that I want to store in a FILETIME variable. I'm using D6, is there a function available to convert this value? (Reading straight from a binary file isn't a problem but I'm missing something trying to convert from the string.)

Hi, I have searched the forum and google and wondered if anyone can answer the following: This is my code for reading a pchar null terminated string from a file which seems to work ok, in this example I know the string is 16 bytes long. var CurrentFile : TFilestream; MyName ...