Failed Query Again!

[Rickinrsm]

Rats! Can't figure why this fails?

The query doesn't run. The pop up data entry window (Xdate) doesn't open.

Knowing me its got to be something stupid!

Any ideas . . . ?

Thanks much . . . Rick

method action(var eventInfo ActionEvent)
var;----------------Declare Variables-------------
OCDownloadLND	table
QueryAddToLand	table
q					query
i					longint
endVar;-------------End Variable List-------------
addAlias("MYDIR","Standard","D:\\DownloadData")
;-------------------------------------------------
Xdate = "Enter the Date Range"
Xdate.view("OFFMARKETDATE")

q=query

Query

ANSWER: :Pdoxwin7\\WORK:QueryAddToLand.DB

D:\DownloadData\OCDownloadLND.DB | STREETNUM  | STREETNAME | CITY       | 
                                 | CheckPlus  | CheckPlus  | CheckPlus  | 

D:\DownloadData\OCDownloadLND.DB | LISTPRICE  | SALESPRICE | 
                                 | CheckPlus  | CheckPlus  | 

D:\DownloadData\OCDownloadLND.DB | OFFMARKETDATE    | OFFICELIST |
                                 | CheckPlus ~Xdate | CheckPlus  |

D:\DownloadData\OCDownloadLND.DB | PRPOFFICENAME | OFFICESELL | 
                                 | CheckPlus     | CheckPlus  | 

D:\DownloadData\OCDownloadLND.DB | OFFICESELL_OFFICENAME | LISTSTATUS     | 
                                 | CheckPlus             | closd or CLOSD | 

EndQuery

 	if not q.executeQbe()then
			errorShow()
		return
	endif
   Message("Finished Land Query Parsing Your Eminence . . . ")

endMethod

 

[Rickinrsm]

Okay . . . here I go again. I didn't have a

method pushButton(var eventInfo Event)

I fixed that but now I get this error:

"expecting a column seperator in table header."

Ideas . . ?

Rick

 

[TonyMcGuire]

Don't the tables need double backslahes in the path?

Or, since you went to the trouble to define an alias, use the alias.

:mydir:OCDownloadLND.DB


Also, you might want to get rid of the second query

q=query

Query




Tony McGuire

http://www.thedbcommunity.com

"It's not about having enough time. It's about priorities.

 

[TonyMcGuire]

Oh, and I don't think this is a valid alias

ANSWER: doxwin7\\WORK:




Tony McGuire

http://www.thedbcommunity.com

"It's not about having enough time. It's about priorities.

 

[TonyMcGuire]

Are you aware that you can put the 'answer' table info in the execute portion of a query?

if not q.executeQbe(":WORK:QueryAddToLand.DB")then
errorShow()
return
endif



Tony McGuire

http://www.thedbcommunity.com

"It's not about having enough time. It's about priorities.

 

[Rickinrsm]

Hi Tony . . .

As always, you're right there when I need you. Kewl!

Your first answer fixed the problem and now it's working great.

Taks care Tony.

We would all be lost without you.

Rick