Delphi Pages Forums  

Go Back   Delphi Pages Forums > Search Forums

Lost Password?

Showing results 1 to 50 of 319
Search took 0.05 seconds.
Search: Posts Made By: David B
Forum: General 07-09-2011, 09:14 AM
Replies: 2
Views: 2,781
Posted By David B
Thanks very much for your help but this is what I...

Thanks very much for your help but this is what I needed.

procedure TForm1.DBGrid1DrawColumnCell(Sender: TObject; const Rect: TRect;
DataCol: Integer; Column: TColumn; State: TGridDrawState);...
Forum: General 07-08-2011, 01:22 PM
Replies: 2
Views: 2,781
Posted By David B
ADOQuery SQL - Add row number column in SQL?

Hi

I am using ADOQuery, connected to MDB

I want to show a row number column using SQL

eg: SELECT rownumber AS row, * from mytable

Is there a way of doing this in SQL using ADOQuery...
Forum: General 06-22-2011, 05:55 AM
Replies: 2
Views: 10,062
Posted By David B
I so far have 2 methods which are great ...

I so far have 2 methods which are great

procedure GetTableNames(List: TStrings; SystemTables: Boolean = False);
procedure GetFieldNames(const TableName: string; List: TStrings);
What I need to...
Forum: General 06-22-2011, 01:32 AM
Replies: 2
Views: 10,062
Posted By David B
ADO - Get list of field name types, size etc?

Hi,

Using Delphi 7, standard ADO components.

I open an access database.

I need to get a list of all the fields in the table

Also get their field type (eg: integer, memo, string[60])
Forum: General 06-10-2011, 07:05 AM
Replies: 3
Views: 2,745
Posted By David B
Hi Glenn That is a great help, thank you...

Hi Glenn

That is a great help, thank you very much

Dave
Forum: General 06-10-2011, 04:26 AM
Replies: 3
Views: 2,745
Posted By David B
Any ideas? Thanks again

Any ideas? Thanks again
Forum: General 06-08-2011, 11:47 PM
Replies: 3
Views: 2,745
Posted By David B
Drag and Drop Multiple items from DBGrid to StringGrid?

Hi,

I am wanting to select multiple items in a DBGrid then Drag and Drop them
into a StringGrid (with the same columns)

I have seen examples on a single selection but am uncertain on selecting...
Forum: General 01-26-2011, 08:29 AM
Replies: 7
Views: 7,831
Posted By David B
While windows explorer recognises the truncated...

While windows explorer recognises the truncated path it does not work in my database DBISAM, I need to grab the temp path on the fly.

I am trying to grab the paths through code so as to automate...
Forum: General 01-25-2011, 10:53 PM
Replies: 7
Views: 7,831
Posted By David B
Hi Nester, No didnt work, even using that...

Hi Nester,

No didnt work, even using that function Windows 7 is changing the
path to

c:\Users\DAVID~1\AppData\Local\Temp

I need to return the complete path without the ~

Any other ideas?
Forum: General 01-25-2011, 09:34 PM
Replies: 7
Views: 7,831
Posted By David B
Thanks very much, will give it a try.

Thanks very much, will give it a try.
Forum: General 01-25-2011, 12:42 AM
Replies: 7
Views: 7,831
Posted By David B
Windows Temp Folder

Hi All,

I am using this code to get the temp folder

function TForm1.TempFolder: String;
var
bufFolder: array [0..MAX_PATH] of Char;
begin
GetTempPath(SizeOf(bufFolder), bufFolder);
...
Forum: General 12-09-2010, 05:41 AM
Replies: 4
Views: 1,560
Posted By David B
Wouldnt that be as simple as the following? ...

Wouldnt that be as simple as the following?

procedure myFunction (myString : string);
var
myFile : TextFile;

