Subject Re: DB Engine Error and Bad Field Name
From Sean <sean@seanwessels.co.za>
Date Tue, 23 Jan 2024 09:59:37 -0500
Newsgroups dbase.getting-started

Hey Mervyn,

Thanks for responding!

I have managed to come right and posted an update, in future ill take screenshots and attach them here.

But to provide answers to the below which may help someone in the future:

What version of dBASE are you using?
-> dbase2019

Do you have sourcecode for existing applications?
-> Yes

Is the data in .dbf tables, .db tables or a SQL server?
-> .dbf tables

Are the errors caused by running existing programs?
-> No existing programs, however the error which reads simply as "Database Engine Error:  At end of table." has been encountered before by my mom in law who used to program.

If existing code, is it written in XDML (the original dBASE for DOS
commands) or OODML for Windows?
->  Most likely XDML. Much of the code is from my mom in law.

Are the errors as a result of new code you are creating?
-> Yes. I know I know, likely culprit. But turns out I was actually doing alright on this one.




Mervyn Bick Wrote:

> On 2024/01/23 12:23, Sean wrote:
> > Hi there,
> >
> > The family business has required me to pickup dBase. Excuse the entry level questioning.
> >
> > I am running into two errors:
> >
> > 1. "Database Engine Error:  At end of table." - I cant seem to find any reference to this error in the dBase books or online.
> >
> > 2. Bad Field Name - checked databases and field name is correct and present in both. Also checked code for whitespace.
> >
> > A little perplexed at this point. Any help would be appreciated and happy to buy you a coffee :)
> >
> > Sean
>
> Please give the EXACT wording of error messages.  Most times, but
> unfortunately not always, dBASE will give the line number in code
> causing the problem.
>
> What version of dBASE are you using?
>
> Do you have sourcecode for existing applications?
>
> Is the data in .dbf tables, .db tables or a SQL server?
>
> Are the errors caused by running existing programs?
>
> If existing code, is it written in XDML (the original dBASE for DOS
> commands) or OODML for Windows?
>
> Are the errors as a result of new code you are creating?
>
> I've never come across the End of table error.  The dBASE rowset class
> does, however, have an endOfSet property and isFirst() and isLast()
> methods which can be used to trap and ensure the error never occurs.
>
> dBASE does not accept spaces in field names in .dbf files whereas .db
> files do but you have checked this.  There is a way of dealing with this
> if it is the cause.
>
> Mervyn.
>
>
>
>
>