logical fields 
Author Message
 logical fields

I'm trying to figure out how to extract a report from my database on the
logical (true, false) fields in Pdx for windows. the manual isn't helpful.
What I need is a statement like if field = true then include in report
"filename".
Any suggestions.
--



Thu, 04 Jul 1996 22:17:06 GMT
 logical fields


Quote:
>I'm trying to figure out how to extract a report from my database on the
>logical (true, false) fields in Pdx for windows. the manual isn't helpful.
>What I need is a statement like if field = true then include in report
>"filename".
>Any suggestions.

Paradox does not have a "logical" field type.  What you should use instead is
an Alpha field that holds the value "True" or "False" or "T" or "F" or however
you wish to represent the value.  

On a report, you can use an IIF to decide whether or not to print something out.
If you are calling a report from a form, use a TCursor to open the table, find
the record, and test for True or False.   Whatever condition you find will
determine which report you open up.

Hope that helps.

--
                    Limax Computing - Paradox Questions?




Fri, 05 Jul 1996 05:32:49 GMT
 logical fields

Quote:
>I'm trying to figure out how to extract a report from my database on the
>logical (true, false) fields in Pdx for windows. the manual isn't helpful.
>What I need is a statement like if field = true then include in report
>"filename".
>Any suggestions.

I do not understand your last statement.  Could you clarify what it is you
want to happen if FIELD = True?  Include what in report "filename"?  Or is it
include report "filename"?  Sorry, I do not understand.


Sun, 07 Jul 1996 03:30:19 GMT
 logical fields

: >I'm trying to figure out how to extract a report from my database on the
: >logical (true, false) fields in Pdx for windows. the manual isn't helpful.
: >What I need is a statement like if field = true then include in report
: >"filename".
: >Any suggestions.

: I do not understand your last statement.  Could you clarify what it is you
: want to happen if FIELD = True?  Include what in report "filename"?  Or is it
: include report "filename"?  Sorry, I do not understand.

I don't understand either.  Perhaps you are looking for something like
"If TITLEON=true then ReportTitle=(filename) else ReportTitle=BLANK"?  If
that's the case, the field for ReportTitle can use an immediate if (iif)
to pick between the title field (special) and blank.

--Kasey Chang



Mon, 21 Oct 1996 13:01:42 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Copying logical fields to a memo field in one database

2. Changing the value in logical fields in a report

3. SQL Problem using a Logical Field

4. Indexes on logical fields

5. Logical Fields in postgres.

6. Boolean (logical) Field

7. calculating logical fields with sql?

8. BDE, dBASE, SQL, and Logical fields (boolean)

9. Paradox LOGICAL fields

10. Accessing logical fields in paradox tables via ODBC

11. Reportsmith and logical fields

12. Constants for logical field types idapi.h


 
Powered by phpBB® Forum Software