begin
AssignFile(myFile, 'C:\myDirectory\' + mystring+'.txt');
...
Forum: General 12-07-2010, 03:14 AM
Replies: 5
Views: 2,160
Posted By David B
Yeah I was aware of the bad design for that but I...

Yeah I was aware of the bad design for that but I have have to
plug this SQL into an already established table done by a third party.

I am thinking of using a temp memory table to build the...
Forum: General 12-06-2010, 09:29 PM
Replies: 5
Views: 2,160
Posted By David B
And it also does not show me the item names. ...

And it also does not show me the item names.

Thanks for your help, but any other suggestions would be greatly appreciated.

Cheers
Forum: General 12-06-2010, 09:11 PM
Replies: 5
Views: 2,160
Posted By David B
Hi Jasser, I tried this but it is not grouping...

Hi Jasser, I tried this but it is not grouping the items.

They appear more than once.
Forum: General 12-06-2010, 02:29 AM
Replies: 5
Views: 2,160
Posted By David B
SQL SUM Question?

Hi All, I have a table like this

Item1, Quantity1, Item 2, Quantity2, Item3, Quantity3

so records say

2,4,2,3,1,3
1,2,2,5,1,1

I need to group all the items and sum the quantities
Forum: General 09-18-2010, 12:02 PM
Replies: 3
Views: 18,173
Posted By David B
If anyone is interested I found a solution to...

If anyone is interested I found a solution to this that seems to work
for me.

The problem is in Windows 7, even though the regional settings are set
to dd/mm/yyyy it still displays in my program...
Forum: DB-Aware 08-17-2010, 02:03 AM
Replies: 7
Views: 3,039
Posted By David B
Hi, sorry I do not have time to read your whole...

Hi, sorry I do not have time to read your whole post as I have to go out.
But I think what you are looking for is the SQL GROUP BY clause

That should get rid of your duplicates.

Will try and...
Forum: General 08-16-2010, 10:28 PM
Replies: 3
Views: 1,289
Posted By David B
function GetTempDirectory: String; var ...

function GetTempDirectory: String;
var
tempFolder: array[0..MAX_PATH] of Char;
begin
GetTempPath(MAX_PATH, @tempFolder);
result := StrPas(tempFolder);
end;
Forum: VCL 07-13-2010, 03:26 AM
Replies: 12
Views: 12,630
Posted By David B
You are also trying to write to your programs...

You are also trying to write to your programs directory which
will not work with Vista and Windows 7 unless you are using
"run as administrator"
Forum: General 06-24-2010, 03:46 AM
Replies: 1
Views: 1,195
Posted By David B
Question Formating for accurate currency?

Hi All,

I need a small function to get an accurate rounding.
There are many extracts on Google but they do not seem to work the way I need.

say I have a figure of type double: 1.3533678
...
Forum: General 06-24-2010, 01:42 AM
Replies: 3
Views: 2,370
Posted By David B
Usually things that work don't just stop. I...

Usually things that work don't just stop.

I would be asking what have you changed?
Forum: General 06-21-2010, 11:12 PM
Replies: 5
Views: 1,443
Posted By David B
Have you checked your Firewall is not blocking it?

Have you checked your Firewall is not blocking it?
Forum: General 06-21-2010, 10:27 PM
Replies: 2
Views: 1,419
Posted By David B
http://delphi.about.com/cs/adptips2003/a/bltip0903...

http://delphi.about.com/cs/adptips2003/a/bltip0903_2.htm
Forum: General 06-17-2010, 03:41 AM
Replies: 8
Views: 1,794
Posted By David B
Sorry, I don't understand what you are trying to...

Sorry, I don't understand what you are trying to do?

ComboBox(I);

What are you trying to do here, as this is not a valid command?
Forum: General 06-17-2010, 01:12 AM
Replies: 8
Views: 1,794
Posted By David B
Write a common procedure procedure...

Write a common procedure

procedure TForm1.ChangeCombo(YourCombo: TComboBox);
begin
with YourCombo do
begin
// do something
end;
end;
Forum: General 06-10-2010, 04:56 AM
Replies: 1
Views: 2,339
Posted By David B
Thumbs up Worked it out.

If anyone is interested there in the region properties there is a property called Anchor. Inside there you can set the Verticle Anchor to Stretch.
Forum: General 06-10-2010, 04:20 AM
Replies: 1
Views: 2,339
Posted By David B
Question Rave Reports - Region: Databand (Can you make it auto expand) ?

Hi All,

Using Rave reports with a Region: Databand.

Inside is a memo which gets its data from a database connection.

I need the Region band to automatically expand. I cant find a setting to...
Forum: General 06-09-2010, 10:41 PM
Replies: 21
Views: 7,012
Posted By David B
Maybe loop through each line of the memo ...

Maybe loop through each line of the memo

Count how many times that text occurs

function CountPos(const subtext: string; Text: string): Integer;
begin
if (Length(subtext) = 0) or...
Forum: General 06-07-2010, 03:02 AM
Replies: 21
Views: 7,012
Posted By David B
Before I go and dust off my crystal ball from the...

Before I go and dust off my crystal ball from the cupboard would
you please share with us the error you are getting?
Forum: General 05-27-2010, 09:20 AM
Replies: 8
Views: 1,502
Posted By David B
Well only he knows. Any solution would probably...

Well only he knows. Any solution would probably suffer firewall issues anyway
Forum: General 05-27-2010, 08:20 AM
Replies: 8
Views: 1,502
Posted By David B
Depends on how he intends to use it. Maybe he...

Depends on how he intends to use it. Maybe he only has it installed on one computer and is simply trying to locate it.
Forum: General 05-27-2010, 04:04 AM
Replies: 8
Views: 1,502
Posted By David B
Heres an idea :) Firstly get a list of all...

Heres an idea :)

Firstly get a list of all the computers on a network

http://www.swissdelphicenter.ch/torry/showcode.php?id=2177

Then

