Query Failure Columns in all Rows

[Rickinrsm]

Hi All . . .
When I run this query I get the following error:

Expecting consistent number of columns in all rows of table; :Scmls:Scmls.db

Everything looks good to me. Any ideas?

Thanks much . . . Rick

qbe=Query

:Scmls:OfficeRosterUpdate.bd | UID | OFFICENAME   |
                             | _ID | _Name        |

:Scmls:Scmls.db  | OFFICELIST | OFFICELIST_OFFICENAME |
                 | _ID |      | Changeto _Name  |

endquery
	if not qbe.executeQbe()then
errorShow()
	return
	endif

qbe=Query

:Scmls:OfficeRosterUpdate.db | UID | OFFICENAME   |
                             | _ID | _Name        |

:Scmls:Scmls.db  | OFFICESELL | OFFICESELL_OFFICENAME |
                 | _ID |      | Changeto _Name  |

endquery
	if not qbe.executeQbe()then
errorShow()
	return
	endif

 

[Rickinrsm]

Okay . . . I found the problem.

I had one too many | in the the query fields after _ID.

Learn from my mistake!

Rick