TSpeedButton.Down := False;
should do it - may depend on AllowAllUp.
- Original Message -
From: "Alistair George" <[EMAIL PROTECTED]>
To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
Sent: Saturday, November 09, 2002 3:58 PM
Subject: [DUG]: Button status
> Hello All,
> I wa
Title: Message
I have a TIBOQuery that uses
UNION.
The SQL runs fine in IB Console,
and in the TIBOQuery SQL Editor with hardcoded values. In the program the query
is the detail in a master/detail relationship.
When I run in a program it seems to
be OK if there are no rows returned in th
ot
happy
> in Delphi
>
> Check the order of opening tables open the lookup before the
> Source/Destination table
> If that doesn't work you could look at forcing a DataChange for the Combo.
>
> HTH
>
>
> Regards
> Paul McKenzie
> Analyst Programmer
> S
I have some code (D6) in which I'm trying to set some default values on
Append so the user only has to enter or change the not so usual stuff. I
store the entries from a previous append/post as properties on the form to
be the defaults for the next add.
I do an Append (to an IBOTable) and then th
> I was thought to select a language appropriate for the problem at hand and
> not to select one and stick to it just because "it's the language I've
> always used." After all, some problems are more easily solved in some
> languages and really complex in others. The way I see it is that .NET
make
It's something like memo1.lines.add(datetostr(Now) + ',' + timetostr(Now));
or memo1.lines.add(DateTimeToStr(Now));
Check the "date formatting routines" in the Help - there's a whole lot of
formats available.
>
> I am wanting to know how do i get the date time in a memo box
> ie
> memo1.lines.a
I have a DBISAM database and been running an Asta client/server solution
successfully.
Now running into issues with users behind firewalls and non-Windows
operating systems (yes there are some).
I've had a crack at using IntraWeb (ugly and expensive IMO) and EWF (pretty
but crashes regularly). T
Mark
Is the column position critical?
If the column you want to change is column 7 (char
4), would it be OK if it became the last column (char 5)?
If so, then SQL is possible - else others who know
how to talk to the BDE or who can do clever things with FieldDefs will need to
advise.
Mi
Mark
The following works in Database Desktop (v7.0) -
haven't verified how it goes in Delphi.
Table has Amount and ExpType (among other things)
in an Expenses table. The following SQL provides total expenses by type and as
percentage of total and has a grand total at the end.
select "
than manually!!
> > If its just a once off thing, try
using the datapump :)
Hadn't thought of that - I've tried
it - it's working for some tables and not for others. Can't see why some aren't
working - columns map corrrectly.
Any ideas?
> > Nic.> > -
I have two Interbase databases - same structure.
I want to append records from a table in one database into the other.
I write -
insert into mytable select * from :otherdb:mytable
but the SQL will not run as it doesn't seem to allow the alias definition
in the prefix.
I've tried batch moves
I have a text field that could have entries with more text than I can fit in
the column width I have available.
Is there a way of wrapping text in a DB Grid?
If not, can it be done in a String/Draw Grid?
Or perhaps there is a 3rd-party grid that can do this???
Or any other relevant suggestions
Check out http://da.teltecnz.co.nz/ - doesn't backup to tape - but can to
Zip Disk, CD, or remote drive (inter/intra net).
Set up the scheduler to run the backup at 3am daily - presumably users are
not online at that time!
- Original Message -
From: "James Sugrue" <[EMAIL PROTECTED]>
To:
a) How do I create an Excel compatible file from a
delimited text file ?
Use commas to delimit and save as a .csv file.
Excel will recognise this as a comma delimited file and open and format
correctly.
b) Should I be copying some sort of database file
instead ?
Don't know. Do you want to
Mark
Have you tried -
ParamByName('SaveDate').AsDate := CurrentDate;
as opposed to
ParamByName('SaveDate').AsString :=
DateToStr(CurrentDate);
What is your Short Date Format - dd/mm/yy or
mm/dd/yy?
DateToStr may not be giving you a valid date for
SQL
Why you would get "could not find ob
(Just to be provocative :) ) Is the door handle faulty if it's fitted to the
hinge side of the door?
Having said that, if Align is anything other than alBottom or alRight the
"drag/resize handle" (what is the technical term for it?) should disappear -
as it does if you drop it onto a panel and no
Thanks Ben - works like a treat.
- Original Message -
From: "Ben Taylor" <[EMAIL PROTECTED]>
To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
Sent: Tuesday, April 24, 2001 1:58 PM
Subject: [DUG]: Basic OO/Delphi Question
> > In, say, Project A I have a form FormA with a labe
> Try Screen.ActiveForm.
Bingo. Thanks.
>
> I put the following code into a form that can be created from many
different
> forms so that it shows up centered inside the
> form from which the create originated.
>
> procedure TfrmNotes.FormShow(Sender: TObject);
> var
> T,L,H,W : integer;
> be
I put the following code into a form that can be created from many different
forms so that it shows up centered inside the
form from which the create originated.
procedure TfrmNotes.FormShow(Sender: TObject);
var
T,L,H,W : integer;
begin
with do begin
T := Top;
L := L
Thanks but this is a level above what I'm looking for.
I'm trying to communicate between two forms in the same program but do it in
a generic way so that I can re-use one form in many
projects without having to use conditional directives to explicitly state
the name of the other forms.
Less theo
I have a form FormX that I want to use in a number of projects.
In, say, Project A I have a form FormA with a label and caption.
When a change is made to some list or variable on FormX I want to modify the
FormA.label.caption
I don't want to do this by writing FormA.label.caption := 'Foo'; in my
I can't speak for my peers, but personally I've adopted the iterative HATHA
methodology, more commonly known as "hack and then hack again". Depending on
the quality of "H" it can be RAD or it can be SAD.
More seriously, is anyone on this list using PSP (Personal Software
Process)?
Also, how man
Try the OnMouseMove event.
- Original Message -
From: "Chrissy R" <[EMAIL PROTECTED]>
To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
Sent: Sunday, February 18, 2001 6:43 PM
Subject: [DUG]: Mouse Position
> How do I get the position of the mouse in a control, a form say?
>
>
> Any ideas, alternatively, does anyone know any good little apps that I
could
> use instead... if building my own gets too tricky (or time consuming
:-))...
>
http://www.worldtimeserver.com/atomic-clock/atomic.exe
This should do it & it's free.
---
Thanks Aaron & Paul
I followed your code and it's working great.
Had a small hiccup on the way - was iterating through my query to build the
list and had all the code in the same loop. Basic effect was I'd added the
same object to all list items!! Separated the add as a procedure - all OK.
A wh
There was a thread on this a few weeks ago and I
thought I'd give it a try in my spare (?) time.
Defined
type
TFooObject = class(TObject)
id : integer;
desc :
string;
role :string;
end;
Then a procedure
var MyObj : TFooObject;
MyObj.id := idfromsomewhere;My
>Hi all
>
>With a TComboBox Style set at csDropDownList you can do:
>
> DocEntryDestCB.ItemIndex :=
DocEntryDestCB.Items.IndexOf(ImpDestCode);
>
>With the Style set at csDropDown, you can't.
Is this in:
* it doesn't compile
* it crashes
* it returns wrong result
I am interested as I
Try
http://www.antivirus.com/vinfo/virusencyclo/default5.asp?VName=VBS_STAGES.A
for the details. Most obvious damage - it deletes regedit.exe.
- Original Message -
From: "Joel van Velden" <[EMAIL PROTECTED]>
To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
Sent: Thursday, Ju
http://www.mail-archive.com/xxx@delphi.org.nz/
where xxx can be delphi, database or
offtopic
It would be handy to have link to these on the
www.delphi.org.nz website
(Mark??).
- Original Message -
From:
Willie
Juson
To: Multiple recipients of list delphi
Details at http://www.delphi.org.nz/
Bookmark this now!
- Original Message -
From:
richter
To: Multiple recipients of list delphi
Sent: Thursday, March 02, 2000 1:30
AM
Subject: [DUG]: HEL !
How do I UNSUBSCRIBE !!! ???
[EMAIL
I've got my CD and am following the procedure to
get my key from the Borland website but the registration process falls over each
time I try once I've submitted my details.
I'm using IE5, with cookies enabled.
I have completed all required fields
...
Afer the delay on submitting I get -
Alex
I had a crack at this one a couple of weeks ago without much success. The
ones that come with Delphi are mostly appalling and not been upgraded since
Delphi 1 - how about Corel/Borland supplying the ones it uses in the IDE for
Delphi 6 (??). Perhaps this is what Corel can bring to the table.
Use the Fields Editor and then pick up the OnGetText event for the
explicitly defined date field. Then format the input as you please and put
into Text.
So, it's not the Grid you are adding properties to but to the DB field. You
can also modify the column header for the date field.
- Origina
Mark
I have a report app that runs under Asta using Report Builder. The app
produces about 5 different reports from straight table print to complex
master/detail and a couple with complex calculations and graphics
generation. Tested it over the Net with the client in Europe on a 33k line,
from my
Here's another 2c worth.
Keep one copy of your (v. low cost) Paradox database at H/O.
Get an ADSL connection for H/O (or cable modem if in Wellington).
Use tzo and assign a domain name for H/O - yourcompany.tzo.com (resolves
dynamic IP addresses - don't ned permanent IP address ~$50/yr).
Buy 3 As
> Your welcome. Actually, I don't even use it for proping up my monitor
> anymore. I find that the 1998 Christchurch Yellow Pages is superior and
> also contains more usefull Delphi programming tips than my previous monitor
> prop.
>
> Author: Telecom Directories
> ISBN: ??
> Price: Free with
If you don't mind forking out $US50 for an OCX try http://www.globalmajic.com/x_knob.htm .
Seriously configurable.
Source and batteries most definitely not
included.
Let's continue this on the DB list - avoids the wrath of the ever-vigilant
list police.
---
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
Sorry about the bum Format advice - hope it didn't cost too much time.
Discovered that Short Date Formats without separators are allowed in Delphi,
Windows and Excel and create various problems.
Going from date to string is OK in all cases but back the other way is
another matter.
Delphi stops w
I take back that last suggestion - fast!!
datetostr will give '100999' but not go back the other way - a separator is
required
-Original Message-----
From: Mike Osborne <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Date: Friday, Septe
Define the Short Date Format without a separator.
ShortDateFormat := 'ddmmyy';
then proceed with StrtoDate() for your dates into database
then back to usual
ShortDateFormat := 'dd/mm/yy';
or, if you want to be Y2K compliant
ShortDateFormat := 'dd/mm/';
Regards,
Mike
-Original Messag
The links below have moved to:
Also an "Understanding the Paradox NET File" at
http://www.borland.com/devsupport/bde/ti/TI5B.html
BDE setup for Peer-To-Peer(Non-Dedicated) Networks
http://www.borland.com/devsupport/bde/ti/TI247B.html
(or at least look similar)
Regards,
Mike
-Original Messa
>I am having problems with queries again - (I need a decent book on SQL -
>any recommendations?).
Have a look at http://www.mkp.com/books_catalog/1-55860-453-7.asp
or
http://www.mkp.com/books_catalog/3239toc.htm
or
http://www.amazon.com/exec/obidos/ASIN/1874416508/qid=935091598/sr=1-1/002-5
0
Given you're in D1, sometimes the less elegant but brutally effective is the
way to go.
Broadly, how I would do it this is.
Query1
SELECT Teacher, Count(Students) As NoGirls, 0 As NoBoys
FROM MySchoolTable
WHERE MaleFemale = "Girl"
GROUP BY Teacher
Then Use BatchMove 'Copy' to a Destination Tab
I wrote in previous post::
>MyDate := EncodeDate(83,12,31); which would be 31 December 89 AD!?
Typo - should be: 31 December 83 AD
Regards,
Mike
---
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Alex wrote:
>Sorry for a confusion. Try that.
>ShortDateFormat := 'dd/mm/yy';
>StrToDate ('29/02/00');
>I just went futher in my testing and checked StrToDate ('29/02/2000')
>without setting proper ShortDateFormat := 'dd/mm/'. Sorry again. This
>works. The above one does not.
'29/02/00'
From the Delphi Year 2000 page (http://www.inprise.com/devsupport/y2000/delphi.html#notes3
) :
"To make your own Delphi applications handle two digit
years more reliably at the millennium, you should initialize the SysUtils global
variable TwoDigitYearCenturyWindow to a positive value in the
More paradox date stuff:
Regardless of Windows Short Date setting year as yy or if you enter the
date '1/1/45' into a grid you get
1/1/1945 but if you use an SQL INSERT of '1/1/45' you get 1/1/2045.
Similarly, a SELECT on '1/1/45' gets 1/1/2045.
FindKey([strtodate('1/1/45')]) will find 1/1/
The key driver seems to be the Windows setting for Short Date Format. Ensure
that is set to four-digit year.
That should resolve your issues - regardless of current date.
(At time of writing this setting gets lost on my PC at each re-boot and
reverts to yy - time to download the 95 patch and insta
More on this:
A similar function but
traversing a TOutline in one condition or doing a FindNearest in another is
terminating when 'C' is pressed but is fine with 'L'.
Is KeyDown an unreliable event in D1?
-Original Message-From:
Mike Osborne &
I suspect the following has either a very complex or very stupid
explanation.
Advice please.
In a D1 app I display a grid from a query sequenced by Description. When
the user presses a character key I position in the grid to the first entry with
that letter. The Datasource gets detached an
with 30+ Paradox tables and multi-users.
Mike Osborne
[EMAIL PROTECTED]
-Original Message-From: Grant Black
<[EMAIL PROTECTED]>To:
Multiple recipients of list delphi <[EMAIL PROTECTED]>Date:
Wednesday, 2 June 1999 17:55Subject: [DUG]: Paradox - Lock file too big
p
This message will occur when adding a column to
a table that already has a column of that name.
Do you have any SQL executing 'Alter table xxx add
duplicate_column_name ...' ?
Regards,
Mike Osborne
-Original
Message-From: Edwin Das <[EMAIL PROTECTED]>T
53 matches
Mail list logo