Displaying a Blob field in a query

[alvinmcg]

I am attempting to develop a new "application" in Paradox8. I am creating a query and want/need the contents of a memo field to display in the answer table. When I select the field with a "check" and attempt to run the query, I get an error message which states "Blob cannot be used as a grouping field."

How can I get the contents of this field included in the answer table?

 

[Langley]

It sounds like the problem may be in the report, not the answer table. Checking the blob field and running a standard query will always produce a result set that includes that blob field. The error you describe sounds more like the error generated by a report when someone tries to place a group band on the report that is based on the blob field. This would alos happen if you designed a report and grouped it on an allowed field, then changed the field type to a memo or other blob field.

Post the contents of your query (myQuery.qbe) by opening it with Wordpad, so we can have a look.

Mac

"There are only 10 kinds of people in this world... those who understand binary and those who don't"

langley_mckelvy@cd4.co.harris.tx.us

 

[alvinmcg]

This query is a little long, so my apologies...

The CLOSE-OUT CORRESPONDANCE.DB table has a COMMENTS field which is formatted as a memo field. I can not even save the query with the field checked.

Thank you for your assistance.

Alvin

*********************************
Query
ANSWER: RIV:ANSWER.DB

COs.DB | SPR Number | Acceptance Date | Description | Type of Use |
Set | _temp | | | |
Set | _temps | >= 04/01/2002 | blank | TCO or PUU |
Set | _perm | >= 04/01/2002 | blank | FAU or PCO or CL |

Projects.DB | SPR Number | Project Name | Street Number |
| only _final, no _temp, _join1 | Check | _num |
| only _temps, _join2 | Check | _numb |
| only _perm, _join3 | Check | _numbe |

Projects.DB | Street Name |
| _na, calc _num+" "+_na as Address |
| _nam, calc _numb+" "+_nam as Address |
| _name, calc _numbe+" "+_name as Address |

Projects.DB | Project Status |
| Check final.. or site.. |
| Check temp.. |
| Check perm.. |

ProjectFirms.DB | SPR Number | Consultant | Point of Contact |
| _join1 | Check _join6 | Check |
| _join2 | Check _join4 | Check |
| _join3 | Check _join5 | Check |

Consultants.DB | Consultant Firm | Office Phone |
| _join6 | Check |
| _join4 | Check |
| _join5 | Check |

ProjectPermits.DB | SPR Number | Final Inspection |
Set | _final | >=04/01/2002 |

Close-Out Correspondance.DB | SPR Number | Date |
| _join1 | Check |
| _join2 | Check |
| _join3 | Check |

EndQuery

 

[Langley]

I'm not really very familiar with set queries, but I think they do grouping by default. If that is the case, it might be better for you to do this in two queries, using a join to add the comments based on the SPR Number field (if that's unique) after the primary query is complete.

Mac

"There are only 10 kinds of people in this world... those who understand binary and those who don't"

langley_mckelvy@cd4.co.harris.tx.us