RE: [DUG]: Offtopic - been there, done that

2002-12-05 Thread Jeremy Coulter
I use Paypal myself. They dotn charge a %, I think is like $2 or $3 US
from memory, AND you can get your $$ put into your NZ bank account ! I
love it !
No cheque to have to put in the bank and wait another 6 weeks to get it
cleared.

Jeremy

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On
Behalf Of Stefan Mueller
Sent: Thursday, 5 December 2002 19:01
To: Multiple recipients of list delphi
Subject: Re: [DUG]: Offtopic - been there, done that


Get your own webserver and publish it on tucows ;-)! Go to
www.findmyhosting.com and fire of a search - plenty of choice of
webhosting for under a 1$ per month! If you have multiple files to
publish than it's probably anyway better to to it that way!

For selling online i use http://www.swreg.org - they charge 1$ + 4%
which is a fantastic good low price.  The even have a tool to create
your own webpages to take over the payment process, so your users don't
have to leave your website!

Cheers,
Stefan




- Original Message -
From: Alistair George [EMAIL PROTECTED]
To: Multiple recipients of list delphi [EMAIL PROTECTED]
Sent: Thursday, December 05, 2002 5:59 PM
Subject: [DUG]: Offtopic - been there, done that


 Hello All,
 Software is ready for release on internet now. Freeware and Shareware.

 My
old
 favourite CNET I was putting the software to and they wait till the 
 last
page to
 tell you you have to pay them to provide their service! Rather 
 upsetting
in that
 if they were honest it would have been at the start.

 Anyway, would any of you kind folks let me know sites that you 
 recommend
for
 distributors so I can upload my software to them.

 Please reply direct to bigal at xtra dot co dot nz.
 Thanks vm,
 Al+

 --
 
-
 New Zealand Delphi Users group - Delphi List -
[EMAIL PROTECTED]
   Website: http://www.delphi.org.nz
 To UnSub, send email to: [EMAIL PROTECTED]
 with body of unsubscribe delphi
 Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/




---
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
  Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED] 
with body of unsubscribe delphi
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/

---
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
  Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED] 
with body of unsubscribe delphi
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/



[DUG]:changing compile conditions at runtime...

2002-12-05 Thread Chris Veale
Hi

I want to implement something like a passcode that when entered allows the
user to do something different than a user without that passcode.  I have
all the functionality already in the code with compile conditions but from
all the help Ive looked through, I cant change this on the fly - it takes a
full recompile.

Is there any way of allowing this change at runtime using compile conditions
or am I going to have to rebuild the functionality with if statements?

Cheers

Chris

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.426 / Virus Database: 239 - Release Date: 2/12/02




__
The contents of this e-mail are privileged and/or confidential to the
named recipient and are not to be used by any other person and/or
organisation. If you have received this e-mail in error, please notify 
the sender and delete all material pertaining to this e-mail.
__
---
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
  Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED] 
with body of unsubscribe delphi
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/



RE: [DUG]:changing compile conditions at runtime...

2002-12-05 Thread Conor Boyd
Hi Chris,

My initial thought is that this is something that needs embedded into the
functionality of your program rather than a compile time issue.  Security is
really something that should be addressed as a constituent part of your
design from the start...

However, one relatively quick workaround if you don't want to revisit your
design would be to do the following:

Compile the two versions of your application (with the different compile
conditions) into 2 separate executables.  These executables should not run
unless a particular 'code' (known only to you as a developer) is passed as a
command line parameter.

Create a 'launcher' executable, which is responsible for asking the user for
the passcode.  Your launcher should use this passcode to determine the
correct code to pass on the command line that it then uses to launch one of
your two existing executables via CreateProcess or ShellExecute.

You can make your security check (i.e. the code you pass on the command
line) as complicated as you like, I suppose; ultimately, it depends on how
determined your users are likely to be in terms of trying to get around your
restrictions.

Hope this makes sense.  Any questions, drop me a line.

Cheers,

Conor

-Original Message-
From: Chris Veale [mailto:[EMAIL PROTECTED]]

I want to implement something like a passcode that when entered allows the
user to do something different than a user without that passcode.  I have
all the functionality already in the code with compile conditions but from
all the help Ive looked through, I cant change this on the fly - it takes a
full recompile.

Is there any way of allowing this change at runtime using compile conditions
or am I going to have to rebuild the functionality with if statements?
---
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
  Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED] 
with body of unsubscribe delphi
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/



RE: [DUG]:changing compile conditions at runtime...

2002-12-05 Thread Conor Boyd
Actually, you could look at doing something with Delphi packages, although I
haven't tried anything like that myself, so I don't know how feasible it
would be.

Create two runtime packages with your different compiled functionality.

Your simple launcher exe might then be able to choose which package to load
based on the passcode.

Like I said, no idea how feasible or easy to implement, that would be, but
if it was, it would mean that you then still only have one executable.

HTH,

Conor

-Original Message-
From: Conor Boyd [mailto:[EMAIL PROTECTED]]

[snip]

Compile the two versions of your application (with the different compile
conditions) into 2 separate executables.  These executables should not run
unless a particular 'code' (known only to you as a developer) is passed as a
command line parameter.

Create a 'launcher' executable, which is responsible for asking the user for
the passcode.  Your launcher should use this passcode to determine the
correct code to pass on the command line that it then uses to launch one of
your two existing executables via CreateProcess or ShellExecute.

[snip]
---
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
  Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED] 
with body of unsubscribe delphi
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/



[DUG]: SQL Server Store Procedure failed when underlying table changes

