Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query performance

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0

Hi,

I have Explorer v6.5.0.47 and I have an issue when I export or try using the
results in another query.

When I export the following name -

D'Apice (single quote)

it comes out as -

D"Apice (double quote)

Why?
Is it possible to fix that?

The second problem I have is that the data format will change when I process the results to the Table.
In the original table there are 3 fields with data type "Real" with the length at 8.
When my results are processed to the local table those 3 fields are converted Real with the length at 15.
So now I can no longer use those fields for joins which is a big issue because they are the master keys to other tables.

Any ideas are greatly appreciated.
Don
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top