Creating a new logical column with false values

Hi everybody!

In the table resulting from a QBE I need to have a new column of the logical type containing all false values.

I was used to type CALC 1 AS NEWFIELDNAME  to generate a new longint field named NEWFIELDNAME having the default value of 1.

So, I tried doing CALC FALSE AS NEWFLAG, but that syntax produces a new STRING field containing the word "FALSE"... :)

I then thought that CALC 1<>1 AS NEWFLAG would do the trick, but that simply isn't accepted by the QBE parser...

Any ideas? :)

Frelance IT consultant and programmer since 1991: www.atipica.it

First thought.  Create table with two fields.  One field that will link to some field in your existing table, say a longint.  The other field a logical field.  Create a single record with some value in the longint and a false in the logical.  Link this table to the table in the qbe using the inclusive opperator on the longint field.  It is not necessary to include the longint but you will want to include the logical.

Dan Fought
Senior Programmer Analyst
Prestwood IT Solutions
http://www.prestwood.com

This will work but you need to deny the join, that is, select the record from the helper table that does NOT match each record in the queried table:

:projdata:sometable.db | Somecolumn | Othercolumn |

                       | Check _j1! | Check       |

:homedata:BoolDual.db | SameTypeAsSomecolumn | BoolWithFalse |

                      | not _j1              | Check         |

-Al.

Yep, that will work.   However there is an outside chance that the values will match.  You will need to make sure the value in the helper table has a value that does not exist in the joined table.

Dan Fought
Senior Programmer Analyst
Prestwood IT Solutions
http://www.prestwood.com