2002-12-05 Thread Edward Huang
Title: Message



Hi,

This is not strictly Delphi question, but I use Delphi 
ADO to access it.

I use MS SQL Server 2000 here, and have many stored 
procedures and UDFs defined.
Every time I made some changed to tables (mainly add 
new columns), some SP or UDF failed to get correct result, usually column 
mismatch. I have to modify the SP/UDF to force it 
recompile.

The problem is I have many SP/UDFs, and it's 
unpractical to find every SP/UDF references the table I changed and open/change 
them. I tried to run 'sp_recompile tablename', but it doesn't help 
much.

So,does anyone out there know how to force SQL 
Server automatically recompile all SP/UDFs when I changed the 
table?

BTW, I use SQL Server Enterprise 
Manager.

Thanks,

Edward


Re: [DUG]: SQL Server Store Procedure failed when underlying tablechanges

2002-12-05 Thread Moisés López
hi there.i dont remember doin that when i used to work with sql server 
(strangely enough am more happy workin w/ IB)

but there's a great sql server forum that prob has an answer.

http://www.sqlmag.com/forums/

cheers,
moises.

---
   New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
 Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED] 
with body of unsubscribe delphi
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/


Re: [DUG]:changing compile conditions at runtime...

2002-12-05 Thread Corey Murtagh
- Original Message -
From: Chris Veale [EMAIL PROTECTED]
Sent: Friday, December 06, 2002 11:33 AM
Subject: [DUG]:changing compile conditions at runtime...


 Hi

 I want to implement something like a passcode that when entered allows the
 user to do something different than a user without that passcode.  I have
 all the functionality already in the code with compile conditions but from
 all the help Ive looked through, I cant change this on the fly - it takes
a
 full recompile.

 Is there any way of allowing this change at runtime using compile
conditions
 or am I going to have to rebuild the functionality with if statements?

The compile-time conditions alter the code that is produced, so any
condition that isn't met effectively comments out the code it encloses.  If
you want to offer variable functionality dependant on a code, user level,
etc. then you'll have to write the logic for it into your code.

How to go about it depends on a variety of things, including how much
difference there is between one level and another.  If you have only two
states that differ only in a few lines of code, then a conditional statement
is probably sufficient.  For a more complex difference (additions to the
interface, completely new functionality, etc), and if you use a reasonably
OO design, you could derive a higher-functionality object from the standard
interface, add whatever you need, then instanciate the one that fits the
current user level.

Remember KISS though.  If you don't need to change much, do it the simplest
way you can - which usually means conditionals in your code.

Final thought: if you want the REALLY complex way, how about implementing
the enhanced functionality in a BPL, and only distribute that to people who
need it.  Same as deriving from a common object, but with added security in
that people who don't have the BPL can't get access to the extra functions,
no matter how they try to hack the program.

--
Corey Murtagh
The Electric Monk
Quidquid latine dictum sit, altum viditur.

---
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
  Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED] 
with body of unsubscribe delphi
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/



[DUG]: Opposite of Pos()

2002-12-05 Thread Nahum Wild
All,

Ages ago I was trolling thru the help and I stumbled across a function that
did the opposite of Pos, it searched from the end of the string to the
beginning looking for a match.  I thought at the time that I should remember
it's name because it would most likely come in handy.  So I promptly forgot
it, as you do. :o)

Does anyone remember/know what the function name is?
Save me writing my own.

Cheers in advance,
Nahum.

---
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
  Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED] 
with body of unsubscribe delphi
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/



RE: [DUG]: Opposite of Pos()

2002-12-05 Thread Nahum Wild
Thats what I'd thought it was!  And that's why I saw it and then could never
find it again as I installed Indy a while back and then removed it :o)

Thanks,
Nahum.

 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
 wrote on 

 Nahum Wild wrote on Friday, 6 December 2002 4:33 p.m.:
 Ages ago I was trolling thru the help and I stumbled across a
 function that did the opposite of Pos, it searched from the end of
 the string to the beginning looking for a match.  I thought at the
 time that I should remember it's name because it would most likely
 come in handy.  So I promptly forgot it, as you do. :o)
 
 Do you mean RPos? To the best of my knowledge this function is only
 available if you are using Indy, though I don't know why it's not
 part of the standard VCL. 
 
 Cheers,
 Paul
 
 -
 Paul Eggleton  Ph:+64-9-4154790
 Software Developer Fax:   +64-9-4154791
 CJN Technologies Ltd.  DDI:   +64-9-4154795
 http://www.cjntech.co.nz   Email: [EMAIL PROTECTED]
 -
 --
 -
 New Zealand Delphi Users group - Delphi List -
 [EMAIL PROTECTED]
   Website: http://www.delphi.org.nz
 To UnSub, send email to: [EMAIL PROTECTED]
 with body of unsubscribe delphi
 Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/


attachment: winmail.dat

[DUG]: ADO question

2002-12-05 Thread Stephen Bertram
Hi all

I know I have seen this before and fixed it, but I can't remember how.  This is 
connecting to Ingres via ODBC with a TADOConnection. The failure is on a simple select 
statement.

  Error message : The requested operation cannot be performed with active queries

There are no current transactions and the ODBC connection dies immediately after this. 
 The statement it occurs on is run many times and fails consistently only after 
another procedure runs.  While I know there must be an issue in the other procedure I 
can't fault it by inspection (mainly because I don't know what I'm looking for).

Can anyone point me at the likely root cause?

TIA 

Stephen
---
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
  Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of unsubscribe delphi
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/