Loop through them to get the list of services running
Forum: General 05-26-2010, 11:19 PM
Replies: 8
Views: 1,502
Posted By David B
How to start stop a service - including computer...

How to start stop a service - including computer name

http://www.chami.com/tips/delphi/031598D.html

I am interested as well in how to find the computer name that a service
is running on. eg:...
Forum: General 05-26-2010, 06:04 AM
Replies: 4
Views: 1,526
Posted By David B
Quick Report Custom Preview (from the qusoft web...

Quick Report Custom Preview (from the qusoft web site)

http://www.qusoft.com/CustomPreview.zip
Forum: General 05-20-2010, 06:30 AM
Replies: 2
[SOLVED] SQL Question?
Views: 1,120
Posted By David B
UNION worked well. All is good - consider solved...

UNION worked well. All is good - consider solved :)
Forum: General 05-20-2010, 01:07 AM
Replies: 2
[SOLVED] SQL Question?
Views: 1,120
Posted By David B
I have an idea which I am going to try Will...

I have an idea which I am going to try

Will use a UNION sql and do 3 individual SQL statements joined by UNIONs

This means it will only filter out matches.

If you have a better way please...
Forum: General 05-20-2010, 12:51 AM
Replies: 2
[SOLVED] SQL Question?
Views: 1,120
Posted By David B
SQL Question?

I have a database including these fields (in the same table)

Date1, Note1
Date2, Note2
Date3, Note3

The user puts in a date range to search

I need to show all records where the date is in...
Forum: General 05-18-2010, 11:10 PM
Replies: 8
Views: 2,859
Posted By David B
I understand yours is clean. But you are...

I understand yours is clean.

But you are saying his is also clean - thats my question?

If your run even a blank form compiled in Delphi and run it through
virus total - which scans with many...
Forum: General 05-18-2010, 10:19 PM
Replies: 8
Views: 2,859
Posted By David B
To say that this is definately not a virus is a...

To say that this is definately not a virus is a very very dangerous statement.

Are you 100% positive?

I mean you are probably right, but do you know what he has downloaded.
Do you know what he...
Forum: General 05-17-2010, 11:28 PM
Replies: 8
Views: 2,859
Posted By David B
Maybe try uploading it to...

Maybe try uploading it to http://www.virustotal.com/

Probably a false positive as you said but doesnt hurt to check.

This program will scan with numerous detectors and will give you a better...
Forum: General 05-13-2010, 12:27 PM
Replies: 2
Views: 1,318
Posted By David B
q.Close; q.SQL.Add('select * from [sheet1$]...

q.Close;
q.SQL.Add('select * from [sheet1$] where id='+id+'');
q.Open;

is id a integer?

if so

q.Close;
q.SQL.Add('select * from [sheet1$] where id='+inttostr(id));
Forum: General 05-13-2010, 06:07 AM
Replies: 1
Views: 1,169
Posted By David B
Hey Tim, I think you may have asked this question...

Hey Tim, I think you may have asked this question before and the following link was given http://cc.embarcadero.com/Item.aspx?id=22620

Did that not help?
Forum: General 05-10-2010, 05:38 AM
Replies: 1
Views: 1,500
Posted By David B
Question Using MSWord automation to check grammar of memo text?

Hi all,

I would like to use MSWord automation to check the grammar of the
text contained in a memo box.

Has anyone played with this before and have any ideas?

Thanks
Forum: General 05-06-2010, 11:47 AM
Replies: 8
Views: 1,921
Posted By David B
No problem :)

No problem :)
Forum: General 05-06-2010, 11:24 AM
Replies: 8
Views: 1,921
Posted By David B
What is plement.pas? The code never...

What is plement.pas?

The code never references this file.

Check all your uses clauses and see if it references plement.pas'

As it is not part of this code

Maybe you added a third party...
Forum: General 05-06-2010, 10:13 AM
Replies: 8
Views: 1,921
Posted By David B
I think what you are looking for is an array...

I think what you are looking for is an array search

see http://www.swissdelphicenter.ch/torry/showcode.php?id=1916
Forum: VCL 05-06-2010, 12:22 AM
Replies: 2
Views: 3,807
Posted By David B
Select * from Mytable Order By Status, Title

Select * from Mytable Order By Status, Title
Forum: General 05-05-2010, 10:58 PM
Replies: 10
Views: 4,023
Posted By David B
I suppose it depends on what your program does. ...

I suppose it depends on what your program does.

With Vista and Windows 7 the main things I have learnt is to
use HKEY_CURRENT_USER instead of HKEY_LOCAL_MACHINE

Store your Data or files that...
Forum: VCL 05-04-2010, 12:17 AM
Replies: 4
Views: 1,876
Posted By David B
Opps forgot about LIKE :) What database...

Opps forgot about LIKE :)

What database engine are you using?
Showing results 1 to 50 of 319

 
Forum Jump

All times are GMT. The time now is 02:12 PM.


Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2019, vBulletin Solutions, Inc.