Warning Message Won't Go AWay

[julian lewis]

I keep getting the message "Are you sure you want to lose your changes" This is from the customer data table I can push yes or no and the message keeps popping up. I have to Ctrl.alt.delete. to get out of the program.

thanks
jc

[Tom Cone Jr]

RE: Warning Message Won't Go AWay

I suggest you reboot your pc, and then determine whether the problem occurs using the default form for the table (available from the right click menu for the table, in the tables / sets tab of the control panel.

-- tom

[julian lewis]

RE: Warning Message Won't Go AWay

Tom:

I put that whole folder aside for a minute and unzipped a backup I had did this morning.

The backup worked fine of course, until I did to it what I had did to the other one, add recno() and recount() fileds to the customer data table.

I went back and removed both fieds and it started working properly again.

any suggestions?

thanks
jc

[Tom Cone Jr]

RE: Warning Message Won't Go AWay

Nope, not in response to what you've described so far.

Got any details?

-- tom

[Cheryl Lemire]

RE: Warning Message Won't Go AWay

"" until I did to it what I had did to the other one, add recno() and recount() fileds to the customer data table.""

You are trying to put A5 functions as a field? Please explain because this does not make sense to me. What exactly is the purpose of these fields? What are you trying to accomplish?

If you are trying to, for example, have the record number retrieved for a particular record, saved in a field, and then displayed on your form/browse/report, wherever ... you may want to try this:

Be VERY careful with your field name, do something like rec_number so as not to use any A5 names. Make sure the type is compatible with the recno() and your size is large enough to accommodate the possible number of records within the table.

Then use fields rules, make the field a calculated field, and create an expression that retrieves the record number of the current record and fills the field with that data. If you have existing records now you will need to re-evaluate the field rules to update those records.

[davej]

RE: Warning Message Won't Go AWay

Julian,

It look to me like you are trying to use Alpha functions names as field names - BIG NO-NO! That, and using Alpha 'reserved words' (such as 'Print', 'Save', 'End') and Xbasic commands for field names will cause all kinds of grief, if Alpha lets you use them at all.

As was indicated previously, adding fields such as recdno (or recnum) and recdcount don't look like they will serve any purpose. Record count changes each time you add or delete a record and Alpha automatically keeps up with that; record number is just the order in which the record was entered and is automaticall genered as well.

Could you be thinking of something like customer number? If so, that it a whole different thing, depending on how you want it structured and if it is automatically incremented, or manually entered.

Dave

[julian lewis]

RE: Warning Message Won't Go AWay

What I was really trying to accomplish is to be able to see

"record 8 of 83" if a query was run.

thanks
jc

[davej]

RE: Warning Message Won't Go AWay

Julian,

Open Alphasports and go to the Customer form. Right click anywhere in the gray area of the form and select 'Find by Key', then click the 'Search by:' button and select '"Record-number order"'. Type the record number you want and it appears. Is this what you want?

Dave

[julian lewis]

RE: Warning Message Won't Go AWay

That looks good

thanks
jc