start up form error

[DaveM]

Hi all,

small problem you may be able to help with.

I have v9 developement that this works perfectly with in a oninit event for a startup form. It also works with v7 developement and runtime. It does NOT work with v9 runtime.

the error comes when the script getsto ix=t.query_create() . It says field does not exist.

t=table.open("slspeeps",file_ro_shared) 
query.filter="username="+quote(trim(scode))
query.order="" 
query.options="T" 
ix=t.query_create() ' ix is not dimmed anywhere
 if ix.records_get()=0 then 
  a5.close() 
 end if 
username=t.username 
salesman=t.salesname 
cellphone = t.cellphone 
password = t.password 
usernow = t.usernow
permissions = t.permissions
userlot = t.lot
gotoileads = t.gotoileads
gotosales = t.gotosales
gotoother = t.gotoother
gotoreports = t.gotoreports
gotocsi = t.gotocsi
buycar = t.buycar
gotoslsschedule = t.gotoslsschedule
gotoslslabels = t.gotoslslabels
setupemail = t.setupemail
seedealnumbers = t.seedealnumbers
reshadow = t.reshadow
gotocomp = t.gotocomp
cleantbls = t.cleantbls
gotoinv=t.gotoinv
editletters=t.Editletters
gotoslspeople = t.gotoslspeople
editownpassword = t.editownpassword
editownuserinfo=t.editownuserinfo
seeallslspeople=t.seeallslspeople
editpermiss=t.editpermiss
gotovendors=t.gotovendors
gotobanks=t.gotobanks

I have dimmed the ix as a P to no avail.

[Tom Cone Jr]

Re: start up form error

Hi Dave. Tell us about "username" and "scode". What are they? Where are they initialized? What values would typically be present when the script runs?

I personally avoid overloading the OnInit event for forms. Prefer to load the form but keep it hidden. Set field values as needed. Set controlling index or query. Then when everything is set, I show the form to the user. It's a mistake to think the form stops opening while the OnInit runs.

-- tom

[DaveM]

Re: start up form error

Thanks for looking Tom.

username is a c variable and scode is a field in a table

the oninit is really pretty short compared to what I have used it the past.

[Stan Mathews]

Re: start up form error

username is a c variable and scode is a field in a table

Then I think you have the filter backwards...

query.filter="username="+quote(trim(scode))

would be

query.filter="scode="+quote(trim(username))

[DaveM]

Re: start up form error

Hi Stan,

I also reported it as a bug. Selwyn says it can't happen.

I will try your suggestion today and also the one Selwyn gave me as follows.

i would suggest that before you to t.query_create(), you add this line to your script:

showvar(t.field_name_get() + crlf(3) + "filter: " + query.filter)

this will give you a list of fields in the table and you can confirm for yourself if all of the fields in your filter exression are indeed in the table.

.

[DaveM]

Re: start up form error

Stan,

That did not work with the developement or the runtime. I then had the same error on each. When I changed it back, the error went away on the developement program, but persists on the runtime.

What Selwyn gave me was no help either.

.

[Stan Mathews]

Re: start up form error

If my suggestion didn't work then you had it backwards when you said

username is a c variable and scode is a field in a table

In the interactive type (paste from here)

t=table.open("slspeeps",file_ro_shared)
? t.username
'see the result here
'then
t.close()

That will tell you if the field is in the table where you want to use it in the query.filter.

[DaveM]

Re: start up form error

Stan,

With reversing as you suggested and then reversing back to the way it was, I can now oppen the server files without an error. It will not work on the shadow. I have deleted the shadow dbf files and did the shadow over again to no avail.

All help is appreciated too!! and yes the username is a field and scode is a variable. I told you wrong. The fields show up in the shadowed table when viewed in a browse.

Here is what I have now:

