Posting error

[Al Buchholz]

Re: Posting error

Doesn't work for either adding to or replacing.

My example uses the replace. Does it work on your machine Tom?

[Tom Cone Jr]

Re: Posting error

Yes, Al. It does.

[Al Buchholz]

Re: Posting error

I think I still like the update operation on the set rather than the posting operation to the many......

I'm not keen on the & in the directory name, but that's the old school in me. Keep it to letters, numbers, & underscores...

[Chris Howell]

Re: Posting error

Well Gentlemen,

I created copies (without the 2006 prefix in the file name) of the original files which were named 2006 Delegates.dbf & 2006 Exhibitors.dbf & then blanked out the personal data so I could send them to you in a public forum.

But before I did I ran the same old posting procedure & it worked!

So I copied the original files again & again called them Delegates.dbf & Exhibitors.dbf again without the 2006 prefix and this time didn't blank out any fields - AND the post worked again.

What can we conclude from this about the reliability of A5?

Chris

[Tom Cone Jr]

Re: Posting error

Table names that begin with nonalpha characters are not recommended. Numeric digits are nonalpha. Alpha Five is behaving correctly. Reliability confirmed.

By the way, if you had posted a reduced scale version of your actual database earlier we could have gotten to this point a lot quicker. But in the end I'm glad we came up with an explanation, perhaps it will be of use to others later on.

[Chris Howell]

Re: Posting error

Table names that begin with nonalpha characters are forbidden. Numeric digits are nonalpha. Alpha Five is behaving correctly. Reliability confirmed.

Forbidden by whom - and where is this truth written so we all might know it?

[Tom Cone Jr]

Re: Posting error

Chris, I edited the previous response. I misspoke. The help file "recommends". It doesn't forbid. Check the index to the help file. Choose topic "Table", then Choose "Names".

[Al Buchholz]

Re: Posting error

Or from the web based help file this link - the one Tom referred to...

Basic Concepts and Terminology

[Chris Howell]

Re: Posting error

Chris, I edited the previous response. I misspoke. The help file "recommends". It doesn't forbid. Check the index to the help file. Choose topic "Table", then Choose "Names".

As always thanks for your help, I much appreciate your time, but the issue about the reliability of the posting process in A5 is still unresolved when it seems to work every time for me in A4v8 (which I don't really want to have to use) but only works "sometimes" in A5, with or without numbers in the file name.

Best regards,

Chris

[Tom Cone Jr]

Re: Posting error

You're welcome. I'm glad we were able to at least identify what was causing the problem you were having. -- tom

[ITALIA]

Re: Posting error

Can someone help explain why I get this error when I perform posting operation. It happens inconsistently.

Here's the error:
Error running Post Operation
Variable post.m_exp1 expression - Field not recognized.

Thanks,
Willie

Hi Willie,
the same problem was happening to me with Alpha5 V6 when i was trying to import data from another table.
My solution was to set a variable containing the value that i needed to post, and then use that variable when posting.

To easily create a custom variable, this are the steps that i follow:

• when you open any form in design mode, a couple of buttons appear on the top-right hand side. One is xy (to edit calc fields) and another is V to edit variables. If you click on the second one, you'll be able to create custom variables and assign a default value. Try to assign the value that you need to post as the default value for your variable, and then you can use such variable for thge posting. When i tried like this, it worked for me.

Regards,
MAURO TRENTINI

[Chris Howell]

Re: Posting error

Thank you Mauro,

I have solved this problem for my purposes by simply renaming any file involved in a post between two files using A5 by not using any numbers in the file names.

Irritating, considering Windows allows numbers in file names, and confusing when trying to, for example, compare files from different years, but it seems to work if no numbers are included in the file names being used by A5.

Chris

Hi Willie,
the same problem was happening to me with Alpha5 V6 when i was trying to import data from another table.
My solution was to set a variable containing the value that i needed to post, and then use that variable when posting.

To easily create a custom variable, this are the steps that i follow:

• when you open any form in design mode, a couple of buttons appear on the top-right hand side. One is xy (to edit calc fields) and another is V to edit variables. If you click on the second one, you'll be able to create custom variables and assign a default value. Try to assign the value that you need to post as the default value for your variable, and then you can use such variable for thge posting. When i tried like this, it worked for me.

Regards,
MAURO TRENTINI

[Al Buchholz]

Re: Posting error

Thank you Mauro,

I have solved this problem for my purposes by simply renaming any file involved in a post between two files using A5 by not using any numbers in the file names.

Irritating, considering Windows allows numbers in file names, and confusing when trying to, for example, compare files from different years, but it seems to work if no numbers are included in the file names being used by A5.

Chris

The issue is not that there are numbers in the file name, it's only that the file name must begin with an character from a-z. After that it can be a letter, number or underscore (_). While the file naming is not edited for that rule (too many people violate it with other software that build dbfs) it can lead to isolated problems like this.

Unfortunately for the person having the problem, it's not an isolated problem. It's directly affecting them...

It's the old adage - What's the difference between a recession and a depression (economically)? The recession is when the neighbor loses a job and a depression is when you lose your own job.....

As far as having files for a single year, name the file with the year as a suffix instead of a prefix and you should not have problems...

[CJI]

Re: Posting error

Want to thank all of you for this thread-it solved my Post Operation error problem "Error running post operation field is not recognized" with V9. My file name started with a numeric-once I removed it worked. Wish Alpha would edit check for file name errors at file creation time-would save a lot of time. So yes-the time and discussion was worth it-for me anyway. Thanks again.

[Al Buchholz]

Re: Posting error

Carl

Great job on using the search. Always good to find the answer in the fray.

Curious - how long did it take you to find this thread?