query problem opening a form

[DaveM]

Hi

I am getting an error when opening a large form on a slow laptop(Compaq 1250) with win98SE. This computer also uses AOL 8.0, if this means anything. When going from the startup form to the records form, it says a5 has generated an error and will be shut down.

This app is running fine on sveral other computers, but has a problem on this one.

Any help will be appreciated!

I FOUND PART OF IT

What is wrong with this?

tbl=table.current()
query.description = "Active Customers"
query.order = "acct"
query.filter = "scode=var->scode.and.status='A'"
query.options = "N"
tbl.query_create()

parent.fetch_last()

Dave Mason

[Stan Mathews]

RE: query problem opening a form

Without knowing the data type of var->scode it is hard to say.

Try

query.filter = "scode="+var->scode+".and.status='A'"
if var->scode is numeric

query.filter = "scode=' " +var->scode= " '.and.status='A'"
if var->scode is character

[DaveM]

RE: query problem opening a form

Stan,

Thanks for the reply!

All of it is characterand works like a charm on other computers.

[DaveM]

RE: query problem opening a form

Only on the one computer does it cause a problem. It will cause a fault error in a5 and kick it back to windows desktop. It only gives the message. On every other computer tested so far, it warks as written and does it's job.

Dave

[Jim Chapman]

RE: query problem opening a form

Hello Dave,

>>I am getting an error when opening a large form on a slow laptop(Compaq 1250) with win98SE

[DaveM]

RE: query problem opening a form

Thanks Jim,

That was not a winner and the newest drivers are also installed. I tried to cover all bases.

I really believe it has to do with something in the query shown above. I removed the query and it went in. I also have that and other queries on buttons and once pushed, I cannot go to anothe form without the error. Other instances tosses me out too, but I haven't isolated those yet.

Thanks for all Help.
Dave

[DaveM]

RE: query problem opening a form

Awaiting a new computer to remedy this

[Pat Bremkamp]

RE: query problem opening a form

Dave,

Sounds to me like an index problem that may be related to the locations of files in various directories. Is everything in a single directory? Is eveything is the same location on the laptop?

Pat

[DaveM]

RE: query problem opening a form

Thanks for your response.

everything is in the same directory and the only indexing or query used is as reads above.

We have come to the conclusion (right/wrong?)that the video is not up to snuff for modern(after 1900) programs. Compaq computers are not my favorite.

Thanks.
Dave