Re: [sqlite] Help with query

Fred, A query I can understand! This was my attempt, and worked to some degree, but yours is more workable and, I feel, more accurate "select NewsData.Postcode,NewsData.Address1,Agents.Code,Agents.Shopname,Agents.Addre ss1.Agents.Price from NewsData join Agents on NewsData.Postcode where NewsDat

[sqlite] Help with query

called Agents. If the above query is successful, I want it to include the columns called Code, Shopname, Address1 and Price, but only if the Shopname column in the Agents table matches either Shop1 or Shop2 in the NewsData table Can anyone help me with this? Regards, Brian Pugh

[sqlite] Changing a Field

Hi, I need to do a multiple search and replace on the same field in my database. Can anyone suggest a suitable bit of code for this? I have over 100,000 records, so any automation is very welcome! Thanks for any suggestions, Brian Pugh

[sqlite] Compiling

Hi, Does anyone know how to compile the source code with lcc-win32? It's not that I don't want to use the supplied dll - I just wanted to have a go at it myself! Thanks for any step-by-step information, Brian Pugh

[sqlite] Re: SQLite command line

Paul, Thanks very much for a clear explanation, and one which I could understand! Pity about the no-timing returns, but I suppose it's obvious that you should employ indexes wherever possible Now to test all my "selects" Thanks again, Brian

[sqlite] Network Performance

to improve the query speed over a network, I would love to hear them Thanks a lot, Brian Pugh Halifax, England

[sqlite] Indexes

s returned to view I have obviously got the wrong end of the stick about indexes! Could someone put me right, or point me gently in the right direction? Thanks, Brian Pugh

[sqlite] Re: Jump to record

Bronislav, Mrs Brisby and Derrell, Thanks a lot for your interest. It now remains for me to try your suggestions Thanks again, Brian

[sqlite] Jumping to a record

with an ID of 12345, how would it be possible to "jump" to that record, and still maintain my original select parameters and order? I guess that this is down to a select within a select, but I'm not sure how to go about it. Well, I'll qualify that - anything that I've tried hasn't worked yet! Thanks a lot, Brian Pugh, Halifax, England

[sqlite] Select from a Select

e? I see there is "create view" and it probably appears to be what I want, but I have no idea how to apply it, or make a "pre-packaged" select Any answers or suggestions would be most gratefully welcomed Thanks a lot, Brian Pugh

[sqlite] Select from Select

o code it Table is called NewsData; Postcode field is called Postcode; Telephone field is called Tel; Canvass field is called Canvass Many thanks for any help, Brian Pugh