Re: "Data type mismatch" error on FoxPro "Select tablealias" Command

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Is there a relation set somewhere? Check data types in the involved columns.
Perhaps nulls are causing the problem.

Reindexing wouldn't hurt either.



"Rex Knepp" <RexKnepp@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E6FE7CE1-9922-49A0-A9C6-DDEACEF39E7A@xxxxxxxxxxxxxxxx
Hello and thanks in advance for any help you can provide on this problem.
We
have a large FoxPro 9 SP2 project that has started receiving "Data type
mismatch" errors on several different "Select tablealias" statements
within
the same procedure. This procedure is used frequently throughout the day,
but the error generally only occurrs once every several days. Once the
user
has seen the error, they can reprocess the same data and the program works
correctly as designed. The error has occurred on three different "Select"
statements involving three different aliases. I have captured "Show
Status"
and "Show Memory" information from an "On Error" routine and everything
looks
to me like it should. The table aliases are listed and the correct index
is
marked as "master" in the "Show Status" output. I have reviewed the
memory
variables as reported in "Show Memory" and I do not see anything out of
place. My questing is why would you get a "Data type mismatch" on a
"Select
tablealias" statement? I am using the actual alias name with the Select -
there are no variables involved. Has anyone had similar experiences? Any
ideas of where I should go from here?


.

Relevant Pages

  • Re: define a data type of 1 bit size
    ... > Is there any way I can define a data type that uses only 1 bit. ... even int is fine - just use zero for 0 and non-zero for 1. ... perhaps get better performance by using an unsigned type such as unsigned ... typically more useful in these embedded environments where memory may be ...
    (comp.lang.c)
  • Re: memory pool library (repost)
    ... It does seem simple enough for what I want to do - but I am also very wary about mucking around with memory for two reasons: ... This is why I need a memory pool/allocator which starts with a pool of previously allocated doubles (although I'd prefer to make the library generic enough that any data type can be stored in it, - specified at initialization, i.e. a Simple Segregated Storage). ... I would make the allocator a templated factory pattern. ...
    (comp.lang.c)
  • Re: Differance between Array and Pointers
    ... pointer - an integer that holds the address of some data type ... Address - a value which indicates a location in memory. ... Pointer - a location in memory which contains an address. ... Array - one of many data types which can reside in memory. ...
    (comp.arch.embedded)
  • Re: Out of memory
    ... error can't change the data type. ... requires that the ENTIRE TABLE be loaded into memory... ... use the Jet Engine anymore. ... The literature you read is in error. ...
    (microsoft.public.access.gettingstarted)
  • Re: Java Future
    ... That would include how each data type is handled, ... (a good book on modern computer systems/processors is "Computer Organization And Design" ... a common assumption by many programmers today is that memory usage does not matter any more, ... But if you have some knowledge of how computers work you would understand that a given algorithm processing a large amount of data could perform significantly better if it took into account actual usage of data types on the processor, memory alignment, level 1/2/3 caches, superpipelining etc and how that can affect the efficiency of a solution. ...
    (comp.lang.java.programmer)