I agree with AJ Ahrens - it should recreate the log file if none exists.

Can you post the full device 'activation error' message?

Regards

But aren't your customers in tblPaxList?  When you create the ServiceRefNo self join on tblPaxList, the returned recordset will be larger than required because ServiceRefNo is not unique on tblPaxList...

Sorry to mess you about, but this is tough to crack without also seeing the base data.  As you've already identified, you're getting too many results as a consequence of...

What error message do you get?

I am sure that this can be achieved without the need for the query you originally requested.

Can you post sample details showing the query you are running, the output you...

This sounds like an unusual way to do things.  Can you go into more detail about what you will be using the resultset for and perhaps we will find another, more...

So

select product, city

from product_cities

where city = 'boston' or city = 'chicago' or city = 'denver'

is not what you want?  (I know you're using IDs, but the theory's the same)...

So you got it right then?

Sorry - I meant for you to replace 'fieldlist' with your list of fields to be selected.  Fieldlist is not a keyword

select distinct

will return unique rows, at field-by-field level.  If any of the fields in the rows are different, the row will be returned.  Therefore the fewer fields you return,...

Aha - never had to work with huge text fields - over to someone else!

Yup, I was talking twaddle once again.

Best go home and swat up

Phil

Prob not the dept table, as that is not included in the section of your code which is causing you problems.  Update: there is no dept table - you...

Please post some sample data (just the relevant fields will do) and datatype/size of text fields.  No need for full text indexing.

Regards

Remi is right.  What is your objective?  It is easy to write a SELECT query to display the data how you want.  Or you can create a permanent VIEW of...