: 16 May 2000 19:26
To: [EMAIL PROTECTED]
Subject: RE: Boolean fields in Foxpro
I don't see why not. To be honest I've never tried to execute an external
application from CF. One item I'm not sure of is if CF will wait for the
application to finish. If it does then I'd run with it.
Another way
on Sunday which perform's a
CFLock and then executes an external app which pack's the DB?
Regards
Michael O'Reilly
Analyst Programmer
TransAer
-Original Message-
From: Bill Grover [mailto:[EMAIL PROTECTED]]
Sent: 15 May 2000 22:44
To: [EMAIL PROTECTED]
Subject: RE: Boolean fields in Foxpro
il: [EMAIL PROTECTED]
Original Message
Date: Mon, 15 May 2000 15:51:53 +0100
From: Michael O Reilly [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: RE: Boolean fields in Foxpro
Message-ID: ECE6504EA487D3118D8A00805F59102E7EB2BA@NT_BACKUP
Bill,
Apologies for not replying. The ISDN link for
, 16 May 2000 09:21:19 +0100
From: Michael O Reilly [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: RE: Boolean fields in Foxpro
Message-ID: ECE6504EA487D3118D8A00805F59102E7EB2D1@NT_BACKUP
Bill,
Don't worry about speed of reply's. I find that I don't have time to read
even a quarter of the stuff
PROTECTED]'
Subject: RE: Boolean fields in Foxpro
Yeah, without FoxPro it becomes much more difficult to figure out what is
happening. You are correct, the database container contains the complete
structure of all the tables in the database. It also contains any
relationships between the tables
e MD 20850
Phone: 301-424-3300 x396
FAX:301-424-3300 x1396#
E-Mail: [EMAIL PROTECTED]
Original Message
Date: Mon, 15 May 2000 15:51:53 +0100
From: Michael O Reilly [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: RE: Boolean fields in Foxpro
Message-ID: ECE6504EA487D3118D8A00805F59
Date: Wed, 10 May 2000 14:15:18 +0100
From: Michael O Reilly [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: RE: Boolean fields in Foxpro
Message-ID: ECE6504EA487D3118D8A00805F59102E7EB26B@NT_BACKUP
Bill,
Thanks for the Tips
I'm using the very latest version of MDAC (2.5) I'm al
he
Boolean field to a Byte (TinyInt) and using 0 for False and 1 for True.
Regards
Michael O'Reilly
Analyst Programmer
TransAer
-Original Message-
From: Bill Grover [mailto:[EMAIL PROTECTED]]
Sent: 10 May 2000 13:46
To: '[EMAIL PROTECTED]'
Subject: RE: Boolean fields in Foxpro
Meadors [mailto:[EMAIL PROTECTED]]
Sent: 09 May 2000 16:03
To: [EMAIL PROTECTED]
Subject: RE: Boolean fields in Foxpro
I know this works:
CFQUERY
INSERT INTO Tablename (BooleanField) VALUES (.T.)
CFQUERY
Larry
[EMAIL PROTECTED] 05/09/00 01:50AM
I can't believe that this is causing me so much
= 5
CFQUERY
will toggle the field to True or False
-Original Message-
From: Bill Grover [mailto:[EMAIL PROTECTED]]
Sent: 08 May 2000 13:32
To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
Subject: RE: Boolean fields in Foxpro
I just caught up with the thread, I would be very surprised
I know this works:
CFQUERY
INSERT INTO Tablename (BooleanField) VALUES (.T.)
CFQUERY
Larry
[EMAIL PROTECTED] 05/09/00 01:50AM
I can't believe that this is causing me so much grief.
Last night I tried the following
CFQUERY
INSERT INTO (Tablename.BooleanField)
VALUES ('.T.')
CFQUERY
I also
Hi All,
I'm having a simple problem I'm sure someone has come up against before.
I developed a CF system with an Access backend.
This was then ported to Foxpro.
Nearly everything worked fine but I'm having a problem setting Boolean
fields.
When I try the following -
CFQUERY
INSERT INTO
Try removing the ' ' marks.
In Boolean fields, some applications do not need them
- Original Message -
From: "Michael O Reilly" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, May 08, 2000 4:41 AM
Subject: RE: Boolean fields in Foxpro
Hi All,
I'm having a simple p
: Randy Adkins [mailto:[EMAIL PROTECTED]]
Sent: 08 May 2000 09:46
To: [EMAIL PROTECTED]
Subject: Re: Boolean fields in Foxpro
Try removing the ' ' marks.
In Boolean fields, some applications do not need them
- Original Message -
From: "Michael O Reilly" [EMAIL PROTECTED]
0 and True becomes -1.
- Original Message -
From: "Michael O Reilly" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, May 08, 2000 4:51 AM
Subject: RE: Boolean fields in Foxpro
I've already tried VALUES (0), I'm assuming that TRUE needs to be wrapped
in
special char t
10:09
To: [EMAIL PROTECTED]
Subject: Re: Boolean fields in Foxpro
Going off the wall here again, when you used '#TRUE#'
did you also try it without the ' ' marks?
I know most Boolean uses 0 and -1 for other data types as
well. I am not sure in Foxpro.
Have you hit the HELP file in Foxpro?
When
-
From: "Michael O Reilly" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, May 08, 2000 5:19 AM
Subject: RE: Boolean fields in Foxpro
If I used #TRUE# (without quotes) then ColdFusion would think I was
referencing a variable called True.
I could try it but I would expec
Thanks for the help, much appreciated. I'll try '.T.'
I remember that notation from my DBaseIV days.
Regards
Michael O'Reilly
TransAer
-Original Message-
From: Randy Adkins [mailto:[EMAIL PROTECTED]]
Sent: 08 May 2000 10:43
To: [EMAIL PROTECTED]
Subject: Re: Boolean fields in Foxpro
18 matches
Mail list logo