executeqbe Posts

{Too Long!}

Posted to MB Topic: Paradox Forms « Paradox Board

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

Posted to MB Topic: QBE & SQL « Paradox Board

{Too Long!}

Posted to MB Topic: ObjectPAL « Paradox Board

Is it possible to use a variable as a resulting value? Or is it only possible to use a variable as filter.  I would like the value in a variable to be put in the resulting column "DATETIMECHANGED". Thanks in advance, Gary var, todaysdatetime DateTime, custnbr String, qq Query, endVar custnbr = "1234", todaysdatetime = dateTime() qq = Query ANSWER: :PRIV:CHNGED.DB OPTIONS: NO AUXILIARY TABLES,ATA:Items.db | FILENO | CUSTNO |, | Check _join1 | ~custnbr | :DATA:PRICING.db | FILENO | QUANTITY | PRICE | DATECHANGED | REASON | INITIALS | PREVIOUSPRICE | PERCENTCHANGE | PRINTSELECT | LASTREFNO | SETUP |, | _join1 | Check | Check | Check calc ~todaysdatetime AS "DATETIMECHANGED" | Check | Check | Check | Check | Check | Check | Check |, EndQuery if NOT qq.executeQBE() then, errorShow(), else, endIf

Posted to MB Topic: QBE & SQL « Paradox Board

{Too Long!}

Posted to MB Topic: QBE & SQL « Paradox Board