Run QBE in method using alias

[paulvos]

I want to run a QBE inside a method. For this I have made a QBE file and imported the ascii version in the method. This approach works fine inside the working directory. However if I need to query a database in a different directory or on a different disk this does not work, not even if I define an alias. After running the method I find the alias in the directory viewer of the project viewer, but still the answer comes up empty. Running the same query by hand does give a result.

Can anyone give me a working method, so I can build from there? I'm running Paradox 9 on W2000

 

[Langley]

Please post the code. If the alias is defined and also included in the query text, then there is no reason it should not work.

i.e.

q=query

:myalias:mytable.db | field1 | field2 |
                    | check  | check  |

endQuery

Mac

"Strange women lying in ponds and distributing swords is no basis for a system of government" - Dennis, age 37

mailto:langley_mckelvy@cd4.co.harris.tx.us

 

[paulvos]

Dear Mark,

Here is the used code:


method pushButton(var eventInfo Event)

Var
Salesinfo Database
Verkoop String
Sales String
Date1 String
Date2 String
Maand String
cDate1 Date
cDate2 Date
RepV Report
Info1 ReportPrintInfo
Info2 ReportPrintInfo
qVar Query
FM Form
tv TableView
Endvar

Maand.View("Voor welk maandnummer? (mm): &quot
Grpvrdmnd="Grpvrd"+Maand+".dbf"

addAlias("Archie","Standard","F:\\archie8\\data&quot

qVar=Query

:Archie:ART000.DBF | ARTNR | GROEP | KOSTPRIJS |
| Check not *.. | Check | _1, calc sum as Kost |

:Archie:ART000.DBF | STAFFEL | VRD |
| calc _1*_2 as Waarde | _2, >0, calc sum as Vrd |

:Archie:ART000.DBF | RES | VRK |
| calc sum as Geres | calc sum as Verk |

:Archie:ART000.DBF | BST |
| calc sum as Best |

:Archie:TAB000.DBF | K | T01 |
| Check _a | Check |

EndQuery

qVar.executeQBE("test.dbf&quot

tv.open("test.dbf&quot


endMethod

 

[ros]

try:

if not qVar.executeQBE("test.dbf&quot then
errorshow()
endif

and see if you get an errormessage
Richie

 

[ljprivara]

Check out PARADOX 9 Help | ObjectPal Reference "executeQBE example 2" for correct syntex and methodology for querying a foreign database.

 

[Langley]

I see no corresponding link to _a in the table :Archie:ART000.DBF

Mac

"Do not delve too deeply in the arts of your enemy and so become ensnared by them"

langley_mckelvy@cd4.co.harris.tx.us