'dim ix as P
t=table.open("slspeeps",file_ro_shared) 
'query.filter="scode="+quote(trim(username)) ' I tried it this way per Stan and hd more errors
query.filter="username="+quote(trim(scode)) ' it has worked this way for several years
query.order="" 
query.options="T" 
'showvar(t.field_name_get() + crlf(3) + "filter: " + query.filter)
ix=t.query_create() 
 if ix.records_get()=0 then 
  a5.close() 
 end if 
username=t.username 
salesman=t.salesname 
cellphone = t.cellphone 
password = t.password 
usernow = t.usernow
permissions = t.permissions
userlot = t.lot
gotoileads = t.gotoileads
gotosales = t.gotosales
gotoother = t.gotoother
gotoreports = t.gotoreports
gotocsi = t.gotocsi
buycar = t.buycar
gotoslsschedule = t.gotoslsschedule
gotoslslabels = t.gotoslslabels
setupemail = t.setupemail
seedealnumbers = t.seedealnumbers
reshadow = t.reshadow
gotocomp = t.gotocomp
cleantbls = t.cleantbls
gotoinv=t.gotoinv
editletters=t.Editletters
gotoslspeople = t.gotoslspeople
editownpassword = t.editownpassword
editownuserinfo=t.editownuserinfo
seeallslspeople=t.seeallslspeople
editpermiss=t.editpermiss
gotovendors=t.gotovendors
gotobanks=t.gotobanks
gotoagents=t.gotoagents
gotorebates=t.gotorebates
deletesales=t.deletesales
makebackup=t.makebackup
editcompinfo=t.editcompinfo
advertisers=t.advertisers
t.close()
if alltrim(pword)<>alltrim(password) then
 UI_MSG_BOX("User","Your User name or Password is incorrect. UpsLog will now close",UI_OK)
 sleep(3)
 a5.close() 
end if

[Tom Cone Jr]

Re: start up form error

Any reason all this heavy lifting couldn't be off loaded to the autoexec script?

Is the table that's opened by the script also a table that supports the startup form?

Look for ways to lighten the load placed on the OnInit event.

[DaveM]

Re: start up form error

Hi Tom,

I offloaded to autoexec and a function and another script. tried to break it up good. not much left in the oninit.

It is still the same. It works in the server folder, but not the shadow folder.

I opened the shadow and tried a database compact and got over 100 errors. This is not good. it was mostly to do with field rules.

It does not give the errors in the server folder.

I have restarted v9 many times and so to, the computer.

Dave

[Stan Mathews]

Re: start up form error

It works in the server folder, but not the shadow folder.

I opened the shadow and tried a database compact and got over 100 errors.

I take this to mean that the shadow differs from the live database.

Have you examined the creation of the shadow to make sure it is being created where you mean it to be and that when you open the shadow you are opening the right one?

[DaveM]

Re: start up form error

Tom, Stan,

I could not think of 2 smarter people here.

The folders differ of course. one is named ups55s, the other is ups559(s being for server files.

I copied the whole server contents into the shadow folder after emptying it. I could start the app fine. Rather than make a mess, I then created the shadow right over the top of the server file already in the shadow folder. I got the same problem on starting the shadow.

I am somewhat baffled. It seems to me the making of the shadow is corrupting files. I have copied all the supporting files over to the shadow(no dbf) and still get the problems.



.

[Tom Cone Jr]

Re: start up form error

Dave, suggest you delete the shadow folder. Then let Alpha Five create the shadow for you by network optimizing the work station.

You don't by chance have portions of your application spread across multiple folders or subfolders do you?

[DaveM]

Re: start up form error

Tom,

Deleted everything. started over and no, Everything is in one folder.

I also downloaded the most recent patch and installed it even though it is the same version.

dave

[DaveM]

Re: start up form error

Tom, Stan,

Thanks a bunch for helping me with this.

I deleted the folder, made another folder with a new name, used the developement prog to make the shadow and then inserted the runtime into that folder.

It works great now and the changes i made at Tom's bequest seems to have helped the speed greatly.

THANKS!!!


.