Query Error

[sales]

I get the following error message from the following qbe.

Expecting a column separator in table header

Code follows

var INVQBE QUERY
selInv Anytype
tblName String
tblVar Table

endvar

{clear TEMP.DB of data }
tblName="TEMP.DB"
tblvar.attach(tblName)
tblvar.empty()

;Test Variable
selInv=47

{the following code deletes updated details from Orders.db
and ordertran.db }

INVQBE=QUERY {Delete selected from ORDTRAN.DB}

Ordtran.db |INV NO |
Delete |~selInv |

endQuery

if not executeQBE(INVQBE)then ERRORSHOW() endif

INVQBE=QUERY {Delete selected from ORDERS.DB}

orders.db |INV NO |
Delete |~selInv |

endQuery

if not executeQBE(INVQBE)then ERRORSHOW() endif

endmethod

help
please reply to

ma...@lumitron.co.uk

[Peter Nielsen]

Try moving the '{Delete selected from ORDTRAN.DB}' comment outside of
the QUERY... ENDQUERY statement. I think that will solve out proble,

Regards,

Peter

[Brian Bushay Ctech]

>I get the following error message from the following qbe.
>
>Expecting a column separator in table header

which of the two queries produces the error?
What version of Paradox are you using?
What is the directory name where this table resides?

Brian

[Gene De Guzman]

Try putting double quotes between ...

| "INV NO" |

sales wrote:

> I get the following error message from the following qbe.
>
> Expecting a column separator in table header
>