Re: Problem with a query

Stark wrote:
Three days I have been fighting with a query that shows a message "Type
mismatch". The query is the following:
SELECT * FROM "Africa.DBF" UNION ALL SELECT * FROM "Sunny Italy.DBF"

I confess I'am working with the BDE and with dBase files.
But the strange thing is that the following works perfectly:
SELECT * FROM "Africa.DBF" UNION ALL SELECT * FROM "Arabia.DBF"

All of the datasets have the same structure. Looking at the dataset content, I can't see anything abnormal. I can't think of anything causing the problem.
Do you have any suggestion ? What should I look at, which test I can perform, anything ?
Having spaces in the name perhaps?


http://webpages.charter.net/jamie_5";

.

Relevant Pages

  • Intermittent connection error (with workaround)
    ... I have a strange error when I try to connect to SqlServer from Bde ... Administrator on ... When I try to open a BDE alias which connects to the local SqlServer I ...
    (microsoft.public.sqlserver.connect)
  • Re: Can you commit a crime of omission ?
    ... The plot involved a girl who went missing in 1998. ... and eventually got him to confess to her ... didn't get round to interviewing all her college friends. ... It seems strange ...
    (uk.legal)
  • Re: XP sp2 & Dbase files
    ... > 1 program can open multiple temporary dbase files but if another program ... temporary directory or somewhere else. ... And of course, if BDE reports ... You'll probably have to make a simple, one Form test application, with ...
    (comp.lang.pascal.delphi.misc)
  • Re: Create link to dBase??
    ... I really would prefer not to use BDE. ... > Using linked server is one of the ways, and I will probably go with that. ... Then BDE links to the ... > dBase files. ...
    (microsoft.public.sqlserver.server)
  • Re: How to write GUI and event separately in wxPython??
    ... Marc 'BlackJack' Rintsch wrote: ... Not so strange really. ... The two xrange objects are different (though I confess I haven't looked to see how they implement comparisons), but iterating over them produces the same result. ...
    (comp.lang.python)