QBE answer table not populated with data

I have a query which I wish to populate a particular table (not the answer table). I have been unable to run this in objectpal. I think it has to do with the tilde variables but i'm not sure. following is my code.

The variable are populated correctly so any advise is most appreciated.

son = 22013
sol = 1

 
qvar = Query

Answer: :CaliachData:rptWorkorders.DB

WORKORDERS.db |WKOWONO | WKOPTNO |WKOBAL | WKOUSER | WKOUSE1 | WKOUSE2 | WKOUSER3 | WKOUSER4 |

|CHECK | CHECK |CHECK | CHECK |CHECK ..~sol | CHECK | CHECK ..~son| CHECK |

Endquery

ExecuteQBE(qvar)
tv.open(":CaliachData:rptWorkorders.DB")

Thanks

first, your vars.. they translate to

..1

..22013

and might not always work that way, mixing string and number.. better practice to set the string in the var, before

son = "..22013"

sol = "..1"

second, you can assign the table name two ways, either works

Answer: :CaliachData:rptWorkorders.DB

or

ExecuteQBE(qvar,":CaliachData:rptWorkorders.DB")

but here's the thing, to answer YOUR question

if not ExecuteQBE(qvar) then

  errorshow()

endif

if not tv.open(":CaliachData:rptWorkorders.DB") then

  errorshow()

endif

then you'll know why it's not working..

Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN

Hi Steven,

I have progressed a little further.

The variables are smallint from the page1 of the form. but I cannot get the query to find the record with those variables.

My code so far is:

var
qvar QUERY
solno Smallint
sono Smallint
tv TableView
Endvar

sono = page1.SalesOrderNo ; (field on Page1)
solno = self.value                  (current Edited Field)

qvar = Query

ANSWER::CaliachData:rptWorkorders.DB

:CaliachData:WORKORDERS.db |WKOWONO | WKOPTNO |WKOBAL | WKOUSER| WKOUSE1 | WKOUSE2 | WKOUSER3 | WKOUSER4 |

|CHECK | CHECK |CHECK | CHECK | CHECK = ~solno | CHECK | Check = ~sono | CHECK |

if not ExecuteQBE(qvar,":CaliachData:rptWorkorders.DB") then

errorshow()

endif

EndQuery
if not tv.open(":CaliachData:rptWorkorders.DB") then

errorshow()

endif

The query populates the answer db with all records.

Hi Steven,

I have progressed a little further.

The variables are smallint from the page1 of the form. but I cannot get the query to find the record with those variables.

My code so far is:

var
qvar QUERY
solno Smallint
sono Smallint
tv TableView
Endvar

sono = page1.SalesOrderNo ; (field on Page1)
solno = self.value                  (current Edited Field)

qvar = Query

ANSWER::CaliachData:rptWorkorders.DB

:CaliachData:WORKORDERS.db |WKOWONO | WKOPTNO |WKOBAL | WKOUSER| WKOUSE1 | WKOUSE2 | WKOUSER3 | WKOUSER4 |

|CHECK | CHECK |CHECK | CHECK | CHECK = ~solno | CHECK | Check = ~sono | CHECK |

if not ExecuteQBE(qvar,":CaliachData:rptWorkorders.DB") then

errorshow()

endif

EndQuery
if not tv.open(":CaliachData:rptWorkorders.DB") then

errorshow()

endif

The query populates the answer db with all records.

no errors, empty or wrong results in the Answer table.. ok.. verify the values being passed along.. before the query

sono.view()

solno.view()

that's what's going into the query.. is it what you want?

Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN

I have viewed the sono, solnn variables and they are correct as integers. Realy stumped by this, I have seveeral other QBE which work just fine.

and errorshow() doen't fire?

I'd suggest string(sono) and string(solno), but errorshow() would fire if lack of that was the problem

Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN