Search results for query: *

I don’t mind the fact that the files are indexed, just that it is causing problems when I link to the database from Access – basically, I need to get all the data out of the tables, and this is the only way I’ve managed it so far. Unfortunately, it’s the application itself which rebuilds the...

I see… I’ll try the FoxPro people. But thanks anyway, it does sound like you were onto something. Phydos

Just checked the index files – the extensions are CDX, couldn’t find any flags when I opened them with notepad, just some unusual characters “ à P”, same kind of thing in the DBF file “ q â ” What I do at the moment is delete all the CDX files, open the DBF files in another application...

One in dBase, and one in visual dbase (hoping that there would be some pre-compiled exe to do the job of detaching the indexes), and one in Access forum (maybe someone has had the same problem in the past). Thanks for your reply in each – I’m looking into it now, but not exactly sure what you...

It's either version 4 or 5 - it's actually a DOS application with dBase files.

I currently link to dBase (the dos version) tables using MS-Access, however, I need to disconnect the dBase indexes before doing this (using dBStructure as I don’t have a licensed copy of dBase). Is there a way to remove the index and disconnect them using either VBA or Access (or any other...

I currently link to dBase tables using MS-Access, however, I need to disconnect the dBase indexes before doing this (using dBStructure as I don’t have a licensed copy of dBase). Is there a way to remove the index and disconnect them using either VBA or Access (or any other method)? Thank you...

I currently link to dBase tables using MS-Access, however, I need to disconnect the dBase indexes before doing this (using dBStructure as I don’t have a licensed copy of dBase). Is there a way to remove the index and disconnect them using either VBA or Access (or any other method)? Thank you...

Thanks; I decided to write 50 artists at a time to an array, then use writeline to insert them (50 on each line) into the html file. It works well now, and the files are optimised quite nicely - very small considering the amount of information in them. We have hundreds of thousands of CDs...

I've developed a procedure to export our products (CDs/DVDs..) to html files using .writeline(recordset(&quot;Artist_Name&quot;). However, I would like to optimise the html files by removing the 'new lines' i.e. change: BLINKIT<br> BLISZ<br> BLIT<br> BLONDES<br> BLONDIE<br> to...

We don’t have Full Text Indexing on our server, so have chosen to use IMPTechnology for the search on our Music store www.phydos.com. It does allow for very fast searching, but the strain on the server is high while indexing (it’s overloaded a couple of times – and tends to take a few hours)...

Thanks, that was helpful. I've now changed all my upload tasks to stored procedures. Best regards, Phydos

I have a number of SQL Update, Insert and Delete queries setup which I run as a batch in Query Analyser, is there a simple way that I could create a single Stored Procedure to run these, rather than create specific Delete...etc Stored Procedures? Regards, Phydos

Thanks for all the advice, I’ve tried out a few techniques, and the one below seems to work quite well (although I may need to speed it up a little as there are close to a million records, and indexes wont work as we are just using keywords within a field). SELECT *, Name AS Artist FROM...

Thanks for the reply SQLBill. It seems this would work okay (LIKE N'%[^A-Z]Enya[^A-Z]%'), only there is the problem of not being able to identify the beginning and end of field (to allow), as it is ignoring Enya if it is the only word in the field (i.e. nothing before or after) or if it is the...

I have an ASP - SQL query (for a music/media webpage) which searches for keyword, the problem the site has is that it returns words within words, for example; search for Enya, and it returns Kenya (and lots of them). The search uses &quot;LIKE '%Enya%'&quot;. Is there any way of specifying that...